From 83dd955cdd9b8f34fcfd9152eff71740a919eca2 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期三, 18 十月 2023 11:17:00 +0800
Subject: [PATCH] 66
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 48 ++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 46 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 85150fd..0cf7af3 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -943,7 +943,7 @@
sqlExecuteService.execute(sql);
}
- //29-SubTablePageInfoUtils.java;104琛�
+ //29,65-SubTablePageInfoUtils.java;104琛�
public int getCountForTX(PwrdevAlarmHistory param){
String sql="select count(distinct alarm.num) as number from db_pwrdev_alarm."+param.getRecordYear()+" alarm,db_pwrdev_inf.tb_pwrdev_inf inf " +
" where alarm.PowerDeviceId = inf.PowerDeviceId ";
@@ -1046,7 +1046,7 @@
return list;
}
- //34锛�51-SubTablePageInfoUtils.java;121琛�
+ //34锛�51,64-SubTablePageInfoUtils.java;121琛�
public int getCountForInterface(InterfaceParam param){
String sql="SELECT count(*) as number FROM db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
" where history.dev_id=db_battinf.tb_battinf.FbsDeviceId ";
@@ -1461,4 +1461,48 @@
});
return list;
}
+
+ //66-SubTablePageInfoUtils.java;80琛�
+ public int getCount(AlarmPar param){
+ String sql="select count(distinct history.num) as number " +
+ " from db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
+ " where history.battgroupid=db_battinf.tb_battinf.battgroupid " +
+ " and alm_id in("+param.getAlmIdOne()+","+param.getAlmIdTwo()+", "+param.getAlmIdThree()+ ", "+param.getAlmIdFour()+ ", "+param.getAlmIdFive()+ ", "+param.getAlmIdSix()+ ", "+param.getAlmIdSeven()+ ", "+param.getAlmIdEight()+ ") " +
+ " and alm_signal_id%2 in("+param.getAlmSignalIdOne()+","+param.getAlmSignalIdTwo()+") " +
+ " and alm_level in( "+param.getAlmLevelOne()+ ", "+param.getAlmLevelTwo()+ ", "+param.getAlmLevelThree()+ ", "+param.getAlmLevelFour()+ ") " +
+ " and alm_start_time>='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' and alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' " +
+ " and db_battinf.tb_battinf.stationname1 like '%"+param.getStationname1()+"%' " +
+ " and db_battinf.tb_battinf.stationname like '%"+param.getStationname()+"%' ";
+ if(param.getBattGroupId()==0){
+ sql+=" and db_battinf.tb_battinf.battgroupid!="+param.getBattGroupId()+" ";
+ }else{
+ sql+=" and db_battinf.tb_battinf.battgroupid="+param.getBattGroupId()+" ";
+ }
+ sql+=" and history.BattGroupId " +
+ " in(select distinct db_battinf.tb_battinf.battgroupid from " +
+ " db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf " +
+ " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
+ " and " +
+ " db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
+ " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid and db_user.tb_user_inf.uid="+param.getUId()+" " +
+ " )";
+ List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ LinkedList<Object> temp = new LinkedList<>();
+ try {
+ while (rs.next())
+ temp.add(rs.getInt("number"));
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ return temp;
+ }
+ });
+ int num =0;
+ if(list!=null){
+ num= (int) list.get(0);
+ }
+ return num;
+ }
}
--
Gitblit v1.9.1