V1.45 edit at date 2022-11-04 1.新增电操开关表'db_ram_db.tb_fbs9100_setparam'表新增字...

Administrator

2022-11-04 be007235b7dc947bc42d1c132945c0a0c79488e7

V1.45 edit at date 2022-11-04
	1.新增电操开关表'db_ram_db.tb_fbs9100_setparam'表新增字段
		`MonCapStd` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量' -----
电操开关新增参数标称容量

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -693,3 +693,8 @@
    1.新增电操开关表'db_ram_db.tb_dev_60870_inverter_info'和'db_ram_db.tb_dev_60870_inverter_state'  
    1.新增三方接口配置表'web_site.tb_interface'
    
V1.45 edit at date 2022-11-04
    1.新增电操开关表'db_ram_db.tb_fbs9100_setparam'表新增字段
        `MonCapStd` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量' ----- 电操开关新增参数标称容量

	

 BattMonitor_DB_Builder/config.xml

@@ -2,7 +2,7 @@

<root>
  <mysql_ramdb_recreate_en>false</mysql_ramdb_recreate_en>
  <mysql_server_ip>192.168.10.79</mysql_server_ip>
  <mysql_server_ip>127.0.0.1</mysql_server_ip>
  <!--SOURCE_BATTDATA_TYPE_FBSDEV = 0-->
  <!--SOURCE_BATTDATA_TYPE_SQLSERVER = 1-->
  <!--SOURCE_BATTDATA_TYPE_C_INTERFACE = 2-->

 BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java

@@ -903,6 +903,15 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 

                        + " ADD COLUMN `HV_mon_uppernum3` int(11) NOT NULL DEFAULT '0' COMMENT '恒压阶段3上限个数'");

            }

            //2022-11-04添加指定的MonCapStd列(标称容量)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='MonCapStd'");

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

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                        + " ADD COLUMN `MonCapStd` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量';");

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {


 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -693,3 +693,8 @@
    1.新增电操开关表'db_ram_db.tb_dev_60870_inverter_info'和'db_ram_db.tb_dev_60870_inverter_state'  
    1.新增三方接口配置表'web_site.tb_interface'
    
V1.45 edit at date 2022-11-04
    1.新增电操开关表'db_ram_db.tb_fbs9100_setparam'表新增字段
        `MonCapStd` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量' ----- 电操开关新增参数标称容量