📄 每天收入统计.frm
字号:
VERSION 5.00
Begin VB.Form frmday
BackColor = &H00C0E0FF&
Caption = "当天财务统计"
ClientHeight = 4980
ClientLeft = 3225
ClientTop = 2235
ClientWidth = 5535
LinkTopic = "Form2"
MaxButton = 0 'False
ScaleHeight = 4980
ScaleWidth = 5535
Begin VB.Frame Frame2
BackColor = &H00C0E0FF&
Caption = "其中"
Height = 1935
Left = 120
TabIndex = 14
Top = 2880
Width = 5295
Begin VB.Label Label17
Caption = "0"
BeginProperty Font
Name = "隶书"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 375
Left = 3960
TabIndex = 22
Top = 1080
Width = 1095
End
Begin VB.Label Label16
BackColor = &H00C0E0FF&
Caption = "冲值总额："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 2760
TabIndex = 21
Top = 1080
Width = 1095
End
Begin VB.Label Label15
Caption = "0"
BeginProperty Font
Name = "隶书"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 375
Left = 3960
TabIndex = 20
Top = 360
Width = 1095
End
Begin VB.Label Label14
BackColor = &H00C0E0FF&
Caption = "充值次数："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 2760
TabIndex = 19
Top = 360
Width = 1095
End
Begin VB.Label Label13
Caption = "0"
BeginProperty Font
Name = "隶书"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 375
Left = 1440
TabIndex = 18
Top = 1080
Width = 1095
End
Begin VB.Label Label12
BackColor = &H00C0E0FF&
Caption = "发卡张数："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 240
TabIndex = 17
Top = 1080
Width = 1095
End
Begin VB.Label Label11
Caption = "0"
BeginProperty Font
Name = "隶书"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 375
Left = 1440
TabIndex = 16
Top = 360
Width = 1095
End
Begin VB.Label Label10
BackColor = &H00C0E0FF&
Caption = "卡结金额："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 240
TabIndex = 15
Top = 360
Width = 1095
End
End
Begin VB.Frame Frame1
BackColor = &H00C0E0FF&
Caption = "时间"
Height = 1335
Left = 120
TabIndex = 3
Top = 240
Width = 5295
Begin VB.ComboBox Combo3
Height = 300
ItemData = "每天收入统计.frx":0000
Left = 3360
List = "每天收入统计.frx":0061
TabIndex = 13
Top = 360
Width = 855
End
Begin VB.ComboBox Combo2
Height = 300
ItemData = "每天收入统计.frx":00D8
Left = 2040
List = "每天收入统计.frx":0100
TabIndex = 12
Top = 360
Width = 855
End
Begin VB.ComboBox Combo1
Height = 300
ItemData = "每天收入统计.frx":012B
Left = 480
List = "每天收入统计.frx":0141
TabIndex = 11
Text = "03"
Top = 360
Width = 975
End
Begin VB.CommandButton Command1
BackColor = &H00C0E0FF&
Caption = "统 计(&S)"
Height = 375
Left = 3240
Style = 1 'Graphical
TabIndex = 10
Top = 840
Width = 1695
End
Begin VB.Label Label9
BackColor = &H00C0E0FF&
Caption = "日"
Height = 255
Left = 4320
TabIndex = 9
Top = 360
Width = 255
End
Begin VB.Label Label8
BackColor = &H00C0E0FF&
Caption = "月"
Height = 255
Left = 3000
TabIndex = 8
Top = 360
Width = 255
End
Begin VB.Label Label7
BackColor = &H00C0E0FF&
Caption = "年"
Height = 255
Left = 1560
TabIndex = 7
Top = 360
Width = 255
End
End
Begin VB.Line Line2
BorderColor = &H000000FF&
X1 = 5160
X2 = 360
Y1 = 2760
Y2 = 2760
End
Begin VB.Line Line1
BorderColor = &H000000FF&
X1 = 360
X2 = 5160
Y1 = 2160
Y2 = 2160
End
Begin VB.Label Label6
BackColor = &H00C0E0FF&
Caption = "元钱（RMB）"
BeginProperty Font
Name = "隶书"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 3480
TabIndex = 6
Top = 2280
Width = 1935
End
Begin VB.Label Label5
BackColor = &H00C0E0FF&
BeginProperty Font
Name = "隶书"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 375
Left = 2040
TabIndex = 5
Top = 2280
Width = 1215
End
Begin VB.Label Label4
BackColor = &H00C0E0FF&
Caption = "一共消费了"
BeginProperty Font
Name = "隶书"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 495
Left = 360
TabIndex = 4
Top = 2280
Width = 1695
End
Begin VB.Label Label3
BackColor = &H00C0E0FF&
Caption = "位顾客光临"
BeginProperty Font
Name = "隶书"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 3360
TabIndex = 2
Top = 1680
Width = 1695
End
Begin VB.Label Label2
BackColor = &H00C0E0FF&
BeginProperty Font
Name = "隶书"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 375
Left = 2040
TabIndex = 1
Top = 1680
Width = 1215
End
Begin VB.Label Label1
BackColor = &H00C0E0FF&
Caption = "今天一共有"
BeginProperty Font
Name = "隶书"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 360
TabIndex = 0
Top = 1680
Width = 1695
End
End
Attribute VB_Name = "frmday"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub Command1_Click()
Dim rens As Integer
Dim jine As Integer
Dim Y As String
Dim m As Integer
m = 0
Dim d As Double
d = 0
Y = Combo1.Text + "-" + Combo2.Text + "-" + Combo3.Text
'查消费的人数和消费总额
Dim lidicnn As New ADODB.Connection
Dim lidirs As New ADODB.Recordset
lidicnn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = 数据库.mdb;"
lidirs.Open "select 实收金额 from 客户表 " + "where 离场时间 like" + "'" + Y + "'", lidicnn
Do Until lidirs.EOF
m = m + 1
d = d + lidirs.Fields(0).Value
lidirs.MoveNext
Loop
lidirs.Close
lidicnn.Close
Label2.Caption = m
Label5.Caption = d
'统计卡结金额
'where 衣柜号=" + "'" + hao + "'" + "and 是否结算=" + "'" + bu + "'", lidicnn
Dim gbka As String
gbka = "贵宾卡支付"
Dim kajie As Integer
kajie = 0
lidicnn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = 数据库.mdb;"
lidirs.Open "select 实收金额 from 客户表 " + "where 离场时间 like" + "'" + Y + "'" + "and 结算方式=" + "'" + gbka + "'", lidicnn
Do Until lidirs.EOF
kajie = kajie + lidirs.Fields(0).Value
lidirs.MoveNext
Loop
Label11.Caption = kajie
lidirs.Close
lidicnn.Close
'统计发卡张数
Dim faka As Integer
faka = 0
lidicnn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = 信息库.mdb;"
lidirs.Open "select * from 卡表 " + "where 发卡时间 like" + "'" + Y + "'", lidicnn
Do Until lidirs.EOF
faka = faka + 1
lidirs.MoveNext
Loop
Label13.Caption = faka
lidirs.Close
lidicnn.Close
'统计充值次数
'统计充值金额
Dim czc As Integer
Dim czj As Integer
czj = 0
czc = 0
lidicnn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = 信息库.mdb;"
lidirs.Open "select 充值金额 from 充值表 " + "where 充值时间 like" + "'" + Y + "'", lidicnn
Do Until lidirs.EOF
czc = czc + 1
czj = czj + lidirs.Fields(0).Value
lidirs.MoveNext
Loop
Label15.Caption = czc
Label17.Caption = czj
lidirs.Close
lidicnn.Close
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -