selectinfo.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DataAccess;
namespace Bussiness
{
    public class SelectInfo
    {
        //初始化数据层里的ReaderInfo的实例
        ReaderInfo objReader = new ReaderInfo();
        //初始化数据层里的BookInfo的实例
        BookInfo objBookInfo = new BookInfo();
        //初始化数据层的MagazineInfo的实例
        MagazineInfo objMagazineInfo = new MagazineInfo();
        //初始化数据层里的BookBorrowRead的实例
        BookBorrowRead objBookBorrowRead = new BookBorrowRead();
        //初始化数据层的MagazineBorrowRead类的实例
        MagazineBorrowRead objMagazineBorrowRead = new MagazineBorrowRead();
        //初始化数据层Lose类的实例
        Lose objLose = new Lose();
        //初始化Amerce类的实例
        Amerce objAmerce = new Amerce();
        //初始化SelectAdminInfo类的实例
        SelectAdminInfo objSelectAdminInfo = new SelectAdminInfo();
        //初始化BookConcernInfo的对象
        BookConcernInfo objBookConcernInfo = new BookConcernInfo();
        
        /// <summary>
        /// 此方法调用数据层的GridViewReader方法得到Reader表的所有数据放到GridViewReader上
        /// </summary>
        /// <returns>返回Reader表的数据</returns>
        public DataTable GridViewReaderTable()
        {
            DataTable ReaderInfoTable = null;
            try
            {
                ReaderInfoTable = objReader.GridViewReaderInfo();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return ReaderInfoTable;
        }
        /// <summary>
        /// 此方法调用数据层的GridViewBookInfo方法得到Books表的所有数据方到GridViewBookInfo上
        /// </summary>
        /// <returns>返回Books表的所有数据</returns>
        public DataTable GridViewBookInfoTable()
        {
            DataTable BookInfoTable = null;
            try
            {
                BookInfoTable = objBookInfo.GridViewBookInfo();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookInfoTable;
        }
        /// <summary>
        /// 此方法调用访问层的SelectLikeBookName方法得到模糊查询到的数据
        /// </summary>
        /// <param name="name">图书名称</param>
        /// <returns>返回根据书名查找到的DataTable</returns>
        public DataTable SeleLikeBookName(string name)
        {
            DataTable objBookInfoTable = null;
            try
            {
                objBookInfoTable = objBookInfo.SelectLikeBookName(name);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objBookInfoTable;
        }
        /// <summary>
        /// 此方法调用访问层的SelectLikeBookID方法得到模糊查询到的数据
        /// </summary>
        /// <param name="ID">图书编号</param>
        /// <returns>返回根据图书编号查找到的DataTable</returns>
        public DataTable SeleLikeBookID(string Type)
        {
            DataTable objBookInfoTable = null;
            try
            {
                objBookInfoTable = objBookInfo.SelectLikeBookID(Type);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objBookInfoTable;
        }
        /// <summary>
        /// 此方法调用访问层的SelectLikeName方法得到模糊查找到的一个DataTable
        /// </summary>
        /// <param name="name">读者姓名</param>
        /// <returns>返回一个模糊查找的DataTable</returns>
        public DataTable SeleLikeName(string name)
        {
            DataTable objReaderTable = null;
            try
            {
                objReaderTable = objReader.SelectLikeName(name);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objReaderTable;
        }
        /// <summary>
        /// 此方法通过调用访问层的SelectLikeID方法得到模糊查找到一个DataTable
        /// </summary>
        /// <param name="ID">读者编号</param>
        /// <returns>返回1个模糊查找到的DataTable</returns>
        public DataTable SeleLikeID(string memberID)
        {
            DataTable objReaderTable = null;
            try
            {
                objReaderTable = objReader.SelectLikeID(memberID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objReaderTable;
        }
        /// <summary>
        /// 此方法返回期刊表的所有数据
        /// </summary>
        /// <returns></returns>
        public DataTable SelectMagazineInfo()
        {
            DataTable objTable = null;
            try
            {
                objTable = objMagazineInfo.SelectMagazineInfo();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 根据期刊名称进行模糊查询
        /// </summary>
        /// <param name="Magazine">期刊名称</param>
        /// <returns>返回objTable</returns>
        public DataTable SeleLikeMagazineName(string Magazine)
        {
            DataTable objTable = null;
            try
            {
                objTable = objMagazineInfo.SelectMagazineName(Magazine);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 根据期刊ID进行模糊查询
        /// </summary>
        /// <param name="ID">期刊编号</param>
        /// <returns>返回objTable</returns>
        public DataTable SeleLikeMagazineID(string Type)
        {
            DataTable objTable = null;
            try
            {
                objTable = objMagazineInfo.SelectMagazineID(Type);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 此方法根据图书编号和读者编号和状态查询，=0说明没数据，没借过这本书（根据读者编号+图书编号+状态，因为这3者是唯一的）
        /// </summary>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="BookID">图书编号</param>
        /// <returns>如果没借过返回true，否则返回false</returns>
        public bool BookBorrowReadLose(string ReaderID, string BookID, string Lose)
        {
            DataTable objTable = null;
       
            try
            {
                objTable = objBookBorrowRead.BookBorrowReadLose(ReaderID, BookID, Lose);
                if (objTable.Rows.Count == 0)
                {
                    return true;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return false;
        }
        /// <summary>
        /// 此方法过渡下数据访问的ProcBorrow方法
        /// </summary>
        /// <param name="BorrowNum"></param>
        /// <param name="ReaderID"></param>
        /// <param name="BookID"></param>
        public void ProcBorrow(string ReaderID, string BookID, double BookMoney)
        {
            try
            {
                objBookBorrowRead.ProcBorrow(ReaderID, BookID, BookMoney);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 根据读者编号查询信息
        /// </summary>
        /// <param name="ReaderID">读者编号</param>
        /// <returns>返回objTable</returns>
        public DataTable selectReaderInfo(string memberID)
        {
            DataTable objTable = null;
            try
            {
                objTable = objBookBorrowRead.selectReaderInfo(memberID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 子查询
        /// 根据读者编号+状态查询信息
        /// </summary>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="Lose">状态</param>
        /// <returns>返回objTable</returns>
        public DataTable SelectReaderBorrowBook(string ReaderID, string Lose)
        {
            DataTable objTable = null;
            try
            {
                objTable = objBookBorrowRead.SelectReaderBorrowBook(ReaderID, Lose);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 子查询
        /// 根据读者编号＋状态查询信息
        /// </summary>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="Lose">状态</param>
        /// <returns>返回objTable</returns>
        public DataTable SelectMagazineBorrowInfo(string ReaderID, string Lose)
        {
            DataTable objTable = null;
            try
            {
                objTable = objMagazineInfo.SelectMagazineBorrowInfo(ReaderID, Lose);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 根据图书编号查询
        /// </summary>
        /// <param name="BookID">图书编号</param>
        /// <returns>返回objTable</returns>
        public DataTable selectBookInfo(string BarCode)
        {
            DataTable objTable = null;
            try
            {
                objTable = objBookBorrowRead.selectBookInfo(BarCode);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 根据图书编号查询图书的借阅价格
        /// </summary>
        /// <param name="BookID">图书编号</param>
        /// <returns>返回objTable</returns>
        public DataTable SelectBooksBookID(string BarCode)
        {
            DataTable objTable = null;
            try
            {
                objTable = objBookInfo.SelectBooksBookID(BarCode);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 根据期刊ID查询期刊的借阅价格
        /// </summary>
        /// <param name="BarCode">期刊ID</param>
        /// <returns></returns>
        public DataTable SelectMagazineborrowPrice(string BarCode)
        {
            DataTable objTable = null;
            try
            {
                objTable = objMagazineInfo.SelectMagazineborrowPrice(BarCode);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }

        /// <summary>
        /// 查询读者的押金
        /// </summary>
        /// <param name="BarCode"></param>
        /// <returns></returns>
        public DataTable SelectReaderMoney(string BarCode)
        {
            DataTable objTable = null;
            try
            {
                objTable = objReader.SelectReaderMoney(BarCode);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 子查询
        /// 根据图书编号＋状态查询
        /// </summary>
        /// <param name="BookID">图书编号</param>
        /// <param name="Lose">状态</param>
        /// <returns>返回objTable</returns>
        public DataTable SelectBookBorrowInfo(string BookID, string Lose)
        {
            DataTable objTable = null;
            try