📄 borrow.frm
字号:
VERSION 5.00
Begin VB.Form borrow_form
AutoRedraw = -1 'True
BorderStyle = 1 'Fixed Single
Caption = "书籍借出"
ClientHeight = 6225
ClientLeft = 3615
ClientTop = 2640
ClientWidth = 12180
Icon = "borrow.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
Picture = "borrow.frx":000C
ScaleHeight = 6225
ScaleWidth = 12180
Begin VB.CommandButton Command1
BackColor = &H8000000E&
Caption = "关闭"
Height = 375
Left = 9360
Style = 1 'Graphical
TabIndex = 21
Top = 5160
Width = 1815
End
Begin VB.CommandButton clear
BackColor = &H8000000E&
Caption = "信息清除"
Height = 375
Left = 9360
Style = 1 'Graphical
TabIndex = 15
Top = 4440
Width = 1815
End
Begin VB.Frame Frame1
BackColor = &H8000000E&
Caption = "借阅信息"
Height = 3135
Left = 840
TabIndex = 2
Top = 2760
Width = 7335
Begin VB.TextBox oper
Appearance = 0 'Flat
Enabled = 0 'False
Height = 270
Left = 1080
TabIndex = 19
Top = 2160
Width = 2055
End
Begin VB.TextBox brdate
Appearance = 0 'Flat
Enabled = 0 'False
Height = 270
Left = 4800
TabIndex = 18
Top = 2160
Width = 2055
End
Begin VB.TextBox U_b_date
Appearance = 0 'Flat
Enabled = 0 'False
Height = 270
Left = 1080
TabIndex = 17
Top = 1680
Width = 2055
End
Begin VB.TextBox Bid
Height = 270
Left = 4800
TabIndex = 7
Top = 705
Width = 2055
End
Begin VB.TextBox Uname
Appearance = 0 'Flat
Enabled = 0 'False
Height = 270
Left = 1080
TabIndex = 6
Top = 1200
Width = 2055
End
Begin VB.TextBox Uid
Height = 270
Left = 1080
TabIndex = 5
Top = 720
Width = 2055
End
Begin VB.TextBox Bname
Appearance = 0 'Flat
Enabled = 0 'False
Height = 270
Left = 4800
TabIndex = 4
Top = 1200
Width = 2055
End
Begin VB.TextBox Bisbn
Appearance = 0 'Flat
Enabled = 0 'False
Height = 270
Left = 4800
TabIndex = 3
Top = 1680
Width = 2055
End
Begin VB.Label Label8
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "操作员"
Height = 180
Left = 240
TabIndex = 20
Top = 2160
Width = 540
End
Begin VB.Label Label7
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "借书期限"
Height = 180
Left = 3960
TabIndex = 16
Top = 2160
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "读者ID"
Height = 180
Left = 240
TabIndex = 13
Top = 720
Width = 540
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "书籍ID"
Height = 180
Left = 3960
TabIndex = 12
Top = 720
Width = 540
End
Begin VB.Label Label3
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "书籍名称"
Height = 180
Left = 3840
TabIndex = 11
Top = 1200
Width = 720
End
Begin VB.Label Label4
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "读者姓名"
Height = 180
Left = 120
TabIndex = 10
Top = 1200
Width = 720
End
Begin VB.Label Label5
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "ISBN"
Height = 180
Left = 4080
TabIndex = 9
Top = 1680
Width = 360
End
Begin VB.Label Label6
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "借书日期"
Height = 180
Left = 120
TabIndex = 8
Top = 1680
Width = 720
End
End
Begin VB.CommandButton borrow
BackColor = &H8000000E&
Caption = "书籍借出"
Enabled = 0 'False
Height = 375
Left = 9360
Style = 1 'Graphical
TabIndex = 1
Top = 3720
Width = 1815
End
Begin VB.CommandButton validate
BackColor = &H8000000E&
Caption = "信息验证"
Height = 375
Left = 9360
Style = 1 'Graphical
TabIndex = 0
Top = 3000
Width = 1815
End
Begin VB.Label caution
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "注意：请正确填写读者和书籍的ID"
ForeColor = &H000000FF&
Height = 180
Left = 840
TabIndex = 14
Top = 2160
Width = 2700
End
End
Attribute VB_Name = "borrow_form"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Bid_GotFocus()
Bid.BackColor = &HC0FFFF
End Sub
Private Sub Bid_LostFocus()
Bid.BackColor = &H80000005
End Sub
Private Sub borrow_Click()
Call borrow_update
End Sub
Private Sub Command1_Click()
borrow_form.Hide
Call borrow_clear
End Sub
Private Sub clear_Click()
Call borrow_clear
End Sub
Private Sub Form_Activate()
Uid.SetFocus
End Sub
Private Sub Uid_GotFocus()
Uid.BackColor = &HC0FFFF
End Sub
Private Sub Uid_LostFocus()
Uid.BackColor = &H80000005
End Sub
Private Sub validate_Click()
If Uid.Text = "" Or Bid.Text = "" Then
MsgBox "请正确填入用户和书籍ID", vbInformation, "T6-G4"
GoTo ed
End If
Call va_u_id_borrow
If ado.users_rs.EOF Then
GoTo ed
End If
Call va_b_id_borrow
If ado.books_rs.EOF Then
GoTo ed
Else
Call get_br_value_borrow
End If
ed:
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -