V1.85 edit at date 2023-08-15 1.创建表'db_alarm.tb_alarm_manual_clear' 2.创建表...

Administrator

2023-08-15 027d4a8e00a9881884824be44d9aee0289b747d4

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/bin/com/database_util/DB_Alarm.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/DB_Param.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/DB_web_site.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,6 +1,11 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    
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',并录入所有[电源，电池，设备告警是否能自动消失配置]

V1.84 edit at date 2023-07-27
    1.删除默认的电源交流停电告警参数
    2.默认插入国网电源2路的三相告警参数

 BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java

@@ -30,6 +30,8 @@
        createTb_Alarm_Detail_Table(pool, recreate);                //创建告警详情
        
        createTb_Alarm_Relation_Table(pool, recreate);                //创建告警对应关系
		
        createTb_Alarm_Manual_Clear_Table(pool,recreate);

        System.out.println(" db_alarm init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
    }
@@ -519,6 +521,60 @@
            sql.close_con();
        }
    }
    /**
     * 
     * @Title: create tb_alarm_manual_clear
     * @Description:告警对应关系
     * @param pool
     * @param recreate
     * @author author
     * @date 2021年9月6日
     */
    public static void createTb_Alarm_Manual_Clear_Table(MysqlConnPool pool, boolean recreate) {
        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Alarm_Manual_Clear_Table;
        String sql_str02 = "CREATE TABLE  IF NOT EXISTS " + Sql_Mysql.Tb_Alarm_Manual_Clear_Table + " (" + 
                "  `id` int(11) NOT NULL AUTO_INCREMENT," + 
                "  `station_id` varchar(10) DEFAULT NULL," + 
                "  `station_name1` varchar(45) DEFAULT NULL," + 
                "  `station_name2` varchar(45) DEFAULT NULL," + 
                "  `station_name3` varchar(45) DEFAULT NULL," + 
                "  `station_name5` varchar(45) DEFAULT NULL," + 
                "  `alarm_type` tinyint(4) DEFAULT NULL COMMENT '告警类型:1-电池,2-设备,3-电源'," + 
                "  `batt_group_id` int(11) DEFAULT NULL," + 
                "  `batt_group_name` varchar(45) DEFAULT NULL," + 
                "  `mon_num` int(11) DEFAULT NULL," + 
                "  `device_id` int(11) DEFAULT NULL," + 
                "  `device_name` varchar(45) DEFAULT NULL," + 
                "  `power_device_id` int(11) DEFAULT NULL," + 
                "  `alm_start_time` datetime DEFAULT NULL," + 
                "  `alm_id` int(11) DEFAULT NULL," + 
                "  `alm_signal_id` int(11) DEFAULT NULL," + 
                "  `reason` varchar(255) DEFAULT NULL COMMENT '恢复原因'," + 
                "  `create_time` datetime DEFAULT NULL," + 
                "  `deal_user_id` int(11) DEFAULT NULL," + 
                "  PRIMARY KEY (`id`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8;;";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        ResultSet res = null;
        try {
            if(true == recreate) {			
                sql.sqlMysqlExecute(sql_str01);
            }
            sql.sqlMysqlExecute(sql_str02);
			
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if(null != res) {
                try {
                    res.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            sql.close_con();
        }
    }
    
    
}

 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


 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java

@@ -814,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,alarm_name FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
        String sql_str_sel = "SELECT PowerDeviceId,alarm_name,alarm_type 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);
@@ -827,9 +827,11 @@
                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)) {
                int old_alm_type = res.getInt("alarm_type");
                if(!old_alm_name.equals(alarm_name) || (old_alm_type != alarm_type)) {
                    sql.sqlMysqlExecute("    UPDATE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table +
                                        " SET alarm_name = '" + alarm_name + "'" + 
                                        " ,alarm_type = " + alarm_type + " " + 
                                        " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id);
                }
            }

 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -99,6 +99,8 @@
        
        createFault_Upload_Table(pool, recreate);                    //故障隐患上传表
        
        createFbs9100_SetParam_Temp_Table(pool, recreate);            //本年度二次核容放电参数
		
        System.out.println(" DB_web_site init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
    }
    
@@ -5537,6 +5539,72 @@
            sql.close_con();
        }
    }
    /**
     *     故障隐患上传表
     * @param pool
     * @param recreate
     */
    public static void createFbs9100_SetParam_Temp_Table(MysqlConnPool pool, boolean recreate) {
        String sql_str_del = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Fbs9100_SetParam_Temp_Table;
        String sql_str = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Fbs9100_SetParam_Temp_Table + " (" + 
                " `num` int(11) NOT NULL AUTO_INCREMENT," + 
                "  `dev_id` int(11) DEFAULT NULL COMMENT '设备id'," + 
                "  `TestCmd` int(11) DEFAULT NULL COMMENT '测试类型'," + 
                "  `DisCurr` float DEFAULT NULL COMMENT '核容电流'," + 
                "  `DisCap` float DEFAULT NULL COMMENT '核容容量'," + 
                "  `DisTime` int(11) DEFAULT NULL COMMENT '核容时长'," + 
                "  `GroupVol_LOW` float DEFAULT NULL COMMENT '组端电压下限'," + 
                "  `MonomerVol_LOW` float DEFAULT NULL COMMENT '单体电压下限'," + 
                "  `MonomerTmp_High` float DEFAULT NULL COMMENT '单体温度上限'," + 
                "  `DCVolHighLimit` float DEFAULT NULL COMMENT '升压上限'," + 
                "  `ChargeCurrSet` float DEFAULT NULL COMMENT '充电电流'," + 
                "  `is_charge` int(11) DEFAULT NULL COMMENT '是否放电（0:未放电;1:已放电）'," + 
                "  `main_id` int(11) DEFAULT NULL COMMENT '审核工单主表id'," + 
                "  `battGroupId` int(11) NOT NULL DEFAULT '0' COMMENT '电池组id'," + 
                "  `noworhis` int(11) NOT NULL DEFAULT '0' COMMENT '是否时历史记录'," + 
                "  PRIMARY KEY (`num`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='本年度二次核容放电参数';";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        ResultSet res = null;
		
        try {
            if(recreate) {
                sql.sqlMysqlExecute(sql_str_del);
            }
            sql.sqlMysqlExecute(sql_str);
			
            //添加电池组id battGroupId
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='web_site'"
                    + " AND table_name='tb_fbs9100_setparam_temp'"
                    + " AND column_name='battGroupId'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Fbs9100_SetParam_Temp_Table 
                        + " ADD COLUMN `battGroupId` int(11) NOT NULL DEFAULT '0' COMMENT '电池组id';");
            }
            res = null;
            //添加 noworhis 是否时历史记录
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='web_site'"
                    + " AND table_name='tb_fbs9100_setparam_temp'"
                    + " AND column_name='noworhis'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Fbs9100_SetParam_Temp_Table 
                        + " ADD COLUMN `noworhis` int(11) NOT NULL DEFAULT '0' COMMENT '是否时历史记录';");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if(null != res) {
                try {
                    res.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }			
            sql.close_con();
        }
    }
    
    
    /**

 BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java

@@ -189,25 +189,25 @@
    /**
     *     山西电源部分电源告警id
     */
    public final static int ALM_TYPE_ACDC_AcIn1_A_OverV_ID          = 110001;            //交流A相过压	
    public final static int ALM_TYPE_ACDC_AcIn1_A_UnderV_ID      = 110002;            //交流A相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_A_Less_ID          = 110003;            //交流A相缺相
    public final static int ALM_TYPE_ACDC_AcIn1_B_OverV_ID          = 110004;            //交流B相过压
    public final static int ALM_TYPE_ACDC_AcIn1_B_UnderV_ID      = 110005;            //交流B相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_B_Less_ID          = 110006;            //交流B相缺相
    public final static int ALM_TYPE_ACDC_AcIn1_C_OverV_ID          = 110007;            //交流C相过压
    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_A_OverV_ID          = 110001;            //1路交流A相过压告警	
    public final static int ALM_TYPE_ACDC_AcIn1_A_UnderV_ID      = 110002;            //1路交流A相欠压告警
    public final static int ALM_TYPE_ACDC_AcIn1_A_Less_ID          = 110003;            //1路交流A相缺相告警
    public final static int ALM_TYPE_ACDC_AcIn1_B_OverV_ID          = 110004;            //1路交流B相过压告警
    public final static int ALM_TYPE_ACDC_AcIn1_B_UnderV_ID      = 110005;            //1路交流B相欠压告警
    public final static int ALM_TYPE_ACDC_AcIn1_B_Less_ID          = 110006;            //1路交流B相缺相告警
    public final static int ALM_TYPE_ACDC_AcIn1_C_OverV_ID          = 110007;            //1路交流C相过压告警
    public final static int ALM_TYPE_ACDC_AcIn1_C_UnderV_ID      = 110008;            //1路交流C相欠压告警
    public final static int ALM_TYPE_ACDC_AcIn1_C_Less_ID          = 110009;            //1路交流C相缺相告警
    
    public final static int ALM_TYPE_ACDC_AcIn1_PowerDown_ID     = 110010;            //交流停电
    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_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_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总故障
@@ -229,104 +229,104 @@
    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_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_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_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过压
    public final static int ALM_TYPE_ACDC_Mod4_OverVol_ID         = 110050;            //整流器4过压
    public final static int ALM_TYPE_ACDC_Mod5_OverVol_ID         = 110051;            //整流器5过压
    public final static int ALM_TYPE_ACDC_Mod6_OverVol_ID         = 110052;            //整流器6过压
    public final static int ALM_TYPE_ACDC_Mod7_OverVol_ID         = 110053;            //整流器7过压
    public final static int ALM_TYPE_ACDC_Mod8_OverVol_ID         = 110054;            //整流器8过压
    public final static int ALM_TYPE_ACDC_Mod9_OverVol_ID         = 110055;            //整流器9过压	
    public final static int ALM_TYPE_ACDC_Mod10_OverVol_ID         = 110056;            //整流器10过压
    public final static int ALM_TYPE_ACDC_Mod11_OverVol_ID         = 110057;            //整流器11过压
    public final static int ALM_TYPE_ACDC_Mod12_OverVol_ID         = 110058;            //整流器12过压
    public final static int ALM_TYPE_ACDC_Mod13_OverVol_ID         = 110059;            //整流器13过压
    public final static int ALM_TYPE_ACDC_Mod14_OverVol_ID         = 110060;            //整流器14过压
    public final static int ALM_TYPE_ACDC_Mod15_OverVol_ID         = 110061;            //整流器15过压
    public final static int ALM_TYPE_ACDC_Mod16_OverVol_ID         = 110062;            //整流器16过压
    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过压告警
    public final static int ALM_TYPE_ACDC_Mod4_OverVol_ID         = 110050;            //整流器4过压告警
    public final static int ALM_TYPE_ACDC_Mod5_OverVol_ID         = 110051;            //整流器5过压告警
    public final static int ALM_TYPE_ACDC_Mod6_OverVol_ID         = 110052;            //整流器6过压告警
    public final static int ALM_TYPE_ACDC_Mod7_OverVol_ID         = 110053;            //整流器7过压告警
    public final static int ALM_TYPE_ACDC_Mod8_OverVol_ID         = 110054;            //整流器8过压告警
    public final static int ALM_TYPE_ACDC_Mod9_OverVol_ID         = 110055;            //整流器9过压告警
    public final static int ALM_TYPE_ACDC_Mod10_OverVol_ID         = 110056;            //整流器10过压告警
    public final static int ALM_TYPE_ACDC_Mod11_OverVol_ID         = 110057;            //整流器11过压告警
    public final static int ALM_TYPE_ACDC_Mod12_OverVol_ID         = 110058;            //整流器12过压告警
    public final static int ALM_TYPE_ACDC_Mod13_OverVol_ID         = 110059;            //整流器13过压告警
    public final static int ALM_TYPE_ACDC_Mod14_OverVol_ID         = 110060;            //整流器14过压告警
    public final static int ALM_TYPE_ACDC_Mod15_OverVol_ID         = 110061;            //整流器15过压告警
    public final static int ALM_TYPE_ACDC_Mod16_OverVol_ID         = 110062;            //整流器16过压告警

    public final static int ALM_TYPE_ACDC_Mod1_UnderVol_ID         = 110063;            //整流器1欠压
    public final static int ALM_TYPE_ACDC_Mod2_UnderVol_ID         = 110064;            //整流器2欠压
    public final static int ALM_TYPE_ACDC_Mod3_UnderVol_ID         = 110065;            //整流器3欠压
    public final static int ALM_TYPE_ACDC_Mod4_UnderVol_ID         = 110066;            //整流器4欠压
    public final static int ALM_TYPE_ACDC_Mod5_UnderVol_ID         = 110067;            //整流器5欠压
    public final static int ALM_TYPE_ACDC_Mod6_UnderVol_ID         = 110068;            //整流器6欠压
    public final static int ALM_TYPE_ACDC_Mod7_UnderVol_ID         = 110069;            //整流器7欠压
    public final static int ALM_TYPE_ACDC_Mod8_UnderVol_ID         = 110070;            //整流器8欠压
    public final static int ALM_TYPE_ACDC_Mod9_UnderVol_ID         = 110071;            //整流器9欠压
    public final static int ALM_TYPE_ACDC_Mod10_UnderVol_ID     = 110072;            //整流器10欠压
    public final static int ALM_TYPE_ACDC_Mod11_UnderVol_ID     = 110073;            //整流器11欠压
    public final static int ALM_TYPE_ACDC_Mod12_UnderVol_ID     = 110074;            //整流器12欠压
    public final static int ALM_TYPE_ACDC_Mod13_UnderVol_ID     = 110075;            //整流器13欠压
    public final static int ALM_TYPE_ACDC_Mod14_UnderVol_ID     = 110076;            //整流器14欠压
    public final static int ALM_TYPE_ACDC_Mod15_UnderVol_ID     = 110077;            //整流器15欠压
    public final static int ALM_TYPE_ACDC_Mod16_UnderVol_ID     = 110078;            //整流器16欠压
    public final static int ALM_TYPE_ACDC_Mod1_UnderVol_ID         = 110063;            //整流器1欠压告警
    public final static int ALM_TYPE_ACDC_Mod2_UnderVol_ID         = 110064;            //整流器2欠压告警
    public final static int ALM_TYPE_ACDC_Mod3_UnderVol_ID         = 110065;            //整流器3欠压告警
    public final static int ALM_TYPE_ACDC_Mod4_UnderVol_ID         = 110066;            //整流器4欠压告警
    public final static int ALM_TYPE_ACDC_Mod5_UnderVol_ID         = 110067;            //整流器5欠压告警
    public final static int ALM_TYPE_ACDC_Mod6_UnderVol_ID         = 110068;            //整流器6欠压告警
    public final static int ALM_TYPE_ACDC_Mod7_UnderVol_ID         = 110069;            //整流器7欠压告警
    public final static int ALM_TYPE_ACDC_Mod8_UnderVol_ID         = 110070;            //整流器8欠压告警
    public final static int ALM_TYPE_ACDC_Mod9_UnderVol_ID         = 110071;            //整流器9欠压告警
    public final static int ALM_TYPE_ACDC_Mod10_UnderVol_ID     = 110072;            //整流器10欠压告警
    public final static int ALM_TYPE_ACDC_Mod11_UnderVol_ID     = 110073;            //整流器11欠压告警
    public final static int ALM_TYPE_ACDC_Mod12_UnderVol_ID     = 110074;            //整流器12欠压告警
    public final static int ALM_TYPE_ACDC_Mod13_UnderVol_ID     = 110075;            //整流器13欠压告警
    public final static int ALM_TYPE_ACDC_Mod14_UnderVol_ID     = 110076;            //整流器14欠压告警
    public final static int ALM_TYPE_ACDC_Mod15_UnderVol_ID     = 110077;            //整流器15欠压告警
    public final static int ALM_TYPE_ACDC_Mod16_UnderVol_ID     = 110078;            //整流器16欠压告警

    public final static int ALM_TYPE_ACDC_Mod1_OverCurr_ID         = 110079;            //整流器1过流
    public final static int ALM_TYPE_ACDC_Mod2_OverCurr_ID         = 110080;            //整流器2过流
    public final static int ALM_TYPE_ACDC_Mod3_OverCurr_ID         = 110081;            //整流器3过流
    public final static int ALM_TYPE_ACDC_Mod4_OverCurr_ID         = 110082;            //整流器4过流
    public final static int ALM_TYPE_ACDC_Mod5_OverCurr_ID         = 110083;            //整流器5过流
    public final static int ALM_TYPE_ACDC_Mod6_OverCurr_ID         = 110084;            //整流器6过流
    public final static int ALM_TYPE_ACDC_Mod7_OverCurr_ID         = 110085;            //整流器7过流
    public final static int ALM_TYPE_ACDC_Mod8_OverCurr_ID         = 110086;            //整流器8过流
    public final static int ALM_TYPE_ACDC_Mod9_OverCurr_ID         = 110087;            //整流器9过流
    public final static int ALM_TYPE_ACDC_Mod10_OverCurr_ID     = 110088;            //整流器10过流
    public final static int ALM_TYPE_ACDC_Mod11_OverCurr_ID     = 110089;            //整流器11过流
    public final static int ALM_TYPE_ACDC_Mod12_OverCurr_ID     = 110090;            //整流器12过流
    public final static int ALM_TYPE_ACDC_Mod13_OverCurr_ID     = 110091;            //整流器13过流
    public final static int ALM_TYPE_ACDC_Mod14_OverCurr_ID     = 110092;            //整流器14过流
    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_OverCurr_ID         = 110079;            //整流器1过流告警
    public final static int ALM_TYPE_ACDC_Mod2_OverCurr_ID         = 110080;            //整流器2过流告警
    public final static int ALM_TYPE_ACDC_Mod3_OverCurr_ID         = 110081;            //整流器3过流告警
    public final static int ALM_TYPE_ACDC_Mod4_OverCurr_ID         = 110082;            //整流器4过流告警
    public final static int ALM_TYPE_ACDC_Mod5_OverCurr_ID         = 110083;            //整流器5过流告警
    public final static int ALM_TYPE_ACDC_Mod6_OverCurr_ID         = 110084;            //整流器6过流告警
    public final static int ALM_TYPE_ACDC_Mod7_OverCurr_ID         = 110085;            //整流器7过流告警
    public final static int ALM_TYPE_ACDC_Mod8_OverCurr_ID         = 110086;            //整流器8过流告警
    public final static int ALM_TYPE_ACDC_Mod9_OverCurr_ID         = 110087;            //整流器9过流告警
    public final static int ALM_TYPE_ACDC_Mod10_OverCurr_ID     = 110088;            //整流器10过流告警
    public final static int ALM_TYPE_ACDC_Mod11_OverCurr_ID     = 110089;            //整流器11过流告警
    public final static int ALM_TYPE_ACDC_Mod12_OverCurr_ID     = 110090;            //整流器12过流告警
    public final static int ALM_TYPE_ACDC_Mod13_OverCurr_ID     = 110091;            //整流器13过流告警
    public final static int ALM_TYPE_ACDC_Mod14_OverCurr_ID     = 110092;            //整流器14过流告警
    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_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_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_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_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通信故障
@@ -342,15 +342,15 @@
    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 ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID      = 110137;        //2路交流A相过压	
    public final static int ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID   = 110138;        //2路交流A相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID      = 110139;        //2路交流A相缺相
    public final static int ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID      = 110140;        //2路交流B相过压
    public final static int ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID   = 110141;        //2路交流B相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID      = 110142;        //2路交流B相缺相
    public final static int ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID      = 110143;        //2路交流C相过压
    public final static int ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID   = 110144;        //2路交流C相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID      = 110145;        //2路交流C相缺相
    public final static int ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID      = 110137;        //2路交流A相过压告警	
    public final static int ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID   = 110138;        //2路交流A相欠压告警
    public final static int ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID      = 110139;        //2路交流A相缺相告警
    public final static int ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID      = 110140;        //2路交流B相过压告警
    public final static int ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID   = 110141;        //2路交流B相欠压告警
    public final static int ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID      = 110142;        //2路交流B相缺相告警
    public final static int ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID      = 110143;        //2路交流C相过压告警
    public final static int ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID   = 110144;        //2路交流C相欠压告警
    public final static int ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID      = 110145;        //2路交流C相缺相告警
    
    public final static int ALM_TYPE_PWRDEV_ERROR_ID                   = 110146;        //电源告警
    public final static int ALM_TYPE_ACDC_PowerDown_CommErr_ID           = 110147;        //交流停电通信故障

 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -245,7 +245,8 @@
    public static final String Tb_Workflow_Main_Table = WEB_Site +".`tb_workflow_main`";                        //工作流主表
    
    public static final String Tb_Fault_Upload_Table = WEB_Site +".`tb_fault_upload`";                            //故障隐患上传表,用于故障隐患考核
	
    public static final String Tb_Fbs9100_SetParam_Temp_Table = WEB_Site +".`tb_fbs9100_setparam_temp`";        //本年度二次核容放电参数考核
																			 
    /***************************** db_battinf数据库  ***************************************/
    public final static String DeverrorRecord_Table = DB_BATT_INF + ".`tb_deverror_record`";                        //机房问题记录表
    public final static String BattinfApply_TABLE = DB_BATT_INF + ".`tb_battinf_apply`";                            //机房安装审批表
@@ -279,6 +280,7 @@
    public final static String Tb_Alarm_Message = DB_ALARM + ".`tb_alarm_message`";
    public final static String Tb_Alarm_Detail_Table = DB_ALARM + ".`tb_alarm_detail`";
    public final static String Tb_Alarm_Relation_Table = DB_ALARM + ".`tb_alarm_relation`";
    public final static String Tb_Alarm_Manual_Clear_Table = DB_ALARM + ".`tb_alarm_manual_clear`";
    
    
    /***************************** db_app_sys 数据库  ***************************************/
@@ -314,6 +316,7 @@
    public final static String App_Param_Table = DB_PARAM + ".`tb_app_param`";
    public final static String Alarm_Param_Table = DB_PARAM + ".`tb_alarm_param`";
    public final static String Dev_AlmParam_Table = DB_PARAM + ".`tb_dev_almparam`";                    //设备告警参数表
    public final static String AppAlm_Param_Table = DB_PARAM + ".`tb_appalm_param`";                    //平台告警参数表
    
    /***************************** db_pwrdev_alarm 数据库  ************************************/
    public final static String Pwrdev_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm`";

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,6 +1,11 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    
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',并录入所有[电源，电池，设备告警是否能自动消失配置]

V1.84 edit at date 2023-07-27
    1.删除默认的电源交流停电告警参数
    2.默认插入国网电源2路的三相告警参数

 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.84;
    public final static float m_VersionNum = (float) 1.85;
    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
    /**************************************************************************/
    /**************************************************************************/