?using System;
using System.Data;
using System.Collections;
using System.Data.SqlClient;
using MyLibrary.DataAccessLayer;
using MyLibrary.DataAccessHelper;


namespace MyLibrary.BusinessLogicLayer
{
    //用戶類
    public class Book
    {
        #region 私有成員
        private int _bookID;                                //書號(hào)
        private string _bookName;                           //書名
        private string _bookISBN;                           //ISBN
        private string _bookAuthor;                         //作者
        private string _bookPublish;                        //出版社
        private DateTime _bookPublishDate;                  //出版時(shí)間
        private string _bookClassify;                       //分類
        private string _bookSubject;                        //主題
        private string _bookIndex;                          //索書號(hào)
        private double _bookPrice;                          //價(jià)格
        private int _bookPageNum;                           //頁數(shù)
        private string _bookSeries;                         //系列
        private string _bookDescription;                    //描述

        #endregion 私有成員

        #region 屬性

        public int BookID
        {
            set
            {
                this._bookID = value;
            }
            get
            {
                return this._bookID;
            }
        }
        public string BookName
        {
            set
            {
                this._bookName = value;
            }
            get
            {
                return this._bookName;
            }
        }
        public string BookISBN
        {
            set
            {
                this._bookISBN = value;
            }
            get
            {
                return this._bookISBN;
            }
        }
        public string BookAuthor
        {
            set
            {
                this._bookAuthor = value;
            }
            get
            {
                return this._bookAuthor;
            }
        }
        public string BookPublish
        {
            set
            {
                this._bookPublish = value;
            }
            get
            {
                return this._bookPublish;
            }
        }
        public DateTime BookPublishDate
        {
            set
            {
                this._bookPublishDate = value;
            }
            get
            {
                return this._bookPublishDate;
            }
        }
        public string BookClassify
        {
            set
            {
                this._bookClassify = value;
            }
            get
            {
                return this._bookClassify;
            }
        }
        public string BookSubject
        {
            set
            {
                this._bookSubject = value;
            }
            get
            {
                return this._bookSubject;
            }
        }
        public string BookIndex
        {
            set
            {
                this._bookIndex = value;
            }
            get
            {
                return this._bookIndex;
            }
        }
        public double BookPrice
        {
            set
            {
                this._bookPrice = value;
            }
            get
            {
                return this._bookPrice;
            }
        }
        public int BookPageNum
        {
            set
            {
                this._bookPageNum = value;
            }
            get
            {
                return this._bookPageNum;
            }
        }
        public string BookSeries
        {
            set
            {
                this._bookSeries = value;
            }
            get
            {
                return this._bookSeries;
            }
        }
        public string BookDescription
        {
            set
            {
                this._bookDescription = value;
            }
            get
            {
                return this._bookDescription;
            }
        }

        #endregion 屬性

        #region 方法

        //根據(jù)書號(hào) BookID 初始化
        //輸入：
        //      XBookID - 書號(hào)；
        //輸出：
        //      書存在：返回True；
        //      書不在：返回False；
        public bool LoadData(int XBookID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase DB = new DataBase();

            Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, XBookID);                       //書號(hào)            

            DataSet ds = DB.GetDataSet("Proc_BookDetail", Params);
            ds.CaseSensitive = false;
            DataRow DR;
            if (ds.Tables[0].Rows.Count > 0)
            {
                DR = ds.Tables[0].Rows[0];
                this._bookID = GetSafeData.ValidateDataRow_N(DR, "BookID");                         //書號(hào)                
                this._bookName = GetSafeData.ValidateDataRow_S(DR, "BookName");                     //書名
                this._bookISBN = GetSafeData.ValidateDataRow_S(DR, "BookISBN");                     //書ISBN號(hào)
                this._bookAuthor = GetSafeData.ValidateDataRow_S(DR, "BookAuthor");                 //作者
                this._bookPublish = GetSafeData.ValidateDataRow_S(DR, "BookPublish");               //出版社
                this._bookPublishDate = GetSafeData.ValidateDataRow_T(DR, "BookPublishDate");       //出版時(shí)間
                this._bookClassify = GetSafeData.ValidateDataRow_S(DR, "BookClassify");             //分類
                this._bookSubject = GetSafeData.ValidateDataRow_S(DR, "BookSubject");               //主題
                this._bookIndex = GetSafeData.ValidateDataRow_S(DR, "BookIndex");                   //索引號(hào)
                this._bookPrice = GetSafeData.ValidateDataRow_F(DR, "BookPrice");                   //價(jià)格
                this._bookPageNum = GetSafeData.ValidateDataRow_N(DR, "BookPageNum");               //頁數(shù)                
                this._bookSeries = GetSafeData.ValidateDataRow_S(DR, "BookSeries");                 //系列
                this._bookDescription = GetSafeData.ValidateDataRow_S(DR, "BookDescription");       //介紹                
                return true;
            }
            else
            {
                return false;
            }
        }

        //根據(jù)BookID判斷該圖書是否存在
        //輸入：
        //      XBookID - 用戶編號(hào)；        
        //輸出：
        //      用戶存在：返回True；
        //      用戶不在：返回False；
        public bool CheckBook(string XBookID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase DB = new DataBase();

            Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, XBookID);                  //書號(hào)            

            SqlDataReader DR = DB.RunProcGetReader("Proc_BookDetail", Params);

            if (!DR.Read())
            {
                return false;
            }
            else
            {
                return true;
            }
        }


        //向Books表中添加書籍信息(采用存儲(chǔ)過程)
        //輸出：
        //      插入成功：返回True；
        //      插入失敗：返回False；
        public bool InsertByProc()
        {
            SqlParameter[] Params = new SqlParameter[12];

            DataBase DB = new DataBase();

            //Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, BookID);                        //書號(hào)
            Params[0] = DB.MakeInParam("@BookName", SqlDbType.VarChar, 50, BookName);               //書名
            Params[1] = DB.MakeInParam("@BookISBN", SqlDbType.VarChar, 50, BookISBN);               //ISBN
            Params[2] = DB.MakeInParam("@BookAuthor", SqlDbType.VarChar, 50, BookAuthor);           //作者
            Params[3] = DB.MakeInParam("@BookPublish", SqlDbType.VarChar, 50, BookPublish);         //出版社
            Params[4] = DB.MakeInParam("@BookPublishDate", SqlDbType.DateTime, 8, BookPublishDate); //出版時(shí)間
            Params[5] = DB.MakeInParam("@BookClassify", SqlDbType.VarChar, 50, BookClassify);       //分類
            Params[6] = DB.MakeInParam("@BookSubject", SqlDbType.VarChar, 50, BookSubject);         //主題
            Params[7] = DB.MakeInParam("@BookIndex", SqlDbType.VarChar, 50, BookIndex);             //索引號(hào)
            Params[8] = DB.MakeInParam("@BookPrice", SqlDbType.Float, 8, BookPrice);          //價(jià)格
            Params[9] = DB.MakeInParam("@BookPageNum", SqlDbType.Int, 4, BookPageNum);             //頁數(shù)
            Params[10] = DB.MakeInParam("@BookSeries", SqlDbType.VarChar, 50, BookSeries);          //系列
            Params[11] = DB.MakeInParam("@BookDescription", SqlDbType.VarChar, 50, BookDescription);//描述

            int Count = -1;
            Count = DB.RunProc("Proc_BookAdd", Params);
            if (Count > 0)
                return true;
            else return false;
        }

        //更新書籍的信息
        public bool UpdateByProc(int XBookID)
        {
            SqlParameter[] Params = new SqlParameter[13];

            DataBase DB = new DataBase();

            Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, XBookID);                       //書號(hào)
            Params[1] = DB.MakeInParam("@BookName", SqlDbType.VarChar, 50, BookName);               //書名
            Params[2] = DB.MakeInParam("@BookISBN", SqlDbType.VarChar, 50, BookISBN);               //ISBN
            Params[3] = DB.MakeInParam("@BookAuthor", SqlDbType.VarChar, 50, BookAuthor);           //作者
            Params[4] = DB.MakeInParam("@BookPublish", SqlDbType.VarChar, 50, BookPublish);         //出版社
            Params[5] = DB.MakeInParam("@BookPublishDate", SqlDbType.DateTime, 8, BookPublishDate); //出版時(shí)間
            Params[6] = DB.MakeInParam("@BookClassify", SqlDbType.VarChar, 50, BookClassify);       //分類
            Params[7] = DB.MakeInParam("@BookSubject", SqlDbType.VarChar, 50, BookSubject);         //主題
            Params[8] = DB.MakeInParam("@BookIndex", SqlDbType.VarChar, 50, BookIndex);             //索引號(hào)
            Params[9] = DB.MakeInParam("@BookPrice", SqlDbType.Float, 8, BookPrice);          //價(jià)格
            Params[10] = DB.MakeInParam("@BookPageNum", SqlDbType.Int, 4, BookPageNum);             //頁數(shù)
            Params[11] = DB.MakeInParam("@BookSeries", SqlDbType.VarChar, 50, BookSeries);          //系列
            Params[12] = DB.MakeInParam("@BookDescription", SqlDbType.VarChar, 50, BookDescription);//描述

            int Count = -1;
            Count = DB.RunProc("Proc_BookModify", Params);
            if (Count > 0)
                return true;
            else return false;
        }

        //刪除書籍
        //輸入：
        //      XBookID - 書號(hào)；
        //輸出：
        //      刪除成功：返回True；
        //      刪除失敗：返回False；
        public bool DeleteByProc(int XBookID)
        {
            SqlParameter[] Params = new SqlParameter[1];

            DataBase DB = new DataBase();

            Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, XBookID);               //書號(hào)          

            int Count = -1;
            Count = DB.RunProc("Proc_BookDelete", Params);
            if (Count > 0)
                return true;
            else return false;
        }

        
        //查詢所有書籍
        //不需要參數(shù)
        public DataSet QueryBooks()
        {
            DataBase DB = new DataBase();
            return DB.GetDataSet("Proc_BookList");
        }

        
        ////查詢最大書號(hào)
        //public int QueryMaxID()
        //{
        //    DataBase DB = new DataBase();
        //    SqlDataReader sdr = DB.RunProcGetReader("Proc_MaxBookID");
        //    return int.Parse(sdr["maxbookid"].ToString());
        //}

        #endregion 方法
    }
}