/// <summary>
/// 根据ID获取任务
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <TaskOptions> GetTaskById(int id)
{
string sql = @"SELECT * FROM TaskOptions WHERE Id = @id";
using var con = new DapperDbContexts().Connection;
TaskOptions task = await con.QueryFirstOrDefaultAsync <TaskOptions>(sql, new
{
id = id
});
return(task);
}
/// <summary>
/// 根据名称获取任务
/// </summary>
/// <param name="groupName"></param>
/// <param name="taskName"></param>
/// <returns></returns>
public async Task <TaskOptions> GetTaskByName(string groupName, string taskName)
{
string sql = @"SELECT * FROM TaskOptions WHERE TaskName = @taskName AND GroupName = @groupName";
using var con = new DapperDbContexts().Connection;
TaskOptions task = await con.QueryFirstOrDefaultAsync <TaskOptions>(sql, new
{
taskName = taskName,
groupName = groupName
});
return(task);
}