| | |
| | | default PageResult<DeviceDO> selectPage(DevicePageReqVO reqVO) { |
| | | return selectPage(reqVO, new LambdaQueryWrapperX<DeviceDO>() |
| | | .eqIfPresent(DeviceDO::getDevId, reqVO.getDevId()) |
| | | .eqIfPresent(DeviceDO::getState, reqVO.getState()) |
| | | .inIfPresent(DeviceDO::getState, reqVO.getState()) |
| | | .eqIfPresent(DeviceDO::getCategory, reqVO.getCategory()) |
| | | .eqIfPresent(DeviceDO::getBrand, reqVO.getBrand()) |
| | | .eqIfPresent(DeviceDO::getModel, reqVO.getModel()) |
| | | .betweenIfPresent(DeviceDO::getPurchaseDate, reqVO.getPurchaseDate()) |
| | | .betweenIfPresent(DeviceDO::getCreateTime, reqVO.getCreateTime()) |
| | | .orderByDesc(DeviceDO::getId)); |
| | | .orderByAsc(DeviceDO::getStateDate)); |
| | | } |
| | | |
| | | @Select("select * from lihu.device where dev_id=#{devId}") |