DELL
2024-03-19 89194580fce783fbffe56eed60bb66ebccaa6988
南瑞南网通信程序修改
4个文件已修改
67 ■■■■■ 已修改文件
IEC61850_ForPowerSupply_ForNW/config.xml 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
IEC61850_ForPowerSupply_ForNW/src/com/power/alarm/Alarm_Param_SQL.java 48 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
IEC61850_ForPowerSupply_ForNW/src/com/power/alarm/PwrDeviceAlarm_Thread.java 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
IEC61850_ForPowerSupply_ForNW/src/com/version_inf/version_inf.txt 12 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
IEC61850_ForPowerSupply_ForNW/config.xml
@@ -2,7 +2,7 @@
<root>
  <mysql_ramdb_recreate_en>false</mysql_ramdb_recreate_en>
  <mysql_server_ip>127.0.0.1</mysql_server_ip>
  <mysql_server_ip>192.168.10.79</mysql_server_ip>
  <!--SOURCE_BATTDATA_TYPE_FBSDEV = 0-->
  <!--SOURCE_BATTDATA_TYPE_SQLSERVER = 1-->
  <!--SOURCE_BATTDATA_TYPE_C_INTERFACE = 2-->
IEC61850_ForPowerSupply_ForNW/src/com/power/alarm/Alarm_Param_SQL.java
@@ -49,30 +49,30 @@
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_CPSS_CommErr_ID, (float)0, (float)0,0,1, 0,1,"通信电源通信故障",sql);
                
                //ACDC
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_PowerDown_ID, (float)264.0, (float)110.0,1,1, 1,0,"交流输入1停电",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_PowerDown_ID, (float)264.0, (float)110.0,1,1, 1,0,"交流输入2停电",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID, (float)0, (float)0,0, 2, 1,0,"交流输入1防雷器故障",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_ThunderErr_ID, (float)0, (float)0,0, 2, 1,0,"交流输入2防雷器故障",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_Trip_ID, (float)0, (float)0,0,2, 1,0,"第1路交流空开跳闸",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_Trip_ID, (float)0, (float)0,0,2, 1,0,"第2路交流空开跳闸",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_OverV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流A相过压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID, (float)264, (float)176,1,2,1,0,"第1路交流A相欠压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_OverV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流B相过压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流B相欠压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_OverV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流C相过压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流C相欠压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_A_OverV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流A相过压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_A_UnderV_ID, (float)264, (float)176,1,2,1,0, "第2路交流A相欠压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_B_OverV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流B相过压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_B_UnderV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流B相欠压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_C_OverV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流C相过压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_C_UnderV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流C相欠压",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_Less_ID, (float)264, (float)110,1,2, 1,0,"第1路交流A相缺相",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_Less_ID, (float)264, (float)110,1,2, 1,0,"第1路交流B相缺相",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_Less_ID, (float)264, (float)110,1,2, 1,0,"第1路交流C相缺相",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_A_Less_ID, (float)264, (float)110,1,2, 1,0,"第2路交流A相缺相",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_B_Less_ID, (float)264, (float)110,1,2, 1,0,"第2路交流B相缺相",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_C_Less_ID, (float)264, (float)110,1,2, 1,0,"第2路交流C相缺相",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_PowerDown_ID, (float)264.0, (float)110.0,1,1, 1,0,"交流输入1停电",sql);        //交流输入1停电
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_PowerDown_ID, (float)264.0, (float)110.0,1,1, 1,0,"交流输入2停电",sql);        //交流输入2停电
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID, (float)0, (float)0,0, 2, 1,0,"交流输入1防雷器故障",sql);            //交流输入1防雷器故障
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_ThunderErr_ID, (float)0, (float)0,0, 2, 1,0,"交流输入2防雷器故障",sql);            //交流输入2防雷器故障
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_Trip_ID, (float)0, (float)0,0,2, 1,0,"第1路交流空开跳闸",sql);                    //第1路交流空开跳闸
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_Trip_ID, (float)0, (float)0,0,2, 1,0,"第2路交流空开跳闸",sql);                    //第2路交流空开跳闸
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_OverV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流A相过压",sql);            //第1路交流A相过压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID, (float)264, (float)176,1,2,1,0,"第1路交流A相欠压",sql);            //第1路交流A相欠压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_OverV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流B相过压",sql);            //第1路交流B相过压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流B相欠压",sql);            //第1路交流B相欠压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_OverV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流C相过压",sql);            //第1路交流C相过压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID, (float)264, (float)176,1,2, 1,0,"第1路交流C相欠压",sql);            //第1路交流C相欠压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_A_OverV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流A相过压",sql);            //第2路交流A相过压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_A_UnderV_ID, (float)264, (float)176,1,2,1,0, "第2路交流A相欠压",sql);            //第2路交流A相欠压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_B_OverV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流B相过压",sql);            //第2路交流B相过压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_B_UnderV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流B相欠压",sql);            //第2路交流B相欠压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_C_OverV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流C相过压",sql);            //第2路交流C相过压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_C_UnderV_ID, (float)264, (float)176,1,2, 1,0,"第2路交流C相欠压",sql);            //第2路交流C相欠压
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_Less_ID, (float)264, (float)110,1,2, 1,0,"第1路交流A相缺相",sql);            //第1路交流A相缺相
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_Less_ID, (float)264, (float)110,1,2, 1,0,"第1路交流B相缺相",sql);            //第1路交流B相缺相
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_Less_ID, (float)264, (float)110,1,2, 1,0,"第1路交流C相缺相",sql);            //第1路交流C相缺相
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_A_Less_ID, (float)264, (float)110,1,2, 1,0,"第2路交流A相缺相",sql);            //第2路交流A相缺相
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_B_Less_ID, (float)264, (float)110,1,2, 1,0,"第2路交流B相缺相",sql);            //第2路交流B相缺相
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_C_Less_ID, (float)264, (float)110,1,2, 1,0,"第2路交流C相缺相",sql);            //第2路交流C相缺相
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_MonitorErr_ID, (float)0, (float)0,0,2, 1,0,"监控单元故障",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module1Err_ID, (float)0, (float)0,0,3, 1,0,"模块1故障",sql);
                insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module2Err_ID, (float)0, (float)0,0,3, 1,0,"模块2故障",sql);
IEC61850_ForPowerSupply_ForNW/src/com/power/alarm/PwrDeviceAlarm_Thread.java
@@ -320,6 +320,11 @@
            for(int n=0;n<m_AL_Data.getItemCount();n++) {
                
                PowerData_RT rtpd = m_AL_Data.getItem(n);
                if(115 != (rtpd.PowerDevDeviceId/1000000)) {
                    //System.out.println(m_AL_Data.getItem(n).PowerDevDeviceId);
                    continue;
                }
                                
                Alarm_Param_SQL.init_alarm_param_sql(rtpd.PowerDevDeviceId, m_Conn_Pool);
                
IEC61850_ForPowerSupply_ForNW/src/com/version_inf/version_inf.txt
@@ -1,5 +1,17 @@
    南瑞版本电源通信程序
    南网电源告警逻辑
        所有告警根据点位触发的告警-无告警参数,暂时不可关闭监测
        交流配电柜
        直流配电柜
        高频开关柜
V1.103  2024-03-07 lijun
    1.新增历史告警分表,以及根据历史告警 记录最久保留3年的 电源历史告警记录