From df7684221a6b30edccd985e32952e2959fff65ce Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期二, 17 十月 2023 14:41:17 +0800
Subject: [PATCH] 23
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 54 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 4e21442..2b5314a 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -849,4 +849,58 @@
});
return list;
}
+
+ //23-SubTablePageInfoUtils.java;469琛�
+ public List<DevalarmDataHistory> getListForInterface_dev(InterfaceParam 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, " +
+ " db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName1,db_battinf.tb_battinf.stationName2,db_battinf.tb_battinf.stationName3," +
+ " db_battinf.tb_battinf.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.getDeviceIds()!=null&¶m.getDeviceIds().size()>0){
+ sql+=" and history.dev_id in( ";
+ for (int i=0;i<param.getDeviceIds().size();i++) {
+ sql+=param.getDeviceIds().get(i);
+ if(i!=(param.getDeviceIds().size()-1)){
+ sql+=",";
+ }
+ }
+ sql+=")";
+ }
+ if(param.getStartTime()!=null){
+ sql+=" and alm_start_time >='"+ActionUtil.sdf.format(param.getStartTime())+"' ";
+ }
+ if(param.getEndTime()!=null){
+ sql+=" and alm_start_time <='"+ActionUtil.sdf.format(param.getEndTime())+"' ";
+ }
+ sql+=" 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