rf

Administrator

2018-10-19 769d4ca92b39f55b6af50e12b851e58e93a3eba4

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

@@ -44,7 +44,7 @@
    //查询机房实时状态

   public List serchByCondition(Object obj) {

      BattInf binf=(BattInf) obj;

      Page p=new Page();

      Page p=binf.getPage();

      Connection conn=DBUtil.getConn();

      String numberSql="SELECT FOUND_ROWS() number";//存放总数

      String sql="select SQL_CALC_FOUND_ROWS distinct station_id,dev_id,record_datetime,station_stat,station_poff_start_time,station_fadian_start_time" +

@@ -66,19 +66,19 @@
                  b.setDev_id(rs.getInt("dev_id"));

                  b.setRecord_datetime(rs.getTimestamp("record_datetime"));

                  b.setStation_stat(rs.getInt("station_stat"));

                  if(((b.getStation_stat()>>4)&1)==1){

                  if(((b.getStation_stat()>>5)&1)==1){

                     b.setStation_stat_diaozhan(1);//掉站

                  }

                  if(((b.getStation_stat()>>3)&1)==1){

                  if(((b.getStation_stat()>>4)&1)==1){

                     b.setStation_stat_dooropen(1);//开门

                  }

                  if(((b.getStation_stat()>>2)&1)==1){

                  if(((b.getStation_stat()>>3)&1)==1){

                     b.setStation_stat_fadian(1);  //发电

                  }

                  if(((b.getStation_stat()>>1)&1)==1){

                  if(((b.getStation_stat()>>2)&1)==1){

                     b.setStation_stat_xuhang(1);//续航

                  }

                  if((b.getStation_stat()&1)==1){

                  if(((b.getStation_stat()>>1)&1)==1){

                     b.setStation_stat_poff(1);    //停电

                  }

                  b.setStation_poff_start_time(rs.getTimestamp("station_poff_start_time"));

@@ -126,11 +126,11 @@
      binf.setStationId("");

      Page p=new Page();

      p.setPageCurr(1);

      p.setPageSize(10);

      p.setPageSize(1);

      binf.setPage(p);

      List<Bts_station_state> list=bimpl.serchByCondition(binf);

      for (Bts_station_state bs : list) {

         System.out.println(bs.getStation_stat_diaozhan()+"  "+bs.getStation_stat_dooropen()+"  "+bs.getStation_stat_fadian()+"   "+bs.getStation_stat_xuhang()+"  "+bs.getStation_stat_poff());

         //System.out.println(bs.getStation_stat_diaozhan()+"  "+bs.getStation_stat_dooropen()+"  "+bs.getStation_stat_fadian()+"   "+bs.getStation_stat_xuhang()+"  "+bs.getStation_stat_poff());

          System.out.println(bs);

      }

   }