图书管理系统(二)/frmReserBroInfo.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 frmReserBroInfo : Form
    {
        public frmReserBroInfo()
        {
            InitializeComponent();
        }
        Dblink dbl = new Dblink();
        Dbconnection dbc = new Dbconnection();
        string Sql = "select r_Number 编号,r_BookId 图书编号,r_BookName 图书名称,r_BookAuthor 图书作者,r_ReaderId 读者编号,r_ReaderName 读者姓名,r_ReaderSex 读者性别,r_BookNumber 预借数量,r_BookPrice 图书价格,r_Publisher 出版社,r_HandleUsr 操作用户,r_ReadyTime 预借时间 from ReserBroInfo";
        private void frmReserBroInfo_Load(object sender, EventArgs e)
        {
            //获得屏幕的大小,并设置窗体初始化时的大小
            Rectangle rect = System.Windows.Forms.SystemInformation.VirtualScreen;
            this.Width = rect.Width - 123;
            this.Height = rect.Height - 157;
            cmbCheckList.SelectedIndex = 0;
            dbl.InfoShow(Sql,dgvReserBroInfo);
        }
        
        private void tsbReflesh_Click(object sender, EventArgs e)
        {
            string time =dbl.GetTime(9);
            if (cmbCheckList.Text.Trim() == "所有预借记录")
            {
                dbl.InfoShow("" + Sql + "", dgvReserBroInfo);
            }
            if (cmbCheckList.Text.Trim() == "今天预借记录")
            {
                dbl.InfoShow("" + Sql + " where r_ReadyTime like'%"+time+"%'", dgvReserBroInfo);
            }
        }

        private void tsbDelete_Click(object sender, EventArgs e)
        {
            string Number = dgvReserBroInfo.SelectedCells[0].Value.ToString();         //获得记录的流水编号 
            if (MessageBox.Show("是否当真删除编号为'" + Number + "'的信息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                string Strsql = "delete from ReserBroInfo where r_Number='"+Number+"'";
                if (dbc.ExeInfochange(Strsql) == 1)
                {
                    dbl.InfoShow("" + Sql + "", dgvReserBroInfo);
                }
            }
        }

        private void cmbCheckList_SelectedIndexChanged(object sender, EventArgs e)
        {
            tsbReflesh_Click(sender, e);
        }