/** * 批量修改物流状态和物流踪迹 * * @param recordList List * @return Integer */ Integer updateStatusBatch(@Param("recordList") List<LogisticsRecordDO> recordList);
<update id="updateStatusBatch"> UPDATE dm_logistics_record <trim prefix="set" suffixOverrides=","> <trim prefix="delivery_status =case" suffix="end,"> <foreach collection="recordList" item="recordDo" index="index"> <if test="recordDo.deliveryStatus!=null"> when record_Id=#{recordDo.recordId} then #{recordDo.deliveryStatus} </if> </foreach> </trim> <trim prefix="trans_info =case" suffix="end,"> <foreach collection="recordList" item="recordDo" index="index"> <if test="recordDo.transInfo!=null"> when record_Id=#{recordDo.recordId} then #{recordDo.transInfo} </if> </foreach> </trim> </trim> where record_id in <foreach collection="recordList" item="recordDo" open="(" close=")" separator=","> #{recordDo.recordId, jdbcType=BIGINT} </foreach> </update>