public List <A_TAlarm> GetEntities() { var entities = new List <A_TAlarm>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_TAlarm_Repository_GetEntities1, null)) { while (rdr.Read()) { var 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"]); entities.Add(entity); } } return(entities); }
public List <A_TAlarm> 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_TAlarm>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_TAlarm_Repository_GetEntities2, parms)) { while (rdr.Read()) { var 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"]); 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); }