/// <summary> /// 获取用户对应的角色列表 /// </summary> /// <param name="userName">用户名</param> /// <returns></returns> public IQueryable <RoleDb> GetRoleDbList(string userName) { IQueryable <int> roleIds = PermissionDal.Set <AdminUserRoleRelationDb>().Where(c => c.user_name == userName).Select(c => c.role_id); return(PermissionDal.Where(c => roleIds.Contains(c.role_id))); }
/// <summary> /// 获取用户对应的有权限的活动的模块 /// </summary> /// <param name="userName">用户名</param> /// <returns></returns> public IQueryable <ModuleDb> GetModuleList(string userName) { IQueryable <int> roleIds = RoleBll.Instance.GetRoleDbList(userName).Select(c => c.role_id); IQueryable <string> moduleCodes = PermissionDal.Set <RoleModuleRelationDb>() .Where(c => roleIds.Contains(c.role_id)).Select(c => c.module_code); return(PermissionDal.Where(c => moduleCodes.Contains(c.module_code) && c.module_status == (int)Model.Common.GlobalCode.CommonStatus.Active) .OrderBy(c => c.order_by)); }
/// <summary> /// 获取指定类别key下面的有效字典 /// </summary> /// <param name="dtTypeKey"></param> /// <returns></returns> public List <DictionaryTableDb> GetListInDtType(string dtTypeKey) { return(PermissionDal.Where(c => c.dt_type_key == dtTypeKey && c.dt_status == (int)CommonStatus.Active).OrderBy(c => c.dt_orderby).ToList()); }
public List <RoleDb> GetRoleListAll() { return(PermissionDal.Where(c => true).ToList()); }