public List <P_Point> GetPoints()
{
var entities = new List <P_Point>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_P_Point_Repository_GetPoints, null)) {
while (rdr.Read())
{
var entity = new P_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.DeviceType = new C_DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.LogicType = new C_LogicType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeName"])
};
entity.DeviceEffect = SqlTypeConverter.DBNullStringHandler(rdr["DeviceEffect"]);
entity.BusiEffect = SqlTypeConverter.DBNullStringHandler(rdr["BusiEffect"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Interpret = SqlTypeConverter.DBNullStringHandler(rdr["Interpret"]);
entity.ExtSet = SqlTypeConverter.DBNullStringHandler(rdr["ExtSet"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public bool IsAlarmPoint(P_Point point)
{
if (point == null)
{
return(false);
}
return(point.Type == EnmPoint.DI && !string.IsNullOrWhiteSpace(point.AlarmId));
}
public EnmPoint GetPointType(P_Point point)
{
if (point.Type == EnmPoint.DI && !string.IsNullOrWhiteSpace(point.AlarmId))
{
return(EnmPoint.AL);
}
return(point.Type);
}
