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