From abd5e9985bd0b4ac0d20ec16eaf2c5577790d6c9 Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期一, 26 八月 2024 19:51:26 +0800 Subject: [PATCH] 批量修改设备厂商类型 --- ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 7 +++++++ ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml | 10 ++++++++++ 2 files changed, 17 insertions(+), 0 deletions(-) diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java index 6e66a2a..239924e 100644 --- a/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java +++ b/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java @@ -131,4 +131,11 @@ void deleteAll(); + /** + * 鎵归噺淇敼璁惧鍘傚晢绫诲瀷 + * + * @param list + * @return + */ + int batchUpdateDeviceType(@Param("list") List<TMonitor> list); } diff --git a/ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml index bffff72..b97bffc 100644 --- a/ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml +++ b/ycl-server/src/main/resources/mapper/zgyw/TMonitorMapper.xml @@ -223,6 +223,16 @@ </trim> </insert> + <update id="batchUpdateDeviceType"> + <foreach collection="list" separator=";" item="item"> + UPDATE t_monitor + SET + update_time = #{item.updateTime}, + device_type = #{item.deviceType} + WHERE id = #{item.id} + </foreach> + </update> + <update id="updateTMonitor" parameterType="com.ycl.platform.domain.entity.TMonitor"> update t_monitor <trim prefix="SET" suffixOverrides=","> -- Gitblit v1.8.0