public IList<ProCourse> Fill(Profess profess) { if (profess == null) { return null; } IList<Core.Business.ProCourse> proCourselist = new List<Core.Business.ProCourse>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Code", SqlDbType.NVarChar, profess.ProCode, 30); SqlDataReader reader = sql.ExecuteSqlReader(SqlFillProCourse); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.ProCourse proCourse = new Core.Business.ProCourse(); if (!reader.IsDBNull(0)) proCourse.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) proCourse.IsMulti = reader.GetBoolean(1); if (!reader.IsDBNull(2)) proCourse.ProCode = reader.GetString(2); if (!reader.IsDBNull(3)) proCourse.CourseCode = reader.GetString(3); if (!reader.IsDBNull(4)) proCourse.CourseCate = reader.GetString(4); if (!reader.IsDBNull(5)) proCourse.MultiCate = reader.GetString(5); proCourse.MarkOld(); proCourselist.Add(proCourse); } reader.Close(); } return proCourselist; }
public IList<Core.Business.ProCourse> GetAllProCourse() { IList<Core.Business.ProCourse> proCourselist = new List<Core.Business.ProCourse>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllProCourse); if (reader != null) { while (reader.Read()) { Core.Business.ProCourse proCourse = new Core.Business.ProCourse(); if (!reader.IsDBNull(0)) proCourse.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) proCourse.IsMulti = reader.GetBoolean(1); if (!reader.IsDBNull(2)) proCourse.ProCode = reader.GetString(2); if (!reader.IsDBNull(3)) proCourse.CourseCode = reader.GetString(3); if (!reader.IsDBNull(4)) proCourse.CourseCate = reader.GetString(4); if (!reader.IsDBNull(5)) proCourse.MultiCate = reader.GetString(5); proCourse.MarkOld(); proCourselist.Add(proCourse); } reader.Close(); } return proCourselist; }