From db206a2503340f1044c400d17b042d39ec98dab3 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期一, 30 十月 2023 16:53:55 +0800
Subject: [PATCH] 中-38-BattMaintDealarmMapper.xml;226行
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 61 ++++++++++++++++++++++++++++++
1 files changed, 61 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index d57d7ee..0daa4c0 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -1,11 +1,13 @@
package com.whyc.service;
import com.whyc.dto.InterfaceParam;
+import com.whyc.dto.ReportBattDTO;
import com.whyc.dto.StandardFeatureCurve;
import com.whyc.dto.paramter.AlarmPar;
import com.whyc.dto.paramter.DevAlarmPar;
import com.whyc.dto.result.AlarmRes;
import com.whyc.dto.result.RealDateDTO;
+import com.whyc.dto.result.ReportBattResultDTO;
import com.whyc.mapper.CallBack;
import com.whyc.pojo.*;
import com.whyc.util.ActionUtil;
@@ -2812,4 +2814,63 @@
return list;
}
+ //38-BattMaintDealarmMapper.xml;226琛�
+ public List<ReportBattResultDTO> searchByBattGroupId5(ReportBattDTO dto){
+ String sql=" select distinct(db_battinf.tb_battinf.BattgroupId),moncount,moncapstd,monvolstd,monresstd,monserstd,FloatVolLevel,OfflineVolLevel " +
+ " ,db_batt_testdata.tb_battresdata_inf.battgroupid,db_batt_testdata.tb_battresdata_inf.test_record_count " +
+ " ,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".group_vol,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_curr" +
+ " ,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_starttime,mon_num,mon_vol,mon_tmp,mon_res,mon_ser,conn_res " +
+ " from " +
+ " db_battinf.tb_battinf,db_batt_testdata.tb_battresdata_inf,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+" " +
+ " where " +
+ " db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_battresdata_inf.BattGroupId " +
+ " and " +
+ " db_batt_testdata.tb_battresdata_inf.BattGroupId=db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".battgroupid " +
+ " and " +
+ " db_batt_testdata.tb_battresdata_inf.test_record_count=db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_record_count " +
+ " and db_battinf.tb_battinf.battgroupid="+dto.getBattGroupId()+" and " +
+ " db_batt_testdata.tb_battresdata_inf.data_available=1 and " +
+ " db_batt_testdata.tb_battresdata_inf.test_type="+dto.getTestType()+" " ;
+ if(dto.getMonNum()!=0){
+ sql+=" and db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".mon_num="+dto.getMonNum()+" ";
+ }
+ if(dto.getStationName1()!=null&&!dto.getStationName1().isEmpty()){
+ sql+=" and stationname1='"+dto.getStationName1()+"' ";
+ }
+ if(dto.getStationName()!=null&&!dto.getStationName().isEmpty()){
+ sql+=" and stationname='"+dto.getStationName()+"' ";
+ }
+ sql+=" order by db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_record_count asc,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".mon_num asc ";
+ List<ReportBattResultDTO> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List<ReportBattResultDTO> list=new ArrayList<>();
+ while (rs.next()){
+ ReportBattResultDTO ph=new ReportBattResultDTO();
+ ph.setBattGroupId(rs.getInt("battGroupId"));
+ ph.setMonCount(rs.getInt("moncount"));
+ ph.setMonCapStd(rs.getFloat("moncapstd"));
+ ph.setMonVolStd(rs.getFloat("monvolstd"));
+ ph.setMonResStd(rs.getFloat("monresstd"));
+ ph.setMonSerStd(rs.getFloat("monserstd"));
+ ph.setFloatVolLevel(rs.getFloat("FloatVolLevel"));
+ ph.setOfflineVolLevel(rs.getFloat("OfflineVolLevel"));
+ ph.setTestRecordCount(rs.getInt("test_record_count"));
+ ph.setTestStartTime(rs.getTimestamp("test_starttime"));
+ ph.setGroupVol(rs.getFloat("group_vol"));
+ ph.setTestCurr(rs.getFloat("test_curr"));
+ ph.setMonNum(rs.getInt("mon_num"));
+ ph.setMonVol(rs.getFloat("mon_vol"));
+ ph.setMonTmp(rs.getFloat("mon_tmp"));
+ ph.setMonSer(rs.getFloat("mon_ser"));
+ ph.setMonRes(rs.getFloat("mon_res"));
+ ph.setConnRes(rs.getFloat("conn_res"));
+ list.add(ph);
+ }
+ return list;
+ }
+ });
+ return list;
+ }
+
}
--
Gitblit v1.9.1