selectinfo.cs

数据库课程设计

        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectMagazineAmerce(string ReaderID)
        {
            DataTable MagazineAmerceInfoTable = null;
            try
            {
                MagazineAmerceInfoTable = objAmerce.SelectMagazineAmerce(ReaderID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return MagazineAmerceInfoTable;
        }
        /// 此方法过渡一下数据层的ProcBorrowMagazine方法
        /// </summary>
        /// <param name="MagazineID">期刊编号</param>
        /// <param name="ReaderID">读者编号</param>

        public void ProcBorrowMagazine(string MagazineID, string ReaderID, double MagazineMoney)
        {
            try
            {
                objMagazineBorrowRead.ProcBorrowMagazine(MagazineID, ReaderID, MagazineMoney);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 此方法根据图书编号和读者编号和状态查询，=0说明没数据，没借过这本书（根据读者编号+图书编号+状态，因为这3者是唯一的）
        /// </summary>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="BookID">图书编号</param>
        /// <returns>如果没借过返回true，否则返回false</returns>
        public bool MagazineBorrowLose(string MagazineID, string BookID, string Lose)
        {
            DataTable objTable = null;

            try
            {
                objTable = objMagazineBorrowRead.MagazineBorrowLose(MagazineID, BookID, Lose);
                if (objTable.Rows.Count == 0)
                {
                    return true;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return false;
        }
        /// <summary>
        /// 此方法过渡下数据访问的ProcReturn方法
        /// </summary>
        /// <param name="BorrowNum"></param>
        /// <param name="ReaderID"></param>
        /// <param name="BookID"></param>
        public void ProcReturn(string ReaderID, string BookID, string Lose, double Price)
        {
            try
            {
                objBookBorrowRead.ProcReturn(ReaderID, BookID, Lose, Price);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 根据读者编号 图书编号 状态 查询该读者是否超过应该还书的时间
        /// </summary>
        /// <param name="BookID">图书编号</param>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="Lose">状态</param>
        /// <returns>没超过返回 真，超过返回 假</returns>
        public bool SelectOverdoeReaderID(string BookID, string ReaderID, string Lose)
        {
            DataTable objTable = null;
            try
            {
                objTable = objBookBorrowRead.SelectOverdoeReaderID(BookID, ReaderID, Lose);
                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="Lose"></param>
     /// <returns></returns>
        public int SelectBookBorrowTime(string BookID, string ReaderID, string Lose)
        {
            int d;
            int m;
            DataTable objTable = null;
          
        
            try
            {
                objTable = objBookBorrowRead.SelectBookBorrowTime(BookID, ReaderID, Lose);
      
                DateTime date = Convert.ToDateTime(objTable.Rows[0][0].ToString());
                int Month = date.Month;
                int Day = date.Day;
                int yue = DateTime.Today.Month;
                int ri = DateTime.Today.Day;
                if (ri >= Day)
                {
                    d = ri - Day;
                    if (yue > Month)
                    {
                        m = yue - Month;
                        m = m * 30;
                        m = m + d;
                        return m;
                    }
                    return d;
                }
                else
                {
                    d = Day - ri;
                    m = yue - Month;
                    m = m * 30;
                    m = m - d;
                    return m;
                }
           
            }
            catch (Exception ex)
            {
                throw ex;
            }
      
        }
        /// <summary>
        /// 书籍过期归还100天8折出售书
        /// </summary>
        /// <param name="Price"></param>
        /// <param name="ReaderID"></param>
        public void ReaderBooksMony(double Price, string ReaderID)
        {
            try
            {
                objLose.ReaderBooksMony(Price, ReaderID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 根据期刊编号+读者编号+状态 查询读者借阅期刊过期没有?
        /// </summary>
        /// <param name="MagazineID">期刊编号</param>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="Lose">状态</param>
        /// <returns>返回bool</returns>
        public bool MagazineOverdoeReaderID(string MagazineID, string ReaderID, string Lose)
        {
            DataTable objTable = null;
            try
            {
                objTable = objMagazineBorrowRead.MagazineOverdoeReaderID(MagazineID, ReaderID, Lose);
                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="Lose"></param>
        /// <returns></returns>
        public int SelectMagazineBorrowTime(string MagazineID, string ReaderID, string Lose)
        {
            int d;
            int m;
            DataTable objTable = null;
            try
            {
                objTable = objMagazineBorrowRead.SelectMagazineBorrowTime(MagazineID, ReaderID, Lose);
                DateTime date = Convert.ToDateTime(objTable.Rows[0][0].ToString());
                int Month = date.Month;
                int Day = date.Day;
                int yue = DateTime.Today.Month;
                int ri = DateTime.Today.Day;
                if (ri >= Day)
                {
                    d = ri - Day;
                    if (yue > Month)
                    {
                        m = yue - Month;
                        m = m * 30;
                        m = m + d;
                        return m;
                    }
                    return d;
                }
                else
                {
                    d = Day - ri;
                    m = yue - Month;
                    m = m * 30;
                    m = m - d;
                    return m;
                }

            }
            catch (Exception ex)
            {
                throw ex;
            }
       
        }
        /// <summary>
        /// 此方法过渡一下数据层的ProcReturnMagazine方法
        /// </summary>
        /// <param name="MagazineID">期刊编号</param>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="Price">期刊价钱</param>
        /// <param name="Lose">状态</param>
        public void ProcReturnMagazine(string MagazineID, string ReaderID, double Price, string Lose)
        {
            try
            {
                objMagazineBorrowRead.ProcReturnMagazine(MagazineID, ReaderID, Price, Lose);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 查询用户表，返回DataTable检查是否存在该用户
        /// </summary>
        /// <param name="AdminName"></param>
        /// <param name="AdminPassword"></param>
        /// <returns></returns>
        public DataTable SelectAdmin(string AdminName,string AdminPassword)
        {
            DataTable SelectAdminTable = null;
            try
            {
                SelectAdminTable = objSelectAdminInfo.SelectAdmin(AdminName, AdminPassword);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return SelectAdminTable;
        }
        /// <summary>
        /// 查询所有的用户信息返回
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAdminuserInfo()
        {
            DataTable SelectAdminTable = null;
            try
            {
                SelectAdminTable = objSelectAdminInfo.SelectAdminuserInfo();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return SelectAdminTable;
        }
        /// <summary>
        /// 查询改用户名是否有人使用
        /// </summary>
        /// <param name="AdminNnam"></param>
        /// <returns></returns>
        public bool SelectAdminNname(string AdminNnam)
        {
            DataTable objTable = null;

            try
            {
                objTable = objSelectAdminInfo.SelectAdminName(AdminNnam);
                if (objTable.Rows.Count == 0)
                {
                    return true;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return false;
        }
        /// <summary>
        /// 查询所有出版商信息
        /// </summary>
        /// <returns></returns>

        public DataTable GridViewBookConcernnfoTable()
        {
            DataTable BookInfoTable = null;
            try
            {
                BookInfoTable = objBookConcernInfo.SelectBookConcernInfo() ;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookInfoTable;
        }
        /// <summary>
        /// 根据出版商ID进行模糊查找
        /// </summary>
        /// <param name="BookConcernID"></param>
        /// <returns></returns>
        public DataTable selectLikeBookConcernID(string BookConcernID  )
        {
            DataTable BookInfoTable = null;
            try
            {
                BookInfoTable = objBookConcernInfo.SelectLikeBookConcernID(BookConcernID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookInfoTable;
        }
        /// <summary>
        /// 根据出版商名称进行模糊查找
        /// </summary>
        /// <param name="BookConcernID"></param>
        /// <returns></returns>
        public DataTable selectLikeBookConcernName(string BookConcernName)
        {
            DataTable BookInfoTable = null;
            try
            {
                BookInfoTable = objBookConcernInfo.SelectLikeBookConcernName(BookConcernName);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return BookInfoTable;
        }
    }
}