From c9b14be3d1d4dc6bb483733b80b259bb6f86f6bf Mon Sep 17 00:00:00 2001
From: 星伟 <星伟@192.168.10.25>
Date: 星期二, 25 九月 2018 14:41:28 +0800
Subject: [PATCH] 左侧导航第二级将省份带上
---
gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
index 23719b7..eea5ad1 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
@@ -3271,12 +3271,11 @@
} );
return list;
}
- //鏌ヨ绠＄悊鐨勫競(宸︿晶瀵艰埅绗簩灞傦紝鏌ユ墍鏈夌殑甯�,num涓瓨鏀緐id)
//鏌ヨ绠＄悊鐨勫競(宸︿晶瀵艰埅绗簩灞傦紝鏌ユ墍鏈夌殑甯�,num涓瓨鏀緐id)
public List serchStationName2(Object obj){
BattInf binf=(BattInf) obj;
- String sql="select DISTINCT StationName2 " +
+ String sql="select DISTINCT StationName1,StationName2 " +
" FROM db_battinf.tb_battinf " +
" where StationId in(" +
" select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=?" +
@@ -3288,6 +3287,7 @@
try {
while(rs.next()){
BattInf batt = new BattInf();
+ batt.setStationName1(rs.getString("stationName1"));
batt.setStationName2(rs.getString("stationName2"));
list.add(batt);
}
--
Gitblit v1.9.1