?using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace myBusinessRole
{
    /// <summary>
    /// 營(yíng)業(yè)廳表 營(yíng)業(yè)廳的相關(guān)信息
    /// </summary>
    class Hall
    {
        #region 字段的定義
        string hallID;//營(yíng)業(yè)廳id
        string hallName;//營(yíng)業(yè)廳名稱(chēng)
        string hallPhone;//聯(lián)系電話
        string hallMan;//聯(lián)系人 
        string hallAddress;//地址
        decimal hallRate;//費(fèi)率
        string remark;//備注
        #endregion

        #region 屬性的添加
        public string HallID
        {
            get { return hallID; }
            set { hallID = value; }
        }
        public string HallName
        {
            get { return hallName; }
            set { hallName = value; }
        }
        public string HallPhone
        {
            get { return hallPhone; }
            set { hallPhone = value; }
        }
        public string HallMan
        {
            get { return hallMan; }
            set { hallMan = value; }
        }
        public string HallAddress
        {
            get { return hallAddress; }
            set { hallAddress = value; }
        }
        public decimal HallRate
        {
            get { return hallRate; }
            set { hallRate = value; }
        }
        public string Remark
        {
            get { return remark; }
            set { remark = value; }
        }
        #endregion

        #region 實(shí)現(xiàn)接口(數(shù)據(jù)庫(kù)操作對(duì)象)的方法
        #region 清空所有變量 void Clear()
        /// <summary>
        ///Clear()
        ///</summary>
        public void Clear()
        {
             hallID="";//營(yíng)業(yè)廳id
             hallName = "";//營(yíng)業(yè)廳名稱(chēng)
             hallPhone = "";//聯(lián)系電話
             hallMan = "";//聯(lián)系人 
             hallAddress = "";//地址
             hallRate = 0;//費(fèi)率
             remark = "";//備注

        }
        #endregion

        #region 判斷能否刪除 public bool IsDeleteFromKey()
        /// <summary>
        ///IsDeleteFromKey() 根據(jù)主鍵判斷能否刪除此記錄
        ///</summary>
        public bool IsDeleteFromKey()
        {

            //定義變量
            bool dbOk = false;//是否存在記錄
            bool isDelete = false;//是否可以刪除
            try
            {
                //營(yíng)業(yè)廳表和用戶表有外鍵關(guān)系，要判斷用戶表中是否有記錄存在
                UserInfo userInfo = new UserInfo();
                userInfo.HallID=hallID;
                dbOk = userInfo.IsExist("HallID='" + hallID + "'");
                if (dbOk)
                {
                    //記錄存在，不能刪除
                    isDelete = false;
                }
                else
                {
                    //沒(méi)有有關(guān)的記錄，可以刪除
                    isDelete = true;
                }
            }
            catch (Exception e)
            {
                throw e;
            }


            return isDelete;
        }
        #endregion

        #region 根據(jù)主鍵刪除 public bool DeleteFromKey()
        /// <summary>
        ///DeleteFromKey() 
        ///在IsDeleteFromKey()之后應(yīng)用的方法
        ///如果能刪除，根據(jù)主鍵刪除
        ///</summary>
        public bool DeleteFromKey()
        {

            //生成Sql語(yǔ)句
            StringBuilder Sql = new StringBuilder();
            Sql.Append(" DELETE FROM Hall ");
            Sql.Append(" WHERE HallID='" + hallID + "'");
            try
            {
                //訪問(wèn)數(shù)據(jù)庫(kù)并返回
                DB db = new DB();
                return db.ExecuteSql(Sql.ToString());
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        #endregion

        #region 根據(jù)條件刪除 public bool Delete(string condition)
        /// <summary>
        ///Delete()  根據(jù)條件刪除， condition為不含“where”的條件
        ///建議慎重使用，因?yàn)闆](méi)有對(duì)應(yīng)的判斷，刪除不能保證成功
        ///如果出錯(cuò)，返回的是數(shù)據(jù)庫(kù)不能刪除的錯(cuò)誤信息
        ///</summary>
        public bool Delete(string condition)
        {

            //生成Sql語(yǔ)句
            StringBuilder Sql = new StringBuilder();
            Sql.Append(" DELETE FROM Hall ");
            if (!(condition == null || condition == ""))//如果條件是空不執(zhí)行否則增加查詢條件
            {
                Sql.Append(" WHERE " + condition);
            }
            try
            {
                //訪問(wèn)數(shù)據(jù)庫(kù)并返回
                DB db = new DB();
                return db.ExecuteSql(Sql.ToString());
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        #endregion

        #region 根據(jù)主鍵更新 public bool UpdateFromKey()
        /// <summary>
        ///UpdateFromKey() 根據(jù)主鍵更新，由前臺(tái)頁(yè)面保證數(shù)據(jù)的合法性
        ///更新的內(nèi)容在屬性中存放。
        ///</summary>
        public bool UpdateFromKey()
        {
            //生成Sql語(yǔ)句
            StringBuilder Sql = new StringBuilder();
            Sql.Append(" UPDATE Hall SET ");

            Sql.Append(" HallID='" + hallID + "' ");
            Sql.Append(" ,HallName='" + hallName + "' ");
            Sql.Append(" ,HallPhone='" + hallPhone + "' ");
            Sql.Append(" ,HallMan='" + hallMan + "' ");
            Sql.Append(" ,HallAddr='" + hallAddress + "' ");
            Sql.Append(" ,HallRate='" + hallRate + "' ");
            Sql.Append(" ,Remark='" + remark + "' ");
            Sql.Append(" WHERE HallID='" + hallID + "'");
            try
            {
                //訪問(wèn)數(shù)據(jù)庫(kù)并返回
                DB db = new DB();
                return db.ExecuteSql(Sql.ToString());
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        #endregion

        #region 添加一條記錄 public bool Insert()
        /// <summary>
        ///Insert() 添加一條記錄，添加的內(nèi)容在屬性中存放
        ///由前臺(tái)頁(yè)面保證數(shù)據(jù)的合法性
        ///</summary>
        public bool Insert()
        {
            //生成Sql語(yǔ)句
            StringBuilder Sql = new StringBuilder();
            Sql.Append(" INSERT INTO Hall(");
            Sql.Append(" HallID,HallName, HallPhone,HallMan,HallAddr,HallRate,Remark)");
            Sql.Append(" VALUES (");
            Sql.Append(" '" + hallID + "' ");
            Sql.Append(" ,'" + hallName + "' ");
            Sql.Append(" ,'" + hallPhone + "' ");
            Sql.Append(" ,'" + hallMan + "' ");
            Sql.Append(" ,'" + hallAddress + "' ");
            Sql.Append(" ,'" + hallRate + "' ");
            Sql.Append(" ,'" + remark + "' ");
            Sql.Append(" )");
            try
            {
                //訪問(wèn)數(shù)據(jù)庫(kù)并返回
                DB db = new DB();
                return db.ExecuteSql(Sql.ToString());
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        #endregion

        #region 給定條件的記錄是否存在 public bool IsExist(string condition)
        /// <summary>
        ///IsExist() 給定條件的記錄是否存在
        ///</summary>
        public bool IsExist(string condition)
        {

            //生成Sql語(yǔ)句
            StringBuilder Sql = new StringBuilder();
            Sql.Append(GetSqlString(condition));//由條件獲得 相應(yīng)的sql語(yǔ)句

            bool dbOk = false;//存放判斷是否存在的結(jié)果
            string retOneData;//一條紀(jì)錄
            try
            {
                //訪問(wèn)數(shù)據(jù)庫(kù)
                DB db = new DB();
                retOneData = db.GetOneData(Sql.ToString());//取按照sql語(yǔ)句執(zhí)行結(jié)果中的第一條數(shù)據(jù)

                if (retOneData != null && retOneData != "")//如果不是空 則存在滿足條件的記錄
                {
                    dbOk = true;
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return dbOk;
        }
        #endregion

        #region 根據(jù)條件查詢  public DataTable Query(string condition)
        /// <summary>
        ///Query() 根據(jù)條件查詢，condition為不含“where”的條件
        ///由查詢者保證condition的合法性
        ///</summary>
        public DataTable Query(string condition)
        {
            try
            {
                //訪問(wèn)數(shù)據(jù)庫(kù)并返回
                DB db = new DB();
                return db.GetDataTable(GetSqlString(condition));
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        #endregion

        #region 無(wú)條件查詢  public DataTable Query()
        /// <summary>
        ///Query() 無(wú)條件查詢
        ///</summary>
        public DataTable Query()
        {
            try
            {
                //訪問(wèn)數(shù)據(jù)庫(kù)并返回
                DB db = new DB();
                return db.GetDataTable(GetSqlString(""));
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        #endregion

        #region 根據(jù)主鍵查詢 public Ret QueryFromKey()
        /// <summary>
        ///QueryFromKey() 根據(jù)主鍵查詢
        ///要查詢的主鍵在屬性中存放，查詢的結(jié)果存放在屬性中
        ///</summary>
        public DataTable QueryFromKey()
        {

            //生成Sql語(yǔ)句
            StringBuilder Sql = new StringBuilder();
            Sql.Append(GetSqlString(" HallID='" + hallID + "' "));

            //清空屬性值
            this.Clear();
            //定義返回變量
            DataTable dt = new DataTable();
            try
            {
                //訪問(wèn)數(shù)據(jù)庫(kù)
                DB db = new DB();
                dt = db.GetDataTable(Sql.ToString());

                //若訪問(wèn)數(shù)據(jù)庫(kù)成功就給屬性賦值
                if (dt.Rows.Count > 0)
                {
                    hallID = dt.Rows[0]["HallID"].ToString();
                    hallName = dt.Rows[0]["HallName"].ToString();
                    hallPhone = dt.Rows[0]["HallPhone"].ToString();
                    hallMan = dt.Rows[0]["HallMan"].ToString();
                    hallAddress = dt.Rows[0]["HallAddr"].ToString();
                    hallRate = (decimal)(dt.Rows[0]["HallRate"]);
                    remark = dt.Rows[0]["Remark"].ToString();
                }
            }
            catch (Exception e)
            {
                throw e;
            }

            return dt;
        }
        #endregion

        #region 根據(jù)條件獲取查詢SQL語(yǔ)句 public string GetSqlString(string condition)
        /// <summary>
        ///GetSqlString(string condition) 根據(jù)條件獲取查詢SQL語(yǔ)句
        ///</summary>
        public string GetSqlString(string condition)
        {

            //生成Sql查詢語(yǔ)句
            StringBuilder Sql = new StringBuilder();
            Sql.Append(" SELECT ");
            Sql.Append(" HallID,HallName, HallPhone,HallMan,HallAddr,HallRate,Remark");
            Sql.Append(" FROM Hall");
            if (condition != null && condition != "")
            {
                Sql.Append(" WHERE " + condition);
            }

            //返回
            return Sql.ToString();
        }
        #endregion



        #endregion
    }
}