/// <summary> /// 分页查询 /// </summary> /// <param name="dto"></param> /// <returns></returns> public PublicResult <PagedList <QueryAdItem> > PagedQueryAds(PagedQueryAdsDto dto) { var page = dto.Page ?? 1; var pageSize = dto.PageSize ?? 20; using (var client = DbFactory.CreateClient()) { var total = 0; var list = client.Queryable <Ad>() .Where(it => it.AdPlaceId == dto.AdPlaceId) .WhereIF(!dto.Keyword.IsNullOrEmpty(), it => it.Title.Contains(dto.Keyword)) .Select(t => new QueryAdItem() { Id = t.Id, AdPlaceId = t.AdPlaceId, Title = t.Title, ImagePath = t.ImagePath, TargetUrl = t.TargetUrl, Order = t.OrderIndex, IsShow = t.IsShow, }) .OrderBy("order_index ASC,id DESC") .ToPageList(page, pageSize, ref total); return(new PagedList <QueryAdItem> { List = list, Page = page, PageSize = pageSize, TotalCount = total }); } }
public IActionResult PagedList(PagedQueryAdsDto request) { var list = _adService.PagedQueryAds(request); var result = new { Code = 0, Message = "", Total = list.Data.TotalCount, Data = list.Data.List }; return(Json(result)); }