648540858
2023-03-21 3e4d2b682c7c3aeb3dcc181a922e90cde2e6f6b6
Merge pull request #783 from StreamLuna/wvp-28181-2.0

fix: 根据国标设备编号查询设备没有返回通道数
1个文件已修改
3 ■■■■ 已修改文件
src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java 3 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java
@@ -42,7 +42,8 @@
            "asMessageChannel," +
            "geoCoordSys," +
            "treeType," +
            "online" +
            "online," +
            "(SELECT count(0) FROM device_channel WHERE deviceId=device.deviceId) as channelCount "+
            " FROM device WHERE deviceId = #{deviceId}")
    Device getDeviceByDeviceId(String deviceId);