public IActionResult PagedList(PagedQueryScheduleTaskDto dto) { var list = _scheduleTaskService.PagedQueryScheduleTasks(dto); var result = new { Code = 0, Message = "", Total = list.Data.TotalCount, Data = list.Data.List }; return(Json(result)); }
/// <summary> /// /// </summary> /// <param name="dto"></param> /// <returns></returns> public PublicResult <PagedList <QueryScheduleTaskItem> > PagedQueryScheduleTasks( PagedQueryScheduleTaskDto dto) { var page = dto.Page ?? 1; var pageSize = dto.PageSize ?? 20; using (var client = DbFactory.CreateClient()) { var total = 0; var list = client.Queryable <ScheduleTask>() .WhereIF(!dto.Keyword.IsNullOrEmpty(), t => t.Name.Contains(dto.Keyword)) .Select(t => new QueryScheduleTaskItem() { Id = t.Id, Name = t.Name, Status = t.Status, StatusDesc = t.StatusDesc, IsEnable = t.IsEnable, Cron = t.Cron, Interval = t.Interval, LastStartTime = t.LastStartTime, LastEndTime = t.LastEndTime, LastSuccessTime = t.LastSuccessTime, }) .OrderBy("id DESC") .ToPageList(page, pageSize, ref total); return(new PagedList <QueryScheduleTaskItem> { List = list, Page = page, PageSize = pageSize, TotalCount = total }); ; } }