recession.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using Common;
using System.Data;
namespace DataAccess
{
    public  class Recession
    {
        //初始化通用层的对象objCommonOperator
        CommonOperator objCommonOperator = new CommonOperator();
        /// <summary>
        /// 查询所有图书归还信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewBookRecession()
        {
            DataTable BookLoseTable = null;
            string sql = "select RecessionID   as '归还ID',BooksID  as '书籍编号', ReaderID  as '读者编号',RecessionTime   as '归还时间',DealMoney    as '付款金额',"
                + "RecessionAdmin  as '操作员' from  BookRecession";
            string sqlTable = "BookRecessionInfo";
            try
            {
                objCommonOperator.ConnectDb();
                BookLoseTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookLoseTable;
        }
        /// <summary>
        /// 按读者ID查询书籍归还信息
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectLikeBookRecession(string ReaderID)
        {
            DataTable BookLoseTable = null;
            string sql = "select RecessionID   as '归还ID',BooksID  as '书籍编号', ReaderID  as '读者编号',RecessionTime   as '归还时间',DealMoney    as '付款金额',"
                + "RecessionAdmin  as '操作员' from  BookRecession where ReaderID='" + ReaderID + "'";
            string sqlTable = "BookRecessionInfo";
            try
            {
                objCommonOperator.ConnectDb();
                BookLoseTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookLoseTable;
        }
        /// <summary>
        /// 查询所有期刊归还信息
        /// </summary>
        /// <returns></returns>
        public DataTable GridViewMagazineRecession()
        {
            DataTable BookLoseTable = null;
            string sql = "select RecessionID   as '归还ID',MagazineID   as '期刊编号', ReaderID  as '读者编号',RecessionTime   as '归还时间',DealMoney    as '付款金额',"
                + "MagazineRecessionAdmin   as '操作员' from  MagazineRecession";
            string sqlTable = "BookRecessionInfo";
            try
            {
                objCommonOperator.ConnectDb();
                BookLoseTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookLoseTable;
        }
        /// <summary>
        /// 根据编号查询期刊信息
        /// </summary>
        /// <param name="ReaderID"></param>
        /// <returns></returns>
        public DataTable SelectLikeMagazineRecession(string ReaderID)
        {
            DataTable BookLoseTable = null;
            string sql = "select RecessionID   as '归还ID',MagazineID   as '期刊编号', ReaderID  as '读者编号',RecessionTime   as '归还时间',DealMoney    as '付款金额',"
                + "MagazineRecessionAdmin   as '操作员' from  MagazineRecession where ReaderID='" + ReaderID + "'";
            string sqlTable = "BookRecessionInfo";
            try
            {
                objCommonOperator.ConnectDb();
                BookLoseTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookLoseTable;
        }
    }
}