From 15973ad70499dba1d0a1696e9d10af950172207a Mon Sep 17 00:00:00 2001
From: songhuangfeng123 <shf18767906695@163.com>
Date: Fri, 01 Jul 2022 17:50:05 +0800
Subject: [PATCH] 新增类型查询
---
emergency/emergency-service/src/main/resource/config/mapper/emergency/EmergencyPlanInfoMapper.xml | 1 +
emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/db/EmergencyPlanDBQuery.java | 10 ++++++++++
emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/EmergencyPlanQuery.java | 10 ++++++++++
3 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/EmergencyPlanQuery.java b/emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/EmergencyPlanQuery.java
index 1ed6de9..96e30b1 100644
--- a/emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/EmergencyPlanQuery.java
+++ b/emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/EmergencyPlanQuery.java
@@ -4,6 +4,8 @@
private String name ;
+ private String type ;
+
public String getName() {
return name;
}
@@ -11,4 +13,12 @@
public void setName(String name) {
this.name = name;
}
+
+ public String getType() {
+ return type;
+ }
+
+ public void setType(String type) {
+ this.type = type;
+ }
}
diff --git a/emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/db/EmergencyPlanDBQuery.java b/emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/db/EmergencyPlanDBQuery.java
index e0af8b7..9ad1273 100644
--- a/emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/db/EmergencyPlanDBQuery.java
+++ b/emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/db/EmergencyPlanDBQuery.java
@@ -4,6 +4,8 @@
private String name ;
+ private String type ;
+
public String getName() {
return name;
}
@@ -11,4 +13,12 @@
public void setName(String name) {
this.name = name;
}
+
+ public String getType() {
+ return type;
+ }
+
+ public void setType(String type) {
+ this.type = type;
+ }
}
diff --git a/emergency/emergency-service/src/main/resource/config/mapper/emergency/EmergencyPlanInfoMapper.xml b/emergency/emergency-service/src/main/resource/config/mapper/emergency/EmergencyPlanInfoMapper.xml
index 2a46366..1271883 100644
--- a/emergency/emergency-service/src/main/resource/config/mapper/emergency/EmergencyPlanInfoMapper.xml
+++ b/emergency/emergency-service/src/main/resource/config/mapper/emergency/EmergencyPlanInfoMapper.xml
@@ -28,6 +28,7 @@
<select id="selectEmergencyPlanList" resultMap="pageResult">
select id,`name`,`type`,`level`,release_date from emergency_plan where del_flag = 0
<if test="query.name != null and query.name != ''"> and `name` like concat('%', #{query.name}, '%')</if>
+ <if test="query.type != null and query.type != ''"> and `type` = #{query.type}</if>
</select>
</mapper>
--
Gitblit v1.9.2