V1.84 edit at date 2023-07-27 1.删除默认的电源交流停电告警参数 2.默认插入国网电源2路的三相告警参数 3.将国...

Administrator

2023-07-31 c9da5f9a78e4bf2a3a634f41555a774dba5324e2

V1.84 edit at date 2023-07-27
	1.删除默认的电源交流停电告警参数
	2.默认插入国网电源2路的三相告警参数
	3.将国网电源原交流三相电压告警参数前新增路数

 BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.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,11 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    
V1.84 edit at date 2023-07-27
    1.删除默认的电源交流停电告警参数
    2.默认插入国网电源2路的三相告警参数
    3.将国网电源原交流三相电压告警参数前新增路数

    
V1.83 edit at date 2023-07-26
    1.'db_pwrdev_inf.tb_pwrdev_inf'新增字段用于判断电源告警中的交流停电告警

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java

@@ -5,12 +5,13 @@
import java.util.Date;

import com.base.Com;
import com.mysql.jdbc.UpdatableResultSet;
import com.sql.MysqlConnPool;
import com.sql.Sql_Mysql;

public class DB_Pwrdev_Alarm {
    public static void init(MysqlConnPool pool, boolean recreate) {
        System.out.println(" db_pwrdev_alarm start end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
        System.out.println(" db_pwrdev_alarm start at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
        
        createDB_Pwrdev_Alarm (pool);
        
@@ -472,28 +473,32 @@
                
                
                
                //交流A相过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流A相过压告警",1,pool);
                //交流A相欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流A相欠压告警",2,pool);
                //交流A相缺相告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流A相缺相告警",2,pool);
                //交流B相过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流B相过压告警",1,pool);
                //交流B相欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流B相欠压告警",2,pool);
                //交流B相缺相告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流B相缺相告警",2,pool);
                //交流C相过压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"交流C相过压告警",1,pool);
                //交流C相欠压告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"交流C相欠压告警",2,pool);
                //交流C相缺相告警
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"交流C相缺相告警",2,pool);
                //交流A相过压告警    110001 
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"1路交流A相过压告警",1,pool);
                //交流A相欠压告警    110002
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"1路交流A相欠压告警",2,pool);
                //交流A相缺相告警    110003
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"1路交流A相缺相告警",2,pool);
                //交流B相过压告警    110004
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"1路交流B相过压告警",1,pool);
                //交流B相欠压告警    110005
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"1路交流B相欠压告警",2,pool);
                //交流B相缺相告警    110006
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"1路交流B相缺相告警",2,pool);
                //交流C相过压告警    110007
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"1路交流C相过压告警",1,pool);
                //交流C相欠压告警    110008
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"1路交流C相欠压告警",2,pool);
                //交流C相缺相告警    110009
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"1路交流C相缺相告警",2,pool);
                
				
                /**
                 * @2023-07-31 修改，交流停电告警暂无告警参数
                 */
                //交流停电告警        110010
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID,SqlsUtils.Alarm_Level_First,54,false, 49,true,"交流停电告警",2,pool);
                //checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID,SqlsUtils.Alarm_Level_First,54,false, 49,true,"交流停电告警",2,pool);
                deletePowerAlarmDefaultParam(SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID, pool);
				
                //防雷器故障告警    110011
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID,SqlsUtils.Alarm_Level_Second,54,false, 49,false,"防雷器故障告警",2,pool);
                //直流电压过高告警    110012
@@ -758,6 +763,24 @@
                //烟感3通信故障告警                110136
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke3_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"烟感3通信故障告警",1,pool);
                
                //2路交流A相过压        110137
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"2路交流A相过压告警",1,pool);
                //2路交流A相欠压        110138
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"2路交流A相欠压告警",2,pool);
                //2路交流A相缺相        110139
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"2路交流A相缺相告警",2,pool);
                //2路交流B相过压        110140
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"2路交流B相过压告警",1,pool);
                //2路交流B相欠压        110141
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"2路交流B相欠压告警",2,pool);
                //2路交流B相缺相        110142
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"2路交流B相缺相告警",2,pool);
                //2路交流C相过压        1101343
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"2路交流C相过压告警",1,pool);
                //2路交流C相欠压        110144
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"2路交流C相欠压告警",2,pool);
                //2路交流C相缺相        110145
                checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"2路交流C相缺相告警",2,pool);
                //System.out.println(PowerDeviceId +" == " + buf_body );
            }            
            if(buf_body.length() > 0) {                
@@ -791,7 +814,7 @@
     * @param alarm_type        告警有效  0-上下限有效  1-上限有效  2-下限有效
     */
    public static void checkPowerAlarmParam(StringBuffer buf_body,int PowerDeviceId,int alm_id,int alm_level,float alarm_limitH,boolean alarm_limitH_EN, float alarm_limitL, boolean alarm_limitL_EN,String alarm_name,int alarm_type,MysqlConnPool pool) {
        String sql_str_sel = "SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
        String sql_str_sel = "SELECT PowerDeviceId,alarm_name FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        ResultSet res = null; 
        res = sql.sqlMysqlQuery(sql_str_sel);
@@ -802,6 +825,13 @@
                    buf_body.append(",");
                }
                buf_body.append("("+PowerDeviceId+","+alm_id+","+alm_level+","+alarm_limitH+","+alarm_limitH_EN+","+alarm_limitL+","+alarm_limitL_EN+",'"+alarm_name+"',"+alarm_type+")");
            }else {
                String old_alm_name = res.getString("alarm_name");
                if(!old_alm_name.equals(alarm_name)) {
                    sql.sqlMysqlExecute("    UPDATE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table +
                                        " SET alarm_name = '" + alarm_name + "'" + 
                                        " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id);
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
@@ -817,6 +847,24 @@
        }
    }
    
    /**
     * 删除默认的告警参数
     * @param alm_id
     * @param pool
     */
    public static void deletePowerAlarmDefaultParam(int alm_id,MysqlConnPool pool) {
        String sql_str = " DELETE FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " where alm_id = " + alm_id;
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        //System.out.println(sql_str_sel);
        try {
            sql.sqlMysqlExecute(sql_str);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            sql.close_con();
        }
    }
	
    
    public static void main(String[] args) {
        MysqlConnPool pool = new MysqlConnPool("192.168.10.79", 3360, 5);

 BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java

@@ -185,7 +185,7 @@
    }
    
    
    
    /************************************************************************************************/
    /**
     *     山西电源部分电源告警id
     */
@@ -342,6 +342,21 @@
    public final static int ALM_TYPE_Envm_Smoke2_CommErr_ID     = 110135;            //烟感2通信故障
    public final static int ALM_TYPE_Envm_Smoke3_CommErr_ID     = 110136;            //烟感3通信故障
    
    public final static int ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID      = 110137;        //2路交流A相过压	
    public final static int ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID   = 110138;        //2路交流A相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID      = 110139;        //2路交流A相缺相
    public final static int ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID      = 110140;        //2路交流B相过压
    public final static int ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID   = 110141;        //2路交流B相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID      = 110142;        //2路交流B相缺相
    public final static int ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID      = 110143;        //2路交流C相过压
    public final static int ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID   = 110144;        //2路交流C相欠压
    public final static int ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID      = 110145;        //2路交流C相缺相
	
    public final static int ALM_TYPE_PWRDEV_ERROR_ID                   = 110146;        //电源告警
    public final static int ALM_TYPE_ACDC_PowerDown_CommErr_ID           = 110147;        //交流停电通信故障
    /************************************************************************************************/
    
    
    public final static int Alarm_Type_TotalEff                 = 0;                //上下限有效
    public final static int Alarm_Type_TotalHigh                 = 1;                //上限有效
    public final static int Alarm_Type_TotalLow                 = 2;                //下限有效

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,6 +1,11 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    
V1.84 edit at date 2023-07-27
    1.删除默认的电源交流停电告警参数
    2.默认插入国网电源2路的三相告警参数
    3.将国网电源原交流三相电压告警参数前新增路数

    
V1.83 edit at date 2023-07-26
    1.'db_pwrdev_inf.tb_pwrdev_inf'新增字段用于判断电源告警中的交流停电告警

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -32,7 +32,7 @@
    /**************************************************************************/
    /**************************************************************************/
    public final static boolean app_debug = false;
    public final static float m_VersionNum = (float) 1.83;
    public final static float m_VersionNum = (float) 1.84;
    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
    /**************************************************************************/
    /**************************************************************************/