From 2d672ca4a0332b682e6d6af7171c406bec03adef Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 23 八月 2022 14:40:04 +0800
Subject: [PATCH] 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_Ram_db.java | 76 ++++++++++++++++++++++++++++++++++++++
1 files changed, 76 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
index 203072d..8f7428f 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
+++ b/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 {
--
Gitblit v1.9.1