t_book.cs

这是一个很好的图书管理系统 数据库SQL2005

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

namespace BLL
{
    public class T_Book
    {

        DAL.DB_Book book = new DAL.DB_Book();

        private BookModel _Book;

        public BookModel Book
        {
            get { return _Book; }
            set { _Book = value; }
        }

        /// <summary>
        /// 查询图书
        /// </summary>
        /// <param name="key">管理编号</param>
        /// <returns>返回DataTable</returns>
        public DataTable SelectBook(string key)
        {
            return book.Select(key);
        }

        /// <summary>
        /// 查询图书
        /// </summary>
        /// <param name="key">条件</param>
        /// <param name="se">字段</param>
        /// <returns>返回DataTable</returns>
        public DataTable SelectBook(string key,string se)
        {
            return book.Select(key,se);
        }

        /// <summary>
        /// 查询所以图书信息
        /// </summary>
        /// <returns>返回DataTable</returns>
        public DataTable SelectBook()
        {
            return book.Select();
        }

        /// <summary>
        /// 增加图书
        /// </summary>
        /// <returns>返回0表示增加失败，返回1表示增加成功。</returns>
        public int InsertBook()
        {
            book.Book = _Book;
            //检索管理编号是否存在
            if (book.Search().Rows.Count > 0)
            {
                return -1;
            }
            int row = book.Insert();
            if (row < 0)
            {
                return 0;
            }
            else
            {
                return 1;
            }
        }

        /// <summary>
        /// 获取图书信息，并赋给图书实体供界面层使用。
        /// </summary>
        public void SelectBookID()
        {
            book.Book = _Book;
            DataTable dt = book.SearchBookID();
            _Book.ManID = dt.Rows[0].ItemArray[1].ToString();
            _Book.BookName = dt.Rows[0].ItemArray[2].ToString();
            _Book.Writer = dt.Rows[0].ItemArray[3].ToString();
        }

        /// <summary>
        /// 更新图书
        /// </summary>
        /// <returns>返回1表示更新成功，返回0表示更新失败。</returns>
        public int UpdateBook()
        {
            book.Book = _Book;
            int temp = book.Update();
            if (temp > 0)
            {
                return 1;
            }
            else
            {
                return 0;
            }
        }

        /// <summary>
        /// 删除图书
        /// </summary>
        /// <returns>返回1表示删除成功，返回0表示删除失败。</returns>
        public int DeleteBook()
        {
            book.Book = _Book;
            int temp = book.Delete();
            if (temp > 0)
            {
                return 1;
            }
            else
            {
                return 0;
            }
        }

        /// <summary>
        /// 查询图书信息
        /// </summary>
        /// <param name="id">图书编号（BOOKID）</param>
        /// <returns>返回DataTable</returns>
        public DataTable ReturnBookDetail(string id)
        {
            DAL.V_BORROW v = new DAL.V_BORROW();
            return v.BookBorrow(id);
        }
    }
}