From a31dec66b5d858e8bfeb98b81c7cab863205906a Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期一, 30 十月 2023 13:27:15 +0800
Subject: [PATCH] 中-15-BattResDataMapper.xml;15行
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 8fbf7e0..f4a56d5 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -2029,4 +2029,28 @@
" values( "+elePrice.getTmpId()+",'"+ThreadLocalUtil.format(elePrice.getTmpStarttime(),4)+"','"+ThreadLocalUtil.format(elePrice.getTmpStoptime(),4)+"',"+elePrice.getElePrice()+")";
sqlExecuteService.execute(sql);
}
+ //15-BattResDataMapper.xml;15琛�
+ public BattResData getMinInfo(Integer battGroupId, Integer testRecordCount){
+ String sql=" select mon_num ,mon_vol from db_batt_testdata.tb_battresdata_"+battGroupId+" " +
+ " where mon_vol=(select min(mon_vol) from db_batt_testdata.tb_battresdata_"+battGroupId+" where test_record_count="+testRecordCount+" ) limit 1";
+ List<BattResData> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List<BattResData> list=new ArrayList<>();
+ while (rs.next()){
+ BattResData bh=new BattResData();
+ bh.setMonNum(rs.getInt("mon_num"));
+ bh.setMonVol(rs.getFloat("mon_vol"));
+ list.add(bh);
+ }
+ return list;
+ }
+ });
+ BattResData bres=null;
+ if(list!=null&&list.size()>0){
+ bres=list.get(0);
+ }
+ return bres;
+
+ }
}
--
Gitblit v1.9.1