sql server循环修改语句

<update id="updateBOMInventory" parameterType="java.util.List">
        UPDATE BOMInventory
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="BenefMaterialL =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    <if test="item.benefMaterialL !=null ">
                        when BarCodeID=#{item.barCodeID} then #{item.benefMaterialL}
                    </if>
                </foreach>
            </trim>
            <trim prefix="BenefMaterialW =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    <if test="item.benefMaterialW !=null ">
                        when BarCodeID=#{item.barCodeID} then #{item.benefMaterialW}
                    </if>
                </foreach>
            </trim>
            <trim prefix="BenefMaterialH =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    <if test="item.benefMaterialH !=null ">
                        when BarCodeID=#{item.barCodeID} then #{item.benefMaterialH}
                    </if>
                </foreach>
            </trim>
            <trim prefix="RoughMaterialL =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    <if test="item.roughMaterialL !=null ">
                        when BarCodeID=#{item.barCodeID} then #{item.roughMaterialL}
                    </if>
                </foreach>
            </trim>
            <trim prefix="RoughMaterialW =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    <if test="item.roughMaterialW !=null ">
                        when BarCodeID=#{item.barCodeID} then #{item.roughMaterialW}
                    </if>
                </foreach>
            </trim>
            <trim prefix="RoughMaterialH =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    <if test="item.roughMaterialH !=null ">
                        when BarCodeID=#{item.barCodeID} then #{item.roughMaterialH}
                    </if>
                </foreach>
            </trim>
        </trim>
        where BarCodeID in
        <foreach collection="list" index="index" item="item" separator="," open="(" close=")">
            #{item.barCodeID}
        </foreach>
    </update>