From 027d4a8e00a9881884824be44d9aee0289b747d4 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 15 八月 2023 16:34:25 +0800
Subject: [PATCH] V1.85 edit at date 2023-08-15 1.创建表'db_alarm.tb_alarm_manual_clear' 2.创建表'web_site.tb_fbs9100_setparam_temp' 3.创建表'db_param.tb_appalm_param',并录入所有[电源，电池，设备告警是否能自动消失配置]
---
BattMonitor_DB_Builder/src/com/database_util/DB_Param.java | 762 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 761 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Param.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Param.java
index 6f2ad4e..f03ddb2 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Param.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Param.java
@@ -22,6 +22,8 @@
createDev_AlmParam_Table(pool, recreate); //创建设备告警参数表
+ createAppAlm_Param_Table(pool, recreate); //创建设备告警参数表
+
System.out.println(" db_param init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -176,7 +178,7 @@
" param_value varchar(50) DEFAULT NULL," +
" param_caption varchar(200) DEFAULT NULL," +
" PRIMARY KEY (num)" +
- ") ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;";
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
try {
if(true == recreate) {
@@ -189,6 +191,764 @@
sql.close_con();
}
}
+
+ /**
+ * 判断是否存在当前告警参数的记录
+ * @param alm_id
+ * @param pool
+ * @return
+ */
+ public static boolean checkAppAlarmParamExists(int alm_id,MysqlConnPool pool) {
+ String sql_str = " SELECT * FROM " + Sql_Mysql.AppAlm_Param_Table + " WHERE alm_id = " + alm_id;
+ ResultSet res = null;
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ res = sql.sqlMysqlQuery(sql_str);
+ if(res.next()) {
+ return true;
+ }
+ } catch (Exception e) {
+ e.printStackTrace();
+ } finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
+ sql.close_con();
+ }
+ return false;
+ }
+
+ /**
+ * 创建 tb_appalm_param 平台告警参数配置表
+ * @param pool
+ * @param recreate
+ */
+ public static void createAppAlm_Param_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.AppAlm_Param_Table;
+ String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.AppAlm_Param_Table + " (" +
+ " `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键'," +
+ " `alm_id` int(11) NOT NULL DEFAULT '119001' COMMENT '告警id'," +
+ " `alm_name` varchar(255) NOT NULL DEFAULT '' COMMENT '告警名称'," +
+ " `alm_category` int(11) NOT NULL DEFAULT '1' COMMENT '告警类别[1-电池告警；2-设备告警；3-电源告警]'," +
+ " `alm_auto_clear_en` int(11) NOT NULL DEFAULT '1' COMMENT '告警自动消失使能[平台告警是否允许消失使能]0-不允许 1-允许'," +
+ " PRIMARY KEY (`num`)" +
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='平台告警参数配置表';";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ String sql_str = " INSERT INTO db_param.tb_appalm_param(alm_id,alm_name,alm_category) VALUES ";
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+
+ int alm_category = 1;
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_OnlineVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_OnlineVol_ID + ",'在线电压告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_GroupVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_GroupVol_ID + ",'组端电压告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BattChargeCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BattChargeCurr_ID + ",'充电电流高告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BattDisChargeCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BattDisChargeCurr_ID + ",'放电电流告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MonVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MonVol_ID + ",'单体电压告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MonTmp_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MonTmp_ID + ",'单体温度告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MonRes_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MonRes_ID + ",'单体内阻告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ConnRes_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ConnRes_ID + ",'连接条阻抗告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_DisChargeMonVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_DisChargeMonVol_ID + ",'放电单体电压告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MONCAP_ALMALARM_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MONCAP_ALMALARM_ID + ",'容量告警告警'," + alm_category +");");
+ }
+// if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MONCAP_CHANGEALARM_ID, pool)) {
+// sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MONCAP_CHANGEALARM_ID + ",'容量更换告警'," + alm_category +");");
+// }
+// if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MONLYVOL_ID, pool)) {
+// sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MONLYVOL_ID + ",'漏液电压告警'," + alm_category +");");
+// }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MONREALCAP_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MONREALCAP_ID + ",'单体预估容量告警'," + alm_category +");");
+ }
+
+ try {
+ Thread.sleep(50);
+ } catch (InterruptedException e) {
+ e.printStackTrace();
+ }
+ /******************************* 设备告警参数 *********************************************************************/
+ alm_category = 2;
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_CommError_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_CommError_ID + ",'BTS通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS_ENDURANCE_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS_ENDURANCE_ID + ",'BTS续航告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_POWEROFF_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_POWEROFF_ID + ",'机房停电告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_FADIAN_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_FADIAN_ID + ",'机房发电告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_DIAOZHAN_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_DIAOZHAN_ID + ",'机房掉站告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_KAIMEN_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_KAIMEN_ID + ",'机房开门告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_TMPHIGHT_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_TMPHIGHT_ID + ",'设备高温告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_SDERROR_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_SDERROR_ID + ",'设备SD卡故障'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_COLLECTERROR_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_COLLECTERROR_ID + ",'采集线告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_CurrBalance_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_CurrBalance_ID + ",'停电电流均衡告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_RELAY_Error_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_RELAY_Error_ID + ",'继电器告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_CONNCET_Error_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_CONNCET_Error_ID + ",'通讯告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_HIGTMP_Error_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_HIGTMP_Error_ID + ",'设备过温告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_DIODE_Error_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_DIODE_Error_ID + ",'二极管D1告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_DRYCONTACT_Error_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_DRYCONTACT_Error_ID + ",'干接点告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_TEST_ERROR_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_TEST_ERROR_ID + ",'测试异常停止'," + alm_category +");");
+ }
+
+ try {
+ Thread.sleep(50);
+ } catch (InterruptedException e) {
+ e.printStackTrace();
+ }
+ /******************************* 电源告警参数 *********************************************************************/
+ alm_category = 3;
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID + ",'1路交流A相过压告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID + ",'1路交流A相欠压告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID + ",'1路交流A相缺相告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID + ",'1路交流B相过压告警'," + alm_category +");");
+ }
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID + ",'1路交流B相欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID + ",'1路交流B相缺相告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID + ",'1路交流C相过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID + ",'1路交流C相欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID + ",'1路交流C相缺相告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID + ",'交流停电告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID + ",'防雷器故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_DCout_OverV_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_DCout_OverV_ID + ",'直流电压过高告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_DCout_UnderV_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_DCout_UnderV_ID + ",'直流电压过低告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_LoaderFuse_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_LoaderFuse_ID + ",'负载熔断告警'," + alm_category +");");
+ }
+
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_BattGrp1Fuse_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_BattGrp1Fuse_ID + ",'电池组1熔断告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_BattGrp2Fuse_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_BattGrp2Fuse_ID + ",'电池组2熔断告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module1Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module1Err_ID + ",'整流器1总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module2Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module2Err_ID + ",'整流器2总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module3Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module3Err_ID + ",'整流器3总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module4Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module4Err_ID + ",'整流器4总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module5Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module5Err_ID + ",'整流器5总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module6Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module6Err_ID + ",'整流器6总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module7Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module7Err_ID + ",'整流器7总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module8Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module8Err_ID + ",'整流器8总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module9Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module9Err_ID + ",'整流器9总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module10Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module10Err_ID + ",'整流器10总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module11Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module11Err_ID + ",'整流器11总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module12Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module12Err_ID + ",'整流器12总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module13Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module13Err_ID + ",'整流器13总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module14Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module14Err_ID + ",'整流器14总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module15Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module15Err_ID + ",'整流器15总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module16Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module16Err_ID + ",'整流器16总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcAlarm_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcAlarm_ID + ",'交流总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_DcAlarm_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_DcAlarm_ID + ",'直流总故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID + ",'交流A相过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID + ",'交流B相过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID + ",'交流C相过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_MonitorErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_MonitorErr_ID + ",'监控器故障告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_DcOut_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_DcOut_OverCurr_ID + ",'直流过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_TolalAlarm_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_TolalAlarm_ID + ",'开关柜总报警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt1_VolLow_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt1_VolLow_ID + ",'电池组1电压低告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt2_VolLow_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt2_VolLow_ID + ",'电池组2电压低告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt1_Down_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt1_Down_ID + ",'电池组1下电告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt2_Down_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt2_Down_ID + ",'电池组2下电告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt1_OverChgCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt1_OverChgCurr_ID + ",'电池组1充电过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt2_OverChgCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt2_OverChgCurr_ID + ",'电池组2充电过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod1_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod1_OverVol_ID + ",'整流器1过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod2_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod2_OverVol_ID + ",'整流器2过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod3_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod3_OverVol_ID + ",'整流器3过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod4_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod4_OverVol_ID + ",'整流器4过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod5_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod5_OverVol_ID + ",'整流器5过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod6_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod6_OverVol_ID + ",'整流器6过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod7_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod7_OverVol_ID + ",'整流器7过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod8_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod8_OverVol_ID + ",'整流器8过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod9_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod9_OverVol_ID + ",'整流器9过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod10_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod10_OverVol_ID + ",'整流器10过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod11_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod11_OverVol_ID + ",'整流器11过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod12_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod12_OverVol_ID + ",'整流器12过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod13_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod13_OverVol_ID + ",'整流器13过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod14_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod14_OverVol_ID + ",'整流器14过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod15_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod15_OverVol_ID + ",'整流器15过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod16_OverVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod16_OverVol_ID + ",'整流器16过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod1_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod1_UnderVol_ID + ",'整流器1欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod2_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod2_UnderVol_ID + ",'整流器2欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod3_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod3_UnderVol_ID + ",'整流器3欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod4_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod4_UnderVol_ID + ",'整流器4欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod5_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod5_UnderVol_ID + ",'整流器5欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod6_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod6_UnderVol_ID + ",'整流器6欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod7_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod7_UnderVol_ID + ",'整流器7欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod8_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod8_UnderVol_ID + ",'整流器8欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod9_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod9_UnderVol_ID + ",'整流器9欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod10_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod10_UnderVol_ID + ",'整流器10欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod11_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod11_UnderVol_ID + ",'整流器11欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod12_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod12_UnderVol_ID + ",'整流器12欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod13_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod13_UnderVol_ID + ",'整流器13欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod14_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod14_UnderVol_ID + ",'整流器14欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod15_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod15_UnderVol_ID + ",'整流器15欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod16_UnderVol_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod16_UnderVol_ID + ",'整流器16欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod1_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod1_OverCurr_ID + ",'整流器1过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod2_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod2_OverCurr_ID + ",'整流器2过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod3_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod3_OverCurr_ID + ",'整流器3过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod4_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod4_OverCurr_ID + ",'整流器4过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod5_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod5_OverCurr_ID + ",'整流器5过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod6_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod6_OverCurr_ID + ",'整流器6过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod7_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod7_OverCurr_ID + ",'整流器7过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod8_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod8_OverCurr_ID + ",'整流器8过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod9_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod9_OverCurr_ID + ",'整流器9过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod10_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod10_OverCurr_ID + ",'整流器10过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod11_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod11_OverCurr_ID + ",'整流器11过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod12_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod12_OverCurr_ID + ",'整流器12过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod13_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod13_OverCurr_ID + ",'整流器13过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod14_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod14_OverCurr_ID + ",'整流器14过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID + ",'整流器15过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID + ",'整流器16过流告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod1_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod1_AC_Err_ID + ",'整流器1交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod2_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod2_AC_Err_ID + ",'整流器2交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod3_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod3_AC_Err_ID + ",'整流器3交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod4_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod4_AC_Err_ID + ",'整流器4交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod5_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod5_AC_Err_ID + ",'整流器5交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod6_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod6_AC_Err_ID + ",'整流器6交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod7_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod7_AC_Err_ID + ",'整流器7交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod8_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod8_AC_Err_ID + ",'整流器8交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod9_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod9_AC_Err_ID + ",'整流器9交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod10_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod10_AC_Err_ID + ",'整流器10交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod11_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod11_AC_Err_ID + ",'整流器11交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod12_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod12_AC_Err_ID + ",'整流器12交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod13_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod13_AC_Err_ID + ",'整流器13交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod14_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod14_AC_Err_ID + ",'整流器14交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod15_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod15_AC_Err_ID + ",'整流器15交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod16_AC_Err_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod16_AC_Err_ID + ",'整流器16交流异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_Trip_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_Trip_ID + ",'交流输入1跳闸告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn2_Trip_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn2_Trip_ID + ",'交流输入2跳闸告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_Fuse_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_Fuse_ID + ",'交流输入1熔丝告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn2_Fuse_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn2_Fuse_ID + ",'交流输入2熔丝告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_Unbalance_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_Unbalance_ID + ",'交流输入1三相不平衡告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn2_Unbalance_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn2_Unbalance_ID + ",'交流输入2三相不平衡告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_FreqErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_FreqErr_ID + ",'交流输入1频率异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn2_FreqErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn2_FreqErr_ID + ",'交流输入2频率异常告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_CPSS_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_CPSS_CommErr_ID + ",'协转通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_PWRDEV_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_PWRDEV_CommErr_ID + ",'电源通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_User_AcIn1_PowerDown_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_User_AcIn1_PowerDown_ID + ",'交流输入1停电告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_User_AcIn2_PowerDown_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_User_AcIn2_PowerDown_ID + ",'交流输入2停电告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_User_AcIn1_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_User_AcIn1_CommErr_ID + ",'交流1采集通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_User_AcIn2_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_User_AcIn2_CommErr_ID + ",'交流2采集通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Temp1_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Temp1_CommErr_ID + ",'温感1通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Temp2_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Temp2_CommErr_ID + ",'温感2通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Temp3_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Temp3_CommErr_ID + ",'温感3通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Humi1_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Humi1_CommErr_ID + ",'湿感1通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Humi2_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Humi2_CommErr_ID + ",'湿感2通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Humi3_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Humi3_CommErr_ID + ",'湿感3通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke1_Occur_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke1_Occur_ID + ",'烟感1报警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke2_Occur_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke2_Occur_ID + ",'烟感2报警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke3_Occur_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke3_Occur_ID + ",'烟感3报警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke1_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke1_CommErr_ID + ",'烟感1通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke2_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke2_CommErr_ID + ",'烟感2通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke3_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke3_CommErr_ID + ",'烟感3通信故障'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID + ",'2路交流A相过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID + ",'2路交流A相欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID + ",'2路交流A相缺相告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID + ",'2路交流B相过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID + ",'2路交流B相欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID + ",'2路交流B相缺相告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID + ",'2路交流C相过压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID + ",'2路交流C相欠压告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID + ",'2路交流C相缺相告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_PWRDEV_ERROR_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_PWRDEV_ERROR_ID + ",'电源告警'," + alm_category +");");
+ }
+
+ if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_PowerDown_CommErr_ID, pool)) {
+ sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_PowerDown_CommErr_ID + ",'交流停电通信故障'," + alm_category +");");
+ }
+
+ /****************************************************************************************************/
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
+
+
/**
* 创建 tb_dev_almparam 表
* @param pool
--
Gitblit v1.9.1