public int UploadSuppliers(string fileName, bool isInitial = false) { ExcelPackage package; IList <Supplier> listOfSupplier = new List <Supplier>(); if (isInitial) { byte[] excelFile = Resource.仓库物品资料汇总表; var templateStream = new MemoryStream(excelFile); package = new ExcelPackage(templateStream); } else { if (string.IsNullOrEmpty(fileName)) { return(-2); } var fi = new FileInfo(fileName); package = new ExcelPackage(fi); } var workbook = package.Workbook; ExcelWorksheet worksheet = workbook.Worksheets["供应商信息表Vendor Master"];//供应商信息表Vendor Master if (worksheet == null) { return(0); } var end = worksheet.Dimension.End; for (var row = 6; row < end.Row; row++) { var supplierObj = new Supplier { Id = Guid.NewGuid() }; for (var col = 1; col <= worksheet.Dimension.End.Column; col++) { var readValue = worksheet.Cells[row, col].Value == null ? "" : worksheet.Cells[row, col].Value.ToString(); switch (col) { case 2: supplierObj.IsActive = readValue == "Active"; break; case 3: supplierObj.Name = readValue; break; } } listOfSupplier.Add(supplierObj); } try { _supplierRepository.AddRange(listOfSupplier); _supplierRepository.Save(); return(1); } catch (DbUpdateException) { return(0); } }