Master.CanYinWu.DAL/PermissionDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Dapper;
using Master.CanYinWu.Entity;
using Master.CanYinWu.Utility;

namespace Master.CanYinWu.DAL
{
    public class PermissionDAL
    {
        /// <summary>
        /// 把当前用户所有的特殊权限查询出来(待删除)
        /// </summary
        /// <param name="adminId"></param>
        /// <returns></returns>
        public async Task<List<Permission>> Getlist(int adminId)
        {
            string sql = @"select  *  from Permission  where IsDelete=0 and adminid=@AdminId";
            using (var conn = ConnectionFactory.Connection())
            {
                return (await conn.QueryAsync<Permission>(sql, new { AdminId = adminId })).ToList();
            }
        }
        /// <summary>
        /// 根据角色得到已有的权限集合
        /// </summary>
        /// <param name="roleId"></param>
        /// <returns></returns>
        public async Task<IEnumerable<Permission>> GetExistPermissionlistByRoleIdAsync(int roleId)
        {
            string sql = @"select  *  from Permission  where IsDelete=0 and RoleId=@RoleId";
            using (var conn = ConnectionFactory.Connection())
            {
                return (await conn.QueryAsync<Permission>(sql, new { RoleId = roleId }));
            }
        }


        /// <summary>
        ///  根据角色和菜单地址，获取菜单
        /// </summary>
        /// <param name="roleId"></param>
        /// <param name="menuPath"></param>
        /// <returns></returns>
        public Menu GetMenuByRoleId(int roleId,string menuPath)
        {
            string sql = @"select menuUrl  from  Permission 
                           left join  Menu 
                           on Permission.menuid=menu.menuid
                           where  roleid=@Roleid and  ispass=@Ispass and  Permission.isdelete=@IsDelete and menuUrl in ('"+ menuPath + "')";
            using (var conn = ConnectionFactory.Connection())
            {
                return (conn.QueryFirstOrDefault<Menu>(sql, new { RoleId = roleId, Ispass=1, IsDelete=0 }));
            }
        }