修改软件版本并且记录当前修改的记录

whyclj

2019-09-24 2622d9aacbb178ea07edcbd4f31cc14d630814d3

修改软件版本并且记录当前修改的记录

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

@@ -352,6 +352,26 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 

                                + " ADD COLUMN `AutoTestStartVol`  float NOT NULL DEFAULT 0;");

            }

			
            //添加指定的 OnLineVol_Low 列(在线电压低阀值)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='OnLineVol_Low'");

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

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `OnLineVol_Low`  float NOT NULL DEFAULT 0;");

            }

			
            //添加指定的 OffLineYH_Cycle 列(离线养护周期)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='OffLineYH_Cycle'");

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

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `OffLineYH_Cycle`  int NOT NULL DEFAULT 0;");

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {


 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -649,8 +649,177 @@
                                            + " ADD COLUMN `charge_curr_max` float DEFAULT '20'");

                        }

                //---------------------------------------------------------------------------------------------//

                        //为紫晶平台添加指定的列

                        boolean isZijing = true;

                        if(isZijing) {

                            //添加电压等级列

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='Vol_grade'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `Vol_grade` float DEFAULT '0'");

                            }

							
                            //生产厂家

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='Manufacturers'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `Manufacturers` varchar(64) DEFAULT ''");

                            }

							
                            //是否资产级设备

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='Assetequipment'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `Assetequipment` varchar(64) DEFAULT ''");

                            }

							
							
							
                            //设备分类全路径

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='Deviceclasspath'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `Deviceclasspath` varchar(64) DEFAULT ''");

                            }

							
                            //设备运维部门

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='Deviceoperationdepartment'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `DeviceOperationDepartment` varchar(64) DEFAULT ''");

                            }

							
                            //产权单位

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='PropertyRightUnit'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `PropertyRightUnit` varchar(64) DEFAULT ''");

                            }

							
                            //产权属性

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='PropertyAttribute'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `PropertyAttribute` varchar(64) DEFAULT ''");

                            }

							
                            //出厂编号

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='FactoryNumber'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `FactoryNumber` varchar(64) DEFAULT ''");

                            }

							
                            //运维班组

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='OperationTeam'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `OperationTeam` varchar(64) DEFAULT ''");

                            }

							
                            //设备身份编码

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='DeviceIdentityCode'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `DeviceIdentityCode` varchar(64) DEFAULT ''");

                            }

							
							
                            //项目类型

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='ProjectType'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `ProjectType` varchar(64) DEFAULT ''");

                            }

							
                            //蓄电池应用类型

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='BatteryApplicationType'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `BatteryApplicationType` varchar(64) DEFAULT ''");

                            }

							
                            //单电池额定电压

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

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='SingleRatedVoltage'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `SingleRatedVoltage` float DEFAULT '0'");

                            }

							
                            //是否实现远程监控  
                            res = sqlMysqlQuery("SELECT * FROM information_schema.columns"

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='RemoteMonitor'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `RemoteMonitor` varchar(64) DEFAULT ''");

                            }

							
                            //是否独立蓄电池室放置  
                            res = sqlMysqlQuery("SELECT * FROM information_schema.columns"

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='BatttIndependentPlaced'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `BatttIndependentPlaced` varchar(64) DEFAULT ''");

                            }

							
                            //均充电压设定值 
                            res = sqlMysqlQuery("SELECT * FROM information_schema.columns"

                                    + " WHERE table_schema='db_battinf'"

                                    + " AND table_name='tb_battinf'"

                                    + " AND column_name='JunChargeVoltageValue'");

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

                                sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                                + " ADD COLUMN `JunChargeVoltageValue` float DEFAULT '0'");

                            }

							
                        }

                        

                        

		
						
        //---------------------------------------------------------------------------------------------//

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

                                + " WHERE table_schema='db_battinf'"


 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -108,3 +108,7 @@
    

V1.42 edit at date 2019-08-30

    1.在’db_ram_db‘数据库中创建‘tb_61850_jhstate’表，用于存储61850均衡供电参数信息

	
V1.43 edit at date 2019-09-24

    1.在'db_ram_db'数据库中的表'tb_fbs9100_setparam'表中添加61850中的在线压低和离线续航周期值

    2.在'db_battinf'数据库中的表'tb_battinf'中添加紫晶那边的电池组信息列

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -16,7 +16,7 @@
    /**************************************************************************/

    /**************************************************************************/

    public final static boolean app_debug = false;

    public final static float m_VersionNum = (float) 1.042;

    public final static float m_VersionNum = (float) 1.043;

    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";

    /**************************************************************************/

    /**************************************************************************/