public IList<Measure> GetAll() { IList<Core.Business.Measure> measurelist = new List<Core.Business.Measure>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllMeasure); if (reader != null) { while (reader.Read()) { Core.Business.Measure measure = new Core.Business.Measure(); if (!reader.IsDBNull(0)) measure.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) measure.MeasureName = reader.GetString(1); if (!reader.IsDBNull(2)) measure.FacCode = reader.GetString(2); if (!reader.IsDBNull(3)) measure.SchlCode = reader.GetString(3); if (!reader.IsDBNull(4)) measure.Format = reader.GetString(4); if (!reader.IsDBNull(5)) measure.Precision = reader.GetString(5); if (!reader.IsDBNull(6)) measure.Num = reader.GetInt32(6); if (!reader.IsDBNull(7)) measure.Factory = reader.GetString(7); if (!reader.IsDBNull(8)) measure.FacDate = reader.GetDateTime(8); if (!reader.IsDBNull(9)) measure.Certification = reader.GetString(9); if (!reader.IsDBNull(10)) measure.ProjectItem = reader.GetString(10); if (!reader.IsDBNull(11)) measure.QualifiedNum = reader.GetInt32(11); if (!reader.IsDBNull(12)) measure.FailureNum = reader.GetInt32(12); if (!reader.IsDBNull(13)) measure.InUse = reader.GetInt32(13); if (!reader.IsDBNull(14)) measure.AvailUse = reader.GetInt32(14); if (!reader.IsDBNull(15)) measure.SchlCert = reader.GetString(15); if (!reader.IsDBNull(16)) measure.ClassRoomCode = reader.GetString(16); if (!reader.IsDBNull(17)) measure.DepartCode = reader.GetString(17); measure.MarkOld(); measurelist.Add(measure); } reader.Close(); } return measurelist; }
public Core.Business.Measure Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectMeasure); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Measure measure = new Core.Business.Measure(); if (!reader.IsDBNull(0)) measure.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) measure.MeasureName = reader.GetString(1); if (!reader.IsDBNull(2)) measure.FacCode = reader.GetString(2); if (!reader.IsDBNull(3)) measure.SchlCode = reader.GetString(3); if (!reader.IsDBNull(4)) measure.Format = reader.GetString(4); if (!reader.IsDBNull(5)) measure.Precision = reader.GetString(5); if (!reader.IsDBNull(6)) measure.Num = reader.GetInt32(6); if (!reader.IsDBNull(7)) measure.Factory = reader.GetString(7); if (!reader.IsDBNull(8)) measure.FacDate = reader.GetDateTime(8); if (!reader.IsDBNull(9)) measure.Certification = reader.GetString(9); if (!reader.IsDBNull(10)) measure.ProjectItem = reader.GetString(10); if (!reader.IsDBNull(11)) measure.QualifiedNum = reader.GetInt32(11); if (!reader.IsDBNull(12)) measure.FailureNum = reader.GetInt32(12); if (!reader.IsDBNull(13)) measure.InUse = reader.GetInt32(13); if (!reader.IsDBNull(14)) measure.AvailUse = reader.GetInt32(14); if (!reader.IsDBNull(15)) measure.SchlCert = reader.GetString(15); if (!reader.IsDBNull(16)) measure.ClassRoomCode = reader.GetString(16); if (!reader.IsDBNull(17)) measure.DepartCode = reader.GetString(17); reader.Close(); return measure; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }