1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
| package com.power.alarm;
|
| import java.sql.ResultSet;
| import java.sql.SQLException;
|
| import org.apache.logging.log4j.LogManager;
| import org.apache.logging.log4j.Logger;
|
| import com.power.data.PowerData_RT_SQL;
| import com.power.mysql.MysqlConnPool;
| import com.power.mysql.Sql_Mysql;
|
| public class Alarm_Param_SQL {
| public static final String PWRDEV_ALARM_PARAM_TABLE = "tb_pwrdev_alarm_param_";
|
| static Logger logger = LogManager.getLogger(PowerData_RT_SQL.class);
|
| 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.err.println("ex:"+ex);
| if(!ex)
| {
|
| String sql_str = "CREATE TABLE IF NOT EXISTS" + Sql_Mysql.PWRDEV_ALARM_PARAM_TABLE+powerdevid+"`"
| + "( `num` BIGINT NOT NULL AUTO_INCREMENT, "
| + "`alarm_id` BIGINT NOT NULL DEFAULT 0, "
| + "`alarm_limitH` float NOT NULL DEFAULT 0, "
| + "`alarm_limitL` float NOT NULL DEFAULT 0, "
| + "`alarm_limitEn` INT NOT NULL DEFAULT 0, "
| + "`UserAlarm_EN` INT NOT NULL DEFAULT 1, "
| + "`alarm_level` INT NOT NULL DEFAULT 0, "
| + "`alarm_devtype` INT NOT NULL DEFAULT 0, "
| + "`alarm_name` VARCHAR(100) NOT NULL DEFAULT '0', "
|
| + "INDEX index_alarm_id (`alarm_id`), "
| + "UNIQUE KEY `unique_alarm_id` (`alarm_id`), "
| + "PRIMARY KEY (`num`)) "
| + "ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
| 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_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);
| } finally {
| try {
| sql.close_con();
| } catch (Exception e){
| logger.error(e.toString(), e);
| }
| }
| }
|
| 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 + ","
| + alm_l + ","
| + alm_en + ","
| + level + ","
| + type + ","
| + user_en + ","
| + "\""+name+"\"" + ")";
|
| //logger.info(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 {
|
| Alarm_Param aparam = new Alarm_Param();
| aparam.alarm_id = alm_type_id;
|
| sql.sqlMysqlUseDB(Sql_Mysql.DB_PWRDEV_ALARM);
|
| String sql_str = " SELECT alarm_limitH,alarm_limitL,UserAlarm_EN,alarm_level,alarm_devtype "
| + " FROM " + Sql_Mysql.PWRDEV_ALARM_PARAM_TABLE +powerdevid+"`"
| + " WHERE alarm_id="+ alm_type_id
| + " ORDER BY alarm_id DESC ";
|
| ResultSet rs = sql.sqlMysqlQuery(sql_str);
| if(rs.next()) {
| aparam.alarm_limitH = rs.getFloat("alarm_limitH");
| aparam.alarm_limitL = rs.getFloat("alarm_limitL");
| aparam.alarm_level = rs.getInt("alarm_level");
| aparam.alarm_devtype = rs.getInt("alarm_devtype");
| aparam.UserAlarm_EN = rs.getInt("UserAlarm_EN");
| }
| else {
|
| }
| if(null != rs) {
| rs.close();
| }
| return aparam;
| }
|
| }
|
|
