public JObject GetReceivers(string userId) { JObject ret = new JObject(); using (oasEntities entity = new oasEntities()) { //1.根据当前登录人找到所有的权限集合。(送的时候只能送虚拟账号) List <dynamic> roles = entity.UP_GetUserRole(userId, "0001").ToList <dynamic>(); //2.根据权限找到虚拟账号集合。(虚拟账号就在权限表里面,所以直接取。) //List<dynamic> users = GetAllUsersByRoles(roles); return(Core.Common.PackageJObect(roles.Count > 0, roles, null)); } }
/// <summary> /// 根据集合权限获取集合虚拟账号 /// </summary> /// <param name="roles"></param> /// <returns></returns> public List <dynamic> GetAllUsersByRoles(List <dynamic> roles) { List <dynamic> dy = new List <dynamic>(); using (oasEntities entity = new oasEntities()) { //找出所有的虚拟账号,跟权限对应是一对一关系。 //List<string> roleparams = new List<string>(); string roleparams = string.Empty; foreach (var item in roles) { roleparams += "," + item.ROLESERIAL; } List <dynamic> rolserial = entity.T_Pub_Role.Select(c => new { c.RoleSerial }).Where(c => roleparams.Contains(c.RoleSerial)).ToList <dynamic>(); return(rolserial); } }
public JObject RolesGetTrees(string id) { using (oasEntities bay = new oasEntities()) { JObject result = new JObject(); var list = bay.UP_GetUserAllRole(id).ToList(); var ret = list.Select(c => new { Role_Value = c.ROLE_VALUE, state = true }); if (list == null) { result.Add(ResultInfo.Result, JProperty.FromObject(false)); result.Add(ResultInfo.Content, JProperty.FromObject("没有数据")); } else { result.Add(ResultInfo.Result, JProperty.FromObject(true)); result.Add(ResultInfo.Content, JProperty.FromObject(ret)); } return(result); } }
/// <summary> /// 获取导航菜单列表 /// </summary> /// <param name="menuId">默认状态0</param> /// <param name="currentUser">用户信息</param> /// <returns></returns> public ConcurrentDictionary <string, string> GetClientsDataJson(int menuId, CurrentLogin currentUser) { //SqlParameter[] prams = new SqlParameter[3]; //prams[0] = new SqlParameter("@MODULE_ID", 0001); //prams[1] = new SqlParameter("@USERID", currentUser.UserName); //prams[2] = new SqlParameter("@SysFlag", "GLXT"); //var ss = DBFactory.oas; using (oasEntities entity = new oasEntities()) { var list = entity.UP_GetUserMenu("0001", currentUser.User_Id, "GLXT").ToList(); var menuList = new List <MenuModel>(); foreach (var item in list.Where(it => it.ParentID == menuId)) { var menuModel = new MenuModel(); menuModel.Id = item.MenuID; menuModel.Name = item.MenuName; menuModel.SortCode = (int)item.SortID; menuModel.ChildNodes = list.Where(c => c.ParentID == item.MenuID) .Select( c => new ChildNodes { Id = c.MenuID, Name = c.MenuName, UrlAddress = c.Url, SortCode = (int)c.SortID }) .OrderBy(c => c.SortCode).ToList(); menuList.Add(menuModel); } menuList = menuList.OrderBy(c => c.SortCode).ToList(); var info = new ConcurrentDictionary <string, string>(); info.TryAdd("authorizeMenu", menuList.ToJson()); return(info); } }