From 35313ffe430ad0ef6799c60316ce2d7bdfa8b855 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期一, 02 九月 2024 13:55:08 +0800
Subject: [PATCH] excel导入单据
---
src/main/java/com/zy/asrs/importexcle/LocMatListener.java | 25 +++++++++++++++++--------
1 files changed, 17 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/zy/asrs/importexcle/LocMatListener.java b/src/main/java/com/zy/asrs/importexcle/LocMatListener.java
index 502cfbc..c4775e8 100644
--- a/src/main/java/com/zy/asrs/importexcle/LocMatListener.java
+++ b/src/main/java/com/zy/asrs/importexcle/LocMatListener.java
@@ -87,6 +87,9 @@
List<LocDetl> locDetls = new ArrayList<>();
list.forEach(locMat -> {
LocMast locMast = locMastService.selectById(locMat.getA());
+ if (locMast == null) {
+ throw new CoolException(locMat.getA() + ":搴撲綅涓嶅瓨鍦紒");
+ }
if (!locMast.getLocSts().equals("O")) {
throw new CoolException(locMat.getA() + ":搴撲綅涓嶄负绌猴紒");
}
@@ -94,19 +97,25 @@
if ("F".equals(locMat.getB())) {
LocDetl locDetl = new LocDetl();
locDetl.setLocNo(locMat.getA());
- locDetl.setZpallet("test" + num);
- locDetl.setAnfme(1.0);
locDetl.setMatnr("3渭m脳10mm");
locDetl.setMaktx("3渭m脳10mm");
- locDetl.setBatch("t" + num);
- locDetl.setSpecs("1");
- locDetl.setModel("t" + num);
- locDetl.setColor(locMat.getC()); // 鏈ㄧ绫诲瀷
- locDetl.setBrand("t" + num);
- locDetl.setPrice(800.0);
+ String flag = "A" + num;
+ locDetl.setUnit(flag);
+ locDetl.setModel(flag);
+ locDetl.setBrand(flag);
locDetl.setOrigin("涓�");
+ locDetl.setColor(locMat.getC());
+ locDetl.setManu("A");
+ locDetl.setSku("10");
+ locDetl.setItemNum("10");
+ locDetl.setManuDate("2024-02-01 23:12:21");
locDetl.setWeight(900.0);
locDetl.setVolume(1000.0);
+ locDetl.setSpecs("1");
+ locDetl.setLength(800.0);
+ locDetl.setZpallet(flag);
+ locDetl.setBarcode(flag);
+ locDetl.setAnfme(1.0);
locDetl.setModiTime(now);
locDetl.setModiUser(userId);
locDetl.setAppeTime(now);
--
Gitblit v1.9.1