v_borrow.cs

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

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

namespace DAL
{
    public class V_BORROW
    {
        /// <summary>
        /// 根据管理编号检索视图
        /// </summary>
        /// <param name="manid">管理编号</param>
        /// <returns>返回ReturnDate列</returns>
        public DataTable SelectBookRutrun(string manid)
        {
            SqlParameter[] sqlp = new SqlParameter[] { new SqlParameter("@ID", manid) };

            DataTable dt = SqlHelper.Select(sqlp, "V_Borrow_SelectReturnDate");

            return dt;
        }

        /// <summary>
        /// 查询读者借书信息
        /// </summary>
        /// <param name="manid">管理编号</param>
        /// <param name="cardid">借书证号</param>
        /// <returns>返回ReturnDate列</returns>
        public DataTable SelectBookRutrun(string manid,string cardid)
        {
            SqlParameter[] sqlp = new SqlParameter[] { new SqlParameter("@ManID", manid),
                new SqlParameter("@CardID", cardid) };

            DataTable dt = SqlHelper.Select(sqlp, "V_Borrow_SelectDate");

            return dt;
        }

        /// <summary>
        /// 查询读者借书信息
        /// </summary>
        /// <param name="id">读者ID</param>
        /// <returns>返回查询结果DataTable</returns>
        public DataTable ReaderBorrow(string id)
        {
            SqlParameter[] sqlp = new SqlParameter[] { new SqlParameter("@ReaderID", id) };

            DataTable dt = SqlHelper.Select(sqlp, "V_BORROW_Select");

            return dt;
        }

        /// <summary>
        /// 根据图书编号查询视图
        /// </summary>
        /// <param name="id">图书编号</param>
        /// <returns>返回DataTable</returns>
        public DataTable BookBorrow(string id)
        {
            SqlParameter[] sqlp = new SqlParameter[] { new SqlParameter("@BookID", id) };

            DataTable dt = SqlHelper.Select(sqlp, "V_BORROW_Select2");

            return dt;
       }

    }
}