From f81fdb2a20dfd6dfe8c897c4d115c488fd1f762b Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期二, 20 五月 2025 16:23:30 +0800
Subject: [PATCH] 查询信息加stationName，powerType，stationType
---
src/main/java/com/whyc/dto/BattDto.java | 2 ++
src/main/resources/mapper/BattInfMapper.xml | 13 +++++++------
2 files changed, 9 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/whyc/dto/BattDto.java b/src/main/java/com/whyc/dto/BattDto.java
index 0e75a51..0cba4ef 100644
--- a/src/main/java/com/whyc/dto/BattDto.java
+++ b/src/main/java/com/whyc/dto/BattDto.java
@@ -8,6 +8,8 @@
private String city;
private String country;
private String stationName;
+ private Integer powerType;
+ private String stationType;
private String powerName;
private String battgroupName;
private Integer pageNum;
diff --git a/src/main/resources/mapper/BattInfMapper.xml b/src/main/resources/mapper/BattInfMapper.xml
index ec4b54d..e660dc9 100644
--- a/src/main/resources/mapper/BattInfMapper.xml
+++ b/src/main/resources/mapper/BattInfMapper.xml
@@ -29,15 +29,16 @@
<if test="country!=null">
and tb_station_inf.country=#{country}
</if>
- <!-- <if test="stationName!=null">
+ <if test="stationName!=null">
and tb_station_inf.station_name like concat('%',#{stationName},'%')
</if>
- <if test="powerName!=null">
- and tb_power_inf.power_name like concat('%',#{powerName},'%')
+ <if test="stationType!=null">
+ and tb_station_inf.station_type like concat('%',#{stationType},'%')
</if>
- <if test="battgroupName!=null">
- and tb_batt_inf.battgroup_name like concat('%',#{battgroupName},'%')
- </if>-->
+ <if test="powerType!=null">
+ and tb_power_inf.power_type like concat('%',#{powerType},'%')
+ </if>
+
<if test="uid>100">
and tb_power_inf.power_id in(
select distinct power_id from db_user.tb_baojigroup_power,db_user.tb_baojigroup_usr
--
Gitblit v1.9.1