From 0ee2a92da94c0b97f7c9c48b4a30a80a810304cd Mon Sep 17 00:00:00 2001 From: 星伟 <星伟@192.168.10.25> Date: 星期四, 27 九月 2018 13:20:20 +0800 Subject: [PATCH] 落后单体查询。ld9查询, 电池实时状态查询添加市级筛选 --- 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