From 2d2e2d34d2d0a3029f4943bbe9b762804dc13095 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期四, 19 十月 2023 15:18:18 +0800
Subject: [PATCH] 115
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 86 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 86 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 0069f4e..dc4a465 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -1721,4 +1721,90 @@
}
sqlExecuteService.execute(sql);
}
+
+ //115-PwrdevDataHistoryService.java;89琛�
+ public List<PwrdevDataHistory> getWeekOrDayData( String tableName,Date startTime,Date endTime){
+ String sql=" select * from db_pwrdev_data_history."+tableName+" where record_time>='"+ActionUtil.sdf.format(startTime)+"' and record_time<='"+ActionUtil.sdf.format(endTime)+"' ";
+ List<PwrdevDataHistory> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List<PwrdevDataHistory> list=new ArrayList<>();
+ while (rs.next()){
+ PwrdevDataHistory ph=new PwrdevDataHistory();
+ ph.setNum(rs.getInt("num"));
+ ph.setPowerDeviceId(rs.getInt("PowerDeviceId"));
+ ph.setRecordTime(rs.getTimestamp("record_time"));
+ ph.setAcAcIn1VolA(rs.getFloat("AC_acIn1_volA"));
+ ph.setAcAcIn1VolB(rs.getFloat("AC_acIn1_volB"));
+ ph.setAcAcIn1VolC(rs.getFloat("AC_acIn1_volC"));
+ ph.setAcAcIn1CurrA(rs.getFloat("AC_acIn1_currA"));
+ ph.setAcAcIn1CurrB(rs.getFloat("AC_acIn1_currB"));
+ ph.setAcAcIn1CurrC(rs.getFloat("AC_acIn1_currC"));
+ ph.setAcAcIn2VolA(rs.getFloat("AC_acIn2_volA"));
+ ph.setAcAcIn2VolB(rs.getFloat("AC_acIn2_volB"));
+ ph.setAcAcIn2VolC(rs.getFloat("AC_acIn2_volC"));
+ ph.setAcAcIn2CurrA(rs.getFloat("AC_acIn2_currA"));
+ ph.setAcAcIn2CurrB(rs.getFloat("AC_acIn2_currB"));
+ ph.setAcAcIn2CurrC(rs.getFloat("AC_acIn2_currC"));
+ ph.setAcTemprature(rs.getFloat("AC_temprature"));
+ ph.setAcAcVolHLimit(rs.getFloat("AC_acVolH_Limit"));
+ ph.setAcAcVolLLimit(rs.getFloat("AC_acVolL_Limit"));
+ ph.setAcdcAcIn1VolA(rs.getFloat("ACDC_acIn1_volA"));
+ ph.setAcdcAcIn1VolB(rs.getFloat("ACDC_acIn1_volB"));
+ ph.setAcdcAcIn1VolC(rs.getFloat("ACDC_acIn1_volC"));
+ ph.setAcdcAcIn2VolA(rs.getFloat("ACDC_acIn2_volA"));
+ ph.setAcdcAcIn2VolB(rs.getFloat("ACDC_acIn2_volB"));
+ ph.setAcdcAcIn2VolC(rs.getFloat("ACDC_acIn2_volC"));
+ ph.setAcdcAcOutVolA(rs.getFloat("ACDC_acOut_volA"));
+ ph.setAcdcAcOutVolB(rs.getFloat("ACDC_acOut_volB"));
+ ph.setAcdcAcOutVolC(rs.getFloat("ACDC_acOut_volC"));
+ ph.setAcdcAcOutCurrA(rs.getFloat("ACDC_acOut_currA"));
+ ph.setAcdcAcOutCurrB(rs.getFloat("ACDC_acOut_currB"));
+ ph.setAcdcAcOutCurrC(rs.getFloat("ACDC_acOut_currC"));
+ ph.setAcdcDcOutVol(rs.getFloat("ACDC_dcOut_vol"));
+ ph.setAcdcLoaderCurr(rs.getFloat("ACDC_loader_curr"));
+ ph.setAcdcBattgroup1Vol(rs.getFloat("ACDC_battgroup1_vol"));
+ ph.setAcdcBattgroup1Curr(rs.getFloat("ACDC_battgroup1_curr"));
+ ph.setAcdcBattgroup2Vol(rs.getFloat("ACDC_battgroup2_vol"));
+ ph.setAcdcBattgroup2Curr(rs.getFloat("ACDC_battgroup2_curr"));
+ ph.setAcdcAcdcmTemp(rs.getFloat("ACDC_acdcm_temp"));
+ ph.setAcdcM1OutCurr(rs.getFloat("ACDC_m1_outCurr"));
+ ph.setAcdcM2OutCurr(rs.getFloat("ACDC_m2_outCurr"));
+ ph.setAcdcM3OutCurr(rs.getFloat("ACDC_m3_outCurr"));
+ ph.setAcdcM4OutCurr(rs.getFloat("ACDC_m4_outCurr"));
+ ph.setAcdcM5OutCurr(rs.getFloat("ACDC_m5_outCurr"));
+ ph.setAcdcM6OutCurr(rs.getFloat("ACDC_m6_outCurr"));
+ ph.setAcdcM7OutCurr(rs.getFloat("ACDC_m7_outCurr"));
+ ph.setAcdcM8OutCurr(rs.getFloat("ACDC_m8_outCurr"));
+ ph.setAcdcM9OutCurr(rs.getFloat("ACDC_m9_outCurr"));
+ ph.setAcdcM10OutCurr(rs.getFloat("ACDC_m10_outCurr"));
+ ph.setAcdcM11OutCurr(rs.getFloat("ACDC_m11_outCurr"));
+ ph.setAcdcM12OutCurr(rs.getFloat("ACDC_m12_outCurr"));
+ ph.setAcdcM13OutCurr(rs.getFloat("ACDC_m13_outCurr"));
+ ph.setAcdcM14OutCurr(rs.getFloat("ACDC_m14_outCurr"));
+ ph.setAcdcM15OutCurr(rs.getFloat("ACDC_m15_outCurr"));
+ ph.setAcdcM16OutCurr(rs.getFloat("ACDC_m16_outCurr"));
+ ph.setAcdcChargLimitCurr(rs.getFloat("ACDC_chargLimitCurr"));
+ ph.setAcdcJunChargeVol(rs.getFloat("ACDC_junChargeVol"));
+ ph.setAcdcFloatChargeVol(rs.getFloat("ACDC_floatChargeVol"));
+ ph.setAcdcAcVolHLimit(rs.getFloat("ACDC_acVolH_Limit"));
+ ph.setAcdcAcVolLLimit(rs.getFloat("ACDC_acVolL_Limit"));
+ ph.setAcdcDcOutVolHLimit(rs.getFloat("ACDC_dcOutVolH_Limit"));
+ ph.setAcdcDcOutVolLLimit(rs.getFloat("ACDC_dcOutVolL_Limit"));
+ ph.setDcDcIn1Vol(rs.getFloat("DC_dcIn1_vol"));
+ ph.setDcDcIn2Vol(rs.getFloat("DC_dcIn2_vol"));
+ ph.setDcDcOut1Vol(rs.getFloat("DC_dcOut1_vol"));
+ ph.setDcDcOut1Curr(rs.getFloat("DC_dcOut1_curr"));
+ ph.setDcDcOut2Vol(rs.getFloat("DC_dcOut2_vol"));
+ ph.setDcDcOut2Curr(rs.getFloat("DC_dcOut2_curr"));
+ ph.setDcTemprature(rs.getFloat("DC_temprature"));
+ ph.setDcDcVolHLimit(rs.getFloat("DC_dcVolH_Limit"));
+ ph.setDcDcVolLLimit(rs.getFloat("DC_dcVolL_Limit"));
+ list.add(ph);
+ }
+ return list;
+ }
+ });
+ return list;
+ }
}
--
Gitblit v1.9.1