public async Task <List <JobDictEntity> > QueryDictAllAsync(DictType?type)
{
if (type.HasValue)
{
return((await _context.QueryAsync <JobDictEntity>($"SELECT * FROM JobDict WHERE Type=@Type ORDER BY Type ASC,Sort ASC", new { Type = type }))?.ToList());
}
else
{
return((await _context.QueryAsync <JobDictEntity>($"SELECT * FROM JobDict ORDER BY Type ASC,Sort ASC"))?.ToList());
}
}
public Task <IEnumerable <long> > QueryRunningJobTaskIdsAsync(string nodeName)
{
return(_context.QueryAsync <long>($"SELECT Id FROM JobTasks {NOLOCK} WHERE NodeName=@NodeName AND Status=@Status", new { NodeName = nodeName, Status = JobTaskStatus.Running }));
}