/// <summary> /// Syn Load Alarms /// </summary> /// <param name="lscId">lscId</param> /// <param name="connectionString">connectionString</param> /// <returns>Load Alarms</returns> public List <LoadAlarmInfo> SynLoadAlarms(int lscId, string connectionString) { SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int) }; parms[0].Value = lscId; var alarms = new List <LoadAlarmInfo>(); SqlHelper.TestConnection(connectionString); using (var dt = SqlHelper.ExecuteTable(connectionString, CommandType.Text, SqlText.SQL_SELECT_ALARM_SYNLOADALARMS, parms)) { if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { var alarm = new LoadAlarmInfo(); alarm.LscID = ComUtility.DBNullInt32Handler(dr["LscID"]); alarm.Area1Name = ComUtility.DBNullStringHandler(dr["Area1Name"]); alarm.Area2Name = ComUtility.DBNullStringHandler(dr["Area2Name"]); alarm.Area3Name = ComUtility.DBNullStringHandler(dr["Area3Name"]); alarm.Area4Name = String.Empty; alarm.StaName = ComUtility.DBNullStringHandler(dr["StaName"]); alarm.DevID = ComUtility.DBNullInt32Handler(dr["DevID"]); alarm.DevName = ComUtility.DBNullStringHandler(dr["DevName"]); alarm.DevTypeID = ComUtility.DBNullInt32Handler(dr["DevTypeID"]); alarm.AlarmStatus = ComUtility.DBNullInt32Handler(dr["AlarmStatus"]); alarm.AlarmLevel = ComUtility.DBNullInt32Handler(dr["AlarmLevel"]); alarm.RateValue = ComUtility.DBNullFloatHandler(dr["RateValue"]); alarm.LoadValue = ComUtility.DBNullFloatHandler(dr["LoadValue"]); alarm.LoadPercent = ComUtility.DBNullFloatHandler(dr["LoadPercent"]); alarm.RightPercent = ComUtility.DBNullFloatHandler(dr["RightPercent"]); alarm.StartTime = ComUtility.DBNullDateTimeHandler(dr["StartTime"]); alarm.EventTime = ComUtility.DBNullDateTimeHandler(dr["EventTime"]); alarm.ConfirmName = ComUtility.DBNullStringHandler(dr["ConfirmName"]); alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(dr["ConfirmTime"]); alarm.EndName = ComUtility.DBNullStringHandler(dr["EndName"]); alarm.EndTime = ComUtility.DBNullDateTimeHandler(dr["EndTime"]); alarm.StartIsAddAlarmList = ComUtility.DBNullBooleanHandler(dr["StartIsAddAlarmList"]); alarm.EndIsAddAlarmList = ComUtility.DBNullBooleanHandler(dr["EndIsAddAlarmList"]); alarm.ConfirmIsAddAlarmList = ComUtility.DBNullBooleanHandler(dr["ConfirmIsAddAlarmList"]); alarms.Add(alarm); } SqlHelper.ExecuteBulkCopy(SqlHelper.ConnectionStringLocalTransaction, SqlText.TN_LoadAlarm, dt); } } return(alarms); }
/// <summary> /// Method to get load alarms /// </summary> public List <LoadAlarmInfo> GetLoadAlarms() { var alarms = new List <LoadAlarmInfo>(); var sqlText = @" ;WITH Alarms AS ( SELECT LA.*,L.[LscName],DT.[TypeName] AS [DevTypeName] FROM [dbo].[TA_LoadAlarm] LA INNER JOIN [dbo].[TM_DEV] TD ON LA.[LscID] = TD.[LscID] AND LA.[DevID] = TD.[DevID] INNER JOIN [dbo].[TM_LSC] L ON TD.[LscID] = L.[LscID] LEFT OUTER JOIN [dbo].[TC_DeviceType] DT ON TD.[DevTypeID] = DT.[TypeID] ) SELECT [LscID],[LscName],[Area1Name],[Area2Name],[Area3Name],[StaName],[DevID],[DevName], [DevTypeID],[DevTypeName],[AlarmLevel],[RateValue],[LoadValue],[LoadPercent],[RightPercent], [StartTime],[ConfirmName],[ConfirmTime],[EndName],[EndTime] FROM Alarms;"; using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sqlText, null)) { while (rdr.Read()) { var alarm = new LoadAlarmInfo(); alarm.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]); alarm.LscName = ComUtility.DBNullStringHandler(rdr["LscName"]); alarm.Area1Name = ComUtility.DBNullStringHandler(rdr["Area1Name"]); alarm.Area2Name = ComUtility.DBNullStringHandler(rdr["Area2Name"]); alarm.Area3Name = ComUtility.DBNullStringHandler(rdr["Area3Name"]); alarm.StaName = ComUtility.DBNullStringHandler(rdr["StaName"]); alarm.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]); alarm.DevName = ComUtility.DBNullStringHandler(rdr["DevName"]); alarm.DevTypeID = ComUtility.DBNullInt32Handler(rdr["DevTypeID"]); alarm.DevTypeName = ComUtility.DBNullStringHandler(rdr["DevTypeName"]); alarm.AlarmLevel = ComUtility.DBNullAlarmLevelHandler(rdr["AlarmLevel"]); alarm.RateValue = ComUtility.DBNullFloatHandler(rdr["RateValue"]); alarm.LoadValue = ComUtility.DBNullFloatHandler(rdr["LoadValue"]); alarm.LoadPercent = ComUtility.DBNullFloatHandler(rdr["LoadPercent"]); alarm.RightPercent = ComUtility.DBNullFloatHandler(rdr["RightPercent"]); alarm.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]); alarm.ConfirmName = ComUtility.DBNullStringHandler(rdr["ConfirmName"]); alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(rdr["ConfirmTime"]); alarm.EndName = ComUtility.DBNullStringHandler(rdr["EndName"]); alarm.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]); alarms.Add(alarm); } } return(alarms); }
/// <summary> /// Method to get history load alarms /// </summary> public List <LoadAlarmInfo> GetHisLoadAlarms(int lscId, string lscName, string area1Name, string area2Name, string area3Name, string staName, int devId, DateTime beginTime, DateTime endTime, DateTime confirmBeginTime, DateTime confirmEndTime, string confirmName, DateTime endBeginTime, DateTime endEndTime, string endName) { 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("@StaName", SqlDbType.NVarChar, 40), new SqlParameter("@DevID", SqlDbType.Int), new SqlParameter("@BeginTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@ConfirmBeginTime", SqlDbType.DateTime), new SqlParameter("@ConfirmEndTime", SqlDbType.DateTime), new SqlParameter("@ConfirmName", SqlDbType.NVarChar, 20), new SqlParameter("@EndBeginTime", SqlDbType.DateTime), new SqlParameter("@EndEndTime", SqlDbType.DateTime), new SqlParameter("@EndName", SqlDbType.NVarChar, 20) }; parms[0].Value = lscId; if (area1Name == ComUtility.DefaultString) { parms[1].Value = DBNull.Value; } else { parms[1].Value = area1Name; } if (area2Name == ComUtility.DefaultString) { parms[2].Value = DBNull.Value; } else { parms[2].Value = area2Name; } if (area3Name == ComUtility.DefaultString) { parms[3].Value = DBNull.Value; } else { parms[3].Value = area3Name; } if (staName == ComUtility.DefaultString) { parms[4].Value = DBNull.Value; } else { parms[4].Value = staName; } if (devId == ComUtility.DefaultInt32) { parms[5].Value = DBNull.Value; } else { parms[5].Value = devId; } if (beginTime == ComUtility.DefaultDateTime) { parms[6].Value = DBNull.Value; } else { parms[6].Value = beginTime; } if (endTime == ComUtility.DefaultDateTime) { parms[7].Value = DBNull.Value; } else { parms[7].Value = endTime; } if (confirmBeginTime == ComUtility.DefaultDateTime) { parms[8].Value = DBNull.Value; } else { parms[8].Value = confirmBeginTime; } if (confirmEndTime == ComUtility.DefaultDateTime) { parms[9].Value = DBNull.Value; } else { parms[9].Value = confirmEndTime; } if (confirmName == ComUtility.DefaultString) { parms[10].Value = DBNull.Value; } else { parms[10].Value = confirmName; } if (endBeginTime == ComUtility.DefaultDateTime) { parms[11].Value = DBNull.Value; } else { parms[11].Value = endBeginTime; } if (endEndTime == ComUtility.DefaultDateTime) { parms[12].Value = DBNull.Value; } else { parms[12].Value = endEndTime; } if (endName == ComUtility.DefaultString) { parms[13].Value = DBNull.Value; } else { parms[13].Value = endName; } var alarms = new List <LoadAlarmInfo>(); using (var rdr = SqlHelper.ExecuteReader(SqlHelper.HisConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_PREALARM_GETHISLOADALARMS, parms)) { while (rdr.Read()) { var alarm = new LoadAlarmInfo(); alarm.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]); alarm.LscName = lscName; alarm.Area1Name = ComUtility.DBNullStringHandler(rdr["Area1Name"]); alarm.Area2Name = ComUtility.DBNullStringHandler(rdr["Area2Name"]); alarm.Area3Name = ComUtility.DBNullStringHandler(rdr["Area3Name"]); alarm.StaName = ComUtility.DBNullStringHandler(rdr["StaName"]); alarm.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]); alarm.DevName = ComUtility.DBNullStringHandler(rdr["DevName"]); alarm.DevTypeID = ComUtility.DBNullInt32Handler(rdr["DevTypeID"]); alarm.AlarmLevel = ComUtility.DBNullAlarmLevelHandler(rdr["AlarmLevel"]); alarm.RateValue = ComUtility.DBNullFloatHandler(rdr["RateValue"]); alarm.LoadValue = ComUtility.DBNullFloatHandler(rdr["LoadValue"]); alarm.LoadPercent = ComUtility.DBNullFloatHandler(rdr["LoadPercent"]); alarm.RightPercent = ComUtility.DBNullFloatHandler(rdr["RightPercent"]); alarm.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]); alarm.ConfirmName = ComUtility.DBNullStringHandler(rdr["ConfirmName"]); alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(rdr["ConfirmTime"]); alarm.EndName = ComUtility.DBNullStringHandler(rdr["EndName"]); alarm.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]); alarms.Add(alarm); } } return(alarms); }