From 4b3d8d360638073683eef4260be228dd2a9f541b Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期四, 27 三月 2025 10:06:48 +0800
Subject: [PATCH] 电源查询增加站点字段
---
src/main/java/com/whyc/mapper/PowerInfMapper.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/mapper/PowerInfMapper.java b/src/main/java/com/whyc/mapper/PowerInfMapper.java
index 356c8cb..9116478 100644
--- a/src/main/java/com/whyc/mapper/PowerInfMapper.java
+++ b/src/main/java/com/whyc/mapper/PowerInfMapper.java
@@ -12,4 +12,13 @@
@Select("select distinct producer from db_batt.power_inf where producer is not null")
List<String> getProducerList();
+
+ @Select("SELECT s.sinf_name as station_name,p.*,p.binf_id as battGroupId,p.binf_name as battGroupName from db_batt.power_inf p,db_batt.sinf_pinf sp,db_batt.station_inf s\n" +
+ "where p.power_id = sp.pinf_id and sp.sinf_id = s.sinf_id")
+ List<PowerInf> getList();
+
+ @Select("SELECT s.sinf_name as station_name,p.*,p.binf_id as battGroupId,p.binf_name as battGroupName from db_batt.power_inf p,db_batt.sinf_pinf sp,db_batt.station_inf s\n" +
+ "where p.power_id = sp.pinf_id and sp.sinf_id = s.sinf_id and power_id = #{powerId}")
+ PowerInf getById(int powerId);
+
}
\ No newline at end of file
--
Gitblit v1.9.1