public IList<Course> Fill(string QueryParam) { if (string.IsNullOrEmpty(QueryParam)) return this.GetAllCourse(); IList<Core.Business.Course> courselist = new List<Core.Business.Course>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllCourse + QueryParam); if (reader != null) { while (reader.Read()) { Core.Business.Course course = new Core.Business.Course(); if (!reader.IsDBNull(0)) course.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) course.CourseNum = reader.GetInt32(1); if (!reader.IsDBNull(2)) course.CourseScore = reader.GetInt32(2); if (!reader.IsDBNull(3)) course.IsPE = reader.GetBoolean(3); if (!reader.IsDBNull(4)) course.Code = reader.GetString(4); if (!reader.IsDBNull(5)) course.Name = reader.GetString(5); if (!reader.IsDBNull(6)) course.Des = reader.GetString(6); course.MarkOld(); courselist.Add(course); } reader.Close(); } return courselist; }
public Core.Business.Course GetByCode(string CourseCode) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Code", SqlDbType.NVarChar, CourseCode); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetByCode); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Course course = new Core.Business.Course(); if (!reader.IsDBNull(0)) course.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) course.Code = reader.GetString(1); if (!reader.IsDBNull(2)) course.Name = reader.GetString(2); if (!reader.IsDBNull(3)) course.Des = reader.GetString(3); if (!reader.IsDBNull(4)) course.CourseNum = reader.GetInt32(4); if (!reader.IsDBNull(5)) course.CourseScore = reader.GetInt32(5); if (!reader.IsDBNull(6)) course.IsPE = reader.GetBoolean(6); course.MarkOld(); reader.Close(); return course; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Course> GetListJoinScore(string wherestr) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT Distinct [Course].[Id], [Course].[CourseNum],[Course].[CourseScore],[Course].[IsPE],[Course].[Code],[Course].[Name],[Course].[Des] "); sb.Append("FROM Score INNER JOIN Course ON Score.CourseCode = Course.Code"); if (!string.IsNullOrEmpty(wherestr)) { sb.Append(" where 1=1 AND " + wherestr); } IList<Core.Business.Course> courselist = new List<Core.Business.Course>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(sb.ToString()); if (reader != null) { while (reader.Read()) { Core.Business.Course course = new Core.Business.Course(); if (!reader.IsDBNull(0)) course.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) course.CourseNum = reader.GetInt32(1); if (!reader.IsDBNull(2)) course.CourseScore = reader.GetInt32(2); if (!reader.IsDBNull(3)) course.IsPE = reader.GetBoolean(3); if (!reader.IsDBNull(4)) course.Code = reader.GetString(4); if (!reader.IsDBNull(5)) course.Name = reader.GetString(5); if (!reader.IsDBNull(6)) course.Des = reader.GetString(6); course.MarkOld(); courselist.Add(course); } reader.Close(); } return courselist; }
public CY.GFive.Core.Business.Course Select(string courseCode) { if (string.IsNullOrEmpty(courseCode)) { return null; } SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Code", SqlDbType.NVarChar, courseCode, 30); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectCourseByCode); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Course course = new Core.Business.Course(); if (!reader.IsDBNull(0)) course.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) course.Code = reader.GetString(1); if (!reader.IsDBNull(2)) course.Name = reader.GetString(2); if (!reader.IsDBNull(3)) course.Des = reader.GetString(3); if (!reader.IsDBNull(4)) course.CourseNum = reader.GetInt32(4); if (!reader.IsDBNull(5)) course.CourseScore = reader.GetInt32(5); reader.Close(); course.MarkOld(); return course; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Course> GetListByQuery(string wherestr) { IList<Core.Business.Course> courselist = new List<Core.Business.Course>(); SqlServerUtility sql = new SqlServerUtility(); StringBuilder sb = new StringBuilder(); sb.Append(SqlGetAllCourse); 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.Course course = new Core.Business.Course(); if (!reader.IsDBNull(0)) course.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) course.CourseNum = reader.GetInt32(1); if (!reader.IsDBNull(2)) course.CourseScore = reader.GetInt32(2); if (!reader.IsDBNull(3)) course.IsPE = reader.GetBoolean(3); if (!reader.IsDBNull(4)) course.Code = reader.GetString(4); if (!reader.IsDBNull(5)) course.Name = reader.GetString(5); if (!reader.IsDBNull(6)) course.Des = reader.GetString(6); course.MarkOld(); courselist.Add(course); } reader.Close(); } return courselist; }