V1.83 edit at date 2023-07-26 1.'db_pwrdev_inf.tb_pwrdev_inf'新增字段用于判断电源告警中...

Administrator

2023-07-26 f6972028e81d2fb6a9c15f1259813b8f19d2b45d

V1.83 edit at date 2023-07-26
	1.'db_pwrdev_inf.tb_pwrdev_inf'新增字段用于判断电源告警中的交流停电告警
		  `acvol_high_limit` float NOT NULL DEFAULT '200' COMMENT '交流上限阈值',
		  `acvol_low_limit` float NOT NULL DEFAULT '200' COMMENT '交流下限阈值',
		  `dcoutvol_low_limit` float NOT NULL DEFAULT '43.2' COMMENT
'直流输出电压下限阈值',

 BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Inf.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,6 +1,14 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    
	
V1.83 edit at date 2023-07-26
    1.'db_pwrdev_inf.tb_pwrdev_inf'新增字段用于判断电源告警中的交流停电告警
          `acvol_high_limit` float NOT NULL DEFAULT '200' COMMENT '交流上限阈值',
          `acvol_low_limit` float NOT NULL DEFAULT '200' COMMENT '交流下限阈值',
          `dcoutvol_low_limit` float NOT NULL DEFAULT '43.2' COMMENT '直流输出电压下限阈值',
		
	
V1.82 edit at date 2023-07-24
    1.'db_param.tb_dev_param'表新增 上上限告警等级和下下限告警等级
          `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级',

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java

@@ -81,6 +81,9 @@
                "  `route_num` tinyint(4) DEFAULT '1' COMMENT '交流ABC几路设置'," + 

                "  `exception_cause` varchar(45) DEFAULT NULL COMMENT '异常原因'," + 

                "  `exception_cause_analysis` varchar(255) DEFAULT NULL COMMENT '异常原因分析'," + 

                "  `acvol_high_limit` float NOT NULL DEFAULT '200' COMMENT '交流上限阈值'," + 
                "  `acvol_low_limit` float NOT NULL DEFAULT '200' COMMENT '交流下限阈值'," + 
                "  `dcoutvol_low_limit` float NOT NULL DEFAULT '43.2' COMMENT '直流输出电压下限阈值'," + 
                "  PRIMARY KEY (`num`)," + 

                "  KEY `index_station_id` (`StationId`)," + 

                "  KEY `index_powerdev_id` (`PowerDeviceId`)," + 

@@ -143,6 +146,36 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table 

                        + " ADD COLUMN `exception_cause_analysis` varchar(255) DEFAULT NULL COMMENT '异常原因分析';");

            }

            res = null;

            //添加字段acvol_high_limit ----- 交流上限阈值

            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

                    + " WHERE table_schema='db_pwrdev_inf'"

                    + " AND table_name='tb_pwrdev_inf'"

                    + " AND column_name='acvol_high_limit'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table 
                        + " ADD COLUMN `acvol_high_limit` float NOT NULL DEFAULT '200' COMMENT '交流上限阈值';");

            }

            res = null;

            //添加字段acvol_low_limit ----- 交流下限阈值

            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

                    + " WHERE table_schema='db_pwrdev_inf'"

                    + " AND table_name='tb_pwrdev_inf'"

                    + " AND column_name='acvol_low_limit'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table 
                        + " ADD COLUMN `acvol_low_limit` float NOT NULL DEFAULT '200' COMMENT '交流下限阈值';");

            }

            res = null;

            //添加字段dcoutvol_low_limit ----- 直流输出电压下限阈值

            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

                    + " WHERE table_schema='db_pwrdev_inf'"

                    + " AND table_name='tb_pwrdev_inf'"

                    + " AND column_name='dcoutvol_low_limit'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table 
                        + " ADD COLUMN `dcoutvol_low_limit` float NOT NULL DEFAULT '43.2' COMMENT '直流输出电压下限阈值';");

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {


 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,6 +1,14 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    
	
V1.83 edit at date 2023-07-26
    1.'db_pwrdev_inf.tb_pwrdev_inf'新增字段用于判断电源告警中的交流停电告警
          `acvol_high_limit` float NOT NULL DEFAULT '200' COMMENT '交流上限阈值',
          `acvol_low_limit` float NOT NULL DEFAULT '200' COMMENT '交流下限阈值',
          `dcoutvol_low_limit` float NOT NULL DEFAULT '43.2' COMMENT '直流输出电压下限阈值',
		
	
V1.82 edit at date 2023-07-24
    1.'db_param.tb_dev_param'表新增 上上限告警等级和下下限告警等级
          `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级',