📄
字号:
BeginProperty HeadFont {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
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
ColumnCount = 2
BeginProperty Column00
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
EndProperty
BeginProperty Column01
EndProperty
EndProperty
End
Begin VB.Label Label9
AutoSize = -1 'True
Caption = "提成"
Height = 195
Left = -68400
TabIndex = 65
Top = 3720
Width = 360
End
Begin VB.Label Label8
Caption = "酒菜大类"
Height = 375
Left = -73440
TabIndex = 64
Top = 960
Width = 1335
End
Begin VB.Label Label6
Caption = "出品类型"
Height = 375
Left = 1560
TabIndex = 63
Top = 840
Width = 1215
End
Begin VB.Label Label31
AutoSize = -1 'True
Caption = "出品类型"
Height = 195
Left = -69360
TabIndex = 57
Top = 4200
Width = 720
End
Begin VB.Label Label30
AutoSize = -1 'True
Caption = "%"
Height = 195
Left = -69960
TabIndex = 56
Top = 4200
Width = 120
End
Begin VB.Label Label29
AutoSize = -1 'True
Caption = "默认成本率"
Height = 195
Left = -71880
TabIndex = 54
Top = 4200
Width = 900
End
Begin VB.Label Label28
AutoSize = -1 'True
Caption = "名称"
Height = 195
Left = -70440
TabIndex = 51
Top = 3120
Width = 360
End
Begin VB.Label Label27
AutoSize = -1 'True
Caption = "编号"
Height = 195
Left = -71880
TabIndex = 50
Top = 3120
Width = 360
End
Begin VB.Label Label26
Caption = "酒菜项目"
Height = 255
Left = -71880
TabIndex = 49
Top = 480
Width = 855
End
Begin VB.Label Label25
Caption = "酒菜大类"
Height = 255
Left = -74760
TabIndex = 47
Top = 480
Width = 1335
End
Begin VB.Label Label24
AutoSize = -1 'True
Caption = "类型"
Height = 195
Left = -68520
TabIndex = 44
Top = 3720
Width = 360
End
Begin VB.Label Label23
AutoSize = -1 'True
Caption = "价格"
Height = 195
Left = -71640
TabIndex = 38
Top = 3720
Width = 360
End
Begin VB.Label Label22
AutoSize = -1 'True
Caption = "单位"
Height = 195
Left = -71640
TabIndex = 37
Top = 4200
Width = 360
End
Begin VB.Label Label5
AutoSize = -1 'True
Caption = "名称"
Height = 195
Left = -70200
TabIndex = 36
Top = 3240
Width = 360
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "成本"
Height = 195
Left = -70200
TabIndex = 35
Top = 3720
Width = 360
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "编号"
Height = 195
Left = -71640
TabIndex = 34
Top = 3240
Width = 360
End
Begin VB.Label Label21
Caption = "酒菜类别"
Height = 255
Left = -74880
TabIndex = 33
Top = 2760
Width = 1335
End
Begin VB.Label Label1
Caption = "酒菜大类"
Height = 255
Left = -74880
TabIndex = 32
Top = 600
Width = 1335
End
Begin VB.Label Label20
AutoSize = -1 'True
Caption = "价格"
Height = 195
Left = -71400
TabIndex = 22
Top = 3720
Width = 360
End
Begin VB.Label Label19
AutoSize = -1 'True
Caption = "单位"
Height = 195
Left = -71400
TabIndex = 21
Top = 4200
Width = 360
End
Begin VB.Label Label18
AutoSize = -1 'True
Caption = "快捷方式"
Height = 195
Left = -69960
TabIndex = 20
Top = 4200
Width = 720
End
Begin VB.Label Label17
AutoSize = -1 'True
Caption = "名称"
Height = 195
Left = -69960
TabIndex = 19
Top = 3240
Width = 360
End
Begin VB.Label Label16
AutoSize = -1 'True
Caption = "提成"
Height = 195
Left = -69960
TabIndex = 18
Top = 3720
Width = 360
End
Begin VB.Label Label15
AutoSize = -1 'True
Caption = "编号"
Height = 195
Left = -71400
TabIndex = 17
Top = 3240
Width = 360
End
Begin VB.Label Label14
Caption = "酒菜设置"
Height = 255
Left = -71520
TabIndex = 16
Top = 600
Width = 1335
End
Begin VB.Label Label13
Caption = "酒菜类别"
Height = 255
Left = -74760
TabIndex = 14
Top = 2760
Width = 1335
End
Begin VB.Label Label12
Caption = "酒菜大类"
Height = 255
Left = -74760
TabIndex = 13
Top = 600
Width = 1335
End
Begin VB.Label Label7
Caption = "注意："
Height = 255
Left = -72360
TabIndex = 11
Top = 4200
Width = 615
End
Begin VB.Label Label2
Caption = "酒菜项目"
Height = 255
Left = -71760
TabIndex = 9
Top = 600
Width = 855
End
End
End
Attribute VB_Name = "JCSZ"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub TabStrip1_Click()
End Sub
Private Sub Label11_Click()
End Sub
Private Sub Command1_Click()
Adodc3.Recordset.AddNew
End Sub
Private Sub Command2_Click()
Adodc3.Recordset.Delete
End Sub
Private Sub Command3_Click()
Adodc3.Recordset.UpdateBatch
End Sub
Private Sub Command4_Click()
Adodc3.Recordset.Cancel
End Sub
Private Sub Command5_Click()
Unload Me
End Sub
Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
On Error Resume Next
Adodc2.RecordSource = "select TYPENO as 编号,TYPENAME as 类别名称 from ddtype where GROUPNO='" & Adodc1.Recordset.Fields(0).Value & "'"
Adodc2.Refresh
Adodc2.Recordset.MoveFirst
DataGrid6_RowColChange 1, 1
' tempsql = "select DDNO as 编号,DDNAME as 酒菜名称,DDUNIT as 单位, "
' tempsql = tempsql + "PRICE as 价格,PRICEVAR as 时价,COST as 成本,PRICE2 as 提成,SELCODE as 快捷方式 from "
' tempsql = tempsql + "dd where TYPENO='" & Adodc2.Recordset(0).Value & "'"
'
' Adodc3.RecordSource = tempsql
' Adodc3.Refresh
Adodc3.Refresh
End Sub
Private Sub DataGrid6_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
Dim tempSql As String
tempSql = "select DDNO as 编号,DDNAME as 酒菜名称,DDUNIT as 单位, "
tempSql = tempSql + "PRICE as 价格,PRICEVAR as 时价,COST as 成本,PRICE2 as 提成,SELCODE as 快捷方式 from "
tempSql = tempSql + "dd where TYPENO='" & Adodc2.Recordset(0).Value & "'"
Adodc3.RecordSource = tempSql
Adodc3.Refresh
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -