public async Task <JsonDataMsg <ExcelPackage> > ExportMachinesAsync()
{
//先尝试获取100条数据
int current = 1;
int capacity = 100;
DataBoxDto <EquipmentDto> dataBoxDto = await Repository.QuantitativeTargetsAsync(current, capacity);
if (0 == dataBoxDto.Total)
{
//如果没有数据，则导出一个空的Excel模板文件，并返回
ExcelPackage emptyExcelPackage = ExcelFileService.CreateEquipmentTemplate();
if (null == emptyExcelPackage)
{
NLogMgr.ErrorExLog(_errorLog, "创建Excel失败", null);
return(new JsonDataMsg <ExcelPackage>(null, false, "创建Excel失败"));
}
NLogMgr.DebugLog(_programLog, "创建Excel模板成功");
return(new JsonDataMsg <ExcelPackage>(emptyExcelPackage, true, ""));
}
//有数据则根据数据，得到总分页数，便于后续遍历
var totalPage = (int)Math.Ceiling(dataBoxDto.Total * 1.0 / capacity);
List <EquipmentDto> eqList = new List <EquipmentDto>(dataBoxDto.Data);
if (totalPage > current)
{
//还需要获取后面分页的数据
while (++current <= totalPage)
{
dataBoxDto = await Repository.QuantitativeTargetsAsync(current, capacity);
if ((null == dataBoxDto.Data || !dataBoxDto.Data.Any()) && (current <= totalPage))
{
NLogMgr.ErrorExLog(_errorLog, $"导出第{current}页数据的时候出错了", null);
return(new JsonDataMsg <ExcelPackage>(null, false, $"导出第{current}页数据的时候出错了"));
}
if (null != dataBoxDto.Data && dataBoxDto.Data.Any())
{
eqList.AddRange(dataBoxDto.Data);
}
}
}
//取完剩余的分页数据，则可以开始生成Excel文件
//todo:生成Excel文件
ExcelPackage excelPackage = ExcelFileService.CreateEquipmentExcel(eqList);
if (null == excelPackage)
{
NLogMgr.ErrorExLog(_errorLog, "创建Excel失败", null);
return(new JsonDataMsg <ExcelPackage>(null, false, $"创建Excel失败"));
}
NLogMgr.DebugLog(_programLog, "数据存储到内存Excel成功");
return(new JsonDataMsg <ExcelPackage>(excelPackage, true, ""));
}
public ExcelFileServiceTests()
{
_helper = new TestsHelper();
_container = _helper.GetContainer();
_excelFileService = _container.Resolve <ExcelFileService>();
_testsFilesPath = Path.Combine(_container.Resolve <string>("TestsFilesPath") + $@"\{nameof(ExcelFileServiceTests)}\");
_fixture = _container.Resolve <Fixture>();
}
public async Task <JsonDataMsg <string> > ImportingMachinesAsync(IFormCollection formCollection)
{
if (null == formCollection || null == formCollection.Files || !formCollection.Files.Any())
{
NLogMgr.ErrorExLog(_errorLog, "服务器接收不到文件文件", null);
return(new JsonDataMsg <string>(null, false, "服务器接收不到文件"));
}
IFormFile file = formCollection.Files[0];
if (!ExcelFile.ValidExcelFile(file))
{
NLogMgr.DebugLog(_programLog, "您上传的文件不是*.xlsx后缀的文件");
return(new JsonDataMsg <string>(null, false, "您上传的文件不是*.xlsx后缀的文件"));
}
//导入前通知工具停止作业
NLogMgr.DebugLog(_programLog, "通知工具停止作业");
try
{
bool ipcResult = await _client.InvokeAsync(p => p.StopJob());
NLogMgr.DebugLog(_programLog, "工具反馈结果:" + ipcResult);
}
catch (Exception ipcEx)
{
NLogMgr.ErrorExLog(_errorLog, "ipc通信失败", ipcEx);
}
List <EquipmentDto> list = await ExcelFileService.GetExcelDataAsync(file);
bool success = await Repository.ReplaceTargetsAsync(list);
JsonDataMsg <string> result = null;
if (success)
{
NLogMgr.DebugLog(_programLog, "设备导入完毕");
result = new JsonDataMsg <string>(null, success, "设备导入完毕");
}
else
{
NLogMgr.DebugLog(_programLog, "导入设备操作过程发生异常");
result = new JsonDataMsg <string>(null, success, "导入设备操作过程发生异常");
}
//导入后重新开始作业
NLogMgr.DebugLog(_programLog, "通知工具可以继续作业");
_client.InvokeAsync(p => p.JobRestart());
return(result);
}
public async Task GenerateReport_ThreeFundingYears()
{
var ukprn = 12345678;
var jobid = 1;
var reportFolder = "FundingSummaryTestThreeYears";
TestFixture(reportFolder, ukprn, jobid);
var esfJobContext = new Mock <IEsfJobContext>();
var sourceFile = new Mock <ISourceFileModel>();
var wrapper = new SupplementaryDataWrapper();
var cancellationToken = CancellationToken.None;
var testModels = new List <IFundingSummaryReportTab>
{
new FundingSummaryReportTab
{
Title = FundingSummaryReportConstants.BodyTitle,
TabName = "ConRef1",
Header = TestHeader("ConRef1", 3),
Body = TestBodyModels(3),
Footer = TestFooter()
},
new FundingSummaryReportTab
{
Title = FundingSummaryReportConstants.BodyTitle,
TabName = "ConRef2",
Header = TestHeader("ConRef2", 3),
Body = TestBodyModels(3),
Footer = TestFooter()
}
};
esfJobContext.Setup(x => x.UkPrn).Returns(ukprn);
esfJobContext.Setup(x => x.JobId).Returns(jobid);
esfJobContext.Setup(x => x.StartCollectionYearAbbreviation).Returns("20");
esfJobContext.Setup(x => x.CollectionYear).Returns(2021);
esfJobContext.Setup(x => x.ReturnPeriod).Returns("R05");
esfJobContext.Setup(x => x.CurrentPeriod).Returns(5);
esfJobContext.Setup(x => x.BlobContainerName).Returns(reportFolder);
var modelBuilder = new Mock <IFundingSummaryReportModelBuilder>();
var renderService = new FundingSummaryReportRenderService();
var dateTimeProvider = new Mock <IDateTimeProvider>();
var fileService = new FileSystemFileService();
var excelFileService = new ExcelFileService(fileService);
modelBuilder.Setup(x => x.Build(esfJobContext.Object, cancellationToken)).ReturnsAsync(testModels);
await NewReport(modelBuilder.Object, renderService, dateTimeProvider.Object, excelFileService)
.GenerateReport(esfJobContext.Object, sourceFile.Object, wrapper, cancellationToken);
}