/// <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());
}
