From 2f10da83d8087ed1b47b8edc9ff29ca5248f504d Mon Sep 17 00:00:00 2001
From: Administrator <Administrator@192.168.10.26>
Date: 星期一, 15 十月 2018 14:31:52 +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