From fc1671346a578cd47f39eb5c578d802b6eac1c4f Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 19 五月 2023 15:29:31 +0800
Subject: [PATCH] 注意:1.新增电源机房时需要重新运行
---
BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java | 180 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 177 insertions(+), 3 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 7dcb34c..e1eeae9 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
@@ -320,6 +320,7 @@
" `alarm_source` int(11) NOT NULL DEFAULT '0' COMMENT '告警数据来源[0-设备告警点位判断；1-当前阈值判断]'," +
" `alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT '当前告警描述'," +
" `alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-上下限有效 1-上限有效 2-下限有效'," +
+ " `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]'," +
" PRIMARY KEY (`num`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -329,11 +330,25 @@
sql.sqlMysqlExecute(sql_str01);
}
sql.sqlMysqlExecute(sql_str02);
+
+ //添加 alarm_en_node -- 告警来源是点位时告警使能[0:不启用；1：启用]
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_alarm'"
+ + " AND table_name='tb_pwrdev_alarm_param_forsx'"
+ + " AND column_name='alarm_en_node'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
+ + " ADD COLUMN `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]';");
+ }
+
+
res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);
StringBuffer buf_base = new StringBuffer("INSERT INTO " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + "(PowerDeviceId,alm_id,alm_level,alarm_limitH,alarm_limitH_EN,alarm_limitL,alarm_limitL_EN,alarm_name,alarm_type) VALUES");
StringBuffer buf_body = new StringBuffer();
while(res.next()) {
int PowerDeviceId = res.getInt("PowerDeviceId");
+
+
//交流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);
@@ -354,12 +369,83 @@
//交流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相过流告警
+
+ //交流停电告警 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
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_DCout_OverV_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"直流电压过高告警",1,pool);
+ //直流电压过低告警 110013
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_DCout_UnderV_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"直流电压过低告警",2,pool);
+ //负载熔断告警 110014
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_LoaderFuse_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"负载熔断告警",2,pool);
+ //电池组1熔断告警 110015
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_BattGrp1Fuse_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"电池组1熔断告警",2,pool);
+ //电池组2熔断告警 110016
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_BattGrp2Fuse_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"电池组2熔断告警",2,pool);
+ //整流器1总故障告警 110017
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module1Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器1总故障告警",2,pool);
+ //整流器2总故障告警 110018
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module2Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器2总故障告警",2,pool);
+ //整流器3总故障告警 110019
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module3Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器3总故障告警",2,pool);
+ //整流器4总故障告警 110020
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module4Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器4总故障告警",2,pool);
+ //整流器5总故障告警 110021
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module5Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器5总故障告警",2,pool);
+ //整流器6总故障告警 110022
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module6Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器6总故障告警",2,pool);
+ //整流器7总故障告警 110023
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module7Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器7总故障告警",2,pool);
+ //整流器8总故障告警 110024
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module8Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器8总故障告警",2,pool);
+ //整流器9总故障告警 110025
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module9Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器9总故障告警",2,pool);
+ //整流器10总故障告警 110026
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module10Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器10总故障告警",2,pool);
+ //整流器11总故障告警 110027
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module11Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器11总故障告警",2,pool);
+ //整流器12总故障告警 110028
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module12Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器12总故障告警",2,pool);
+ //整流器13总故障告警 110029
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module13Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器13总故障告警",2,pool);
+ //整流器14总故障告警 110030
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module14Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器14总故障告警",2,pool);
+ //整流器15总故障告警 110031
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module15Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器15总故障告警",2,pool);
+ //整流器16总故障告警 110032
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module16Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"整流器16总故障告警",2,pool);
+ //交流总故障告警 110033
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcAlarm_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"交流总故障告警",2,pool);
+ //直流总故障告警 110034
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_DcAlarm_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"直流总故障告警",2,pool);
+
+ //交流A相过流告警 110035
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流A相过流告警",1,pool);
- //交流B相过流告警
+ //交流B相过流告警 110036
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流B相过流告警",1,pool);
- //交流C相过流告警
+ //交流C相过流告警 110037
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流C相过流告警",1,pool);
+
+ //监控器故障告警 110038
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_MonitorErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"监控器故障告警",1,pool);
+ //直流过流告警 110039
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_DcOut_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"直流过流告警",1,pool);
+ //开关柜总报警 110040
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_TolalAlarm_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"开关柜总报警",1,pool);
+ //电池组1电压低告警 110041
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt1_VolLow_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"电池组1电压低告警",1,pool);
+ //电池组2电压低告警 110042
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt2_VolLow_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"电池组2电压低告警",1,pool);
+ //电池组1下电告警 110043
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt1_Down_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"电池组1下电告警",1,pool);
+ //电池组2下电告警 110044
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt2_Down_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"电池组2下电告警",1,pool);
+ //电池组1充电过流告警 110045
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt1_OverChgCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"电池组1充电过流告警",1,pool);
+ //电池组2充电过流告警 110046
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt2_OverChgCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"电池组2充电过流告警",1,pool);
//整流器1过压告警
@@ -460,8 +546,96 @@
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器15过流告警",1,pool);
//整流器16过流告警
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器16过流告警",1,pool);
+
+ //整流器1交流异常告警 110095
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器1交流异常告警",1,pool);
+ //整流器2交流异常告警 110096
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器2交流异常告警",1,pool);
+ //整流器3交流异常告警 110097
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器3交流异常告警",1,pool);
+ //整流器4交流异常告警 110098
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器4交流异常告警",1,pool);
+ //整流器5交流异常告警 110099
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器5交流异常告警",1,pool);
+ //整流器6交流异常告警 110100
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器6交流异常告警",1,pool);
+ //整流器7交流异常告警 110101
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器7交流异常告警",1,pool);
+ //整流器8交流异常告警 110102
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器8交流异常告警",1,pool);
+ //整流器9交流异常告警 110103
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器9交流异常告警",1,pool);
+ //整流器10交流异常告警 110104
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器10交流异常告警",1,pool);
+ //整流器11交流异常告警 110105
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器11交流异常告警",1,pool);
+ //整流器12交流异常告警 110106
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器12交流异常告警",1,pool);
+ //整流器13交流异常告警 110107
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器13交流异常告警",1,pool);
+ //整流器14交流异常告警 110108
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器14交流异常告警",1,pool);
+ //整流器15交流异常告警 110109
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器15交流异常告警",1,pool);
+ //整流器16交流异常告警 110110
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"整流器16交流异常告警",1,pool);
+ //交流输入1跳闸告警 110111
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_Trip_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流输入1跳闸告警",1,pool);
+ //交流输入2跳闸告警 110112
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn2_Trip_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流输入2跳闸告警",1,pool);
+ //交流输入1熔丝告警 110113
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_Fuse_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流输入1熔丝告警",1,pool);
+ //交流输入2熔丝告警 110114
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn2_Fuse_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流输入2熔丝告警",1,pool);
+ //交流输入1三相不平衡告警 110115
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_Unbalance_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"交流输入1三相不平衡告警",1,pool);
+ //交流输入2三相不平衡告警 110116
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn2_Unbalance_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"交流输入2三相不平衡告警",1,pool);
+ //交流输入1频率异常告警 110117
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_FreqErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"交流输入1频率异常告警",1,pool);
+ //交流输入2频率异常告警 110118
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn2_FreqErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"交流输入2频率异常告警",1,pool);
+ //协转通信故障告警 110119
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_CPSS_CommErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"协转通信故障告警",1,pool);
+
+ //1+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ //电源通信故障告警 110120
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_PWRDEV_CommErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"电源通信故障告警",1,pool);
+ //交流输入1停电告警 110121
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_User_AcIn1_PowerDown_ID,SqlsUtils.Alarm_Level_First,100,true, 0,false,"交流输入1停电告警",1,pool);
+ //交流输入2停电告警 110122
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_User_AcIn2_PowerDown_ID,SqlsUtils.Alarm_Level_First,100,true, 0,false,"交流输入2停电告警",1,pool);
+ //交流1采集通信故障告警 110123
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_User_AcIn1_CommErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流1采集通信故障告警",1,pool);
+ //交流2采集通信故障告警 110124
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_User_AcIn2_CommErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"交流2采集通信故障告警",1,pool);
+ //温感1通信故障告警 110125
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Temp1_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"温感1通信故障告警",1,pool);
+ //温感2通信故障告警 110126
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Temp2_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"温感2通信故障告警",1,pool);
+ //温感3通信故障告警 110127
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Temp3_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"温感3通信故障告警",1,pool);
+ //湿感1通信故障告警 110128
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Humi1_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"湿感1通信故障告警",1,pool);
+ //湿感2通信故障告警 110129
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Humi2_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"湿感2通信故障告警",1,pool);
+ //湿感3通信故障告警 110130
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Humi3_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"湿感3通信故障告警",1,pool);
+ //烟感1报警告警 110131
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke1_Occur_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"烟感1报警告警",1,pool);
+ //烟感2报警告警 110132
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke2_Occur_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"烟感2报警告警",1,pool);
+ //烟感3报警告警 110133
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke3_Occur_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"烟感3报警告警",1,pool);
+ //烟感1通信故障告警 110134
+ checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke1_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"烟感1通信故障告警",1,pool);
+ //烟感2通信故障告警 110135
+ 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);
+
//System.out.println(PowerDeviceId +" == " + buf_body );
}
if(buf_body.length() > 0) {
--
Gitblit v1.9.1