/// <summary>
/// 获取运行日志信息
/// </summary>
/// <param name="taskId"></param>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public async Task <IEnumerable <TaskLog> > GetJobRunLog(int taskId, int page, int pageSize = 30)
{
string sql = $@"SELECT * FROM TaskLog WHERE TaskId = @taskId ORDER BY ExecutionTime DESC LIMIT {pageSize} OFFSET {(page - 1) * pageSize}";
using var con = new DapperDbContexts().Connection;
IEnumerable <TaskLog> result = await con.QueryAsync <TaskLog>(sql, new { taskId = taskId });
return(result);
}
/// <summary>
/// 获取所有任务
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <TaskOptions> > GetAll()
{
string sql = @"SELECT * FROM TaskOptions";
using var con = new DapperDbContexts().Connection;
IEnumerable <TaskOptions> tasks = await con.QueryAsync <TaskOptions>(sql);
return(tasks);
}