form1.frm

中北大学数据库课程设计

VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "Comdlg32.ocx"
Begin VB.MDIForm Form1 
   BackColor       =   &H8000000C&
   Caption         =   "图书管理系统 V 1.0"
   ClientHeight    =   5820
   ClientLeft      =   60
   ClientTop       =   630
   ClientWidth     =   8865
   Icon            =   "form1.frx":0000
   LinkTopic       =   "MDIForm1"
   StartUpPosition =   1  '所有者中心
   Begin MSComDlg.CommonDialog cod 
      Left            =   2280
      Top             =   2400
      _ExtentX        =   847
      _ExtentY        =   847
      _Version        =   393216
      Filter          =   "备份文件|*.bak"
      Flags           =   1
   End
   Begin VB.Menu book_manage 
      Caption         =   "图书信息管理 (&M)"
      Begin VB.Menu add_book_style 
         Caption         =   "添加图书类别"
      End
      Begin VB.Menu modify_book_style 
         Caption         =   "修改图书类别"
      End
      Begin VB.Menu del_book_style 
         Caption         =   "删除图书类别"
      End
      Begin VB.Menu fenge 
         Caption         =   "-"
      End
      Begin VB.Menu add_book_info 
         Caption         =   "添加图书信息"
      End
      Begin VB.Menu modify_book_info 
         Caption         =   "修改图书信息"
      End
      Begin VB.Menu del_book_info 
         Caption         =   "删除图书信息"
      End
      Begin VB.Menu book_exit 
         Caption         =   "退出(&X)"
      End
   End
   Begin VB.Menu reader_manage 
      Caption         =   "读者管理 (&R)"
      Begin VB.Menu add_reader_style 
         Caption         =   "添加读者类别"
      End
      Begin VB.Menu modify_reader_style 
         Caption         =   "修改读者类别"
      End
      Begin VB.Menu del_reader_style 
         Caption         =   "删除读者类别"
      End
      Begin VB.Menu fenge1 
         Caption         =   "-"
      End
      Begin VB.Menu add_reader_info 
         Caption         =   "添加读者信息"
      End
      Begin VB.Menu modify_reader_info 
         Caption         =   "修改读者信息"
      End
      Begin VB.Menu del_reader_info 
         Caption         =   "删除读者信息"
      End
   End
   Begin VB.Menu query 
      Caption         =   "查询 (&Q)"
      Begin VB.Menu find_book_info 
         Caption         =   "查询图书信息"
      End
      Begin VB.Menu heng1 
         Caption         =   "-"
      End
      Begin VB.Menu find_reader_info 
         Caption         =   "查询读者信息"
      End
   End
   Begin VB.Menu lend_book_manage 
      Caption         =   "借书 (B)"
      Begin VB.Menu add_lend_book 
         Caption         =   "添加借书信息"
      End
      Begin VB.Menu heng2 
         Caption         =   "-"
      End
      Begin VB.Menu find_lend_book 
         Caption         =   "查询借书信息"
      End
   End
   Begin VB.Menu back_book_manage 
      Caption         =   "还书 (&T)"
      Begin VB.Menu add_back_book 
         Caption         =   "添加还书信息"
      End
   End
   Begin VB.Menu database 
      Caption         =   "数据库功能 (&D)"
      Begin VB.Menu bankup 
         Caption         =   "数据备份"
      End
      Begin VB.Menu heng3 
         Caption         =   "-"
      End
      Begin VB.Menu revive 
         Caption         =   "数据恢复"
      End
   End
   Begin VB.Menu users 
      Caption         =   "设置用户 (&S)"
      Begin VB.Menu add_admin 
         Caption         =   "添加管理员"
      End
      Begin VB.Menu heng4 
         Caption         =   "-"
      End
      Begin VB.Menu change_pwd 
         Caption         =   "修改密码"
      End
   End
   Begin VB.Menu help 
      Caption         =   "帮助 (&H)"
      Begin VB.Menu about 
         Caption         =   "关于"
      End
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Declare Function ShellAbout Lib "shell32.dll" _
Alias "ShellAboutA" (ByVal hWnd As Long, ByVal szApp As String, _
ByVal szOtherStuff As String, ByVal hIcon As Long) As Long
Private Sub about_Click()
ShellAbout hWnd, " 图书管理系统-2005-02090402  ", "版本:1.0  By 刘庆 袁军会 尤其 殷越 吴杰 ", Me.Icon
End Sub

Private Sub add_admin_Click()
frmadduser.Show
End Sub

Private Sub add_back_book_Click()
frmbackbookinfo.Show
End Sub

Private Sub add_book_info_Click()
frmaddbookinfo.Show
End Sub

Private Sub add_book_style_Click()
frmaddbookstyle.Show
End Sub

Private Sub add_lend_book_Click()
frmfindbook.Show
End Sub

Private Sub add_reader_info_Click()
frmaddreaderinfo.Show
End Sub

Private Sub add_reader_style_Click()
frmaddreaderstyle.Show
End Sub

Private Sub bankup_Click()
cod.DialogTitle = "备份数据库"
cod.FileName = ""
cod.ShowSave
If cod.FileName = "" Then
    Exit Sub
Else
Dim fso As New FileSystemObject
fso.CopyFile App.Path & "\book.mdb", cod.FileName
MsgBox "backup sucess!!", vbOKOnly + vbInformation, "ok"
End If
End Sub

Private Sub change_pwd_Click()
frmchangepwd.Show
End Sub

Private Sub book_exit_Click()
End
End Sub

Private Sub del_book_info_Click()
frmmodifybookinfo.Show
End Sub

Private Sub del_book_style_Click()
frmmodifybookstyle.Show
End Sub

Private Sub del_reader_info_Click()
frmreaderinfo.Show
End Sub

Private Sub del_reader_style_Click()
frmmodifyreaderstyle.Show
End Sub

Private Sub exit_sys_Click()
End
End Sub

Private Sub find_book_info_Click()
frmfindbook.Show
End Sub

Private Sub find_lend_book_Click()
frmfindborrowinfo.Show
End Sub

Private Sub find_reader_info_Click()
frmfindreader.Show
End Sub

Private Sub MDIForm_Load()
If userpow = "guest" Then
book_manage.Enabled = False
reader_manage.Enabled = False
book_lend.Enabled = False
database.Enabled = False
users.Enabled = False
End If
End Sub

Private Sub modify_book_info_Click()
frmmodifybookinfo.Show
End Sub

Private Sub modify_book_style_Click()
frmmodifybookstyle.Show
End Sub

Private Sub modify_reader_info_Click()
frmreaderinfo.Show
End Sub

Private Sub modify_reader_style_Click()
frmmodifyreaderstyle.Show
End Sub

Private Sub revive_Click()
cod.DialogTitle = "恢复数据库"
cod.FileName = ""
cod.ShowOpen
If cod.FileName = "" Then
    Exit Sub
Else
Dim fso As FileSystemObject
Set fso = New FileSystemObject
fso.CopyFile cod.FileName, App.Path & "\book.mdb"
MsgBox "restore sucess!!", vbOKOnly + vbInformation, "ok"
End If
End Sub