|
public GetByJob ( string jobName, System.DateTime start, System.DateTime end, int limit ) : Task |
||
| jobName | string | |
| start | System.DateTime | |
| end | System.DateTime | |
| limit | int | |
| Результат | Task |
|
public virtual Task<IEnumerable<InvocationState>> GetByJob(string jobName, DateTime? start, DateTime? end, int? limit)
{
var limitStr = "";
if(limit != null)
{
limitStr = "TOP (" + limit.Value.ToString() + ") ";
}
return ConnectAndQuery(@"
SELECT " + limitStr + @"*
FROM [work].Invocations
WHERE [Job] = @jobName
AND (@start IS NULL OR [UpdatedAt] >= @start)
AND (@end IS NULL OR [UpdatedAt] <= @end)
ORDER BY UpdatedAt DESC", new { jobName, start, end });
}
