/// <summary> /// 分页查询 /// </summary> /// <param name="dto"></param> /// <returns></returns> public PublicResult <PagedList <QueryAdPlaceItem> > PagedQueryAdPlaces(PagedQueryAdPlaceDto dto) { var page = dto.Page ?? 1; var pageSize = dto.PageSize ?? 20; using (var client = DbFactory.CreateClient()) { var total = 0; var list = client.Queryable <AdPlace>() .WhereIF(!dto.Keyword.IsNullOrEmpty(), t => t.Title.Contains(dto.Keyword)) .Select(t => new QueryAdPlaceItem() { Id = t.Id, Title = t.Title, Code = t.Code, Desc = t.Desc, AddTime = t.Addtime, }) .OrderBy("id DESC") .ToPageList(page, pageSize, ref total); return(new PagedList <QueryAdPlaceItem> { List = list, Page = page, PageSize = pageSize, TotalCount = total }); } }
public IActionResult PagedList(PagedQueryAdPlaceDto dto) { var list = _adService.PagedQueryAdPlaces(dto); var result = new { Code = 0, Message = "", Total = list.Data.TotalCount, Data = list.Data.List }; return(Json(result)); }