public IList<Core.Business.Course> GetAllCourse()
{
IList<Core.Business.Course> courselist = new List<Core.Business.Course>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllCourse);
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 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 Core.Business.Course Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectCourse);
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.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);
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 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;
}
