| | |
|---|
| | | " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
|
|---|
| | | " 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_user.tb_user_inf.uid=? and db_battinf.tb_battinf.Station_install=1 ) " ;
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {
|
|---|
| | |
|
|---|
| | |
|---|
| | | "and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? and db_battinf.tb_battinf.stationname5 like ? ";
|
|---|
| | |
|
|---|
| | | //选取蓄电池组条件
|
|---|
| | | String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
|
|---|
| | | String idSqlF=" and db_battinf.tb_battinf.battgroupid=? ";
|
|---|
| | | String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? and db_battinf.tb_battinf.Station_install=1 ";
|
|---|
| | | String idSqlF=" and db_battinf.tb_battinf.battgroupid=? and db_battinf.tb_battinf.Station_install=1 ";
|
|---|
| | | if(binf.getBattGroupId()==0){
|
|---|
| | | baseSql+=idSqlT;
|
|---|
| | | }else{
|
|---|
