From e471caab42abf070e3ad51b8244e9f21cc260f70 Mon Sep 17 00:00:00 2001 From: 星伟 <星伟@192.168.10.25> Date: 星期四, 27 九月 2018 15:27:28 +0800 Subject: [PATCH] 设备历史告警加市级筛选 --- gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) 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 674ea82..f3d80d9 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 @@ -110,7 +110,7 @@ " 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.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? "; /*//鐢ㄤ簬瀹炴椂鍛婅 String almSqlT="and alm_cleared_type=? "; //鍘嗗彶鍛婅 @@ -169,6 +169,7 @@ adata_H.getAlm_start_time1(), "%"+binf.getStationName1()+"%", "%"+binf.getStationName()+"%", + "%"+binf.getStationName2()+"%", //adata_H.getAlm_cleared_type(), -- Gitblit v1.9.1