/// <summary> /// 加载菜单信息 /// </summary> /// <param name="StrUserId">根据用户id</param> /// <param name="ParentMenuId">父类id</param> /// <returns></returns> public List <Base_MenuInfo> GetLeftMenu(string StrUserId, string ParentMenuId) { StringBuilder StrRightMenu = new StringBuilder(); //当前人所有的角色 //var oneUserMenus = from u in base_UserInfoService.LoadEntities(u => true) // join m in base_UserMenuInfoService.LoadEntities(um => true) on u.Id equals m.UserId // where u.Id == StrUserId // select m; var oneUserMenus = (from ur in base_UserRoleInfoService.LoadEntities(ur => true) join rm in base_RoleMenuInfoService.LoadEntities(rm => true) on ur.RoleId equals rm.RoleId where ur.UserId == StrUserId select new { rm.MenuId }).Distinct(); //找所有的菜单信息 var tempMenuRes = from m in this.LoadEntities(m => m.DelFlag == 0) join mid in oneUserMenus on m.Id equals mid.MenuId select m; if (!string.IsNullOrEmpty(ParentMenuId)) { tempMenuRes = tempMenuRes.Where(m => m.ParentId == ParentMenuId); } else { tempMenuRes = tempMenuRes.Where(m => m.ParentId == null); } tempMenuRes = tempMenuRes.OrderBy(m => m.OrderBy); if (tempMenuRes == null) { return(new List <Base_MenuInfo>()); } return(tempMenuRes.ToList()); }
/// <summary> /// 登录时,获取指定人员信息 /// </summary> /// <param name="base_UserInfo"></param> /// <returns></returns> public Base_UserInfo Login(Base_UserInfo base_UserInfo) { var temp = this.LoadEntities(u => u.UserName == base_UserInfo.UserName && u.UserPwd == base_UserInfo.UserPwd && u.DelFlag == 0).FirstOrDefault(); if (temp == null) { return(null); } Base_UserRoleInfoService base_UserRoleInfoService = new Base_UserRoleInfoService(); Base_RolesInfoService base_RolesInfoService = new Base_RolesInfoService(); var curPerRoles = from ur in base_UserRoleInfoService.LoadEntities(ur => true) join r in base_RolesInfoService.LoadEntities(r => r.DelFlag == 0) on ur.RoleId equals r.Id where ur.UserId == temp.Id select r; if (curPerRoles != null) { temp.RoleList = curPerRoles.ToList(); } else { temp.RoleList = new List <Base_RolesInfo>(); } return(temp); }