From 3fe3343e3ebba208f2eb4ec31718032a83745be5 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.26>
Date: 星期四, 18 十月 2018 16:25:53 +0800
Subject: [PATCH] 详情添加基站状态
---
gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java | 18 ++++++++++++++----
1 files changed, 14 insertions(+), 4 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java
index 06eae27..a4e2842 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Bts_station_eventImpl.java
+++ b/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();
--
Gitblit v1.9.1