注意:1.新增电源机房时需要重新运行

Administrator

2023-05-19 fc1671346a578cd47f39eb5c578d802b6eac1c4f

注意:1.新增电源机房时需要重新运行


V1.74 edit at date 2023-05-19
	1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增电源告警使能
		`alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT
'告警来源是点位时告警使能[0:不启用；1：启用]'
	2.初始默认录入所有机房的 所有的电源告警参数

 BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/SqlsUtils.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,4 +1,11 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
	

V1.74 edit at date 2023-05-19
    1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增电源告警使能
        `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]'
    2.初始默认录入所有机房的 所有的电源告警参数 

V1.73 edit at date 2023-05-16
    1.删除线程监控中平台线程的记录,避免平台线程一直重启

 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) {                

 BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java

@@ -192,10 +192,50 @@
    public final static int ALM_TYPE_ACDC_AcIn1_C_UnderV_ID      = 110008;            //交流C相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_C_Less_ID          = 110009;            //交流C相缺相
    
    public final static int ALM_TYPE_ACDC_AcIn1_PowerDown_ID     = 110010;            //交流停电
    public final static int ALM_TYPE_ACDC_AcIn1_ThunderErr_ID     = 110011;            //防雷器故障

    public final static int ALM_TYPE_ACDC_DCout_OverV_ID         = 110012;            //直流电压过高
    public final static int ALM_TYPE_ACDC_DCout_UnderV_ID         = 110013;            //直流电压过低

    public final static int ALM_TYPE_ACDC_LoaderFuse_ID         = 110014;            //负载熔断
    public final static int ALM_TYPE_ACDC_BattGrp1Fuse_ID         = 110015;            //电池组1熔断
    public final static int ALM_TYPE_ACDC_BattGrp2Fuse_ID         = 110016;            //电池组2熔断

    public final static int ALM_TYPE_ACDC_Module1Err_ID         = 110017;            //整流器1总故障
    public final static int ALM_TYPE_ACDC_Module2Err_ID         = 110018;            //整流器2总故障
    public final static int ALM_TYPE_ACDC_Module3Err_ID         = 110019;            //整流器3总故障
    public final static int ALM_TYPE_ACDC_Module4Err_ID         = 110020;            //整流器4总故障
    public final static int ALM_TYPE_ACDC_Module5Err_ID         = 110021;            //整流器5总故障
    public final static int ALM_TYPE_ACDC_Module6Err_ID         = 110022;            //整流器6总故障
    public final static int ALM_TYPE_ACDC_Module7Err_ID         = 110023;            //整流器7总故障
    public final static int ALM_TYPE_ACDC_Module8Err_ID         = 110024;            //整流器8总故障
    public final static int ALM_TYPE_ACDC_Module9Err_ID         = 110025;            //整流器9总故障
    public final static int ALM_TYPE_ACDC_Module10Err_ID         = 110026;            //整流器10总故障
    public final static int ALM_TYPE_ACDC_Module11Err_ID         = 110027;            //整流器11总故障
    public final static int ALM_TYPE_ACDC_Module12Err_ID         = 110028;            //整流器12总故障
    public final static int ALM_TYPE_ACDC_Module13Err_ID         = 110029;            //整流器13总故障
    public final static int ALM_TYPE_ACDC_Module14Err_ID         = 110030;            //整流器14总故障
    public final static int ALM_TYPE_ACDC_Module15Err_ID         = 110031;            //整流器15总故障
    public final static int ALM_TYPE_ACDC_Module16Err_ID         = 110032;            //整流器16总故障

    public final static int ALM_TYPE_ACDC_AcAlarm_ID             = 110033;            //交流总故障
    public final static int ALM_TYPE_ACDC_DcAlarm_ID             = 110034;            //直流总故障
    
    public final static int ALM_TYPE_ACDC_Acb1_OverCurrA_ID     = 110035;            //交流A相过流
    public final static int ALM_TYPE_ACDC_Acb1_OverCurrB_ID     = 110036;            //交流B相过流
    public final static int ALM_TYPE_ACDC_Acb1_OverCurrC_ID     = 110037;            //交流C相过流

    public final static int ALM_TYPE_ACDC_MonitorErr_ID         = 110038;            //监控器故障
    public final static int ALM_TYPE_ACDC_DcOut_OverCurr_ID     = 110039;            //直流过流
    public final static int ALM_TYPE_ACDC_TolalAlarm_ID         = 110040;            //开关柜总报警
    public final static int ALM_TYPE_ACDC_Batt1_VolLow_ID         = 110041;            //电池组1电压低
    public final static int ALM_TYPE_ACDC_Batt2_VolLow_ID         = 110042;            //电池组2电压低
    public final static int ALM_TYPE_ACDC_Batt1_Down_ID         = 110043;            //电池组1下电
    public final static int ALM_TYPE_ACDC_Batt2_Down_ID         = 110044;            //电池组2下电
    public final static int ALM_TYPE_ACDC_Batt1_OverChgCurr_ID     = 110045;            //电池组1充电过流
    public final static int ALM_TYPE_ACDC_Batt2_OverChgCurr_ID     = 110046;            //电池组2充电过流
	
    public final static int ALM_TYPE_ACDC_Mod1_OverVol_ID         = 110047;            //整流器1过压
    public final static int ALM_TYPE_ACDC_Mod2_OverVol_ID         = 110048;            //整流器2过压
    public final static int ALM_TYPE_ACDC_Mod3_OverVol_ID         = 110049;            //整流器3过压
@@ -247,6 +287,53 @@
    public final static int ALM_TYPE_ACDC_Mod15_OverCurr_ID     = 110093;            //整流器15过流
    public final static int ALM_TYPE_ACDC_Mod16_OverCurr_ID     = 110094;            //整流器16过流
    
    public final static int ALM_TYPE_ACDC_Mod1_AC_Err_ID         = 110095;            //整流器1交流异常
    public final static int ALM_TYPE_ACDC_Mod2_AC_Err_ID         = 110096;            //整流器2交流异常
    public final static int ALM_TYPE_ACDC_Mod3_AC_Err_ID         = 110097;            //整流器3交流异常
    public final static int ALM_TYPE_ACDC_Mod4_AC_Err_ID         = 110098;            //整流器4交流异常
    public final static int ALM_TYPE_ACDC_Mod5_AC_Err_ID         = 110099;            //整流器5交流异常
    public final static int ALM_TYPE_ACDC_Mod6_AC_Err_ID         = 110100;            //整流器6交流异常
    public final static int ALM_TYPE_ACDC_Mod7_AC_Err_ID         = 110101;            //整流器7交流异常
    public final static int ALM_TYPE_ACDC_Mod8_AC_Err_ID         = 110102;            //整流器8交流异常
    public final static int ALM_TYPE_ACDC_Mod9_AC_Err_ID         = 110103;            //整流器9交流异常
    public final static int ALM_TYPE_ACDC_Mod10_AC_Err_ID         = 110104;            //整流器10交流异常
    public final static int ALM_TYPE_ACDC_Mod11_AC_Err_ID         = 110105;            //整流器11交流异常
    public final static int ALM_TYPE_ACDC_Mod12_AC_Err_ID         = 110106;            //整流器12交流异常
    public final static int ALM_TYPE_ACDC_Mod13_AC_Err_ID         = 110107;            //整流器13交流异常
    public final static int ALM_TYPE_ACDC_Mod14_AC_Err_ID         = 110108;            //整流器14交流异常
    public final static int ALM_TYPE_ACDC_Mod15_AC_Err_ID         = 110109;            //整流器15交流异常
    public final static int ALM_TYPE_ACDC_Mod16_AC_Err_ID         = 110110;            //整流器16交流异常

    public final static int ALM_TYPE_ACDC_AcIn1_Trip_ID         = 110111;            //交流输入1跳闸
    public final static int ALM_TYPE_ACDC_AcIn2_Trip_ID         = 110112;            //交流输入2跳闸
    public final static int ALM_TYPE_ACDC_AcIn1_Fuse_ID         = 110113;            //交流输入1熔丝告警	
    public final static int ALM_TYPE_ACDC_AcIn2_Fuse_ID         = 110114;            //交流输入2熔丝告警
    public final static int ALM_TYPE_ACDC_AcIn1_Unbalance_ID     = 110115;            //交流输入1三相不平衡
    public final static int ALM_TYPE_ACDC_AcIn2_Unbalance_ID     = 110116;            //交流输入2三相不平衡
    public final static int ALM_TYPE_ACDC_AcIn1_FreqErr_ID         = 110117;            //交流输入1频率异常
    public final static int ALM_TYPE_ACDC_AcIn2_FreqErr_ID         = 110118;            //交流输入2频率异常

    public final static int ALM_TYPE_ACDC_CPSS_CommErr_ID         = 110119;            //协转通信故障

    //1+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    public final static int ALM_TYPE_PWRDEV_CommErr_ID             = 110120;            //电源通信故障
    		
    public final static int ALM_TYPE_User_AcIn1_PowerDown_ID     = 110121;            //交流输入1停电	
    public final static int ALM_TYPE_User_AcIn2_PowerDown_ID     = 110122;            //交流输入2停电
    public final static int ALM_TYPE_User_AcIn1_CommErr_ID         = 110123;            //交流1采集通信故障
    public final static int ALM_TYPE_User_AcIn2_CommErr_ID         = 110124;            //交流2采集通信故障
    public final static int ALM_TYPE_Envm_Temp1_CommErr_ID         = 110125;            //温感1通信故障
    public final static int ALM_TYPE_Envm_Temp2_CommErr_ID         = 110126;            //温感2通信故障
    public final static int ALM_TYPE_Envm_Temp3_CommErr_ID         = 110127;            //温感3通信故障
    public final static int ALM_TYPE_Envm_Humi1_CommErr_ID         = 110128;            //湿感1通信故障
    public final static int ALM_TYPE_Envm_Humi2_CommErr_ID         = 110129;            //湿感2通信故障
    public final static int ALM_TYPE_Envm_Humi3_CommErr_ID         = 110130;            //湿感3通信故障
    public final static int ALM_TYPE_Envm_Smoke1_Occur_ID         = 110131;            //烟感1报警
    public final static int ALM_TYPE_Envm_Smoke2_Occur_ID         = 110132;            //烟感2报警
    public final static int ALM_TYPE_Envm_Smoke3_Occur_ID         = 110133;            //烟感3报警
    public final static int ALM_TYPE_Envm_Smoke1_CommErr_ID     = 110134;            //烟感1通信故障
    public final static int ALM_TYPE_Envm_Smoke2_CommErr_ID     = 110135;            //烟感2通信故障
    public final static int ALM_TYPE_Envm_Smoke3_CommErr_ID     = 110136;            //烟感3通信故障
    
    public final static int Alarm_Type_TotalEff                 = 0;                //上下限有效
    public final static int Alarm_Type_TotalHigh                 = 1;                //上限有效

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,4 +1,11 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
	

V1.74 edit at date 2023-05-19
    1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增电源告警使能
        `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]'
    2.初始默认录入所有机房的 所有的电源告警参数 

V1.73 edit at date 2023-05-16
    1.删除线程监控中平台线程的记录,避免平台线程一直重启

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -32,7 +32,7 @@
    /**************************************************************************/
    /**************************************************************************/
    public final static boolean app_debug = false;
    public final static float m_VersionNum = (float) 1.73;
    public final static float m_VersionNum = (float) 1.74;
    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
    /**************************************************************************/
    /**************************************************************************/