From e6cd256f189c1cd43fec2c45b2c35b16861e22f8 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期二, 05 十一月 2024 15:05:35 +0800
Subject: [PATCH] 国网电源获取当前天负载电流的平均值
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 24 +++++++++++++++++++++++-
1 files changed, 23 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index e4d8bf5..3e35c9a 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -4208,5 +4208,27 @@
}
sqlExecuteService.makeManualCommit(sql_str);
}
-
+ //鑾峰彇褰撳墠澶╁钩鍧囪礋杞界數娴�
+ public Float getAvgLoadCurr(Integer powerId, String tableName) {
+ String sql=" select avg(load_curr) as avgCurr from "+tableName +" where DATE(record_time) = CURDATE() ";
+ List<Float> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List list=new ArrayList<>();
+ try {
+ while (rs.next()){
+ list.add(rs.getFloat("avgCurr"));
+ }
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ return list;
+ }
+ });
+ float avgCurr=0f;
+ if (list!=null){
+ avgCurr=list.get(0);
+ }
+ return avgCurr;
+ }
}
--
Gitblit v1.9.1