frmutterbook.vb

图书管理系统能过完成基本的功能

Imports System
Imports System.Data
Imports System.Data.OleDb

Public Class frmUtterBook
    Inherits System.Windows.Forms.Form

#Region " Windows 窗体设计器生成的代码 "

    Public Sub New()
        MyBase.New()

        '该调用是 Windows 窗体设计器所必需的。
        InitializeComponent()

        '在 InitializeComponent() 调用之后添加任何初始化

    End Sub

    '窗体重写处置以清理组件列表。
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Windows 窗体设计器所必需的
    Private components As System.ComponentModel.IContainer

    '注意：以下过程是 Windows 窗体设计器所必需的
    '可以使用 Windows 窗体设计器修改此过程。
    '不要使用代码编辑器修改它。
    Friend WithEvents TabCtr As System.Windows.Forms.TabControl
    Friend WithEvents TabPage1 As System.Windows.Forms.TabPage
    Friend WithEvents TabPage2 As System.Windows.Forms.TabPage
    Friend WithEvents TabPage3 As System.Windows.Forms.TabPage
    Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
    Friend WithEvents GroupBox2 As System.Windows.Forms.GroupBox
    Friend WithEvents GroupBox3 As System.Windows.Forms.GroupBox
    Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid
    Friend WithEvents lbISBN As System.Windows.Forms.Label
    Friend WithEvents lbBookName As System.Windows.Forms.Label
    Friend WithEvents lbPublisher As System.Windows.Forms.Label
    Friend WithEvents lbAuthors As System.Windows.Forms.Label
    Friend WithEvents TextBox1 As System.Windows.Forms.TextBox
    Friend WithEvents btnBorrow As System.Windows.Forms.Button
    Friend WithEvents lbReturnDates As System.Windows.Forms.Label
    Friend WithEvents lbPublishers As System.Windows.Forms.Label
    Friend WithEvents lbAuthor As System.Windows.Forms.Label
    Friend WithEvents lbName As System.Windows.Forms.Label
    Friend WithEvents lbRdate As System.Windows.Forms.Label
    Friend WithEvents GroupBox4 As System.Windows.Forms.GroupBox
    Friend WithEvents TextBox2 As System.Windows.Forms.TextBox
    Friend WithEvents lbID As System.Windows.Forms.Label
    Friend WithEvents GroupBox5 As System.Windows.Forms.GroupBox
    Friend WithEvents GroupBox6 As System.Windows.Forms.GroupBox
    Friend WithEvents TextBox3 As System.Windows.Forms.TextBox
    Friend WithEvents Button1 As System.Windows.Forms.Button
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents TextBox4 As System.Windows.Forms.TextBox
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents GroupBox7 As System.Windows.Forms.GroupBox
    Friend WithEvents DataGrid2 As System.Windows.Forms.DataGrid
    Friend WithEvents TextBox5 As System.Windows.Forms.TextBox
    Friend WithEvents Label3 As System.Windows.Forms.Label
    Friend WithEvents Label4 As System.Windows.Forms.Label
    Friend WithEvents Label5 As System.Windows.Forms.Label
    Friend WithEvents Label6 As System.Windows.Forms.Label
    Friend WithEvents Label7 As System.Windows.Forms.Label
    Friend WithEvents Label12 As System.Windows.Forms.Label
    Friend WithEvents Label13 As System.Windows.Forms.Label
    Friend WithEvents Label14 As System.Windows.Forms.Label
    Friend WithEvents Label15 As System.Windows.Forms.Label
    Friend WithEvents GroupBox8 As System.Windows.Forms.GroupBox
    Friend WithEvents DataGrid3 As System.Windows.Forms.DataGrid
    Friend WithEvents lbFFactor As System.Windows.Forms.Label
    Friend WithEvents lbFBase As System.Windows.Forms.Label
    Friend WithEvents lbFMulti As System.Windows.Forms.Label
    Friend WithEvents lbDays As System.Windows.Forms.Label
    Friend WithEvents lbReDate As System.Windows.Forms.Label
    Friend WithEvents lbBName As System.Windows.Forms.Label
    Friend WithEvents lbBDate As System.Windows.Forms.Label
    Friend WithEvents lbsID As System.Windows.Forms.Label
    Friend WithEvents Label8 As System.Windows.Forms.Label
    Friend WithEvents lbSum As System.Windows.Forms.Label
    Friend WithEvents Button2 As System.Windows.Forms.Button
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.TabCtr = New System.Windows.Forms.TabControl
        Me.TabPage1 = New System.Windows.Forms.TabPage
        Me.GroupBox1 = New System.Windows.Forms.GroupBox
        Me.GroupBox3 = New System.Windows.Forms.GroupBox
        Me.DataGrid1 = New System.Windows.Forms.DataGrid
        Me.GroupBox2 = New System.Windows.Forms.GroupBox
        Me.GroupBox4 = New System.Windows.Forms.GroupBox
        Me.TextBox2 = New System.Windows.Forms.TextBox
        Me.lbID = New System.Windows.Forms.Label
        Me.btnBorrow = New System.Windows.Forms.Button
        Me.lbRdate = New System.Windows.Forms.Label
        Me.lbName = New System.Windows.Forms.Label
        Me.lbAuthor = New System.Windows.Forms.Label
        Me.lbPublishers = New System.Windows.Forms.Label
        Me.TextBox1 = New System.Windows.Forms.TextBox
        Me.lbReturnDates = New System.Windows.Forms.Label
        Me.lbAuthors = New System.Windows.Forms.Label
        Me.lbPublisher = New System.Windows.Forms.Label
        Me.lbBookName = New System.Windows.Forms.Label
        Me.lbISBN = New System.Windows.Forms.Label
        Me.TabPage2 = New System.Windows.Forms.TabPage
        Me.GroupBox5 = New System.Windows.Forms.GroupBox
        Me.GroupBox7 = New System.Windows.Forms.GroupBox
        Me.DataGrid2 = New System.Windows.Forms.DataGrid
        Me.TextBox3 = New System.Windows.Forms.TextBox
        Me.Button1 = New System.Windows.Forms.Button
        Me.Label1 = New System.Windows.Forms.Label
        Me.TextBox4 = New System.Windows.Forms.TextBox
        Me.Label2 = New System.Windows.Forms.Label
        Me.TabPage3 = New System.Windows.Forms.TabPage
        Me.GroupBox6 = New System.Windows.Forms.GroupBox
        Me.Button2 = New System.Windows.Forms.Button
        Me.Label8 = New System.Windows.Forms.Label
        Me.lbSum = New System.Windows.Forms.Label
        Me.GroupBox8 = New System.Windows.Forms.GroupBox
        Me.DataGrid3 = New System.Windows.Forms.DataGrid
        Me.Label12 = New System.Windows.Forms.Label
        Me.Label13 = New System.Windows.Forms.Label
        Me.Label14 = New System.Windows.Forms.Label
        Me.Label15 = New System.Windows.Forms.Label
        Me.lbFFactor = New System.Windows.Forms.Label
        Me.lbFBase = New System.Windows.Forms.Label
        Me.lbFMulti = New System.Windows.Forms.Label
        Me.lbDays = New System.Windows.Forms.Label
        Me.Label4 = New System.Windows.Forms.Label
        Me.Label5 = New System.Windows.Forms.Label
        Me.Label6 = New System.Windows.Forms.Label
        Me.Label7 = New System.Windows.Forms.Label
        Me.lbReDate = New System.Windows.Forms.Label
        Me.lbBName = New System.Windows.Forms.Label
        Me.lbBDate = New System.Windows.Forms.Label
        Me.lbsID = New System.Windows.Forms.Label
        Me.TextBox5 = New System.Windows.Forms.TextBox
        Me.Label3 = New System.Windows.Forms.Label
        Me.TabCtr.SuspendLayout()
        Me.TabPage1.SuspendLayout()
        Me.GroupBox1.SuspendLayout()
        Me.GroupBox3.SuspendLayout()
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.GroupBox2.SuspendLayout()
        Me.GroupBox4.SuspendLayout()
        Me.TabPage2.SuspendLayout()
        Me.GroupBox5.SuspendLayout()
        Me.GroupBox7.SuspendLayout()
        CType(Me.DataGrid2, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.TabPage3.SuspendLayout()
        Me.GroupBox6.SuspendLayout()
        Me.GroupBox8.SuspendLayout()
        CType(Me.DataGrid3, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'TabCtr
        '
        Me.TabCtr.Appearance = System.Windows.Forms.TabAppearance.FlatButtons
        Me.TabCtr.Controls.Add(Me.TabPage1)
        Me.TabCtr.Controls.Add(Me.TabPage2)
        Me.TabCtr.Controls.Add(Me.TabPage3)
        Me.TabCtr.Dock = System.Windows.Forms.DockStyle.Fill
        Me.TabCtr.HotTrack = True
        Me.TabCtr.Location = New System.Drawing.Point(0, 0)
        Me.TabCtr.Multiline = True
        Me.TabCtr.Name = "TabCtr"
        Me.TabCtr.SelectedIndex = 0
        Me.TabCtr.ShowToolTips = True
        Me.TabCtr.Size = New System.Drawing.Size(544, 429)
        Me.TabCtr.SizeMode = System.Windows.Forms.TabSizeMode.Fixed
        Me.TabCtr.TabIndex = 0
        '
        'TabPage1
        '
        Me.TabPage1.Controls.Add(Me.GroupBox1)
        Me.TabPage1.Location = New System.Drawing.Point(4, 24)
        Me.TabPage1.Name = "TabPage1"
        Me.TabPage1.Size = New System.Drawing.Size(536, 401)
        Me.TabPage1.TabIndex = 0
        Me.TabPage1.Text = "图书借阅"
        Me.TabPage1.ToolTipText = "借阅图书"
        '
        'GroupBox1
        '
        Me.GroupBox1.BackColor = System.Drawing.Color.FromArgb(CType(192, Byte), CType(192, Byte), CType(255, Byte))
        Me.GroupBox1.Controls.Add(Me.GroupBox3)
        Me.GroupBox1.Controls.Add(Me.GroupBox2)
        Me.GroupBox1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.GroupBox1.Location = New System.Drawing.Point(0, 0)
        Me.GroupBox1.Name = "GroupBox1"
        Me.GroupBox1.Size = New System.Drawing.Size(536, 401)
        Me.GroupBox1.TabIndex = 0
        Me.GroupBox1.TabStop = False
        '
        'GroupBox3
        '
        Me.GroupBox3.Controls.Add(Me.DataGrid1)
        Me.GroupBox3.Dock = System.Windows.Forms.DockStyle.Fill
        Me.GroupBox3.Location = New System.Drawing.Point(3, 216)
        Me.GroupBox3.Name = "GroupBox3"
        Me.GroupBox3.Size = New System.Drawing.Size(530, 182)
        Me.GroupBox3.TabIndex = 1
        Me.GroupBox3.TabStop = False
        Me.GroupBox3.Text = "读者借阅信息"
        '
        'DataGrid1
        '
        Me.DataGrid1.DataMember = ""
        Me.DataGrid1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.DataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.DataGrid1.Location = New System.Drawing.Point(3, 17)
        Me.DataGrid1.Name = "DataGrid1"
        Me.DataGrid1.ReadOnly = True
        Me.DataGrid1.Size = New System.Drawing.Size(524, 162)
        Me.DataGrid1.TabIndex = 0
        '
        'GroupBox2
        '
        Me.GroupBox2.Controls.Add(Me.GroupBox4)
        Me.GroupBox2.Controls.Add(Me.lbRdate)
        Me.GroupBox2.Controls.Add(Me.lbName)
        Me.GroupBox2.Controls.Add(Me.lbAuthor)
        Me.GroupBox2.Controls.Add(Me.lbPublishers)
        Me.GroupBox2.Controls.Add(Me.TextBox1)
        Me.GroupBox2.Controls.Add(Me.lbReturnDates)
        Me.GroupBox2.Controls.Add(Me.lbAuthors)
        Me.GroupBox2.Controls.Add(Me.lbPublisher)
        Me.GroupBox2.Controls.Add(Me.lbBookName)
        Me.GroupBox2.Controls.Add(Me.lbISBN)
        Me.GroupBox2.Dock = System.Windows.Forms.DockStyle.Top
        Me.GroupBox2.Location = New System.Drawing.Point(3, 17)
        Me.GroupBox2.Name = "GroupBox2"
        Me.GroupBox2.Size = New System.Drawing.Size(530, 199)
        Me.GroupBox2.TabIndex = 0
        Me.GroupBox2.TabStop = False
        Me.GroupBox2.Text = "图书信息"
        '
        'GroupBox4
        '
        Me.GroupBox4.Controls.Add(Me.TextBox2)
        Me.GroupBox4.Controls.Add(Me.lbID)
        Me.GroupBox4.Controls.Add(Me.btnBorrow)
        Me.GroupBox4.Location = New System.Drawing.Point(8, 144)
        Me.GroupBox4.Name = "GroupBox4"
        Me.GroupBox4.Size = New System.Drawing.Size(512, 48)
        Me.GroupBox4.TabIndex = 11
        Me.GroupBox4.TabStop = False
        '
        'TextBox2
        '
        Me.TextBox2.BackColor = System.Drawing.SystemColors.Info
        Me.TextBox2.Font = New System.Drawing.Font("宋体", 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))
        Me.TextBox2.Location = New System.Drawing.Point(120, 16)
        Me.TextBox2.MaxLength = 25
        Me.TextBox2.Name = "TextBox2"
        Me.TextBox2.Size = New System.Drawing.Size(328, 23)
        Me.TextBox2.TabIndex = 8
        Me.TextBox2.Text = ""
        '
        'lbID
        '
        Me.lbID.BackColor = System.Drawing.Color.Black
        Me.lbID.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D
        Me.lbID.Font = New System.Drawing.Font("宋体", 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))
        Me.lbID.ForeColor = System.Drawing.Color.White
        Me.lbID.Location = New System.Drawing.Point(8, 16)
        Me.lbID.Name = "lbID"
        Me.lbID.Size = New System.Drawing.Size(112, 23)
        Me.lbID.TabIndex = 7
        Me.lbID.Text = "读者借书证号"
        Me.lbID.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'btnBorrow
        '
        Me.btnBorrow.FlatStyle = System.Windows.Forms.FlatStyle.Flat
        Me.btnBorrow.ForeColor = System.Drawing.Color.Navy
        Me.btnBorrow.Location = New System.Drawing.Point(448, 16)