public async Task <IEnumerable <ArrearagesList> > GetAsync(ArrearagesListSearch option, CancellationToken token = default(CancellationToken)) => await arrearagesListQueryProcessor.GetAsync(option);
public async Task <byte[]> GetAsync(ArrearagesListSearch option, CancellationToken token = default(CancellationToken))
{
var companyTask = companyQueryProcessor.GetAsync(new CompanySearch {
Id = option.CompanyId,
}, token);
var columnTask = columnNameSettingQueryProcessor.GetAsync(new ColumnNameSetting {
CompanyId = option.CompanyId, TableName = nameof(Billing),
}, token);
var settingTask = reportSettingQueryProcessor.GetAsync(option.CompanyId, ReportId, token);
var loadTask = arrearagesListQueryProcessor.GetAsync(option, token);
var ccyCode = string.IsNullOrEmpty(option.CurrencyCode) ? Constants.DefaultCurrencyCode : option.CurrencyCode;
var ccyTask = currencyGetByCodeQueryProcessor.GetByCodeAsync(option.CompanyId, ccyCode);
var tasks = new List <Task>()
{
companyTask, columnTask, loadTask, ccyTask
};
var requireSetting = !(option.ReportSettings?.Any() ?? false);
if (requireSetting)
{
tasks.Add(settingTask);
}
await Task.WhenAll(tasks);
var company = companyTask.Result.First();
var columns = columnTask.Result.ToList();
var items = loadTask.Result.ToList();
var precision = ccyTask.Result.Precision;
if (!items.Any())
{
return(null);
}
if (requireSetting)
{
option.ReportSettings = settingTask.Result.ToList();
}
var processor = option.CustomerSummaryFlag ?
(IProcessor) new ArrearagesListSummaryDocumentProcessor {
Company = company,
Items = items,
Precision = precision,
} : new ArrearagesListDocumentProcessor {
Company = company,
Items = items,
Precision = precision,
Note1 = columns.FirstOrDefault(x => x.ColumnName == nameof(ArrearagesList.Note1))?.DisplayColumnName ?? "備考1",
};
using (var stream = new MemoryStream())
{
using (var document = SpreadsheetDocument.Create(stream, SpreadsheetDocumentType.Workbook))
{
processor.Process(document);
}
return(stream.ToArray());
}
}
public async Task <byte[]> GetAsync(ArrearagesListSearch option, CancellationToken token = default(CancellationToken))
{
var companyTask = companyQueryProcessor.GetAsync(new CompanySearch {
Id = option.CompanyId,
}, token);
var columnTask = columnNameSettingQueryProcessor.GetAsync(new ColumnNameSetting {
CompanyId = option.CompanyId, TableName = nameof(Billing),
}, token);
var settingTask = reportSettingQueryProcessor.GetAsync(option.CompanyId, ReportId, token);
var loadTask = arrearagesListQueryProcessor.GetAsync(option, token);
var tasks = new List <Task>()
{
companyTask, columnTask, loadTask
};
var requireSetting = !(option.ReportSettings?.Any() ?? false);
if (requireSetting)
{
tasks.Add(settingTask);
}
await Task.WhenAll(tasks);
var company = companyTask.Result.First();
var columns = columnTask.Result.ToList();
var items = loadTask.Result.ToList();
if (!items.Any())
{
return(null);
}
if (requireSetting)
{
option.ReportSettings = settingTask.Result.ToList();
}
GrapeCity.ActiveReports.SectionReport report;
var title = $"滞留明細一覧表{DateTime.Today:yyyyMMdd}";
if (option.CustomerSummaryFlag)
{
var reportTemp = new ArrearagesCustomerListReport();
reportTemp.SetBasicPageSetting(company.Code, company.Name);
reportTemp.SetData(items, option.Precision, option.ReportSettings);
report = reportTemp;
}
else
{
var reportTemp = new ArrearagesListReport();
reportTemp.SetBasicPageSetting(company.Code, company.Name);
reportTemp.SetData(items, option.Precision, option.ReportSettings, columns);
report = reportTemp;
}
report.Name = title;
report.Run();
return(report.Convert());
}
