vboot框架后台动态获取权限

///

///
public async Task> GetMenuList(string userid, int admintype)
{
List rootList = await GetRootList(userid, admintype);
List routeList = await GetRouteList(userid, admintype);
List treelist = GetMenuTreeList(routeList, rootList);
return treelist;
}
///

///

///
public async Taskstring>> GetPermCode(string userid, int admintype)
{
List<string> perm = new List<string>();
string sql;
if (admintype == (int)AdminType.SuperAdmin)
{
sql = $@"SELECT perm
FROM sys_auth_menu
WHERE `type`='B'";
}
else
{
sql = $@"SELECT perm
FROM sys_auth_menu
WHERE `type`='B' AND shtag=1 AND avtag=1 AND id IN
(
SELECT `mid`
FROM sys_auth_role_menu a
LEFT JOIN sys_auth_role_org b ON b.rid=a.rid
WHERE b.oid='{userid}'
)";
}
List menulist = await _repo.Context.SqlQueryable(sql).ToListAsync();
for (int i = 0; i )
{
perm.Add(menulist[i].perm);
}
return perm;
}
///

///

///
private async Task> GetRouteList(string userid, int admintype)
{
string sql;
if (admintype == (int)AdminType.SuperAdmin)
{
sql = $@"SELECT id,pid,ornum,`name`,icon,path,comp,`code`,redirect
FROM sys_auth_menu
where `type`!='B'
ORDER BY ornum";
}
else
{
sql = $@"SELECT id,pid,ornum,`name`,icon,path,comp,`code`,redirect
FROM sys_auth_menu
WHERE `type`!='B' AND shtag=1 AND avtag=1 and id IN
(
SELECT a.mid
FROM sys_auth_role_menu a
LEFT JOIN sys_auth_role b ON b.id=a.rid
LEFT JOIN sys_auth_role_org c ON c.rid=b.id
WHERE c.oid='{userid}'
)
ORDER BY ornum";
}
List routelist = await ToWebmenuList(sql);
return routelist;
}
///

///

///
private async Task> GetRootList(string userid, int admintype)
{
string sql;
if (admintype == (int)AdminType.SuperAdmin)
{
sql = $@"SELECT id,pid,ornum,`name`,icon,path,comp,`code`,redirect
FROM sys_auth_menu
WHERE isnull(pid)=true and `type`!='B'
ORDER BY ornum";
}
else
{
sql = $@"SELECT id,pid,ornum,`name`,icon,path,comp,`code`,redirect
FROM sys_auth_menu
WHERE id IN
(
SELECT pid
FROM
(
SELECT id,pid,ornum,`name`,icon,path,comp,`code`,redirect
FROM sys_auth_menu
WHERE `type`!='B' AND shtag=1 AND avtag=1 and id IN
(
SELECT a.mid
FROM sys_auth_role_menu a
LEFT JOIN sys_auth_role b ON b.id=a.rid
LEFT JOIN sys_auth_role_org c ON c.rid=b.id
WHERE c.oid='{userid}'
)
) a
)
AND id NOT IN
(
SELECT id
FROM
(
SELECT id,pid,ornum,`name`,icon,path,comp,`code`,redirect
FROM sys_auth_menu
WHERE `type`!='B' AND shtag=1 AND avtag=1 and id IN
(
SELECT a.mid
FROM sys_auth_role_menu a
LEFT JOIN sys_auth_role b ON b.id=a.rid
LEFT JOIN sys_auth_role_org c ON c.rid=b.id
WHERE c.oid='{userid}'
)
) b
)
ORDER BY ornum";
}
List rootlist = await ToWebmenuList(sql);
return rootlist;
}
///

///
private async Task> ToWebmenuList(string sql)
{
List list = new List();
var menulist = await _repo.Context
.SqlQueryable(sql)
.ToListAsync();
for (int i = 0; i )
{
RouteMeta meta = new RouteMeta();
meta.orderNo = menulist[i].ornum;
meta.icon = menulist[i].icon;
meta.title = menulist[i].name;
RouteItem item = new RouteItem();
item.id = menulist[i].id;
item.pid = menulist[i].pid;
item.path = menulist[i].path;
item.component = menulist[i].comp;
//item.compOnent= "/sys/auth/role/index";
item.name = menulist[i].code;
item.redirect = menulist[i].redirect;
item.meta = meta;
item.children = new List();
list.Add(item);
}
return list;
}
///

///

///
private List GetMenuTreeList(List menulist, List rootlist)
{
if (menulist == null)
{
menulist = new List();
}
List treelist = new List();
treelist.AddRange(rootlist);
GetChildrenList(menulist, rootlist);
return treelist;
}
///

///

private void GetChildrenList(List menulist, List plist)
{
foreach (RouteItem item in plist)
{
List childrenlist = menulist.Where(p => p.pid == item.id).ToList();
item.children.AddRange(childrenlist);
GetChildrenList(menulist, childrenlist);
}
}
}
public class RouteMeta
{
public int? orderNo { get; set; }
// title
public string title { get; set; }
//// dynamic router level.
//public int? dynamicLevel{get;set;}
//// dynamic router real route path (For performance).
//public string realPath{get;set;}
//// Whether to ignore permissions
//public bool? ignoreAuth{get;set;}
//// role info RoleEnum[]
//public object roles { get; set; }
//// Whether not to cache
//ignoreKeepAlive?: boolean;
//// Is it fixed on tab
//affix?: boolean;
//icon on tab
public string icon { get; set; }
//frameSrc?: string;
//// current page transition
//transitionName?: string;
//// Whether the route has been dynamically added
//hideBreadcrumb?: boolean;
//// Hide submenu
//hideChildrenInMenu?: boolean;
//// Carrying parameters
//carryParam?: boolean;
//// Used internally to mark single-level menus
//single?: boolean;
//// Currently active menu
//currentActiveMenu?: string;
//// Never show in tab
//hideTab?: boolean;
//// Never show in menu
//hideMenu?: boolean;
//isLink?: boolean;
//// only build for Menu
//ignoreRoute?: boolean;
//// Hide path for children
//hidePathForChildren?: boolean;
}
public class RouteItem
{
public string id { get; set; }
public string pid { get; set; }
public string path { get; set; }
// component: any;
public object component { get; set; }
public RouteMeta meta { get; set; }
public string name { get; set; }
//alias?: string | string[];
public string redirect { get; set; }
//public bool? caseSensitive{get;set;}
public List children { get; set; }
}
}

LoginService.cs

三、前端vboot-vben

1、projectSetting.ts 权限模式改为 BACK 模式

// Permission mode
//permissionMode: PermissionModeEnum.ROUTE_MAPPING,
permissionMode: PermissionModeEnum.BACK,

2、BACK模式下默认访问views路径不是pages路径，所以要把pages下相应的目录及文件要拷贝到views下，如下图所示：

3、前端按钮权限的实现 v-auth="'权限标识'"

"'dept:delete'" @click="deleteEvent($refs.xGrid)">删 除

到此，用户的菜单权限、按钮权限基本就完成了，亲测可用