批量修改设备厂商类型

xiangpei

2024-08-26 abd5e9985bd0b4ac0d20ec16eaf2c5577790d6c9

批量修改设备厂商类型

 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);
}

 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=",">