namespace Admin.NET.Core.Service; /// /// 系统角色菜单服务 /// public class SysRoleMenuService : ITransient { private readonly SqlSugarRepository _sysRoleMenuRep; private readonly ISysCacheService _sysCacheService; public SysRoleMenuService(SqlSugarRepository sysRoleMenuRep, ISysCacheService sysCacheService) { _sysRoleMenuRep = sysRoleMenuRep; _sysCacheService = sysCacheService; } /// /// 根据角色Id集合获取菜单Id集合 /// /// /// public async Task> GetRoleMenuIdList(List roleIdList) { return await _sysRoleMenuRep.AsQueryable() .Where(u => roleIdList.Contains(u.RoleId)) .Select(u => u.MenuId).ToListAsync(); } /// /// 根据角色Id集合获取菜单树 /// /// /// public async Task> GetRoleMenu(List roleIdList) { var menuIdList = await _sysRoleMenuRep.AsQueryable() .Where(u => roleIdList.Contains(u.RoleId)) .Select(u => u.MenuId).ToListAsync(); return await _sysRoleMenuRep.ChangeRepository>().AsQueryable() .Where(u => menuIdList.Contains(u.Id)) .ToTreeAsync(u => u.Children, u => u.Pid, 0); } /// /// 授权角色菜单 /// /// /// [SqlSugarUnitOfWork] public async Task GrantRoleMenu(RoleMenuInput input) { await _sysRoleMenuRep.DeleteAsync(u => u.RoleId == input.Id); var menus = input.MenuIdList.Select(u => new SysRoleMenu { RoleId = input.Id, MenuId = u }).ToList(); await _sysRoleMenuRep.InsertRangeAsync(menus); // 清除缓存 await _sysCacheService.DelByPatternAsync(CacheConst.KeyMenu); await _sysCacheService.DelByPatternAsync(CacheConst.KeyPermission); } /// /// 根据菜单Id集合删除角色菜单 /// /// /// public async Task DeleteRoleMenuByMenuIdList(List menuIdList) { await _sysRoleMenuRep.DeleteAsync(u => menuIdList.Contains(u.MenuId)); } /// /// 根据角色Id删除角色菜单 /// /// /// public async Task DeleteRoleMenuByRoleId(long roleId) { await _sysRoleMenuRep.DeleteAsync(u => u.RoleId == roleId); } }