From 0dba85880e21d1a42fd2667590b5168c54bdc7e9 Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期三, 14 八月 2024 10:40:46 +0800
Subject: [PATCH] 成品入库和界面显示
---
src/main/resources/mapper/LocDetlMapper.xml | 13 +++++++++----
1 files changed, 9 insertions(+), 4 deletions(-)
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 6a04062..fd62acb 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -59,25 +59,30 @@
</sql>
<insert id="batchDetls">
INSERT INTO
- asr_loc_detl(loc_no,zpallet,anfme,matnr,maktx,batch,specs,model,color,brand,price
- ,origin,weight,volume,modi_time,modi_user,appe_time,appe_user)
+ asr_loc_detl(loc_no,zpallet,barcode,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=",">
(
#{item.locNo},
#{item.zpallet},
+ #{item.barcode},
#{item.anfme},
#{item.matnr},
#{item.maktx},
- #{item.batch},
+ #{item.unit},
#{item.specs},
#{item.model},
#{item.color},
+ #{item.manu},
+ #{item.sku},
#{item.brand},
- #{item.price},
#{item.origin},
+ #{item.itemNum},
+ #{item.manuDate},
#{item.weight},
#{item.volume},
+ #{item.length},
#{item.modiTime},
#{item.modiUser},
#{item.appeTime},
--
Gitblit v1.9.1