修改

81041

2019-01-04 b268b39629bcc2dfbac978b5c53b67db3b71a839

 gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java

@@ -896,7 +896,7 @@
             + ",dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr,dev_captest_cap,dev_captest_timelong "

             + ",dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type "

             + ",db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName1,db_battinf.tb_battinf.StationName2,db_battinf.tb_battinf.StationName3,db_battinf.tb_battinf.StationName5 "

             + ",db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.BattGroupId,db_battinf.tb_battinf.battgroupname "

             + ",db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.BattGroupId,db_battinf.tb_battinf.battgroupname,db_battinf.tb_battinf.moncapstd,db_battinf.tb_battinf.moncount "

             + " from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr "

             + " where   dev_workstate="+FBS9100_ComBase.DISCHARGE

             + " and db_battinf.tb_battinf.fbsdeviceId=db_ram_db.tb_fbs9100_state.dev_id    "

@@ -905,7 +905,28 @@
             + " 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) {

@@ -942,6 +963,8 @@
                  fstate.setStationName5(rs.getString("stationName5"));

                  fstate.setBattgroupid(rs.getInt("battgroupid"));

                  fstate.setMonvolstd(rs.getInt("monvolstd"));

                  fstate.setMoncapstd(rs.getInt("moncapstd"));

                  fstate.setMoncount(rs.getInt("moncount"));

                  fstate.setNote(rs.getString("battgroupname"));

                  list.add(fstate);

               }

@@ -971,8 +994,10 @@
       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){