/// <summary> /// 构造前台传递的查询条件 /// </summary> /// <param name="queryable"></param> /// <param name="query"></param> /// <returns></returns> private IQueryable<Role> GetQueryConditions(IQueryable<Role> queryable, RoleQuery query) { if (!string.IsNullOrWhiteSpace(query.Name)) queryable = queryable.Where(p => p.Name.Contains(query.Name)); if (query.Enabled != null) queryable = queryable.Where(p => p.Enabled == query.Enabled); if (query.IsAdmin != null) queryable = queryable.Where(p => p.IsAdmin == query.IsAdmin); return queryable; }
public PagerList<Role> Query(RoleQuery query) { if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序 query.Order = "Id desc"; query.TotalCount = RoleRepository.GetAll().Count(); IQueryable<Role> roles = GetQueryConditions(RoleRepository.GetAll(), query) //where查询条件必须放在排序和分页前,不然生成SQL有BUG .OrderByIfOrderNullOrEmpty(query.Order) .Skip(query.GetSkipCount()) .Take(query.PageSize); var result = new PagerList<Role>(query); result.AddRange(roles.ToList()); return result; }
public PagerList<RoleDto> Query(RoleQuery query, Guid userId) { return RoleDomainService.Query(query).Convert(item => item.ToDto(userId)); }
public PagerList<RoleDto> Query(RoleQuery query) { return RoleDomainService.Query(query).Convert(p =>p.MapTo<RoleDto>()); }
public PagerList<RoleDto> Query(RoleQuery query, Guid userId) { return PagerList(query).Convert(item => item.ToDto(userId)); }
public PagerList<RoleDto> Query(RoleQuery query) { return PagerList(query).Convert(p => p.MapTo<RoleDto>()); }
/// <summary> ///获取分页的角色列表,以及查询的用户id的所有角色选中状态 /// </summary> /// <param name="query"></param> /// <param name="userId"></param> /// <returns></returns> public ActionResult QueryByUser(RoleQuery query, Guid userId) { SetPage(query); var result = _roleService.Query(query, userId).Convert(p => p.ToGridVm()); return ToDataGridResult(result, result.TotalCount); }