From 19516e371e9b2bc3389a32111e45f0b28a43b82a Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期二, 17 十月 2023 11:07:15 +0800
Subject: [PATCH] 16
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 60 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 255d67e..2f7738f 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -702,4 +702,64 @@
});
return list;
}
+
+ //16-SubTablePageInfoUtils.java;188琛�
+ public List getList2(DevAlarmPar param){
+ String sql=" SELECT history.num,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,alm_severity, " +
+ " db_battinf.tb_battinf.stationName,stationName1,stationName2,stationName3,stationName5,db_battinf.tb_battinf.FbsDeviceName as dev_name " +
+ " FROM db_alarm."+param.getRecordYear()+" history,db_battinf.tb_battinf " +
+ " where history.dev_id=db_battinf.tb_battinf.FbsDeviceId ";
+ if(param.getStationName1()!=null){
+ if(param.getStationName1().equals("")){
+ sql+=" and stationName1!='"+param.getStationName1()+"' ";
+ }else{
+ sql+=" and stationName1='"+param.getStationName1()+"' ";
+ }
+ }
+ if(param.getStationName()!=null){
+ if(param.getStationName().equals("")){
+ sql+=" and stationName!='"+param.getStationName()+"' ";
+ }else{
+ sql+=" and stationName='"+param.getStationName()+"' ";
+ }
+ }
+ sql+=" and alm_start_time >='"+ActionUtil.sdf.format(param.getAlmStartTime())+"' and alm_start_time <='"+ActionUtil.sdf.format(param.getAlmStartTime1())+"' ";
+ sql+=" and history.dev_id in(select distinct db_battinf.tb_battinf.FbsDeviceId " +
+ " 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()+") " +
+ " ORDER BY alm_start_time desc ,dev_name asc limit "+param.getLimitStart()+","+param.getLimitEnd()+" ";
+ List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List<DevalarmDataHistory> list=new ArrayList<>();
+ while (rs.next()){
+ DevalarmDataHistory ph=new DevalarmDataHistory();
+ ph.setNum(rs.getLong("num"));
+ ph.setDevId(rs.getInt("dev_id"));
+ ph.setDevIp(rs.getString("dev_ip"));
+ ph.setAlmType(rs.getInt("alm_type"));
+ ph.setAlmLevel(rs.getInt("alm_level"));
+ ph.setAlmStartTime(rs.getTimestamp("alm_start_time"));
+ ph.setAlmEndTime(rs.getTimestamp("alm_end_time"));
+ ph.setAlmIsConfirmed(rs.getInt("alm_is_confirmed"));
+ ph.setAlmConfirmedTime(rs.getTimestamp("alm_confirmed_time"));
+ ph.setAlmClearedType(rs.getInt("alm_cleared_type"));
+ ph.setDevName(rs.getString("dev_name"));
+ ph.setStationName(rs.getString("stationName"));
+ ph.setStationName1(rs.getString("stationName1"));
+ ph.setStationName2(rs.getString("stationName2"));
+ ph.setStationName3(rs.getString("stationName3"));
+ ph.setStationName5(rs.getString("stationName5"));
+ list.add(ph);
+ }
+ return list;
+ }
+ });
+ return list;
+ }
}
--
Gitblit v1.9.1