public Task <IEnumerable <EBFileSetting> > GetAsync(EBFileSettingSearch option, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT s.*
, f.RequireYear
FROM EBFileSetting s
INNER JOIN EBFormat f ON f.Id = s.EBFormatId
WHERE s.Id = s.Id";
if (option.CompanyId.HasValue)
{
query += @"
AND s.CompanyId = @CompanyId";
}
if (option.Ids?.Any() ?? false)
{
query += @"
AND s.Id IN (SELECT Id FROM @Ids)";
}
query += @"
ORDER BY s.DisplayOrder ASC";
return(dbHelper.GetItemsAsync <EBFileSetting>(query, new {
option.CompanyId,
Ids = option.Ids.GetTableParameter(),
}, token));
}
public async Task <int> UpdateIsUseable(EBFileSettingSearch option, CancellationToken token) => await ebFileSettingProcessor.UpdateIsUseableAsync(option.CompanyId.Value, option.LoginUserId.Value, option.UpdateIds);
public async Task <IEnumerable <EBFileSetting> > GetItems(EBFileSettingSearch option, CancellationToken token) => (await ebFileSettingProcessor.GetAsync(option, token)).ToArray();
public async Task <IEnumerable <EBFileSetting> > GetAsync(EBFileSettingSearch option, CancellationToken token = default(CancellationToken)) => await ebFileSettingQueryProcessor.GetAsync(option, token);
