/// <summary>
/// Get history alarm condition
/// </summary>
/// <returns>history alarm condition</returns>
private HisAlarmConditionInfo GetCondition()
{
var condition = new HisAlarmConditionInfo();
condition.LscItem = new ListItemInfo()
{
Value = LscsComboBox.SelectedItem.Value, Text = LscsComboBox.SelectedItem.Text, SelectedIndex = LscsComboBox.SelectedIndex
};
condition.Area1Item = new ListItemInfo()
{
Value = WebUtility.DefaultItemID, Text = WebUtility.DefaultItemName, SelectedIndex = -1
};
condition.Area2Item = new ListItemInfo()
{
Value = Area2ComboBox.SelectedItem.Value, Text = Area2ComboBox.SelectedItem.Text, SelectedIndex = Area2ComboBox.SelectedIndex
};
condition.Area3Item = new ListItemInfo()
{
Value = Area3ComboBox.SelectedItem.Value, Text = Area3ComboBox.SelectedItem.Text, SelectedIndex = Area3ComboBox.SelectedIndex
};
condition.Area4Item = new ListItemInfo()
{
Value = WebUtility.DefaultItemID, Text = WebUtility.DefaultItemName, SelectedIndex = -1
};
condition.StaItem = new ListItemInfo()
{
Value = StaComboBox.SelectedItem.Value, Text = StaComboBox.SelectedItem.Text, SelectedIndex = StaComboBox.SelectedIndex
};
condition.DevItem = new ListItemInfo()
{
Value = DevComboBox.SelectedItem.Value, Text = DevComboBox.SelectedItem.Text, SelectedIndex = DevComboBox.SelectedIndex
};
condition.NodeItem = new ListItemInfo()
{
Value = NodeComboBox.SelectedItem.Value, Text = NodeComboBox.SelectedItem.Text, SelectedIndex = NodeComboBox.SelectedIndex
};
condition.AlarmDevItem = new ListItemInfo()
{
Value = AlarmDevComboBox.SelectedItem.Value, Text = AlarmDevComboBox.SelectedItem.Text, SelectedIndex = AlarmDevComboBox.SelectedIndex
};
condition.AlarmLogicItem = new ListItemInfo()
{
Value = AlarmLogicComboBox.SelectedItem.Value, Text = AlarmLogicComboBox.SelectedItem.Text, SelectedIndex = AlarmLogicComboBox.SelectedIndex
};
condition.AlarmNameItem = new ListItemInfo()
{
Value = AlarmNameComboBox.SelectedItem.Value, Text = AlarmNameComboBox.SelectedItem.Text, SelectedIndex = AlarmNameComboBox.SelectedIndex
};
var levels = new string[AlarmLevelMultiCombo.SelectedItems.Count];
for (int i = 0; i < levels.Length; i++)
{
levels[i] = AlarmLevelMultiCombo.SelectedItems[i].Value;
}
condition.AlarmLevelItems = levels;
condition.ConfirmNameText = ConfirmNameTextField.Text.Trim();
condition.BeginFromTimeText = BeginFromDate.Text.Trim();
condition.BeginToTimeText = BeginToDate.Text.Trim();
condition.EndFromTimeText = EndFromDate.Text.Trim();
condition.EndToTimeText = EndToDate.Text.Trim();
condition.ConfirmFromTimeText = ConfirmFromDate.Text.Trim();
condition.ConfirmToTimeText = ConfirmToDate.Text.Trim();
condition.MinDelay = Double.MinValue;
if (FromMinNumberField.Number > 0)
{
condition.MinDelay = TimeSpan.FromMinutes(FromMinNumberField.Number).TotalSeconds;
}
condition.MaxDelay = Double.MaxValue;
if (ToMinNumberField.Number > 0)
{
condition.MaxDelay = TimeSpan.FromMinutes(ToMinNumberField.Number).TotalSeconds;
}
return(condition);
}
public List <AlarmInfo> GetHisAlarms(Int32 lscId, String lscName, List <StandardProtocolInfo> protocols, List <GroupTreeInfo> groupNodes, HisAlarmConditionInfo condition)
{
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@Area1Name", SqlDbType.NVarChar, 40),
new SqlParameter("@Area2Name", SqlDbType.NVarChar, 40),
new SqlParameter("@Area3Name", SqlDbType.NVarChar, 40),
new SqlParameter("@Area4Name", SqlDbType.NVarChar, 40),
new SqlParameter("@StaName", SqlDbType.NVarChar, 40),
new SqlParameter("@DevName", SqlDbType.NVarChar, 40),
new SqlParameter("@NodeName", SqlDbType.NVarChar, 40),
new SqlParameter("@AlarmDevName", SqlDbType.NVarChar, 40),
new SqlParameter("@AlarmLogicName", SqlDbType.NVarChar, 40),
new SqlParameter("@AlarmName", SqlDbType.NVarChar, 40),
new SqlParameter("@AlarmLevels", SqlDbType.NVarChar, 50),
new SqlParameter("@BeginFromTime", SqlDbType.DateTime),
new SqlParameter("@BeginToTime", SqlDbType.DateTime),
new SqlParameter("@EndFromTime", SqlDbType.DateTime),
new SqlParameter("@EndToTime", SqlDbType.DateTime),
new SqlParameter("@ConfirmName", SqlDbType.NVarChar, 20),
new SqlParameter("@ConfirmFromTime", SqlDbType.DateTime),
new SqlParameter("@ConfirmToTime", SqlDbType.DateTime),
new SqlParameter("@MinDelay", SqlDbType.Real),
new SqlParameter("@MaxDelay", SqlDbType.Real),
new SqlParameter("@MHArea1", SqlDbType.Bit),
new SqlParameter("@MHArea2", SqlDbType.Bit),
new SqlParameter("@MHArea3", SqlDbType.Bit),
new SqlParameter("@MHArea4", SqlDbType.Bit),
new SqlParameter("@MHSta", SqlDbType.Bit),
new SqlParameter("@MHDev", SqlDbType.Bit),
new SqlParameter("@MHNode", SqlDbType.Bit) };
parms[0].Value = lscId;
if (condition.Area1Item.Value == null || condition.Area1Item.Value.Equals(ComUtility.DefaultItemID))
{
parms[1].Value = DBNull.Value;
}
else
{
parms[1].Value = condition.Area1Item.Text;
}
if (condition.Area2Item.Value == null || condition.Area2Item.Value.Equals(ComUtility.DefaultItemID))
{
parms[2].Value = DBNull.Value;
}
else
{
parms[2].Value = condition.Area2Item.Text;
}
if (condition.Area3Item.Value == null || condition.Area3Item.Value.Equals(ComUtility.DefaultItemID))
{
parms[3].Value = DBNull.Value;
}
else
{
parms[3].Value = condition.Area3Item.Text;
}
if (condition.Area4Item.Value == null || condition.Area4Item.Value.Equals(ComUtility.DefaultItemID))
{
parms[4].Value = DBNull.Value;
}
else
{
parms[4].Value = condition.Area4Item.Text;
}
if (condition.StaItem.Value == null || condition.StaItem.Value.Equals(ComUtility.DefaultItemID))
{
parms[5].Value = DBNull.Value;
}
else
{
parms[5].Value = condition.StaItem.Text;
}
if (condition.DevItem.Value == null || condition.DevItem.Value.Equals(ComUtility.DefaultItemID))
{
parms[6].Value = DBNull.Value;
}
else
{
parms[6].Value = condition.DevItem.Text;
}
if (condition.NodeItem.Value == null || condition.NodeItem.Value.Equals(ComUtility.DefaultItemID))
{
parms[7].Value = DBNull.Value;
}
else
{
parms[7].Value = condition.NodeItem.Text;
}
if (condition.AlarmDevItem.Value.Equals(ComUtility.DefaultItemID))
{
parms[8].Value = DBNull.Value;
}
else
{
parms[8].Value = condition.AlarmDevItem.Text;
}
if (condition.AlarmLogicItem.Value.Equals(ComUtility.DefaultItemID))
{
parms[9].Value = DBNull.Value;
}
else
{
parms[9].Value = condition.AlarmLogicItem.Text;
}
if (condition.AlarmNameItem.Value.Equals(ComUtility.DefaultItemID))
{
parms[10].Value = DBNull.Value;
}
else
{
parms[10].Value = condition.AlarmNameItem.Text;
}
if (condition.AlarmLevelItems.Length <= 0)
{
parms[11].Value = DBNull.Value;
}
else
{
parms[11].Value = String.Join(",", condition.AlarmLevelItems);
}
if (String.IsNullOrEmpty(condition.BeginFromTimeText))
{
parms[12].Value = DBNull.Value;
}
else
{
parms[12].Value = condition.BeginFromTimeText;
}
if (String.IsNullOrEmpty(condition.BeginToTimeText))
{
parms[13].Value = DBNull.Value;
}
else
{
parms[13].Value = condition.BeginToTimeText;
}
if (String.IsNullOrEmpty(condition.EndFromTimeText))
{
parms[14].Value = DBNull.Value;
}
else
{
parms[14].Value = condition.EndFromTimeText;
}
if (String.IsNullOrEmpty(condition.EndToTimeText))
{
parms[15].Value = DBNull.Value;
}
else
{
parms[15].Value = condition.EndToTimeText;
}
if (String.IsNullOrEmpty(condition.ConfirmNameText))
{
parms[16].Value = DBNull.Value;
}
else
{
parms[16].Value = condition.ConfirmNameText;
}
if (String.IsNullOrEmpty(condition.ConfirmFromTimeText))
{
parms[17].Value = DBNull.Value;
}
else
{
parms[17].Value = condition.ConfirmFromTimeText;
}
if (String.IsNullOrEmpty(condition.ConfirmToTimeText))
{
parms[18].Value = DBNull.Value;
}
else
{
parms[18].Value = condition.ConfirmToTimeText;
}
if (condition.MinDelay == Double.MinValue)
{
parms[19].Value = DBNull.Value;
}
else
{
parms[19].Value = condition.MinDelay;
}
if (condition.MaxDelay == Double.MaxValue)
{
parms[20].Value = DBNull.Value;
}
else
{
parms[20].Value = condition.MaxDelay;
}
parms[21].Value = condition.Area1Item.SelectedIndex == -1;
parms[22].Value = condition.Area2Item.SelectedIndex == -1;
parms[23].Value = condition.Area3Item.SelectedIndex == -1;
parms[24].Value = condition.Area4Item.SelectedIndex == -1;
parms[25].Value = condition.StaItem.SelectedIndex == -1;
parms[26].Value = condition.DevItem.SelectedIndex == -1;
parms[27].Value = condition.NodeItem.SelectedIndex == -1;
var alarms = new List <AlarmInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.HisConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_ALARM_GETHISALARMS, parms)) {
while (rdr.Read())
{
var alarm = new AlarmInfo();
alarm.LscID = lscId;
alarm.LscName = lscName;
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.DevDesc = ComUtility.DefaultString;
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.AlarmStatus = EnmAlarmStatus.Ended;
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.AuxSet = ComUtility.DefaultString;
alarm.ProjName = ComUtility.DBNullStringHandler(rdr["ProjName"]);
alarm.TurnCount = 0;
alarm.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]);
alarms.Add(alarm);
}
}
if (alarms.Count > 0)
{
alarms = (from alarm in alarms
join node in groupNodes on ComUtility.GetDevID(alarm.NodeID) equals node.NodeID
join sp in protocols on alarm.AlarmID equals sp.AlarmID into tp
from dl in tp.DefaultIfEmpty()
select new AlarmInfo {
LscID = alarm.LscID,
LscName = alarm.LscName,
SerialNO = alarm.SerialNO,
Area1Name = alarm.Area1Name,
Area2Name = alarm.Area2Name,
Area3Name = alarm.Area3Name,
Area4Name = alarm.Area4Name,
StaName = alarm.StaName,
DevName = alarm.DevName,
DevDesc = alarm.DevDesc,
NodeID = alarm.NodeID,
NodeType = alarm.NodeType,
NodeName = alarm.NodeName,
AlarmID = alarm.AlarmID,
AlarmValue = alarm.AlarmValue,
AlarmLevel = alarm.AlarmLevel,
AlarmStatus = alarm.AlarmStatus,
AlarmDesc = alarm.AlarmDesc,
AuxAlarmDesc = alarm.AuxAlarmDesc,
StartTime = alarm.StartTime,
EndTime = alarm.EndTime,
ConfirmName = alarm.ConfirmName,
ConfirmMarking = alarm.ConfirmMarking,
ConfirmTime = alarm.ConfirmTime,
AuxSet = alarm.AuxSet,
ProjName = alarm.ProjName,
TurnCount = alarm.TurnCount,
UpdateTime = alarm.UpdateTime,
NMAlarmID = (dl == null ? ComUtility.DefaultString : dl.NMAlarmID),
AlarmName = (dl == null ? ComUtility.DefaultString : dl.AlarmName),
AlarmClass = (dl == null ? ComUtility.DefaultString : dl.AlarmClass),
AlarmDeviceTypeID = (dl == null ? ComUtility.DefaultInt32 : dl.AlarmDeviceTypeID),
AlarmDeviceType = (dl == null ? ComUtility.DefaultString : dl.AlarmDeviceType),
AlarmLogTypeID = (dl == null ? ComUtility.DefaultInt32 : dl.AlarmLogTypeID),
AlarmLogType = (dl == null ? ComUtility.DefaultString : dl.AlarmLogType)
}).ToList();
}
return(alarms);
}
public List <AlarmInfo> GetHisAlarms(int lscId, string lscName, List <StandardProtocolInfo> protocols, List <GroupTreeInfo> groupNodes, HisAlarmConditionInfo condition)
{
try {
return(alarmDal.GetHisAlarms(lscId, lscName, protocols, groupNodes, condition));
} catch {
throw;
}
}
