bookinfquery.cs

这是一个图书馆管理用的简化系统

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

namespace BMS
{
    public partial class BookInfQuery : Form
    {
        public BookInfQuery()
        {
            InitializeComponent();
        }

        private void BookInfQuery_Load(object sender, EventArgs e)
        {
            comboBox1.Text = "所有图书";
        }

        private void textBox1_KeyDown(object sender, KeyEventArgs e)
        {
            string selectstr = "select Publishid as 出版编号,Bookname as 图书名称,Booksort as 类别,Bookinprice as 进价,Bookamount as 数量,Booksum as 花费,Bookstocks as 库存量,Bookaddpoeple as 图书入库员,Bookaddtime as 添加时间 from Booktable where Bookname like '" + textBox1.Text + "%'";
            DataSet ds = new DataSet();
            ds = Operator.SelectSql(selectstr);
            this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            dataGridView2.DataSource = null;
            if (comboBox1.SelectedItem.ToString() == "所有图书")
            {
                string selectstr = "select Publishid as 出版编号,Bookname as 图书名称,Booksort as 类别,Bookinprice as 进价,Bookamount as 数量,Booksum as 花费,Bookstocks as 库存量,Bookaddpoeple as 图书入库员,Bookaddtime as 添加时间 from Booktable ";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            if (comboBox1.SelectedItem.ToString() == "借出图书")
            {
                string selectstr = "select Publishid as 出版编号,Booktable.Bookname as 图书名称,Booktable.Booksort as 类别,Bookinprice as 进价,Bookamount as 数量,Booksum as 花费,Bookstocks as 库存量,Bookaddpoeple as 图书入库员,Bookaddtime as 添加时间 from Booktable,Bookinf where Bookinf.Bookstate='借出'";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            if (comboBox1.SelectedItem.ToString() == "库存图书")
            {
                string selectstr = "select Publishid as 出版编号,Booktable.Bookname as 图书名称,Booktable.Booksort as 类别,Bookinprice as 进价,Bookamount as 数量,Booksum as 花费,Bookstocks as 库存量,Bookaddpoeple as 图书入库员,Bookaddtime as 添加时间 from Booktable,Bookinf where Bookinf.Bookstate='在库'";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            if (comboBox1.SelectedItem.ToString() == "新刊特刊")
            {
                string selectstr = "select M_id as 新刊编号,M_name as 新刊特刊名称,M_qishu as 期号,M_publish as 出版社,M_pubtime as 出版时间,M_price as 单价,M_sort as 类别,M_addpeople as 入库员,M_time as 入库时间,M_isbreak as 是否报损 from Magazine";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            dataGridView2.DataSource = null;
            if (comboBox1.SelectedItem.ToString() != "新刊特刊")
            {
                string selectstr = "select Bookinf.Bookid as 图书编号,Bookinf.Published as 出版号, Booktable.Bookname as 图书名称,Booktable.Booksort as 类别,Bookwriter as 作者,Bookpublish as 出版社,Bookpubdate as 出版时间, Bookprice as 进价,Bookamount as 数量,Booksum as 花费,Bookstocks as 库存量,Bookaddpoeple as 图书入库员,Bookaddtime as 添加时间,Bookstate as 图书状态  from Booktable,Bookinf where Bookinf.Published='" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "' ";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView2.DataSource = ds.Tables[0].DefaultView;
            }                   
        }
    }
}