| | |
| | | + " 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_battgroup_baojigroup_usr.uId=? "
|
| | | + " and db_battinf.tb_battinf.MonVolStd=? ";
|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[] {binf.getNum(),binf.getMonVolStd()}, new CallBack() {
|
| | | //条件
|
| | | String sql0=" and stationid=? "; //具体机房
|
| | | String sql1=" and stationname1=? ";//省
|
| | | String sql2=" and stationname2=? ";//市
|
| | | String sql5=" and stationname5=? ";//区县
|
| | | switch (binf.getNum()) {
|
| | | case 0:
|
| | | sql+=sql0;
|
| | | break;
|
| | | case 1:
|
| | | sql+=sql1;
|
| | | break;
|
| | | case 2:
|
| | | sql+=sql2;
|
| | | break;
|
| | | case 5:
|
| | | sql+=sql5;
|
| | | break;
|
| | | default:
|
| | | return null;
|
| | | }
|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[] {binf.getBattGroupId(),binf.getMonVolStd(),binf.getStationName()}, new CallBack() {
|
| | |
|
| | | @Override
|
| | | public List getResults(ResultSet rs) {
|
| | |
| | | p.setPageCurr(1);
|
| | | fs.setPage(p);
|
| | | BattInf binf=new BattInf();
|
| | | binf.setNum(1002);
|
| | | binf.setMonVolStd(12f);
|
| | | binf.setNum(1);
|
| | | binf.setBattGroupId(1002);
|
| | | binf.setStationName("广西省");
|
| | | binf.setMonVolStd(2f);
|
| | | /*List<Fbs9100_state> list=fi.serchByCondition(fs);
|
| | | System.out.println(list.size());
|
| | | for(Fbs9100_state f:list){
|