逾期图书清单.cs

来自「图书管理系统源代码,很图书管理系统源代码,很不错,有参考作用不错,有参考作用」· CS 代码 · 共 63 行

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

namespace 图书馆管理系统
{
   /// <summary>
   /// 查找出过了规定期限归还图书的读者信息
   /// </summary>
    public partial class 逾期图书清单 : Form
    {
        public 逾期图书清单()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

            sqlConnection1.Open();
            sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[1].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[2].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[3].Value = "%%";

            switch (comboBox1.SelectedIndex)
            {
                case 0:
                    sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%" + textBox1.Text + "%";
                    break;
                case 1:
                    sqlDataAdapter1.SelectCommand.Parameters[1].Value = "%" + textBox1.Text + "%";
                    break;
                case 2:
                    sqlDataAdapter1.SelectCommand.Parameters[2].Value = "%" + textBox1.Text + "%";
                    break;
                case 3:
                    sqlDataAdapter1.SelectCommand.Parameters[3].Value = "%" + textBox1.Text + "%";
                    break;
                case 4:
                    sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%%";
                    break;

            }
            dataSet61.图书信息.Clear();
            sqlDataAdapter1.Fill(dataSet61);
            sqlConnection1.Close();
        }

        private void 逾期图书清单_Load(object sender, EventArgs e)
        {
            sqlDataAdapter1.SelectCommand.Parameters[0].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[1].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[2].Value = "%%";
            sqlDataAdapter1.SelectCommand.Parameters[3].Value = "%%";
            sqlDataAdapter1.Fill(dataSet61);
        }
    }
}