图书管理系统(二)/frmHandleNote.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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


namespace 图书管理系统_二_
{
    public partial class frmHandleNote : Form
    {
        public frmHandleNote()
        {
            InitializeComponent();
        }
        string Sql="select HandleNumber 操作编号,Handletype 操作类型,HandleUser 操作用户,BookName 图书名称,BookStrichcode 图书编号,ReaderID 读者编号,ReaderName 读者姓名,ReaderSex 读者性别,BookNumber 借书数量,BookPrice 图书价格,HandleDate 操作日期 from HandleNote";
        Dblink db = new Dblink();
        Dbconnection dbc = new Dbconnection();
        DateTime NowTime = Convert.ToDateTime(DateTime.Now.ToString());
        private void frmBookSelect_Load(object sender, EventArgs e)
        {
            //显示所有操作日志
            cmbCheckList.SelectedIndex = 1;
            db.InfoShow(""+Sql+"", dgvNote);
            //获得屏幕的大小,并设置窗体初始化时的大小
            Rectangle rect = System.Windows.Forms.SystemInformation.VirtualScreen; 
            this.Width =rect.Width- 135;
            this.Height = rect .Height - 157;
        }
     
        private void tsbExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void tsbToExcel_Click(object sender, EventArgs e)
        {
            //导出到EXCEL表格中
            db.ShowDgvInfo(dgvNote, true);
        }

        //单击工具栏按钮执行T-SQL查询语句
         #region  T-SQL查询语句
        private void cmbCheckList_TextChanged(object sender, EventArgs e)
        {
            tsbReflesh_Click(sender,e);
        }
        //当文本框中的文本变化时进行查询
        private void txtBookNameorID_TextChanged(object sender, EventArgs e)
        {
            string time = db.GetTime(9);
            if (cmbCheckList.Text.Trim() == "今日操作记录")
            {
                db.InfoShow("" + Sql + " where ((BookName like'%" + txtBookNameorID.Text.Trim() + "%') or (BookStrichcode like'%" + txtBookNameorID.Text.Trim() + "%'))and HandleDate like'" + time + "%' order by HandleNumber", dgvNote);
            }
            else
            {