public IList<PlanCourse> Fill(CoursePlan plan) { if (plan == null) return null; IList<Core.Business.PlanCourse> planCourselist = new List<Core.Business.PlanCourse>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@PlanCode", SqlDbType.NVarChar, plan.PlanCode, 30); SqlDataReader reader = sql.ExecuteSqlReader(SqlFillPlanCourse); if (reader != null) { while (reader.Read()) { Core.Business.PlanCourse planCourse = new Core.Business.PlanCourse(); if (!reader.IsDBNull(0)) planCourse.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) planCourse.PlanCode = reader.GetString(1); if (!reader.IsDBNull(2)) planCourse.CourseCode = reader.GetString(2); if (!reader.IsDBNull(3)) planCourse.TeacherCode = reader.GetString(3); if (!reader.IsDBNull(4)) planCourse.CourseNum = reader.GetInt32(4); if (!reader.IsDBNull(5)) planCourse.CourseScore = reader.GetInt32(5); planCourse.MarkOld(); planCourselist.Add(planCourse); } reader.Close(); } return planCourselist; }
public IList<Core.Business.PlanCourse> GetAllPlanCourse() { IList<Core.Business.PlanCourse> planCourselist = new List<Core.Business.PlanCourse>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllPlanCourse); if (reader != null) { while (reader.Read()) { Core.Business.PlanCourse planCourse = new Core.Business.PlanCourse(); if (!reader.IsDBNull(0)) planCourse.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) planCourse.PlanCode = reader.GetString(1); if (!reader.IsDBNull(2)) planCourse.CourseCode = reader.GetString(2); if (!reader.IsDBNull(3)) planCourse.TeacherCode = reader.GetString(3); if (!reader.IsDBNull(4)) planCourse.CourseNum = reader.GetInt32(4); if (!reader.IsDBNull(5)) planCourse.CourseScore = reader.GetInt32(5); planCourse.MarkOld(); planCourselist.Add(planCourse); } reader.Close(); } return planCourselist; }
public Core.Business.PlanCourse Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectPlanCourse); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.PlanCourse planCourse = new Core.Business.PlanCourse(); if (!reader.IsDBNull(0)) planCourse.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) planCourse.PlanCode = reader.GetString(1); if (!reader.IsDBNull(2)) planCourse.CourseCode = reader.GetString(2); if (!reader.IsDBNull(3)) planCourse.TeacherCode = reader.GetString(3); if (!reader.IsDBNull(4)) planCourse.CourseNum = reader.GetInt32(4); if (!reader.IsDBNull(5)) planCourse.CourseScore = reader.GetInt32(5); reader.Close(); return planCourse; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }