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_Pwrdev_Alarm {
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
System.out.println(" db_pwrdev_alarm start end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
createDB_Pwrdev_Alarm (pool);
|
|
createPwrdev_Alarm_Table(pool, recreate);
|
|
createPwrdev_Alarm_History_Table(pool, recreate);
|
|
createPwrdev_Alarm_Param_Table(pool, recreate);
|
|
createPwrdev_Alarm_Config_Table(pool, recreate);
|
|
createPwrdev_Time_Adj_Alarm_Table(pool, recreate);
|
|
createPwrdev_Time_Out_Alarm_Table(pool, recreate);
|
|
createPwrdev_Alarm_Param_ForSX_Table(pool, recreate);
|
|
System.out.println(" db_pwrdev_alarm init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
}
|
|
private static void createPwrdev_Time_Out_Alarm_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Time_Out_Alarm_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Time_Out_Alarm_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alarm_typeId` int(11) NOT NULL DEFAULT '0'," +
|
" `alarm_index` int(11) NOT NULL DEFAULT '0'," +
|
" `timeout_tag` int(11) NOT NULL DEFAULT '0'," +
|
" `read_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `system_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `resume_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=65 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();
|
}
|
}
|
private static void createPwrdev_Time_Adj_Alarm_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Time_Adj_Alarm_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Time_Adj_Alarm_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alarm_typeId` int(11) NOT NULL DEFAULT '0'," +
|
" `detect_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=38 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();
|
}
|
}
|
private static void createPwrdev_Alarm_Config_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Config_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Config_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `SMS_CommPort` varchar(10) NOT NULL DEFAULT ' '," +
|
" `SMS_CommPort_ReInit` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `Beeper_CommPort` varchar(10) NOT NULL DEFAULT ' '," +
|
" `Beeper_CommPort_ReInit` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `SMS_Alarm_Text` varchar(100) NOT NULL DEFAULT ' '," +
|
" `SMS_Alarm_EN` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `Beeper_Alarm_EN` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `Beeper_Sound_OFF` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `AlarmDevIP` varchar(30) NOT NULL DEFAULT '192.168.10.223'," +
|
" `SMS_Alarm_ipPort` int(11) NOT NULL DEFAULT '26'," +
|
" `Beeper_Alarm_ipPort` int(11) NOT NULL DEFAULT '27'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=2 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();
|
}
|
}
|
private static void createPwrdev_Alarm_Param_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Param_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Param_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `alarm_id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alarm_limitH` float NOT NULL DEFAULT '0'," +
|
" `alarm_limitL` float NOT NULL DEFAULT '0'," +
|
" `alarm_limitEn` int(11) NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñ¿ÉÒÔÉèÖÃÉÏÏÂÏÞ'," +
|
" `UserAlarm_EN` int(11) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯¹æÔòÊÇ·ñÆô¶¯'," +
|
" `alarm_level` int(11) NOT NULL DEFAULT '0'," +
|
" `alarm_devtype` int(11) NOT NULL DEFAULT '0'," +
|
" `alarm_name` varchar(100) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `unique_alarm_id` (`alarm_id`)," +
|
" KEY `index_alarm_id` (`alarm_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 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();
|
}
|
}
|
|
/**
|
* ´´½¨ db_pwrdev_alarm Êý¾Ý¿â
|
* @param pool
|
*/
|
private static void createDB_Pwrdev_Alarm(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_PWRDEV_ALARM);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_alarm ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Alarm_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `record_id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alm_type` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_level` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_source` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_index` int(11) NOT NULL DEFAULT '0',"+
|
" `alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_value` float NOT NULL DEFAULT '0'," +
|
" `alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
|
" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'," +
|
" `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_record_id` (`record_id`)," +
|
" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
|
" KEY `index_alm_type` (`alm_type`)," +
|
" KEY `index_alm_start_time` (`alm_start_time`)," +
|
" KEY `index_alm_cleared_type` (`alm_cleared_type`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=44 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_source
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm'"
|
+ " AND column_name='alm_source'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
|
+ " ADD COLUMN `alm_source` int(11) NOT NULL DEFAULT '0'");
|
}
|
|
//Ìí¼Ó alm_index
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm'"
|
+ " AND column_name='alm_index'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
|
+ " ADD COLUMN `alm_index` int(11) NOT NULL DEFAULT '0'");
|
}
|
//Ìí¼Ó alm_trigger ¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm'"
|
+ " AND column_name='alm_trigger'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
|
+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'");
|
}
|
res = null;
|
//Ìí¼Ó alm_severity ¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm'"
|
+ " AND column_name='alm_severity'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
|
+ " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_alarm_history ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Alarm_History_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_History_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_History_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `record_id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alm_type` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_level` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_source` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_index` int(11) NOT NULL DEFAULT '0',"+
|
" `alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_value` float NOT NULL DEFAULT '0'," +
|
" `alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
|
" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'," +
|
" `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_record_id` (`record_id`)," +
|
" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
|
" KEY `index_alm_type` (`alm_type`)," +
|
" KEY `index_alm_start_time` (`alm_start_time`)," +
|
" KEY `index_alm_cleared_type` (`alm_cleared_type`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=43 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_source
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_history'"
|
+ " AND column_name='alm_source'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
|
+ " ADD COLUMN `alm_source` int(11) NOT NULL DEFAULT '0'");
|
}
|
|
//Ìí¼Ó alm_index
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_history'"
|
+ " AND column_name='alm_index'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
|
+ " ADD COLUMN `alm_index` int(11) NOT NULL DEFAULT '0'");
|
}
|
//Ìí¼Ó alm_trigger -- ¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_history'"
|
+ " AND column_name='alm_trigger'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
|
+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'");
|
}
|
//Ìí¼Ó alm_severity -- ¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_history'"
|
+ " AND column_name='alm_severity'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
|
+ " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
private static void createPwrdev_Alarm_Param_ForSX_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÔ´id'," +
|
" `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯id'," +
|
" `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '¸æ¾¯µÈ¼¶'," +
|
" `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÉÏÏÞãÐÖµ'," +
|
" `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'ÉÏÏ޸澯ʹÄÜ'," +
|
" `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÞãÐÖµ'," +
|
" `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÞʹÄÜ'," +
|
" `alarm_source` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯Êý¾ÝÀ´Ô´[0-É豸¸æ¾¯µãλÅжϣ»1-µ±Ç°ãÐÖµÅжÏ]'," +
|
" `alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'µ±Ç°¸æ¾¯ÃèÊö'," +
|
" `alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-ÉÏÏÂÏÞÓÐЧ 1-ÉÏÏÞÓÐЧ 2-ÏÂÏÞÓÐЧ'," +
|
" `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯À´Ô´Êǵãλʱ¸æ¾¯Ê¹ÄÜ[0:²»ÆôÓã»1£ºÆôÓÃ]'," +
|
" `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '¸æ¾¯ÉÏÉÏÏÞãÐÖµ'," +
|
" `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÂÏÞãÐÖµ'," +
|
" `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]'," +
|
" `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB 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);
|
|
//Ìí¼Ó alarm_en_node -- ¸æ¾¯À´Ô´Êǵãλʱ¸æ¾¯Ê¹ÄÜ[0:²»ÆôÓã»1£ºÆôÓÃ]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_param_forsx'"
|
+ " AND column_name='alarm_en_node'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
|
+ " ADD COLUMN `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯À´Ô´Êǵãλʱ¸æ¾¯Ê¹ÄÜ[0:²»ÆôÓã»1£ºÆôÓÃ]';");
|
}
|
res = null;
|
//Ìí¼Ó alarm_limitH_upper -- ¸æ¾¯ÉÏÉÏÏÞãÐÖµ
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_param_forsx'"
|
+ " AND column_name='alarm_limitH_upper'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
|
+ " ADD COLUMN `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '¸æ¾¯ÉÏÉÏÏÞãÐÖµ';");
|
}
|
res = null;
|
//Ìí¼Ó alarm_limitL_lower -- ¸æ¾¯ÏÂÏÂÏÞãÐÖµ
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_param_forsx'"
|
+ " AND column_name='alarm_limitL_lower'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
|
+ " ADD COLUMN `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÂÏÞãÐÖµ';");
|
}
|
res = null;
|
//Ìí¼Ó alarm_limitH_upper_en -- ÉÏÉÏÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_param_forsx'"
|
+ " AND column_name='alarm_limitH_upper_en'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
|
+ " ADD COLUMN `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]';");
|
}
|
|
res = null;
|
//Ìí¼Ó alarm_limitL_lower_en -- ÏÂÏÂÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_param_forsx'"
|
+ " AND column_name='alarm_limitL_lower_en'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
|
+ " ADD COLUMN `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]';");
|
}
|
|
res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);
|
StringBuffer buf_base = new StringBuffer("INSERT INTO " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + "(PowerDeviceId,alm_id,alm_level,alarm_limitH,alarm_limitH_EN,alarm_limitL,alarm_limitL_EN,alarm_name,alarm_type) VALUES");
|
StringBuffer buf_body = new StringBuffer();
|
while(res.next()) {
|
int PowerDeviceId = res.getInt("PowerDeviceId");
|
|
|
|
//½»Á÷AÏà¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"½»Á÷AÏà¹ýѹ¸æ¾¯",1,pool);
|
//½»Á÷AÏàǷѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"½»Á÷AÏàǷѹ¸æ¾¯",2,pool);
|
//½»Á÷AÏàȱÏà¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"½»Á÷AÏàȱÏà¸æ¾¯",2,pool);
|
//½»Á÷BÏà¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"½»Á÷BÏà¹ýѹ¸æ¾¯",1,pool);
|
//½»Á÷BÏàǷѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"½»Á÷BÏàǷѹ¸æ¾¯",2,pool);
|
//½»Á÷BÏàȱÏà¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"½»Á÷BÏàȱÏà¸æ¾¯",2,pool);
|
//½»Á÷CÏà¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"½»Á÷CÏà¹ýѹ¸æ¾¯",1,pool);
|
//½»Á÷CÏàǷѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"½»Á÷CÏàǷѹ¸æ¾¯",2,pool);
|
//½»Á÷CÏàȱÏà¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"½»Á÷CÏàȱÏà¸æ¾¯",2,pool);
|
|
|
//½»Á÷Í£µç¸æ¾¯ 110010
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_PowerDown_ID,SqlsUtils.Alarm_Level_First,54,false, 49,true,"½»Á÷Í£µç¸æ¾¯",2,pool);
|
//·ÀÀ×Æ÷¹ÊÕϸ澯 110011
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID,SqlsUtils.Alarm_Level_Second,54,false, 49,false,"·ÀÀ×Æ÷¹ÊÕϸ澯",2,pool);
|
//Ö±Á÷µçѹ¹ý¸ß¸æ¾¯ 110012
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_DCout_OverV_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"Ö±Á÷µçѹ¹ý¸ß¸æ¾¯",1,pool);
|
//Ö±Á÷µçѹ¹ýµÍ¸æ¾¯ 110013
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_DCout_UnderV_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"Ö±Á÷µçѹ¹ýµÍ¸æ¾¯",2,pool);
|
//¸ºÔØÈ۶ϸ澯 110014
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_LoaderFuse_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"¸ºÔØÈ۶ϸ澯",2,pool);
|
//µç³Ø×é1È۶ϸ澯 110015
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_BattGrp1Fuse_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"µç³Ø×é1È۶ϸ澯",2,pool);
|
//µç³Ø×é2È۶ϸ澯 110016
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_BattGrp2Fuse_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"µç³Ø×é2È۶ϸ澯",2,pool);
|
//ÕûÁ÷Æ÷1×ܹÊÕϸ澯 110017
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module1Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷1×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷2×ܹÊÕϸ澯 110018
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module2Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷2×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷3×ܹÊÕϸ澯 110019
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module3Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷3×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷4×ܹÊÕϸ澯 110020
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module4Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷4×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷5×ܹÊÕϸ澯 110021
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module5Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷5×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷6×ܹÊÕϸ澯 110022
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module6Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷6×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷7×ܹÊÕϸ澯 110023
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module7Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷7×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷8×ܹÊÕϸ澯 110024
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module8Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷8×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷9×ܹÊÕϸ澯 110025
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module9Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷9×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷10×ܹÊÕϸ澯 110026
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module10Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷10×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷11×ܹÊÕϸ澯 110027
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module11Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷11×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷12×ܹÊÕϸ澯 110028
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module12Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷12×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷13×ܹÊÕϸ澯 110029
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module13Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷13×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷14×ܹÊÕϸ澯 110030
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module14Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷14×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷15×ܹÊÕϸ澯 110031
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module15Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷15×ܹÊÕϸ澯",2,pool);
|
//ÕûÁ÷Æ÷16×ܹÊÕϸ澯 110032
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Module16Err_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"ÕûÁ÷Æ÷16×ܹÊÕϸ澯",2,pool);
|
//½»Á÷×ܹÊÕϸ澯 110033
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcAlarm_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"½»Á÷×ܹÊÕϸ澯",2,pool);
|
//Ö±Á÷×ܹÊÕϸ澯 110034
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_DcAlarm_ID,SqlsUtils.Alarm_Level_Second,54,true, 49,false,"Ö±Á÷×ܹÊÕϸ澯",2,pool);
|
|
//½»Á÷AÏà¹ýÁ÷¸æ¾¯ 110035
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷AÏà¹ýÁ÷¸æ¾¯",1,pool);
|
//½»Á÷BÏà¹ýÁ÷¸æ¾¯ 110036
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷BÏà¹ýÁ÷¸æ¾¯",1,pool);
|
//½»Á÷CÏà¹ýÁ÷¸æ¾¯ 110037
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷CÏà¹ýÁ÷¸æ¾¯",1,pool);
|
|
//¼à¿ØÆ÷¹ÊÕϸ澯 110038
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_MonitorErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"¼à¿ØÆ÷¹ÊÕϸ澯",1,pool);
|
//Ö±Á÷¹ýÁ÷¸æ¾¯ 110039
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_DcOut_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"Ö±Á÷¹ýÁ÷¸æ¾¯",1,pool);
|
//¿ª¹Ø¹ñ×ܱ¨¾¯ 110040
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_TolalAlarm_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"¿ª¹Ø¹ñ×ܱ¨¾¯",1,pool);
|
//µç³Ø×é1µçѹµÍ¸æ¾¯ 110041
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt1_VolLow_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"µç³Ø×é1µçѹµÍ¸æ¾¯",1,pool);
|
//µç³Ø×é2µçѹµÍ¸æ¾¯ 110042
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt2_VolLow_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"µç³Ø×é2µçѹµÍ¸æ¾¯",1,pool);
|
//µç³Ø×é1ϵç¸æ¾¯ 110043
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt1_Down_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"µç³Ø×é1ϵç¸æ¾¯",1,pool);
|
//µç³Ø×é2ϵç¸æ¾¯ 110044
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt2_Down_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"µç³Ø×é2ϵç¸æ¾¯",1,pool);
|
//µç³Ø×é1³äµç¹ýÁ÷¸æ¾¯ 110045
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt1_OverChgCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"µç³Ø×é1³äµç¹ýÁ÷¸æ¾¯",1,pool);
|
//µç³Ø×é2³äµç¹ýÁ÷¸æ¾¯ 110046
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Batt2_OverChgCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"µç³Ø×é2³äµç¹ýÁ÷¸æ¾¯",1,pool);
|
|
|
//ÕûÁ÷Æ÷1¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷1¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷2¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷2¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷3¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷3¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷4¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷4¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷5¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷5¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷6¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷6¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷7¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷7¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷8¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷8¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷9¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷9¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷10¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷10¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷11¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷11¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷12¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷12¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷13¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷13¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷14¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷14¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷15¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷15¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷16¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷16¹ýѹ¸æ¾¯",1,pool);
|
|
//ÕûÁ÷Æ÷1Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷1Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷2Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷2Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷3Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷3Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷4Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷4Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷5Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷5Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷6Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷6Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷7Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷7Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷8Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷8Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷9Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷9Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷10Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷10Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷11Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷11Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷12Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷12Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷13Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷13Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷14Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷14Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷15Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷15Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷16Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷16Ƿѹ¸æ¾¯",2,pool);
|
|
//ÕûÁ÷Æ÷1¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷1¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷2¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷2¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷3¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷3¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷4¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷4¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷5¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷5¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷6¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷6¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷7¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷7¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷8¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷8¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷9¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷9¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷10¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷10¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷11¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷11¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷12¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷12¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷13¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷13¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷14¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷14¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷15¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷15¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷16¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷16¹ýÁ÷¸æ¾¯",1,pool);
|
|
//ÕûÁ÷Æ÷1½»Á÷Òì³£¸æ¾¯ 110095
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷1½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷2½»Á÷Òì³£¸æ¾¯ 110096
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷2½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷3½»Á÷Òì³£¸æ¾¯ 110097
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷3½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷4½»Á÷Òì³£¸æ¾¯ 110098
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷4½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷5½»Á÷Òì³£¸æ¾¯ 110099
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷5½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷6½»Á÷Òì³£¸æ¾¯ 110100
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷6½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷7½»Á÷Òì³£¸æ¾¯ 110101
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷7½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷8½»Á÷Òì³£¸æ¾¯ 110102
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷8½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷9½»Á÷Òì³£¸æ¾¯ 110103
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷9½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷10½»Á÷Òì³£¸æ¾¯ 110104
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷10½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷11½»Á÷Òì³£¸æ¾¯ 110105
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷11½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷12½»Á÷Òì³£¸æ¾¯ 110106
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷12½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷13½»Á÷Òì³£¸æ¾¯ 110107
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷13½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷14½»Á÷Òì³£¸æ¾¯ 110108
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷14½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷15½»Á÷Òì³£¸æ¾¯ 110109
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷15½»Á÷Òì³£¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷16½»Á÷Òì³£¸æ¾¯ 110110
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_AC_Err_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷16½»Á÷Òì³£¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë1ÌøÕ¢¸æ¾¯ 110111
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_Trip_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷ÊäÈë1ÌøÕ¢¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë2ÌøÕ¢¸æ¾¯ 110112
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn2_Trip_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷ÊäÈë2ÌøÕ¢¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë1ÈÛË¿¸æ¾¯ 110113
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_Fuse_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷ÊäÈë1ÈÛË¿¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë2ÈÛË¿¸æ¾¯ 110114
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn2_Fuse_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷ÊäÈë2ÈÛË¿¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë1ÈýÏ಻ƽºâ¸æ¾¯ 110115
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_Unbalance_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"½»Á÷ÊäÈë1ÈýÏ಻ƽºâ¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë2ÈýÏ಻ƽºâ¸æ¾¯ 110116
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn2_Unbalance_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"½»Á÷ÊäÈë2ÈýÏ಻ƽºâ¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë1ƵÂÊÒì³£¸æ¾¯ 110117
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_FreqErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"½»Á÷ÊäÈë1ƵÂÊÒì³£¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë2ƵÂÊÒì³£¸æ¾¯ 110118
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn2_FreqErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"½»Á÷ÊäÈë2ƵÂÊÒì³£¸æ¾¯",1,pool);
|
//ÐתͨÐŹÊÕϸ澯 110119
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_CPSS_CommErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÐתͨÐŹÊÕϸ澯",1,pool);
|
|
|
|
//1+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
//µçԴͨÐŹÊÕϸ澯 110120
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_PWRDEV_CommErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"µçԴͨÐŹÊÕϸ澯",1,pool);
|
//½»Á÷ÊäÈë1Í£µç¸æ¾¯ 110121
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_User_AcIn1_PowerDown_ID,SqlsUtils.Alarm_Level_First,100,true, 0,false,"½»Á÷ÊäÈë1Í£µç¸æ¾¯",1,pool);
|
//½»Á÷ÊäÈë2Í£µç¸æ¾¯ 110122
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_User_AcIn2_PowerDown_ID,SqlsUtils.Alarm_Level_First,100,true, 0,false,"½»Á÷ÊäÈë2Í£µç¸æ¾¯",1,pool);
|
//½»Á÷1²É¼¯Í¨ÐŹÊÕϸ澯 110123
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_User_AcIn1_CommErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷1²É¼¯Í¨ÐŹÊÕϸ澯",1,pool);
|
//½»Á÷2²É¼¯Í¨ÐŹÊÕϸ澯 110124
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_User_AcIn2_CommErr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷2²É¼¯Í¨ÐŹÊÕϸ澯",1,pool);
|
//θÐ1ͨÐŹÊÕϸ澯 110125
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Temp1_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"θÐ1ͨÐŹÊÕϸ澯",1,pool);
|
//θÐ2ͨÐŹÊÕϸ澯 110126
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Temp2_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"θÐ2ͨÐŹÊÕϸ澯",1,pool);
|
//θÐ3ͨÐŹÊÕϸ澯 110127
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Temp3_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"θÐ3ͨÐŹÊÕϸ澯",1,pool);
|
//ʪ¸Ð1ͨÐŹÊÕϸ澯 110128
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Humi1_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"ʪ¸Ð1ͨÐŹÊÕϸ澯",1,pool);
|
//ʪ¸Ð2ͨÐŹÊÕϸ澯 110129
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Humi2_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"ʪ¸Ð2ͨÐŹÊÕϸ澯",1,pool);
|
//ʪ¸Ð3ͨÐŹÊÕϸ澯 110130
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Humi3_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"ʪ¸Ð3ͨÐŹÊÕϸ澯",1,pool);
|
//Ñ̸Ð1±¨¾¯¸æ¾¯ 110131
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke1_Occur_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"Ñ̸Ð1±¨¾¯¸æ¾¯",1,pool);
|
//Ñ̸Ð2±¨¾¯¸æ¾¯ 110132
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke2_Occur_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"Ñ̸Ð2±¨¾¯¸æ¾¯",1,pool);
|
//Ñ̸Ð3±¨¾¯¸æ¾¯ 110133
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke3_Occur_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"Ñ̸Ð3±¨¾¯¸æ¾¯",1,pool);
|
//Ñ̸Ð1ͨÐŹÊÕϸ澯 110134
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke1_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"Ñ̸Ð1ͨÐŹÊÕϸ澯",1,pool);
|
//Ñ̸Ð2ͨÐŹÊÕϸ澯 110135
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke2_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"Ñ̸Ð2ͨÐŹÊÕϸ澯",1,pool);
|
//Ñ̸Ð3ͨÐŹÊÕϸ澯 110136
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_Envm_Smoke3_CommErr_ID,SqlsUtils.Alarm_Level_Third,100,true, 0,false,"Ñ̸Ð3ͨÐŹÊÕϸ澯",1,pool);
|
|
//System.out.println(PowerDeviceId +" == " + buf_body );
|
}
|
if(buf_body.length() > 0) {
|
sql.sqlMysqlExecute((buf_base.append(buf_body)).toString());
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
*
|
* @param buf_body sql_str
|
* @param PowerDeviceId µçÔ´id
|
* @param alm_id ¸æ¾¯id
|
* @param alm_level ¸æ¾¯µÈ¼¶
|
* @param alarm_limitH ÉÏÏÞãÐÖµ
|
* @param alarm_limitH_EN ÉÏÏÞãÐֵʹÄÜ
|
* @param alarm_limitL ÏÂÏÞãÐÖµ
|
* @param alarm_limitL_EN ÏÂÏÞãÐֵʹÄÜ
|
* @param alarm_name ¸æ¾¯ÃèÊö
|
* @param alarm_type ¸æ¾¯ÓÐЧ 0-ÉÏÏÂÏÞÓÐЧ 1-ÉÏÏÞÓÐЧ 2-ÏÂÏÞÓÐЧ
|
*/
|
public static void checkPowerAlarmParam(StringBuffer buf_body,int PowerDeviceId,int alm_id,int alm_level,float alarm_limitH,boolean alarm_limitH_EN, float alarm_limitL, boolean alarm_limitL_EN,String alarm_name,int alarm_type,MysqlConnPool pool) {
|
String sql_str_sel = "SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
res = sql.sqlMysqlQuery(sql_str_sel);
|
//System.out.println(sql_str_sel);
|
try {
|
if(!res.next()) {
|
if(buf_body.length() > 0) {
|
buf_body.append(",");
|
}
|
buf_body.append("("+PowerDeviceId+","+alm_id+","+alm_level+","+alarm_limitH+","+alarm_limitH_EN+","+alarm_limitL+","+alarm_limitL_EN+",'"+alarm_name+"',"+alarm_type+")");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
|
public static void main(String[] args) {
|
MysqlConnPool pool = new MysqlConnPool("192.168.10.79", 3360, 5);
|
createPwrdev_Alarm_Param_ForSX_Table(pool, false);
|
}
|
}
|
