| | |
|---|
| | | " and db_user.tb_user_inf.uid=? )";
|
|---|
| | | baseSql+=userSql;
|
|---|
| | | //机房维护区选择
|
|---|
| | | String stationSql=" AND db_battinf.tb_battinf.stationname like ? AND db_battinf.tb_battinf.stationname1 like ? ";
|
|---|
| | | String stationSql=" AND db_battinf.tb_battinf.stationname like ? AND db_battinf.tb_battinf.stationname1 like ? AND db_battinf.tb_battinf.stationname2 like ? ";
|
|---|
| | | baseSql+=stationSql;
|
|---|
| | | //电池状态
|
|---|
| | | String stateSqlT=" AND batt_state=? ";
|
|---|
| | |
|---|
| | | String limitSql=" limit ?,?";
|
|---|
| | | sql=baseSql+endSql+limitSql;
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | List<Batt_State> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%"
|
|---|
| | | List<Batt_State> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%"
|
|---|
| | | ,binf.getNum(),(page.getPageCurr() - 1)*page.getPageSize(),
|
|---|
| | | page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
