/// <summary>
/// DBNull Alarm Level Checker
/// </summary>
/// <param name="val">val</param>
public static object DBNullAlarmLevelChecker(EnmAlarmLevel val)
{
if (val == EnmAlarmLevel.NoAlarm)
{
return(DBNull.Value);
}
return((Int32)val);
}
public static Color GetAlarmColor(EnmAlarmLevel level)
{
switch (level)
{
case EnmAlarmLevel.Level1:
return(Color.Red);
case EnmAlarmLevel.Level2:
return(Color.Orange);
case EnmAlarmLevel.Level3:
return(Color.Yellow);
case EnmAlarmLevel.Level4:
return(Color.SkyBlue);
default:
return(Color.White);
}
}
/// <summary>
/// Method to get treeview icon key.
/// </summary>
/// <param name="status">alarm status</param>
/// <returns>icon key</returns>
public static String GetTreeViewIcon(EnmAlarmLevel status)
{
switch (status)
{
case EnmAlarmLevel.Critical:
return("AL1");
case EnmAlarmLevel.Major:
return("AL2");
case EnmAlarmLevel.Minor:
return("AL3");
case EnmAlarmLevel.Hint:
return("AL4");
default:
return("AL0");
}
}
/// <summary>
/// Method to get alarm level name
/// </summary>
/// <param name="level">level</param>
public static string GetAlarmLevelName(EnmAlarmLevel level)
{
switch (level)
{
case EnmAlarmLevel.NoAlarm:
return("全部告警");
case EnmAlarmLevel.Critical:
return("一级告警");
case EnmAlarmLevel.Major:
return("二级告警");
case EnmAlarmLevel.Minor:
return("三级告警");
case EnmAlarmLevel.Hint:
return("四级告警");
default:
return("Undefined");
}
}
public static string GetAlarmDisplay(EnmAlarmLevel level)
{
switch (level)
{
case EnmAlarmLevel.NoAlarm:
return("无告警");
case EnmAlarmLevel.Level1:
return("一级告警");
case EnmAlarmLevel.Level2:
return("二级告警");
case EnmAlarmLevel.Level3:
return("三级告警");
case EnmAlarmLevel.Level4:
return("四级告警");
default:
return("Undefined");
}
}
/// <summary>
/// Method to get excel alarm color
/// </summary>
/// <param name="level">level</param>
public static Excel.Color GetExcelAlarmColor(EnmAlarmLevel level)
{
switch (level)
{
case EnmAlarmLevel.NoAlarm:
return(Excel.Colors.White);
case EnmAlarmLevel.Critical:
return(Excel.Colors.Red);
case EnmAlarmLevel.Major:
return(Excel.Colors.Default34);
case EnmAlarmLevel.Minor:
return(Excel.Colors.Yellow);
case EnmAlarmLevel.Hint:
return(Excel.Colors.Default2C);
default:
return(Excel.Colors.White);
}
}
/// <summary>
/// Method to get level color
/// </summary>
/// <param name="level">level</param>
public static Color GetLevelColor(EnmAlarmLevel level)
{
switch (level)
{
case EnmAlarmLevel.NoAlarm:
return(Color.White);
case EnmAlarmLevel.Critical:
return(Color.Red);
case EnmAlarmLevel.Major:
return(Color.Orange);
case EnmAlarmLevel.Minor:
return(Color.Yellow);
case EnmAlarmLevel.Hint:
return(Color.SkyBlue);
default:
return(Color.White);
}
}
/// <summary>
/// Get history alarms.
/// </summary>
/// <param name="area2">area2</param>
/// <param name="area3">area3</param>
/// <param name="sta">sta</param>
/// <param name="dev">dev</param>
/// <param name="node">node</param>
/// <param name="level">level</param>
/// <param name="bfTime">bfTime</param>
/// <param name="btTime">btTime</param>
/// <param name="efTime">efTime</param>
/// <param name="etTime">etTime</param>
/// <param name="fInterval">fInterval</param>
/// <param name="eInterval">eInterval</param>
/// <returns>history alarms</returns>
public List <AlarmInfo> GetHisAlarms(String area2, String area3, String sta, String dev, String node, EnmAlarmLevel level, DateTime bfTime, DateTime btTime, DateTime efTime, DateTime etTime, Int32 fInterval, Int32 eInterval)
{
SqlParameter[] parms = { new SqlParameter("@Area2Name", SqlDbType.VarChar, 40),
new SqlParameter("@Area3Name", SqlDbType.VarChar, 40),
new SqlParameter("@StaName", SqlDbType.VarChar, 40),
new SqlParameter("@DevName", SqlDbType.VarChar, 40),
new SqlParameter("@NodeName", SqlDbType.VarChar, 40),
new SqlParameter("@AlarmLevel", SqlDbType.Int),
new SqlParameter("@BeginFromTime", SqlDbType.DateTime),
new SqlParameter("@BeginToTime", SqlDbType.DateTime),
new SqlParameter("@EndFromTime", SqlDbType.DateTime),
new SqlParameter("@EndToTime", SqlDbType.DateTime),
new SqlParameter("@FromInterval", SqlDbType.Int),
new SqlParameter("@EndInterval", SqlDbType.Int) };
parms[0].Value = ComUtility.DBNullStringChecker(area2);
parms[1].Value = ComUtility.DBNullStringChecker(area3);
parms[2].Value = ComUtility.DBNullStringChecker(sta);
parms[3].Value = ComUtility.DBNullStringChecker(dev);
parms[4].Value = ComUtility.DBNullStringChecker(node);
parms[5].Value = ComUtility.DBNullAlarmLevelChecker(level);
parms[6].Value = ComUtility.DBNullDateTimeChecker(bfTime);
parms[7].Value = ComUtility.DBNullDateTimeChecker(btTime);
parms[8].Value = ComUtility.DBNullDateTimeChecker(efTime);
parms[9].Value = ComUtility.DBNullDateTimeChecker(etTime);
parms[10].Value = ComUtility.DBNullInt32Checker(fInterval);
parms[11].Value = ComUtility.DBNullInt32Checker(eInterval);
var alarms = new List <AlarmInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.HisConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_AM_GetHisAlarms, parms)) {
while (rdr.Read())
{
var alarm = new AlarmInfo();
alarm.SerialNO = ComUtility.DBNullInt32Handler(rdr["SerialNO"]);
alarm.Area1Name = ComUtility.DBNullStringHandler(rdr["Area1Name"]);
alarm.Area2Name = ComUtility.DBNullStringHandler(rdr["Area2Name"]);
alarm.Area3Name = ComUtility.DBNullStringHandler(rdr["Area3Name"]);
alarm.Area4Name = ComUtility.DBNullStringHandler(rdr["Area4Name"]);
alarm.StaName = ComUtility.DBNullStringHandler(rdr["StaName"]);
alarm.DevName = ComUtility.DBNullStringHandler(rdr["DevName"]);
alarm.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
alarm.NodeType = ComUtility.DBNullNodeTypeHandler(rdr["NodeType"]);
alarm.NodeName = ComUtility.DBNullStringHandler(rdr["NodeName"]);
alarm.AlarmID = ComUtility.DBNullInt32Handler(rdr["AlarmID"]);
alarm.AlarmValue = ComUtility.DBNullFloatHandler(rdr["AlarmValue"]);
alarm.AlarmLevel = ComUtility.DBNullAlarmLevelHandler(rdr["AlarmLevel"]);
alarm.AlarmDesc = ComUtility.DBNullStringHandler(rdr["AlarmDesc"]);
alarm.AuxAlarmDesc = ComUtility.DBNullStringHandler(rdr["AuxAlarmDesc"]);
alarm.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]);
alarm.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
alarm.ConfirmName = ComUtility.DBNullStringHandler(rdr["ConfirmName"]);
alarm.ConfirmMarking = ComUtility.DBNullConfirmMarkingHandler(rdr["ConfirmMarking"]);
alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(rdr["ConfirmTime"]);
alarm.ProjName = ComUtility.DBNullStringHandler(rdr["ProjName"]);
alarms.Add(alarm);
}
}
return(alarms);
}
