⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 图书管理系统.frm

📁 入库新书管理模块:用于登记新购图书和受赠图书两部分信息
💻 FRM
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.MDIForm 图书管理系统 
   BackColor       =   &H8000000C&
   Caption         =   "图书管理系统"
   ClientHeight    =   6510
   ClientLeft      =   165
   ClientTop       =   735
   ClientWidth     =   9540
   LinkTopic       =   "MDIForm1"
   StartUpPosition =   3  'Windows Default
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   0
      Top             =   2160
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   32
      ImageHeight     =   32
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   11
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":0000
            Key             =   ""
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":0856
            Key             =   ""
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":137C
            Key             =   ""
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":1D26
            Key             =   ""
         EndProperty
         BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":257C
            Key             =   ""
         EndProperty
         BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":2E4A
            Key             =   ""
         EndProperty
         BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":3718
            Key             =   ""
         EndProperty
         BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":4142
            Key             =   ""
         EndProperty
         BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":4AEC
            Key             =   ""
         EndProperty
         BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":53CA
            Key             =   ""
         EndProperty
         BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "图书管理系统.frx":5BE4
            Key             =   ""
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.Toolbar Toolbar1 
      Align           =   1  'Align Top
      Height          =   810
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   9540
      _ExtentX        =   16828
      _ExtentY        =   1429
      ButtonWidth     =   1455
      ButtonHeight    =   1376
      Style           =   1
      ImageList       =   "ImageList1"
      HotImageList    =   "ImageList1"
      _Version        =   393216
      BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
         NumButtons      =   12
         BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "图书信息"
            Key             =   "图书信息"
            Object.ToolTipText     =   "图书信息"
            ImageIndex      =   1
         EndProperty
         BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "读者信息"
            Key             =   "读者信息"
            Object.ToolTipText     =   "读者信息"
            ImageIndex      =   2
         EndProperty
         BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "借书"
            Key             =   "借书"
            ImageIndex      =   5
         EndProperty
         BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "还书"
            Key             =   "还书"
            Object.ToolTipText     =   "还书"
            ImageIndex      =   8
         EndProperty
         BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "图书检索"
            Key             =   "图书检索"
            Object.ToolTipText     =   "图书检索"
            ImageIndex      =   6
         EndProperty
         BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "重新登录"
            Key             =   "重新登录"
            Object.ToolTipText     =   "重新登录"
            ImageIndex      =   7
         EndProperty
         BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
      EndProperty
      BorderStyle     =   1
   End
   Begin VB.Menu 资料管理 
      Caption         =   "【资料管理】"
      Begin VB.Menu 文献类型 
         Caption         =   "文献类型"
      End
      Begin VB.Menu 图书信息 
         Caption         =   "图书信息"
         Shortcut        =   ^Z
      End
      Begin VB.Menu 读者信息 
         Caption         =   "读者信息"
         Shortcut        =   ^D
      End
   End
   Begin VB.Menu 借书管理 
      Caption         =   "【借书管理】"
      Begin VB.Menu 图书预约 
         Caption         =   "图书预约"
      End
      Begin VB.Menu 借书 
         Caption         =   "借书"
         Shortcut        =   ^X
      End
      Begin VB.Menu 图书续借 
         Caption         =   "图书续借"
      End
   End
   Begin VB.Menu 还书管理 
      Caption         =   "【还书管理】"
      Begin VB.Menu 还书 
         Caption         =   "还书"
         Shortcut        =   ^A
      End
      Begin VB.Menu 逾期图书 
         Caption         =   "逾期图书"
      End
      Begin VB.Menu 罚款信息 
         Caption         =   "罚款信息"
      End
   End
   Begin VB.Menu 检索统计 
      Caption         =   "【检索统计】"
      Begin VB.Menu 图书检索 
         Caption         =   "图书检索"
         Shortcut        =   ^Q
      End
      Begin VB.Menu 动态信息 
         Caption         =   "动态信息"
      End
      Begin VB.Menu 统计分析 
         Caption         =   "统计分析"
      End
   End
   Begin VB.Menu 系统管理 
      Caption         =   "【系统管理】"
      Begin VB.Menu 用户管理 
         Caption         =   "用户管理"
      End
      Begin VB.Menu 密码维护 
         Caption         =   "密码维护"
      End
      Begin VB.Menu 重新登录 
         Caption         =   "重新登录"
      End
      Begin VB.Menu space 
         Caption         =   "-"
      End
      Begin VB.Menu 参数配置 
         Caption         =   "参数配置"
      End
   End
End
Attribute VB_Name = "图书管理系统"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub MDIForm_Load()
    Dim rst As ADODB.Recordset
    Dim rights As String
    Dim sTokens() As String
    Dim msg As String
    '得到系统参数
    Call SetSystemPar
    
    '查询权限信息
    SQL = " select 权限 from 用户信息表 where 用户ID='" & Sys_UserID & "'"
    Set rst = SelectSQL(SQL, msg)
    If rst.RecordCount > 0 Then
        rights = Trim(rst.Fields(0))
        rst.Close
    Else
        MsgBox ("没有用户信息!")
        Exit Sub
    End If
    '设置权限
   资料管理.Enabled = InStr(rights, "资料管理")
   借书管理.Enabled = InStr(rights, "借书管理")
   还书管理.Enabled = InStr(rights, "还书管理")
   检索统计.Enabled = InStr(rights, "检索统计")
   '系统管理.Enabled = InStr(rights, "系统管理")
End Sub
Private Sub 文献类型_Click()
    A文献类型.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 图书信息_Click()
    A图书信息.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 读者信息_Click()
    A读者信息.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 图书预约_Click()
    B图书预约.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 借书_Click()
    B借书.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 图书续借_Click()
    B图书续借.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 还书_Click()
    C还书.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 逾期图书_Click()
    C逾期图书.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 罚款信息_Click()
    C罚款信息.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 图书检索_Click()
    D图书检索.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 动态信息_Click()
    D动态信息.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 统计分析_Click()
    D统计分析.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 用户管理_Click()
    E用户管理.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 密码维护_Click()
    E密码维护.Show
    图书管理系统.Enabled = False
End Sub
Private Sub 重新登录_Click()
    Unload Me
    E重新登录.Show
End Sub
Private Sub 参数配置_Click()
    E参数配置.Show
    图书管理系统.Enabled = False
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
    Select Case Button.Index
    Case 1:
        Call 图书信息_Click             '调入图书信息
    Case 3:
        Call 读者信息_Click             '调入读者信息
    Case 5:
        Call 借书_Click                 '调入借书
    Case 7:
        Call 还书_Click                 '调入还书
    Case 9:
        Call 图书检索_Click             '调入图书检索
    Case 11:
        Call 重新登录_Click             '调入重新登录
    End Select
End Sub

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -