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