public PagerList <User> Query(UserQuery query)
{
if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序
{
query.Order = "Id desc";
}
query.TotalCount = UserRepository.GetAllFilterDataPermissions().Count();
IQueryable <User> users = GetQueryConditions(UserRepository.GetAllFilterDataPermissions(), query) //where查询条件必须放在排序和分页前，不然生成SQL有BUG
.OrderByIfOrderNullOrEmpty(query.Order)
.Skip(query.GetSkipCount())
.Take(query.PageSize);
var result = new PagerList <User>(query);
result.AddRange(users.ToList());
return(result);
}
//[DisableFiltersAttribute(FiltersEnum.SoftDelete)] //示范：关闭数据过滤器(参数为过滤器名称列表)
public PagerList <UserDto> Query(UserQuery query)
{
//todo：easyui组件的ajax请求异常，暂时无法拦截
//throw new Exception("用户查询异常，easyui ajax操作全局异常测试");
if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序
{
query.Order = "Id desc";
}
query.TotalCount = _userRepository.GetAllFilterDataPermissions().Count();
IQueryable <User> users = GetQueryConditions(_userRepository.GetAllFilterDataPermissions(), query) //where查询条件必须放在排序和分页前，不然生成SQL有BUG
.OrderByIfOrderNullOrEmpty(query.Order)
.Skip(query.GetSkipCount())
.Take(query.PageSize);
var result = new PagerList <User>(query);
result.AddRange(users.ToList());
return(result.Convert(p => p.ToDto()));
}
