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


namespace MyLibrary.BusinessLogicLayer
{
    //用戶類
    public class Borrow
    {
        #region 私有成員
        private int _borrowID;                                              //借書號
        private string _userID;                                             //用戶編號
        private int _bookID;                                                //書號
        private DateTime _borrowBeginDate;                                  //借書時間
        private DateTime _borrowEndDate;                                    //還書時間
        private int _borrowState;                                           //借書狀態：0表示不在館，1表示在館        

        #endregion 私有成員

        #region 屬性

        public int BorrowID
        {
            set
            {
                this._borrowID = value;
            }
            get
            {
                return this._borrowID;
            }
        }
        public string UserID
        {
            set
            {
                this._userID = value;
            }
            get
            {
                return this._userID;
            }
        }        
        public int BookID
        {
            set
            {
                this._bookID = value;
            }
            get
            {
                return this._bookID;
            }
        }        
        public DateTime BorrowBeginDate
        {
            set
            {
                this._borrowBeginDate = value;
            }
            get
            {
                return this._borrowBeginDate;
            }
        }
        public DateTime BorrowEndDate
        {
            set
            {
                this._borrowEndDate = value;
            }
            get
            {
                return this._borrowEndDate;
            }
        }
        public int BorrowState
        {
            set
            {
                this._borrowState = value;
            }
            get
            {
                return this._borrowState;
            }
        }        

        #endregion 屬性

        #region 方法

        //向Borrow表中添加借閱信息(借書)
        //輸出：
        //      插入成功：返回True；
        //      插入失敗：返回False；
        public bool InsertByProc()
        {
            SqlParameter[] Params = new SqlParameter[5];

            DataBase DB = new DataBase();

            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, UserID);                   //用戶編號
            Params[1] = DB.MakeInParam("@BookID", SqlDbType.Int , 4, BookID);                       //書號
            Params[2] = DB.MakeInParam("@BorrowBeginDate", SqlDbType.DateTime, 8, BorrowBeginDate); //借閱時間
            Params[3] = DB.MakeInParam("@BorrowEndDate", SqlDbType.DateTime, 8, BorrowEndDate);     //還書時間
            Params[4] = DB.MakeInParam("@BorrowState", SqlDbType.Int, 4, BorrowState);              //借書狀態
            
            int Count = -1;
            Count = DB.RunProc("Proc_BorrowAdd", Params);
            if (Count > 0)
                return true;
            else return false;
        }

        //還書
        public bool UpdateByProc(int XBookID)
        {
            SqlParameter[] Params = new SqlParameter[2];
            DataBase DB = new DataBase();           
            Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, BookID);                       //書號           
            Params[1] = DB.MakeInParam("@BorrowState", SqlDbType.Int, 4, BorrowState);              //借書狀態

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

        //查詢借閱歷史        
        public DataSet QueryBorrowHistory(string XUserID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase DB = new DataBase();
            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID);                       //書號            
            return DB.GetDataSet("Proc_ReaderBorrowHistory",Params);
        }

        //查詢目前借閱圖書        
        public DataSet QueryCurrentBorrow(string XUserID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase DB = new DataBase();
            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID);                       //書號            
            return DB.GetDataSet("Proc_ReaderCurrentBorrow", Params);
        }

        //查詢超期該還圖書        
        public DataSet QueryExpireBorrow(string XUserID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase DB = new DataBase();
            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID);                       //書號            
            return DB.GetDataSet("Proc_ReaderExpireCuiHuan", Params);
        }

        //查詢目前借閱圖書數量        
        public int QueryCurrentBorrowCount(string XUserID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase DB = new DataBase();
            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID);                       //書號            
            return DB.RunProcGetCount("Proc_ReaderCurrentBorrowCount", Params);
        }

        #endregion 方法
    }
}