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