vb模拟 图书管理系统

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.MDIForm 菜单 
   BackColor       =   &H8000000F&
   Caption         =   "图书馆管理系统"
   ClientHeight    =   3090
   ClientLeft      =   60
   ClientTop       =   750
   ClientWidth     =   4920
   LinkTopic       =   "MDIForm1"
   StartUpPosition =   2  '屏幕中心
   WindowState     =   2  'Maximized
   Begin MSComctlLib.StatusBar StatusBar1 
      Align           =   2  'Align Bottom
      Height          =   315
      Left            =   0
      TabIndex        =   0
      Top             =   2775
      Width           =   4920
      _ExtentX        =   8678
      _ExtentY        =   556
      _Version        =   393216
      BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628} 
         NumPanels       =   1
         BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
         EndProperty
      EndProperty
   End
   Begin VB.Menu menu1 
      Caption         =   "图书借还处理"
      Begin VB.Menu menu11 
         Caption         =   "图书借阅处理"
      End
      Begin VB.Menu menu12 
         Caption         =   "图书归还处理"
      End
      Begin VB.Menu menu13 
         Caption         =   "退出(&Q)"
      End
   End
   Begin VB.Menu menu2 
      Caption         =   "图书管理"
      Begin VB.Menu menu21 
         Caption         =   "图书入库处理"
      End
      Begin VB.Menu menu22 
         Caption         =   "图书查找处理"
      End
   End
   Begin VB.Menu menu3 
      Caption         =   "读者管理"
      Begin VB.Menu menu31 
         Caption         =   "读者登记处理"
      End
      Begin VB.Menu menu32 
         Caption         =   "读者查找处理"
      End
   End
   Begin VB.Menu menu4 
      Caption         =   "系统维护管理"
      Begin VB.Menu menu41 
         Caption         =   "设置系统用户"
      End
      Begin VB.Menu menu42 
         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()
If Not userlevel = "系统管理员" Then
menu21.Enabled = False
menu31.Enabled = False
menu41.Enabled = False
menu42.Enabled = False
End If
If userlevel = "访客" Then
menu11.Enabled = False
menu12.Enabled = False
menu21.Enabled = False
menu31.Enabled = False
menu32.Enabled = False
menu41.Enabled = False
menu42.Enabled = False
End If
End Sub

Private Sub menu11_Click()
图书借阅.Show vbModal
End Sub

Private Sub menu12_Click()
图书归还.Show vbModal
End Sub

Private Sub menu13_Click()
End
End Sub

Private Sub menu21_Click()
图书入库.Show vbModal
End Sub

Private Sub menu22_Click()
图书查找.Show vbModal
End Sub

Private Sub menu31_Click()
读者登记.Show vbModal
End Sub

Private Sub menu32_Click()
读者查找.Show vbModal
End Sub

Private Sub menu41_Click()
设置系统用户.Show vbModal
End Sub

Private Sub menu42_Click()
If MsgBox("本功能要清除系统中所有数据，真的初始化吗？", vbYesNo, _
"确认初始化操作") = vbYes Then
Call deldata(conn)
sql = "delete * from book"
conn.Execute sql
sql = "delete * from reader"
conn.Execute sql
sql = "delete * from borrow"
conn.Execute sql
sql = "delete * from rlevel"
conn.Execute sql
sql = "delete * from depart"
conn.Execute sql
sql = "delete * from press"
conn.Execute sql
'Call deldata("book")
'Call deldata("reader")
'Call deldata("borrow")
'Call deldata("rlevel")
'Call deldata("depart")
'Call deldata("press")
'Call deldata("oper")
MsgBox "系统初始化完毕，下次只能以1234/1234（用户名/口令）进入本系统", _
vbOKOnly, "信息提示"
End If
End Sub