📄 backbook.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form backbook
BorderStyle = 3 'Fixed Dialog
Caption = "还书"
ClientHeight = 4380
ClientLeft = 45
ClientTop = 330
ClientWidth = 6765
LinkTopic = "Form2"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
Picture = "backbook.frx":0000
ScaleHeight = 4380
ScaleWidth = 6765
ShowInTaskbar = 0 'False
Begin VB.TextBox Text1
Appearance = 0 'Flat
BackColor = &H00E0E0E0&
Height = 270
Index = 0
Left = 1320
TabIndex = 6
Text = "Text1"
Top = 240
Width = 855
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BackColor = &H00E0E0E0&
Height = 270
Index = 1
Left = 3360
TabIndex = 5
Text = "Text1"
Top = 240
Width = 855
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BackColor = &H00E0E0E0&
Height = 270
Index = 2
Left = 1320
TabIndex = 4
Text = "Text1"
Top = 960
Width = 855
End
Begin VB.TextBox Text1
Appearance = 0 'Flat
BackColor = &H00E0E0E0&
Height = 270
Index = 3
Left = 3360
TabIndex = 3
Text = "Text1"
Top = 960
Width = 855
End
Begin VB.CommandButton Command1
Caption = "还书"
Height = 375
Left = 4920
Picture = "backbook.frx":9C09
Style = 1 'Graphical
TabIndex = 1
Top = 240
Width = 975
End
Begin VB.CommandButton Command2
Caption = "关闭"
Height = 375
Left = 4920
Picture = "backbook.frx":C469
Style = 1 'Graphical
TabIndex = 0
Top = 960
Width = 975
End
Begin MSComctlLib.ListView ListView1
Height = 1575
Left = 120
TabIndex = 2
Top = 2520
Width = 6495
_ExtentX = 11456
_ExtentY = 2778
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
HotTracking = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = 14737632
BorderStyle = 1
Appearance = 1
NumItems = 0
End
Begin VB.Label Label3
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "请选择您想要还的书"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 2160
TabIndex = 12
Top = 2160
Width = 2310
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "借书借号"
Height = 180
Index = 0
Left = 360
TabIndex = 11
Top = 360
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "姓名"
Height = 180
Index = 1
Left = 2760
TabIndex = 10
Top = 360
Width = 360
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "共欠罚金"
Height = 180
Index = 2
Left = 360
TabIndex = 9
Top = 1080
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "班级"
Height = 180
Index = 3
Left = 2760
TabIndex = 8
Top = 1080
Width = 360
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Label2"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 240
Left = 1560
TabIndex = 7
Top = 1800
Width = 825
End
End
Attribute VB_Name = "backbook"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim sql As String
Dim username1 As String
Dim bookno1 As String
username1 = Replace(Trim(ListView1.SelectedItem.Text), "'", "''") & " "
bookno1 = Replace(Trim(ListView1.SelectedItem.SubItems(2)), "'", "''") & " "
If Trim(username1) = "" Or Trim(bookno1) = "" Then
Command1.Enabled = False
Exit Sub
End If
'删除借书记录
sql = "select * from lendbook where username='" & username & "' and bookno='" & Trim(bookno1) & "'"
opendb sql, "3"
If rs.EOF Then
MsgBox "没有此书。", 64, "提示"
Else
rs.Delete
MsgBox "您借的《" & Trim(ListView1.SelectedItem.SubItems(3)) & "》已经还掉了。", 64, "提示"
End If
closedb
'库存加一
sql = "select * from book where bookno='" & Trim(bookno1) & "'"
opendb sql, "2"
If rs.EOF Then
MsgBox "没有此书。", 64, "提示"
Else
rs("stock") = Val(rs("stock")) + 1
rs.Update
End If
closedb
displendbook
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
Private Sub Form_Load()
Dim sql As String
Dim i As Integer
Command1.Enabled = False
sql = "select username,name,money,class from person where username='" & username & "'"
opendb sql, ""
For i = 0 To rs.Fields.Count - 1
Text1(i).Text = rs(i).Value & " "
Text1(i).Locked = True
Next
closedb
ListView1.View = lvwReport
ListView1.ColumnHeaders.Add , , "借书证号"
ListView1.ColumnHeaders.Add , , "借书人姓名"
ListView1.ColumnHeaders.Add , , "图书编号"
ListView1.ColumnHeaders.Add , , "书名"
ListView1.ColumnHeaders.Add , , "价格"
ListView1.ColumnHeaders.Add , , "类别"
ListView1.ColumnHeaders.Add , , "出版社"
ListView1.ColumnHeaders.Add , , "借出日期"
ListView1.ColumnHeaders.Add , , "应还日期"
displendbook
End Sub
Private Sub displendbook()
Dim sql As String
Dim i As Integer
Dim n As Integer
ListView1.ListItems.Clear
sql = "select * from lendbook where username='" & username & "'"
opendb sql, ""
If rs.EOF Then
MsgBox "您没有借书！", 64, "提示"
closedb
Command1.Enabled = False
Exit Sub
Else
Command1.Enabled = True
n = rs.RecordCount
If n = 2 Then
Label2.ForeColor = &HFF&
Label2.Caption = "您已经借了" & Trim(Str(n)) & "本书了，您不以再借书了。"
Else
Label2.ForeColor = &H80000012
Label2.Caption = "您已经借了" & Trim(Str(n)) & "本书了，您还可以借" & Trim(Str(2 - n)) & "本书。"
End If
ListView1.ListItems.Clear
ListView1.GridLines = True
For j = 1 To rs.RecordCount '列出用户所借的书
ListView1.ListItems.Add , , rs.Fields("username") & vbNullString
With ListView1.ListItems(j)
.SubItems(1) = rs.Fields("name") & vbNullString
.SubItems(2) = rs.Fields("bookno") & vbNullString
.SubItems(3) = rs.Fields("booktitle") & vbNullString
.SubItems(4) = rs.Fields("price") & vbNullString
.SubItems(5) = rs.Fields("sort") & vbNullString
.SubItems(6) = rs.Fields("press") & vbNullString
.SubItems(7) = rs.Fields("lenddate") & vbNullString
.SubItems(8) = rs.Fields("backdate") & vbNullString
End With
'统计过期书名
If (Date - CDate(rs("backdate"))) > 0 Then
bookname = bookname & "《" & rs("booktitle") & "》,"
End If
rs.MoveNext
Next
closedb
If Right(bookname, 1) = "," Then
bookname = Mid(bookname, 1, InStrRev(bookname, ",") - 1)
End If
If Trim(bookname) <> "" And money > 0 Then
MsgBox "您的" & Trim(bookname) & "已经过期，请尽快还掉。您所要交的罚金是：" & Trim(Str(money)) & "元", 64, "提示"
ElseIf Trim(bookname) <> "" Then
MsgBox "您的" & Trim(bookname) & "已经过期，请尽快还掉", 64, "提示"
ElseIf money > 0 Then
MsgBox "您要交的罚金：" & Trim(Str(money)) & "元", 64, "提示"
End If
End If
End Sub
Private Sub ListView1_Click()
'Command1.Enabled = True
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -