云南昆明电源通信程序更新

DELL

2024-10-10 13644901831040bd4564aa1d61ac62fab0a58cd6

 IEC61850_ForPowerSupply_ForNW/src/com/power/alarm/Alarm_Param_SQL.java

@@ -18,12 +18,11 @@
   public static void init_alarm_param_sql(int powerdevid, MysqlConnPool conn_pool) {

      

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

		
      try {

         sql.sqlMysqlUseDB(Sql_Mysql.DB_PWRDEV_ALARM);

         

         boolean ex = sql.sqlMysqlCheckIfTableExist(PWRDEV_ALARM_PARAM_TABLE+powerdevid);

         //System.out.println("ex:"+ex);

         //System.err.println("ex:"+ex);

         if(!ex) 

         {

            

@@ -45,104 +44,123 @@
            

            sql.sqlMysqlExecute(sql_str);

            

            //通信电源

            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);      //交流输入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);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module3Err_ID, (float)0, (float)0,0,3, 1,0,"模块3故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module4Err_ID, (float)0, (float)0,0,3, 1,0,"模块4故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module5Err_ID, (float)0, (float)0,0,3, 1,0,"模块5故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module6Err_ID, (float)0, (float)0,0,3, 1,0,"模块6故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module7Err_ID, (float)0, (float)0,0,3, 1,0,"模块7故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module8Err_ID, (float)0, (float)0,0,3, 1,0,"模块8故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module9Err_ID, (float)0, (float)0,0,3, 1,0,"模块9故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module10Err_ID, (float)0, (float)0,0,3, 1,0,"模块10故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module11Err_ID, (float)0, (float)0,0,3, 1,0,"模块11故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module12Err_ID, (float)0, (float)0,0,3, 1,0,"模块12故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module13Err_ID, (float)0, (float)0,0,3, 1,0,"模块13故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module14Err_ID, (float)0, (float)0,0,3, 1,0,"模块14故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module15Err_ID, (float)0, (float)0,0,3, 1,0,"模块15故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module16Err_ID, (float)0, (float)0,0,3, 1,0,"模块16故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_TolalAlarm_ID, (float)0, (float)0,0,3, 1,0,"高频开关电源柜总告警",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_DCout_OverV_ID, (float)57, (float)43,1,2, 1,0,"直流输出过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_DCout_UnderV_ID, (float)57, (float)43,1,2, 1,0,"直流输出欠压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Batt1_Down_ID, (float)57, (float)43,1,2,0,0,"电池组下电保护",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_BattGrp1Fuse_ID, (float)57, (float)43,1,2, 1,0,"电池组1熔丝告警",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_BattGrp2Fuse_ID, (float)57, (float)43,1,2, 1,0,"电池组2熔丝告警",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_LoaderFuse_ID, (float)57, (float)43,1,2, 1,0,"负载熔丝告警",sql);				
				
            //AC

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_PowerDown_ID, (float)264.0, (float)110.0,1,1, 2,0,"交流输入1停电",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_PowerDown_ID, (float)264.0, (float)110.0,1,1, 2,0,"交流输入2停电",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_ThunderErr_ID, (float)0, (float)0,0,2, 2,0,"交流输入1防雷器故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_ThunderErr_ID, (float)0, (float)0,0,2, 2,0,"交流输入2防雷器故障",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_Trip_ID, (float)0, (float)0,0,2, 2,0,"第1路交流空开跳闸",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_Trip_ID, (float)0, (float)0,0,2, 2,0,"第2路交流空开跳闸",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_A_OverV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流A相过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_A_UnderV_ID, (float)264, (float)176,1,2,2,0,"第1路交流A相欠压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_B_OverV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流B相过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_B_UnderV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流B相欠压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_C_OverV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流C相过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_C_UnderV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流C相欠压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_A_OverV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流A相过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_A_UnderV_ID, (float)264, (float)176,1,2,2,0,"第2路交流A相欠压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_B_OverV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流B相过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_B_UnderV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流B相欠压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_C_OverV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流C相过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_C_UnderV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流C相欠压",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_A_Less_ID, (float)264, (float)110,1,2, 2,0,"第1路交流A相缺相",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_B_Less_ID, (float)264, (float)110,1,2, 2,0,"第1路交流B相缺相",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_C_Less_ID, (float)264, (float)110,1,2, 2,0,"第1路交流C相缺相",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_A_Less_ID, (float)264, (float)110,1,2, 2,0,"第2路交流A相缺相",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_B_Less_ID, (float)264, (float)110,1,2, 2,0,"第2路交流B相缺相",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_C_Less_ID, (float)264, (float)110,1,2, 2,0,"第2路交流C相缺相",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_MonitorErr_ID, (float)0, (float)0,0,2, 2,0,"监控单元故障",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_MX1_SW_N_Trip_ID, (float)0, (float)0,0,3, 2,0,"1段交流母线输出开关N跳闸" ,sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_MX2_SW_N_Trip_ID, (float)0, (float)0,0,3, 2,0,"2段交流母线输出开关N跳闸" ,sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_TolalAlarm_ID, (float)0, (float)0,0,3,2, 0,"交流配电柜总告警",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_TempAlarm_ID, (float)55, (float)10,1,3, 2, 0,"交流配电柜温度告警",sql);				


            //DC

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DCout1_OverV_ID, (float)57, (float)43,1, 2, 3,0,"第1路直流过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DCout1_UnderV_ID, (float)57, (float)43,1, 2, 3,0,"第1路直流欠压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DCout2_OverV_ID, (float)57, (float)43,1, 2, 3,0,"第2路直流过压",sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DCout2_UnderV_ID, (float)57, (float)43,1, 2, 3,0,"第2路直流欠压",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DcIn1_Trip_ID, (float)0, (float)0,0, 2, 3,0,"第1路输入开关跳闸",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DcIn2_Trip_ID, (float)0, (float)0,0, 2, 3,0,"第2路输入开关跳闸",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DC1_SW_N_Trip_ID, (float)0, (float)0,0,3, 2,0,"1段直流第N路跳闸" ,sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DC2_SW_N_Trip_ID, (float)0, (float)0,0,3, 2,0,"2段直流第N路跳闸" ,sql);

            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_TempAlarm_ID, (float)55, (float)10,1,3, 3,0,"温度告警",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_MonitorErr_ID, (float)0, (float)0,0,3, 3,0,"监控单元故障",sql);				
            insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_TolalAlarm_ID, (float)0, (float)0,0,3, 3,0,"直流配电柜总告警",sql);	
            

         }

         //通信电源

         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);      //交流输入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);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module3Err_ID, (float)0, (float)0,0,3, 1,0,"模块3故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module4Err_ID, (float)0, (float)0,0,3, 1,0,"模块4故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module5Err_ID, (float)0, (float)0,0,3, 1,0,"模块5故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module6Err_ID, (float)0, (float)0,0,3, 1,0,"模块6故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module7Err_ID, (float)0, (float)0,0,3, 1,0,"模块7故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module8Err_ID, (float)0, (float)0,0,3, 1,0,"模块8故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module9Err_ID, (float)0, (float)0,0,3, 1,0,"模块9故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module10Err_ID, (float)0, (float)0,0,3, 1,0,"模块10故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module11Err_ID, (float)0, (float)0,0,3, 1,0,"模块11故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module12Err_ID, (float)0, (float)0,0,3, 1,0,"模块12故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module13Err_ID, (float)0, (float)0,0,3, 1,0,"模块13故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module14Err_ID, (float)0, (float)0,0,3, 1,0,"模块14故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module15Err_ID, (float)0, (float)0,0,3, 1,0,"模块15故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module16Err_ID, (float)0, (float)0,0,3, 1,0,"模块16故障",sql);



         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module1Close_ID, (float)0, (float)0,0,1, 1,0,"模块1关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module2Close_ID, (float)0, (float)0,0,1, 1,0,"模块2关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module3Close_ID, (float)0, (float)0,0,1, 1,0,"模块3关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module4Close_ID, (float)0, (float)0,0,1, 1,0,"模块4关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module5Close_ID, (float)0, (float)0,0,1, 1,0,"模块5关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module6Close_ID, (float)0, (float)0,0,1, 1,0,"模块6关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module7Close_ID, (float)0, (float)0,0,1, 1,0,"模块7关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module8Close_ID, (float)0, (float)0,0,1, 1,0,"模块8关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module9Close_ID, (float)0, (float)0,0,1, 1,0,"模块9关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module10Close_ID, (float)0, (float)0,0,1, 1,0,"模块10关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module11Close_ID, (float)0, (float)0,0,1, 1,0,"模块11关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module12Close_ID, (float)0, (float)0,0,1, 1,0,"模块12关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module13Close_ID, (float)0, (float)0,0,1, 1,0,"模块13关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module14Close_ID, (float)0, (float)0,0,1, 1,0,"模块14关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module15Close_ID, (float)0, (float)0,0,1, 1,0,"模块15关机",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module16Close_ID, (float)0, (float)0,0,1, 1,0,"模块16关机",sql);

			
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_TolalAlarm_ID, (float)0, (float)0,0,3, 1,0,"高频开关电源柜总告警",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_DCout_OverV_ID, (float)57, (float)43,1,2, 1,0,"直流输出过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_DCout_UnderV_ID, (float)57, (float)43,1,2, 1,0,"直流输出欠压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Batt1_Down_ID, (float)57, (float)43,1,2,0,0,"电池组下电保护",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_BattGrp1Fuse_ID, (float)57, (float)43,1,2, 1,0,"电池组1熔丝告警",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_BattGrp2Fuse_ID, (float)57, (float)43,1,2, 1,0,"电池组2熔丝告警",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_ACDC_LoaderFuse_ID, (float)57, (float)43,1,2, 1,0,"负载熔丝告警",sql);				
			
         //AC

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_PowerDown_ID, (float)264.0, (float)110.0,1,1, 2,0,"交流输入1停电",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_PowerDown_ID, (float)264.0, (float)110.0,1,1, 2,0,"交流输入2停电",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_ThunderErr_ID, (float)0, (float)0,0,2, 2,0,"交流输入1防雷器故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_ThunderErr_ID, (float)0, (float)0,0,2, 2,0,"交流输入2防雷器故障",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_Trip_ID, (float)0, (float)0,0,2, 2,0,"第1路交流空开跳闸",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_Trip_ID, (float)0, (float)0,0,2, 2,0,"第2路交流空开跳闸",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_A_OverV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流A相过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_A_UnderV_ID, (float)264, (float)176,1,2,2,0,"第1路交流A相欠压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_B_OverV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流B相过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_B_UnderV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流B相欠压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_C_OverV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流C相过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_C_UnderV_ID, (float)264, (float)176,1,2, 2,0,"第1路交流C相欠压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_A_OverV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流A相过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_A_UnderV_ID, (float)264, (float)176,1,2,2,0,"第2路交流A相欠压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_B_OverV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流B相过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_B_UnderV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流B相欠压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_C_OverV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流C相过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_C_UnderV_ID, (float)264, (float)176,1,2, 2,0,"第2路交流C相欠压",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_A_Less_ID, (float)264, (float)110,1,2, 2,0,"第1路交流A相缺相",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_B_Less_ID, (float)264, (float)110,1,2, 2,0,"第1路交流B相缺相",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn1_C_Less_ID, (float)264, (float)110,1,2, 2,0,"第1路交流C相缺相",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_A_Less_ID, (float)264, (float)110,1,2, 2,0,"第2路交流A相缺相",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_B_Less_ID, (float)264, (float)110,1,2, 2,0,"第2路交流B相缺相",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_AcIn2_C_Less_ID, (float)264, (float)110,1,2, 2,0,"第2路交流C相缺相",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_MonitorErr_ID, (float)0, (float)0,0,2, 2,0,"监控单元故障",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_MX1_SW_N_Trip_ID, (float)0, (float)0,0,3, 2,0,"1段交流母线输出开关N跳闸" ,sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_MX2_SW_N_Trip_ID, (float)0, (float)0,0,3, 2,0,"2段交流母线输出开关N跳闸" ,sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_TolalAlarm_ID, (float)0, (float)0,0,3,2, 0,"交流配电柜总告警",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_AC_TempAlarm_ID, (float)55, (float)10,1,3, 2, 0,"交流配电柜温度告警",sql);				


         //DC

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DCout1_OverV_ID, (float)57, (float)43,1, 2, 3,0,"第1路直流过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DCout1_UnderV_ID, (float)57, (float)43,1, 2, 3,0,"第1路直流欠压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DCout2_OverV_ID, (float)57, (float)43,1, 2, 3,0,"第2路直流过压",sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DCout2_UnderV_ID, (float)57, (float)43,1, 2, 3,0,"第2路直流欠压",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DcIn1_Trip_ID, (float)0, (float)0,0, 2, 3,0,"第1路输入开关跳闸",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DcIn2_Trip_ID, (float)0, (float)0,0, 2, 3,0,"第2路输入开关跳闸",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DC1_SW_N_Trip_ID, (float)0, (float)0,0,3, 2,0,"1段直流第N路跳闸" ,sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_DC2_SW_N_Trip_ID, (float)0, (float)0,0,3, 2,0,"2段直流第N路跳闸" ,sql);

         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_TempAlarm_ID, (float)55, (float)10,1,3, 3,0,"温度告警",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_MonitorErr_ID, (float)0, (float)0,0,3, 3,0,"监控单元故障",sql);				
         insert_alarm_param(powerdevid,PwrDeviceAlarm_Data.ALM_TYPE_DC_TolalAlarm_ID, (float)0, (float)0,0,3, 3,0,"直流配电柜总告警",sql);	
         

      }catch (Exception e) {

         logger.error(e.toString(), e);

@@ -158,7 +176,8 @@
   public static  void insert_alarm_param(int powerdevid,int id,float alm_h,float alm_l,int alm_en,int level,int type,int user_en,String name,Sql_Mysql sql) throws SQLException{

      

      String sql_str = " INSERT IGNORE INTO " + Sql_Mysql.PWRDEV_ALARM_PARAM_TABLE + powerdevid+"`";



      String sql_str_sel = "SELECT * FROM "  + Sql_Mysql.PWRDEV_ALARM_PARAM_TABLE + powerdevid+ "` WHERE alarm_id = " + id;

      ResultSet res = null;

      sql_str += " (alarm_id,alarm_limitH,alarm_limitL,alarm_limitEn,alarm_level,alarm_devtype,UserAlarm_EN,alarm_name ) VALUES ("

            + id + ","

            + alm_h + ","

@@ -170,8 +189,20 @@
            + "\""+name+"\"" + ")";

      

      //logger.info(sql_str);

		
      sql.sqlMysqlExecute(sql_str);

      try {

         res = sql.sqlMysqlQuery(sql_str_sel);

         if(!res.next()) {

            sql.sqlMysqlExecute(sql_str);

            //System.err.println(sql_str_sel);

         }

         //System.out.println(sql_str_sel);

      } catch (Exception e) {

         e.printStackTrace();

      } finally {

         if(null != res) {

            res.close();

         }

      }		
   }

   

   public static Alarm_Param query_alarm_param(int powerdevid,int alm_type_id, Sql_Mysql sql) throws SQLException {