成品入库和界面显示

pang.jiabao

2024-08-14 0dba85880e21d1a42fd2667590b5168c54bdc7e9

成品入库和界面显示

 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},