📄 frmgroupfind.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form FrmGroupFind
BorderStyle = 3 'Fixed Dialog
Caption = "集体充值查询（学员卡）"
ClientHeight = 6525
ClientLeft = 45
ClientTop = 330
ClientWidth = 7005
Icon = "FrmGroupFind.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 6525
ScaleWidth = 7005
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.Frame fraFind
Caption = "查询学员卡充值信息"
Height = 2295
Left = 360
TabIndex = 0
Top = 240
Width = 6255
Begin VB.ComboBox cboType
Height = 300
Left = 1680
Style = 2 'Dropdown List
TabIndex = 16
Top = 1320
Width = 1335
End
Begin VB.ComboBox cboGroup
Height = 300
ItemData = "FrmGroupFind.frx":000C
Left = 4200
List = "FrmGroupFind.frx":0028
Style = 2 'Dropdown List
TabIndex = 15
Top = 1300
Width = 1335
End
Begin VB.ComboBox cboSort
Height = 300
ItemData = "FrmGroupFind.frx":006C
Left = 1680
List = "FrmGroupFind.frx":0076
Style = 2 'Dropdown List
TabIndex = 13
Top = 360
Width = 1335
End
Begin VB.ComboBox cboUser
Height = 300
Left = 1680
Style = 2 'Dropdown List
TabIndex = 4
Top = 1300
Width = 1335
End
Begin VB.ComboBox cboFindType
Height = 300
ItemData = "FrmGroupFind.frx":0090
Left = 1680
List = "FrmGroupFind.frx":009A
Style = 2 'Dropdown List
TabIndex = 3
Top = 840
Width = 1335
End
Begin VB.CommandButton cmdfFind
Caption = "查 询"
Default = -1 'True
Height = 375
Left = 4080
TabIndex = 2
Top = 360
Width = 1215
End
Begin VB.CommandButton cmdPrint
Caption = "打印预览"
Height = 375
Left = 4080
TabIndex = 1
Top = 840
Width = 1215
End
Begin MSComCtl2.DTPicker DTPTo
Height = 300
Left = 4200
TabIndex = 5
Top = 1800
Width = 1335
_ExtentX = 2355
_ExtentY = 529
_Version = 393216
Format = 24641537
CurrentDate = 38057
End
Begin MSComCtl2.DTPicker DTPFrom
Height = 300
Left = 1680
TabIndex = 6
Top = 1800
Width = 1335
_ExtentX = 2355
_ExtentY = 529
_Version = 393216
Format = 24641537
CurrentDate = 38057
End
Begin VB.Label lblSORTYY
AutoSize = -1 'True
Caption = "学员卡类别："
Height = 180
Left = 600
TabIndex = 18
Top = 1365
Width = 1080
End
Begin VB.Label lblGroup
AutoSize = -1 'True
Caption = "批次："
Height = 180
Left = 3600
TabIndex = 17
Top = 1365
Width = 540
End
Begin VB.Label lblSort
AutoSize = -1 'True
Caption = "查询内容："
Height = 180
Left = 600
TabIndex = 14
Top = 420
Width = 900
End
Begin VB.Label lbluser
AutoSize = -1 'True
Caption = "用户："
Height = 180
Left = 600
TabIndex = 10
Top = 1365
Width = 540
End
Begin VB.Label lblType
AutoSize = -1 'True
Caption = "查询方式："
Height = 180
Left = 600
TabIndex = 9
Top = 900
Width = 900
End
Begin VB.Label lblFrom
AutoSize = -1 'True
Caption = "从："
Height = 180
Left = 600
TabIndex = 8
Top = 1860
Width = 360
End
Begin VB.Label lblTo
AutoSize = -1 'True
Caption = "到："
Height = 180
Left = 3600
TabIndex = 7
Top = 1860
Width = 360
End
End
Begin MSComctlLib.ListView lvwGroup
Height = 3495
Left = 360
TabIndex = 11
Top = 2880
Width = 6255
_ExtentX = 11033
_ExtentY = 6165
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
NumItems = 0
End
Begin VB.Label lblList
AutoSize = -1 'True
Caption = "全部充值信息："
Height = 180
Left = 360
TabIndex = 12
Top = 2640
Width = 1260
End
End
Attribute VB_Name = "FrmGroupFind"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public rsGroup As Recordset
Private Sub cboSort_Click()
If cboSort.Text = "按学员卡查" Then
lbluser.Visible = False
cboUser.Visible = False
cboUser.ListIndex = -1
lblSORTYY.Visible = True
cboType.Visible = True
lblGroup.Visible = True
cboGroup.Visible = True
ElseIf cboSort.Text = "按用户查" Then
lblSORTYY.Visible = False
cboType.Visible = False
cboType.ListIndex = -1
lblGroup.Visible = False
cboGroup.Visible = False
cboGroup.ListIndex = -1
lbluser.Visible = True
cboUser.Visible = True
End If
End Sub
Private Sub cmdfFind_Click()
lblList.Caption = "查询结果："
Set rsGroup = New Recordset
Dim strCondition As String
strCondition = "select * from TbGroup,tbuser" & where & " and TbGroup.u_id=tbuser.u_id"
rsGroup.Open strCondition, Modmain.conn, 3, 2
LoadDate
End Sub
Private Sub Form_Load()
'************************************************给用户列表框赋值******************
Set rsUser = New Recordset
rsUser.Open "select * from TbUser", Modmain.conn, 3, 2
While Not rsUser.EOF
cboUser.AddItem (rsUser.Fields!u_name)
rsUser.MoveNext
Wend
cboUser.AddItem ""
rsUser.Close
Set rsUser = Nothing
'*************************************************给学员卡类别列表框赋值*************
cboType.AddItem "计算机培训"
cboType.AddItem "网络培训"
cboType.AddItem ""
'**************************************************配置lvwGroup控件*******************
lvwGroup.ColumnHeaders.Add , , "编号", 0
lvwGroup.ColumnHeaders.Add , , "类别名", lvwGroup.Width / 5
lvwGroup.ColumnHeaders.Add , , "批次", lvwGroup.Width / 8
lvwGroup.ColumnHeaders.Add , , "日期", lvwGroup.Width / 6
lvwGroup.ColumnHeaders.Add , , "金额", lvwGroup.Width / 10
lvwGroup.ColumnHeaders.Add , , "用户名", lvwGroup.Width / 8
lvwGroup.ColumnHeaders.Add , , "充值描述", lvwGroup.Width / 4 + 1800
lvwGroup.GridLines = True
lvwGroup.Sorted = True
lvwGroup.View = lvwReport
'***********************************************给lvwGroup控件赋值*********************
Set rsGroup = New Recordset
rsGroup.Open "select * from tbGroup,tbuser where tbGroup.U_ID=tbuser.u_id", Modmain.conn, 3, 2
LoadDate
End Sub
Private Sub cboFindType_Click()
If cboFindType.Text = "单日查询" Then
lblFrom.Caption = "查询日期："
lblTo.Visible = False
DTPTo.Visible = False
ElseIf cboFindType.Text = "时间段查询" Then
lblFrom.Caption = "从："
lblTo.Visible = True
DTPTo.Visible = True
End If
End Sub
Private Sub LoadDate()
lvwGroup.ListItems.Clear
While Not rsGroup.EOF ' 添加相应的 ListItem
Set lItem = lvwGroup.ListItems.Add
lItem.Text = rsGroup.Fields("ID")
lItem.SubItems(1) = rsGroup.Fields("ST_Name")
lItem.SubItems(2) = rsGroup.Fields("Group")
lItem.SubItems(3) = rsGroup.Fields!Date
lItem.SubItems(4) = rsGroup.Fields!Money
lItem.SubItems(5) = rsGroup.Fields!u_name
If rsGroup.Fields!Memo <> "" Then
lItem.SubItems(6) = rsGroup.Fields!Memo
End If
rsGroup.MoveNext
Wend
End Sub
Private Function where() As String '查询条件
Dim s As String
If cboGroup.Text <> "" Then
If s <> "" Then
s = s & " and TbGroup.group like '" & cboGroup.Text & "'"
Else
s = " where TbGroup.group like '" & cboGroup.Text & "'"
End If
End If
If cboType.Text <> "" Then
If s <> "" Then
s = s & " and ST_Name like '" & cboType.Text & "'"
Else
s = " where ST_Name like '" & cboType.Text & "'"
End If
End If
If DTPTo.Visible = False Then
If s <> "" Then
s = s & "and Date like '" & DTPFrom.Value & "'"
Else
s = " where Date like '" & DTPFrom.Value & "'"
End If
Else
Dim dtFrom As String
Dim dtTo As String
'''''''''''''''''手工转换日期格式使其与ACCESS数据库相对应''''''''''''''''''''''''
dtFrom = Month(DTPFrom.Value) & "/" & Day(DTPFrom.Value) & "/" & Year(DTPFrom.Value)
dtTo = Month(DTPTo.Value) & "/" & Day(DTPTo.Value) & "/" & Year(DTPTo.Value)
If s <> "" Then
s = s & "and Date>= #" & dtFrom & "# and Date<=#" & dtTo & "#"
Else
s = " where Date>=#" & dtFrom & "# and Date<=#" & dtTo & "#"
End If
End If
If cboUser.Text <> "" Then
Set rsUser = New Recordset
rsUser.Open "select * from TbUser Where U_Name like '" & cboUser.Text & "'", Modmain.conn, 3, 2
If s <> "" Then
s = s & " and tbuser.U_ID like '" & rsUser.Fields!u_id & "'"
Else
s = " where tbuser.U_ID like '" & rsUser.Fields!u_id & "'"
End If
End If
where = s
End Function
Private Sub cmdPrint_Click()
If rsGroup.RecordCount = 0 Then
MsgBox "没有可打印的信息！", vbOKOnly + vbExclamation, "机房管理"
Else
DRGroup.Show 1
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -