public async Task StudentInfoAndPaymentLogImporter_Test() { var filePath = Path.Combine(Directory.GetCurrentDirectory(), "TestFiles", "Import", "学生基础数据及缴费流水号导入.xlsx"); var importDic = await Importer.ImportMultipleSheet <ImportStudentAndPaymentLogDto>(filePath); foreach (var item in importDic) { var import = item.Value; import.ShouldNotBeNull(); if (import.Exception != null) { _testOutputHelper.WriteLine(import.Exception.ToString()); } if (import.RowErrors.Count > 0) { _testOutputHelper.WriteLine(JsonConvert.SerializeObject(import.RowErrors)); } import.HasError.ShouldBeTrue(); import.Data.ShouldNotBeNull(); if (item.Key == "1班导入数据") { import.Data.Count.ShouldBe(16); ImportStudentDto dto = (ImportStudentDto)import.Data.ElementAt(0); dto.Name.ShouldBe("杨圣超"); } if (item.Key == "缴费数据") { import.Data.Count.ShouldBe(20); ImportPaymentLogDto dto = (ImportPaymentLogDto)import.Data.ElementAt(0); dto.Name.ShouldBe("刘茵"); } } }
public async Task ClassStudentInfoImporter_SaveLabelingError_Test() { var filePath = Path.Combine(Directory.GetCurrentDirectory(), "TestFiles", "Import", "学生基础数据及缴费流水号导入_标注错误.xlsx"); var importDic = await Importer.ImportMultipleSheet <ImportStudentAndPaymentLogDto>(filePath); foreach (var item in importDic) { var import = item.Value; import.ShouldNotBeNull(); if (import.Exception != null) { _testOutputHelper.WriteLine(import.Exception.ToString()); } if (import.RowErrors.Count > 0) { _testOutputHelper.WriteLine(JsonConvert.SerializeObject(import.RowErrors)); } import.Data.ShouldNotBeNull(); if (item.Key == "1班导入数据") { import.Data.Count.ShouldBe(16); ImportStudentDto dto = (ImportStudentDto)import.Data.ElementAt(0); dto.Name.ShouldBe("杨圣超"); } if (item.Key == "缴费数据") { import.HasError.ShouldBeTrue(); import.Data.Count.ShouldBe(20); ImportPaymentLogDto dto = (ImportPaymentLogDto)import.Data.ElementAt(0); dto.Name.ShouldBe("刘茵"); } } var ext = Path.GetExtension(filePath); var labelingErrorExcelPath = filePath.Replace(ext, "_" + ext); if (File.Exists(labelingErrorExcelPath)) { _testOutputHelper.WriteLine($"保存标注错误Excel文件已生成,路径:{labelingErrorExcelPath}"); } }