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