selectinfo.cs

数据库课程设计

            {
                objTable = objBookBorrowRead.SelectBookBorrowInfo(BookID, Lose);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 根据期刊编号查询信息
        /// </summary>
        /// <param name="MagazineID">期刊编号</param>
        /// <returns>返回objTable</returns>
        public DataTable selectMagazineInfo(string BarCode)
        {
            DataTable objTable = null;
            try
            {
                objTable = objMagazineBorrowRead.selectMagazineInfo(BarCode);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 子查询
        /// 根据期刊编号和状态查询当前借阅次期刊的读者
        /// </summary>
        /// <param name="MagazineID">期刊编号</param>
        /// <param name="Lose">状态</param>
        /// <returns>返回objTable</returns>
        public DataTable SelectBorrowMagazineReader(string MagazineID, string Lose)
        {
            DataTable objTable = null;
            try
            {
                objTable = objMagazineBorrowRead.SelectBorrowMagazineReader(MagazineID, Lose);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return objTable;
        }
        /// <summary>
        /// 此方法根据图书编号和读者编号和状态查询，=0说明没数据，没借过这本书（根据读者编号+图书编号+状态，因为这3者是唯一的）
        /// </summary>
        /// <param name="ReaderID">读者编号</param>
        /// <returns>如果没借过返回true，否则返回false</returns>
        public bool MagazineSelect(string MagazineName)
        {
            DataTable objTable = null;
        
            try
            {
                objTable = objMagazineInfo.MagazineSelect(MagazineName);
                if (objTable.Rows.Count == 0)
                {
                    return true;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return false;
        }
        /// <summary>
        /// 书籍丢失罚款
        /// </summary>
        /// <param name="BookID">图书编号</param>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="money">罚款金额</param>
        public void InsertBookLose(string BookID, string ReaderID, double CompensateMoney, string BookLoseAdmin)
        {
            try
            {
                objLose.InsertBookLose(BookID, ReaderID, CompensateMoney, BookLoseAdmin);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 删除丢失书籍在书籍借阅表的信息
        /// </summary>
        /// <param name="BookID">书籍ID</param>
        /// <param name="ReaderID">读者ID</param>
        public void delBorrowBook(string BookID, string ReaderID)
        {
            try
            {
                objBookBorrowRead.delBorrowBook(BookID, ReaderID);
                
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 插入期刊丢失信息
        /// </summary>
        /// <param name="MagazineID"></param>
        /// <param name="ReaderID"></param>
        /// <param name="CompensateMoney"></param>
        /// <param name="BMagazineLoseAdmin"></param>
        public void InsertMagazineLose(string MagazineID, string ReaderID, double CompensateMoney, string BMagazineLoseAdmin)
        {
            try
            {
                objLose.InsertMagazineLose(MagazineID, ReaderID, CompensateMoney, BMagazineLoseAdmin);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 删除丢失期刊在期刊借阅表的信息
        /// </summary>
        /// <param name="MagazineID"></param>
        /// <param name="ReaderID"></param>
        public void delMagazineLose(string MagazineID, string ReaderID)
        {
            try
            {
                objMagazineBorrowRead.delMagazineLose(MagazineID, ReaderID);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 插入期刊罚款信息信息
        /// </summary>
        /// <param name="MagazineID"></param>
        /// <param name="ReaderID"></param>
        /// <param name="CompensateMoney"></param>
        /// <param name="BMagazineLoseAdmin"></param>
        public void InsertBookAmerce(string MagazineID, string ReaderID, double CompensateMoney, double Amercemoney, string BMagazineLoseAdmin)
        {
            try
            {
                objAmerce.InsertBookAmerce(MagazineID, ReaderID, CompensateMoney, Amercemoney, BMagazineLoseAdmin);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 插入期刊罚款信息
        /// </summary>
        /// <param name="MagazineID"></param>
        /// <param name="ReaderID"></param>
        /// <param name="CompensateMoney"></param>
        /// <param name="BMagazineLoseAdmin"></param>
        public void InsertMagazineAmerce(string MagazineID, string ReaderID, double CompensateMoney, double Amercemoney, string BMagazineLoseAdmin)
        {
            try
            {
                objAmerce.InsertMagazineAmerce(MagazineID, ReaderID, CompensateMoney, Amercemoney, BMagazineLoseAdmin);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 删除书籍丢失表信息
        /// </summary>
        /// <param name="BookID"></param>
        /// <param name="ReaderID"></param>
        public void delBookLose(string BookID, string ReaderID)
        {
            try
            {
                objLose.delBookLose(BookID, ReaderID);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 删除期刊丢失表的信息
        /// </summary>
        /// <param name="MagazineID"></param>
        /// <param name="ReaderID"></param>
        public void delMagazineLoseA(string MagazineID, string ReaderID)
        {
            try
            {
                objLose.delMagazineLose(MagazineID, ReaderID);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 删除书籍罚款表的信息
        /// </summary>
        /// <param name="BookID"></param>
        /// <param name="ReaderID"></param>
        public void delBookAmerce(string BookID, string ReaderID)
        {
            try
            {
                objAmerce.delBookAmerce(BookID, ReaderID);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 删除期刊罚款表的信息
        /// </summary>
        /// <param name="MagazineID"></param>
        /// <param name="ReaderID"></param>
        public void delMagazineAmerce(string MagazineID, string ReaderID)
        {
            try
            {
                objAmerce.delMagazineAmerce(MagazineID, ReaderID);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 返回丢失书籍表信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewBookLoseTable()
        {
            DataTable BookLoseInfoTable = null;
            try
            {
                BookLoseInfoTable = objLose.GridViewBookLose();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookLoseInfoTable;
        }
        /// <summary>
        /// 根据读者编号对书籍丢失表进行模糊查找
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectLikeBookLose(string ReaderID)
        {
            DataTable BookLoseInfoTable = null;
            try
            {
                BookLoseInfoTable = objLose.SelectLikeBookLose(ReaderID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookLoseInfoTable;
        }
        /// <summary>
        /// 返回丢失期刊表信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewMagazineLoseTable()
        {
            DataTable MagazineLoseInfoTable = null;
            try
            {
                MagazineLoseInfoTable = objLose.GridViewMagazineLose();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return MagazineLoseInfoTable;
        }
        /// <summary>
        /// 根据读者编号对期刊丢失表进行模糊查找
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectLikeMagazineLose(string ReaderID)
        {
            DataTable BookLoseInfoTable = null;
            try
            {
                BookLoseInfoTable = objLose.SelectLikeMagazineLose(ReaderID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookLoseInfoTable;
        }

        /// <summary>
        /// 返回书籍罚款表信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewBookAmerceTable()
        {
            DataTable BookAmerceInfoTable = null;
            try
            {
                BookAmerceInfoTable = objAmerce.GridViewBookAmerce();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookAmerceInfoTable;
        }
        /// <summary>
        /// 根据读者编号对书籍罚款表进行模糊查找
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectLikeBookAmerce(string ReaderID)
        {
            DataTable BookAmerceInfoTable = null;
            try
            {
                BookAmerceInfoTable = objAmerce.SelectLikeBookAmerce(ReaderID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookAmerceInfoTable;
        }
        /// <summary>
        /// 返回丢失期刊表信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewMagazineAmerceTable()
        {
            DataTable MagazineAmerceInfoTable = null;
            try
            {
                MagazineAmerceInfoTable = objAmerce.GridViewMagazineAmerce();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return MagazineAmerceInfoTable;
        }
        /// <summary>
        /// 根据读者编号对期刊罚款表进行模糊查找
        ///