t_borrow.cs

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

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

namespace BLL
{
    public class T_Borrow
    {
        private PublicClass.BorrowModel _Borrow;

        public PublicClass.BorrowModel Borrow
        {
            get { return _Borrow; }
            set { _Borrow = value; }
        }
        DAL.DB_Borrow borrow = new DAL.DB_Borrow();

        /// <summary>
        /// 插入借书信息
        /// </summary>
        /// <returns>返回0表示借书操作成功，-1表示读者ID不存在，1表示图书ID不存在，2表示图书已借出，3表示借书操作失败。</returns>
        public int BorrowBook()
        {
            DAL.DB_Reader read = new DAL.DB_Reader();
            PublicClass.ReaderModel reader = new PublicClass.ReaderModel();
            reader.CardID = _Borrow.CardID;
            read.Reader = reader;
            //校验读者ID
            DataTable dt= read.Search();
            if (dt.Rows.Count == 0)
            {
                return -1;
            }
            DAL.DB_Book book = new DAL.DB_Book();
            PublicClass.BookModel Book = new PublicClass.BookModel();
            Book.ManID = _Borrow.ManID;
            book.Book = Book;
            //校验图书ID
            dt = book.Search();
            if (dt.Rows.Count == 0)
            {
                return 1;
            }
            DAL.V_BORROW v = new DAL.V_BORROW();
            //判断图书是否借出
            dt=v.SelectBookRutrun(_Borrow.ManID);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i].ItemArray[0].ToString()== "")
                {
                    return 2;
                }
            }
            borrow.Borrow = _Borrow;
            //插入借书信息
            int row=borrow.Insert();
            if (row > 0)
            {
                return 0;
            }
            else
            {
                return 3;
            }
        }

        /// <summary>
        /// 插入还书信息
        /// </summary>
        /// <returns>返回0表示还书操作成功，-1表示读者ID不存在，1表示图书ID不存在，2表示该图书未借出，3表示还书操作失败。</returns>
        public int ReturnBook()
        {
            DAL.DB_Reader read = new DAL.DB_Reader();
            PublicClass.ReaderModel reader = new PublicClass.ReaderModel();
            reader.CardID = _Borrow.CardID;
            read.Reader = reader;
            //校验读者ID
            DataTable dt = read.Search();
            if (dt.Rows.Count == 0)
            {
                return -1;
            }
            DAL.DB_Book book = new DAL.DB_Book();
            PublicClass.BookModel Book = new PublicClass.BookModel();
            Book.ManID = _Borrow.ManID;
            book.Book = Book;
            //校验图书管理编号
            dt = book.Search();
            if (dt.Rows.Count == 0)
            {
                return 1;
            }
            DAL.V_BORROW v = new DAL.V_BORROW();
            //查询图书借出信息
            dt = v.SelectBookRutrun(_Borrow.ManID,_Borrow.CardID);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i].ItemArray[0].ToString() == "")
                {
                    //更新借书信息
                    borrow.Borrow = _Borrow;
                    int row = borrow.Update();
                    if (row > 0)
                    {
                        return 0;
                    }
                    else
                    {
                        return 3;
                    }
                }
            }
            return 2;
        }
    }
}