using SqlSugar; using System; using System.Collections.Concurrent; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using WIDESEAWCS_Core; using WIDESEAWCS_Core.BaseRepository; using WIDESEAWCS_Core.Helper; using WIDESEAWCS_ISystemRepository; using WIDESEAWCS_Model; using WIDESEAWCS_Model.Models; namespace WIDESEAWCS_SystemRepository { public class Sys_MenuRepository : RepositoryBase<Sys_Menu>, ISys_MenuRepository { public Sys_MenuRepository(IUnitOfWorkManage unitOfWorkManage) : base(unitOfWorkManage) { } public List<Sys_Menu> GetAllMenu() { List<Sys_Menu> _menus = base.QueryData(x => x.Enable == 1 || x.Enable == 2).OrderByDescending(a => a.OrderNo).ThenByDescending(q => q.ParentId).ToList(); _menus.ForEach(x => { x.MenuType ??= 0; if (!string.IsNullOrEmpty(x.Auth) && x.Auth.Length > 10) { try { x.Actions = x.Auth.DeserializeObject<List<Sys_Actions>>(); } catch { } } x.Actions ??= new List<Sys_Actions>(); }); string test = _menus.Serialize(); return _menus; } public object GetSuperAdminMenu() { return GetAllMenu().Select(x => new { id = x.MenuId, name = x.MenuName, url = x.Url, parentId = x.ParentId, icon = x.Icon, x.Enable, x.TableName, // 2022.03.26å¢žç§»åŠ¨ç«¯åŠ èœå•类型 permission = x.Actions.Select(s => s.Value).ToArray() }).ToList(); } public object GetMenuByRoleId(int roleId) { var menu = from a in GetPermissions(roleId) join b in GetAllMenu() on a.MenuId equals b.MenuId orderby b.OrderNo descending select new { id = a.MenuId, name = b.MenuName, url = b.Url, parentId = b.ParentId, icon = b.Icon, b.Enable, b.TableName, permission = a.UserAuthArr }; return menu.ToList(); } /// <summary> /// 获å–角色æƒé™æ—¶é€šè¿‡å®‰å…¨å—å…¸é”定的角色id /// </summary> private static ConcurrentDictionary<string, object> objKeyValue = new ConcurrentDictionary<string, object>(); public List<Permissions> GetPermissions(int roleId) { if (App.User.IsRoleIdSuperAdmin(roleId)) { //2020.12.27å¢žåŠ èœå•界é¢ä¸Šä¸æ˜¾ç¤ºï¼Œä½†å¯ä»¥åˆ†é…æƒé™ var permissions = QueryData(x => x.Enable == 1 || x.Enable == 2) .Select(a => new Permissions { MenuId = a.MenuId, ParentId = a.ParentId, TableName = (a.TableName ?? "").ToLower(), UserAuth = a.Auth, MenuType = a.MenuType ?? 0 }).ToList(); return MenuActionToArray(permissions); } //é”定æ¯ä¸ªè§’色,通过安全å—å…¸å‡å°‘é”粒度,å¦åˆ™å¤šä¸ªåŒæ—¶è§’色获å–缓å˜ä¼šå¯¼è‡´é˜»å¡ž object objId = objKeyValue.GetOrAdd(roleId.ToString(), new object()); //é”定æ¯ä¸ªè§’色 lock (objId) { //没有redis/memory缓å˜è§’è‰²çš„ç‰ˆæœ¬å·æˆ–ä¸Žå½“å‰æœåŠ¡å™¨çš„è§’è‰²ç‰ˆæœ¬å·ä¸åŒæ—¶ï¼Œåˆ·æ–°ç¼“å˜ List<Permissions> _permissions = QueryTabs<Sys_Menu, Sys_RoleAuth, Permissions>((a, b) => new object[] { JoinType.Inner, a.MenuId == b.MenuId }, (a, b) => new Permissions { MenuId = a.MenuId, ParentId = a.ParentId, TableName = (a.TableName ?? "").ToLower(), MenuAuth = a.Auth, UserAuth = b.AuthValue ?? "", MenuType = a.MenuType ?? 0 }, (a, b) => b.RoleId == roleId, x => true); ActionToArray(_permissions); return _permissions; } } private List<Permissions> MenuActionToArray(List<Permissions> permissions) { permissions.ForEach(x => { try { x.UserAuthArr = string.IsNullOrEmpty(x.UserAuth) ? new string[0] : x.UserAuth.DeserializeObject<List<Sys_Actions>>().Select(s => s.Value).ToArray(); } catch { } finally { if (x.UserAuthArr == null) { x.UserAuthArr = new string[0]; } } }); return permissions; } private List<Permissions> ActionToArray(List<Permissions> permissions) { permissions.ForEach(x => { try { var menuAuthArr = x.MenuAuth.DeserializeObject<List<Sys_Actions>>(); x.UserAuthArr = string.IsNullOrEmpty(x.UserAuth) ? new string[0] : x.UserAuth.Split(",").Where(c => menuAuthArr.Any(m => m.Value == c)).ToArray(); } catch { } finally { if (x.UserAuthArr == null) { x.UserAuthArr = new string[0]; } } }); return permissions; } public object GetMenu(List<int> menuIds) { return QueryData(x => menuIds.Contains(x.MenuId)).Select(a => new { id = a.MenuId, parentId = a.ParentId, name = a.MenuName, a.MenuType, a.OrderNo }).OrderByDescending(a => a.OrderNo) .ThenByDescending(q => q.parentId).ToList(); } public object GetTreeItem(int menuId) { var sysMenu = base.QueryData(x => x.MenuId == menuId) .Select( p => new { p.MenuId, p.ParentId, p.MenuName, p.Url, p.Auth, p.OrderNo, p.Icon, p.Enable, // 2022.03.26å¢žç§»åŠ¨ç«¯åŠ èœå•类型 MenuType = p.MenuType ?? 0, p.CreateDate, p.Creater, p.TableName, p.ModifyDate }).FirstOrDefault(); return sysMenu; } } }