public List <A_FAlarm> GetEntities() { var entities = new List <A_FAlarm>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_FAlarm_Repository_GetEntities1, null)) { while (rdr.Read()) { var entity = new A_FAlarm(); entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.SignalId = SqlTypeConverter.DBNullStringHandler(rdr["SignalId"]); entity.SignalNumber = SqlTypeConverter.DBNullStringHandler(rdr["SignalNumber"]); entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]); entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]); entity.AlarmTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AlarmTime"]); entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.AlarmFlag = SqlTypeConverter.DBNullEnmFlagHandler(rdr["AlarmFlag"]); entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]); entity.AlarmValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmValue"]); entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]); entities.Add(entity); } } return(entities); }
public List <A_FAlarm> GetEntities(DateTime start, DateTime end) { SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime), new SqlParameter("@End", SqlDbType.DateTime) }; parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start); parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end); var entities = new List <A_FAlarm>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_FAlarm_Repository_GetEntities2, parms)) { while (rdr.Read()) { var entity = new A_FAlarm(); entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.SignalId = SqlTypeConverter.DBNullStringHandler(rdr["SignalId"]); entity.SignalNumber = SqlTypeConverter.DBNullStringHandler(rdr["SignalNumber"]); entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]); entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]); entity.AlarmTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AlarmTime"]); entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.AlarmFlag = SqlTypeConverter.DBNullEnmFlagHandler(rdr["AlarmFlag"]); entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]); entity.AlarmValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmValue"]); entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]); entities.Add(entity); } } return(entities); }
public A_TAlarm GetEntity(long id) { SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.BigInt) }; parms[0].Value = SqlTypeConverter.DBNullInt64Checker(id); A_TAlarm entity = null; using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_TAlarm_Repository_GetEntity, parms)) { if (rdr.Read()) { entity = new A_TAlarm(); entity.Id = SqlTypeConverter.DBNullInt64Handler(rdr["Id"]); entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.SignalId = SqlTypeConverter.DBNullStringHandler(rdr["SignalId"]); entity.SignalNumber = SqlTypeConverter.DBNullStringHandler(rdr["SignalNumber"]); entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]); entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]); entity.AlarmTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AlarmTime"]); entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.AlarmFlag = SqlTypeConverter.DBNullEnmFlagHandler(rdr["AlarmFlag"]); entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]); entity.AlarmValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmValue"]); entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]); } } return(entity); }
public P_SubPoint GetSubPoint(string point, string statype) { SqlParameter[] parms = { new SqlParameter("@PointId", SqlDbType.VarChar, 100), new SqlParameter("@StationTypeId", SqlDbType.VarChar, 100) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(point); parms[1].Value = SqlTypeConverter.DBNullStringChecker(statype); P_SubPoint entity = null; using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_P_Point_Repository_GetSubPoint, parms)) { if (rdr.Read()) { entity = new P_SubPoint(); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.StationType = new C_StationType { Id = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeName"]) }; entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.TriggerTypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TriggerTypeId"]); entity.AlarmLimit = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmLimit"]); entity.AlarmReturnDiff = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmReturnDiff"]); entity.AlarmRecoveryDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmRecoveryDelay"]); entity.AlarmDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmDelay"]); entity.SavedPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["SavedPeriod"]); entity.StaticPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["StaticPeriod"]); entity.AbsoluteThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["AbsoluteThreshold"]); entity.PerThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["PerThreshold"]); entity.StorageInterval = SqlTypeConverter.DBNullInt32Handler(rdr["StorageInterval"]); } } return(entity); }
public List <P_SubPoint> GetSubPoints() { var entities = new List <P_SubPoint>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_P_Point_Repository_GetSubPoints, null)) { while (rdr.Read()) { var entity = new P_SubPoint(); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.StationType = new C_StationType { Id = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeName"]) }; entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.TriggerTypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TriggerTypeId"]); entity.AlarmLimit = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmLimit"]); entity.AlarmReturnDiff = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmReturnDiff"]); entity.AlarmRecoveryDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmRecoveryDelay"]); entity.AlarmDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmDelay"]); entity.SavedPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["SavedPeriod"]); entity.StaticPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["StaticPeriod"]); entity.AbsoluteThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["AbsoluteThreshold"]); entity.PerThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["PerThreshold"]); entity.StorageInterval = SqlTypeConverter.DBNullInt32Handler(rdr["StorageInterval"]); entities.Add(entity); } } return(entities); }
public List <SubPoint> GetEntitiesInStaType(string id) { SqlParameter[] parms = { new SqlParameter("@StaTypeId", SqlDbType.VarChar, 100) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(id); var entities = new List <SubPoint>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_SubPoint_Repository_GetEntitiesInStaType, parms)) { while (rdr.Read()) { var entity = new SubPoint(); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.StationTypeId = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]); entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.AlarmLimit = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmLimit"]); entity.AlarmDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmDelay"]); entity.AlarmRecoveryDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmRecoveryDelay"]); entity.SavedPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["SavedPeriod"]); entity.AbsoluteThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["AbsoluteThreshold"]); entity.PerThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["PerThreshold"]); entity.StaticPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["StaticPeriod"]); entity.StorageRefTime = SqlTypeConverter.DBNullStringHandler(rdr["StorageRefTime"]); entities.Add(entity); } } return(entities); }
public List <Point> GetEntitiesByProtocol(string protocol) { SqlParameter[] parms = { new SqlParameter("@ProtocolId", SqlDbType.VarChar, 100) }; parms[0].Value = protocol; var entities = new List <Point>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Point_Repository_GetEntitiesByProtcol, parms)) { while (rdr.Read()) { var entity = new Point(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.Type = SqlTypeConverter.DBNullEnmPointHandler(rdr["Type"]); entity.UnitState = SqlTypeConverter.DBNullStringHandler(rdr["UnitState"]); entity.Number = SqlTypeConverter.DBNullStringHandler(rdr["Number"]); entity.AlarmId = SqlTypeConverter.DBNullStringHandler(rdr["AlarmId"]); entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]); entity.StationType = new StationType { Id = SqlTypeConverter.DBNullStringHandler(rdr["StationTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["StationTypeName"]) }; entity.SubDeviceType = new SubDeviceType { Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"]) }; entity.DeviceType = new DeviceType { Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"]) }; entity.SubLogicType = new SubLogicType { Id = SqlTypeConverter.DBNullStringHandler(rdr["SubLogicTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubLogicTypeName"]) }; entity.LogicType = new LogicType { Id = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeName"]) }; entity.AlarmComment = SqlTypeConverter.DBNullStringHandler(rdr["AlarmComment"]); entity.NormalComment = SqlTypeConverter.DBNullStringHandler(rdr["NormalComment"]); entity.DeviceEffect = SqlTypeConverter.DBNullStringHandler(rdr["DeviceEffect"]); entity.BusiEffect = SqlTypeConverter.DBNullStringHandler(rdr["BusiEffect"]); entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.TriggerTypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TriggerTypeId"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]); entity.Interpret = SqlTypeConverter.DBNullStringHandler(rdr["Interpret"]); entity.AlarmLimit = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmLimit"]); entity.AlarmReturnDiff = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmReturnDiff"]); entity.AlarmRecoveryDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmRecoveryDelay"]); entity.AlarmDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmDelay"]); entity.SavedPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["SavedPeriod"]); entity.StaticPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["StaticPeriod"]); entity.AbsoluteThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["AbsoluteThreshold"]); entity.PerThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["PerThreshold"]); entity.ExtSet1 = SqlTypeConverter.DBNullStringHandler(rdr["ExtSet1"]); entity.ExtSet2 = SqlTypeConverter.DBNullStringHandler(rdr["ExtSet2"]); entity.Description = SqlTypeConverter.DBNullStringHandler(rdr["Description"]); entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]); entities.Add(entity); } } return(entities); }
public List <A_HAlarm> GetAlarmsInStation(string id, DateTime start, DateTime end) { SqlParameter[] parms = { new SqlParameter("@StationId", SqlDbType.VarChar, 100), new SqlParameter("@Start", SqlDbType.DateTime), new SqlParameter("@End", SqlDbType.DateTime) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(id); parms[1].Value = SqlTypeConverter.DBNullDateTimeChecker(start); parms[2].Value = SqlTypeConverter.DBNullDateTimeChecker(end); var entities = new List <A_HAlarm>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_HAlarm_Repository_GetAlarmsInStation, parms)) { while (rdr.Read()) { var entity = new A_HAlarm(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]); entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]); entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]); entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]); entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]); entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]); entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.StartValue = SqlTypeConverter.DBNullDoubleHandler(rdr["StartValue"]); entity.EndValue = SqlTypeConverter.DBNullDoubleHandler(rdr["EndValue"]); entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]); entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]); entity.Confirmed = SqlTypeConverter.DBNullEnmConfirmStatusHandler(rdr["Confirmed"]); entity.Confirmer = SqlTypeConverter.DBNullStringHandler(rdr["Confirmer"]); entity.ConfirmedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ConfirmedTime"]); entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]); entity.PrimaryId = SqlTypeConverter.DBNullStringHandler(rdr["PrimaryId"]); entity.RelatedId = SqlTypeConverter.DBNullStringHandler(rdr["RelatedId"]); entity.FilterId = SqlTypeConverter.DBNullStringHandler(rdr["FilterId"]); entity.ReversalId = SqlTypeConverter.DBNullStringHandler(rdr["ReversalId"]); entity.ReversalCount = SqlTypeConverter.DBNullInt32Handler(rdr["ReversalCount"]); entity.Masked = SqlTypeConverter.DBNullBooleanHandler(rdr["Masked"]); entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]); entities.Add(entity); } } return(entities); }
public A_AAlarm GetEntityInPoint(string device, string point) { SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100), new SqlParameter("@PointId", SqlDbType.VarChar, 100) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(device); parms[1].Value = SqlTypeConverter.DBNullStringChecker(point); A_AAlarm entity = null; using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_AAlarm_Repository_GetEntityInPoint, parms)) { if (rdr.Read()) { entity = new A_AAlarm(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]); entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]); entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]); entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]); entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]); entity.AlarmTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AlarmTime"]); entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.AlarmValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmValue"]); entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]); entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]); entity.Confirmed = SqlTypeConverter.DBNullEnmConfirmHandler(rdr["Confirmed"]); entity.Confirmer = SqlTypeConverter.DBNullStringHandler(rdr["Confirmer"]); entity.ConfirmedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ConfirmedTime"]); entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]); entity.PrimaryId = SqlTypeConverter.DBNullStringHandler(rdr["PrimaryId"]); entity.RelatedId = SqlTypeConverter.DBNullStringHandler(rdr["RelatedId"]); entity.FilterId = SqlTypeConverter.DBNullStringHandler(rdr["FilterId"]); entity.ReversalId = SqlTypeConverter.DBNullStringHandler(rdr["ReversalId"]); entity.ReversalCount = SqlTypeConverter.DBNullInt32Handler(rdr["ReversalCount"]); entity.Masked = SqlTypeConverter.DBNullBooleanHandler(rdr["Masked"]); entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]); } } return(entity); }
public List <A_AAlarm> GetEntities() { var entities = new List <A_AAlarm>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_AAlarm_Repository_GetEntities, null)) { while (rdr.Read()) { var entity = new A_AAlarm(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]); entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]); entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]); entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]); entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]); entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]); entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]); entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]); entity.AlarmTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AlarmTime"]); entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]); entity.AlarmValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmValue"]); entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]); entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]); entity.Confirmed = SqlTypeConverter.DBNullEnmConfirmHandler(rdr["Confirmed"]); entity.Confirmer = SqlTypeConverter.DBNullStringHandler(rdr["Confirmer"]); entity.ConfirmedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ConfirmedTime"]); entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]); entity.PrimaryId = SqlTypeConverter.DBNullStringHandler(rdr["PrimaryId"]); entity.RelatedId = SqlTypeConverter.DBNullStringHandler(rdr["RelatedId"]); entity.FilterId = SqlTypeConverter.DBNullStringHandler(rdr["FilterId"]); entity.ReversalId = SqlTypeConverter.DBNullStringHandler(rdr["ReversalId"]); entity.ReversalCount = SqlTypeConverter.DBNullInt32Handler(rdr["ReversalCount"]); entity.Masked = SqlTypeConverter.DBNullBooleanHandler(rdr["Masked"]); entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]); entities.Add(entity); } } return(entities); }