ZhongJianChen/Class_TuShuJieYueGuanLi.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

/*
 *         作用: 中间层.接收图书借阅管理窗口参数，处理该窗口数据 
 *         作者: 王麒云
 *         时间: 2011-8-8
 */

namespace MF借书系统.ZhongJianChen
{
    class Class_TuShuJieYueGuanLi
    {
        //构造方法
        public Class_TuShuJieYueGuanLi()
        { 
            
        }
        //返回用户信息
        public string[] selectDuzhe(string duzheId)
        {
            string[] _duzhe = new string[4];
            string sqlStr = "select * from Duzhe where DuzheID = '"+duzheId+"'";
            ADO.SqlAdo sql = new ADO.SqlAdo();
            SqlDataReader read = sql.select(sqlStr);
            if (read.Read())
                for (int i = 0; i < 4; i++)
                    _duzhe[i] = read[i].ToString();
            return _duzhe;
        }
        //返回图书信息
        public string[] selectBookInfo(string ISBN)
        {
            string[] _book = new string[4];
            string sqlStr = "select ISBN,bookname,typename,price from bookinfo where isbn = '"+ISBN+"' ";
            ADO.SqlAdo sql = new ADO.SqlAdo();
            SqlDataReader read = sql.select(sqlStr);
            if (read.Read())
                for (int i = 0; i < 4; i++)
                    _book[i] = read[i].ToString();
            return _book;
        }
        //匹配读者ID
        public bool str_Duzhe(string name)
        {
            string sqlStr = "select DuzheId from Duzhe where DuzheId = '" + name + "'";
            ADO.SqlAdo ado = new ADO.SqlAdo();
            SqlDataReader read = ado.select(sqlStr);
            if (read.Read())
                return true;
            return false;
        }
        //匹配图书ID
        public bool str_bookinfo(string name)
        {
            string sqlStr = " select ISBN from bookinfo where isbn = '" + name + "'";