/// <summary> /// 获取SQL任务分页 /// </summary> /// <param name="pageIndex">页面索引</param> /// <param name="pageSize">页面大小</param> /// <param name="state">任务状态</param> /// <param name="keyword">搜索关键字</param> /// <param name="orderBy">排序字符串</param> /// <exception cref="SocketException"></exception> /// <returns></returns> public Task <PageInfo <SqlDelayTask> > SqlTaskToPage(int pageIndex, int pageSize, DelayTaskState state, string keyword = null, string orderBy = "ExecuteTime ASC") { return(this.client.InvokeApi <PageInfo <SqlDelayTask> >("SqlTaskToPage", pageIndex, pageSize, state, keyword, orderBy)); }
/// <summary> /// 获取Http任务分页 /// </summary> /// <param name="pageIndex">页面索引</param> /// <param name="pageSize">页面大小</param> /// <param name="state">状态</param> /// <param name="keyword">搜索关键字</param> /// <param name="orderBy">排序字符串</param> /// <returns></returns> public static PageInfo <HttpDelayTask> HttpTaskToPage(int pageIndex, int pageSize, DelayTaskState state, string keyword, string orderBy = "ExecuteTime ASC") { var where = Where.True <HttpDelayTask>(); if (state == DelayTaskState.Active) { where = where.And(item => item.LoopInterval > 0 || (item.SuccessCount + item.FailureCount) == 0); } else if (state == DelayTaskState.NoActive) { where = where.And(item => item.LoopInterval <= 0 && (item.SuccessCount + item.FailureCount) > 0); } if (string.IsNullOrEmpty(keyword) == false) { where = where.And(item => item.Name.Contains(keyword) || item.Description.Contains(keyword)); } return(DatabaseHelper.DelayTaskToPage <HttpDelayTask>(pageIndex, pageSize, where, orderBy)); }
public PageInfo <SqlDelayTask> SqlTaskToPage(int pageIndex, int pageSize, DelayTaskState state, string keyword, string orderBy) { return(TaskSheduler.SqlTaskToPage(pageIndex, pageSize, state, keyword, orderBy)); }