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