/// <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; } }