?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
      
    }
}