course.cs

一个多用户在线题库管理系统,可以实现各类试题的添加和管理

using System;
using System.Data;
using System.Collections;

using TQMS.DataAccessLayer;
using TQMS.DataAccessHelper;


namespace TQMS.BusinessLogicLayer
{
    /// <summary>
    /// Course 的摘要说明
    /// </summary>
    public class Course
    {
        #region 私有成员

        private int _courseID;//科目编号
        private string _courseName;//科目名称

        private bool _exist;

        #endregion

        #region 属性
        public int CourseID
        {
            set
            {
                this._courseID = value;
            }
            get
            {
                return this._courseID;
            }
        }
        public string CourseName
        {
            set
            {
                this._courseName = value;
            }
            get
            {
                return this._courseName;
            }
        }
        public bool Exist
        {
            set
            {
                this._exist = value;
            }
            get
            {
                return this._exist;
            }
        }
        #endregion

        #region 方法

        /// <summary>
        /// 根据参数courseID，获取科目详细信息
        /// </summary>
        /// <param name="courseID">科目ID</param>
        public void LoadData(int courseID)
        {
            Database db = new Database();		//实例化一个Database类

            string sql = "";
            sql = "Select * from [TQ_Courses] where TQ_CourseID = " + courseID;

            DataRow dr = db.GetDataRow(sql);	//利用Database类的GetDataRow方法查询用户数据

            //根据查询得到的数据，对成员赋值
            if (dr != null)
            {
                this._courseID = GetSafeData.ValidateDataRow_N(dr, "TQ_CourseID");
                this._courseName = GetSafeData.ValidateDataRow_S(dr, "TQ_CourseName");

                this._exist = true;
            }
            else
            {
                this._exist = false;
            }
        }


        /// <summary>
        /// 添加一个科目信息
        /// </summary>
        /// <param name="newCourseInfo">科目信息哈希表</param>
        public void Add(Hashtable CourseInfo)
        {
            Database db = new Database();
            db.Insert("[TQ_Courses]", CourseInfo);
        }
        
        /// <summary>
        /// 根据courseID修改科目信息
        /// </summary>
        /// <param name="newCourseInfo">新的科目信息哈希表</param>
        /// <param name="condition">Update的Where子句</param>
        public bool  Update(Hashtable newCourseInfo)
        {
            bool success = false;
            Database db = new Database();
            string condition="Where TQ_CourseID ="+this._courseID;
            if (db.Update("[TQ_Courses]", newCourseInfo, condition))
            {
                success = true;
            }
            return success;
        }

        /// <summary>
        /// 删除科目信息
        /// </summary>
        public void Delete()
        {
            Database db = new Database();
            string strSql = "Delete From [TQ_Courses] Where TQ_CourseID= " + this._courseID;
            db.ExecuteSQL(strSql);
        }
        /// <summary>
        /// 查询科目信息
        /// </summary>
        /// <param name="queryItems">查询条件哈希表</param>
        /// <returns>查询结果集</returns>
        public static DataTable QueryCourse(Hashtable queryItems)
        {
            string where = SqlStringConstructor.GetConditionClause(queryItems);
            string sql = "Select * From [TQ_Courses] " + where;

            Database db = new Database();
            return db.GetDataTable(sql);
        }
        public DataRow QueryCouserbyID(int courseID)
        {
            string sql = "Select * From [TQ_Courses]  where TQ_CourseID="+courseID ;

            Database db = new Database();
            return db.GetDataRow(sql);
        }
   
        #endregion
      
    }
}