| | |
|---|
| | | List<SparesPartInventory> list = ExcelImportUtil.importExcel(file.getInputStream(), SparesPartInventory.class, params); |
|---|
| | | long start = System.currentTimeMillis(); |
|---|
| | | for (int i = 0; i < list.size(); i++) { |
|---|
| | | SparesPartInventory sparesPartInventory = list.get(i); |
|---|
| | | sparesPartInventory.setSparePartId(mainId); |
|---|
| | | String mainUnitName = sparesPartInventory.getMainUnitId(); |
|---|
| | | String supplierName = sparesPartInventory.getSupplierId(); |
|---|
| | | String warehouseName = sparesPartInventory.getWarehouseId(); |
|---|
| | | String warehouseAreaName = sparesPartInventory.getWarehouseAreaId(); |
|---|
| | | String warehouseLocationName = sparesPartInventory.getWarehouseLocationId(); |
|---|
| | | Supplier supplierId = supplierService.getByName(supplierName); |
|---|
| | | Unit unitById = unitService.getUnitByName(mainUnitName); |
|---|
| | | Warehouse warehouseId = warehouseService.getByName(warehouseName); |
|---|
| | | WarehouseArea warehouseAreaId = warehouseAreaService.getByName(warehouseAreaName); |
|---|
| | | WarehouseLocation warehouseLocationId = warehouseLocationService.getByName(warehouseLocationName); |
|---|
| | | if (!StringUtils.isNotEmpty(unitById.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行单位不存在"); |
|---|
| | | if (!StringUtils.isNotEmpty(supplierId.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行供应商不存在"); |
|---|
| | | if (!StringUtils.isNotEmpty(warehouseId.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行仓库不存在"); |
|---|
| | | if (!StringUtils.isNotEmpty(warehouseAreaId.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行库区不存在"); |
|---|
| | | if (!StringUtils.isNotEmpty(warehouseLocationId.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行库位不存在"); |
|---|
| | | list.get(i).setMainUnitId(unitById.getId()); |
|---|
| | | list.get(i).setSupplierId(supplierId.getId()); |
|---|
| | | list.get(i).setSupplierId(warehouseId.getId()); |
|---|
| | | list.get(i).setSupplierId(warehouseAreaId.getId()); |
|---|
| | | list.get(i).setSupplierId(warehouseLocationId.getId()); |
|---|
| | | if (!StringUtils.isNotEmpty(sparesPartInventory.getBatchNum())) |
|---|
| | | Supplier supplier = null; |
|---|
| | | Unit unit = null; |
|---|
| | | Warehouse warehouse = null; |
|---|
| | | WarehouseArea warehouseArea = null; |
|---|
| | | WarehouseLocation warehouseLocation = null; |
|---|
| | | list.get(i).setSparePartId(mainId); |
|---|
| | | |
|---|
| | | String mainUnitName = list.get(i).getMainUnitId(); |
|---|
| | | String supplierName = list.get(i).getSupplierId(); |
|---|
| | | String warehouseName = list.get(i).getWarehouseId(); |
|---|
| | | String warehouseAreaName = list.get(i).getWarehouseAreaId(); |
|---|
| | | String warehouseLocationName = list.get(i).getWarehouseLocationId(); |
|---|
| | | String num =list.get(i).getValidityForecast(); |
|---|
| | | |
|---|
| | | if (supplierName != null) { |
|---|
| | | supplier = supplierService.getByName(supplierName); |
|---|
| | | } |
|---|
| | | if (mainUnitName != null) { |
|---|
| | | unit = unitService.getUnitByName(mainUnitName); |
|---|
| | | } |
|---|
| | | if (warehouseName != null) { |
|---|
| | | warehouse = warehouseService.getByName(warehouseName); |
|---|
| | | } |
|---|
| | | if (warehouseAreaName != null) { |
|---|
| | | warehouseArea = warehouseAreaService.getByName(warehouseAreaName); |
|---|
| | | } |
|---|
| | | if (warehouseLocationName != null) { |
|---|
| | | warehouseLocation = warehouseLocationService.getByName(warehouseLocationName); |
|---|
| | | } |
|---|
| | | if (!StringUtils.isNotEmpty(list.get(i).getBatchNum())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行批次号不能为空"); |
|---|
| | | if (sparesPartInventory.getMainQuantity() <= 0) |
|---|
| | | if (list.get(i).getMainQuantity() <= 0) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行数量不能为小于等于0"); |
|---|
| | | |
|---|
| | | if (unit != null) { |
|---|
| | | if (!StringUtils.isNotEmpty(unit.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行单位不存在"); |
|---|
| | | list.get(i).setMainUnitId(unit.getId()); |
|---|
| | | } |
|---|
| | | if (supplier != null) { |
|---|
| | | if (!StringUtils.isNotEmpty(supplier.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行供应商不存在"); |
|---|
| | | list.get(i).setSupplierId(supplier.getId()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (warehouse != null) { |
|---|
| | | if (!StringUtils.isNotEmpty(warehouse.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行仓库不存在"); |
|---|
| | | list.get(i).setWarehouseId(warehouse.getId()); |
|---|
| | | } |
|---|
| | | if (warehouseArea != null) { |
|---|
| | | if (!StringUtils.isNotEmpty(warehouseArea.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行库区不存在"); |
|---|
| | | list.get(i).setWarehouseAreaId(warehouseArea.getId()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (warehouseLocation != null) { |
|---|
| | | if (!StringUtils.isNotEmpty(warehouseLocation.getId())) |
|---|
| | | return Result.error("文件导入失败: 第" + (i + 1) + "行库位不存在"); |
|---|
| | | list.get(i).setWarehouseLocationId(warehouseLocation.getId()); |
|---|
| | | } |
|---|
| | | list.get(i).setValidityForecast(num); |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | sparesPartInventoryService.saveBatch(list); |
|---|
