<insert id="saveEoceonfirmDetail" parameterType="java.util.List">
INSERT INTO OMS_OD_STOCKIN_ITEMS
(ID,
ORDER_ID,
ORDER_CODE,
GOODS_CODE,
GOODS_NAME,
ACCEPTABLE_QTY,
STOCKIN_DATE,
CREATED_BY,
CREATED_TIME,
VERSION,
IS_INACTIVE,
DEFECTIVE_QTY)
<foreach collection="list" item="item" index="index" open="(" close=")" separator="UNION ALL"> //传入的参数是List<Map<String, Object>>
(SELECT
#{item.id},
#{item.entry_order_id},
#{item.entry_order_code},
#{item.goods_code},
#{item.goods_name},
#{item.acceptable_qty},
<if test="item.stockin_date !=null and item.stockin_date !=''">
TO_TIMESTAMP( #{item.stockin_date},'YYYY-MM-DD HH24:MI:SS') ,
</if>
<if test="item.stockin_date ==null or item.stockin_date ==''">
sysdate,
</if>
'oms',
sysdate,
0,
0,
#{item.defective_qty}
FROM dual) //虚表
</foreach>
</insert>
INSERT INTO OMS_OD_STOCKIN_ITEMS
(ID,
ORDER_ID,
ORDER_CODE,
GOODS_CODE,
GOODS_NAME,
ACCEPTABLE_QTY,
STOCKIN_DATE,
CREATED_BY,
CREATED_TIME,
VERSION,
IS_INACTIVE,
DEFECTIVE_QTY)
<foreach collection="list" item="item" index="index" open="(" close=")" separator="UNION ALL"> //传入的参数是List<Map<String, Object>>
(SELECT
#{item.id},
#{item.entry_order_id},
#{item.entry_order_code},
#{item.goods_code},
#{item.goods_name},
#{item.acceptable_qty},
<if test="item.stockin_date !=null and item.stockin_date !=''">
TO_TIMESTAMP( #{item.stockin_date},'YYYY-MM-DD HH24:MI:SS') ,
</if>
<if test="item.stockin_date ==null or item.stockin_date ==''">
sysdate,
</if>
'oms',
sysdate,
0,
0,
#{item.defective_qty}
FROM dual) //虚表
</foreach>
</insert>