批量修改

<update id="batchUpdateDipDiseOprnCrsp">
        UPDATE dip_dise_oprn_crsp_d
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="DISE_SCO = case" suffix="end,"> <!--修改对照病种分值-->
                <foreach collection="list" item="i">
                    <if test="i.diseSco != null and i.diseSco != ''">
                        when DISE_OPRN_CRSP_ID = #{i.diseOprnCrspId} then #{i.diseSco}
                    </if>
                </foreach>
            </trim>
            <trim prefix="ACT_DISE_SCO = case" suffix="end,"> <!--修改实际病种分值-->
                <foreach collection="list" item="i">
                    <if test="i.actDiseSco != null and i.actDiseSco != ''">
                        when DISE_OPRN_CRSP_ID = #{i.diseOprnCrspId} then #{i.actDiseSco}
                    </if>
                </foreach>
            </trim>
            <trim prefix="VALI_FLAG = case" suffix="end,"> <!--修改有效标识-->
                <foreach collection="list" item="i">
                    <if test="i.valiFlag != null and i.valiFlag != ''">
                        when DISE_OPRN_CRSP_ID = #{i.diseOprnCrspId} then #{i.valiFlag}
                    </if>
                </foreach>
            </trim>
        </trim>
        <where>
            <foreach collection="list" separator="or" item="i">
                DISE_OPRN_CRSP_ID = #{i.diseOprnCrspId}
            </foreach>
        </where>
    </update>