frmuser.vb

基于VB.NET开发的简单的图书馆管理系统,可正常运行以测试,内带源码.

Imports System.Data
Imports System.Data.sqlclient
Public Class frmuser
    Inherits System.Windows.Forms.Form

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

    Public Sub New()
        MyBase.New()

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

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

    End Sub

    '窗体重写 dispose 以清理组件列表。
    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 stabmain As System.Windows.Forms.StatusBar
    Friend WithEvents stabusername As System.Windows.Forms.StatusBarPanel
    Friend WithEvents stauserquanxian As System.Windows.Forms.StatusBarPanel
    Friend WithEvents tabborrow As System.Windows.Forms.TabPage
    Friend WithEvents Label16 As System.Windows.Forms.Label
    Friend WithEvents bnB As System.Windows.Forms.Button
    Friend WithEvents tbBookid As System.Windows.Forms.TextBox
    Friend WithEvents bnQuery As System.Windows.Forms.Button
    Friend WithEvents dgRst As System.Windows.Forms.DataGrid
    Friend WithEvents Label9 As System.Windows.Forms.Label
    Friend WithEvents Label10 As System.Windows.Forms.Label
    Friend WithEvents Label11 As System.Windows.Forms.Label
    Friend WithEvents tbValuejs As System.Windows.Forms.TextBox
    Friend WithEvents cbConjs As System.Windows.Forms.ComboBox
    Friend WithEvents cbFieldjs As System.Windows.Forms.ComboBox
    Friend WithEvents tabreturn As System.Windows.Forms.TabPage
    Friend WithEvents bthslook As System.Windows.Forms.Button
    Friend WithEvents Label19 As System.Windows.Forms.Label
    Friend WithEvents Label18 As System.Windows.Forms.Label
    Friend WithEvents bnH As System.Windows.Forms.Button
    Friend WithEvents tbhsbookid As System.Windows.Forms.TextBox
    Friend WithEvents dg2 As System.Windows.Forms.DataGrid
    Friend WithEvents tabquery As System.Windows.Forms.TabPage
    Friend WithEvents Button5 As System.Windows.Forms.Button
    Friend WithEvents dgrstquery As System.Windows.Forms.DataGrid
    Friend WithEvents Label13 As System.Windows.Forms.Label
    Friend WithEvents Label14 As System.Windows.Forms.Label
    Friend WithEvents Label17 As System.Windows.Forms.Label
    Friend WithEvents tbValuecx As System.Windows.Forms.TextBox
    Friend WithEvents cbConcx As System.Windows.Forms.ComboBox
    Friend WithEvents cbFieldcx As System.Windows.Forms.ComboBox
    Friend WithEvents tabcborrow As System.Windows.Forms.TabPage
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents Button2 As System.Windows.Forms.Button
    Friend WithEvents Label12 As System.Windows.Forms.Label
    Friend WithEvents bnXj As System.Windows.Forms.Button
    Friend WithEvents tbxjbookid As System.Windows.Forms.TextBox
    Friend WithEvents dg1 As System.Windows.Forms.DataGrid
    Friend WithEvents TabPage6 As System.Windows.Forms.TabPage
    Friend WithEvents tbtelno As System.Windows.Forms.TextBox
    Friend WithEvents Label15 As System.Windows.Forms.Label
    Friend WithEvents bnCancle As System.Windows.Forms.Button
    Friend WithEvents bnModify As System.Windows.Forms.Button
    Friend WithEvents tbStudNo As System.Windows.Forms.TextBox
    Friend WithEvents tbClass As System.Windows.Forms.TextBox
    Friend WithEvents tbEmail As System.Windows.Forms.TextBox
    Friend WithEvents tbusername As System.Windows.Forms.TextBox
    Friend WithEvents tbPwdConfirm As System.Windows.Forms.TextBox
    Friend WithEvents tbPwd As System.Windows.Forms.TextBox
    Friend WithEvents tbloginname As System.Windows.Forms.TextBox
    Friend WithEvents Label7 As System.Windows.Forms.Label
    Friend WithEvents Label6 As System.Windows.Forms.Label
    Friend WithEvents Label5 As System.Windows.Forms.Label
    Friend WithEvents Label4 As System.Windows.Forms.Label
    Friend WithEvents Label3 As System.Windows.Forms.Label
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents Label8 As System.Windows.Forms.Label
    Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
    Friend WithEvents TabControl1 As System.Windows.Forms.TabControl
    Friend WithEvents tbsex As System.Windows.Forms.TextBox
    Friend WithEvents Label20 As System.Windows.Forms.Label
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmuser))
        Me.stabmain = New System.Windows.Forms.StatusBar
        Me.stabusername = New System.Windows.Forms.StatusBarPanel
        Me.stauserquanxian = New System.Windows.Forms.StatusBarPanel
        Me.tabborrow = New System.Windows.Forms.TabPage
        Me.Label16 = New System.Windows.Forms.Label
        Me.bnB = New System.Windows.Forms.Button
        Me.tbBookid = New System.Windows.Forms.TextBox
        Me.bnQuery = New System.Windows.Forms.Button
        Me.dgRst = New System.Windows.Forms.DataGrid
        Me.Label9 = New System.Windows.Forms.Label
        Me.Label10 = New System.Windows.Forms.Label
        Me.Label11 = New System.Windows.Forms.Label
        Me.tbValuejs = New System.Windows.Forms.TextBox
        Me.cbConjs = New System.Windows.Forms.ComboBox
        Me.cbFieldjs = New System.Windows.Forms.ComboBox
        Me.tabreturn = New System.Windows.Forms.TabPage
        Me.bthslook = New System.Windows.Forms.Button
        Me.Label19 = New System.Windows.Forms.Label
        Me.Label18 = New System.Windows.Forms.Label
        Me.bnH = New System.Windows.Forms.Button
        Me.tbhsbookid = New System.Windows.Forms.TextBox
        Me.dg2 = New System.Windows.Forms.DataGrid
        Me.tabquery = New System.Windows.Forms.TabPage
        Me.Button5 = New System.Windows.Forms.Button
        Me.dgrstquery = New System.Windows.Forms.DataGrid
        Me.Label13 = New System.Windows.Forms.Label
        Me.Label14 = New System.Windows.Forms.Label
        Me.Label17 = New System.Windows.Forms.Label
        Me.tbValuecx = New System.Windows.Forms.TextBox
        Me.cbConcx = New System.Windows.Forms.ComboBox
        Me.cbFieldcx = New System.Windows.Forms.ComboBox
        Me.tabcborrow = New System.Windows.Forms.TabPage
        Me.Label1 = New System.Windows.Forms.Label
        Me.Button2 = New System.Windows.Forms.Button
        Me.Label12 = New System.Windows.Forms.Label
        Me.bnXj = New System.Windows.Forms.Button
        Me.tbxjbookid = New System.Windows.Forms.TextBox
        Me.dg1 = New System.Windows.Forms.DataGrid
        Me.TabPage6 = New System.Windows.Forms.TabPage
        Me.tbsex = New System.Windows.Forms.TextBox
        Me.Label20 = New System.Windows.Forms.Label
        Me.tbtelno = New System.Windows.Forms.TextBox
        Me.Label15 = New System.Windows.Forms.Label
        Me.bnCancle = New System.Windows.Forms.Button
        Me.bnModify = New System.Windows.Forms.Button
        Me.tbStudNo = New System.Windows.Forms.TextBox
        Me.tbClass = New System.Windows.Forms.TextBox
        Me.tbEmail = New System.Windows.Forms.TextBox
        Me.tbusername = New System.Windows.Forms.TextBox
        Me.tbPwdConfirm = New System.Windows.Forms.TextBox
        Me.tbPwd = New System.Windows.Forms.TextBox
        Me.tbloginname = New System.Windows.Forms.TextBox
        Me.Label7 = New System.Windows.Forms.Label
        Me.Label6 = New System.Windows.Forms.Label
        Me.Label5 = New System.Windows.Forms.Label
        Me.Label4 = New System.Windows.Forms.Label
        Me.Label3 = New System.Windows.Forms.Label
        Me.Label2 = New System.Windows.Forms.Label
        Me.Label8 = New System.Windows.Forms.Label
        Me.GroupBox1 = New System.Windows.Forms.GroupBox
        Me.TabControl1 = New System.Windows.Forms.TabControl
        CType(Me.stabusername, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.stauserquanxian, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.tabborrow.SuspendLayout()
        CType(Me.dgRst, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.tabreturn.SuspendLayout()
        CType(Me.dg2, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.tabquery.SuspendLayout()
        CType(Me.dgrstquery, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.tabcborrow.SuspendLayout()
        CType(Me.dg1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.TabPage6.SuspendLayout()
        Me.TabControl1.SuspendLayout()
        Me.SuspendLayout()
        '
        'stabmain
        '
        Me.stabmain.Location = New System.Drawing.Point(0, 453)
        Me.stabmain.Name = "stabmain"
        Me.stabmain.Panels.AddRange(New System.Windows.Forms.StatusBarPanel() {Me.stabusername, Me.stauserquanxian})
        Me.stabmain.ShowPanels = True
        Me.stabmain.Size = New System.Drawing.Size(600, 32)
        Me.stabmain.TabIndex = 2
        Me.stabmain.Text = "StatusBar1"
        '
        'stabusername
        '
        Me.stabusername.AutoSize = System.Windows.Forms.StatusBarPanelAutoSize.Spring
        Me.stabusername.Text = "当前登录用户名称："
        Me.stabusername.Width = 292
        '
        'stauserquanxian
        '
        Me.stauserquanxian.AutoSize = System.Windows.Forms.StatusBarPanelAutoSize.Spring
        Me.stauserquanxian.Text = "当前登录用户权限"
        Me.stauserquanxian.Width = 292
        '
        'tabborrow
        '
        Me.tabborrow.Controls.Add(Me.Label16)
        Me.tabborrow.Controls.Add(Me.bnB)
        Me.tabborrow.Controls.Add(Me.tbBookid)
        Me.tabborrow.Controls.Add(Me.bnQuery)
        Me.tabborrow.Controls.Add(Me.dgRst)
        Me.tabborrow.Controls.Add(Me.Label9)
        Me.tabborrow.Controls.Add(Me.Label10)
        Me.tabborrow.Controls.Add(Me.Label11)
        Me.tabborrow.Controls.Add(Me.tbValuejs)
        Me.tabborrow.Controls.Add(Me.cbConjs)
        Me.tabborrow.Controls.Add(Me.cbFieldjs)
        Me.tabborrow.Location = New System.Drawing.Point(4, 21)
        Me.tabborrow.Name = "tabborrow"
        Me.tabborrow.Size = New System.Drawing.Size(592, 375)
        Me.tabborrow.TabIndex = 0
        Me.tabborrow.Text = "借书"
        '
        'Label16
        '
        Me.Label16.Location = New System.Drawing.Point(60, 326)
        Me.Label16.Name = "Label16"
        Me.Label16.Size = New System.Drawing.Size(104, 23)
        Me.Label16.TabIndex = 42
        Me.Label16.Text = "请输入图书编号："
        '
        'bnB
        '
        Me.bnB.Location = New System.Drawing.Point(452, 322)
        Me.bnB.Name = "bnB"
        Me.bnB.Size = New System.Drawing.Size(80, 23)
        Me.bnB.TabIndex = 41
        Me.bnB.Text = "借书"
        '
        'tbBookid
        '
        Me.tbBookid.Location = New System.Drawing.Point(164, 322)
        Me.tbBookid.Name = "tbBookid"
        Me.tbBookid.Size = New System.Drawing.Size(288, 21)
        Me.tbBookid.TabIndex = 40
        Me.tbBookid.Text = ""
        '
        'bnQuery
        '
        Me.bnQuery.Location = New System.Drawing.Point(443, 26)
        Me.bnQuery.Name = "bnQuery"
        Me.bnQuery.TabIndex = 39
        Me.bnQuery.Text = "查询"
        '
        'dgRst
        '
        Me.dgRst.DataMember = ""
        Me.dgRst.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.dgRst.Location = New System.Drawing.Point(67, 98)
        Me.dgRst.Name = "dgRst"
        Me.dgRst.Size = New System.Drawing.Size(464, 200)
        Me.dgRst.TabIndex = 38
        '
        'Label9
        '
        Me.Label9.Location = New System.Drawing.Point(275, 34)
        Me.Label9.Name = "Label9"
        Me.Label9.Size = New System.Drawing.Size(56, 16)
        Me.Label9.TabIndex = 37
        Me.Label9.Text = "查询值"
        '
        'Label10
        '
        Me.Label10.Location = New System.Drawing.Point(203, 34)
        Me.Label10.Name = "Label10"
        Me.Label10.Size = New System.Drawing.Size(56, 16)
        Me.Label10.TabIndex = 36
        Me.Label10.Text = "查询条件"
        '
        'Label11
        '
        Me.Label11.Location = New System.Drawing.Point(67, 34)
        Me.Label11.Name = "Label11"
        Me.Label11.Size = New System.Drawing.Size(56, 16)
        Me.Label11.TabIndex = 35
        Me.Label11.Text = "查询项目"
        '
        'tbValuejs
        '
        Me.tbValuejs.Location = New System.Drawing.Point(283, 58)
        Me.tbValuejs.Name = "tbValuejs"
        Me.tbValuejs.Size = New System.Drawing.Size(248, 21)
        Me.tbValuejs.TabIndex = 34
        Me.tbValuejs.Text = ""
        '
        'cbConjs
        '
        Me.cbConjs.ItemHeight = 12
        Me.cbConjs.Items.AddRange(New Object() {"等于", "大于", "小于", "大于等于", "小于等于", "不等于", "模糊查"})