/// <summary> /// 分页查询 /// </summary> /// <param name="dto"></param> /// <returns></returns> public PublicResult <PagedList <QueryRoleItem> > PagedQueryRoles(PagedQueryRoleDto dto) { var page = dto.Page ?? 1; var pageSize = dto.PageSize ?? 20; using (var client = DbFactory.CreateClient()) { var total = 0; var list = client.Queryable <Role>() .WhereIF(!string.IsNullOrEmpty(dto.Keyword), t => t.Name.Contains(dto.Keyword)) .Select(t => new QueryRoleItem() { Id = t.Id, Name = t.Name, IsActive = t.IsActive, Code = t.Code, IsAdmin = t.IsAdmin, IsSystem = t.IsSystem, }) .OrderBy("id ASC") .ToPageList(page, pageSize, ref total); return(new PagedList <QueryRoleItem> { List = list, Page = page, PageSize = pageSize, TotalCount = total }); } }
public IActionResult PagedList(PagedQueryRoleDto dto) { var list = _roleService.PagedQueryRoles(dto); var result = new { Code = 0, Message = "", Total = list.Data.TotalCount, Data = list.Data.List }; return(Json(result)); }