public void TestImportExcelList_ImportDataTable(int rows, string[] values_1, int[] values_2) { DataTable dataTable = new DataTable(); List <ColumnImportClass> importList = new List <ColumnImportClass>(); dataTable.Columns.Add("Column1", typeof(string)); dataTable.Columns.Add("Column2", typeof(int)); for (int i = 0; i < rows; i++) { DataRow dr = dataTable.NewRow(); dr["Column1"] = values_1[i]; dr["Column2"] = values_2[i]; dataTable.Rows.Add(dr); } ImportExcelListService <ColumnImportClass> service = new ImportExcelListService <ColumnImportClass>(importList, dataTable); service.Import(); Assert.IsNotNull(importList); Assert.AreEqual(importList.Count, rows); for (int i = 0; i < rows; i++) { Assert.AreEqual(importList[i].Column1, values_1[i]); Assert.AreEqual(importList[i].Column2, values_2[i]); } }
public void TestImportExcelList_ImportDataTable(int rows, string[] values_1, int[] values_2) { DataTable dataTable = new DataTable(); List<ColumnImportClass> importList = new List<ColumnImportClass>(); dataTable.Columns.Add("Column1", typeof(string)); dataTable.Columns.Add("Column2", typeof(int)); for (int i = 0; i < rows; i++) { DataRow dr = dataTable.NewRow(); dr["Column1"] = values_1[i]; dr["Column2"] = values_2[i]; dataTable.Rows.Add(dr); } ImportExcelListService<ColumnImportClass> service = new ImportExcelListService<ColumnImportClass>(importList, dataTable); service.Import(); Assert.IsNotNull(importList); Assert.AreEqual(importList.Count, rows); for (int i = 0; i < rows; i++) { Assert.AreEqual(importList[i].Column1, values_1[i]); Assert.AreEqual(importList[i].Column2, values_2[i]); } }
public static int ImportRegionStats(this IKpiImportController controller, HttpPostedFileBase httpPostedFileBase, string[] sheetNames, IRegionRepository regionRepository, ITopCellRepository<CdmaRegionStat> cdmaStatRepository) { List<CdmaRegionStat> statList = httpPostedFileBase.ImportInfo( x => { List<CdmaRegionStat> stats = new List<CdmaRegionStat>(); using (ExcelImporter excelImporter = new ExcelImporter(x, sheetNames)) { foreach (string sheetName in sheetNames) { using (DataTable statTable = excelImporter[sheetName]) { ImportExcelListService<CdmaRegionStat> service = new ImportExcelListService<CdmaRegionStat>(stats, statTable); service.Import(); } } } return stats; }, "佛山"); if (statList.Count > 0) { OptimizeRegion firstOrDefault = regionRepository.GetAllList().FirstOrDefault( x => x.Region == statList[0].Region); if (firstOrDefault != null) { controller.SaveTimeKpiStatsService.CurrentCity = firstOrDefault.City; controller.Save3GStatsService.CurrentCity = firstOrDefault.City; } } return cdmaStatRepository.SaveStats(statList); }
public static KpiImportResult Import(this IKpiImportController controller, HttpPostedFileBase httpPostedFileBase, string[] sheetNames, IRegionRepository regionRepository, ITopCellRepository <CdmaRegionStat> cdmaStatRepository) { List <CdmaRegionStat> statList = httpPostedFileBase.ImportInfo( x => { List <CdmaRegionStat> stats = new List <CdmaRegionStat>(); using (ExcelImporter excelImporter = new ExcelImporter(x, sheetNames)) { foreach (string sheetName in sheetNames) { using (DataTable statTable = excelImporter[sheetName]) { ImportExcelListService <CdmaRegionStat> service = new ImportExcelListService <CdmaRegionStat>(stats, statTable); service.Import(); } } } return(stats); }, "佛山"); if (statList.Count > 0) { OptimizeRegion firstOrDefault = regionRepository.GetAllList().FirstOrDefault( x => x.Region == statList[0].Region); if (firstOrDefault != null) { controller.SaveTimeKpiStatsService.CurrentCity = firstOrDefault.City; controller.Save3GStatsService.CurrentCity = firstOrDefault.City; } } int regionStatsSaved = cdmaStatRepository.SaveStats(statList); ExcelStatsImportRepository <TopDrop2GCellExcel> drop2GExcelRepository = httpPostedFileBase.ImportInfo( x => new ExcelStatsImportRepository <TopDrop2GCellExcel>(x, "掉话TOP30小区"), "佛山"); int topDrop2GSaved = controller.SaveTimeKpiStatsService.Save(drop2GExcelRepository.StatList); ExcelStatsImportRepository <TopConnection3GCellExcel> connection3GExcelRepository = httpPostedFileBase.ImportInfo( x => new ExcelStatsImportRepository <TopConnection3GCellExcel>(x, "连接TOP30小区"), "佛山"); int topConnection3GSaved = controller.Save3GStatsService.Save(connection3GExcelRepository.StatList); return(new KpiImportResult { RegionStatsSaved = regionStatsSaved, TopDrop2GSaved = topDrop2GSaved, TopConnection3GSaved = topConnection3GSaved }); }
public static KpiImportResult Import(this IKpiImportController controller, HttpPostedFileBase httpPostedFileBase, string[] sheetNames, IRegionRepository regionRepository, ITopCellRepository<CdmaRegionStat> cdmaStatRepository) { List<CdmaRegionStat> statList = httpPostedFileBase.ImportInfo( x => { List<CdmaRegionStat> stats = new List<CdmaRegionStat>(); using (ExcelImporter excelImporter = new ExcelImporter(x, sheetNames)) { foreach (string sheetName in sheetNames) { using (DataTable statTable = excelImporter[sheetName]) { ImportExcelListService<CdmaRegionStat> service = new ImportExcelListService<CdmaRegionStat>(stats, statTable); service.Import(); } } } return stats; }, "佛山"); if (statList.Count > 0) { OptimizeRegion firstOrDefault = regionRepository.GetAllList().FirstOrDefault( x => x.Region == statList[0].Region); if (firstOrDefault != null) { controller.SaveTimeKpiStatsService.CurrentCity = firstOrDefault.City; controller.Save3GStatsService.CurrentCity = firstOrDefault.City; } } int regionStatsSaved = cdmaStatRepository.SaveStats(statList); ExcelStatsImportRepository<TopDrop2GCellExcel> drop2GExcelRepository = httpPostedFileBase.ImportInfo( x => new ExcelStatsImportRepository<TopDrop2GCellExcel>(x, "掉话TOP30小区"), "佛山"); int topDrop2GSaved = controller.SaveTimeKpiStatsService.Save(drop2GExcelRepository.StatList); ExcelStatsImportRepository<TopConnection3GCellExcel> connection3GExcelRepository = httpPostedFileBase.ImportInfo( x => new ExcelStatsImportRepository<TopConnection3GCellExcel>(x, "连接TOP30小区"), "佛山"); int topConnection3GSaved = controller.Save3GStatsService.Save(connection3GExcelRepository.StatList); return new KpiImportResult { RegionStatsSaved = regionStatsSaved, TopDrop2GSaved = topDrop2GSaved, TopConnection3GSaved = topConnection3GSaved }; }