readerinfo.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;

namespace DataAccess
{
    public class ReaderInfo
    {
        //初始化公用层里的CommonOperator类
        Common.CommonOperator objCommonOpera = new CommonOperator();
        /// <summary>
        /// 此方法调用通用层的Search方法得到ReaderInfo表的所有数据
        /// </summary>
        /// <param name="sql">查询Reader表的字符串</param>
        /// <param name="sqlTable">Reader表名</param>
        /// <returns>返回Reader表里的所有数据</returns>
        public DataTable GridViewReaderInfo()
        {
            DataTable ReaderInfoTable = null;
            string sql = "select ReaderID as '读者编号',ReaderName as '姓名', ReaderSex as '性别',ReaderBirthday as '生日',ReaderCertificate as '有效证件',"
+"ReaderCertificateID as '证件号',ReaderPhone as '电话',ReaderAccession as '登记日期',ReaderRestrict as '至限制日期',ReaderDistinction as '读者级别',"
+"ReaderDay as '限制借阅天数',ReaderMoney as '押金',ReaderAdmin as '操作员',ReaderRemark as '备注',ReaderBookBorrowNum as '借阅书记次数',"+
"ReaderMagazineBorrowNum as '借阅期刊次数',ReaderState as '是否挂失' from  Reader";
            string sqlTable = "Reader";
            try
            {
                objCommonOpera.ConnectDb();
                ReaderInfoTable = objCommonOpera.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOpera.CloseDb();
            }
            return ReaderInfoTable;
        }
        /// <summary>
        /// 此方法调公用层的Search方法返回一个模糊查询的DataTable
        /// </summary>
        /// <param name="name">读者姓名</param>
        /// <returns>返回模糊查询的DataTable</returns>
        public DataTable SelectLikeName(string name)
        {
            DataTable objReaderTable = new DataTable();
            string sql = "select ReaderID as '读者编号',ReaderName as '姓名', ReaderSex as '性别',ReaderBirthday as '生日',ReaderCertificate as '有效证件',"
+ "ReaderCertificateID as '证件号',ReaderPhone as '电话',ReaderAccession as '登记日期',ReaderRestrict as '至限制日期',ReaderDistinction as '读者级别',"
+ "ReaderDay as '限制借阅天数',ReaderMoney as '押金',ReaderAdmin as '操作员',ReaderRemark as '备注',ReaderBookBorrowNum as '借阅书记次数'," +
"ReaderMagazineBorrowNum as '借阅期刊次数',ReaderState as '是否挂失' from  Reader where ReaderName like'%" + name + "%'";
            string sqlTable = "ReaderInfo";
            try
            {
                objCommonOpera.ConnectDb();
                objReaderTable = objCommonOpera.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOpera.CloseDb();
            }
            return objReaderTable;
        }
        /// <summary>
        /// 此方法调公用层的Search方法返回一个模糊查询的DataTable
        /// </summary>
        /// <param name="ID">读者编号</param>
        /// <returns>返回模糊查询的DataTable</returns>
        public DataTable SelectLikeID(string ID)
        {
            DataTable objReaderTable = new DataTable();
            string sql = "select ReaderID as '读者编号',ReaderName as '姓名', ReaderSex as '性别',ReaderBirthday as '生日',ReaderCertificate as '有效证件',"
+ "ReaderCertificateID as '证件号',ReaderPhone as '电话',ReaderAccession as '登记日期',ReaderRestrict as '至限制日期',ReaderDistinction as '读者级别',"
+ "ReaderDay as '限制借阅天数',ReaderMoney as '押金',ReaderAdmin as '操作员',ReaderRemark as '备注',ReaderBookBorrowNum as '借阅书记次数'," +
"ReaderMagazineBorrowNum as '借阅期刊次数',ReaderState as '是否挂失' from  Reader where ReaderID like '%" + ID + "%'";
            string sqlTable = "ReaderInfo";
            try
            {
                objCommonOpera.ConnectDb();
                objReaderTable = objCommonOpera.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOpera.CloseDb();
            }
            return objReaderTable;
        }
        /// <summary>
        /// 查询读者的押金
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
     
        public DataTable SelectReaderMoney(string ID)
        {
            DataTable objReaderTable = new DataTable();
            string sql = "select ReaderMoney from Reader ";
            string sqlTable = "ReaderMoney";
            try
            {
                objCommonOpera.ConnectDb();
                objReaderTable = objCommonOpera.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOpera.CloseDb();
            }
            return objReaderTable;
        }
    }
}