~whyclj/BattMonitor_DB_Builder.git

parent: bf782524 | 补丁 | 提交 | show whitespace

V1.62 edit at date 2023-03-22 1.创建山西电源告警参数表'db_pwrdev_alarm.tb_pwrdev_alar...

Administrator

2023-03-22 1c292d4397f410497bebe111a558bc1d5469149b

V1.62 edit at date 2023-03-22
	1.创建山西电源告警参数表'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'，并录入所有电源设备告警参数
		CREATE TABLE `tb_pwrdev_alarm_param_forsx` (
		  `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
		  `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT '电源id',
		  `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '告警id',
		  `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '告警等级',
		  `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '告警上限阈值',
		  `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上限告警使能',
		  `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '告警下限阈值',
		  `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警下限使能',
		  `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-下限有效',
		  PRIMARY KEY (`num`)
		) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8
COMMENT='山西电源告警参数表';
	2.表'db_pwrdev_alarm.tb_pwrdev_alarm'表新增字段   用于标识当前告警来源
		`alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT
'告警来源[0-来源于点表；1-来源于电源告警参数]'
	3.表'db_pwrdev_alarm.tb_pwrdev_alarm_history'表新增字段   用于标识当前告警来源
		`alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT
'告警来源[0-来源于点表；1-来源于电源告警参数]'

6个文件已修改

	BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt	24 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java	242 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java	89 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt	24 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,6 +1,28 @@
蓄电池监控平台建表程序

V1.61 edit at date 2023-03-16
V1.62 edit at date 2023-03-22
    1.创建山西电源告警参数表'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'，并录入所有电源设备告警参数
        CREATE TABLE `tb_pwrdev_alarm_param_forsx` (
          `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
          `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT '电源id',
          `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '告警id',
          `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '告警等级',
          `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '告警上限阈值',
          `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上限告警使能',
          `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '告警下限阈值',
          `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警下限使能',
          `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-下限有效',
          PRIMARY KEY (`num`)
        ) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';
    2.表'db_pwrdev_alarm.tb_pwrdev_alarm'表新增字段   用于标识当前告警来源
        `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'
    3.表'db_pwrdev_alarm.tb_pwrdev_alarm_history'表新增字段   用于标识当前告警来源
        `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'


V1.61 edit at date 2023-03-17
    1.'web_site.tb_battdischarge_plan'表新增字段'nodeStation'
        `nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '站点类型[节点站标识:0:不是节点站[默认];1:节点站]'
    2.'web_site.tb_battdischarge_plan'表新增字段'baoji_group_id'

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java

@@ -26,6 +26,7 @@
        
        createPwrdev_Time_Out_Alarm_Table(pool, recreate);        
        
        createPwrdev_Alarm_Param_ForSX_Table(pool, recreate);		

        System.out.println(" db_pwrdev_alarm init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
        
@@ -179,6 +180,7 @@
                "  `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + 
                "  `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," + 
                "  `usr_Id` int(11) NOT NULL DEFAULT '0'," + 
                "  `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'," + 
                "  PRIMARY KEY (`num`)," + 
                "  KEY `index_record_id` (`record_id`)," + 
                "  KEY `index_pwrdev_id` (`PowerDeviceId`)," + 
@@ -214,6 +216,15 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table 
                                + " ADD COLUMN `alm_index` int(11) NOT NULL DEFAULT '0'");
            }
            //添加 alm_trigger  告警触发来源[0-来源于点表；1-来源于电源告警参数]
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_pwrdev_alarm'"
                    + " AND table_name='tb_pwrdev_alarm'"
                    + " AND column_name='alm_trigger'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table 
                        + " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
@@ -243,6 +254,7 @@
                "  `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + 
                "  `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," + 
                "  `usr_Id` int(11) NOT NULL DEFAULT '0'," + 
                "  `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'," + 
                "  PRIMARY KEY (`num`)," + 
                "  KEY `index_record_id` (`record_id`)," + 
                "  KEY `index_pwrdev_id` (`PowerDeviceId`)," + 
@@ -278,10 +290,240 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table 
                                + " ADD COLUMN `alm_index` int(11) NOT NULL DEFAULT '0'");
            }
            //添加 alm_trigger -- 告警触发来源[0-来源于点表；1-来源于电源告警参数]
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_pwrdev_alarm'"
                    + " AND table_name='tb_pwrdev_alarm_history'"
                    + " AND column_name='alm_trigger'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table 
                        + " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            sql.close_con();
        }
    }
	
    private static void createPwrdev_Alarm_Param_ForSX_Table(MysqlConnPool pool, boolean recreate) {
        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table;
        String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " (" + 
                "  `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键'," + 
                "  `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT '电源id'," + 
                "  `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '告警id'," + 
                "  `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '告警等级'," + 
                "  `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '告警上限阈值'," + 
                "  `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上限告警使能'," + 
                "  `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '告警下限阈值'," + 
                "  `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警下限使能'," + 
                "  `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-下限有效'," + 
                "  PRIMARY KEY (`num`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        ResultSet res  = null;
        try {
            if(true == recreate) {			
                sql.sqlMysqlExecute(sql_str01);
            }
            sql.sqlMysqlExecute(sql_str02);
            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);
                //交流A相欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流A相欠压告警",2,pool);
                //交流A相缺相告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流A相缺相告警",2,pool);
                //交流B相过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流B相过压告警",1,pool);
                //交流B相欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流B相欠压告警",2,pool);
                //交流B相缺相告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流C相缺相告警",2,pool);
                //交流C相过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流C相过压告警",1,pool);
                //交流C相欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流C相欠压告警",2,pool);
                //交流C相缺相告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流C相缺相告警",2,pool);
				
                //交流A相过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"交流A相过流告警",1,pool);
                //交流B相过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"交流B相过流告警",1,pool);
                //交流C相过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"交流C相过流告警",1,pool);
				
				
                //整流器1过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器1过压告警",1,pool);
                //整流器2过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器2过压告警",1,pool);
                //整流器3过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器3过压告警",1,pool);
                //整流器4过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器4过压告警",1,pool);
                //整流器5过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器5过压告警",1,pool);
                //整流器6过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器6过压告警",1,pool);
                //整流器7过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器7过压告警",1,pool);
                //整流器8过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器8过压告警",1,pool);
                //整流器9过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器9过压告警",1,pool);
                //整流器10过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器10过压告警",1,pool);
                //整流器11过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器11过压告警",1,pool);
                //整流器12过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器12过压告警",1,pool);
                //整流器13过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器13过压告警",1,pool);
                //整流器14过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器14过压告警",1,pool);
                //整流器15过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器15过压告警",1,pool);
                //整流器16过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器16过压告警",1,pool);

                //整流器1欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器1欠压告警",2,pool);
                //整流器2欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器2欠压告警",2,pool);
                //整流器3欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器3欠压告警",2,pool);
                //整流器4欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器4欠压告警",2,pool);
                //整流器5欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器5欠压告警",2,pool);
                //整流器6欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器6欠压告警",2,pool);
                //整流器7欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器7欠压告警",2,pool);
                //整流器8欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器8欠压告警",2,pool);
                //整流器9欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器9欠压告警",2,pool);
                //整流器10欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器10欠压告警",2,pool);
                //整流器11欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器11欠压告警",2,pool);
                //整流器12欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器12欠压告警",2,pool);
                //整流器13欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器13欠压告警",2,pool);
                //整流器14欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器14欠压告警",2,pool);
                //整流器15欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器15欠压告警",2,pool);
                //整流器16欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器16欠压告警",2,pool);

                //整流器1过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器1过流告警",1,pool);
                //整流器2过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器2过流告警",1,pool);
                //整流器3过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器3过流告警",1,pool);
                //整流器4过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器4过流告警",1,pool);
                //整流器5过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器5过流告警",1,pool);
                //整流器6过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器6过流告警",1,pool);
                //整流器7过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器7过流告警",1,pool);
                //整流器8过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器8过流告警",1,pool);
                //整流器9过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器9过流告警",1,pool);
                //整流器10过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器10过流告警",1,pool);
                //整流器11过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器11过流告警",1,pool);
                //整流器12过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器12过流告警",1,pool);
                //整流器13过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器13过流告警",1,pool);
                //整流器14过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器14过流告警",1,pool);
                //整流器15过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器15过流告警",1,pool);
                //整流器16过流告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器16过流告警",1,pool);

				
                //System.out.println(PowerDeviceId +" == " + buf_body );
            }			
            if(buf_body.length() > 0) {				
                sql.sqlMysqlExecute((buf_base.append(buf_body)).toString());
            }			
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if(null != res) {
                try {
                    res.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            sql.close_con();
        }
    }
	
    /**
     * 
     * @param buf_body            sql_str
     * @param PowerDeviceId        电源id
     * @param alm_id            告警id
     * @param alm_level            告警等级
     * @param alarm_limitH        上限阈值
     * @param alarm_limitH_EN    上限阈值使能
     * @param alarm_limitL        下限阈值
     * @param alarm_limitL_EN    下限阈值使能
     * @param alarm_name        告警描述
     * @param alarm_type        告警有效  0-上下限有效  1-上限有效  2-下限有效
     */
    public static void checkPowerAlarmParam(StringBuffer buf_body,int PowerDeviceId,int alm_id,int alm_level,float alarm_limitH,boolean alarm_limitH_EN, float alarm_limitL, boolean alarm_limitL_EN,String alarm_name,int alarm_type,MysqlConnPool pool) {
        String sql_str_sel = "SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        ResultSet res = null; 
        res = sql.sqlMysqlQuery(sql_str_sel);
        //System.out.println(sql_str_sel);
        try {
            if(!res.next()) {
                if(buf_body.length() > 0) {
                    buf_body.append(",");
                }
                buf_body.append("("+PowerDeviceId+","+alm_id+","+alm_level+","+alarm_limitH+","+alarm_limitH_EN+","+alarm_limitL+","+alarm_limitL_EN+",'"+alarm_name+"',"+alarm_type+")");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if(null != res) {
                try {
                    res.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            sql.close_con();
        }
    }
	
	
    public static void main(String[] args) {
        MysqlConnPool pool = new MysqlConnPool("192.168.10.79", 3360, 5);
        createPwrdev_Alarm_Param_ForSX_Table(pool, false);
    }
}

 BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java

@@ -90,6 +90,95 @@
            sqlstb_page_param.add(strs[i]);
        }
    }
    
    
    
    /**
     *     山西电源部分电源告警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_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_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_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 Alarm_Type_TotalEff                 = 0;                //上下限有效
    public final static int Alarm_Type_TotalHigh                 = 1;                //上限有效
    public final static int Alarm_Type_TotalLow                 = 2;                //下限有效
    
    
    public final static int Alarm_Level_First                     = 1;                //1级告警
    public final static int Alarm_Level_Second                     = 2;                //2级告警
    public final static int Alarm_Level_Third                     = 3;                //3级告警
    public final static int Alarm_Level_Fourth                     = 4;                //4级告警
    
    
    
    
    
    
    
    

//    public static void main(String[] args) {
//        System.out.println("SqlsUtils.sqlstb_page_param2 = " + SqlsUtils.sqlstb_page_param2);

 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -312,6 +312,8 @@
    public final static String Pwrdev_Time_Adj_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_time_adj_alarm`";
    public final static String Pwrdev_Time_Out_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_time_out_alarm`";
    
    public final static String Pwrdev_Alarm_Param_ForSX_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_param_forsx`";        //山西电源告警参数表			
	
    
    
    /***************************** db_pwrdev_data_rt 数据库  ************************************/

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,6 +1,28 @@
蓄电池监控平台建表程序

V1.61 edit at date 2023-03-16
V1.62 edit at date 2023-03-22
    1.创建山西电源告警参数表'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'，并录入所有电源设备告警参数
        CREATE TABLE `tb_pwrdev_alarm_param_forsx` (
          `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
          `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT '电源id',
          `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '告警id',
          `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '告警等级',
          `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '告警上限阈值',
          `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上限告警使能',
          `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '告警下限阈值',
          `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警下限使能',
          `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-下限有效',
          PRIMARY KEY (`num`)
        ) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';
    2.表'db_pwrdev_alarm.tb_pwrdev_alarm'表新增字段   用于标识当前告警来源
        `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'
    3.表'db_pwrdev_alarm.tb_pwrdev_alarm_history'表新增字段   用于标识当前告警来源
        `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'


V1.61 edit at date 2023-03-17
    1.'web_site.tb_battdischarge_plan'表新增字段'nodeStation'
        `nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '站点类型[节点站标识:0:不是节点站[默认];1:节点站]'
    2.'web_site.tb_battdischarge_plan'表新增字段'baoji_group_id'

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

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

			@@ -1,6 +1,28 @@
			蓄电池监控平台建表程序

			V1.61 edit at date 2023-03-16
			V1.62 edit at date 2023-03-22
			1.创建山西电源告警参数表'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'，并录入所有电源设备告警参数
			CREATE TABLE `tb_pwrdev_alarm_param_forsx` (
			`num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
			`PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT '电源id',
			`alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '告警id',
			`alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '告警等级',
			`alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '告警上限阈值',
			`alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上限告警使能',
			`alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '告警下限阈值',
			`alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警下限使能',
			`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-下限有效',
			PRIMARY KEY (`num`)
			) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';
			2.表'db_pwrdev_alarm.tb_pwrdev_alarm'表新增字段用于标识当前告警来源
			`alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'
			3.表'db_pwrdev_alarm.tb_pwrdev_alarm_history'表新增字段用于标识当前告警来源
			`alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'


			V1.61 edit at date 2023-03-17
			1.'web_site.tb_battdischarge_plan'表新增字段'nodeStation'
			`nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '站点类型[节点站标识:0:不是节点站[默认];1:节点站]'
			2.'web_site.tb_battdischarge_plan'表新增字段'baoji_group_id'

			@@ -26,6 +26,7 @@

			createPwrdev_Time_Out_Alarm_Table(pool, recreate);

			createPwrdev_Alarm_Param_ForSX_Table(pool, recreate);

			System.out.println(" db_pwrdev_alarm init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));

			@@ -179,6 +180,7 @@
			" `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
			" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
			" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
			" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'," +
			" PRIMARY KEY (`num`)," +
			" KEY `index_record_id` (`record_id`)," +
			" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
			@@ -214,6 +216,15 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
			+ " ADD COLUMN `alm_index` int(11) NOT NULL DEFAULT '0'");
			}
			//添加 alm_trigger 告警触发来源[0-来源于点表；1-来源于电源告警参数]
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_pwrdev_alarm'"
			+ " AND table_name='tb_pwrdev_alarm'"
			+ " AND column_name='alm_trigger'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
			+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			@@ -243,6 +254,7 @@
			" `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
			" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
			" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
			" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'," +
			" PRIMARY KEY (`num`)," +
			" KEY `index_record_id` (`record_id`)," +
			" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
			@@ -278,10 +290,240 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
			+ " ADD COLUMN `alm_index` int(11) NOT NULL DEFAULT '0'");
			}
			//添加 alm_trigger -- 告警触发来源[0-来源于点表；1-来源于电源告警参数]
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_pwrdev_alarm'"
			+ " AND table_name='tb_pwrdev_alarm_history'"
			+ " AND column_name='alm_trigger'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
			+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			sql.close_con();
			}
			}

			private static void createPwrdev_Alarm_Param_ForSX_Table(MysqlConnPool pool, boolean recreate) {
			String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table;
			String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " (" +
			" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键'," +
			" `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT '电源id'," +
			" `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '告警id'," +
			" `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '告警等级'," +
			" `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '告警上限阈值'," +
			" `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上限告警使能'," +
			" `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '告警下限阈值'," +
			" `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警下限使能'," +
			" `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-下限有效'," +
			" PRIMARY KEY (`num`)" +
			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
			Sql_Mysql sql = new Sql_Mysql(pool.getConn());
			ResultSet res = null;
			try {
			if(true == recreate) {
			sql.sqlMysqlExecute(sql_str01);
			}
			sql.sqlMysqlExecute(sql_str02);
			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);
			//交流A相欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流A相欠压告警",2,pool);
			//交流A相缺相告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流A相缺相告警",2,pool);
			//交流B相过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流B相过压告警",1,pool);
			//交流B相欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流B相欠压告警",2,pool);
			//交流B相缺相告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流C相缺相告警",2,pool);
			//交流C相过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流C相过压告警",1,pool);
			//交流C相欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流C相欠压告警",2,pool);
			//交流C相缺相告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流C相缺相告警",2,pool);

			//交流A相过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"交流A相过流告警",1,pool);
			//交流B相过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"交流B相过流告警",1,pool);
			//交流C相过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"交流C相过流告警",1,pool);


			//整流器1过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器1过压告警",1,pool);
			//整流器2过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器2过压告警",1,pool);
			//整流器3过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器3过压告警",1,pool);
			//整流器4过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器4过压告警",1,pool);
			//整流器5过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器5过压告警",1,pool);
			//整流器6过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器6过压告警",1,pool);
			//整流器7过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器7过压告警",1,pool);
			//整流器8过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器8过压告警",1,pool);
			//整流器9过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器9过压告警",1,pool);
			//整流器10过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器10过压告警",1,pool);
			//整流器11过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器11过压告警",1,pool);
			//整流器12过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器12过压告警",1,pool);
			//整流器13过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器13过压告警",1,pool);
			//整流器14过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器14过压告警",1,pool);
			//整流器15过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器15过压告警",1,pool);
			//整流器16过压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverVol_ID,SqlsUtils.Alarm_Level_Second,198,true, 135,false,"整流器16过压告警",1,pool);

			//整流器1欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器1欠压告警",2,pool);
			//整流器2欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器2欠压告警",2,pool);
			//整流器3欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器3欠压告警",2,pool);
			//整流器4欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器4欠压告警",2,pool);
			//整流器5欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器5欠压告警",2,pool);
			//整流器6欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器6欠压告警",2,pool);
			//整流器7欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器7欠压告警",2,pool);
			//整流器8欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器8欠压告警",2,pool);
			//整流器9欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器9欠压告警",2,pool);
			//整流器10欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器10欠压告警",2,pool);
			//整流器11欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器11欠压告警",2,pool);
			//整流器12欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器12欠压告警",2,pool);
			//整流器13欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器13欠压告警",2,pool);
			//整流器14欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器14欠压告警",2,pool);
			//整流器15欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器15欠压告警",2,pool);
			//整流器16欠压告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_UnderVol_ID,SqlsUtils.Alarm_Level_Second,198,false, 135,true,"整流器16欠压告警",2,pool);

			//整流器1过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器1过流告警",1,pool);
			//整流器2过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器2过流告警",1,pool);
			//整流器3过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器3过流告警",1,pool);
			//整流器4过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器4过流告警",1,pool);
			//整流器5过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器5过流告警",1,pool);
			//整流器6过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器6过流告警",1,pool);
			//整流器7过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器7过流告警",1,pool);
			//整流器8过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器8过流告警",1,pool);
			//整流器9过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器9过流告警",1,pool);
			//整流器10过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器10过流告警",1,pool);
			//整流器11过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器11过流告警",1,pool);
			//整流器12过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器12过流告警",1,pool);
			//整流器13过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器13过流告警",1,pool);
			//整流器14过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器14过流告警",1,pool);
			//整流器15过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器15过流告警",1,pool);
			//整流器16过流告警
			checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 99,false,"整流器16过流告警",1,pool);


			//System.out.println(PowerDeviceId +" == " + buf_body );
			}
			if(buf_body.length() > 0) {
			sql.sqlMysqlExecute((buf_base.append(buf_body)).toString());
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			if(null != res) {
			try {
			res.close();
			} catch (SQLException e) {
			e.printStackTrace();
			}
			}
			sql.close_con();
			}
			}

			/**
			*
			* @param buf_body sql_str
			* @param PowerDeviceId 电源id
			* @param alm_id 告警id
			* @param alm_level 告警等级
			* @param alarm_limitH 上限阈值
			* @param alarm_limitH_EN 上限阈值使能
			* @param alarm_limitL 下限阈值
			* @param alarm_limitL_EN 下限阈值使能
			* @param alarm_name 告警描述
			* @param alarm_type 告警有效 0-上下限有效 1-上限有效 2-下限有效
			*/
			public static void checkPowerAlarmParam(StringBuffer buf_body,int PowerDeviceId,int alm_id,int alm_level,float alarm_limitH,boolean alarm_limitH_EN, float alarm_limitL, boolean alarm_limitL_EN,String alarm_name,int alarm_type,MysqlConnPool pool) {
			String sql_str_sel = "SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
			Sql_Mysql sql = new Sql_Mysql(pool.getConn());
			ResultSet res = null;
			res = sql.sqlMysqlQuery(sql_str_sel);
			//System.out.println(sql_str_sel);
			try {
			if(!res.next()) {
			if(buf_body.length() > 0) {
			buf_body.append(",");
			}
			buf_body.append("("+PowerDeviceId+","+alm_id+","+alm_level+","+alarm_limitH+","+alarm_limitH_EN+","+alarm_limitL+","+alarm_limitL_EN+",'"+alarm_name+"',"+alarm_type+")");
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			if(null != res) {
			try {
			res.close();
			} catch (SQLException e) {
			e.printStackTrace();
			}
			}
			sql.close_con();
			}
			}


			public static void main(String[] args) {
			MysqlConnPool pool = new MysqlConnPool("192.168.10.79", 3360, 5);
			createPwrdev_Alarm_Param_ForSX_Table(pool, false);
			}
			}

			@@ -90,6 +90,95 @@
			sqlstb_page_param.add(strs[i]);
			}
			}



			/**
			* 山西电源部分电源告警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_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_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_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 Alarm_Type_TotalEff = 0; //上下限有效
			public final static int Alarm_Type_TotalHigh = 1; //上限有效
			public final static int Alarm_Type_TotalLow = 2; //下限有效


			public final static int Alarm_Level_First = 1; //1级告警
			public final static int Alarm_Level_Second = 2; //2级告警
			public final static int Alarm_Level_Third = 3; //3级告警
			public final static int Alarm_Level_Fourth = 4; //4级告警









			// public static void main(String[] args) {
			// System.out.println("SqlsUtils.sqlstb_page_param2 = " + SqlsUtils.sqlstb_page_param2);

			@@ -312,6 +312,8 @@
			public final static String Pwrdev_Time_Adj_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_time_adj_alarm`";
			public final static String Pwrdev_Time_Out_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_time_out_alarm`";

			public final static String Pwrdev_Alarm_Param_ForSX_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_param_forsx`"; //山西电源告警参数表



			/*************************** db_pwrdev_data_rt 数据库 **********************************/

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