| | |
| | | // batt.setStationName(rs.getString("StationName"));
|
| | | batt.setBattGroupName(rs.getString("battGroupName"));
|
| | | batt.setMonCount(rs.getInt("monCount"));
|
| | | batt.setMonNum(Integer.parseInt(rs.getString("signalname").split("#")[0]));
|
| | | //batt.setMonNum(Integer.parseInt(rs.getString("signalname").split("#")[0]));
|
| | | //System.out.println(batt);
|
| | | list.add(batt);
|
| | | }
|
| | |
| | |
|
| | | BattInfImpl biml = new BattInfImpl();
|
| | | BattInf binf = new BattInf();
|
| | | binf.setBattGroupId(0);
|
| | | binf.setBattGroupId(1000967);
|
| | | binf.setStationName("内蒙古");
|
| | | binf.setStationName1("内蒙古");
|
| | |
|
| | |
| | | bmd.setUinf(uinf);
|
| | | //List<BattInf> list = biml.serchByConditionNew(bmd);
|
| | | //List<BattInf> list=biml.serchByTestType(bmd);
|
| | | List<BattInf> list=biml.serchGroupAssess(bmd);
|
| | | //List<BattInf> list=biml.serchGroupAssess(bmd);
|
| | | List<BattInf> list=biml.serchByMonNum(binf);
|
| | | for (BattInf b : list) {
|
| | | System.out.println(b);
|
| | | }
|
| | |
| | | }else{
|
| | | baseSql+=station1SqlF;
|
| | | }
|
| | | //用于市级筛选
|
| | | String station2SqlT=" and stationname2!=? ";//全部
|
| | | String station2SqlF=" and stationname2=? ";
|
| | | if(binf.getStationName2().equals("")){
|
| | | baseSql+=station2SqlT;
|
| | | }else{
|
| | | baseSql+=station2SqlF;
|
| | | }
|
| | | //用于机房站点
|
| | | String stationSqlT=" and stationname!=? ";//全部
|
| | | String stationSqlF=" and stationname=? ";
|
| | |
| | | //System.out.println(sql);
|
| | | List<BattInf> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{
|
| | | binf.getNum()
|
| | | ,binf.getStationName1(),binf.getStationName(),binf.getBattGroupId(),binf.getMonNum()
|
| | | ,binf.getStationName1(),binf.getStationName2(),binf.getStationName(),binf.getBattGroupId(),binf.getMonNum()
|
| | | ,(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
| | |
|
| | | public List getResults(ResultSet rs) {
|