From 1c292d4397f410497bebe111a558bc1d5469149b Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 22 三月 2023 10:15:07 +0800
Subject: [PATCH] V1.62 edit at date 2023-03-22 1.创建山西电源告警参数表'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'，并录入所有电源设备告警参数 CREATE TABLE `tb_pwrdev_alarm_param_forsx` ( `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT '电源id', `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '告警id', `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '告警等级', `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '告警上限阈值', `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上限告警使能', `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '告警下限阈值', `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警下限使能', `alarm_source` int(11) NOT NULL DEFAULT '0' COMMENT '告警数据来源[0-设备告警点位判断；1-当前阈值判断]', `alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT '当前告警描述', `alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-上下限有效 1-上限有效 2-下限有效', PRIMARY KEY (`num`) ) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表'; 2.表'db_pwrdev_alarm.tb_pwrdev_alarm'表新增字段 用于标识当前告警来源 `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]' 3.表'db_pwrdev_alarm.tb_pwrdev_alarm_history'表新增字段 用于标识当前告警来源 `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'
---
BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java | 89 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 89 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 f3533c0..481b0f0 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
@@ -90,6 +90,95 @@
sqlstb_page_param.add(strs[i]);
}
}
+
+
+
+ /**
+ * 山西电源部分电源告警id
+ */
+ public final static int ALM_TYPE_ACDC_AcIn1_A_OverV_ID = 110001; //交流A相过压
+ public final static int ALM_TYPE_ACDC_AcIn1_A_UnderV_ID = 110002; //交流A相欠压
+ public final static int ALM_TYPE_ACDC_AcIn1_A_Less_ID = 110003; //交流A相缺相
+ public final static int ALM_TYPE_ACDC_AcIn1_B_OverV_ID = 110004; //交流B相过压
+ public final static int ALM_TYPE_ACDC_AcIn1_B_UnderV_ID = 110005; //交流B相欠压
+ public final static int ALM_TYPE_ACDC_AcIn1_B_Less_ID = 110006; //交流B相缺相
+ public final static int ALM_TYPE_ACDC_AcIn1_C_OverV_ID = 110007; //交流C相过压
+ 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_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_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过压
+ public final static int ALM_TYPE_ACDC_Mod4_OverVol_ID = 110050; //整流器4过压
+ public final static int ALM_TYPE_ACDC_Mod5_OverVol_ID = 110051; //整流器5过压
+ public final static int ALM_TYPE_ACDC_Mod6_OverVol_ID = 110052; //整流器6过压
+ public final static int ALM_TYPE_ACDC_Mod7_OverVol_ID = 110053; //整流器7过压
+ public final static int ALM_TYPE_ACDC_Mod8_OverVol_ID = 110054; //整流器8过压
+ public final static int ALM_TYPE_ACDC_Mod9_OverVol_ID = 110055; //整流器9过压
+ public final static int ALM_TYPE_ACDC_Mod10_OverVol_ID = 110056; //整流器10过压
+ public final static int ALM_TYPE_ACDC_Mod11_OverVol_ID = 110057; //整流器11过压
+ public final static int ALM_TYPE_ACDC_Mod12_OverVol_ID = 110058; //整流器12过压
+ public final static int ALM_TYPE_ACDC_Mod13_OverVol_ID = 110059; //整流器13过压
+ public final static int ALM_TYPE_ACDC_Mod14_OverVol_ID = 110060; //整流器14过压
+ public final static int ALM_TYPE_ACDC_Mod15_OverVol_ID = 110061; //整流器15过压
+ public final static int ALM_TYPE_ACDC_Mod16_OverVol_ID = 110062; //整流器16过压
+
+ public final static int ALM_TYPE_ACDC_Mod1_UnderVol_ID = 110063; //整流器1欠压
+ public final static int ALM_TYPE_ACDC_Mod2_UnderVol_ID = 110064; //整流器2欠压
+ public final static int ALM_TYPE_ACDC_Mod3_UnderVol_ID = 110065; //整流器3欠压
+ public final static int ALM_TYPE_ACDC_Mod4_UnderVol_ID = 110066; //整流器4欠压
+ public final static int ALM_TYPE_ACDC_Mod5_UnderVol_ID = 110067; //整流器5欠压
+ public final static int ALM_TYPE_ACDC_Mod6_UnderVol_ID = 110068; //整流器6欠压
+ public final static int ALM_TYPE_ACDC_Mod7_UnderVol_ID = 110069; //整流器7欠压
+ public final static int ALM_TYPE_ACDC_Mod8_UnderVol_ID = 110070; //整流器8欠压
+ public final static int ALM_TYPE_ACDC_Mod9_UnderVol_ID = 110071; //整流器9欠压
+ public final static int ALM_TYPE_ACDC_Mod10_UnderVol_ID = 110072; //整流器10欠压
+ public final static int ALM_TYPE_ACDC_Mod11_UnderVol_ID = 110073; //整流器11欠压
+ public final static int ALM_TYPE_ACDC_Mod12_UnderVol_ID = 110074; //整流器12欠压
+ public final static int ALM_TYPE_ACDC_Mod13_UnderVol_ID = 110075; //整流器13欠压
+ public final static int ALM_TYPE_ACDC_Mod14_UnderVol_ID = 110076; //整流器14欠压
+ public final static int ALM_TYPE_ACDC_Mod15_UnderVol_ID = 110077; //整流器15欠压
+ public final static int ALM_TYPE_ACDC_Mod16_UnderVol_ID = 110078; //整流器16欠压
+
+ public final static int ALM_TYPE_ACDC_Mod1_OverCurr_ID = 110079; //整流器1过流
+ public final static int ALM_TYPE_ACDC_Mod2_OverCurr_ID = 110080; //整流器2过流
+ public final static int ALM_TYPE_ACDC_Mod3_OverCurr_ID = 110081; //整流器3过流
+ public final static int ALM_TYPE_ACDC_Mod4_OverCurr_ID = 110082; //整流器4过流
+ public final static int ALM_TYPE_ACDC_Mod5_OverCurr_ID = 110083; //整流器5过流
+ public final static int ALM_TYPE_ACDC_Mod6_OverCurr_ID = 110084; //整流器6过流
+ public final static int ALM_TYPE_ACDC_Mod7_OverCurr_ID = 110085; //整流器7过流
+ public final static int ALM_TYPE_ACDC_Mod8_OverCurr_ID = 110086; //整流器8过流
+ public final static int ALM_TYPE_ACDC_Mod9_OverCurr_ID = 110087; //整流器9过流
+ public final static int ALM_TYPE_ACDC_Mod10_OverCurr_ID = 110088; //整流器10过流
+ public final static int ALM_TYPE_ACDC_Mod11_OverCurr_ID = 110089; //整流器11过流
+ public final static int ALM_TYPE_ACDC_Mod12_OverCurr_ID = 110090; //整流器12过流
+ public final static int ALM_TYPE_ACDC_Mod13_OverCurr_ID = 110091; //整流器13过流
+ public final static int ALM_TYPE_ACDC_Mod14_OverCurr_ID = 110092; //整流器14过流
+ 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 Alarm_Type_TotalEff = 0; //上下限有效
+ public final static int Alarm_Type_TotalHigh = 1; //上限有效
+ public final static int Alarm_Type_TotalLow = 2; //下限有效
+
+
+ public final static int Alarm_Level_First = 1; //1级告警
+ public final static int Alarm_Level_Second = 2; //2级告警
+ public final static int Alarm_Level_Third = 3; //3级告警
+ public final static int Alarm_Level_Fourth = 4; //4级告警
+
+
+
+
+
+
+
+
// public static void main(String[] args) {
// System.out.println("SqlsUtils.sqlstb_page_param2 = " + SqlsUtils.sqlstb_page_param2);
--
Gitblit v1.9.1