版本初建

bklLiudl

2025-04-07 4e8f58cb41c7b6d570fd1979d80f74ab8a4d00c2

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
using System;
using System.Collections.Generic;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using WMS.Entity;
using WMS.Entity.Context;
using WMS.IDAL;
using WMS.IDAL.ISysInterface;
 
namespace WMS.DAL.SysInfrastructure
{
    /// <summary>
    /// RBAC仓储实践
    /// </summary>
    public class RBACRepository : IRBACRepository
    {
        private static readonly SqlSugarScope Db = DataContext.Db;
        public RBACRepository()
        {
        }
 
        /// <summary>
        /// 获取rbac信息列表
        /// </summary>
        /// <returns></returns>
        public async Task<List<RBAC>> GetRBACLists(int roleid)
        {
            string str = "select userinfo.UserNo,userinfo.UserName,userinfo.RealName,userinfo.Status,userinfo.Sex,userinfo.Nationality,userinfo.Paper,userinfo.Phone,userinfo.Email,userinfo.Addres,userinfo.LoginTime,userinfo.SetPasswordTime,role.RoleNo,role.RoleName,menu.MenuNo,menu.MenuName,menu.ParentNo,menu.Ord,menu.Url,menu.level from SysUserInfor userinfo join SysRoles role on userinfo.RoleNo = role.RoleNo join SysRoleRight roleright on roleright.RoleNo = role.RoleNo join SysFunctionMenu menu on roleright.MenuNo = menu.MenuNo";
            List<RBAC> rbaclist = new List<RBAC>();
            if (roleid != 0)
            {
                str += " where role.Id = @id";
                rbaclist = await Db.Ado.SqlQueryAsync<RBAC>(str, new
                {
                    id = roleid //角色id
                });
            }
            else
            {
                rbaclist = await Db.Ado.SqlQueryAsync<RBAC>(str);
            }
            return rbaclist;
        }
 
    }
}