package com.database_util;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.Date;
|
|
import com.base.Com;
|
import com.sql.MysqlConnPool;
|
import com.sql.Sql_Mysql;
|
|
public class DB_Param {
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
System.out.println(" db_param init start at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
createDB_PARAM(pool);
|
|
createDev_Param_Table(pool, recreate);
|
|
createApp_Param_Table(pool, recreate);
|
|
createAlarm_Param_Table(pool, recreate);
|
|
createDev_AlmParam_Table(pool, recreate); //´´½¨É豸¸æ¾¯²ÎÊý±í
|
|
createAppAlm_Param_Table(pool, recreate); //´´½¨É豸¸æ¾¯²ÎÊý±í
|
|
System.out.println(" db_param init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
}
|
|
/**
|
* ´´½¨ db_param Êý¾Ý¿â
|
* @param pool
|
*/
|
public static void createDB_PARAM(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_PARAM);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_dev_param ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createDev_Param_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dev_Param_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dev_Param_Table + " (" +
|
" num int(11) NOT NULL AUTO_INCREMENT," +
|
" dev_Id int(11) NOT NULL DEFAULT '91000000'," +
|
" alm_id int(11) NOT NULL DEFAULT '119001'," +
|
" alm_name varchar(64) NOT NULL DEFAULT 'Batt_Alarm_Type_'," +
|
" alm_high_coe float NOT NULL DEFAULT '0.9'," +
|
" alm_low_coe float NOT NULL DEFAULT '0.5'," +
|
" alm_high_level int(11) NOT NULL DEFAULT '4'," +
|
" alm_low_level int(11) NOT NULL DEFAULT '1'," +
|
" alm_high_en int(11) NOT NULL DEFAULT '0'," +
|
" alm_low_en int(11) NOT NULL DEFAULT '0'," +
|
" note varchar(64) NOT NULL DEFAULT ''," +
|
" `alm_high_coe_upper` float NOT NULL DEFAULT '3.2' COMMENT 'ÉÏÉÏÏ޸澯ϵÊýÖµ'," +
|
" `alm_high_coe_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]'," +
|
" `alm_low_coe_lower` float NOT NULL DEFAULT '0' COMMENT 'ÏÂÏÂÏ޸澯ϵÊýÖµ'," +
|
" `alm_low_coe_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏÞãÐֵʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]'," +
|
" `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '¸æ¾¯ÑÓ³Ùʱ³¤[µ¥Î»£ºÃë]'," +
|
" `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏ޸澯µÈ¼¶'," +
|
" `alm_low_level_lower` int(11) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏ޸澯µÈ¼¶'," +
|
" PRIMARY KEY (num)," +
|
" KEY index_alm_id (alm_id)," +
|
" KEY index_dev_id (dev_Id)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
|
//Ìí¼Óalm_high_coe_upper
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_param'"
|
+ " AND table_name='tb_dev_param'"
|
+ " AND column_name='alm_high_coe_upper'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table
|
+ " ADD COLUMN `alm_high_coe_upper` float NOT NULL DEFAULT '3.2' COMMENT 'ÉÏÉÏÏ޸澯ϵÊýÖµ';");
|
}
|
res = null;
|
//Ìí¼Óalm_high_coe_upper_en
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_param'"
|
+ " AND table_name='tb_dev_param'"
|
+ " AND column_name='alm_high_coe_upper_en'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table
|
+ " ADD COLUMN `alm_high_coe_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]';");
|
}
|
res = null;
|
//Ìí¼Óalm_low_coe_lower
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_param'"
|
+ " AND table_name='tb_dev_param'"
|
+ " AND column_name='alm_low_coe_lower'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table
|
+ " ADD COLUMN `alm_low_coe_lower` float NOT NULL DEFAULT '0' COMMENT 'ÏÂÏÂÏ޸澯ϵÊýÖµ';");
|
}
|
res = null;
|
//Ìí¼Óalm_low_coe_lower_en
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_param'"
|
+ " AND table_name='tb_dev_param'"
|
+ " AND column_name='alm_low_coe_lower_en'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table
|
+ " ADD COLUMN `alm_low_coe_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏÞãÐֵʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]';");
|
}
|
res = null;
|
//Ìí¼Óalm_delay_time
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_param'"
|
+ " AND table_name='tb_dev_param'"
|
+ " AND column_name='alm_delay_time'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table
|
+ " ADD COLUMN `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '¸æ¾¯ÑÓ³Ùʱ³¤[µ¥Î»£ºÃë]';");
|
}
|
res = null;
|
//Ìí¼Óalm_high_level_upper
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_param'"
|
+ " AND table_name='tb_dev_param'"
|
+ " AND column_name='alm_high_level_upper'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table
|
+ " ADD COLUMN `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏ޸澯µÈ¼¶';");
|
}
|
res = null;
|
//Ìí¼Óalm_low_level_lower
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_param'"
|
+ " AND table_name='tb_dev_param'"
|
+ " AND column_name='alm_low_level_lower'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table
|
+ " ADD COLUMN `alm_low_level_lower` int(11) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏ޸澯µÈ¼¶';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_app_param ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createApp_Param_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.App_Param_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.App_Param_Table + " (" +
|
" num int(11) NOT NULL AUTO_INCREMENT," +
|
" param_name varchar(50) DEFAULT NULL," +
|
" param_value varchar(50) DEFAULT NULL," +
|
" param_caption varchar(200) DEFAULT NULL," +
|
" PRIMARY KEY (num)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ÅжÏÊÇ·ñ´æÔÚµ±Ç°¸æ¾¯²ÎÊýµÄ¼Ç¼
|
* @param alm_id
|
* @param pool
|
* @return
|
*/
|
public static boolean checkAppAlarmParamExists(int alm_id,MysqlConnPool pool) {
|
String sql_str = " SELECT * FROM " + Sql_Mysql.AppAlm_Param_Table + " WHERE alm_id = " + alm_id;
|
ResultSet res = null;
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
res = sql.sqlMysqlQuery(sql_str);
|
if(res.next()) {
|
return true;
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
return false;
|
}
|
|
/**
|
* ´´½¨ tb_appalm_param ƽ̨¸æ¾¯²ÎÊýÅäÖñí
|
* @param pool
|
* @param recreate
|
*/
|
public static void createAppAlm_Param_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.AppAlm_Param_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.AppAlm_Param_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" `alm_id` int(11) NOT NULL DEFAULT '119001' COMMENT '¸æ¾¯id'," +
|
" `alm_name` varchar(255) NOT NULL DEFAULT '' COMMENT '¸æ¾¯Ãû³Æ'," +
|
" `alm_category` int(11) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯Àà±ð[1-µç³Ø¸æ¾¯£»2-É豸¸æ¾¯£»3-µçÔ´¸æ¾¯]'," +
|
" `alm_auto_clear_en` int(11) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯×Ô¶¯ÏûʧʹÄÜ[ƽ̨¸æ¾¯ÊÇ·ñÔÊÐíÏûʧʹÄÜ]0-²»ÔÊÐí 1-ÔÊÐí'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ƽ̨¸æ¾¯²ÎÊýÅäÖñí';";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
String sql_str = " INSERT INTO db_param.tb_appalm_param(alm_id,alm_name,alm_category) VALUES ";
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
int alm_category = 1;
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_OnlineVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_OnlineVol_ID + ",'ÔÚÏßµçѹ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_GroupVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_GroupVol_ID + ",'×é¶Ëµçѹ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BattChargeCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BattChargeCurr_ID + ",'³äµçµçÁ÷¸ß¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BattDisChargeCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BattDisChargeCurr_ID + ",'·ÅµçµçÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MonVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MonVol_ID + ",'µ¥Ìåµçѹ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MonTmp_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MonTmp_ID + ",'µ¥Ìåζȸ澯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MonRes_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MonRes_ID + ",'µ¥ÌåÄÚ×è¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ConnRes_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ConnRes_ID + ",'Á¬½ÓÌõ×迹¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_DisChargeMonVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_DisChargeMonVol_ID + ",'·Åµçµ¥Ìåµçѹ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MONCAP_ALMALARM_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MONCAP_ALMALARM_ID + ",'ÈÝÁ¿¸æ¾¯¸æ¾¯'," + alm_category +");");
|
}
|
// if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MONCAP_CHANGEALARM_ID, pool)) {
|
// sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MONCAP_CHANGEALARM_ID + ",'ÈÝÁ¿¸ü»»¸æ¾¯'," + alm_category +");");
|
// }
|
// if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MONLYVOL_ID, pool)) {
|
// sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MONLYVOL_ID + ",'©Һµçѹ¸æ¾¯'," + alm_category +");");
|
// }
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_MONREALCAP_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_MONREALCAP_ID + ",'µ¥ÌåÔ¤¹ÀÈÝÁ¿¸æ¾¯'," + alm_category +");");
|
}
|
|
try {
|
Thread.sleep(50);
|
} catch (InterruptedException e) {
|
e.printStackTrace();
|
}
|
/******************************* É豸¸æ¾¯²ÎÊý *********************************************************************/
|
alm_category = 2;
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_CommError_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_CommError_ID + ",'BTSͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS_ENDURANCE_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS_ENDURANCE_ID + ",'BTSÐøº½¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_POWEROFF_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_POWEROFF_ID + ",'»ú·¿Í£µç¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_FADIAN_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_FADIAN_ID + ",'»ú·¿·¢µç¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_DIAOZHAN_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_DIAOZHAN_ID + ",'»ú·¿µôÕ¾¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_KAIMEN_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_KAIMEN_ID + ",'»ú·¿¿ªÃŸ澯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_TMPHIGHT_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_TMPHIGHT_ID + ",'É豸¸ßθ澯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_SDERROR_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_SDERROR_ID + ",'É豸SD¿¨¹ÊÕÏ'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_COLLECTERROR_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_COLLECTERROR_ID + ",'²É¼¯Ï߸澯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_FBS9100_CurrBalance_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_FBS9100_CurrBalance_ID + ",'Í£µçµçÁ÷¾ùºâ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_RELAY_Error_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_RELAY_Error_ID + ",'¼ÌµçÆ÷¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_CONNCET_Error_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_CONNCET_Error_ID + ",'ͨѶ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_HIGTMP_Error_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_HIGTMP_Error_ID + ",'É豸¹ýθ澯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_DIODE_Error_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_DIODE_Error_ID + ",'¶þ¼«¹ÜD1¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_DRYCONTACT_Error_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_DRYCONTACT_Error_ID + ",'¸É½Óµã¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_BTS61850_TEST_ERROR_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_BTS61850_TEST_ERROR_ID + ",'²âÊÔÒ쳣ֹͣ'," + alm_category +");");
|
}
|
|
try {
|
Thread.sleep(50);
|
} catch (InterruptedException e) {
|
e.printStackTrace();
|
}
|
/******************************* µçÔ´¸æ¾¯²ÎÊý *********************************************************************/
|
alm_category = 3;
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID + ",'1·½»Á÷AÏà¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID + ",'1·½»Á÷AÏàǷѹ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID + ",'1·½»Á÷AÏàȱÏà¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID + ",'1·½»Á÷BÏà¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID + ",'1·½»Á÷BÏàǷѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID + ",'1·½»Á÷BÏàȱÏà¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID + ",'1·½»Á÷CÏà¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID + ",'1·½»Á÷CÏàǷѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID + ",'1·½»Á÷CÏàȱÏà¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID + ",'½»Á÷Í£µç¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID + ",'·ÀÀ×Æ÷¹ÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_DCout_OverV_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_DCout_OverV_ID + ",'Ö±Á÷µçѹ¹ý¸ß¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_DCout_UnderV_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_DCout_UnderV_ID + ",'Ö±Á÷µçѹ¹ýµÍ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_LoaderFuse_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_LoaderFuse_ID + ",'¸ºÔØÈ۶ϸ澯'," + alm_category +");");
|
}
|
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_BattGrp1Fuse_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_BattGrp1Fuse_ID + ",'µç³Ø×é1È۶ϸ澯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_BattGrp2Fuse_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_BattGrp2Fuse_ID + ",'µç³Ø×é2È۶ϸ澯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module1Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module1Err_ID + ",'ÕûÁ÷Æ÷1×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module2Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module2Err_ID + ",'ÕûÁ÷Æ÷2×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module3Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module3Err_ID + ",'ÕûÁ÷Æ÷3×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module4Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module4Err_ID + ",'ÕûÁ÷Æ÷4×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module5Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module5Err_ID + ",'ÕûÁ÷Æ÷5×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module6Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module6Err_ID + ",'ÕûÁ÷Æ÷6×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module7Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module7Err_ID + ",'ÕûÁ÷Æ÷7×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module8Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module8Err_ID + ",'ÕûÁ÷Æ÷8×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module9Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module9Err_ID + ",'ÕûÁ÷Æ÷9×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module10Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module10Err_ID + ",'ÕûÁ÷Æ÷10×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module11Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module11Err_ID + ",'ÕûÁ÷Æ÷11×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module12Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module12Err_ID + ",'ÕûÁ÷Æ÷12×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module13Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module13Err_ID + ",'ÕûÁ÷Æ÷13×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module14Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module14Err_ID + ",'ÕûÁ÷Æ÷14×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module15Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module15Err_ID + ",'ÕûÁ÷Æ÷15×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Module16Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Module16Err_ID + ",'ÕûÁ÷Æ÷16×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcAlarm_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcAlarm_ID + ",'½»Á÷×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_DcAlarm_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_DcAlarm_ID + ",'Ö±Á÷×ܹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID + ",'½»Á÷AÏà¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID + ",'½»Á÷BÏà¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID + ",'½»Á÷CÏà¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_MonitorErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_MonitorErr_ID + ",'¼à¿ØÆ÷¹ÊÕϸ澯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_DcOut_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_DcOut_OverCurr_ID + ",'Ö±Á÷¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_TolalAlarm_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_TolalAlarm_ID + ",'¿ª¹Ø¹ñ×ܱ¨¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt1_VolLow_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt1_VolLow_ID + ",'µç³Ø×é1µçѹµÍ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt2_VolLow_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt2_VolLow_ID + ",'µç³Ø×é2µçѹµÍ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt1_Down_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt1_Down_ID + ",'µç³Ø×é1ϵç¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt2_Down_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt2_Down_ID + ",'µç³Ø×é2ϵç¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt1_OverChgCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt1_OverChgCurr_ID + ",'µç³Ø×é1³äµç¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Batt2_OverChgCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Batt2_OverChgCurr_ID + ",'µç³Ø×é2³äµç¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod1_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod1_OverVol_ID + ",'ÕûÁ÷Æ÷1¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod2_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod2_OverVol_ID + ",'ÕûÁ÷Æ÷2¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod3_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod3_OverVol_ID + ",'ÕûÁ÷Æ÷3¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod4_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod4_OverVol_ID + ",'ÕûÁ÷Æ÷4¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod5_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod5_OverVol_ID + ",'ÕûÁ÷Æ÷5¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod6_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod6_OverVol_ID + ",'ÕûÁ÷Æ÷6¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod7_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod7_OverVol_ID + ",'ÕûÁ÷Æ÷7¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod8_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod8_OverVol_ID + ",'ÕûÁ÷Æ÷8¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod9_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod9_OverVol_ID + ",'ÕûÁ÷Æ÷9¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod10_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod10_OverVol_ID + ",'ÕûÁ÷Æ÷10¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod11_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod11_OverVol_ID + ",'ÕûÁ÷Æ÷11¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod12_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod12_OverVol_ID + ",'ÕûÁ÷Æ÷12¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod13_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod13_OverVol_ID + ",'ÕûÁ÷Æ÷13¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod14_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod14_OverVol_ID + ",'ÕûÁ÷Æ÷14¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod15_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod15_OverVol_ID + ",'ÕûÁ÷Æ÷15¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod16_OverVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod16_OverVol_ID + ",'ÕûÁ÷Æ÷16¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod1_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod1_UnderVol_ID + ",'ÕûÁ÷Æ÷1Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod2_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod2_UnderVol_ID + ",'ÕûÁ÷Æ÷2Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod3_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod3_UnderVol_ID + ",'ÕûÁ÷Æ÷3Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod4_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod4_UnderVol_ID + ",'ÕûÁ÷Æ÷4Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod5_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod5_UnderVol_ID + ",'ÕûÁ÷Æ÷5Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod6_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod6_UnderVol_ID + ",'ÕûÁ÷Æ÷6Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod7_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod7_UnderVol_ID + ",'ÕûÁ÷Æ÷7Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod8_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod8_UnderVol_ID + ",'ÕûÁ÷Æ÷8Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod9_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod9_UnderVol_ID + ",'ÕûÁ÷Æ÷9Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod10_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod10_UnderVol_ID + ",'ÕûÁ÷Æ÷10Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod11_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod11_UnderVol_ID + ",'ÕûÁ÷Æ÷11Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod12_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod12_UnderVol_ID + ",'ÕûÁ÷Æ÷12Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod13_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod13_UnderVol_ID + ",'ÕûÁ÷Æ÷13Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod14_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod14_UnderVol_ID + ",'ÕûÁ÷Æ÷14Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod15_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod15_UnderVol_ID + ",'ÕûÁ÷Æ÷15Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod16_UnderVol_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod16_UnderVol_ID + ",'ÕûÁ÷Æ÷16Ƿѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod1_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod1_OverCurr_ID + ",'ÕûÁ÷Æ÷1¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod2_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod2_OverCurr_ID + ",'ÕûÁ÷Æ÷2¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod3_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod3_OverCurr_ID + ",'ÕûÁ÷Æ÷3¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod4_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod4_OverCurr_ID + ",'ÕûÁ÷Æ÷4¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod5_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod5_OverCurr_ID + ",'ÕûÁ÷Æ÷5¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod6_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod6_OverCurr_ID + ",'ÕûÁ÷Æ÷6¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod7_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod7_OverCurr_ID + ",'ÕûÁ÷Æ÷7¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod8_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod8_OverCurr_ID + ",'ÕûÁ÷Æ÷8¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod9_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod9_OverCurr_ID + ",'ÕûÁ÷Æ÷9¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod10_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod10_OverCurr_ID + ",'ÕûÁ÷Æ÷10¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod11_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod11_OverCurr_ID + ",'ÕûÁ÷Æ÷11¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod12_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod12_OverCurr_ID + ",'ÕûÁ÷Æ÷12¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod13_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod13_OverCurr_ID + ",'ÕûÁ÷Æ÷13¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod14_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod14_OverCurr_ID + ",'ÕûÁ÷Æ÷14¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID + ",'ÕûÁ÷Æ÷15¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID + ",'ÕûÁ÷Æ÷16¹ýÁ÷¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod1_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod1_AC_Err_ID + ",'ÕûÁ÷Æ÷1½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod2_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod2_AC_Err_ID + ",'ÕûÁ÷Æ÷2½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod3_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod3_AC_Err_ID + ",'ÕûÁ÷Æ÷3½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod4_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod4_AC_Err_ID + ",'ÕûÁ÷Æ÷4½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod5_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod5_AC_Err_ID + ",'ÕûÁ÷Æ÷5½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod6_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod6_AC_Err_ID + ",'ÕûÁ÷Æ÷6½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod7_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod7_AC_Err_ID + ",'ÕûÁ÷Æ÷7½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod8_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod8_AC_Err_ID + ",'ÕûÁ÷Æ÷8½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod9_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod9_AC_Err_ID + ",'ÕûÁ÷Æ÷9½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod10_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod10_AC_Err_ID + ",'ÕûÁ÷Æ÷10½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod11_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod11_AC_Err_ID + ",'ÕûÁ÷Æ÷11½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod12_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod12_AC_Err_ID + ",'ÕûÁ÷Æ÷12½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod13_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod13_AC_Err_ID + ",'ÕûÁ÷Æ÷13½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod14_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod14_AC_Err_ID + ",'ÕûÁ÷Æ÷14½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod15_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod15_AC_Err_ID + ",'ÕûÁ÷Æ÷15½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_Mod16_AC_Err_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_Mod16_AC_Err_ID + ",'ÕûÁ÷Æ÷16½»Á÷Òì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_Trip_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_Trip_ID + ",'½»Á÷ÊäÈë1ÌøÕ¢¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn2_Trip_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn2_Trip_ID + ",'½»Á÷ÊäÈë2ÌøÕ¢¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_Fuse_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_Fuse_ID + ",'½»Á÷ÊäÈë1ÈÛË¿¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn2_Fuse_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn2_Fuse_ID + ",'½»Á÷ÊäÈë2ÈÛË¿¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_Unbalance_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_Unbalance_ID + ",'½»Á÷ÊäÈë1ÈýÏ಻ƽºâ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn2_Unbalance_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn2_Unbalance_ID + ",'½»Á÷ÊäÈë2ÈýÏ಻ƽºâ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_FreqErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_FreqErr_ID + ",'½»Á÷ÊäÈë1ƵÂÊÒì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn2_FreqErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn2_FreqErr_ID + ",'½»Á÷ÊäÈë2ƵÂÊÒì³£¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_CPSS_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_CPSS_CommErr_ID + ",'ÐתͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_PWRDEV_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_PWRDEV_CommErr_ID + ",'µçԴͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_User_AcIn1_PowerDown_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_User_AcIn1_PowerDown_ID + ",'½»Á÷ÊäÈë1Í£µç¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_User_AcIn2_PowerDown_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_User_AcIn2_PowerDown_ID + ",'½»Á÷ÊäÈë2Í£µç¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_User_AcIn1_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_User_AcIn1_CommErr_ID + ",'½»Á÷1²É¼¯Í¨ÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_User_AcIn2_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_User_AcIn2_CommErr_ID + ",'½»Á÷2²É¼¯Í¨ÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Temp1_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Temp1_CommErr_ID + ",'θÐ1ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Temp2_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Temp2_CommErr_ID + ",'θÐ2ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Temp3_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Temp3_CommErr_ID + ",'θÐ3ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Humi1_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Humi1_CommErr_ID + ",'ʪ¸Ð1ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Humi2_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Humi2_CommErr_ID + ",'ʪ¸Ð2ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Humi3_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Humi3_CommErr_ID + ",'ʪ¸Ð3ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke1_Occur_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke1_Occur_ID + ",'Ñ̸Ð1±¨¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke2_Occur_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke2_Occur_ID + ",'Ñ̸Ð2±¨¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke3_Occur_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke3_Occur_ID + ",'Ñ̸Ð3±¨¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke1_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke1_CommErr_ID + ",'Ñ̸Ð1ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke2_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke2_CommErr_ID + ",'Ñ̸Ð2ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_Envm_Smoke3_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_Envm_Smoke3_CommErr_ID + ",'Ñ̸Ð3ͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID + ",'2·½»Á÷AÏà¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID + ",'2·½»Á÷AÏàǷѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID + ",'2·½»Á÷AÏàȱÏà¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID + ",'2·½»Á÷BÏà¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID + ",'2·½»Á÷BÏàǷѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID + ",'2·½»Á÷BÏàȱÏà¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID + ",'2·½»Á÷CÏà¹ýѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID + ",'2·½»Á÷CÏàǷѹ¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID + ",'2·½»Á÷CÏàȱÏà¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_PWRDEV_ERROR_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_PWRDEV_ERROR_ID + ",'µçÔ´¸æ¾¯'," + alm_category +");");
|
}
|
|
if(!checkAppAlarmParamExists(SqlsUtils.ALM_TYPE_ACDC_PowerDown_CommErr_ID, pool)) {
|
sql.sqlMysqlExecute(sql_str + "(" + SqlsUtils.ALM_TYPE_ACDC_PowerDown_CommErr_ID + ",'½»Á÷Í£µçͨÐŹÊÕÏ'," + alm_category +");");
|
}
|
|
/****************************************************************************************************/
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
|
|
/**
|
* ´´½¨ tb_dev_almparam ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createDev_AlmParam_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dev_AlmParam_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dev_AlmParam_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `alm_id` int(11) NOT NULL DEFAULT '119020' COMMENT '¸æ¾¯id'," +
|
" `alm_name` varchar(255) NOT NULL COMMENT '¸æ¾¯Ãû³Æ'," +
|
" `alm_type` int(11) NOT NULL DEFAULT '0' COMMENT 'µ±Ç°¸æ¾¯´¥·¢ÀàÐÍ£»0-booleanÀàÐÍ 1-ãÐÖµÀàÐÍ'," +
|
" `alm_limit_value` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ãÐÖµ'," +
|
" `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '¸æ¾¯µÈ¼¶'," +
|
" `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '¸æ¾¯ÑÓ³Ù´¥·¢Ê±³¤[µ¥Î»£ºÃë]'," +
|
" `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'," +
|
" `alm_en` int(11) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯Ê¹ÄÜ£º0-²»´¥·¢ 1-´¥·¢'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='É豸¸æ¾¯²ÎÊý±í';";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
//BTSͨÐŹÊÕÏ =========119020
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_CommError_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_OnlineVol_ID+",'ͨÐŹÊÕϳ¬Ê±³¤[Ãë]',1,180,1,60,1,1)");
|
}
|
//BTSÐøº½¸æ¾¯=========119023
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BTS_ENDURANCE_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_BTS_ENDURANCE_ID+",'Ðøº½²»×ã¸æ¾¯',0,0,2,60,0,0)");
|
}
|
//»ú·¿Í£µç¸æ¾¯=========119024
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_POWEROFF_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_FBS9100_POWEROFF_ID+",'»ú·¿Í£µç¸æ¾¯',0,0,2,60,0,0)");
|
}
|
//»ú·¿·¢µç¸æ¾¯=========119025
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_FADIAN_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_FBS9100_FADIAN_ID+",'»ú·¿·¢µç¸æ¾¯',0,0,2,60,0,0)");
|
}
|
//»ú·¿µôÕ¾¸æ¾¯=========119026
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_DIAOZHAN_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_FBS9100_DIAOZHAN_ID+",'»ú·¿µôÕ¾¸æ¾¯',0,0,2,60,0,0)");
|
}
|
//»ú·¿¿ªÃŸ澯=========119027
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_KAIMEN_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_FBS9100_KAIMEN_ID+",'»ú·¿¿ªÃŸ澯',0,0,2,60,0,0)");
|
}
|
//É豸¸ßθ澯=========119028
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_TMPHIGHT_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_FBS9100_TMPHIGHT_ID+",'É豸¸ßθ澯',1,50,2,60,0,1)");
|
}
|
//É豸SD¿¨¹ÊÕÏ=========119032
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_SDERROR_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_FBS9100_SDERROR_ID+",'É豸SD¿¨¹ÊÕÏ',0,0,2,60,0,0)");
|
}
|
//²É¼¯Ï߸澯=========119033
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_COLLECTERROR_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_FBS9100_COLLECTERROR_ID+",'²É¼¯Ï߸澯',1,1.5,4,60,0,1)");
|
}
|
//Í£µçµçÁ÷¾ùºâ¸æ¾¯=========119034
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_FBS9100_CurrBalance_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_FBS9100_CurrBalance_ID+",'Í£µçµçÁ÷¾ùºâ¸æ¾¯',0,0,2,60,0,1)");
|
}
|
//¼ÌµçÆ÷¸æ¾¯=========618501
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BTS61850_RELAY_Error_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_BTS61850_RELAY_Error_ID+",'¼ÌµçÆ÷¸æ¾¯',0,0,2,60,0,1)");
|
}
|
//ͨѶ¸æ¾¯=========618502
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BTS61850_CONNCET_Error_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_BTS61850_CONNCET_Error_ID+",'ͨѶ¹ÊÕÏ',0,0,2,60,0,1)");
|
}
|
//É豸¹ýθ澯=========618503
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BTS61850_HIGTMP_Error_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_BTS61850_HIGTMP_Error_ID+",'É豸¹ýθ澯',0,0,2,60,0,1)");
|
}
|
//¶þ¼«¹ÜD1¸æ¾¯=========618504
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BTS61850_DIODE_Error_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_BTS61850_DIODE_Error_ID+",'¶þ¼«¹ÜD1¸æ¾¯',0,0,2,60,0,1)");
|
}
|
//¸É½Óµã¸æ¾¯=========618505
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BTS61850_DRYCONTACT_Error_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_BTS61850_DRYCONTACT_Error_ID+",'¸É½Óµã¸æ¾¯',0,0,2,60,0,1)");
|
}
|
//²âÊÔÒ쳣ֹͣ=========618506
|
if(!checkDevAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BTS61850_TEST_ERROR_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Dev_AlmParam_Table + "(alm_id,alm_name,alm_type,alm_limit_value,alm_level,alm_delay_time,alm_severity,alm_en) VALUES("+SqlsUtils.ALM_TYPE_BTS61850_TEST_ERROR_ID+",'²âÊÔÒ쳣ֹͣ',0,0,2,60,0,1)");
|
}
|
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_alarm_param ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createAlarm_Param_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Alarm_Param_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Alarm_Param_Table + " (" +
|
" num int(11) NOT NULL AUTO_INCREMENT," +
|
" alm_id int(11) NOT NULL DEFAULT '0'," +
|
" alm_name varchar(50) NOT NULL DEFAULT ' '," +
|
" alm_high_coe float NOT NULL DEFAULT '0'," +
|
" alm_low_coe float NOT NULL DEFAULT '0'," +
|
" alm_high_level int(11) NOT NULL DEFAULT '0'," +
|
" alm_low_level int(11) NOT NULL DEFAULT '0'," +
|
" alm_high_en tinyint(1) NOT NULL DEFAULT '0'," +
|
" alm_low_en tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
//ÔÚÏßµçѹ¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_OnlineVol_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_OnlineVol_ID+",'Batt_Alarm_Type_OnlineVol',1.2,0.8,2,2,1,0)");
|
}
|
|
//×é¶Ëµçѹ¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_GroupVol_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_GroupVol_ID+",'Batt_Alarm_Type_GroupVol',1.2,0.8,2,2,1,1)");
|
}
|
//³äµçµçÁ÷¸ß
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BattChargeCurr_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_BattChargeCurr_ID+",'Batt_Alarm_Type_BattChargeCurr',3,0,3,3,1,0)");
|
}
|
//·ÅµçµçÁ÷¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_BattDisChargeCurr_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_BattDisChargeCurr_ID+",'Batt_Alarm_Type_BattDisChargeCurr',3,0,3,3,1,0)");
|
}
|
//µ¥Ìåµçѹ¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MonVol_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MonVol_ID+",'Batt_Alarm_Type_MonVol',1.2,0.8,2,2,1,1)");
|
}
|
//µ¥Ìåζȸ澯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MonTmp_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MonTmp_ID+",'Batt_Alarm_Type_MonTmp',1.5,0.5,2,2,1,1)");
|
}
|
//µ¥ÌåÄÚ×è¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MonRes_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MonRes_ID+",'Batt_Alarm_Type_MonRes',2,0.5,2,2,1,1)");
|
}
|
//Á¬½ÓÌõ×迹¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_ConnRes_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_ConnRes_ID+",'Batt_Alarm_Type_ConnRes',2,0.5,2,3,0,0)");
|
}
|
//·Åµçµ¥Ìåµçѹ¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_DisChargeMonVol_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_DisChargeMonVol_ID+",'Batt_Alarm_Type_DisChargeMonVol',1.2,0.8,2,2,0,0)");
|
}
|
//ÈÝÁ¿¸æ¾¯¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MONCAP_ALMALARM_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MONCAP_ALMALARM_ID+",'Batt_Alarm_Type_CapAlarm',3,0.8,3,2,0,1)");
|
}
|
//ÈÝÁ¿¸ü»»¸æ¾¯
|
if(!checkAlarmParamExists(pool, SqlsUtils.ALM_TYPE_MONCAP_CHANGEALARM_ID)) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Alarm_Param_Table + "(alm_id,alm_name,alm_high_coe,alm_low_coe,alm_high_level,alm_low_level,alm_high_en,alm_low_en) VALUES("+SqlsUtils.ALM_TYPE_MONCAP_CHANGEALARM_ID+",'Batt_Alarm_Type_CapChange',2,0.6,2,2,0,1)");
|
}
|
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ¼ì²édb_param.tb_alarm_param ±íÖÐalm¼Ç¼ÊÇ·ñ´æÔÚ
|
* @param pool
|
* @param alm_id
|
* @return
|
*/
|
public static boolean checkAlarmParamExists(MysqlConnPool pool,int alm_id) {
|
boolean isExists = false;
|
String sql_str = "SELECT * FROM " + Sql_Mysql.Alarm_Param_Table + " WHERE alm_id = " + alm_id;
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
|
try {
|
res = sql.sqlMysqlQuery(sql_str);
|
if(res.next()) {
|
isExists = true;
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
return isExists;
|
}
|
|
|
/**
|
* ¼ì²édb_param.tb_dev_almparam ±íÖÐalm¼Ç¼ÊÇ·ñ´æÔÚ
|
* @param pool
|
* @param alm_id
|
* @return
|
*/
|
public static boolean checkDevAlarmParamExists(MysqlConnPool pool,int alm_id) {
|
boolean isExists = false;
|
String sql_str = "SELECT * FROM " + Sql_Mysql.Dev_AlmParam_Table + " WHERE alm_id = " + alm_id;
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
|
try {
|
res = sql.sqlMysqlQuery(sql_str);
|
if(res.next()) {
|
isExists = true;
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
return isExists;
|
}
|
|
}
|
