📄 frmbookfine_choose.frm
字号:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form frmbookfine_choose
BorderStyle = 1 'Fixed Single
Caption = "读者未交款的过期图书列表"
ClientHeight = 6165
ClientLeft = 45
ClientTop = 435
ClientWidth = 8400
Icon = "frmbookfine_choose.frx":0000
LinkTopic = "Form2"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 6165
ScaleWidth = 8400
StartUpPosition = 2 '屏幕中心
Begin VB.TextBox txt图书名称
Height = 390
Left = 4560
TabIndex = 1
Top = 480
Width = 2175
End
Begin VB.TextBox txt图书编号
Height = 390
Left = 1200
TabIndex = 0
Top = 480
Width = 2175
End
Begin VB.CommandButton cmdexit
Cancel = -1 'True
Caption = "返 回"
Height = 495
Left = 7080
TabIndex = 4
Top = 5400
Width = 1215
End
Begin VB.CommandButton cmdchoose
Caption = "选 择"
Default = -1 'True
Height = 495
Left = 7080
TabIndex = 3
Top = 4680
Width = 1215
End
Begin MSFlexGridLib.MSFlexGrid bookfineGrid
Height = 4815
Left = 120
TabIndex = 2
Top = 1200
Width = 6855
_ExtentX = 12091
_ExtentY = 8493
_Version = 393216
Rows = 1
Cols = 8
FixedCols = 0
BackColor = -2147483639
BackColorBkg = 14737632
GridColor = 14737632
GridColorFixed = 14737632
SelectionMode = 1
AllowUserResizing= 1
End
Begin VB.PictureBox Picbg1
Appearance = 0 'Flat
AutoRedraw = -1 'True
AutoSize = -1 'True
BackColor = &H80000005&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 1440
Left = 7440
Picture = "frmbookfine_choose.frx":19862
ScaleHeight = 1440
ScaleWidth = 1440
TabIndex = 5
Top = 240
Width = 1440
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "图书名称："
Height = 180
Left = 3600
TabIndex = 7
Top = 585
Width = 900
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "图书编号："
Height = 180
Left = 240
TabIndex = 6
Top = 585
Width = 900
End
End
Attribute VB_Name = "frmbookfine_choose"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'-------------------------------------------------------
' 作者：邹雪桃
' 功能： 列出要罚款的图书，可以模糊查询，
' 把相应信息返回主框
'-------------------------------------------------------
Public Function bookfineChoose_update(sql As String)
Dim rs As New ADODB.Recordset
'sql = "select * from hsxxb where 是否交款 = '是' and 读者编号 = '" & frmoverduefine.txt读者编号.Text & "'" '在<还书信息表hsxxb>找出读者未交款的信息
Set rs = TransactSQL(sql)
With bookfineGrid
.Rows = 1
While Not rs.EOF
'把未交款的读者信息添加到当前readerfineGrid中
bookfineGrid.AddItem rs(0) & vbTab & rs(1) & vbTab & rs(4) & vbTab & rs(5) & vbTab & rs(6) & vbTab & rs(7) & vbTab & rs(8) & vbTab & rs(9)
rs.MoveNext
Wend
End With
rs.Close
End Function
Private Sub cmdchoose_Click()
With bookfineGrid
If .TextMatrix(.Row, 0) = "" Then
MsgBox "请在当前表中选择一条图书信息。", vbInformation + vbOKOnly, "信息"
Else
frmoverduefine.lst图书.AddItem "图书编号：" & vbTab & .TextMatrix(.Row, 0), 0
frmoverduefine.lst图书.AddItem "图书名称：" & vbTab & .TextMatrix(.Row, 1), 1
frmoverduefine.lst图书.AddItem "借阅数量：" & vbTab & .TextMatrix(.Row, 2), 2
frmoverduefine.lst图书.AddItem "借阅日期：" & vbTab & .TextMatrix(.Row, 3), 3
frmoverduefine.lst图书.AddItem "应还日期：" & vbTab & .TextMatrix(.Row, 4), 4
frmoverduefine.lst图书.AddItem "实还日期：" & vbTab & .TextMatrix(.Row, 5), 5
frmoverduefine.lst图书.AddItem "过期天数：" & vbTab & .TextMatrix(.Row, 6), 6
frmoverduefine.lst图书.AddItem "超期罚金：" & vbTab & Format(Val(.TextMatrix(.Row, 7)), "0.00"), 7
frmoverduefine.cmdadd.Enabled = True
Unload Me
End If
End With
End Sub
Private Sub cmdexit_Click()
frmoverduefine.lst图书.Rows = 1 '清除lst图书的数据
frmoverduefine.cmdadd = False
Unload Me
End Sub
Private Sub Form_Load()
Call fullpic(Me, Picbg1) '背景图
With bookfineGrid
.TextMatrix(0, 0) = "图书编号"
.TextMatrix(0, 1) = "图书名称"
.TextMatrix(0, 2) = "借阅数量"
.TextMatrix(0, 3) = "借阅日期"
.TextMatrix(0, 4) = "应还日期"
.TextMatrix(0, 5) = "实还日期"
.TextMatrix(0, 6) = "过期天数"
.TextMatrix(0, 7) = "超期罚金"
.ColWidth(1) = 2200
.ColWidth(3) = 1262
.ColWidth(4) = 1262
.ColWidth(5) = 1262
End With
Dim sql As String
sql = "select * from hsxxb where 是否交款 = '是' and 读者编号 = '" & frmoverduefine.txt读者编号.Text & "'" '在<还书信息表hsxxb>找出读者未交款的信息
Call bookfineChoose_update(sql) '把读者过期欠款的书的信息显示在当前bookfineGrid表中
End Sub
Private Sub txt图书编号_Change()
Dim sql As String
If txt图书编号.Text = "" And txt图书名称.Text = "" Then
'Call bookfineChoose_update '把欠款的读者信息显示在当前readerfineGrid表中
sql = "select * from hsxxb where 是否交款 = '是' and 读者编号 = '" & frmoverduefine.txt读者编号.Text & "'" '在<还书信息表hsxxb>找出读者未交款的图书信息
Else
sql = "select * from hsxxb where 图书编号 like '" & Trim(txt图书编号.Text) & "%' and 是否交款 = '是' and 读者编号 = '" & frmoverduefine.txt读者编号.Text & "'" '在<还书信息表hsxxb>按条件找出读者未交款的图书信息
' Dim rs As New ADODB.Recordset
' Dim sql As String
'
' sql = "select * from hsxxb where 是否交款 = '是' and 读者编号 = '" & frmoverduefine.txt读者编号.Text & "'" '在<还书信息表hsxxb>找出读者未交款的信息
' Set rs = TransactSQL(sql)
' With bookfineGrid
' .Rows = 1
' While Not rs.EOF
' '把过期未交款的读者的图书信息添加到当前bookfineGrid中
' If Left(rs(0), Len(Trim(txt图书编号.Text))) = Trim(txt图书编号.Text) Then
' bookfineGrid.AddItem rs(0) & vbTab & rs(1) & vbTab & rs(4) & vbTab & rs(5) & vbTab & rs(6) & vbTab & rs(7) & vbTab & rs(8) & vbTab & rs(9)
' End If
' rs.MoveNext
' Wend
' End With
' rs.Close
End If
Call bookfineChoose_update(sql) '把欠款的读者的图信息显示在当前readerfineGrid表中
End Sub
Private Sub txt图书名称_Change()
Dim sql As String
If txt图书编号.Text = "" And txt图书名称.Text = "" Then
'Call bookfineChoose_update '把欠款的读者信息显示在当前readerfineGrid表中
sql = "select * from hsxxb where 是否交款 = '是' and 读者编号 = '" & frmoverduefine.txt读者编号.Text & "'" '在<还书信息表hsxxb>找出读者未交款的信息
Else
sql = "select * from hsxxb where 图书名称 like '" & Trim(txt图书名称.Text) & "%' and 是否交款 = '是' and 读者编号 = '" & frmoverduefine.txt读者编号.Text & "'" '在<还书信息表hsxxb>按条件找出读者未交款的图书信息
' Dim rs, rs2 As New ADODB.Recordset
' Dim sql As String
'
' sql = "select * from hsxxb where 是否交款 = '是' and 读者编号 = '" & frmoverduefine.txt读者编号.Text & "'" '在<还书信息表hsxxb>找出读者未交款的信息
' Set rs = TransactSQL(sql)
' With bookfineGrid
' .Rows = 1
' While Not rs.EOF
' '把过期未交款的读者的图书信息添加到当前bookfineGrid中
' If Left(rs(1), Len(Trim(txt图书名称.Text))) = Trim(txt图书名称.Text) Then
' bookfineGrid.AddItem rs(0) & vbTab & rs(1) & vbTab & rs(4) & vbTab & rs(5) & vbTab & rs(6) & vbTab & rs(7) & vbTab & rs(8) & vbTab & rs(9)
' End If
' rs.MoveNext
' Wend
' End With
' rs.Close
End If
Call bookfineChoose_update(sql) '把欠款的读者的图信息显示在当前readerfineGrid表中
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -