readerselect.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using DataAccess;
using System.Data;
using Business.UserException;
namespace Bussiness
{
   public class ReaderSelect
    {

       private Reader objDBAccess = new Reader();
        private DataTable drCheck = new DataTable();


        //此方法用于显示查询到读者信息的每个字段
        public DataTable SelectReader(string readID)
        {
            drCheck = objDBAccess.ReadIDcheck(readID);
            if (Rcheck(readID))
            {
                drCheck = objDBAccess.ReadIDcheck(readID);
            }
            return drCheck;

        }


        /// <summary> 
        /// 验证数据库中是否有正要添加的读者
        /// </summary>
        /// <param name="readID">读者编号</param>
        /// <returns>返回false 表示数据库中没有此读者，可以添加</returns>
        public bool Rcheck(string readID)
        {
            drCheck = objDBAccess.ReadIDcheck(readID);
            foreach (DataRow dr in drCheck.Rows)
            {
                if (readID == dr[0].ToString().Trim())
                {
                    return true;
                }

            }
            return false;
        }

        public void AddReader(string ReaderID,
           string ReaderName, string ReaderSex, double ReaderMoney, string ReaderDistinction,
            DateTime ReaderBirthday, DateTime ReaderAccession, DateTime ReaderRestrict,
            string ReaderState, int ReaderDay, string ReaderCertificate, string ReaderCertificateID,
            string ReaderPhone, string ReaderAdmin, int ReaderBookBorrowNum, int ReaderMagazineBorrowNum,
            string ReaderRemark)
        {
            try
            {
                //插入读者信息
                objDBAccess.InsertReaderInfo(ReaderID, ReaderName, ReaderSex, ReaderMoney, ReaderDistinction,
                    ReaderBirthday, ReaderAccession, ReaderRestrict, ReaderState, ReaderDay, ReaderCertificate,
                    ReaderCertificateID, ReaderPhone, ReaderAdmin, ReaderBookBorrowNum, ReaderMagazineBorrowNum,
                    ReaderRemark);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        //更新押金ReaderMoney的值
        public void updateMoney(string ReaderID, double ReaderMoney)
        {
            if (Rcheck(ReaderID))
            {
                objDBAccess.updateMoney(ReaderID, ReaderMoney);
            }
            else
            {
                throw new ReadercheckException();
            }
        }
        public void updateState(string ReaderID, string ReaderState)
        {
            if (Rcheck(ReaderID))
            {
                objDBAccess.updateReaderState(ReaderID, ReaderState);

            }
            else
            {
                throw new ReadercheckException();
            }
        }
        public DataTable RetureTable()
        {

            try
            {
                DataTable objDataTable = new DataTable();
                objDataTable = objDBAccess.ReaderAllShow();
                return objDataTable;
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }
       /// <summary>
       /// 根据读者编号删除读者信息
       /// </summary>
       /// <param name="ReaderID"></param>
        public void Delete(string ReaderID)
        {
            try
            {
                objDBAccess.ReaderDelete(ReaderID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
       /// <summary>
       /// 更新读者信息
       /// </summary>
       /// <param name="ReaderID"></param>
       /// <param name="ReaderName"></param>
       /// <param name="ReaderSex"></param>
       /// <param name="ReaderMoney"></param>
       /// <param name="ReaderDistinction"></param>
       /// <param name="ReaderBirthday"></param>
       /// <param name="ReaderAccession"></param>
       /// <param name="ReaderRestrict"></param>
       /// <param name="ReaderState"></param>
       /// <param name="ReaderDay"></param>
       /// <param name="ReaderCertificate"></param>
       /// <param name="ReaderCertificateID"></param>
       /// <param name="ReaderPhone"></param>
       /// <param name="ReaderAdmin"></param>
       /// <param name="ReaderBookBorrowNum"></param>
       /// <param name="ReaderMagazineBorrowNum"></param>
       /// <param name="ReaderRemark"></param>
       public void UpdateReader(string ReaderID,
   string ReaderName, string ReaderSex, double ReaderMoney, string ReaderDistinction,
    DateTime ReaderBirthday, DateTime ReaderAccession, DateTime ReaderRestrict,
    string ReaderState, int ReaderDay, string ReaderCertificate, string ReaderCertificateID,
    string ReaderPhone, string ReaderAdmin, int ReaderBookBorrowNum, int ReaderMagazineBorrowNum,
    string ReaderRemark)
       {
           try
           {
               //插入读者信息
               objDBAccess.UpdateReaderInfo(ReaderID, ReaderName, ReaderSex, ReaderMoney, ReaderDistinction,
                   ReaderBirthday, ReaderAccession, ReaderRestrict, ReaderState, ReaderDay, ReaderCertificate,
                   ReaderCertificateID, ReaderPhone, ReaderAdmin, ReaderBookBorrowNum, ReaderMagazineBorrowNum,
                   ReaderRemark);
           }
           catch (Exception ex)
           {
               throw ex;
           }
       }
       public void procDeleteReaderID(string ReaderID)
       {
           try
           {
               objDBAccess.procDeleteReaderID(ReaderID);
           }
           catch (Exception ex)
           {
               throw ex;
           }
       }
       /// <summary>
       /// 返回级别读者级别
       /// </summary>
       /// <param name="ReaderID"></param>
       /// <returns></returns>
       public DataTable SelectReaderDistinction(string ReaderID)
       {
           DataTable BookInfoTable = null;
           try
           {
               BookInfoTable = objDBAccess.SelectReaderDistinction(ReaderID);
           }
           catch (Exception ex)
           {
               throw ex;
           }
           return BookInfoTable;
       }
    }
}