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();