skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DTO/SgDeviceSearchDTO.java
@@ -10,4 +10,5 @@ private String deviceName; private String deviceType; private String projectName; private String projectId; } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgDeviceMapper.xml
@@ -8,6 +8,9 @@ <if test="dto.projectName != null and dto.projectName != ''"> and project.project_name like CONCAT(CONCAT('%', #{dto.projectName}), '%') </if> <if test="dto.projectId != null and dto.projectId != ''"> and project.id = #{dto.projectId} </if> <if test="dto.deviceName != null and dto.deviceName != ''"> and ds.device_name like CONCAT(CONCAT('%', #{dto.deviceName}), '%') </if>
