From ebd1b9316de01be57c3ed92fc0c002a1a45b29b2 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.13>
Date: 星期一, 10 十二月 2018 09:16:38 +0800
Subject: [PATCH] 历史告警加上在线电压
---
gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java | 3 ++-
gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java | 4 ++--
2 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java
index 04aeb5e..929f9f1 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java
@@ -304,8 +304,8 @@
"and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? and db_battinf.tb_battinf.stationname5 like ? ";
//閫夊彇钃勭數姹犵粍鏉′欢
- String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
- String idSqlF=" and db_battinf.tb_battinf.battgroupid=? ";
+ String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? and db_battinf.tb_battinf.Station_install=1 ";
+ String idSqlF=" and db_battinf.tb_battinf.battgroupid=? and db_battinf.tb_battinf.Station_install=1 ";
if(binf.getBattGroupId()==0){
baseSql+=idSqlT;
}else{
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java
index f550002..fa5d6e9 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java
@@ -107,7 +107,7 @@
String baseSql = "select SQL_CALC_FOUND_ROWS distinct(db_alarm.tb_battalarm_data_history.BattGroupId),db_alarm.tb_battalarm_data_history.num,alm_signal_id,db_alarm.tb_battalarm_data_history.monnum,alm_value,alm_level,alm_is_confirmed,alm_confirmed_time,alm_start_time,alm_end_time, " +
" stationname,stationname5,battgroupname" +
" from db_alarm.tb_battalarm_data_history,db_battinf.tb_battinf " +
- " where alm_id in(?,?,?,?,?,?) and alm_signal_id%2 in(?,?) " +
+ " where alm_id in(?,?,?,?,?,?,?) and alm_signal_id%2 in(?,?) " +
" and alm_level in(?,?,?,?) " +
" and alm_start_time>=? and alm_start_time<=? " +
" and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? and db_battinf.tb_battinf.stationname5 like ? ";
@@ -149,6 +149,7 @@
//System.out.println(sql);
List<Batt_Maint_Dealarm> list= DAOHelper.executeQueryLimit(sql,conn,
new Object[] {
+ mainf.getUsr_id(),
mainf.getFault_type_id(),
mainf.getFault_level(),
mainf.getRecord_uid(),
--
Gitblit v1.9.1