From d42b55ad5e49d34ed75749683191769a21a4121d Mon Sep 17 00:00:00 2001
From: whycq <10027870+whycq@user.noreply.gitee.com>
Date: 星期一, 05 十二月 2022 14:50:52 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/mapper/LocDetlMapper.java | 2 ++
src/main/java/com/zy/asrs/service/LocDetlService.java | 1 +
src/main/resources/mapper/LocDetlMapper.xml | 4 +++-
src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java | 4 ++++
src/main/java/com/zy/asrs/controller/MatController.java | 12 ++++++++++++
5 files changed, 22 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/controller/MatController.java b/src/main/java/com/zy/asrs/controller/MatController.java
index 3e12304..d5424bf 100644
--- a/src/main/java/com/zy/asrs/controller/MatController.java
+++ b/src/main/java/com/zy/asrs/controller/MatController.java
@@ -10,10 +10,12 @@
import com.core.annotations.ManagerAuth;
import com.core.common.*;
import com.core.exception.CoolException;
+import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.Mat;
import com.zy.asrs.entity.MatPrint;
import com.zy.asrs.entity.OrderDetl;
import com.zy.asrs.entity.result.KeyValueVo;
+import com.zy.asrs.service.LocDetlService;
import com.zy.asrs.service.MatService;
import com.zy.asrs.utils.MatExcelListener;
import com.zy.common.CodeRes;
@@ -39,6 +41,8 @@
@Autowired
private MatService matService;
+ @Autowired
+ private LocDetlService locDetlService;
@Autowired
private SnowflakeIdWorker snowflakeIdWorker;
@@ -150,7 +154,15 @@
if (Cools.isEmpty(list)){
return R.error();
}
+
+
for (Mat entity : list){
+ LocDetl locDetl = locDetlService.selectByMatnr(entity.getMatnr());
+
+
+ if (!Cools.isEmpty(locDetl)) {
+ throw new CoolException("褰撳墠鐗╂枡鍦ㄥ簱锛屾棤娉曞垹闄わ紒");
+ }
if (!matService.delete(new EntityWrapper<>(entity))) {
throw new CoolException("鍒犻櫎澶辫触锛岃鑱旂郴绠＄悊鍛�");
}
diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
index c33ab13..1489a3b 100644
--- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -67,4 +67,6 @@
Double selectLocDetlSumQty(String locNo);
+ LocDetl selectByMatnr(String matnr);
+
}
diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java
index 0023ecf..35aae4d 100644
--- a/src/main/java/com/zy/asrs/service/LocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/LocDetlService.java
@@ -55,4 +55,5 @@
List<LocDetl> unreason();
Double getLocDetlSumQty(String locNo);
+ LocDetl selectByMatnr(String matnr);
}
diff --git a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
index 44bdd07..e61bc6b 100644
--- a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
@@ -116,4 +116,8 @@
public Double getLocDetlSumQty(String locNo) {
return this.baseMapper.selectLocDetlSumQty(locNo);
}
+
+ public LocDetl selectByMatnr(String matnr) {
+ return this.baseMapper.selectByMatnr(matnr);
+ }
}
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 0869303..557c698 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -319,5 +319,7 @@
where loc_no=#{locNo}
</select>
-
+ <select id="selectByMatnr" resultType="com.zy.asrs.entity.LocDetl">
+ select * from asr_loc_detl where matnr=#{matnr}
+ </select>
</mapper>
--
Gitblit v1.9.1