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