From b341245d84fb1e4743e8d34bc9a4f742b0fb9a5e Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期四, 29 五月 2025 11:00:39 +0800
Subject: [PATCH] 电压上一季度历史实时
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 22 +++++++++++++++++++++-
1 files changed, 21 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 218cd68..99d43ed 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -4,9 +4,11 @@
import com.whyc.dto.AlmHis.BattAlmPar;
import com.whyc.dto.AlmHis.DevAlmPar;
import com.whyc.dto.AlmHis.PwrAlmPar;
+import com.whyc.dto.Real.QuarterData;
import com.whyc.mapper.CallBack;
import com.whyc.pojo.db_alarm.BattalarmDataHistory;
import com.whyc.pojo.db_alarm.DevalarmDataHistory;
+import com.whyc.pojo.db_data_history.BattRealdataId;
import com.whyc.pojo.db_pwrdev_alarm.PwrdevAlarmHistory;
import com.whyc.util.ThreadLocalUtil;
import org.springframework.beans.factory.annotation.Autowired;
@@ -465,5 +467,23 @@
});
return list;
}
-
+ //鑾峰彇鐢垫睜缁勬煇涓�骞存湀鐨勬暟鎹�
+ public List<QuarterData> getBattRealHis(String tableName,String columnName) {
+ String sql="select distinct mon_num,record_time,"+columnName+" from "+tableName+" order by record_time asc";
+ List<QuarterData> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List<QuarterData> list=new ArrayList<>();
+ while (rs.next()){
+ QuarterData data=new QuarterData();
+ data.setRecordTime(rs.getTimestamp("record_time"));
+ data.setNumValue(rs.getFloat(columnName));
+ data.setMonNum(rs.getInt("mon_num"));
+ list.add(data);
+ }
+ return list;
+ }
+ });
+ return list;
+ }
}
--
Gitblit v1.9.1