批量修改
<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>