📄 销售分析.frm
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Begin VB.Form XSFX
Caption = "销售分析"
ClientHeight = 6330
ClientLeft = 60
ClientTop = 345
ClientWidth = 7950
LinkTopic = "Form1"
ScaleHeight = 6330
ScaleWidth = 7950
StartUpPosition = 3 'Windows Default
Begin VB.Frame Frame1
Height = 975
Left = 0
TabIndex = 1
Top = 5280
Width = 7935
Begin MSAdodcLib.Adodc Adodc2
Height = 330
Left = 6240
Top = 360
Width = 1575
_ExtentX = 2778
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 1
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "select GROUPNAME as 大类名称,sum(FEEORG) as 合计金额 ,sum(FEECOST) as 成本合计 from allorder group by GROUPNAME"
Caption = "Adodc2"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSAdodcLib.Adodc Adodc1
Height = 330
Left = 120
Top = 360
Width = 1455
_ExtentX = 2566
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.CommandButton Command4
Caption = "退出"
Height = 495
Left = 5040
TabIndex = 5
Top = 240
Width = 1095
End
Begin VB.CommandButton Command3
Caption = "小票"
Height = 495
Left = 3960
TabIndex = 4
Top = 240
Width = 1095
End
Begin VB.CommandButton Command2
Caption = "打印"
Height = 495
Left = 2880
TabIndex = 3
Top = 240
Width = 1095
End
Begin VB.CommandButton Command1
Caption = "查询"
Height = 495
Left = 1800
TabIndex = 2
Top = 240
Width = 1095
End
End
Begin TabDlg.SSTab SSTab1
Height = 5175
Left = 0
TabIndex = 0
Top = 120
Width = 7935
_ExtentX = 13996
_ExtentY = 9128
_Version = 393216
Style = 1
Tabs = 2
TabsPerRow = 2
TabHeight = 520
BackColor = -2147483635
ForeColor = 16711680
TabCaption(0) = "部门分析"
TabPicture(0) = "销售分析.frx":0000
Tab(0).ControlEnabled= -1 'True
Tab(0).Control(0)= "Label3"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).Control(1)= "Label4"
Tab(0).Control(1).Enabled= 0 'False
Tab(0).Control(2)= "DataGrid2"
Tab(0).Control(2).Enabled= 0 'False
Tab(0).Control(3)= "DataGrid1"
Tab(0).Control(3).Enabled= 0 'False
Tab(0).Control(4)= "Frame2"
Tab(0).Control(4).Enabled= 0 'False
Tab(0).Control(5)= "Frame3"
Tab(0).Control(5).Enabled= 0 'False
Tab(0).Control(6)= "Frame4"
Tab(0).Control(6).Enabled= 0 'False
Tab(0).ControlCount= 7
TabCaption(1) = "班次分析"
TabPicture(1) = "销售分析.frx":001C
Tab(1).ControlEnabled= 0 'False
Tab(1).Control(0)= "Label21"
Tab(1).Control(1)= "Label22"
Tab(1).Control(2)= "DataGrid4"
Tab(1).Control(3)= "DataGrid3"
Tab(1).Control(4)= "Frame5"
Tab(1).Control(5)= "Frame6"
Tab(1).Control(6)= "Frame7"
Tab(1).ControlCount= 7
Begin VB.Frame Frame7
Caption = "总营业‘额"
Height = 2175
Left = -70560
TabIndex = 51
Top = 2880
Width = 3375
Begin VB.Label Label36
AutoSize = -1 'True
Caption = "总毛利率："
Height = 195
Left = 1680
TabIndex = 57
Top = 1680
Width = 900
End
Begin VB.Label Label35
AutoSize = -1 'True
Caption = "提成金额："
Height = 195
Left = 1680
TabIndex = 56
Top = 960
Width = 900
End
Begin VB.Label Label34
AutoSize = -1 'True
Caption = "收税金额："
Height = 195
Left = 1680
TabIndex = 55
Top = 360
Width = 900
End
Begin VB.Label Label33
AutoSize = -1 'True
Caption = "酒菜成本："
Height = 195
Left = 120
TabIndex = 54
Top = 1680
Width = 900
End
Begin VB.Label Label32
AutoSize = -1 'True
Caption = "实收金额："
Height = 195
Left = 120
TabIndex = 53
Top = 960
Width = 900
End
Begin VB.Label Label31
AutoSize = -1 'True
Caption = "应收金额："
Height = 195
Left = 120
TabIndex = 52
Top = 360
Width = 900
End
End
Begin VB.Frame Frame6
Caption = "营业分析"
Height = 2175
Left = -74880
TabIndex = 42
Top = 2880
Width = 4215
Begin VB.Label Label30
AutoSize = -1 'True
Caption = "折扣："
Height = 195
Left = 2340
TabIndex = 50
Top = 1800
Width = 540
End
Begin VB.Label Label29
AutoSize = -1 'True
Caption = "房间费："
Height = 195
Left = 2160
TabIndex = 49
Top = 1320
Width = 720
End
Begin VB.Label Label28
AutoSize = -1 'True
Caption = "特殊消费："
Height = 195
Left = 1980
TabIndex = 48
Top = 840
Width = 900
End
Begin VB.Label Label27
AutoSize = -1 'True
Caption = "人数："
Height = 195
Left = 2340
TabIndex = 47
Top = 360
Width = 540
End
Begin VB.Label Label26
AutoSize = -1 'True
Caption = "服务费："
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -