From c69424cc915d4b49fa2b7df090539904b7780f46 Mon Sep 17 00:00:00 2001
From: 星伟 <星伟@192.168.10.25>
Date: 星期四, 27 九月 2018 15:36:36 +0800
Subject: [PATCH] 设备实时告警加市级筛选
---
gx_tieta/src/com/fgkj/dao/impl/Batt_devalarm_dataImpl.java | 10 +++++++++-
gx_tieta/src/com/fgkj/dto/Batt_devalarm_data.java | 12 ++++++++++--
2 files changed, 19 insertions(+), 3 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_devalarm_dataImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_devalarm_dataImpl.java
index 60276ab..9f25065 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Batt_devalarm_dataImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_devalarm_dataImpl.java
@@ -329,6 +329,14 @@
}else{
baseSql+=stationSqlF;
}
+ //鐢ㄤ簬鏈烘埧绔欑偣
+ String stationSql2T=" and stationname2!=? ";//鍏ㄩ儴
+ String stationSql2F=" and stationname2=? ";
+ if(ddata.getStationName2().equals("")){
+ baseSql+=stationSql2T;
+ }else{
+ baseSql+=stationSql2F;
+ }
//鐢ㄤ簬鏁呴殰浜嬩欢
String almTypeT=" and alm_type!=? ";//鍏ㄩ儴
String almTypeF=" and alm_type=? ";
@@ -350,7 +358,7 @@
//鍒嗛〉
String limitSql=" LIMIT ?,? ";
sql=baseSql+endSql+limitSql;
- List<Batt_devalarm_data> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{ddata.getStationName1(),ddata.getStationName(),ddata.getAlm_type(),uinf.getUId(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
+ List<Batt_devalarm_data> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{ddata.getStationName1(),ddata.getStationName(),ddata.getStationName2(),ddata.getAlm_type(),uinf.getUId(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
public List getResults(ResultSet rs) {
List list=new ArrayList();
diff --git a/gx_tieta/src/com/fgkj/dto/Batt_devalarm_data.java b/gx_tieta/src/com/fgkj/dto/Batt_devalarm_data.java
index 1bb7032..8653a09 100644
--- a/gx_tieta/src/com/fgkj/dto/Batt_devalarm_data.java
+++ b/gx_tieta/src/com/fgkj/dto/Batt_devalarm_data.java
@@ -22,6 +22,7 @@
private String dev_name;//璁惧鍚嶇О
private String stationName;//鏈烘埧鍚嶇О
private String stationName1;//缁存姢鍖哄悕绉�
+ private String stationName2;//甯傜骇
private String stationId;//鏈烘埧id
private Page page;//鍒嗛〉
private User_inf uinf;
@@ -149,6 +150,12 @@
public void setStationName1(String stationName1) {
this.stationName1 = stationName1;
}
+ public String getStationName2() {
+ return stationName2;
+ }
+ public void setStationName2(String stationName2) {
+ this.stationName2 = stationName2;
+ }
@Override
public String toString() {
return "Batt_devalarm_data [num=" + num + ", record_id=" + record_id
@@ -160,8 +167,9 @@
+ alm_confirmed_time + ", alm_cleared_type=" + alm_cleared_type
+ ", usr_id=" + usr_id + ", note=" + note + ", dev_name="
+ dev_name + ", stationName=" + stationName + ", stationName1="
- + stationName1 + ", stationId=" + stationId + ", page=" + page
- + ", uinf=" + uinf + "]";
+ + stationName1 + ", stationName2=" + stationName2
+ + ", stationId=" + stationId + ", page=" + page + ", uinf="
+ + uinf + "]";
}
--
Gitblit v1.9.1