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