t_reader.cs

这是一个很好的图书管理系统 数据库SQL2005

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using PublicClass;

namespace BLL
{
    public class T_Reader
    {
        DAL.DB_Reader read = new DAL.DB_Reader();

        private ReaderModel _Reader;

        public ReaderModel Reader
        {
            get { return _Reader; }
            set { _Reader = value; }
        }

        /// <summary>
        /// 查询读者信息
        /// </summary>
        /// <param name="id">读者ID</param>
        /// <returns>返回查询结果DataTable</returns>
        public DataTable SelectReader(string id)
        {
            return read.Select(id);
        }

        /// <summary>
        /// 查询读者信息
        /// </summary>
        /// <param name="re">字段</param>
        /// <param name="key">条件</param>
        /// <returns>返回查询结果DataTable</returns>
        public DataTable SelectReader(string re,string key)
        {
            return read.Select(key,re);
        }

        public DataTable SelectReader()
        {
            return read.Select();
        }

        /// <summary>
        /// 增加读者
        /// </summary>
        /// <returns>返回0表示增加失败，返回1表示成功。</returns>
        public int InsertReader()
        {
            read.Reader = _Reader;
            //校验读者ID
            if (read.Search().Rows.Count > 0)
            {
                return -1;
            }
            //插入信息
            int row = read.Insert();
            if (row < 0)
            {
                return 0;
            }
            else
            {
                return 1;
            }
        }

        /// <summary>
        /// 查询读者信息传给读者实体供界面层使用
        /// </summary>
        public void SelectReaderID()
        {
            read.Reader = _Reader;
            DataTable dt = read.SearchReaderID();
            _Reader.CardID= dt.Rows[0].ItemArray[1].ToString();
            _Reader.ReaderName = dt.Rows[0].ItemArray[2].ToString();
            _Reader.Tel = dt.Rows[0].ItemArray[3].ToString();
        }

        /// <summary>
        /// 更新读者信息
        /// </summary>
        /// <returns>返回1表示更新成功，0表示更新失败。</returns>
        public int UpdateReader()
        {
            read.Reader = _Reader;
            int temp=read.Update();
            if (temp > 0)
            {
                return 1;
            }
            else
            {
                return 0;
            }
        }

        /// <summary>
        /// 删除读者
        /// </summary>
        /// <returns>返回1表示删除成功，0表示删除失败。</returns>
        public int DeleteReader()
        {
            read.Reader = _Reader;
            int temp = read.Delete();
            if (temp > 0)
            {
                return 1;
            }
            else
            {
                return 0;
            }
        }

        /// <summary>
        /// 查询读者详细信息
        /// </summary>
        /// <param name="id">读者ID</param>
        /// <returns>返回查询结果DataTable</returns>
        public DataTable ReturnReaderDetail(string id)
        {
            DAL.V_BORROW v = new DAL.V_BORROW();
            return v.ReaderBorrow(id);
        }
    }
}