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