From db9a7f9c1b61af84be764a399b3f1f85e0ff03ee Mon Sep 17 00:00:00 2001
From: dubin <bindu_bean@163.com>
Date: 星期四, 27 十一月 2025 09:37:36 +0800
Subject: [PATCH] #1
---
src/main/java/com/zy/asrs/utils/MatExcelListener.java | 43 ++++++++++++++++++++++++++++++++++++++++---
1 files changed, 40 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/zy/asrs/utils/MatExcelListener.java b/src/main/java/com/zy/asrs/utils/MatExcelListener.java
index 0c7ff89..cf5fd80 100644
--- a/src/main/java/com/zy/asrs/utils/MatExcelListener.java
+++ b/src/main/java/com/zy/asrs/utils/MatExcelListener.java
@@ -2,17 +2,20 @@
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
+import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.core.common.Cools;
import com.core.common.SpringUtils;
import com.core.exception.CoolException;
+import com.zy.asrs.entity.InOut;
import com.zy.asrs.entity.Mat;
+import com.zy.asrs.entity.MatBarcode;
import com.zy.asrs.entity.Tag;
import com.zy.asrs.mapper.TagMapper;
-import com.zy.asrs.service.MatService;
-import com.zy.asrs.service.TagService;
+import com.zy.asrs.service.*;
import com.zy.common.entity.MatExcel;
import com.zy.common.utils.NodeUtils;
import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
import java.util.ArrayList;
import java.util.Date;
@@ -57,6 +60,11 @@
TagService tagService = SpringUtils.getBean(TagService.class);
TagMapper tagMapper = SpringUtils.getBean(TagMapper.class);
MatService matService = SpringUtils.getBean(MatService.class);
+ InOutService inOutService = SpringUtils.getBean(InOutService.class);
+ MatBarcodeService matBarcodeService = SpringUtils.getBean(MatBarcodeService.class);
+ WrkDetlService wrkDetlService = SpringUtils.getBean(WrkDetlService.class);
+ LocDetlService locDetlService = SpringUtils.getBean(LocDetlService.class);
+ WaitPakinService waitPakinService = SpringUtils.getBean(WaitPakinService.class);
Date now = new Date();
Long tagId;
// 鍒嗙被
@@ -127,14 +135,43 @@
tagId = tagService.getTop().getId();
}
// 鍟嗗搧
- Mat mat = matService.selectByMatnr(excel.getMatnr());
+ Mat mat = matService.selectByMatnr(excel.getMatnr() + "__" + excel.getName());
if (mat == null) {
+ InOut inOut=new InOut();
mat = excel;
mat.setTagId(tagId);
+ mat.setMatnr(excel.getMatnr()+"__"+excel.getName());
+ inOut.setMatnr(mat.getMatnr());
+ inOut.setMaktx(mat.getMaktx());
+ inOut.setColor(mat.getColor());
+ inOut.setSpecs(mat.getSpecs());
+ inOut.setTemp1("");
if (!matService.insert(mat)) {
+ throw new CoolException("淇濆瓨鍟嗗搧妗ｆ澶辫触锛屽晢鍝佺紪鐮侊細" + excel.getMatnr());
+ }
+ if (!inOutService.insert(inOut)){
throw new CoolException("淇濆瓨鍟嗗搧淇℃伅澶辫触锛屽晢鍝佺紪鐮侊細" + excel.getMatnr());
}
total++;
+ } else {
+ if (excel.getColor().equals("鎶ュ簾")){
+ //妯″叿鐘舵�佹洿鏂颁负鎶ュ簾 妯″叿涓庢墭鐩樿В缁�
+ List<MatBarcode> list = new ArrayList<>();
+ MatBarcode matBarcode = matBarcodeService.selectbyMatnr(excel.getMatnr() + "__" + excel.getName());
+ if (matBarcode != null){
+ list.add(matBarcode);
+ matBarcodeService.deleteMatBarcode(list);
+ }
+
+ }
+ //妯″叿淇℃伅鏇存柊
+ matService.delete(new EntityWrapper<Mat>().eq("matnr",mat.getMatnr()));
+ mat = excel;
+ mat.setTagId(tagId);
+ mat.setMatnr(excel.getMatnr() + "__" + excel.getName());
+ if (!matService.insert(mat)) {
+ throw new CoolException("淇濆瓨鍟嗗搧妗ｆ澶辫触锛屽晢鍝佺紪鐮侊細" + excel.getMatnr());
+ }
}
}
--
Gitblit v1.9.1