From 80911312d9c3981341b518d833ccffd148dad678 Mon Sep 17 00:00:00 2001
From: hdw <496960745@qq.com>
Date: 星期四, 01 十一月 2018 15:29:44 +0800
Subject: [PATCH] 落后单体查询bug
---
gx_tieta/src/com/fgkj/dao/impl/Ld9/BadLd9_monImpl.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Ld9/BadLd9_monImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Ld9/BadLd9_monImpl.java
index 5113d2a..6e188f2 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Ld9/BadLd9_monImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Ld9/BadLd9_monImpl.java
@@ -177,7 +177,7 @@
" and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
" and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
" and db_user.tb_user_inf.uid=? " +
- " 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 ?)";
baseSql+=userSql;
String endSql=" ORDER BY web_site.tb_badld9_mon.battgroupid asc ";
@@ -186,7 +186,7 @@
//System.out.println(sql);
List<Batt_Maint_Dealarm> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{
binf.getBattProductDate(),binf.getBattProductDate1(),
- binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%",
+ binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%","%"+binf.getStationName2()+"%",
(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
public List getResults(ResultSet rs) {
--
Gitblit v1.9.1