详情添加基站状态

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