book.cs

图书管理系统

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;                                //书号
        private string _bookName;                           //书名
        private string _bookISBN;                           //ISBN
        private string _bookAuthor;                         //作者
        private string _bookPublish;                        //出版社
        private DateTime _bookPublishDate;                  //出版时间
        private string _bookClassify;                       //分类
        private string _bookSubject;                        //主题
        private string _bookIndex;                          //索书号
        private double _bookPrice;                          //价格
        private int _bookPageNum;                           //页数
        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 方法

        //根据书号 BookID 初始化
        //输入：
        //      XBookID - 书号；
        //输出：
        //      书存在：返回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);                       //书号            

            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");                         //书号                
                this._bookName = GetSafeData.ValidateDataRow_S(DR, "BookName");                     //书名
                this._bookISBN = GetSafeData.ValidateDataRow_S(DR, "BookISBN");                     //书ISBN号
                this._bookAuthor = GetSafeData.ValidateDataRow_S(DR, "BookAuthor");                 //作者
                this._bookPublish = GetSafeData.ValidateDataRow_S(DR, "BookPublish");               //出版社
                this._bookPublishDate = GetSafeData.ValidateDataRow_T(DR, "BookPublishDate");       //出版时间
                this._bookClassify = GetSafeData.ValidateDataRow_S(DR, "BookClassify");             //分类
                this._bookSubject = GetSafeData.ValidateDataRow_S(DR, "BookSubject");               //主题
                this._bookIndex = GetSafeData.ValidateDataRow_S(DR, "BookIndex");                   //索引号
                this._bookPrice = GetSafeData.ValidateDataRow_F(DR, "BookPrice");                   //价格
                this._bookPageNum = GetSafeData.ValidateDataRow_N(DR, "BookPageNum");               //页数                
                this._bookSeries = GetSafeData.ValidateDataRow_S(DR, "BookSeries");                 //系列
                this._bookDescription = GetSafeData.ValidateDataRow_S(DR, "BookDescription");       //介绍                
                return true;
            }
            else
            {
                return false;
            }
        }

        //根据BookID判断该图书是否存在
        //输入：
        //      XBookID - 用户编号；        
        //输出：
        //      用户存在：返回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);                  //书号            

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

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


        //向Books表中添加书籍信息(采用存储过程)
        //输出：
        //      插入成功：返回True；
        //      插入失败：返回False；
        public bool InsertByProc()
        {
            SqlParameter[] Params = new SqlParameter[12];

            DataBase DB = new DataBase();

            //Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, BookID);                        //书号
            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); //出版时间
            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);             //索引号
            Params[8] = DB.MakeInParam("@BookPrice", SqlDbType.Float, 8, BookPrice);          //价格
            Params[9] = DB.MakeInParam("@BookPageNum", SqlDbType.Int, 4, BookPageNum);             //页数
            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);                       //书号
            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); //出版时间
            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);             //索引号
            Params[9] = DB.MakeInParam("@BookPrice", SqlDbType.Float, 8, BookPrice);          //价格
            Params[10] = DB.MakeInParam("@BookPageNum", SqlDbType.Int, 4, BookPageNum);             //页数
            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 - 书号；
        //输出：
        //      删除成功：返回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);               //书号          

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

        
        //查询所有书籍
        //不需要参数
        public DataSet QueryBooks()
        {
            DataBase DB = new DataBase();
            return DB.GetDataSet("Proc_BookList");
        }

        
        ////查询最大书号
        //public int QueryMaxID()
        //{
        //    DataBase DB = new DataBase();
        //    SqlDataReader sdr = DB.RunProcGetReader("Proc_MaxBookID");
        //    return int.Parse(sdr["maxbookid"].ToString());
        //}

        #endregion 方法
    }
}