ZhongJianChen/Class_TuShuChaXun.cs

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

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

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

namespace MF借书系统.ZhongJianChen
{
    class Class_TuShuChaXun
    {
        public Class_TuShuChaXun()
        { 
        
        }
        public DataTable getTable()
        {
            ADO.AdoTable table = new ADO.AdoTable();
            string sqlStr = "select ISBN as 图书编号,TypeID as 类别编号, "+
                                 "typeName as 类别名称,bookName as图书书名, "+
                                 "writer as 作者,Translator as 出版社, "+
                                 " Publisher as 译者,Date as 日期,Price as 价格 from bookinfo";
            return table.getTable(sqlStr).Tables[0];
        }

        //查询图书数据
        public DataTable getTiaoJian(string tiaoJian,int i)
        {
            ADO.AdoTable table = new ADO.AdoTable();
            string sqlStr = "select ISBN as 图书编号,TypeID as 类别编号,typeName as 类别名称, " +
                                  "bookName as图书书名,writer as 作者,Translator as 出版社, " +
                                  "Publisher as 译者,Date as 日期,Price as 价格 from bookinfo";
            return table.getTable(this.piPei(tiaoJian,i,sqlStr)).Tables[0];
        }

        //匹配sql查询条件
        private string piPei(string tiaoJian, int i,string sqlStr)
        {
            switch (i)
            {
                case 0:
                    sqlStr += " where ISBN = '" + tiaoJian + "'";
                    break;
                case 1:
                    sqlStr += " where TypeID = '" + tiaoJian + "'";
                    break;
                case 2:
                    sqlStr += " where typeName = '" + tiaoJian + "'";
                    break;
                case 3:
                    sqlStr += " where bookName = '" + tiaoJian + "'";
                    break;
                case 4:
                    sqlStr += " where writer = '" + tiaoJian + "'";
                    break;
                case 5:
                    sqlStr += " where Translator = '" + tiaoJian + "'";
                    break;
                case 6:
                    sqlStr += " where Publisher = '" + tiaoJian + "'";