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
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
| package com.database_util;
|
| import java.util.ArrayList;
| import java.util.Arrays;
| import java.util.List;
|
| import com.sql.Sql_Mysql;
|
| public class SqlsUtils {
|
| /**
| * db_app_sys.tb_page_paramµÄĬÈϲÎÊýÖеÄid
| */
| static List<Integer> idsDefault;
|
| /**
| * db_app_sys.tb_page_param2µÄĬÈϲÎÊýÖеÄid
| */
| static List<Integer> idsDefault2;
|
| /**
| * db_app_sys.tb_menuµÄĬÈϲÎÊýÖеÄid
| */
| static List<Integer> idsDefault_tb_menu;
|
|
| /**
| * db_app_sys.tb_page_paramµÄĬÈÏinsertÓï¾ä
| */
| static ArrayList<String> sqlstb_page_param;
| /**
| * db_app_sys.tb_page_param2µÄĬÈÏinsertÓï¾ä
| */
| static ArrayList<String> sqlstb_page_param2;
|
|
| /**
| * db_app_sys.tb_menuµÄĬÈÏinsertÓï¾ä
| */
| static ArrayList<String> sqlstb_tb_menu;
|
|
| /**
| * db_app_sys.tb_alarm_relation µÄĬÈÏinsertÓï¾ä
| */
| static ArrayList<String> sqlstb_tb_alarm_relation;
|
|
| static {
|
| Integer[] temp= {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,47,48,49,50,51,52};
| idsDefault = Arrays.asList(temp);
|
| Integer[] temp2= {1,2,3,4};
| idsDefault2 = Arrays.asList(temp2);
|
| sqlstb_page_param2 = new ArrayList<>();
| String tb_page_param2 = "INSERT INTO `db_app_sys`.`tb_page_param2`(`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) VALUES ('1', 'visit_time_first', 'Óû§µÇ¼·ÃÎÊ¿ØÖÆ-·ÃÎÊʱ¼ä×îÔç', '00:00:01', '1','User Login Access Control-Access Earliest');" +
| "INSERT INTO `db_app_sys`.`tb_page_param2`(`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) VALUES ('2', 'visit_time_last', 'Óû§µÇ¼·ÃÎÊ¿ØÖÆ-·ÃÎÊʱ¼ä×îÍí', '23:59:59', '1','User Login Access Control-Access Latest');" +
| "INSERT INTO `db_app_sys`.`tb_page_param2`(`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) VALUES ('3', 'visit_ip', 'Óû§µÇ¼·ÃÎÊ¿ØÖÆ-·ÃÎÊ¿Í»§¶Ëip-ÔÊÐí', '*', '1','User Login Access Control-Access Client IP-Allow');"+
| "INSERT INTO `db_app_sys`.`tb_page_param2`(`id`, `param`, `label`, `value`, `categoryId`,`lableEnUs`) VALUES ('4', 'audit_cap', 'Éó¼ÆÊý¾Ý¼Ç¼ÈÝÁ¿', '5000', '2','');";
| String[] strs2 = tb_page_param2.split(";");
| for (int i = 0; i < strs2.length; i++) {
| sqlstb_page_param2.add(strs2[i]);
| }
|
| sqlstb_page_param = new ArrayList<>();
| String tb_page_param = "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('1', 'É豸¹¤×÷״̬', '1', '1','Device Status');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('2', 'É豸ͨѶ', '1', '1','Device Communication');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('3', 'É豸ζÈ', '1', '1','Temperature(¡ãC)');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('4', '¸É½Óµã', '1', '1','Dry Contact');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('5', 'ºËÈÝÖÕÖ¹ÔÒò', '1', '1','Reason for capacity check termination');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('6', '²Ù×÷ʧ°ÜÔÒò', '1', '1','Operate Failure Reason');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('7', 'Ê£ÓàÌìÊý', '1', '1','Remaining Day(s)');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('8', '¹¤×÷ģʽ', '1', '1','Working Mode');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('9', '×é¶Ëµçѹ', '1', '1','String Voltage');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('10', '·åÖµµçѹ', '1', '1','Peak Voltage');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('11', 'Æô¶¯ºËÈݲâÊÔ', '1', '2','Initiate capacity check testing');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('12', 'Í£Ö¹²âÊÔ', '1', '2','Stop testing');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('13', 'ϵͳ²ÎÊýÉèÖÃ', '1', '2','System Parms Setting');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('14', 'Çå³ý¸æ¾¯', '1', '2','Clear Alarm');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('15', 'Æô¶¯Ñø»¤/³ýÁò', '1', '2','Start Maintenance/Desulfation');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('16', 'Í£Ö¹Ñø»¤/³ýÁò', '1', '2','Stop Maintenance/Desulfation');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('17', 'Æô¶¯ÀëÏßÑø»¤', '1', '2','Start Offline Maintenance');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('18', 'Í£Ö¹ÀëÏßÑø»¤', '1', '2','Stop Offline Maintenance');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('19', '¶¨ÆÚÆô¶¯É豸', '1', '2','Periodically Ratart');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('20', 'ÖØÆôÉ豸', '1', '2','Restart');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('21', '¾ùºâ¿ØÖƲÎÊýÉèÖà ', '1', '2','Balance Control Parms Setting');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('31', 'Ðîµç³Øºǫ́¼à¿Ø¹ÜÀíƽ̨', '1', '5','Intelligent System for Battery Uninterruptible Power Supply');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('32', 'V1.0.5', '1', '6','V1.0.5');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('33', 'ƽ̨logo', '1', '7','Platform logo');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('34', 'uKey', '1', '7','uKey');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('35', 'ÈËÁ³Ê¶±ð', '1', '7','Face recognition');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('36', 'Ç©Ãû', '1', '7','signature');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('37', 'Ô¶³ÌÐÞ¸Äip', '1', '7','Remote modification of IP');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('38', 'Æô¶¯·ÅµçÌí¼ÓÈËÁ³Ê¶±ð', '1', '7','Start discharging and add facial recognition');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('39', 'Õ˺ÅɨÃè²ßÂÔ', '1', '8','Account scanning strategy');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('40', 'Õ˺ŵǼʧ°ÜÏÞÖÆ´ÎÊý', '10', '9','Account login failure limit number of times');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('41', 'Õ˺ŵǼʧ°ÜËø¶¨½âËø²ßÂÔ', '2', '9','Account login failure lock unlock strategy');" +
|
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('42', 'ÃÜÂëÉèÖùæÔò-λÊý', '8', '10','Password setting rules - number of digits');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('43', 'ÃÜÂëÉèÖùæÔò-·ûºÅÀàÐÍ', '4', '10','Password Setting Rules - Symbol Types');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('44', 'ÀúÊ·Êý¾ÝµÄÍÕ·å¹øµ×¹¦ÄÜ¿ªÆô', '1', '11','Enabling the Hump Pot Bottom Function of Historical Data');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('45', 'ÀúÊ·Êý¾ÝµÄÊý¾ÝÏÔʾÁ£¶È', '5', '11','Data display granularity of historical data');" +
|
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('47', '·Åµçʱ³¤', '10', '12','');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('48', '×ó±ß¹æ¶¨Ê±¼äʱ³¤', '10', '12','');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('49', '×ó±ß¹æ¶¨Ê±¼ä´ÎÊý', '10', '12','');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('50', 'Óұ߹涨ʱ¼äʱ³¤', '1', '12','');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('51', 'Óұ߹涨ʱ¼ä´ÎÊý', '1', '12','');" +
| "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('52', '·ÅµçÓÅ»¯Ê±¼ä', '2', '13','');" +
| "";
| String[] strs = tb_page_param.split(";");
| for (int i = 0; i < strs.length; i++) {
| sqlstb_page_param.add(strs[i]);
| }
|
| Integer[] temp3= {1,2,3,4,5,6,7,8,2001,2002,2003,2004,2005,2006,2007,2008,2009,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,4001,4002,4003,4004,4005,4006,4007,4008,4009,4010,4011,4012,4013,5001,5002,5003,5004,5005,5006,5007,5008,6001,6002,6003,6004,7001,7002,7003,7004,7005,8001,8002,8003};
| idsDefault_tb_menu = Arrays.asList(temp3);
| sqlstb_tb_menu = new ArrayList<>();
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('1', 'Home', 'Ê×Ò³', 'home', '/home', 'el-icon-s-home', '0', '1', null, '1', '1', '0');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2', 'Online Monitoring', 'ÔÚÏß¼à²â', 'testData', '', 'el-icon-s-data', '0', '1', null, '1', '2', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3', 'Data Management', 'Êý¾Ý¹ÜÀí', 'dataMager', '', 'el-icon-s-help', '0', '1', null, '1', '3', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4', 'Alarm Management', '¸æ¾¯¹ÜÀí', 'alarmMager', '', 'el-icon-message-solid', '0', '1', null, '1', '4', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5', 'Report Statistics', '±¨±íͳ¼Æ', 'reportStatistics', '', 'el-icon-tickets', '0', '1', null, '1', '5', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6', 'Device Management', '×÷Òµ¹ÜÀí', 'jobManage', '', 'el-icon-s-cooperation', '0', '1', null, '1', '6', '6');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7', 'User Management', 'Óû§¹ÜÀí', 'userMager', '', 'el-icon-user-solid', '0', '1', null, '1', '7', '7');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('8', 'System Setting', 'ϵͳÉèÖÃ', 'systemPageSetting', '', 'el-icon-s-management', '0', '1', null, '1', '8', '8');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2001', 'Real-time Monitoring', 'ʵʱ¼à¿Ø', 'movingRingSystem', '/dataTest/movingRingSystem', null, '1', '1', null, '2', '1', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2002', 'Data Viewing', 'ÀúÊ·Êý¾Ý', 'history', '/dataTest/history', null, '1', '1', null, '2', '2', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2003', 'Data Management', 'ÀúÊ·Êý¾Ý¹ÜÀí', 'historyInfoMager', '/dataTest/historyInfoMager', null, '1', '1', null, '2', '3', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2004', 'Standard Curve', '±ê×¼ÇúÏß', 'standardLine', '/dataTest/standardLine', null, '1', '1', null, '2', '4', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2005', 'Device Status Search', 'É豸״̬²éѯ', 'btsStatus', '/dataTest/btsStatus', null, '1', '1', null, '2', '5', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2006', 'FGCD Tester Import Record', 'Ò»Ìå»úµ¼Èë¼Ç¼', 'historyAio', '/dataTest/historyAio', null, '1', '1', null, '2', '6', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2007', 'Comm Alarm Parameter Rule', 'ͨÐŵçÔ´¸æ¾¯¹æÔò', 'hfSwitch', '/dataTest/hfSwitch', null, '1', '1', null, '2', '7', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2008', 'Telemetering of AC Distribution Cabinet', '½»Á÷Åäµç¹ñÒ£²âÁ¿', 'GGDmeasure', '/dataTest/GGDmeasure', null, '1', '1', null, '2', '8', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('2009', 'Discharger Data Analysis', '·ÅµçÒǷŵçÊý¾Ý·ÖÎö', 'dischargeMeterData', '/dataTest/dischargeMeterData', null, '1', '1', null, '2', '9', '2');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3001', 'Power Supply Setting', 'µçÔ´ÐÅÏ¢ÅäÖÃ', 'powerMager', '/dataMager/powerMager', null, '1', '1', null, '2', '1', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3002', 'Battery Info Management', 'µç³ØÐÅÏ¢¹ÜÀí', 'battGroupMager', '/dataMager/battGroupMager', null, '1', '1', 'batttest_data_query_permit', '2', '2', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3003', 'Equipment Room Info Manaement', '»ú·¿ÐÅÏ¢¹ÜÀí', 'totalStation', '/dataMager/totalStation', null, '1', '1', 'batttest_data_query_permit', '2', '3', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3004', 'Battery Info Statistics Analysis', 'µç³ØÐÅϢͳ¼Æ·ÖÎö', 'produceTotal', '/dataMager/produceTotal', null, '1', '1', null, '2', '4', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3005', 'Background Thread Management', 'ºǫ́Ï̹߳ÜÀí', 'threadMager', '/dataMager/threadMager', null, '1', '1', 'batttest_data_query_permit', '2', '5', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3006', 'Equipment Room Status Search', '»ú·¿×´Ì¬²éѯ', 'powercut', '/dataMager/powercut', null, '1', '1', 'batttest_data_query_permit', '2', '6', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3007', 'Battery Management', 'µç³Ø¹Ø×¢¹ÜÀí', 'batteryMager', '/dataMager/batteryMager', null, '1', '1', 'batttest_data_query_permit', '2', '7', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3008', 'Device Working Status', 'É豸¹¤×÷״̬', 'deviceWorkState', '/dataMager/deviceWorkState', null, '1', '1', null, '2', '8', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3009', 'Dead Battery Management', '±¨·Ïµç³ØÐÅÏ¢¹ÜÀí', 'scrapBattery', '/dataMager/scrapBattery', null, '1', '1', null, '2', '9', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3010', 'Spare Battery Management', '±¸¼þµç³ØÐÅÏ¢¹ÜÀí', 'repairBattery', '/dataMager/repairBattery', null, '1', '1', null, '2', '10', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3011', 'Electricity Rate Distribution Template', 'µç¼Û·Ö²¼Ä£°å¹ÜÀí', 'elePriceDistributionTpl', '/dataMager/elePriceDistributionTpl', null, '1', '1', null, '2', '11', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3012', 'FGCD Equipment Room Import', 'Ò»Ìå»ú»ú·¿µ¼Èë', 'aioStationImport', '/dataMager/aioStationImport', null, '1', '1', null, '2', '12', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('3013', 'Carbon Neutral', '̼ÖкÍ', 'carbonInfo', '/dataMager/carbonInfo', null, '1', '1', null, '2', '13', '3');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4001', 'Power Supply Real-time Alarm', 'µçԴʵʱ¸æ¾¯', 'powerRealtimeInfo', '/alarmMager/powerRealtimeInfo', null, '1', '1', null, '2', '1', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4002', 'Power Supply History Alarm', 'µçÔ´ÀúÊ·¸æ¾¯', 'powerHistoryInfo', '/alarmMager/powerHistoryInfo', null, '1', '1', null, '2', '2', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4003', 'Battery Alarm Real-time Search', 'µç³Ø¸æ¾¯ÊµÊ±²éѯ', 'batteryrTimequery', '/alarmMager/batteryrTimequery', null, '1', '1', 'batt_alm_query_permit', '2', '3', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4004', 'Battery Alarm History Search', 'µç³Ø¸æ¾¯ÀúÊ·²éѯ', 'batteryrHistoryquery', '/alarmMager/batteryrHistoryquery', null, '1', '1', 'batt_alm_query_permit', '2', '4', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4005', 'Device Alarm Real-time Search', 'É豸¸æ¾¯ÊµÊ±²éѯ', 'deviceTimequery', '/alarmMager/deviceTimequery', null, '1', '1', 'dev_alm_query_permit', '2', '5', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4006', 'Device Alarm History Search', 'É豸¸æ¾¯ÀúÊ·²éѯ', 'deviceHistoryquery', '/alarmMager/deviceHistoryquery', null, '1', '1', 'dev_alm_query_permit', '2', '6', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4007', 'Comm Power Real-time Alarm', 'ͨÐŵçԴʵʱ¸æ¾¯', 'powerBoxAlarm', '/alarmMager/powerBoxAlarm', null, '1', '1', null, '2', '7', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4008', 'Comm Power History Alarm', 'ͨÐŵçÔ´ÀúÊ·¸æ¾¯', 'powerBoxHistoryAlarm', '/alarmMager/powerBoxHistoryAlarm', null, '1', '1', null, '2', '8', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4009', 'Comm Power Timeout Alarm', 'ͨÐŵçÔ´³¬Ê±¸æ¾¯', 'powerAlarmTimeout', '/alarmMager/powerAlarmTimeout', null, '1', '1', null, '2', '9', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4010', 'Comm Alarm Parameter Rule', 'ͨÐŵçÔ´¸æ¾¯¹æÔò', 'powerCabinetSetting', '/alarmMager/powerCabinetSetting', null, '1', '1', null, '2', '10', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4011', 'Battery Alarm Parameter Setting', 'µç³Ø¸æ¾¯²ÎÊýÉèÖÃ', 'devicepaSetting', '/alarmMager/devicepaSetting', null, '1', '1', 'batt_alm_param_query_permit', '2', '11', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4012', 'Alarm Assign Management', '¸æ¾¯Åɵ¥¹ÜÀí', 'alarmDispatch', '/alarmMager/alarmDispatch', null, '1', '1', null, '2', '12', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('4013', 'Alarm Preprocess Management', '¸æ¾¯Ô¤´¦Àí¹ÜÀí', 'alarmHandle', '/alarmMager/alarmHandle', null, '1', '1', 'batt_alm_param_query_permit', '2', '13', '4');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5001', 'Battery Group Statistics Search', 'µç³Ø×éͳ¼Æ·ÖÎö²éѯ', 'eleAnalyse', '/reportStatistics/eleAnalyse', null, '1', '1', null, '2', '1', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5002', 'Cell Statistics Search', 'µç³Øµ¥Ìåͳ¼Æ·ÖÎö²éѯ', 'eleMonomer', '/reportStatistics/eleMonomer', null, '1', '1', null, '2', '2', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5003', 'Battery Group Post-Evaluation', 'Ðîµç³Ø×éºóÆÀ¹À', 'eleAssess', '/reportStatistics/eleAssess', null, '1', '1', null, '2', '3', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5004', 'Lagging Cell Search', 'Âäºóµ¥Ìå²éѯ', 'taskplan', '/reportStatistics/taskplan', null, '1', '1', null, '2', '4', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5005', 'Battery Real-time Status Search', 'µç³Øʵʱ״̬²éѯ', 'elestatus', '/reportStatistics/elestatus', null, '1', '1', null, '2', '5', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5006', 'Battery Life History Search', 'µç³ØÐøº½ÄÜÁ¦ÀúÊ·²éѯ', 'endure', '/reportStatistics/endure', null, '1', '1', null, '2', '6', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5007', 'Comm Power Report', 'ͨÐŵçÔ´±¨±í', 'powerReport', '/reportStatistics/powerReport', null, '1', '1', null, '2', '7', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('5008', 'Event Summary Table', 'ʼþ×ܱí', 'eventTotalPage', '/reportStatistics/eventTotalPage', null, '1', '1', null, '2', '8', '5');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6001', 'BTS Equipment Upgrade', 'BTSÉ豸Éý¼¶', 'btsUpgrade', '/jobManage/btsUpgrade', null, '1', '1', null, '2', '1', '6');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6002', 'Discharge Plan Management', '·Åµç¼Æ»®¹ÜÀí', 'planManage', '/jobManage/planManage', null, '1', '1', null, '2', '2', '6');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6003', 'LD-9 Device Upgrade', '9¶ÈÉ豸Éý¼¶', 'nineDevUpdate', '/jobManage/nineDevUpdate', null, '1', '1', null, '2', '3', '6');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('6004', 'FGCD Tester Upgrade', 'Ò»Ìå»úÉ豸Éý¼¶', 'aioUpdate', '/jobManage/aioUpdate', null, '1', '1', null, '2', '4', '6');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7001', 'User Info Management', 'Óû§ÐÅÏ¢¹ÜÀí', 'userInfoMager', '/userMager/userInfo', null, '1', '1', 'usr_query_permit', '2', '1', '7');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7002', 'User Facial Recognition', 'Óû§ÈËÁ³¹ÜÀí', 'userFaceManager', '/userMager/userFaceManager', null, '1', '1', null, '2', '2', '7');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7003', 'Authority Management', 'ȨÏÞ¹ÜÀí', 'powerMager', '/userMager/powerMager', null, '1', '1', 'permit_query_permit', '2', '3', '7');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7004', 'Work Team Management', '°ü»ú×é¹ÜÀí', 'baojiMager', '/userMager/baojiMager', null, '1', '1', 'usr_query_permit', '2', '4', '7');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('7005', 'Operation Event Management', '²Ù×÷ʼþ¹ÜÀí', 'operationRecordMager', '/userMager/operationRecord', null, '1', '1', null, '2', '5', '7');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('8001', 'System Configuration', 'ϵͳÅäÖÃ', 'realTimeSetting', '/pageSetting/realTime', null, '1', '1', 'batt_test_op_permit', '2', '1', '8');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('8002', '3D Equipement Room Config.', '3D»ú·¿ÅäÖÃ', 'threeHomeSetting', '/pageSetting/threeHomeSetting', null, '1', '1', null, '2', '2', '8');");
| sqlstb_tb_menu.add("INSERT INTO " + Sql_Mysql.Menu_Table + "(id,lableEnUs,label,name,src,icon,closable,enableduse,permitName,level,ord,menuId) VALUES ('8003', 'Map Configuration', 'µØͼÅäÖÃ', 'chartMapSetting', '/pageSetting/chartMapSetting', null, '1', '1', null, '2', '3', '8');");
|
| }
|
|
| /************************************************************************************************/
| /**
| * ɽÎ÷µçÔ´²¿·ÖµçÔ´¸æ¾¯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_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¹ýѹ
| 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 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 ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID = 110137; //2·½»Á÷AÏà¹ýѹ
| public final static int ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID = 110138; //2·½»Á÷AÏàǷѹ
| public final static int ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID = 110139; //2·½»Á÷AÏàȱÏà
| public final static int ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID = 110140; //2·½»Á÷BÏà¹ýѹ
| public final static int ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID = 110141; //2·½»Á÷BÏàǷѹ
| public final static int ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID = 110142; //2·½»Á÷BÏàȱÏà
| public final static int ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID = 110143; //2·½»Á÷CÏà¹ýѹ
| public final static int ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID = 110144; //2·½»Á÷CÏàǷѹ
| public final static int ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID = 110145; //2·½»Á÷CÏàȱÏà
|
| public final static int ALM_TYPE_PWRDEV_ERROR_ID = 110146; //µçÔ´¸æ¾¯
| public final static int ALM_TYPE_ACDC_PowerDown_CommErr_ID = 110147; //½»Á÷Í£µçͨÐŹÊÕÏ
| /************************************************************************************************/
|
|
| 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 final static int ALM_TYPE_OnlineVol_ID = 119001; //ÔÚÏßµçѹ¸æ¾¯
| public final static int ALM_TYPE_GroupVol_ID = 119002; //×é¶Ëµçѹ¸æ¾¯
| public final static int ALM_TYPE_BattChargeCurr_ID = 119003; //³äµçµçÁ÷¸ß
| public final static int ALM_TYPE_BattDisChargeCurr_ID = 119004; //·ÅµçµçÁ÷¸æ¾¯
| public final static int ALM_TYPE_MonVol_ID = 119005; //µ¥Ìåµçѹ¸æ¾¯
| public final static int ALM_TYPE_MonTmp_ID = 119006; //µ¥Ìåζȸ澯
| public final static int ALM_TYPE_MonRes_ID = 119007; //µ¥ÌåÄÚ×è¸æ¾¯
| public final static int ALM_TYPE_ConnRes_ID = 119008; //Á¬½ÓÌõ×迹¸æ¾¯
| public final static int ALM_TYPE_DisChargeMonVol_ID = 119009; //·Åµçµ¥Ìåµçѹ¸æ¾¯
| public final static int ALM_TYPE_MONCAP_ALMALARM_ID = 119010; //ÈÝÁ¿¸æ¾¯¸æ¾¯
| public final static int ALM_TYPE_MONCAP_CHANGEALARM_ID = 119011; //ÈÝÁ¿¸ü»»¸æ¾¯
| public final static int ALM_TYPE_MONLYVOL_ID = 119012; //©Һµçѹ¸æ¾¯
| public final static int ALM_TYPE_MONREALCAP_ID = 119013; //µ¥ÌåÔ¤¹ÀÈÝÁ¿¸æ¾¯
|
|
|
| /******************************* É豸¸æ¾¯²ÎÊý *********************************************************************/
| public final static int ALM_TYPE_FBS9100_CommError_ID = 119020; //BTSͨÐŹÊÕÏ
| public final static int ALM_TYPE_BTS_ENDURANCE_ID = 119023; //BTSÐøº½¸æ¾¯
| public final static int ALM_TYPE_FBS9100_POWEROFF_ID = 119024; //»ú·¿Í£µç¸æ¾¯
| public final static int ALM_TYPE_FBS9100_FADIAN_ID = 119025; //»ú·¿·¢µç¸æ¾¯
| public final static int ALM_TYPE_FBS9100_DIAOZHAN_ID = 119026; //»ú·¿µôÕ¾¸æ¾¯
| public final static int ALM_TYPE_FBS9100_KAIMEN_ID = 119027; //»ú·¿¿ªÃŸ澯
| public final static int ALM_TYPE_FBS9100_TMPHIGHT_ID = 119028; //É豸¸ßθ澯
| public final static int ALM_TYPE_FBS9100_SDERROR_ID = 119032; //É豸SD¿¨¹ÊÕÏ
| public final static int ALM_TYPE_FBS9100_COLLECTERROR_ID = 119033; //²É¼¯Ï߸澯
| public final static int ALM_TYPE_FBS9100_CurrBalance_ID = 119034; //Í£µçµçÁ÷¾ùºâ¸æ¾¯
| public final static int ALM_TYPE_BTS61850_RELAY_Error_ID = 618501; //¼ÌµçÆ÷¸æ¾¯
| public final static int ALM_TYPE_BTS61850_CONNCET_Error_ID = 618502; //ͨѶ¸æ¾¯
| public final static int ALM_TYPE_BTS61850_HIGTMP_Error_ID = 618503; //É豸¹ýθ澯
| public final static int ALM_TYPE_BTS61850_DIODE_Error_ID = 618504; //¶þ¼«¹ÜD1¸æ¾¯
| public final static int ALM_TYPE_BTS61850_DRYCONTACT_Error_ID = 618505; //¸É½Óµã¸æ¾¯
| public final static int ALM_TYPE_BTS61850_TEST_ERROR_ID = 618506; //²âÊÔÒ쳣ֹͣ
| /****************************************************************************************************/
|
|
|
|
| // public static void main(String[] args) {
| // System.out.println("SqlsUtils.sqlstb_page_param2 = " + SqlsUtils.sqlstb_page_param2);
| // System.out.println("SqlsUtils.sqlstb_page_param = " + SqlsUtils.sqlstb_page_param);
| // for (int i = 0; i < SqlsUtils.sqlstb_page_param2.size(); i++) {
| // System.out.println("SqlsUtils.sqls.get(i) = " + SqlsUtils.sqlstb_page_param2.get(i));
| // }
| // System.out.println(SqlsUtils.idsDefault.size());
| // }
|
| }
|
|
