From c9da5f9a78e4bf2a3a634f41555a774dba5324e2 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期一, 31 七月 2023 10:29:52 +0800
Subject: [PATCH] V1.84 edit at date 2023-07-27 1.删除默认的电源交流停电告警参数 2.默认插入国网电源2路的三相告警参数 3.将国网电源原交流三相电压告警参数前新增路数
---
BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java | 94 +++++++++++++++++++++++++++++++++++-----------
1 files changed, 71 insertions(+), 23 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
index db9f5ae..c855cb7 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
@@ -5,12 +5,13 @@
import java.util.Date;
import com.base.Com;
+import com.mysql.jdbc.UpdatableResultSet;
import com.sql.MysqlConnPool;
import com.sql.Sql_Mysql;
public class DB_Pwrdev_Alarm {
public static void init(MysqlConnPool pool, boolean recreate) {
- System.out.println(" db_pwrdev_alarm start end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
+ System.out.println(" db_pwrdev_alarm start at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
createDB_Pwrdev_Alarm (pool);
@@ -472,28 +473,32 @@
- //交流A相过压告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流A相过压告警",1,pool);
- //交流A相欠压告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流A相欠压告警",2,pool);
- //交流A相缺相告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流A相缺相告警",2,pool);
- //交流B相过压告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流B相过压告警",1,pool);
- //交流B相欠压告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流B相欠压告警",2,pool);
- //交流B相缺相告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流B相缺相告警",2,pool);
- //交流C相过压告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流C相过压告警",1,pool);
- //交流C相欠压告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流C相欠压告警",2,pool);
- //交流C相缺相告警
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流C相缺相告警",2,pool);
+ //交流A相过压告警 110001
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"1路交流A相过压告警",1,pool);
+ //交流A相欠压告警 110002
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"1路交流A相欠压告警",2,pool);
+ //交流A相缺相告警 110003
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"1路交流A相缺相告警",2,pool);
+ //交流B相过压告警 110004
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"1路交流B相过压告警",1,pool);
+ //交流B相欠压告警 110005
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"1路交流B相欠压告警",2,pool);
+ //交流B相缺相告警 110006
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"1路交流B相缺相告警",2,pool);
+ //交流C相过压告警 110007
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"1路交流C相过压告警",1,pool);
+ //交流C相欠压告警 110008
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"1路交流C相欠压告警",2,pool);
+ //交流C相缺相告警 110009
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"1路交流C相缺相告警",2,pool);
+ /**
+ * @2023-07-31 修改，交流停电告警暂无告警参数
+ */
+ //交流停电告警 110010
+ //checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID,SqlsUtils.Alarm_Level_First,54,false, 49,true,"交流停电告警",2,pool);
+ deletePowerAlarmDefaultParam(SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID, pool);
- //交流停电告警 110010
- checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID,SqlsUtils.Alarm_Level_First,54,false, 49,true,"交流停电告警",2,pool);
//防雷器故障告警 110011
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID,SqlsUtils.Alarm_Level_Second,54,false, 49,false,"防雷器故障告警",2,pool);
//直流电压过高告警 110012
@@ -757,7 +762,25 @@
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke2_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"烟感2通信故障告警",1,pool);
//烟感3通信故障告警 110136
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke3_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"烟感3通信故障告警",1,pool);
-
+
+ //2路交流A相过压 110137
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"2路交流A相过压告警",1,pool);
+ //2路交流A相欠压 110138
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"2路交流A相欠压告警",2,pool);
+ //2路交流A相缺相 110139
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"2路交流A相缺相告警",2,pool);
+ //2路交流B相过压 110140
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"2路交流B相过压告警",1,pool);
+ //2路交流B相欠压 110141
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"2路交流B相欠压告警",2,pool);
+ //2路交流B相缺相 110142
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"2路交流B相缺相告警",2,pool);
+ //2路交流C相过压 1101343
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"2路交流C相过压告警",1,pool);
+ //2路交流C相欠压 110144
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"2路交流C相欠压告警",2,pool);
+ //2路交流C相缺相 110145
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"2路交流C相缺相告警",2,pool);
//System.out.println(PowerDeviceId +" == " + buf_body );
}
if(buf_body.length() > 0) {
@@ -791,7 +814,7 @@
* @param alarm_type 告警有效 0-上下限有效 1-上限有效 2-下限有效
*/
public static void checkPowerAlarmParam(StringBuffer buf_body,int PowerDeviceId,int alm_id,int alm_level,float alarm_limitH,boolean alarm_limitH_EN, float alarm_limitL, boolean alarm_limitL_EN,String alarm_name,int alarm_type,MysqlConnPool pool) {
- String sql_str_sel = "SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
+ String sql_str_sel = "SELECT PowerDeviceId,alarm_name FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
ResultSet res = null;
res = sql.sqlMysqlQuery(sql_str_sel);
@@ -802,6 +825,13 @@
buf_body.append(",");
}
buf_body.append("("+PowerDeviceId+","+alm_id+","+alm_level+","+alarm_limitH+","+alarm_limitH_EN+","+alarm_limitL+","+alarm_limitL_EN+",'"+alarm_name+"',"+alarm_type+")");
+ }else {
+ String old_alm_name = res.getString("alarm_name");
+ if(!old_alm_name.equals(alarm_name)) {
+ sql.sqlMysqlExecute(" UPDATE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table +
+ " SET alarm_name = '" + alarm_name + "'" +
+ " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id);
+ }
}
} catch (SQLException e) {
e.printStackTrace();
@@ -817,6 +847,24 @@
}
}
+ /**
+ * 删除默认的告警参数
+ * @param alm_id
+ * @param pool
+ */
+ public static void deletePowerAlarmDefaultParam(int alm_id,MysqlConnPool pool) {
+ String sql_str = " DELETE FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " where alm_id = " + alm_id;
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ //System.out.println(sql_str_sel);
+ try {
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
public static void main(String[] args) {
MysqlConnPool pool = new MysqlConnPool("192.168.10.79", 3360, 5);
--
Gitblit v1.9.1