frmsousuo.cs

一个图书馆管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace BookManage
{
    public partial class frmsousuo : Form
    {
        private SqlConnection objSqlConnection;
        private SqlDataAdapter objSqlDataAdapter;
        private DataSet objDataSet;
        public frmsousuo()
        {
            InitializeComponent();
        }

        private void frmsousuo_Load(object sender, EventArgs e)
        {
            objSqlConnection = new SqlConnection("server=(local);database=Book;Integrated Security=SSPI;");
            objDataSet = new DataSet();
            objSqlDataAdapter = new SqlDataAdapter("select * from bookInfo", objSqlConnection);
            objSqlDataAdapter.Fill(objDataSet, "bookInfo");
            if (objDataSet.Tables["bookInfo"].Rows.Count > 0)
            {
                foreach (DataRow objRow in objDataSet.Tables["bookInfo"].Rows)
                {
                    cboleibie.Items.Add(objRow["BookType"]);
                }
            }
        }

        private void btnsousuo_Click(object sender, EventArgs e)
        {
            if (this.cboleibie.Text.Equals("") && this.cbobie.Text.Equals("") && this.cboname.Text.Equals("") && this.txtname.Text.Equals("") && this.txtneirong.Text.Equals(""))
            {
                dbgname.DataSource = objDataSet.Tables[0].DefaultView;
            }
            else
            {
                if (cbobie.Text=="or" && cboname.Text=="or")
                {
                    
                        try
                        {
                            objDataSet = new DataSet();
                            objSqlDataAdapter = new SqlDataAdapter("select * from bookInfo where BookType='" + cboleibie.Text + "' or BookName='" + txtname.Text + "' or BookContent='" + txtneirong.Text + "'", objSqlConnection);
                            objSqlDataAdapter.Fill(objDataSet, "bookInfo");
                            if (objDataSet.Tables["bookInfo"].Rows.Count == 0)
                            {
                                MessageBox.Show("没有你要查询的图书!");
                            }
                            else
                            {
                                dbgname.DataSource = objDataSet.Tables[0].DefaultView;
                            }
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                   }
                   if (cbobie.Text == "or" && cboname.Text == "and")
                   {
                       try
                       {
                           objDataSet = new DataSet();
                           objSqlDataAdapter = new SqlDataAdapter("select * from bookInfo where BookType='" + cboleibie.Text + "' or BookName='" + txtname.Text + "' and BookContent='" + txtneirong.Text + "'", objSqlConnection);
                           objSqlDataAdapter.Fill(objDataSet, "bookInfo");
                           if (objDataSet.Tables["bookInfo"].Rows.Count == 0)
                           {
                               MessageBox.Show("没有你要查询的图书!");
                           }
                           else
                           {
                               dbgname.DataSource = objDataSet.Tables[0].DefaultView;
                           }
                       }
                       catch (Exception ex)
                       {
                           MessageBox.Show(ex.Message);
                       }
                   }
                   if (cbobie.Text == "and" && cboname.Text == "or")
                   {
                       try
                       {
                           objDataSet = new DataSet();
                           objSqlDataAdapter = new SqlDataAdapter("select * from bookInfo where BookType='" + cboleibie.Text + "' and BookName='" + txtname.Text + "' or BookContent='" + txtneirong.Text + "'", objSqlConnection);
                           objSqlDataAdapter.Fill(objDataSet, "bookInfo");
                           if (objDataSet.Tables["bookInfo"].Rows.Count == 0)
                           {
                               MessageBox.Show("没有你要查询的图书!");
                           }
                           else
                           {
                               dbgname.DataSource = objDataSet.Tables[0].DefaultView;
                           }
                       }
                       catch (Exception ex)
                       {
                           MessageBox.Show(ex.Message);
                       }
                   }
                   if (cbobie.Text == "and" && cboname.Text == "and")
                   {
                       try
                       {
                           objDataSet = new DataSet();
                           objSqlDataAdapter = new SqlDataAdapter("select * from bookInfo where BookType='" + cboleibie.Text + "' and BookName='" + txtname.Text + "' and BookContent='" + txtneirong.Text + "'", objSqlConnection);
                           objSqlDataAdapter.Fill(objDataSet, "bookInfo");
                           if (objDataSet.Tables["bookInfo"].Rows.Count == 0)
                           {
                               MessageBox.Show("没有你要查询的图书!");
                           }
                           else
                           {
                               dbgname.DataSource = objDataSet.Tables[0].DefaultView;
                           }
                       }
                       catch (Exception ex)
                       {
                           MessageBox.Show(ex.Message);
                       }
                   }
            }
        }
    }
}