public Core.Business.CourseClass GetByCode(string CourseClassCode) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@TCCode", SqlDbType.NVarChar, CourseClassCode); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetByCode); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.CourseClass courseClass = new Core.Business.CourseClass(); if (!reader.IsDBNull(0)) courseClass.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) courseClass.TCCode = reader.GetString(1); if (!reader.IsDBNull(2)) courseClass.CourseCode = reader.GetString(2); if (!reader.IsDBNull(3)) courseClass.YearNum = reader.GetString(3); if (!reader.IsDBNull(4)) courseClass.Term = reader.GetString(4); reader.Close(); courseClass.MarkOld(); return courseClass; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.CourseClass> GetAllCourseClass() { IList<Core.Business.CourseClass> courseClasslist = new List<Core.Business.CourseClass>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllCourseClass); if(reader != null) { while(reader.Read()) { Core.Business.CourseClass courseClass = new Core.Business.CourseClass(); if (!reader.IsDBNull(0)) courseClass.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) courseClass.TCCode = reader.GetString(1); if (!reader.IsDBNull(2)) courseClass.CourseCode = reader.GetString(2); if (!reader.IsDBNull(3)) courseClass.YearNum = reader.GetString(3); if (!reader.IsDBNull(4)) courseClass.Term = reader.GetString(4); courseClass.MarkOld(); courseClasslist.Add(courseClass); } reader.Close(); } return courseClasslist; }
public Core.Business.CourseClass Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectCourseClass); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.CourseClass courseClass = new Core.Business.CourseClass(); if (!reader.IsDBNull(0)) courseClass.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) courseClass.TCCode = reader.GetString(1); if (!reader.IsDBNull(2)) courseClass.CourseCode = reader.GetString(2); if (!reader.IsDBNull(3)) courseClass.YearNum = reader.GetString(3); if (!reader.IsDBNull(4)) courseClass.Term = reader.GetString(4); reader.Close(); return courseClass; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.CourseClass> GetListByQuery(string wherestr) { IList<Core.Business.CourseClass> courseClasslist = new List<Core.Business.CourseClass>(); SqlServerUtility sql = new SqlServerUtility(); StringBuilder sb = new StringBuilder(); sb.Append(SqlGetAllCourseClass); if (!string.IsNullOrEmpty(wherestr)) { sb.Append(" WHERE 1=1 AND "+ wherestr); } SqlDataReader reader = sql.ExecuteSqlReader(sb.ToString()); if (reader != null) { while (reader.Read()) { Core.Business.CourseClass courseClass = new Core.Business.CourseClass(); if (!reader.IsDBNull(0)) courseClass.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) courseClass.TCCode = reader.GetString(1); if (!reader.IsDBNull(2)) courseClass.CourseCode = reader.GetString(2); if (!reader.IsDBNull(3)) courseClass.YearNum = reader.GetString(3); if (!reader.IsDBNull(4)) courseClass.Term = reader.GetString(4); courseClass.MarkOld(); courseClasslist.Add(courseClass); } reader.Close(); } return courseClasslist; }