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