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,53,54,55,56};
|
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','');" +
|
|
"INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('53', 'ºËÈݷŵçʱ¼ä¹ýÂË', '2', '14','');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('54', 'ºËÈݳäµçʱ¼ä¹ýÂË', '2', '14','');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('55', '¼à²â·Åµçʱ¼ä¹ýÂË', '2', '14','');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('56', '¼à²â³äµçʱ¼ä¹ýÂË', '2', '14','');" +
|
"";
|
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<>();
|
|
}
|
|
|
/************************************************************************************************/
|
/**
|
* ɽÎ÷µçÔ´²¿·ÖµçÔ´¸æ¾¯id
|
*/
|
public final static int ALM_TYPE_ACDC_AcIn1_A_OverV_ID = 110001; //1·½»Á÷AÏà¹ýѹ¸æ¾¯
|
public final static int ALM_TYPE_ACDC_AcIn1_A_UnderV_ID = 110002; //1·½»Á÷AÏàǷѹ¸æ¾¯
|
public final static int ALM_TYPE_ACDC_AcIn1_A_Less_ID = 110003; //1·½»Á÷AÏàȱÏà¸æ¾¯
|
public final static int ALM_TYPE_ACDC_AcIn1_B_OverV_ID = 110004; //1·½»Á÷BÏà¹ýѹ¸æ¾¯
|
public final static int ALM_TYPE_ACDC_AcIn1_B_UnderV_ID = 110005; //1·½»Á÷BÏàǷѹ¸æ¾¯
|
public final static int ALM_TYPE_ACDC_AcIn1_B_Less_ID = 110006; //1·½»Á÷BÏàȱÏà¸æ¾¯
|
public final static int ALM_TYPE_ACDC_AcIn1_C_OverV_ID = 110007; //1·½»Á÷CÏà¹ýѹ¸æ¾¯
|
public final static int ALM_TYPE_ACDC_AcIn1_C_UnderV_ID = 110008; //1·½»Á÷CÏàǷѹ¸æ¾¯
|
public final static int ALM_TYPE_ACDC_AcIn1_C_Less_ID = 110009; //1·½»Á÷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());
|
// }
|
|
}
|
