books.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using DataAccess;
using System.Data;
namespace Bussiness
{

    public class Books
    {
        BookInfo objBookInfo = new BookInfo();
        /// <summary>
        /// 添加一个新书
        /// </summary>
        /// <param name="BooksID"></param>
        /// <param name="BooksName"></param>
        /// <param name="BooksGenre"></param>
        /// <param name="BooksAuthor"></param>
        /// <param name="BookConcernID"></param>
        /// <param name="BooksPrice"></param>
        /// <param name="BooksborrowPrice"></param>
        /// <param name="BooksExistent"></param>
        /// <param name="BooksSum"></param>
        /// <param name="BooksEnterTime"></param>
        /// <param name="BooksAdmin"></param>
        /// <param name="BooksBriefIntroduction"></param>
        /// <param name="BooksBorrowNum"></param>
        /// <param name="BooksState"></param>
        public void InsertBooks(string BooksID, string BooksName, string BooksGenre, string BooksAuthor, string BookConcernID, double BooksPrice, double BooksborrowPrice, int BooksExistent, int BooksSum, string BooksEnterTime, string BooksAdmin, string BooksBriefIntroduction, int BooksBorrowNum, int BooksState)
        {
            try
            {
                objBookInfo.InsertBooks(BooksID, BooksName, BooksGenre, BooksAuthor, BookConcernID, BooksPrice, BooksborrowPrice, BooksExistent, BooksSum, BooksEnterTime, BooksAdmin, BooksBriefIntroduction, BooksBorrowNum, BooksState);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 更新书的数量
        /// </summary>
        /// <param name="BooksID"></param>
        /// <param name="BooksName"></param>
        /// <param name="BooksExistent"></param>
        /// <param name="BooksSum"></param>
        public void UpdateBooks(string BooksID, string BooksName, int BooksExistent, int BooksSum)
        {
            try
            {
                objBookInfo.UpdateBooks(BooksID, BooksName, BooksExistent, BooksSum);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 查询该书是否存在
        /// </summary>
        /// <param name="BooksID"></param>
        /// <param name="BooksName"></param>
        /// <returns></returns>
        public bool SelectBooks(string BooksID, string BooksName)
        {
            DataTable objTable = null;

            try
            {
                objTable = objBookInfo.SelectBooks(BooksID, BooksName);
                if (objTable.Rows.Count == 0)
                {
                    return true;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return false;
        }
        /// <summary>
        /// 更新书籍信息
        /// </summary>
        /// <param name="BooksID"></param>
        /// <param name="BooksName"></param>
        /// <param name="BooksGenre"></param>
        /// <param name="BooksAuthor"></param>
        /// <param name="BookConcernID"></param>
        /// <param name="BooksPrice"></param>
        /// <param name="BooksborrowPrice"></param>
        /// <param name="BooksExistent"></param>
        /// <param name="BooksSum"></param>
        /// <param name="BooksEnterTime"></param>
        /// <param name="BooksAdmin"></param>
        /// <param name="BooksBriefIntroduction"></param>
        /// <param name="BooksBorrowNum"></param>
        /// <param name="BooksState"></param>
        public void UpdateBooks(string BooksID, string BooksName, string BooksGenre, string BooksAuthor, string BookConcernID, double BooksPrice, double BooksborrowPrice, int BooksExistent, int BooksSum, string BooksEnterTime, string BooksAdmin, string BooksBriefIntroduction, int BooksBorrowNum, int BooksState)
        {
            try
            {
                objBookInfo.UpdateBooks(BooksID, BooksName, BooksGenre, BooksAuthor, BookConcernID, BooksPrice, BooksborrowPrice, BooksExistent, BooksSum, BooksEnterTime, BooksAdmin, BooksBriefIntroduction, BooksBorrowNum, BooksState);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 调用存储过程删除书籍信息
        /// </summary>
        /// <param name="BooksID"></param>
        public void procDelBooks(string BooksID)
        {
            try
            {
                objBookInfo.procDelBooks(BooksID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 删除出版社调用此方法
        /// </summary>
        /// <param name="BookConcernID"></param>
        public void BookConcernIDDelete(string BookConcernID)
        {
            try
            {
                objBookInfo.BookConcernIDDelete(BookConcernID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}