/// <summary>
        /// 查询所有
        /// </summary>
        /// <param name="CourseLbID">类别ID</param>
        /// <returns></returns>
        public List <Model.CourseSystem> GetList(int PageCount, int PageSize, int CourseLbID)
        {
            string strSql      = "";
            string RedCountsql = "";
            int    RowTotal    = (PageCount - 1) * PageSize;//

            RedCountsql = "(select count(CR_ID) from [AP_COURSE] where [CR_CATEGORY_ID]='" + CourseLbID + "' ) as RowTotal";
            strSql      = "Select Top " + PageSize + " *," + RedCountsql + " FROM [AP_COURSE]  where [CR_ID] not in (Select Top " + RowTotal + " [CR_ID] from [AP_COURSE] Where [CR_CATEGORY_ID]='" + CourseLbID + "' ORDER BY CR_ID DESC ) And [CR_CATEGORY_ID]='" + CourseLbID + "' ORDER BY CR_ID DESC";
            List <Model.CourseSystem> List = new List <Model.CourseSystem>();

            SqlParameter[] parameters =
            {
            };

            SqlDataReader DR;

            if (GetCourseSysSetupInfo())
            {
                DR = CourseSys.ExecuteReader(strSql.ToString(), parameters);
            }
            else
            {
                DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
            }

            using (DR)
            {
                while (DR.Read())
                {
                    Model.CourseSystem model = new Model.CourseSystem();
                    model.ID       = int.Parse(DR["CR_ID"].ToString());
                    model.Title    = DR["CR_COURSE_NAME"].ToString();
                    model.RowTotal = int.Parse(DR["RowTotal"].ToString());
                    model.Credit   = int.Parse(DR["CR_CREDIT"].ToString());
                    model.Money    = int.Parse(DR["CR_MONEY"].ToString());
                    List.Add(model);
                }
                DR.Close();
                DR.Dispose();
            }
            return(List);
        }
        /// <summary>
        /// 查询所有
        /// </summary>
        /// <returns></returns>
        public List <Model.CourseSystem> GetList()
        {
            string strSql = "";

            strSql = "Select * FROM [AP_COURSE_CATEGORY]";
            List <Model.CourseSystem> List = new List <Model.CourseSystem>();

            SqlParameter[] parameters =
            {
            };
            SqlDataReader DR;

            if (GetCourseSysSetupInfo())
            {
                DR = CourseSys.ExecuteReader(strSql.ToString(), parameters);
            }
            else
            {
                DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
            }

            using (DR)
            {
                while (DR.Read())
                {
                    Model.CourseSystem model = new Model.CourseSystem();
                    model.CourseLbID  = int.Parse(DR["CRC_ID"].ToString());
                    model.Name        = DR["CRC_CATEGORY_NAME"].ToString();
                    model.Up          = int.Parse(DR["CRC_PARENT_ID"].ToString());
                    model.CourseCount = GetCourseCount(int.Parse(DR["CRC_ID"].ToString()));
                    //model.CourseCount = 1;
                    List.Add(model);
                }
                DR.Close();
                DR.Dispose();
            }
            return(List);
        }
        /// <summary>
        /// 显示详细
        /// </summary>
        /// <param name="ID">ID</param>
        /// <returns></returns>
        public List <Model.CourseSystem> Details(int ID)
        {
            string strSql = "";

            strSql = "Select * FROM [AP_COURSE] Where [CR_ID]='" + ID + "'";
            List <Model.CourseSystem> List = new List <Model.CourseSystem>();

            SqlParameter[] parameters =
            {
            };
            SqlDataReader DR;

            if (GetCourseSysSetupInfo())
            {
                DR = CourseSys.ExecuteReader(strSql.ToString(), parameters);
            }
            else
            {
                DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
            }

            using (DR)
            {
                while (DR.Read())
                {
                    Model.CourseSystem model = new Model.CourseSystem();
                    model.ID       = int.Parse(DR["CR_ID"].ToString());
                    model.Title    = DR["CR_COURSE_NAME"].ToString();
                    model.Abstract = DR["CR_DESC"].ToString();
                    model.Outline  = DR["CR_OUTLINE"].ToString();
                    List.Add(model);
                }
                DR.Close();
                DR.Dispose();
            }
            return(List);
        }