From ff1ed10ebcb27f4039fb121486261c0b24208baf Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期一, 22 七月 2024 10:43:25 +0800
Subject: [PATCH] 蓄电池单体容量
---
src/main/java/com/whyc/service/SubTableService.java | 36 ++++++++++++++++++++++++++++++++++++
1 files changed, 36 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTableService.java b/src/main/java/com/whyc/service/SubTableService.java
index 6f2d1e2..89eecbe 100644
--- a/src/main/java/com/whyc/service/SubTableService.java
+++ b/src/main/java/com/whyc/service/SubTableService.java
@@ -3,6 +3,7 @@
import com.whyc.mapper.CallBack;
import com.whyc.pojo.BattAlarmHis;
import com.whyc.pojo.BattTestInfData;
+import com.whyc.util.ActionUtil;
import com.whyc.util.ThreadLocalUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -112,4 +113,39 @@
});
return list;
}
+ //鍙栬鍗曚綋鏈�鍚庝竴绗旀斁鐢佃褰�
+ public BattTestInfData getMonNumData(int binfId, Integer testRecordCount, Integer recordNum, int monNum) {
+ String sql="select * from db_dis_batt.batt_test_inf_"+binfId+" " +
+ " where binf_id="+binfId+" " +
+ " and test_record_count="+testRecordCount+
+ " and record_num="+recordNum+
+ " and mon_num="+monNum;
+ List<BattTestInfData> list=sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List list=new ArrayList();
+ while (rs.next()){
+ BattTestInfData data=new BattTestInfData();
+ data.setNum(rs.getInt("num"));
+ data.setBinfId(rs.getInt("binf_id"));
+ data.setTestRecordCount(rs.getInt("test_record_count"));
+ data.setTestStarttime(rs.getTimestamp("test_starttime"));
+ data.setRecordTime(rs.getTimestamp("record_time"));
+ data.setTestType(rs.getInt("test_type"));
+ data.setRecordNum(rs.getInt("record_num"));
+ data.setTestTimelong(rs.getInt("test_timelong"));
+ data.setOnlineVol(rs.getFloat("online_vol"));
+ data.setGroupVol(rs.getFloat("group_vol"));
+ data.setTestCurr(rs.getFloat("test_curr"));
+ data.setTestCap(rs.getFloat("test_cap"));
+ data.setMonNum(rs.getInt("mon_num"));
+ data.setMonVol(rs.getFloat("mon_vol"));
+ data.setMonTmp(rs.getFloat("mon_tmp"));
+ list.add(data);
+ }
+ return list;
+ }
+ });
+ return list.stream().findFirst().orElse((BattTestInfData) ActionUtil.objeNull);
+ }
}
\ No newline at end of file
--
Gitblit v1.9.1