package com.power.alarm;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
import com.base.Com;
|
import com.power.data.PowerData_RT;
|
import com.power.mysql.MysqlConnPool;
|
import com.power.mysql.Sql_Mysql;
|
|
public class PwrDeviceAlarm_Thread_SQL {
|
|
|
public static void ChangeRT_AlarmToHistoryAlarm(MysqlConnPool pool,PwrDeviceAlarm_Data alm){
|
|
ArrayList<String> sql_strs = new ArrayList<String>();
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
|
|
try {
|
sql.sqlMysqlUseDB(Sql_Mysql.DB_PWRDEV_ALARM);
|
|
// //ÔÚʵʱ¸æ¾¯±íÖеĵ±Ç°É豸µÄ¸æ¾¯¼Ç¼¸Ä³ÉÀúÊ·¸æ¾¯¼Ç¼,²¢ÇҼǼµ±Ç°µÄʱ¼ä
|
// String sql_str1 = "UPDATE " + Sql_Mysql.TB_PWRDEV_ALARM
|
// + " SET "
|
// + " alm_end_time='" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "', "
|
// + " alm_cleared_type=" + PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_AUTO
|
// + " WHERE PowerDeviceId=" + dev_id + " AND alm_type= "+ alm_type_id;
|
|
//½«µ±Ç°É豸ʵʱ¸æ¾¯±íÖеÄÀúÊ·¸æ¾¯¼Ç¼²åÈëµ½É豸ÀúÊ·¸æ¾¯±íÖÐ
|
String sql_str2 = " INSERT INTO " + Sql_Mysql.TB_PWRDEV_ALARM_HISTORY+"(record_id,PowerDeviceId,alm_type,alm_level,alm_start_time,alm_end_time,alm_value,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,alm_trigger,alm_severity) (SELECT record_id,PowerDeviceId,alm_type,alm_level,alm_start_time,alm_end_time,alm_value,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,alm_trigger,alm_severity from "+Sql_Mysql.TB_PWRDEV_ALARM+" WHERE PowerDeviceId = " + alm.pwrdev_id + " and alm_type = " + alm.alm_type + " and alm_cleared_type = " + PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_HIST + ")";
|
|
//½«ÊµÊ±¸æ¾¯±íÖеķÇʵʱ¸æ¾¯É¾³ý
|
String sql_str3 = " DELETE FROM " + Sql_Mysql.TB_PWRDEV_ALARM +" WHERE PowerDeviceId = "+ alm.pwrdev_id + " and alm_type = " + alm.alm_type + " and alm_cleared_type = " + PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_HIST + ")";
|
|
//sql_strs.add(sql_str1);
|
sql_strs.add(sql_str2);
|
sql_strs.add(sql_str3);
|
sql.makeManualCommit(sql_strs);
|
|
} catch (Exception e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
sql.close_con();
|
}
|
|
}
|
public static void ChangeRT_AlarmToAlarmVerify(MysqlConnPool pool,PwrDeviceAlarm_Data alm){
|
|
ArrayList<String> sql_strs = new ArrayList<String>();
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
|
|
try {
|
sql.sqlMysqlUseDB(Sql_Mysql.DB_PWRDEV_ALARM);
|
|
// //ÔÚʵʱ¸æ¾¯±íÖеĵ±Ç°É豸µÄ¸æ¾¯¼Ç¼¸Ä³ÉÀúÊ·¸æ¾¯¼Ç¼,²¢ÇҼǼµ±Ç°µÄʱ¼ä
|
// String sql_str1 = "UPDATE " + Sql_Mysql.TB_PWRDEV_ALARM
|
// + " SET "
|
// + " alm_end_time='" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "', "
|
// + " alm_cleared_type=" + PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_AUTO
|
// + " WHERE PowerDeviceId=" + dev_id + " AND alm_type= "+ alm_type_id;
|
|
//½«µ±Ç°É豸ʵʱ¸æ¾¯±íÖеÄÀúÊ·¸æ¾¯¼Ç¼²åÈëµ½É豸ÀúÊ·¸æ¾¯±íÖÐ
|
String sql_str2 = " INSERT INTO " + Sql_Mysql.PWRDEV_ALARM_VERIFY_TABLE+"(record_id,PowerDeviceId,alm_type,alm_level,alm_start_time,alm_end_time,alm_value,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,alm_trigger,alm_severity)(SELECT record_id,PowerDeviceId,alm_type,alm_level,alm_start_time,alm_end_time,alm_value,alm_is_confirmed,alm_confirmed_time,alm_cleared_type,alm_trigger,alm_severity from "+Sql_Mysql.TB_PWRDEV_ALARM+" WHERE PowerDeviceId = " + alm.pwrdev_id + " and alm_type = " + alm.alm_type + " and alm_cleared_type = " + PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_HIST + ");";
|
|
//½«ÊµÊ±¸æ¾¯±íÖеķÇʵʱ¸æ¾¯É¾³ý
|
String sql_str3 = " DELETE FROM " + Sql_Mysql.TB_PWRDEV_ALARM +" WHERE PowerDeviceId = "+ alm.pwrdev_id + " and alm_type = " + alm.alm_type + " and alm_cleared_type = " + PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_HIST;
|
|
//System.out.println(sql_str2);
|
//sql_strs.add(sql_str1);
|
|
sql_strs.add(sql_str2);
|
sql_strs.add(sql_str3);
|
sql.makeManualCommit(sql_strs);
|
|
} catch (Exception e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
sql.close_con();
|
}
|
|
}
|
|
public static List<PwrDeviceAlarm_Data> queryPwrDeviceHistoty(MysqlConnPool pool) {
|
List<PwrDeviceAlarm_Data> al_alarm = new ArrayList<>();
|
String sql_str_sel = " SELECT * FROM db_pwrdev_alarm.tb_pwrdev_alarm WHERE alm_cleared_type = " + PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_HIST;
|
ResultSet res = null;
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
res = sql.sqlMysqlQuery(sql_str_sel);
|
try {
|
while(res.next()) {
|
PwrDeviceAlarm_Data tmp_alm = new PwrDeviceAlarm_Data(res.getInt("alm_type"));
|
tmp_alm.pwrdev_id = res.getInt("PowerDeviceId");
|
tmp_alm.RecId = res.getLong("record_id");
|
tmp_alm.alm_cleared_type = res.getInt("alm_cleared_type"); //¸æ¾¯ÀàÐÍ 0:ʵʱ¸æ¾¯ 1:ÀúÊ·¸æ¾¯ 2:È¡Ïû¸æ¾¯
|
tmp_alm.alm_vlaue = res.getFloat("alm_value"); //¸æ¾¯Öµ
|
tmp_alm.alm_level = res.getInt("alm_level"); //¸æ¾¯µÈ¼¶
|
tmp_alm.alm_start_time = res.getTimestamp("alm_start_time"); //¸æ¾¯¿ªÊ¼Ê±¼ä
|
tmp_alm.alm_end_time = res.getTimestamp("alm_end_time"); //¸æ¾¯½áÊøʱ¼ä
|
tmp_alm.alm_trigger = res.getInt("alm_trigger"); //¸æ¾¯À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]
|
tmp_alm.alm_severity = res.getInt("alm_severity"); //¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]
|
al_alarm.add(tmp_alm);
|
}
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
}
|
}
|
sql.close_con();
|
}
|
return al_alarm;
|
}
|
|
/**
|
* ²åÈë»òÕ߸üеçÔ´¸æ¾¯¼Ç¼
|
* @param pool
|
* @param alarm
|
*/
|
public static void InsertPwrDevAlarmToTable(MysqlConnPool pool, PwrDeviceAlarm_Data alarm) {
|
String sql_str_sel = " SELECT * FROM db_pwrdev_alarm.tb_pwrdev_alarm WHERE alm_type = " + alarm.alm_type + " and PowerDeviceId = " + alarm.pwrdev_id/* + " AND alm_cleared_type = " + PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_REAL*/;
|
String sql_str_upd = "";
|
String sql_str_ins = "";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
PwrDeviceAlarm_Data tmp_alm = null;
|
|
try {
|
sql.sqlMysqlUseDB(Sql_Mysql.DB_PWRDEV_ALARM);
|
res = sql.sqlMysqlQuery(sql_str_sel);
|
if(res.next()) {
|
tmp_alm = new PwrDeviceAlarm_Data(res.getInt("alm_type"));
|
tmp_alm.RecId = res.getLong("record_id");
|
tmp_alm.alm_cleared_type = res.getInt("alm_cleared_type"); //¸æ¾¯ÀàÐÍ 0:ʵʱ¸æ¾¯ 1:ÀúÊ·¸æ¾¯ 2:È¡Ïû¸æ¾¯
|
tmp_alm.alm_vlaue = res.getFloat("alm_value"); //¸æ¾¯Öµ
|
tmp_alm.alm_level = res.getInt("alm_level"); //¸æ¾¯µÈ¼¶
|
tmp_alm.alm_start_time = res.getTimestamp("alm_start_time"); //¸æ¾¯¿ªÊ¼Ê±¼ä
|
tmp_alm.alm_end_time = res.getTimestamp("alm_end_time"); //¸æ¾¯½áÊøʱ¼ä
|
tmp_alm.alm_trigger = res.getInt("alm_trigger"); //¸æ¾¯À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]
|
tmp_alm.alm_severity = res.getInt("alm_severity"); //¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]
|
}
|
if(null == tmp_alm) {
|
if(alarm.alm_cleared_type == PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_REAL) {
|
//гöÏֵĵçԴʵʱ¸æ¾¯
|
sql_str_ins = "INSERT INTO " + Sql_Mysql.TB_PWRDEV_ALARM + " "
|
+ "(record_id,"
|
+ "PowerDeviceId, "
|
+ "alm_type, "
|
+ "alm_level, "
|
+ "alm_start_time, "
|
+ "alm_end_time, "
|
+ "alm_value,"
|
+ "alm_is_confirmed, "
|
+ "alm_confirmed_time,"
|
+ "alm_trigger, "
|
+ "alm_severity, "
|
+ "alm_cleared_type) "
|
|
+ " VALUES "
|
+ "("
|
+ alarm.RecId + ", "
|
+ alarm.pwrdev_id + ", "
|
+ alarm.alm_type + ", "
|
+ alarm.alm_level + ", "
|
+ "'" + Com.getDateTimeFormat(alarm.alm_start_time, Com.DTF_YMDhms) + "', "
|
+ "'" + Com.getDateTimeFormat(alarm.alm_end_time, Com.DTF_YMDhms) + "', "
|
+ alarm.alm_vlaue +", "
|
+ false + ", "
|
+ "'" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "', "
|
+ "'" + alarm.alm_trigger + "', "
|
+ "" + alarm.alm_severity + ", "
|
+ PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_NULL + " "
|
+ ")";
|
sql.sqlMysqlExecute(sql_str_ins);
|
}
|
}else {
|
//µ±Ç°ÊµÊ±¸æ¾¯ÒÑ´æÔÚ
|
if(alarm.alm_cleared_type == PwrDeviceAlarm_Data.ALM_CLEARED_TYPE_HIST) {
|
//µ±Ç°¸æ¾¯Ïûʧ,Ð޸ĵ±Ç°×´Ì¬
|
sql_str_upd = " UPDATE " + Sql_Mysql.PWRDEV_ALARM_TABLE +
|
" SET alm_cleared_type = " + alarm.alm_cleared_type +
|
" ,alm_end_time = '" + Com.getDateTimeFormat(alarm.alm_end_time, Com.DTF_YMDhms) + "'" +
|
" WHERE PowerDeviceId = " + alarm.pwrdev_id + " AND alm_type = " + alarm.alm_type;
|
sql.sqlMysqlExecute(sql_str_upd);
|
}
|
if(alarm.alm_level != tmp_alm.alm_level) {
|
//µ±Ç°¸æ¾¯µÈ¼¶Çл»
|
sql_str_upd = " UPDATE " + Sql_Mysql.PWRDEV_ALARM_TABLE +
|
" SET alm_level = " + alarm.alm_level +
|
" WHERE PowerDeviceId = " + alarm.pwrdev_id + " AND alm_type = " + alarm.alm_type;
|
sql.sqlMysqlExecute(sql_str_upd);
|
}
|
|
}
|
|
|
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
}
|
}
|
sql.close_con();
|
}
|
|
|
|
}
|
|
/**
|
* ¶ÁÈ¡ÊÇ·ñÐèÒª¸üеçÔ´¸æ¾¯²ÎÊý
|
* @param pool
|
* @return
|
*/
|
public static int quereyAlarmThreadParam(MysqlConnPool pool) {
|
int thread_en = 0;
|
String sql_str = "SELECT * FROM web_site.tb_thread_util WHERE thread_id = 2019003";
|
ResultSet res = null;
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
res = sql.sqlMysqlQuery(sql_str);
|
if(res.next()) {
|
thread_en = res.getInt("thread_en");
|
}
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
}
|
}
|
sql.close_con();
|
}
|
return thread_en;
|
}
|
|
/**
|
* ¶ÁÈ¡ÊÇ·ñÐèÒª¸üеçÔ´¸æ¾¯²ÎÊý
|
* @param pool
|
* @return
|
*/
|
public static int updateAlarmThreadParam(MysqlConnPool pool,int thread_en) {
|
String sql_str = " UPDATE web_site.tb_thread_util" +
|
" SET thread_en = " + thread_en +
|
" WHERE thread_id = 2019003";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute(sql_str);
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
sql.close_con();
|
}
|
return thread_en;
|
}
|
|
/**
|
* ÔØÈëµçÔ´¸æ¾¯²ÎÊý
|
* @param pool
|
* @param rtpd
|
*/
|
public static void readPwrDeviceAlarm(MysqlConnPool pool,PowerData_RT rtpd) {
|
String sql_str_sel = " SELECT * FROM " + Sql_Mysql.PWRDEV_ALARM_PARAM_FORSX_TABLE + " WHERE PowerDeviceId = " + rtpd.PowerDevDeviceId;
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
res = sql.sqlMysqlQuery(sql_str_sel);
|
try {
|
rtpd.almParams.clear();
|
while(res.next()) {
|
PwrDeviceAarmParam param = new PwrDeviceAarmParam();
|
|
param.PowerDeviceId = res.getInt("PowerDeviceId"); //'µçÔ´id',
|
param.alm_id = res.getInt("alm_id"); //'¸æ¾¯id',
|
param.alm_level = res.getInt("alm_level"); //'¸æ¾¯µÈ¼¶',
|
param.alarm_limitH = res.getFloat("alarm_limitH"); //'¸æ¾¯ÉÏÏÞãÐÖµ',
|
param.alarm_limitH_EN = res.getBoolean("alarm_limitH_EN"); //'ÉÏÏ޸澯ʹÄÜ',
|
param.alarm_limitL = res.getFloat("alarm_limitL"); //'¸æ¾¯ÏÂÏÞãÐÖµ',
|
param.alarm_limitL_EN = res.getBoolean("alarm_limitL_EN"); //'¸æ¾¯ÏÂÏÞʹÄÜ',
|
param.alarm_source = res.getInt("alarm_source"); //'¸æ¾¯Êý¾ÝÀ´Ô´[0-É豸¸æ¾¯µãλÅжϣ»1-µ±Ç°ãÐÖµÅжÏ]',
|
param.alarm_name = res.getString("alarm_name"); //'µ±Ç°¸æ¾¯ÃèÊö',
|
param.alarm_type = res.getInt("alarm_type"); //'0-ÉÏÏÂÏÞÓÐЧ 1-ÉÏÏÞÓÐЧ 2-ÏÂÏÞÓÐЧ',
|
param.alarm_en_node = res.getInt("alarm_en_node"); //¸æ¾¯À´Ô´Êǵãλʱ¸æ¾¯Ê¹ÄÜ[0:²»ÆôÓã»1£ºÆôÓÃ]
|
|
|
param.alarm_limitH_upper = res.getFloat("alarm_limitH_upper"); //'¸æ¾¯ÉÏÉÏÏÞãÐÖµ',
|
param.alarm_limitL_lower = res.getFloat("alarm_limitL_lower"); //'¸æ¾¯ÏÂÏÂÏÞãÐÖµ',
|
|
param.alm_delay_time = res.getInt("alm_delay_time"); //'¸æ¾¯ÉÏÉÏÏÞãÐֵʹÄÜ',
|
|
param.alarm_limitH_upper_en = res.getBoolean("alarm_limitH_upper_en"); //'¸æ¾¯ÉÏÉÏÏÞãÐֵʹÄÜ',
|
param.alarm_limitL_lower_en = res.getBoolean("alarm_limitL_lower_en"); //'¸æ¾¯ÏÂÏÂÏÞãÐֵʹÄÜ',
|
|
param.alarm_limitL_level = res.getInt("alarm_limitL_level"); //ÏÂÏ޸澯µÈ¼¶',
|
param.alarm_limitH_level = res.getInt("alarm_limitH_level"); //ÉÏÏ޸澯µÈ¼¶',
|
param.alarm_limitL_lower_level = res.getInt("alarm_limitL_lower_level"); //ÏÂÏÂÏ޸澯µÈ¼¶',
|
param.alarm_limitH_upper_level = res.getInt("alarm_limitH_upper_level"); //ÉÏÉÏÏ޸澯µÈ¼¶',
|
|
rtpd.almParams.put(param.alm_id, param);
|
}
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
}
|
}
|
sql.close_con();
|
}
|
|
}
|
|
public static void queryLastPwrDeviceAlarm(PowerData_RT item,MysqlConnPool pool) {
|
String sql_str = " SELECT * FROM " + Sql_Mysql.PWRDEV_ALARM_TABLE + " WHERE PowerDeviceId = " + item.PowerDevDeviceId + " AND alm_cleared_type = 0;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
res = sql.sqlMysqlQuery(sql_str);
|
try {
|
while(res.next()) {
|
|
PwrDeviceAlarm_Data alm = null;
|
int alm_type = res.getInt("alm_type");
|
switch(alm_type) {
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_OverV_ID: //110001; //1·½»Á÷AÏà¹ýѹ
|
{alm = item.alm_ACDC_Acin1_A_OverV_First;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID: //110002; //1·½»Á÷AÏàǷѹ
|
{alm = item.alm_ACDC_Acin1_A_Underv_First;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_Less_ID: //110003; //1·½»Á÷AÏàȱÏà
|
{alm = item.alm_ACDC_AcIn1_A_Less_First;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_OverV_ID: //110004; //1·½»Á÷BÏà¹ýѹ
|
{alm = item.alm_ACDC_AcIn1_B_OverV_First;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID: //110005; //1·½»Á÷BÏàǷѹ
|
{alm = item.alm_ACDC_AcIn1_B_UnderV_First;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_Less_ID: //110006; //1·½»Á÷BÏàȱÏà
|
{alm = item.alm_ACDC_AcIn1_B_Less_First;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_OverV_ID: //110007; //1·½»Á÷CÏà¹ýѹ
|
{alm = item.alm_ACDC_AcIn1_C_OverV_First;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID: //110008; //1·½»Á÷CÏàǷѹ
|
{alm = item.alm_ACDC_AcIn1_C_UnderV_First;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_Less_ID: //110009; //1·½»Á÷CÏàȱÏà
|
{alm = item.alm_ACDC_AcIn1_C_Less_First;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_PowerDown_ID: //110010; //½»Á÷Í£µç
|
{alm = item.alm_ACDC_AcIn1_PowerDown;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_ThunderErr_ID: //110011; //·ÀÀ×Æ÷¹ÊÕÏ
|
{alm = item.alm_ACDC_AcIn1_ThunderErr;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_DCout_OverV_ID: //110012; //Ö±Á÷µçѹ¹ý¸ß
|
{alm = item.alm_ACDC_DCout_OverV;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_DCout_UnderV_ID: //110013; //Ö±Á÷µçѹ¹ýµÍ
|
{alm = item.alm_ACDC_DCout_UnderV;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_LoaderFuse_ID: //110014; //¸ºÔØÈÛ¶Ï
|
{alm = item.alm_ACDC_LoaderFuse;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_BattGrp1Fuse_ID: //110015; //µç³Ø×é1ÈÛ¶Ï
|
{alm = item.alm_ACDC_BattGrp1Fuse;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_BattGrp2Fuse_ID: //110016; //µç³Ø×é2ÈÛ¶Ï
|
{alm = item.alm_ACDC_BattGrp2Fuse;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module1Err_ID: //110017; //ÕûÁ÷Æ÷1×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module1Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module2Err_ID: //110018; //ÕûÁ÷Æ÷2×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module2Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module3Err_ID: //110019; //ÕûÁ÷Æ÷3×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module3Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module4Err_ID: //110020; //ÕûÁ÷Æ÷4×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module4Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module5Err_ID: //110021; //ÕûÁ÷Æ÷5×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module5Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module6Err_ID: //110022; //ÕûÁ÷Æ÷6×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module6Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module7Err_ID: //110023; //ÕûÁ÷Æ÷7×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module7Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module8Err_ID: //110024; //ÕûÁ÷Æ÷8×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module8Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module9Err_ID: //110025; //ÕûÁ÷Æ÷9×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module9Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module10Err_ID: //110026; //ÕûÁ÷Æ÷10×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module10Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module11Err_ID: //110027; //ÕûÁ÷Æ÷11×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module11Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module12Err_ID: //110028; //ÕûÁ÷Æ÷12×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module12Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module13Err_ID: //110029; //ÕûÁ÷Æ÷13×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module13Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module14Err_ID: //110030; //ÕûÁ÷Æ÷14×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module14Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module15Err_ID: //110031; //ÕûÁ÷Æ÷15×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module15Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Module16Err_ID: //110032; //ÕûÁ÷Æ÷16×ܹÊÕÏ
|
{alm = item.alm_ACDC_Module16Err;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcAlarm_ID: //110033; //½»Á÷×ܹÊÕÏ
|
{alm = item.alm_ACDC_AcAlarm;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_DcAlarm_ID: //110034; //Ö±Á÷×ܹÊÕÏ
|
{alm = item.alm_ACDC_DcAlarm;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Acb1_OverCurrA_ID: //110035; //½»Á÷AÏà¹ýÁ÷
|
{alm = item.alm_ACDC_Acb1_OverCurrA;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Acb1_OverCurrB_ID: //110036; //½»Á÷BÏà¹ýÁ÷
|
{alm = item.alm_ACDC_Acb1_OverCurrB;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Acb1_OverCurrC_ID: //110037; //½»Á÷CÏà¹ýÁ÷
|
{alm = item.alm_ACDC_Acb1_OverCurrC;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_MonitorErr_ID: //110038; //¼à¿ØÆ÷¹ÊÕÏ
|
{alm = item.alm_ACDC_MonitorErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_DcOut_OverCurr_ID: //110039; //Ö±Á÷¹ýÁ÷
|
{alm = item.alm_ACDC_DcOut_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_TolalAlarm_ID: //110040; //¿ª¹Ø¹ñ×ܱ¨¾¯
|
{alm = item.alm_ACDC_TolalAlarm;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Batt1_VolLow_ID: //110041; //µç³Ø×é1µçѹµÍ
|
{alm = item.alm_ACDC_Batt1_VolLow;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Batt2_VolLow_ID: //110042; //µç³Ø×é2µçѹµÍ
|
{alm = item.alm_ACDC_Batt2_VolLow;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Batt1_Down_ID: //110043; //µç³Ø×é1ϵç
|
{alm = item.alm_ACDC_Batt1_Down;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Batt2_Down_ID: //110044; //µç³Ø×é2ϵç
|
{alm = item.alm_ACDC_Batt2_Down;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Batt1_OverChgCurr_ID: //110045; //µç³Ø×é1³äµç¹ýÁ÷
|
{alm = item.alm_ACDC_Batt1_OverChgCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Batt2_OverChgCurr_ID: //110046; //µç³Ø×é2³äµç¹ýÁ÷
|
{alm = item.alm_ACDC_Batt2_OverChgCurr;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod1_OverVol_ID: //110047; //ÕûÁ÷Æ÷1¹ýѹ
|
{alm = item.alm_ACDC_Mod1_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod2_OverVol_ID: //110048; //ÕûÁ÷Æ÷2¹ýѹ
|
{alm = item.alm_ACDC_Mod2_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod3_OverVol_ID: //110049; //ÕûÁ÷Æ÷3¹ýѹ
|
{alm = item.alm_ACDC_Mod3_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod4_OverVol_ID: //110050; //ÕûÁ÷Æ÷4¹ýѹ
|
{alm = item.alm_ACDC_Mod4_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod5_OverVol_ID: //110051; //ÕûÁ÷Æ÷5¹ýѹ
|
{alm = item.alm_ACDC_Mod5_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod6_OverVol_ID: //110052; //ÕûÁ÷Æ÷6¹ýѹ
|
{alm = item.alm_ACDC_Mod6_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod7_OverVol_ID: //110053; //ÕûÁ÷Æ÷7¹ýѹ
|
{alm = item.alm_ACDC_Mod7_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod8_OverVol_ID: //110054; //ÕûÁ÷Æ÷8¹ýѹ
|
{alm = item.alm_ACDC_Mod8_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod9_OverVol_ID: //110055; //ÕûÁ÷Æ÷9¹ýѹ
|
{alm = item.alm_ACDC_Mod9_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod10_OverVol_ID: //110056; //ÕûÁ÷Æ÷10¹ýѹ
|
{alm = item.alm_ACDC_Mod10_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod11_OverVol_ID: //110057; //ÕûÁ÷Æ÷11¹ýѹ
|
{alm = item.alm_ACDC_Mod11_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod12_OverVol_ID: //110058; //ÕûÁ÷Æ÷12¹ýѹ
|
{alm = item.alm_ACDC_Mod12_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod13_OverVol_ID: //110059; //ÕûÁ÷Æ÷13¹ýѹ
|
{alm = item.alm_ACDC_Mod13_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod14_OverVol_ID: //110060; //ÕûÁ÷Æ÷14¹ýѹ
|
{alm = item.alm_ACDC_Mod14_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod15_OverVol_ID: //110061; //ÕûÁ÷Æ÷15¹ýѹ
|
{alm = item.alm_ACDC_Mod15_OverVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod16_OverVol_ID: //110062; //ÕûÁ÷Æ÷16¹ýѹ
|
{alm = item.alm_ACDC_Mod16_OverVol;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod1_UnderVol_ID: //110063; //ÕûÁ÷Æ÷1Ƿѹ
|
{alm = item.alm_ACDC_Mod1_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod2_UnderVol_ID: //110064; //ÕûÁ÷Æ÷2Ƿѹ
|
{alm = item.alm_ACDC_Mod2_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod3_UnderVol_ID: //110065; //ÕûÁ÷Æ÷3Ƿѹ
|
{alm = item.alm_ACDC_Mod3_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod4_UnderVol_ID: //110066; //ÕûÁ÷Æ÷4Ƿѹ
|
{alm = item.alm_ACDC_Mod4_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod5_UnderVol_ID: //110067; //ÕûÁ÷Æ÷5Ƿѹ
|
{alm = item.alm_ACDC_Mod5_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod6_UnderVol_ID: //110068; //ÕûÁ÷Æ÷6Ƿѹ
|
{alm = item.alm_ACDC_Mod6_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod7_UnderVol_ID: //110069; //ÕûÁ÷Æ÷7Ƿѹ
|
{alm = item.alm_ACDC_Mod7_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod8_UnderVol_ID: //110070; //ÕûÁ÷Æ÷8Ƿѹ
|
{alm = item.alm_ACDC_Mod8_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod9_UnderVol_ID: //110071; //ÕûÁ÷Æ÷9Ƿѹ
|
{alm = item.alm_ACDC_Mod9_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod10_UnderVol_ID: //110072; //ÕûÁ÷Æ÷10Ƿѹ
|
{alm = item.alm_ACDC_Mod10_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod11_UnderVol_ID: //110073; //ÕûÁ÷Æ÷11Ƿѹ
|
{alm = item.alm_ACDC_Mod11_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod12_UnderVol_ID: //110074; //ÕûÁ÷Æ÷12Ƿѹ
|
{alm = item.alm_ACDC_Mod12_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod13_UnderVol_ID: //110075; //ÕûÁ÷Æ÷13Ƿѹ
|
{alm = item.alm_ACDC_Mod13_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod14_UnderVol_ID: //110076; //ÕûÁ÷Æ÷14Ƿѹ
|
{alm = item.alm_ACDC_Mod14_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod15_UnderVol_ID: //110077; //ÕûÁ÷Æ÷15Ƿѹ
|
{alm = item.alm_ACDC_Mod15_UnderVol;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod16_UnderVol_ID: //110078; //ÕûÁ÷Æ÷16Ƿѹ
|
{alm = item.alm_ACDC_Mod16_UnderVol;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod1_OverCurr_ID: //110079; //ÕûÁ÷Æ÷1¹ýÁ÷
|
{alm = item.alm_ACDC_Mod1_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod2_OverCurr_ID: //110080; //ÕûÁ÷Æ÷2¹ýÁ÷
|
{alm = item.alm_ACDC_Mod2_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod3_OverCurr_ID: //110081; //ÕûÁ÷Æ÷3¹ýÁ÷
|
{alm = item.alm_ACDC_Mod3_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod4_OverCurr_ID: //110082; //ÕûÁ÷Æ÷4¹ýÁ÷
|
{alm = item.alm_ACDC_Mod4_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod5_OverCurr_ID: //110083; //ÕûÁ÷Æ÷5¹ýÁ÷
|
{alm = item.alm_ACDC_Mod5_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod6_OverCurr_ID: //110084; //ÕûÁ÷Æ÷6¹ýÁ÷
|
{alm = item.alm_ACDC_Mod6_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod7_OverCurr_ID: //110085; //ÕûÁ÷Æ÷7¹ýÁ÷
|
{alm = item.alm_ACDC_Mod7_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod8_OverCurr_ID: //110086; //ÕûÁ÷Æ÷8¹ýÁ÷
|
{alm = item.alm_ACDC_Mod8_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod9_OverCurr_ID: //110087; //ÕûÁ÷Æ÷9¹ýÁ÷
|
{alm = item.alm_ACDC_Mod9_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod10_OverCurr_ID: //110088; //ÕûÁ÷Æ÷10¹ýÁ÷
|
{alm = item.alm_ACDC_Mod10_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod11_OverCurr_ID: //110089; //ÕûÁ÷Æ÷11¹ýÁ÷
|
{alm = item.alm_ACDC_Mod11_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod12_OverCurr_ID: //110090; //ÕûÁ÷Æ÷12¹ýÁ÷
|
{alm = item.alm_ACDC_Mod12_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod13_OverCurr_ID: //110091; //ÕûÁ÷Æ÷13¹ýÁ÷
|
{alm = item.alm_ACDC_Mod13_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod14_OverCurr_ID: //110092; //ÕûÁ÷Æ÷14¹ýÁ÷
|
{alm = item.alm_ACDC_Mod14_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod15_OverCurr_ID: //110093; //ÕûÁ÷Æ÷15¹ýÁ÷
|
{alm = item.alm_ACDC_Mod15_OverCurr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod16_OverCurr_ID: //110094; //ÕûÁ÷Æ÷16¹ýÁ÷
|
{alm = item.alm_ACDC_Mod16_OverCurr;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod1_AC_Err_ID: //110095; //ÕûÁ÷Æ÷1½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod1_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod2_AC_Err_ID: //110096; //ÕûÁ÷Æ÷2½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod2_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod3_AC_Err_ID: //110097; //ÕûÁ÷Æ÷3½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod3_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod4_AC_Err_ID: //110098; //ÕûÁ÷Æ÷4½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod4_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod5_AC_Err_ID: //110099; //ÕûÁ÷Æ÷5½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod5_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod6_AC_Err_ID: //110100; //ÕûÁ÷Æ÷6½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod6_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod7_AC_Err_ID: //110101; //ÕûÁ÷Æ÷7½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod7_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod8_AC_Err_ID: //110102; //ÕûÁ÷Æ÷8½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod8_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod9_AC_Err_ID: //110103; //ÕûÁ÷Æ÷9½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod9_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod10_AC_Err_ID: //110104; //ÕûÁ÷Æ÷10½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod10_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod11_AC_Err_ID: //110105; //ÕûÁ÷Æ÷11½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod11_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod12_AC_Err_ID: //110106; //ÕûÁ÷Æ÷12½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod12_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod13_AC_Err_ID: //110107; //ÕûÁ÷Æ÷13½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod13_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod14_AC_Err_ID: //110108; //ÕûÁ÷Æ÷14½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod14_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod15_AC_Err_ID: //110109; //ÕûÁ÷Æ÷15½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod15_AC_Err;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_Mod16_AC_Err_ID: //110110; //ÕûÁ÷Æ÷16½»Á÷Òì³£
|
{alm = item.alm_ACDC_Mod16_AC_Err;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_Trip_ID: //110111; //½»Á÷ÊäÈë1ÌøÕ¢
|
{alm = item.alm_ACDC_AcIn1_Trip;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_Trip_ID: //110112; //½»Á÷ÊäÈë2ÌøÕ¢
|
{alm = item.alm_ACDC_AcIn2_Trip;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_Fuse_ID: //110113; //½»Á÷ÊäÈë1ÈÛË¿¸æ¾¯
|
{alm = item.alm_ACDC_AcIn1_Fuse;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_Fuse_ID: //110114; //½»Á÷ÊäÈë2ÈÛË¿¸æ¾¯
|
{alm = item.alm_ACDC_AcIn2_Fuse;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_Unbalance_ID: //110115; //½»Á÷ÊäÈë1ÈýÏ಻ƽºâ
|
{alm = item.alm_ACDC_AcIn1_Unbalance;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_Unbalance_ID: //110116; //½»Á÷ÊäÈë2ÈýÏ಻ƽºâ
|
{alm = item.alm_ACDC_AcIn2_Unbalance;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_FreqErr_ID: //110117; //½»Á÷ÊäÈë1ƵÂÊÒì³£
|
{alm = item.alm_ACDC_AcIn1_FreqErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn2_FreqErr_ID: //110118; //½»Á÷ÊäÈë2ƵÂÊÒì³£
|
{alm = item.alm_ACDC_AcIn2_FreqErr;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_CPSS_CommErr_ID: //110119; //ÐתͨÐŹÊÕÏ
|
{alm = item.alm_ACDC_CPSS_CommErr;}break;
|
|
//1+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
case PwrDeviceAlarm_Data.ALM_TYPE_PWRDEV_CommErr_ID: //110120; //µçԴͨÐŹÊÕÏ
|
{alm = item.alm_PWRDEV_CommErr;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_User_AcIn1_PowerDown_ID: //110121; //½»Á÷ÊäÈë1Í£µç
|
{alm = item.alm_User_AcIn1_PowerDown;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_User_AcIn2_PowerDown_ID: //110122; //½»Á÷ÊäÈë2Í£µç
|
{alm = item.alm_User_AcIn2_PowerDown;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_User_AcIn1_CommErr_ID: //110123; //½»Á÷1²É¼¯Í¨ÐŹÊÕÏ
|
{alm = item.alm_User_AcIn1_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_User_AcIn2_CommErr_ID: //110124; //½»Á÷2²É¼¯Í¨ÐŹÊÕÏ
|
{alm = item.alm_User_AcIn2_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Temp1_CommErr_ID: //110125; //θÐ1ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Temp1_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Temp2_CommErr_ID: //110126; //θÐ2ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Temp2_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Temp3_CommErr_ID: //110127; //θÐ3ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Temp3_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Humi1_CommErr_ID: //110128; //ʪ¸Ð1ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Humi1_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Humi2_CommErr_ID: //110129; //ʪ¸Ð2ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Humi2_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Humi3_CommErr_ID: //110130; //ʪ¸Ð3ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Humi3_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Smoke1_Occur_ID: //110131; //Ñ̸Ð1±¨¾¯
|
{alm = item.alm_Envm_Smoke1_Occur;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Smoke2_Occur_ID: //110132; //Ñ̸Ð2±¨¾¯
|
{alm = item.alm_Envm_Smoke2_Occur;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Smoke3_Occur_ID: //110133; //Ñ̸Ð3±¨¾¯
|
{alm = item.alm_Envm_Smoke3_Occur;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Smoke1_CommErr_ID: //110134; //Ñ̸Ð1ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Smoke1_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Smoke2_CommErr_ID: //110135; //Ñ̸Ð2ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Smoke2_CommErr;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_Envm_Smoke3_CommErr_ID: //110136; //Ñ̸Ð3ͨÐŹÊÕÏ
|
{alm = item.alm_Envm_Smoke3_CommErr;}break;
|
|
/********************* 2023-07-28 ÐÂÔöµçÔ´¸æ¾¯ ************************************************/
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_OverV_Second_ID: //110137; //2·½»Á÷AÏà¹ýѹ
|
{alm = item.alm_ACDC_AcIn1_A_OverV_Second;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_UnderV_Second_ID: //110138; //2·½»Á÷AÏàǷѹ
|
{alm = item.alm_ACDC_AcIn1_A_UnderV_Second;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_A_Less_Second_ID: //110139; //2·½»Á÷AÏàȱÏà
|
{alm = item.alm_ACDC_AcIn1_A_Less_Second;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_OverV_Second_ID: //110140; //2·½»Á÷BÏà¹ýѹ
|
{alm = item.alm_ACDC_AcIn1_B_OverV_Second;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_UnderV_Second_ID: //110141; //2·½»Á÷BÏàǷѹ
|
{alm = item.alm_ACDC_AcIn1_B_UnderV_Second;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_B_Less_Second_ID: //110142; //2·½»Á÷BÏàȱÏà
|
{alm = item.alm_ACDC_AcIn1_B_Less_Second;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_OverV_Second_ID: //110143; //2·½»Á÷CÏà¹ýѹ
|
{alm = item.alm_ACDC_AcIn1_C_OverV_Second;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_UnderV_Second_ID: //110144; //2·½»Á÷CÏàǷѹ
|
{alm = item.alm_ACDC_AcIn1_C_UnderV_Second;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_AcIn1_C_Less_Second_ID: //110145; //2·½»Á÷CÏàȱÏà
|
{alm = item.alm_ACDC_AcIn1_C_Less_Second;}break;
|
|
case PwrDeviceAlarm_Data.ALM_TYPE_PWRDEV_ERROR_ID: //110146; //µçÔ´¸æ¾¯
|
{alm = item.alm_PWRDEV_ERROR;}break;
|
case PwrDeviceAlarm_Data.ALM_TYPE_ACDC_PowerDown_CommErr_ID: //110147; //½»Á÷Í£µçͨÐŹÊÕÏ
|
{alm = item.alm_ACDC_PowerDown_CommErr;}break;
|
}
|
if(null != alm) {
|
alm.pwrdev_id = item.PowerDevDeviceId;
|
|
alm.RecId = res.getLong("record_id");
|
alm.alm_type = alm_type; //¸æ¾¯id
|
alm.alm_cleared_type = res.getInt("alm_cleared_type"); //¸æ¾¯ÀàÐÍ 0:ʵʱ¸æ¾¯ 1:ÀúÊ·¸æ¾¯ 2:È¡Ïû¸æ¾¯
|
alm.alm_vlaue = res.getFloat("alm_value"); //¸æ¾¯Öµ
|
alm.alm_severity = res.getInt("alm_severity"); //¸æ¾¯×´Ì¬
|
alm.alm_level = res.getInt("alm_level"); //¸æ¾¯µÈ¼¶
|
alm.alm_start_time = res.getTimestamp("alm_start_time"); //¸æ¾¯¿ªÊ¼Ê±¼ä
|
alm.alm_trigger = res.getInt("alm_trigger"); //¸æ¾¯´¥·¢À´Ô´
|
|
//System.out.println(alm);
|
|
}
|
}
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
}
|
}
|
sql.close_con();
|
}
|
|
}
|
|
|
/**
|
* ²éѯBTSÉ豸µÄÉ豸¹¤×÷״̬ÒÔ¼°µç³Ø×é״̬
|
* @param pool
|
* @param rtpd
|
*/
|
public static void readStateionBTSState(MysqlConnPool pool, PowerData_RT rtpd) {
|
String sql_str = " SELECT dev_workstate,batt_state " +
|
" FROM db_battinf.tb_battinf,db_ram_db.tb_batt_rtstate,db_ram_db.tb_fbs9100_state " +
|
" WHERE FBSDeviceId = dev_id AND tb_battinf.BattGroupId = tb_batt_rtstate.BattGroupId " +
|
" AND StationId = '" + rtpd.StationId + "'";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
res = sql.sqlMysqlQuery(sql_str);
|
try {
|
if(res.next()) {
|
rtpd.dev_wrokstate = res.getInt("dev_workstate");
|
rtpd.batt_state = res.getInt("batt_state");
|
}
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
sql.logger.error(e.toString(), e);
|
}
|
}
|
sql.close_con();
|
}
|
|
|
}
|
|
|
/**
|
* ¶Áȡƽ̨¸æ¾¯ÅäÖòÎÊý
|
* @param pool
|
* @param appParam
|
*/
|
public static void queryAppAlmParam(MysqlConnPool pool,Map<Integer, AppAlm_Param> appParam) {
|
String sql_str = " SELECT alm_id,alm_auto_clear_en,alm_auto_clear_en,alm_category,alm_name FROM db_param.tb_appalm_param ";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
res = sql.sqlMysqlQuery(sql_str);
|
while(res.next()) {
|
int alm_id = res.getInt("alm_id");
|
AppAlm_Param appAlm = appParam.get(alm_id);
|
if(null != appAlm) {
|
//¸üе±Ç°ÅäÖòÎÊý
|
|
appAlm.setAlm_auto_clear_en(res.getInt("alm_auto_clear_en"));
|
}else {
|
AppAlm_Param param = new AppAlm_Param();
|
param.setAlm_id(res.getInt("alm_id"));
|
param.setAlm_auto_clear_en(res.getInt("alm_auto_clear_en"));
|
param.setAlm_name(res.getString("alm_name"));
|
param.setAlm_category(res.getInt("alm_category"));
|
|
appParam.put(alm_id, param);
|
}
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
} finally{
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
|
}
|
