From dee0bff47af3c0b84b2e97c595cbb45e0cd500b1 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期六, 02 十一月 2024 14:26:48 +0800
Subject: [PATCH] 批量导入
---
src/main/java/com/zy/asrs/importexcle/LocMatListener.java | 7 +++++--
src/main/resources/mapper/LocDetlMapper.xml | 3 ++-
2 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/zy/asrs/importexcle/LocMatListener.java b/src/main/java/com/zy/asrs/importexcle/LocMatListener.java
index c4775e8..e9686ba 100644
--- a/src/main/java/com/zy/asrs/importexcle/LocMatListener.java
+++ b/src/main/java/com/zy/asrs/importexcle/LocMatListener.java
@@ -26,7 +26,7 @@
/**
* 姣忛殧1000鏉″瓨鍌ㄦ暟鎹簱锛屽疄闄呬娇鐢ㄤ腑鍙互3000鏉★紝鐒跺悗娓呯悊list 锛屾柟渚垮唴瀛樺洖鏀�
*/
- private static final int BATCH_COUNT = 400;
+ private static final int BATCH_COUNT = 50;
private static int num = 1;
@@ -99,13 +99,14 @@
locDetl.setLocNo(locMat.getA());
locDetl.setMatnr("3渭m脳10mm");
locDetl.setMaktx("3渭m脳10mm");
+ locDetl.setBatch("");
String flag = "A" + num;
locDetl.setUnit(flag);
locDetl.setModel(flag);
locDetl.setBrand(flag);
locDetl.setOrigin("涓�");
locDetl.setColor(locMat.getC());
- locDetl.setManu("A");
+ locDetl.setManu(flag);
locDetl.setSku("10");
locDetl.setItemNum("10");
locDetl.setManuDate("2024-02-01 23:12:21");
@@ -123,11 +124,13 @@
// 娣诲姞杩涘簱瀛樻槑缁嗗垪琛�
locDetls.add(locDetl);
+ locMast.setBarcode(flag);
num ++;
}
// 鏇存柊搴撲綅鐘舵��
locMast.setLocSts(locMat.getB());
+
locMastService.updateById(locMast);
});
// 鎵归噺鎻掑叆搴撳瓨鏄庣粏
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index e4e21c2..12b6f31 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -59,7 +59,7 @@
</sql>
<insert id="batchDetls">
INSERT INTO
- asr_loc_detl(loc_no,zpallet,barcode,anfme,matnr,maktx,unit,specs,model,color,manu,sku,brand
+ asr_loc_detl(loc_no,zpallet,barcode,batch,anfme,matnr,maktx,unit,specs,model,color,manu,sku,brand
,origin,item_num,manu_date,weight,volume,length,modi_time,modi_user,appe_time,appe_user)
VALUES
<foreach collection="locDetls" item="item" index="index" separator=",">
@@ -67,6 +67,7 @@
#{item.locNo},
#{item.zpallet},
#{item.barcode},
+ #{item.batch},
#{item.anfme},
#{item.matnr},
#{item.maktx},
--
Gitblit v1.9.1