详情添加基站状态

81041

2018-10-18 3fe3343e3ebba208f2eb4ec31718032a83745be5

 gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java

@@ -298,10 +298,20 @@
            " from tb_bts_station_event,db_battinf.tb_battinf " +

            " where  tb_bts_station_event.dev_id=tb_battinf.FBSDeviceId " +

            " and dev_id=?  " +

            " and  record_datetime>=?  and  record_datetime<=? " +

            " order by station_id,station_event_type,record_datetime,station_event_trig asc " +

            " limit ?,? ";

      List<Bts_station_event> list=DAOHelper.executeQuery(sql, conn, new Object[]{bevent.getDev_id(),bevent.getRecord_datetime(),bevent.getRecord_datetime_end(),(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()}, new CallBack() {

            " and  record_datetime>=?  and  record_datetime<=? ";

      //基站状态

      String eventSqlT=" and station_event_type!=? ";

      String eventSqlF=" and station_event_type=? ";

      if(bevent.getStation_event_type()==0){

         sql+=eventSqlT;

      }else{

         sql+=eventSqlF;

      }

      //排序

      String orderSql=" order by station_id,station_event_type,record_datetime,station_event_trig asc " ;

       //分页

      String limitSql=" limit ?,? ";

      List<Bts_station_event> list=DAOHelper.executeQuery(sql, conn, new Object[]{bevent.getDev_id(),bevent.getRecord_datetime(),bevent.getRecord_datetime_end(),bevent.getStation_event_type(),(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()}, new CallBack() {

         

         public List getResults(ResultSet rs) {

            List list=new ArrayList();