设备管理： 更改设置状态时 允许同时更新备注

eight

2024-12-18 14f87cf04b519fd33ef6f76ea5e2926f30fab419

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/devmanage/DeviceMapper.java

@@ -33,7 +33,7 @@
                .eqIfPresent(DeviceDO::getModel, reqVO.getModel())
                .betweenIfPresent(DeviceDO::getPurchaseDate, reqVO.getPurchaseDate())
                .betweenIfPresent(DeviceDO::getCreateTime, reqVO.getCreateTime())
                .orderByAsc(DeviceDO::getStateDate));
                .orderByAsc(DeviceDO::getDevId));
    }

    @Select("select * from lihu.device where dev_id=#{devId}")
@@ -42,8 +42,8 @@
    })
    DeviceDO getDeviceByDevId(@Param("devId") String devId);

    @Update("update lihu.device set state=#{state}, state_date=#{stateDate} where dev_id=#{devId}")
    Integer updateDevState(@Param("devId") String devId, @Param("state") Integer state, @Param("stateDate") LocalDate stateDate);
    @Update("update lihu.device set state=#{state}, state_date=#{stateDate}, comment=#{comment} where dev_id=#{devId}")
    Integer updateDevState(@Param("devId") String devId, @Param("state") Integer state, @Param("stateDate") LocalDate stateDate, @Param("comment") String comment);

    @Select("<script>" +
            "select category, state, count(1) as dev_count from lihu.device " +