<update id="batchupdateByPrimaryKey" parameterType="java.util.List" >
update tss_stockin_detail
<trim prefix="set" suffixOverrides="," >
<trim prefix="stockin_id =case" suffix="end, ">
<foreach collection="list" item="i" index="index">
<if test="i.stockinId!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.stockinId}
</if>
</foreach>
</trim>
<trim prefix="device_model_id =case" suffix="end," >
<foreach collection="list" item="i" index="index">
<if test="i.deviceModelId!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.deviceModelId}
</if>
</foreach>
</trim>
<trim prefix="stock_in_count =case" suffix="end," >
<foreach collection="list" item="i" index="index">
<if test="i.stockInCount!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.stockInCount}
</if>
</foreach>
</trim>
<trim prefix="return_count =case" suffix="end," >
<foreach collection="list" item="i" index="index">
<if test="i.returnCount!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.returnCount}
</if>
</foreach>
</trim>
<trim prefix="return_stockout_id =case" suffix="end," >
<foreach collection="list" item="i" index="index">
<if test="i.returnStockOutId!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.returnStockOutId}
</if>
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="i" index="index" >
stockin_detail_id=#{i.stockinDetailId}
</foreach>
</update>
update tss_stockin_detail
<trim prefix="set" suffixOverrides="," >
<trim prefix="stockin_id =case" suffix="end, ">
<foreach collection="list" item="i" index="index">
<if test="i.stockinId!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.stockinId}
</if>
</foreach>
</trim>
<trim prefix="device_model_id =case" suffix="end," >
<foreach collection="list" item="i" index="index">
<if test="i.deviceModelId!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.deviceModelId}
</if>
</foreach>
</trim>
<trim prefix="stock_in_count =case" suffix="end," >
<foreach collection="list" item="i" index="index">
<if test="i.stockInCount!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.stockInCount}
</if>
</foreach>
</trim>
<trim prefix="return_count =case" suffix="end," >
<foreach collection="list" item="i" index="index">
<if test="i.returnCount!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.returnCount}
</if>
</foreach>
</trim>
<trim prefix="return_stockout_id =case" suffix="end," >
<foreach collection="list" item="i" index="index">
<if test="i.returnStockOutId!=null">
when stockin_detail_id=#{i.stockinDetailId} then #{i.returnStockOutId}
</if>
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="i" index="index" >
stockin_detail_id=#{i.stockinDetailId}
</foreach>
</update>