代码提交

liusheng

2025-09-15 3d1344ca6f0613bf3726d2c40d35f3928f82a910

 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 " +