From 7f953d9aa0e7d4fcbe3c366c7f9f0b3f847f12bd Mon Sep 17 00:00:00 2001
From: hdw <hdw@192.168.137.1>
Date: 星期六, 19 一月 2019 09:16:08 +0800
Subject: [PATCH] Merge branch 'dev_lxw' of https://gitlab.com/whyclxw1/gx_tieta.git into dev_lxw
---
gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java | 27 ++++++++++++++++++++-------
1 files changed, 20 insertions(+), 7 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java
index f3d80d9..7905605 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Battalarm_data_historyImpl.java
@@ -105,12 +105,13 @@
String numberSql="SELECT FOUND_ROWS() number";//瀛樻斁鎬绘暟
Connection conn=DBUtil.getConn();//sql鍜宯umberSql鍏辩敤涓�涓猚onnection
String baseSql = "select SQL_CALC_FOUND_ROWS distinct(db_alarm.tb_battalarm_data_history.BattGroupId),db_alarm.tb_battalarm_data_history.num,alm_signal_id,db_alarm.tb_battalarm_data_history.monnum,alm_value,alm_level,alm_is_confirmed,alm_confirmed_time,alm_start_time,alm_end_time, " +
- " stationname,battgroupname" +
- " from db_alarm.tb_battalarm_data_history,db_battinf.tb_battinf " +
- " where alm_id in(?,?,?,?,?,?) and alm_signal_id%2 in(?,?) " +
+ " stationname,stationname5,battgroupname" +
+ " from db_alarm.tb_battalarm_data_history,db_battinf.tb_battinf"
+ + ",db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf " +
+ " where alm_id in(?,?,?,?,?,?,?) and alm_signal_id%2 in(?,?) " +
" and alm_level in(?,?,?,?) " +
" and alm_start_time>=? and alm_start_time<=? " +
- " and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? ";
+ " and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? and db_battinf.tb_battinf.stationname5 like ? ";
/*//鐢ㄤ簬瀹炴椂鍛婅
String almSqlT="and alm_cleared_type=? ";
//鍘嗗彶鍛婅
@@ -135,20 +136,27 @@
}else{
baseSql+=idSqlF;
}
- //鐢ㄤ簬鐢ㄦ埛绠＄悊鐨勭數姹犵粍鐨勭瓫閫�
+ //鐢ㄤ簬鐢ㄦ埛绠＄悊鐨勭數姹犵粍鐨勭瓫閫�
+ String userSql=" and db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId "
+ + "and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id "
+ + "and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid and db_user.tb_user_inf.uid=? ";
+ baseSql+=userSql;
+
+ /*//鐢ㄤ簬鐢ㄦ埛绠＄悊鐨勭數姹犵粍鐨勭瓫閫�
String userSql=" and db_alarm.tb_battalarm_data_history.BattGroupId in(select distinct db_battinf.tb_battinf.battgroupid " +
" from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf " +
" where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
" and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
" and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
" and db_user.tb_user_inf.uid=? )";
- baseSql+=userSql;
+ baseSql+=userSql;*/
String endSql="order by db_alarm.tb_battalarm_data_history.alm_start_time desc,db_alarm.tb_battalarm_data_history.monnum asc ";
String limitSql=" limit ?,? ";
sql=baseSql+endSql+limitSql;
//System.out.println(sql);
List<Batt_Maint_Dealarm> list= DAOHelper.executeQueryLimit(sql,conn,
new Object[] {
+ mainf.getUsr_id(),
mainf.getFault_type_id(),
mainf.getFault_level(),
mainf.getRecord_uid(),
@@ -170,6 +178,7 @@
"%"+binf.getStationName1()+"%",
"%"+binf.getStationName()+"%",
"%"+binf.getStationName2()+"%",
+ "%"+binf.getStationName5()+"%",
//adata_H.getAlm_cleared_type(),
@@ -188,6 +197,7 @@
Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm();
BattInf binf = new BattInf();
binf.setStationName(rs.getString("stationName"));
+ binf.setStationName5(rs.getString("stationName5"));
binf.setBattGroupName(rs.getString("battGroupName"));
Battalarm_data_history adata_H = new Battalarm_data_history();
@@ -233,7 +243,7 @@
Battalarm_data_historyImpl bimpl=new Battalarm_data_historyImpl();
Page p = new Page();
p.setPageCurr(1);
- p.setPageSize(10);
+ p.setPageSize(1000);
/*鏉′欢鎵�瀛樻斁鐨勪綅缃墠鍙帮細tb_batt_maint_inf
* 鍦ㄧ嚎鐢靛帇锛歶sr_id
* 缁勭鐢靛帇锛歠ault_type_id
@@ -274,6 +284,9 @@
binf.setStationName("");
binf.setStationName1("");
+ binf.setStationName2("");
+ binf.setStationName3("");
+ binf.setStationName5("");
binf.setBattGroupId(0);
--
Gitblit v1.9.1