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