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