From 1c45aa6534cb6b48f9dfeadd5b259b070e7e8ae7 Mon Sep 17 00:00:00 2001
From: 星伟 <星伟@192.168.10.25>
Date: 星期四, 27 九月 2018 17:08:09 +0800
Subject: [PATCH] 设备告警参数加省市筛选条件
---
gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java | 4 ++--
1 files changed, 2 insertions(+), 2 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 aa535b0..5e32997 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java
@@ -301,7 +301,7 @@
"FROM web_site.tb_badbatt_mon,db_battinf.tb_battinf " +
"where web_site.tb_badbatt_mon.battgroupid=db_battinf.tb_battinf.BattGroupId " +
"and test_starttime>=? and test_starttime<=? " +
- "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 idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
@@ -325,7 +325,7 @@
sql=baseSql+endSql+limitSql;
//System.out.println(sql);
List<Batt_Maint_Dealarm> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{
- binf.getBattProductDate(),binf.getBattProductDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%",
+ binf.getBattProductDate(),binf.getBattProductDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%","%"+binf.getStationName2()+"%",
binf.getBattGroupId(),uinf.getUId(),
(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
--
Gitblit v1.9.1