statquery.cs

用C#与SQL2005写的一个简单的图书管理系统.主要功能:图书及学生信息的添加修改与删除 图书的借出与归还 图书信息的模糊查询.

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

namespace BooksM.InforQuery
{
    public partial class StatQuery : Form
    {
        public StatQuery()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
                string temp = "select * from BookCardInfor where  "
                + "LoanNum>0";
                myConnData.ShowDataGrid(ref temp, ref dataGridView1);
            }
            catch
            {
                MessageBox.Show("查询失败！");
            }

        }

        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
                string temp = "select ReaderInfor.ReaderID,ReaderInfor.ReaderName,BookID,LoanNum,loanDate,DueReturnDate,ActualRDate,Fine"
                + " from LoanInfor,ReaderInfor where ReaderInfor.ReaderID=LoanInfor.ReaderID and "
                + "LoanInfor.BookID='" + textBox1.Text.ToString().Trim() + "'";
                myConnData.ShowDataGrid(ref temp, ref dataGridView1);
            }
            catch
            {
                MessageBox.Show("查询失败！");
            }

        }

        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
                string temp = "select ReaderInfor.ReaderID,ReaderInfor.ReaderName,BookID,LoanNum,loanDate,DueReturnDate,ActualRDate,Fine"
                + " from LoanInfor,ReaderInfor where ReaderInfor.ReaderID=LoanInfor.ReaderID and  "
                + "LoanNum>0";
                myConnData.ShowDataGrid(ref temp, ref dataGridView1);
            }
            catch
            {
                MessageBox.Show("查询失败！");
            }
        }

        private void button4_Click(object sender, EventArgs e)
        {
            try
            {
                MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
                string temp = "select ReaderInfor.ReaderID,ReaderInfor.ReaderName,BookID,LoanNum,loanDate,DueReturnDate,ActualRDate,Fine"
                + " from LoanInfor,ReaderInfor where ReaderInfor.ReaderID=LoanInfor.ReaderID and  "
                + "LoanInfor.ReaderID='"+textBox2.Text.ToString().Trim()+"' order by loanNum desc";
                myConnData.ShowDataGrid(ref temp, ref dataGridView1);
            }
            catch
            {
                MessageBox.Show("查询失败！");
            }

        }

        private void button5_Click(object sender, EventArgs e)
        {
            try
            {
                MyClass.ConnData myConnData = new BooksM.MyClass.ConnData();
                string temp = "select ReaderInfor.ReaderID,ReaderInfor.ReaderName,BookID,LoanNum,loanDate,DueReturnDate,ActualRDate,Fine"
                + " from LoanInfor,ReaderInfor where ReaderInfor.ReaderID=LoanInfor.ReaderID and  "
                + "DateDiff(day,DueReturnDate,getdate())>0 order by loanNum desc";
                myConnData.ShowDataGrid(ref temp, ref dataGridView1);
            }
            catch
            {
                MessageBox.Show("查询失败！");
            }
        }

    }
}