BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
BattMonitor_DB_Builder/src/com/database_util/DB_Dev_TestParam.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -654,4 +654,12 @@ `a059_switchVolMin` float NOT NULL DEFAULT '0' COMMENT '回切组端电压范围低', `a059_switchVolMax` float NOT NULL DEFAULT '0' COMMENT '回切组端电压范围高', V1.40 edit at date 2022-08-23 1.表'db_ram_db.tb_fbs9100_sysparam'表新增字段并联电源系统参数 `floatChargeVolt` float NOT NULL DEFAULT '0' COMMENT '浮充电压[并联电源]', `disChargeVolt` float NOT NULL DEFAULT '0' COMMENT '后备放电电压[并联电源]', `dischargeVoltLimit` float NOT NULL DEFAULT '0' COMMENT '放电电压下限[并联电源]', `monomerLowVolt` float NOT NULL DEFAULT '0' COMMENT '单体下限[并联电源]', `monomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体下限个数[并联电源]', `autoEQChargeStartimeTime` int(11) NOT NULL DEFAULT '0' COMMENT '自动启动均充周期(天)[并联电源]', `autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT '均充时长[并联电源]', BattMonitor_DB_Builder/src/com/database_util/DB_Dev_TestParam.java
@@ -51,6 +51,7 @@ res = sql.sqlMysqlQuery(sql_str_sel); while(res.next()) { int battgroupid = res.getInt("BattGroupId"); sql.sqlMysqlUseDB(Sql_Mysql.DB_DEV_TESTPARAM); if(!sql.sqlMysqlCheckIfTableExist(Sql_Mysql.Batt_TestParam_Table + battgroupid)) { sql.sqlMysqlExecute(" CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Batt_TestParam_Table + battgroupid + " (" + " `num` bigint(20) NOT NULL AUTO_INCREMENT," + BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -1801,6 +1801,82 @@ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table + " ADD COLUMN `StandyVolt` float NOT NULL DEFAULT '0' COMMENT '后备电压(V)';"); } /* * * 2022-08-23 并联电源新增参数设置 * ***********************************************************/ //添加字段floatChargeVolt 浮充电压[并联电源] res = null; res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_sysparam'" + " AND column_name='floatChargeVolt'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table + " ADD COLUMN `floatChargeVolt` float NOT NULL DEFAULT '0' COMMENT '浮充电压[并联电源]';"); } //添加字段disChargeVolt 后备放电电压[并联电源] res = null; res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_sysparam'" + " AND column_name='disChargeVolt'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table + " ADD COLUMN `disChargeVolt` float NOT NULL DEFAULT '0' COMMENT '后备放电电压[并联电源]';"); } //添加字段dischargeVoltLimit 放电电压下限[并联电源] res = null; res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_sysparam'" + " AND column_name='dischargeVoltLimit'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table + " ADD COLUMN `dischargeVoltLimit` float NOT NULL DEFAULT '0' COMMENT '放电电压下限[并联电源]';"); } //添加字段monomerLowVolt 单体下限[并联电源] res = null; res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_sysparam'" + " AND column_name='monomerLowVolt'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table + " ADD COLUMN `monomerLowVolt` float NOT NULL DEFAULT '0' COMMENT '单体下限[并联电源]';"); } //添加字段monomerLowCount 单体下限个数[并联电源] res = null; res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_sysparam'" + " AND column_name='monomerLowCount'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table + " ADD COLUMN `monomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体下限个数[并联电源]';"); } //添加字段autoEQChargeStartimeTime 自动启动均充周期(天)[并联电源] res = null; res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_sysparam'" + " AND column_name='autoEQChargeStartimeTime'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table + " ADD COLUMN `autoEQChargeStartimeTime` int(11) NOT NULL DEFAULT '0' COMMENT '自动启动均充周期(天)[并联电源]';"); } //添加字段autoEQChargetTime 均充时长[并联电源] res = null; res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_sysparam'" + " AND column_name='autoEQChargetTime'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table + " ADD COLUMN `autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT '均充时长[并联电源]';"); } } catch (SQLException e) { e.printStackTrace(); } finally { BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -654,4 +654,12 @@ `a059_switchVolMin` float NOT NULL DEFAULT '0' COMMENT '回切组端电压范围低', `a059_switchVolMax` float NOT NULL DEFAULT '0' COMMENT '回切组端电压范围高', V1.40 edit at date 2022-08-23 1.表'db_ram_db.tb_fbs9100_sysparam'表新增字段并联电源系统参数 `floatChargeVolt` float NOT NULL DEFAULT '0' COMMENT '浮充电压[并联电源]', `disChargeVolt` float NOT NULL DEFAULT '0' COMMENT '后备放电电压[并联电源]', `dischargeVoltLimit` float NOT NULL DEFAULT '0' COMMENT '放电电压下限[并联电源]', `monomerLowVolt` float NOT NULL DEFAULT '0' COMMENT '单体下限[并联电源]', `monomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体下限个数[并联电源]', `autoEQChargeStartimeTime` int(11) NOT NULL DEFAULT '0' COMMENT '自动启动均充周期(天)[并联电源]', `autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT '均充时长[并联电源]', 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.39; public final static float m_VersionNum = (float) 1.40; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/