From fc1671346a578cd47f39eb5c578d802b6eac1c4f Mon Sep 17 00:00:00 2001 From: Administrator <1525436766@qq.com> Date: 星期五, 19 五月 2023 15:29:31 +0800 Subject: [PATCH] 注意:1.新增电源机房时需要重新运行 --- BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java | 87 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 87 insertions(+), 0 deletions(-) diff --git a/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java b/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java index 7392fc2..b206863 100644 --- a/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java +++ b/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java @@ -192,10 +192,50 @@ public final static int ALM_TYPE_ACDC_AcIn1_C_UnderV_ID = 110008; //交流C相欠压 public final static int ALM_TYPE_ACDC_AcIn1_C_Less_ID = 110009; //交流C相缺相 + public final static int ALM_TYPE_ACDC_AcIn1_PowerDown_ID = 110010; //交流停电 + public final static int ALM_TYPE_ACDC_AcIn1_ThunderErr_ID = 110011; //防雷器故障 + + public final static int ALM_TYPE_ACDC_DCout_OverV_ID = 110012; //直流电压过高 + public final static int ALM_TYPE_ACDC_DCout_UnderV_ID = 110013; //直流电压过低 + + public final static int ALM_TYPE_ACDC_LoaderFuse_ID = 110014; //负载熔断 + public final static int ALM_TYPE_ACDC_BattGrp1Fuse_ID = 110015; //电池组1熔断 + public final static int ALM_TYPE_ACDC_BattGrp2Fuse_ID = 110016; //电池组2熔断 + + public final static int ALM_TYPE_ACDC_Module1Err_ID = 110017; //整流器1总故障 + public final static int ALM_TYPE_ACDC_Module2Err_ID = 110018; //整流器2总故障 + public final static int ALM_TYPE_ACDC_Module3Err_ID = 110019; //整流器3总故障 + public final static int ALM_TYPE_ACDC_Module4Err_ID = 110020; //整流器4总故障 + public final static int ALM_TYPE_ACDC_Module5Err_ID = 110021; //整流器5总故障 + public final static int ALM_TYPE_ACDC_Module6Err_ID = 110022; //整流器6总故障 + public final static int ALM_TYPE_ACDC_Module7Err_ID = 110023; //整流器7总故障 + public final static int ALM_TYPE_ACDC_Module8Err_ID = 110024; //整流器8总故障 + public final static int ALM_TYPE_ACDC_Module9Err_ID = 110025; //整流器9总故障 + public final static int ALM_TYPE_ACDC_Module10Err_ID = 110026; //整流器10总故障 + public final static int ALM_TYPE_ACDC_Module11Err_ID = 110027; //整流器11总故障 + public final static int ALM_TYPE_ACDC_Module12Err_ID = 110028; //整流器12总故障 + public final static int ALM_TYPE_ACDC_Module13Err_ID = 110029; //整流器13总故障 + public final static int ALM_TYPE_ACDC_Module14Err_ID = 110030; //整流器14总故障 + public final static int ALM_TYPE_ACDC_Module15Err_ID = 110031; //整流器15总故障 + public final static int ALM_TYPE_ACDC_Module16Err_ID = 110032; //整流器16总故障 + + public final static int ALM_TYPE_ACDC_AcAlarm_ID = 110033; //交流总故障 + public final static int ALM_TYPE_ACDC_DcAlarm_ID = 110034; //直流总故障 + public final static int ALM_TYPE_ACDC_Acb1_OverCurrA_ID = 110035; //交流A相过流 public final static int ALM_TYPE_ACDC_Acb1_OverCurrB_ID = 110036; //交流B相过流 public final static int ALM_TYPE_ACDC_Acb1_OverCurrC_ID = 110037; //交流C相过流 + public final static int ALM_TYPE_ACDC_MonitorErr_ID = 110038; //监控器故障 + public final static int ALM_TYPE_ACDC_DcOut_OverCurr_ID = 110039; //直流过流 + public final static int ALM_TYPE_ACDC_TolalAlarm_ID = 110040; //开关柜总报警 + public final static int ALM_TYPE_ACDC_Batt1_VolLow_ID = 110041; //电池组1电压低 + public final static int ALM_TYPE_ACDC_Batt2_VolLow_ID = 110042; //电池组2电压低 + public final static int ALM_TYPE_ACDC_Batt1_Down_ID = 110043; //电池组1下电 + public final static int ALM_TYPE_ACDC_Batt2_Down_ID = 110044; //电池组2下电 + public final static int ALM_TYPE_ACDC_Batt1_OverChgCurr_ID = 110045; //电池组1充电过流 + public final static int ALM_TYPE_ACDC_Batt2_OverChgCurr_ID = 110046; //电池组2充电过流 + public final static int ALM_TYPE_ACDC_Mod1_OverVol_ID = 110047; //整流器1过压 public final static int ALM_TYPE_ACDC_Mod2_OverVol_ID = 110048; //整流器2过压 public final static int ALM_TYPE_ACDC_Mod3_OverVol_ID = 110049; //整流器3过压 @@ -247,6 +287,53 @@ public final static int ALM_TYPE_ACDC_Mod15_OverCurr_ID = 110093; //整流器15过流 public final static int ALM_TYPE_ACDC_Mod16_OverCurr_ID = 110094; //整流器16过流 + public final static int ALM_TYPE_ACDC_Mod1_AC_Err_ID = 110095; //整流器1交流异常 + public final static int ALM_TYPE_ACDC_Mod2_AC_Err_ID = 110096; //整流器2交流异常 + public final static int ALM_TYPE_ACDC_Mod3_AC_Err_ID = 110097; //整流器3交流异常 + public final static int ALM_TYPE_ACDC_Mod4_AC_Err_ID = 110098; //整流器4交流异常 + public final static int ALM_TYPE_ACDC_Mod5_AC_Err_ID = 110099; //整流器5交流异常 + public final static int ALM_TYPE_ACDC_Mod6_AC_Err_ID = 110100; //整流器6交流异常 + public final static int ALM_TYPE_ACDC_Mod7_AC_Err_ID = 110101; //整流器7交流异常 + public final static int ALM_TYPE_ACDC_Mod8_AC_Err_ID = 110102; //整流器8交流异常 + public final static int ALM_TYPE_ACDC_Mod9_AC_Err_ID = 110103; //整流器9交流异常 + public final static int ALM_TYPE_ACDC_Mod10_AC_Err_ID = 110104; //整流器10交流异常 + public final static int ALM_TYPE_ACDC_Mod11_AC_Err_ID = 110105; //整流器11交流异常 + public final static int ALM_TYPE_ACDC_Mod12_AC_Err_ID = 110106; //整流器12交流异常 + public final static int ALM_TYPE_ACDC_Mod13_AC_Err_ID = 110107; //整流器13交流异常 + public final static int ALM_TYPE_ACDC_Mod14_AC_Err_ID = 110108; //整流器14交流异常 + public final static int ALM_TYPE_ACDC_Mod15_AC_Err_ID = 110109; //整流器15交流异常 + public final static int ALM_TYPE_ACDC_Mod16_AC_Err_ID = 110110; //整流器16交流异常 + + public final static int ALM_TYPE_ACDC_AcIn1_Trip_ID = 110111; //交流输入1跳闸 + public final static int ALM_TYPE_ACDC_AcIn2_Trip_ID = 110112; //交流输入2跳闸 + public final static int ALM_TYPE_ACDC_AcIn1_Fuse_ID = 110113; //交流输入1熔丝告警 + public final static int ALM_TYPE_ACDC_AcIn2_Fuse_ID = 110114; //交流输入2熔丝告警 + public final static int ALM_TYPE_ACDC_AcIn1_Unbalance_ID = 110115; //交流输入1三相不平衡 + public final static int ALM_TYPE_ACDC_AcIn2_Unbalance_ID = 110116; //交流输入2三相不平衡 + public final static int ALM_TYPE_ACDC_AcIn1_FreqErr_ID = 110117; //交流输入1频率异常 + public final static int ALM_TYPE_ACDC_AcIn2_FreqErr_ID = 110118; //交流输入2频率异常 + + public final static int ALM_TYPE_ACDC_CPSS_CommErr_ID = 110119; //协转通信故障 + + //1+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + public final static int ALM_TYPE_PWRDEV_CommErr_ID = 110120; //电源通信故障 + + public final static int ALM_TYPE_User_AcIn1_PowerDown_ID = 110121; //交流输入1停电 + public final static int ALM_TYPE_User_AcIn2_PowerDown_ID = 110122; //交流输入2停电 + public final static int ALM_TYPE_User_AcIn1_CommErr_ID = 110123; //交流1采集通信故障 + public final static int ALM_TYPE_User_AcIn2_CommErr_ID = 110124; //交流2采集通信故障 + public final static int ALM_TYPE_Envm_Temp1_CommErr_ID = 110125; //温感1通信故障 + public final static int ALM_TYPE_Envm_Temp2_CommErr_ID = 110126; //温感2通信故障 + public final static int ALM_TYPE_Envm_Temp3_CommErr_ID = 110127; //温感3通信故障 + public final static int ALM_TYPE_Envm_Humi1_CommErr_ID = 110128; //湿感1通信故障 + public final static int ALM_TYPE_Envm_Humi2_CommErr_ID = 110129; //湿感2通信故障 + public final static int ALM_TYPE_Envm_Humi3_CommErr_ID = 110130; //湿感3通信故障 + public final static int ALM_TYPE_Envm_Smoke1_Occur_ID = 110131; //烟感1报警 + public final static int ALM_TYPE_Envm_Smoke2_Occur_ID = 110132; //烟感2报警 + public final static int ALM_TYPE_Envm_Smoke3_Occur_ID = 110133; //烟感3报警 + public final static int ALM_TYPE_Envm_Smoke1_CommErr_ID = 110134; //烟感1通信故障 + 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 Alarm_Type_TotalEff = 0; //上下限有效 public final static int Alarm_Type_TotalHigh = 1; //上限有效 -- Gitblit v1.9.1