readerinfquery.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 ReaderInfQuery : Form
    {
        public ReaderInfQuery()
        {
            InitializeComponent();
        }

        private void ReaderInfQuery_Load(object sender, EventArgs e)
        {
            comboBox1.Text = "所有读者资料";
        }

        private void button1_Click(object sender, EventArgs e)
        {
            dataGridView2.DataSource = null;
            dataGridView3.DataSource = null;
            if (comboBox1.SelectedItem.ToString() == "所有读者资料")
            {
                string selectstr = "select readerid as 读者编号,readername as 姓名,readersex as 性别,readxi as 系别,readerbanji as 班级,readerphone as 联系电话,Readerdegree as 身份证号,addpeople as 添加人,addtime as 添加时间 from Reader ";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            if (comboBox1.SelectedItem.ToString() == "已借图书读者资料")
            {
                string selectstr = "select Reader.readerid as 读者编号,Reader.readername as 姓名,readersex as 性别,readxi as 系别,readerbanji as 班级,readerphone as 联系电话,Readerdegree as 身份证号,addpeople as 添加人,addtime as 添加时间 from Reader,BRinf where Reader.readerid=BRinf.Readerid ";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
        }

        private void textBox1_KeyDown(object sender, KeyEventArgs e)
        {
            string selectstr = "select readerid as 读者编号,readername as 姓名,readersex as 性别,readxi as 系别,readerbanji as 班级,readerphone as 联系电话,Readerdegree as 身份证号,addpeople as 添加人,addtime as 添加时间 from Reader where readerid like '" + textBox1.Text + "%'";
            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;
            dataGridView3.DataSource = null;
            string selectstr = "select Readerid as 读者编号,Readername as 读者姓名,Bookid as 资料编号,Bookname as 资料名,Borrowtime as 借阅时间,LimitReturntime as 限还时间,Operater as 操作员 from BRinf where Readerid='"+dataGridView1.CurrentRow.Cells[0].Value.ToString()+"' and IsReturn='否'";
            DataSet ds = new DataSet();
            ds = Operator.SelectSql(selectstr);
            this.dataGridView2.DataSource = ds.Tables[0].DefaultView;

            string sele= "select Readerid as 读者编号,Readername as 读者姓名,Bookid as 资料编号,Bookname as 资料名,Borrowtime as 借阅时间,LimitReturntime as 限还时间,Returntime as 还书时间,Overtime as 超还天数,Spend as 费率,Money as 罚款,IsReturn as 是否还书,Operater as 操作员 from BRinf where Readerid='" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'";
            DataSet DS  = new DataSet();
            DS = Operator.SelectSql(sele);
            this.dataGridView3.DataSource = DS.Tables[0].DefaultView;
        }        
    }
}