From 2f3d91bdb79235cd9c3dcbfed2493adf1bd94d6a Mon Sep 17 00:00:00 2001
From: houjie <714924425@qq.com>
Date: 星期五, 01 九月 2023 17:26:45 +0800
Subject: [PATCH] 备件库存/备件信息 导入 字典值转移
---
lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparesPartInventoryController.java | 58 ++++++++++++++++++++++++++++++++++++++++++----------------
1 files changed, 42 insertions(+), 16 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparesPartInventoryController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparesPartInventoryController.java
index 0b9419d..859cc9f 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparesPartInventoryController.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparesPartInventoryController.java
@@ -11,6 +11,8 @@
import org.jeecg.common.aspect.annotation.AutoLog;
import org.jeecg.common.system.base.controller.JeecgController;
import org.jeecg.common.system.query.QueryGenerator;
+import org.jeecg.modules.base.entity.*;
+import org.jeecg.modules.base.service.*;
import org.jeecg.modules.spare.entity.SparePart;
import org.jeecg.modules.spare.entity.SparesPartInventory;
import org.jeecg.modules.spare.service.ISparePartService;
@@ -45,6 +47,20 @@
private ISparesPartInventoryService sparesPartInventoryService;
@Autowired
private ISparePartService sparePartService;
+ @Autowired
+ private IUnitService unitService;
+ @Autowired
+ private ISupplierService supplierService;
+
+ @Autowired
+ private IWarehouseService warehouseService;
+
+ @Autowired
+ private IWarehouseAreaService warehouseAreaService;
+
+ @Autowired
+ private IWarehouseLocationService warehouseLocationService;
+
/**
* 鍒嗛〉鍒楄〃鏌ヨ
@@ -188,31 +204,41 @@
params.setNeedSave(true);
try {
List<SparesPartInventory> list = ExcelImportUtil.importExcel(file.getInputStream(), SparesPartInventory.class, params);
- /* for (SparesPartInventory temp : list) {
- temp.setSparePartId(mainId);
- if (!StringUtils.isNotEmpty(sparePart.getName()))
- return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽浠跺悕绉颁笉鑳戒负绌�");
- if (!StringUtils.isNotEmpty(sparePart.getNum()))
- return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽浠剁紪鐮佷笉鑳戒负绌�");
- if (!StringUtils.isNotEmpty(sparePart.getSpecification()))
- return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽浠惰鏍间笉鑳戒负绌�");
- if (!StringUtils.isNotEmpty(sparePart.getModel()))
- return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽浠跺瀷鍙蜂笉鑳戒负绌�");
-
- }*/
+ 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()))
return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屾壒娆″彿涓嶈兘涓虹┖");
if (sparesPartInventory.getMainQuantity() <= 0)
return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屾暟閲忎笉鑳戒负灏忎簬绛変簬0");
-
}
-
- long start = System.currentTimeMillis();
sparesPartInventoryService.saveBatch(list);
log.info("娑堣�楁椂闂�" + (System.currentTimeMillis() - start) + "姣");
return Result.OK("鏂囦欢瀵煎叆鎴愬姛锛佹暟鎹鏁帮細" + list.size());
--
Gitblit v1.9.3