public IList<CY.GFive.Core.Business.Curriculm> Fill(string queryParam) { if (string.IsNullOrEmpty(queryParam)) { return GetAllCurriculm(); } IList<Core.Business.Curriculm> curriculmlist = new List<Core.Business.Curriculm>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllCurriculm + queryParam); if (reader != null) { while (reader.Read()) { Core.Business.Curriculm curriculm = new Core.Business.Curriculm(); if (!reader.IsDBNull(0)) curriculm.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) curriculm.MakeDate = reader.GetDateTime(1); if (!reader.IsDBNull(2)) curriculm.CurriculmYear = reader.GetString(2); if (!reader.IsDBNull(3)) curriculm.CurriculmTerm = reader.GetString(3); if (!reader.IsDBNull(4)) curriculm.CurriculeStoredAddress = reader.GetString(4); if (!reader.IsDBNull(5)) curriculm.Name = reader.GetString(5); curriculm.MarkOld(); curriculmlist.Add(curriculm); } reader.Close(); } return curriculmlist; }
public Curriculm Select(string year, string term) { if (string.IsNullOrEmpty(year) || string.IsNullOrEmpty(term)) return null; SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Year", SqlDbType.NVarChar, year, 10); sql.AddParameter("@Term", SqlDbType.NVarChar, term, 10); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetCurriculm); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Curriculm curriculm = new Core.Business.Curriculm(); if (!reader.IsDBNull(0)) curriculm.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) curriculm.MakeDate = reader.GetDateTime(1); if (!reader.IsDBNull(2)) curriculm.CurriculmYear = reader.GetString(2); if (!reader.IsDBNull(3)) curriculm.CurriculmTerm = reader.GetString(3); if (!reader.IsDBNull(4)) curriculm.CurriculeStoredAddress = reader.GetString(4); if (!reader.IsDBNull(5)) curriculm.Name = reader.GetString(5); reader.Close(); curriculm.MarkOld(); return curriculm; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }