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

        private void button1_Click(object sender, EventArgs e)
        {
            DateTime dt = new DateTime();
            DateTime dt1 = new DateTime();
            dt = DateTime.Today;
            dt1 = DateTime.Now.AddDays(1);
            if (comboBox1.SelectedItem.ToString() == "所有借阅记录")
            {
                string selectstr = "select Readerid as 读者编号,Readername as 读者姓名,Bookid as 资料编号,Bookname as 资料名,Borrowtime as 借阅时间,LimitReturntime as 限还时间,Returntime as 还书时间,Overtime as 超还天数,Spend as 费率,Money as 罚款,Id as 编号,IsReturn as 是否还书,Operater as 操作员 from BRinf";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            if (comboBox1.SelectedItem.ToString() == "今日借阅记录")
            {
                string selectstr = "select Readerid as 读者编号,Readername as 读者姓名,Bookid as 资料编号,Bookname as 资料名,Borrowtime as 借阅时间,LimitReturntime as 限还时间,Returntime as 还书时间,Overtime as 超还天数,Spend as 费率,Money as 罚款,Id as 编号,IsReturn as 是否还书,Operater as 操作员 from BRinf where Borrowtime>='" + dt + "'and Borrowtime<'" + dt1 + "'";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            if (comboBox1.SelectedItem.ToString() == "今日到期记录")
            {
                string selectstr = "select Readerid as 读者编号,Readername as 读者姓名,Bookid as 资料编号,Bookname as 资料名,Borrowtime as 借阅时间,LimitReturntime as 限还时间,Returntime as 还书时间,Overtime as 超还天数,Spend as 费率,Money as 罚款,Id as 编号,IsReturn as 是否还书,Operater as 操作员 from BRinf where LimitReturntime<'" + dt1 + "'";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            if (comboBox1.SelectedItem.ToString() == "已经超期记录")
            {
                string selectstr = "select Readerid as 读者编号,Readername as 读者姓名,Bookid as 资料编号,Bookname as 资料名,Borrowtime as 借阅时间,LimitReturntime as 限还时间,Returntime as 还书时间,Overtime as 超还天数,Spend as 费率,Money as 罚款,Id as 编号,IsReturn as 是否还书,Operater as 操作员 from BRinf where LimitReturntime<'" + dt1 + "'";
                DataSet ds = new DataSet();
                ds = Operator.SelectSql(selectstr);
                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }

        }

        private void borrowreadquery_Load(object sender, EventArgs e)
        {
            this.comboBox1.Text = "所有借阅记录";
        }

        private void textBox1_KeyDown(object sender, KeyEventArgs e)
        {
            textBox2.Text = "";
            string selectstr = "select Readerid as 读者编号,Readername as 读者姓名,Bookid as 资料编号,Bookname as 资料名,Borrowtime as 借阅时间,LimitReturntime as 限还时间,Returntime as 还书时间,Overtime as 超还天数,Spend as 费率,Money as 罚款,Id as 编号,IsReturn as 是否还书,Operater as 操作员 from BRinf where Readerid like '" + textBox1.Text + "%' or Readername like '"+textBox1.Text+" %'";
            DataSet ds = new DataSet();
            ds = Operator.SelectSql(selectstr);
            this.dataGridView1.DataSource = ds.Tables[0].DefaultView;       
        }

        private void textBox2_KeyDown(object sender, KeyEventArgs e)
        {
            textBox1.Text = "";
            string selectstr = "select Readerid as 读者编号,Readername as 读者姓名,Bookid as 资料编号,Bookname as 资料名,Borrowtime as 借阅时间,LimitReturntime as 限还时间,Returntime as 还书时间,Overtime as 超还天数,Spend as 费率,Money as 罚款,Id as 编号,IsReturn as 是否还书,Operater as 操作员 from BRinf where Bookid like '" + textBox2.Text + "%' or Bookname like '" + textBox2.Text + "%'";
            DataSet ds = new DataSet();
            ds = Operator.SelectSql(selectstr);
            this.dataGridView1.DataSource = ds.Tables[0].DefaultView;   
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (dataGridView1.Rows.Count != 0)
            {
                if (Convert.ToDateTime(dataGridView1.CurrentRow.Cells[5].Value) >= DateTime.Today && dataGridView1.CurrentRow.Cells[11].Value.ToString().Trim() == "否")
                {
                    BookInfoMag bif = new BookInfoMag();
                    Value.bookid = dataGridView1.CurrentRow.Cells[2].Value.ToString();
                    Value.readerid = dataGridView1.CurrentRow.Cells[0].Value.ToString();
                    Value.Borrowreturn = "续借";

                    bif.ShowDialog();
                    
                    
                }
                else
                {
                    MessageBox.Show("此书已超期或已归还,不能续借", "提示");
                }
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            if (dataGridView1.Rows.Count != 0)
            {
                if (dataGridView1.CurrentRow.Cells[11].Value.ToString().Trim() == "否")
                {
                    BookInfoMag bif = new BookInfoMag();
                    Value.bookid = dataGridView1.CurrentRow.Cells[2].Value.ToString();
                    Value.readerid = dataGridView1.CurrentRow.Cells[0].Value.ToString();
                    Value.Borrowreturn = "归还";
                    bif.ShowDialog();
                    
                }
                else
                {
                    MessageBox.Show("此书已归还", "提示");
                }
            }
        }

    }
}