public List <H_CardRecord> GetEntitiesInDevice(DateTime start, DateTime end, string id)
{
SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime),
new SqlParameter("@DeviceId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeChecker(start);
parms[1].Value = SqlTypeConverter.DBNullDateTimeChecker(end);
parms[2].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List <H_CardRecord>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_H_CardRecord_Repository_GetEntitiesInDevice, parms)) {
while (rdr.Read())
{
var entity = new H_CardRecord();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["CardId"]);
entity.PunchTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["PunchTime"]);
entity.Status = SqlTypeConverter.DBNullStringHandler(rdr["Status"]);
entity.Remark = SqlTypeConverter.DBNullRecRemarkHandler(rdr["Remark"]);
entity.Direction = SqlTypeConverter.DBNullDirectionHandler(rdr["Direction"]);
entities.Add(entity);
}
}
return(entities);
}