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

📄 menu.frm

📁 一个数据库程序
💻 FRM
字号:
VERSION 5.00
Begin VB.Form Menu 
   BackColor       =   &H80000003&
   Caption         =   "图书管理系统"
   ClientHeight    =   2700
   ClientLeft      =   195
   ClientTop       =   480
   ClientWidth     =   7875
   FillColor       =   &H00404000&
   ForeColor       =   &H80000010&
   Icon            =   "Menu.frx":0000
   LinkTopic       =   "Form1"
   Picture         =   "Menu.frx":324A
   ScaleHeight     =   2700
   ScaleWidth      =   7875
   Begin VB.CommandButton changepas 
      Caption         =   "更改密码"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   4080
      TabIndex        =   11
      Top             =   1920
      Width           =   1455
   End
   Begin VB.CommandButton Command1 
      BackColor       =   &H80000001&
      Caption         =   "历史数据"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   6000
      MaskColor       =   &H00404000&
      TabIndex        =   7
      Top             =   1200
      Width           =   1455
   End
   Begin VB.CommandButton bk_search 
      BackColor       =   &H80000001&
      Caption         =   "书目查询"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   480
      MaskColor       =   &H00404000&
      TabIndex        =   5
      Top             =   1200
      Width           =   1455
   End
   Begin VB.CommandButton exit 
      BackColor       =   &H80000001&
      Caption         =   "退出"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   6000
      MaskColor       =   &H00404000&
      TabIndex        =   8
      Top             =   1920
      Width           =   1455
   End
   Begin VB.CommandButton rd_mng 
      BackColor       =   &H80000001&
      Caption         =   "读者管理"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   2280
      MaskColor       =   &H00404000&
      TabIndex        =   6
      Top             =   1200
      Width           =   1455
   End
   Begin VB.CommandButton punish_mng 
      BackColor       =   &H80000001&
      Caption         =   "罚款处理"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   4080
      MaskColor       =   &H00404000&
      TabIndex        =   4
      Top             =   1200
      Width           =   1455
   End
   Begin VB.CommandButton ret_bk 
      BackColor       =   &H80000001&
      Caption         =   "读者还书"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   6000
      MaskColor       =   &H00404000&
      TabIndex        =   3
      Top             =   480
      Width           =   1455
   End
   Begin VB.CommandButton bor_bk 
      BackColor       =   &H80000001&
      Caption         =   "读者借书"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   4080
      MaskColor       =   &H00404000&
      TabIndex        =   2
      Top             =   480
      Width           =   1455
   End
   Begin VB.CommandButton drop_obk 
      BackColor       =   &H80000001&
      Caption         =   "旧书出库"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   2280
      MaskColor       =   &H00404000&
      TabIndex        =   1
      Top             =   480
      Width           =   1455
   End
   Begin VB.CommandButton load_nbk 
      BackColor       =   &H80000001&
      Caption         =   "新书入库"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   480
      MaskColor       =   &H00404000&
      TabIndex        =   0
      Top             =   480
      Width           =   1455
   End
   Begin VB.Label Label2 
      BackColor       =   &H80000018&
      Caption         =   "版权所有  一笑工作室  2004-2005"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   -1  'True
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   600
      TabIndex        =   10
      Top             =   2040
      Width           =   3015
   End
   Begin VB.Label Label1 
      Caption         =   "图书管理系统   1.0版"
      BeginProperty Font 
         Name            =   "楷体_GB2312"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   2160
      TabIndex        =   9
      Top             =   120
      Width           =   2535
   End
End
Attribute VB_Name = "Menu"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs As Recordset
Dim str As String

Private Sub bk_search_Click()
search_bk.Show vbModal
End Sub

Private Sub bor_bk_Click()
borrow.Show vbModal
End Sub

Private Sub changepas_Click()
 change_pass.Show vbModal
End Sub

Private Sub Command1_Click()
history.Show vbModal
End Sub

Private Sub drop_obk_Click()
bkout.Show vbModal
End Sub

Private Sub exit_Click()
    
    Unload Me
    
End Sub

Private Sub load_nbk_Click()

load_nbkf.Show vbModal

End Sub

Private Sub punish_mng_Click()
stri = "delete 罚款记录表"
exesql (stri)
stri = "insert 罚款记录表 select  读者编号,图书编号,罚款日期=借书日期+30,罚款数目=datediff(dd,借书日期,getdate())-30 From 图书借阅表 Where DateDiff(dd, 借书日期, getdate()) - 30 > 0 "
exesql (stri)
punish.Show vbModal
End Sub

Private Sub rd_mng_Click()
reader.Show vbModal
End Sub

Private Sub ret_bk_Click()
retbk.Show vbModal
End Sub

⌨️ 快捷键说明

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