V1.75 edit at date 2023-05-19 1.db_user.tb_user_log 新增字段用于FBC300平台中英文日志描述 ...

Administrator

2023-05-25 8909d101cb232169d7c327654e16af4182c0dca4

V1.75 edit at date 2023-05-19
	1.db_user.tb_user_log 新增字段用于FBC300平台中英文日志描述
		`uOprateMsgEnUs` text,
  		`operation_detail_enUs` text,

 BattMonitor_DB_Builder/bin/com/database_util/DB_App_Sys.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/DB_Param.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/DB_db_user.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/SqlsUtils.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,6 +1,10 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    
V1.75 edit at date 2023-05-25
    1.db_user.tb_user_log 新增字段用于FBC300平台中英文日志描述
        `uOprateMsgEnUs` text,
          `operation_detail_enUs` text,

V1.74 edit at date 2023-05-19
    1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增电源告警使能

 BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java

@@ -199,11 +199,11 @@

                }else{
                    //不存在添加
                    sql.sqlMysqlExecute("INSERT INTO `db_app_sys`.`tb_page_param2` (`id`, `param`, `label`, `value`, `categoryId`) "
                            + "VALUES ('1', 'visit_time_first', '用户登录访问控制-访问时间最早', '00:00:01', '1'),"
                            + "('2', 'visit_time_last', '用户登录访问控制-访问时间最晚', '23:59:59', '1'),"
                            + "('3', 'visit_ip', '用户登录访问控制-访问客户端ip-允许', '*', '1'),"
                            + "('4', 'audit_cap', '审计数据记录容量', '5000', '2');");
                    sql.sqlMysqlExecute("INSERT INTO `db_app_sys`.`tb_page_param2` (`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) "
                            + "VALUES ('1', 'visit_time_first', '用户登录访问控制-访问时间最早', '00:00:01', '1','User Login Access Control-Access Earliest'),"
                            + "('2', 'visit_time_last', '用户登录访问控制-访问时间最晚', '23:59:59', '1','User Login Access Control-Access Latest'),"
                            + "('3', 'visit_ip', '用户登录访问控制-访问客户端ip-允许', '*', '1','User Login Access Control-Access Client IP-Allow'),"
                            + "('4', 'audit_cap', '审计数据记录容量', '5000', '2','');");
                }
                
            }
@@ -471,50 +471,54 @@
//                    System.out.println("db_app_sys.tb_page_param ids:"+ids);

                }else{
                    sql.sqlMysqlExecute("INSERT INTO `db_app_sys`.`tb_page_param` (`id`, `param`, `status`, `categoryId`,paramEnUs)"+
                            "VALUES ('1', '设备工作状态', '0', '1','Device Status')," +
                            "('2', '设备通讯', '1', '1','Device Communication')," +
                            "('3', '设备温度', '1', '1','Temperature(°C)')," +
                            "('4', '干接点', '1', '1','Dry Contact')," +
                            "('5', '核容终止原因', '1', '1','Reason for capacity check  termination')," +
                            "('6', '操作失败原因', '1', '1','Operate Failure Reason')," +
                            "('7', '剩余天数', '1', '1','Remaining Day(s)')," +
                            "('8', '工作模式', '1', '1','Working Mode')," +
                            "('9', '组端电压', '1', '1','String Voltage')," +
                            "('10', '峰值电压', '1', '1','Peak Voltage')," +
                            "('11', '启动核容测试', '1', '2','Initiate capacity check testing')," +
                            "('12', '停止测试', '1', '2','Stop testing')," +
                            "('13', '系统参数设置', '0', '2','System Parms Setting')," +
                            "('14', '清除告警', '1', '2','Clear Alarm')," +
                            "('15', '启动养护/除硫', '1', '2','Start Maintenance/Desulfation')," +
                            "('16', '停止养护/除硫', '1', '2','Stop Maintenance/Desulfation')," +
                            "('17', '启动离线养护', '1', '2','Start Offline Maintenance')," +
                            "('18', '停止离线养护', '1', '2','Stop Offline Maintenance')," +
                            "('19', '定期启动设备', '1', '2','Periodically Ratart')," +
                            "('20', '重启设备', '1', '2','Restart')," +
                            "('31', '蓄电池远程运维管理系统', '1', '5','Intelligent System for Battery Uninterruptible Power Supply')," +
                            "('32', 'V1.0.5', '1', '6','V1.0.5')," +
                            "('33', '平台logo', '1', '7','Platform logo')," +
                            "('34', 'uKey', '1', '7','uKey')," +
                            "('35', '人脸识别', '1', '7','Face recognition')," +
                            "('36', '签名', '1', '7','signature')," +
                            "('37', '远程修改ip', '1', '7','Remote modification of IP')," +
                            "('38', '启动放电添加人脸识别', '1', '7','Start discharging and add facial recognition')," +
                            "('39', '账号扫描策略', '1', '8','Account scanning strategy')," +
                            "('40', '账号登录失败限制次数', '7', '9','Account login failure limit number of times')," +
                            "('41', '账号登录失败锁定解锁策略', '1', '9','Account login failure lock unlock strategy')," +
                    StringBuffer sql_str_bf = new StringBuffer("INSERT INTO " + Sql_Mysql.Page_Param_Table + " (`id`, `param`, `status`, `categoryId`,`paramEnUs`) VALUES");
					
                    sql_str_bf.append("('1', '设备工作状态', '0', '1','Device Status'),");
                    sql_str_bf.append("('2', '设备通讯', '1', '1','Device Communication'),");
                    sql_str_bf.append("('3', '设备温度', '1', '1','Temperature(°C)'),");
                    sql_str_bf.append("('4', '干接点', '1', '1','Dry Contact'),");
                    sql_str_bf.append("('5', '核容终止原因', '1', '1','Reason for capacity check  termination'),");
                    sql_str_bf.append("('6', '操作失败原因', '1', '1','Operate Failure Reason'),");
                    sql_str_bf.append("('7', '剩余天数', '1', '1','Remaining Day(s)'),");
                    sql_str_bf.append("('8', '工作模式', '1', '1','Working Mode'),");
                    sql_str_bf.append("('9', '组端电压', '1', '1','String Voltage'),");
                    sql_str_bf.append("('10', '峰值电压', '1', '1','Peak Voltage'),");
                    sql_str_bf.append("('11', '启动核容测试', '1', '2','Initiate capacity check testing'),");
                    sql_str_bf.append("('12', '停止测试', '1', '2','Stop testing'),");
                    sql_str_bf.append("('13', '系统参数设置', '0', '2','System Parms Setting'),");
                    sql_str_bf.append("('14', '清除告警', '1', '2','Clear Alarm'),");
                    sql_str_bf.append("('15', '启动养护/除硫', '1', '2','Start Maintenance/Desulfation'),");
                    sql_str_bf.append("('16', '停止养护/除硫', '1', '2','Stop Maintenance/Desulfation'),");
                    sql_str_bf.append("('17', '启动离线养护', '1', '2','Start Offline Maintenance'),");
                    sql_str_bf.append("('18', '停止离线养护', '1', '2','Stop Offline Maintenance'),");
                    sql_str_bf.append("('19', '定期启动设备', '1', '2','Periodically Ratart'),");
                    sql_str_bf.append("('20', '重启设备', '1', '2','Restart'),");
                    sql_str_bf.append("('31', '蓄电池远程运维管理系统', '1', '5','Intelligent System for Battery Uninterruptible Power Supply'),");
                    sql_str_bf.append("('32', 'V1.0.5', '1', '6','V1.0.5'),");
                    sql_str_bf.append("('33', '平台logo', '1', '7','Platform logo'),");
                    sql_str_bf.append("('34', 'uKey', '1', '7','uKey'),");
                    sql_str_bf.append("('35', '人脸识别', '1', '7','Face recognition'),");
                    sql_str_bf.append("('36', '签名', '1', '7','signature'),");
                    sql_str_bf.append("('37', '远程修改ip', '1', '7','Remote modification of IP'),");
                    sql_str_bf.append("('38', '启动放电添加人脸识别', '1', '7','Start discharging and add facial recognition'),");
                    sql_str_bf.append("('39', '账号扫描策略', '1', '8','Account scanning strategy'),");
                    sql_str_bf.append("('40', '账号登录失败限制次数', '7', '9','Account login failure limit number of times'),");
                    sql_str_bf.append("('41', '账号登录失败锁定解锁策略', '1', '9','Account login failure lock unlock strategy'),");
                            
                            "('42', '密码设置规则-位数', '8', '10','Password setting rules - number of digits')," +
                            "('43', '密码设置规则-符号类型', '4', '10','Password Setting Rules - Symbol Types')," +
                            "('44', '历史数据的驼峰锅底功能开启', '1', '11','Enabling the Hump Pot Bottom Function of Historical Data')," +
                            "('45', '历史数据的数据显示粒度', '5', '11','Data display granularity of historical data')" +
                    sql_str_bf.append("('42', '密码设置规则-位数', '8', '10','Password setting rules - number of digits'),");
                    sql_str_bf.append("('43', '密码设置规则-符号类型', '4', '10','Password Setting Rules - Symbol Types'),");
                    sql_str_bf.append("('44', '历史数据的驼峰锅底功能开启', '1', '11','Enabling the Hump Pot Bottom Function of Historical Data'),");
                    sql_str_bf.append("('45', '历史数据的数据显示粒度', '5', '11','Data display granularity of historical data'),");
                           
                            "('47', '放电时长, '10', '12','')" +
                            "('48', '左边规定放电时长', '10', '12','')" +
                            "('49', '左边规定时间次数', '10', '12','')" +
                            "('50', '右边规定时间时长', '1', '12','')" +
                            "('51', '右边规定时间次数', '1', '12','')" +
                            ";");
                    sql_str_bf.append("('47', '放电时长', '10', '12',''),");
                    sql_str_bf.append("('48', '左边规定放电时长', '10', '12',''),");
                    sql_str_bf.append("('49', '左边规定时间次数', '10', '12',''),");
                    sql_str_bf.append("('50', '右边规定时间时长', '1', '12',''),");
                    sql_str_bf.append("('51', '右边规定时间次数', '1', '12','')");
					
                    //System.out.println(sql_str_bf.toString());
                    sql.sqlMysqlExecute(sql_str_bf.toString());
				    
                }
            }
        } catch (SQLException e) {

 BattMonitor_DB_Builder/src/com/database_util/DB_Param.java

@@ -1,5 +1,6 @@
package com.database_util;



import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Date;



@@ -126,10 +127,91 @@
                sql.sqlMysqlExecute(sql_str01);

            }

            sql.sqlMysqlExecute(sql_str02);        

			
            //在线电压告警

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_OnlineVol_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_OnlineVol_ID+",'Batt_Alarm_Type_OnlineVol',1.2,0.8,2,2,1,0)");

            }

			
            //组端电压告警

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_GroupVol_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_GroupVol_ID+",'Batt_Alarm_Type_GroupVol',1.2,0.8,2,2,1,1)");

            }

            //充电电流高

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BattChargeCurr_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_BattChargeCurr_ID+",'Batt_Alarm_Type_BattChargeCurr',3,0,3,3,1,0)");

            }

            //放电电流告警

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BattDisChargeCurr_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_BattDisChargeCurr_ID+",'Batt_Alarm_Type_BattDisChargeCurr',3,0,3,3,1,0)");

            }

            //单体电压告警

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MonVol_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MonVol_ID+",'Batt_Alarm_Type_MonVol',1.2,0.8,2,2,1,1)");

            }

            //单体温度告警

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MonTmp_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MonTmp_ID+",'Batt_Alarm_Type_MonTmp',1.5,0.5,2,2,1,1)");

            }

            //单体内阻告警

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MonRes_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MonRes_ID+",'Batt_Alarm_Type_MonRes',2,0.5,2,2,1,1)");

            }

            //连接条阻抗告警

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_ConnRes_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_ConnRes_ID+",'Batt_Alarm_Type_ConnRes',2,0.5,2,3,0,0)");

            }

            //放电单体电压告警	
            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_DisChargeMonVol_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_DisChargeMonVol_ID+",'Batt_Alarm_Type_DisChargeMonVol',1.2,0.8,2,2,0,0)");

            }

            //容量告警告警	
            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MONCAP_ALMALARM_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MONCAP_ALMALARM_ID+",'Batt_Alarm_Type_CapAlarm',3,0.8,3,2,0,1)");

            }

            //容量更换告警

            if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MONCAP_CHANGEALARM_ID)) {

                sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MONCAP_CHANGEALARM_ID+",'Batt_Alarm_Type_CapChange',2,0.6,2,2,0,1)");

            }

			
			
        } catch (SQLException e) {

            e.printStackTrace();

        } finally {

            sql.close_con();

        }

    }

	
    /**

     *     检查db_param.tb_alarm_param 表中alm记录是否存在

     * @param pool

     * @param alm_id

     * @return

     */

    public static boolean checkAlarmParamExists(MysqlConnPool pool,int alm_id) {

        boolean isExists = false;

        String sql_str = "SELECT * FROM " + Sql_Mysql.Alarm_Param_Table + " WHERE alm_id = " + alm_id;

        Sql_Mysql sql = new Sql_Mysql(pool.getConn());

        ResultSet res = null;

		
        try {

            res = sql.sqlMysqlQuery(sql_str);

            if(res.next()) {

                isExists = true;

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {

            if(null != res) {

                try {

                    res.close();

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

            sql.close_con();

        }

        return isExists;

    }

	
}


 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java

@@ -337,7 +337,7 @@
                    + " AND table_name='tb_pwrdev_alarm_param_forsx'"
                    + " AND column_name='alarm_en_node'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table 
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table 
                        + " ADD COLUMN `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]';");
            }
            

 BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java

@@ -1595,6 +1595,10 @@
                "  `uOprateDay` datetime NOT NULL DEFAULT '1980-01-01 00:00:00'," + 
                "  `uTerminalIp` varchar(20) NOT NULL DEFAULT ' '," + 
                "  `uOprateMsg` varchar(250) NOT NULL DEFAULT ' '," + 
                "  `operation_detail` text COMMENT '操作的具体数据'," + 
                "  `read_flag` tinyint(1) DEFAULT '1' COMMENT '是否已阅读,此功能针对异常信息'," + 
                "  `uOprateMsgEnUs` text," + 
                "  `operation_detail_enUs` text," + 
                "  PRIMARY KEY (`num`)," + 
                "  KEY `user_id` (`uId`)" + 
                ") ENGINE=InnoDB AUTO_INCREMENT=7293 DEFAULT CHARSET=utf8;";
@@ -1641,6 +1645,26 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table 
                                + " ADD COLUMN `read_flag` tinyint(1) DEFAULT '1' COMMENT '是否已阅读,此功能针对异常信息'");
            }
            res = null;
            //添加uOprateMsgEnUs
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_log'"
                    + " AND column_name='uOprateMsgEnUs'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table 
                        + " ADD COLUMN `uOprateMsgEnUs` text");
            }
            res = null;
            //添加operation_detail_enUs
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_log'"
                    + " AND column_name='operation_detail_enUs'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table 
                        + " ADD COLUMN `operation_detail_enUs` text");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {

 BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java

@@ -48,11 +48,10 @@
        idsDefault2 = Arrays.asList(temp2);
        
        sqlstb_page_param2 = new ArrayList<>();
        String tb_page_param2 = "INSERT INTO `db_app_sys`.`tb_page_param2` VALUES ('1', 'visit_time_first', '用户登录访问控制-访问时间最早', '00:00:01', '1');" +
                "INSERT INTO `db_app_sys`.`tb_page_param2` VALUES ('2', 'visit_time_last', '用户登录访问控制-访问时间最晚', '23:59:59', '1');" +
                "INSERT INTO `db_app_sys`.`tb_page_param2` VALUES ('3', 'visit_ip', '用户登录访问控制-访问客户端ip-允许', '*', '1');"+
                "INSERT INTO `db_app_sys`.`tb_page_param2` (`id`, `param`, `label`, `value`, `categoryId`) "+
                "VALUES ('4', 'audit_cap', '审计数据记录容量', '5000', '2');";
        String tb_page_param2 = "INSERT INTO `db_app_sys`.`tb_page_param2`(`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) VALUES ('1', 'visit_time_first', '用户登录访问控制-访问时间最早', '00:00:01', '1','User Login Access Control-Access Earliest');" +
                                "INSERT INTO `db_app_sys`.`tb_page_param2`(`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) VALUES ('2', 'visit_time_last', '用户登录访问控制-访问时间最晚', '23:59:59', '1','User Login Access Control-Access Latest');" +
                                "INSERT INTO `db_app_sys`.`tb_page_param2`(`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) VALUES ('3', 'visit_ip', '用户登录访问控制-访问客户端ip-允许', '*', '1','User Login Access Control-Access Client IP-Allow');"+
                                "INSERT INTO `db_app_sys`.`tb_page_param2`(`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) VALUES ('4', 'audit_cap', '审计数据记录容量', '5000', '2','');";
        String[] strs2 = tb_page_param2.split(";");
        for (int i = 0; i < strs2.length; i++) {
            sqlstb_page_param2.add(strs2[i]);
@@ -347,7 +346,20 @@
    
    
    
    
    public final static int ALM_TYPE_OnlineVol_ID                 = 119001;            //在线电压告警
    public final static int ALM_TYPE_GroupVol_ID                 = 119002;            //组端电压告警
    public final static int ALM_TYPE_BattChargeCurr_ID             = 119003;            //充电电流高
    public final static int ALM_TYPE_BattDisChargeCurr_ID         = 119004;            //放电电流告警
    public final static int ALM_TYPE_MonVol_ID                     = 119005;            //单体电压告警
    public final static int ALM_TYPE_MonTmp_ID                     = 119006;            //单体温度告警
    public final static int ALM_TYPE_MonRes_ID                     = 119007;            //单体内阻告警
    public final static int ALM_TYPE_ConnRes_ID                 = 119008;            //连接条阻抗告警
    public final static int ALM_TYPE_DisChargeMonVol_ID         = 119009;            //放电单体电压告警	
    public final static int ALM_TYPE_MONCAP_ALMALARM_ID         = 119010;            //容量告警告警
    public final static int ALM_TYPE_MONCAP_CHANGEALARM_ID         = 119011;            //容量更换告警	
    public final static int ALM_TYPE_MONLYVOL_ID                 = 119012;            //漏液电压告警	
    public final static int ALM_TYPE_MONREALCAP_ID                 = 119013;            //单体预估容量告警

    
    
    

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,6 +1,10 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    
V1.75 edit at date 2023-05-25
    1.db_user.tb_user_log 新增字段用于FBC300平台中英文日志描述
        `uOprateMsgEnUs` text,
          `operation_detail_enUs` text,

V1.74 edit at date 2023-05-19
    1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增电源告警使能