/// <summary>
/// 分页查询
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public PagedQueryAdResponse PagedQueryAds(PagedQueryAdRequest request)
{
var page = request.Page ?? 1;
var pageSize = request.PageSize ?? 20;
using (var client = DbFactory.GetClient())
{
var total = 0;
var list = client.Queryable <Ad>()
.Where(it => it.AdPlaceId == request.AdPlaceId)
.WhereIF(!request.Keyword.IsNullOrEmpty(), it => it.Title.Contains(request.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 PagedQueryAdResponse()
{
List = list,
Page = page,
PageSize = pageSize,
TotalCount = total
});
}
}
//[AdminAuthorize(Permissions = "admin.ad.index")]
public IActionResult PagedList(PagedQueryAdRequest request)
{
var list = _adService.PagedQueryAds(request);
var result = new
{
Code = 0,
Message = "",
Total = list.TotalCount,
Data = list.List
};
return(Json(result));
}
