📄 frmcustomerform.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form frmCustomerForm
Caption = "客户上台"
ClientHeight = 6525
ClientLeft = 60
ClientTop = 345
ClientWidth = 11880
FillColor = &H80000008&
Icon = "frmCustomerForm.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MDIChild = -1 'True
ScaleHeight = 6525
ScaleWidth = 11880
WindowState = 2 'Maximized
Begin MSComctlLib.TabStrip Strip1
Height = 465
Left = 75
TabIndex = 11
Top = 1260
Width = 3720
_ExtentX = 6562
_ExtentY = 820
_Version = 393216
BeginProperty Tabs {1EFB6598-857C-11D1-B16A-00C0F0283628}
NumTabs = 1
BeginProperty Tab1 {1EFB659A-857C-11D1-B16A-00C0F0283628}
Caption = "所有列表"
Key = "ALL"
Object.ToolTipText = "显示所有单据"
ImageVarType = 2
EndProperty
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.Frame Frame2
ForeColor = &H00808000&
Height = 1305
Left = 90
TabIndex = 9
Top = -30
Width = 9930
Begin VB.CommandButton cmdCancel
Cancel = -1 'True
Caption = "关闭退出"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 420
Left = 8880
Picture = "frmCustomerForm.frx":030A
TabIndex = 7
ToolTipText = "Esc 退出"
Top = 300
Width = 1275
End
Begin VB.CommandButton cmdPast
BackColor = &H00C0C0C0&
Caption = "结帐"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 420
Left = 7620
Picture = "frmCustomerForm.frx":0835
TabIndex = 5
ToolTipText = "F5 结帐"
Top = 300
Width = 1275
End
Begin VB.CommandButton cmdChange
BackColor = &H00FFC0FF&
Caption = "换桌"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 420
Left = 6360
TabIndex = 4
ToolTipText = "换桌"
Top = 300
Width = 1275
End
Begin VB.CommandButton cmdCopy
BackColor = &H00C0FFC0&
Caption = "同桌"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 420
Left = 5100
TabIndex = 3
ToolTipText = "换桌"
Top = 300
Width = 1275
End
Begin VB.ComboBox cmbSite
BackColor = &H00FFFFC0&
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800000&
Height = 330
Left = 870
Sorted = -1 'True
TabIndex = 0
Top = 360
Width = 1695
End
Begin VB.CommandButton cmdClean
BackColor = &H00FFC0C0&
Caption = "清台"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 420
Left = 3840
Style = 1 'Graphical
TabIndex = 2
ToolTipText = "点菜"
Top = 300
Width = 1275
End
Begin VB.CommandButton cmdDC
BackColor = &H00C0C0C0&
Caption = "点菜"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 420
Left = 2580
Picture = "frmCustomerForm.frx":1FA1
TabIndex = 1
ToolTipText = "点菜"
Top = 300
Width = 1275
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "请选择或输入座位(餐桌)后，按【点菜】按钮点菜，下面显示该桌所点菜谱。"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00404040&
Height = 195
Index = 1
Left = 915
TabIndex = 13
Top = 870
Width = 6645
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "请选择或输入座位(餐桌)后，按【点菜】按钮点菜，下面显示该桌所点菜谱。"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 195
Index = 0
Left = 900
TabIndex = 12
Top = 885
Width = 6645
End
Begin VB.Image Image1
Height = 480
Left = 285
Picture = "frmCustomerForm.frx":370D
Top = 735
Width = 480
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "座位："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Index = 1
Left = 270
TabIndex = 10
Top = 420
Width = 630
End
End
Begin VB.Frame Frame1
Height = 5490
Left = 75
TabIndex = 8
Top = 1620
Width = 6555
Begin MSComctlLib.ListView lstPro
Height = 5265
Left = 60
TabIndex = 6
Top = 180
Width = 5415
_ExtentX = 9551
_ExtentY = 9287
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
AllowReorder = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 7
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "编号"
Object.Width = 1411
EndProperty
BeginProperty ColumnHeader(2) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 1
Text = "助记编码"
Object.Width = 2117
EndProperty
BeginProperty ColumnHeader(3) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 2
Text = "菜 名"
Object.Width = 2469
EndProperty
BeginProperty ColumnHeader(4) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Alignment = 1
SubItemIndex = 3
Text = "单价"
Object.Width = 1764
EndProperty
BeginProperty ColumnHeader(5) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Alignment = 1
SubItemIndex = 4
Text = "数量"
Object.Width = 1764
EndProperty
BeginProperty ColumnHeader(6) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Alignment = 2
SubItemIndex = 5
Text = "加工费"
Object.Width = 1764
EndProperty
BeginProperty ColumnHeader(7) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Alignment = 1
SubItemIndex = 6
Text = "金额"
Object.Width = 2469
EndProperty
End
End
End
Attribute VB_Name = "frmCustomerForm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim bDel As Boolean
Dim sCustType As String
Private Sub cmbSite_Click()
On Error Resume Next
sPubSite = Trim(cmbSite.Text)
If Trim(cmbSite.Text) <> "" Then
cmdChange.Enabled = True
cmdDC.Enabled = True
cmdCopy.Enabled = True
cmdPast.Enabled = True
cmdClean.Enabled = True
Else
cmdDC.Enabled = False
cmdCopy.Enabled = False
cmdChange.Enabled = False
cmdPast.Enabled = False
cmdClean.Enabled = False
End If
ConfigGrid '刷新点菜列表
End Sub
Private Sub cmbSite_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
cmdDC.Value = True
End If
End Sub
Private Sub cmbSite_LostFocus()
On Error GoTo CheckSite
If cmbSite.Text = "" Then Exit Sub
'检查是否存在的座位号
Dim EF As Recordset
Dim DB As Connection
Set DB = CreateObject("ADODB.Connection")
Set EF = CreateObject("ADODB.Recordset")
DB.Open Constr
'4为维修时，或者3结帐后不能点菜
EF.Open "Select * from SiteType Where Class='" & Trim(cmbSite.Text) & "' And SiteStatus<4", DB, adOpenStatic, adLockReadOnly, adCmdText
If EF.EOF And EF.BOF Then
EF.Close
DB.Close
MsgBox "没有找到该座位号或者『该桌正在维修中』,或者『已经结帐』。" & vbCrLf _
& "如果不记得座位编号,请点击右边按钮选择。 " & vbCrLf & vbCrLf & "否则出错了,可得你赔钱 ：-< 别怨我没有提醒。 ", vbExclamation, "飞鸿哥:Silong."
cmbSite.Text = ""
cmbSite.SetFocus
Exit Sub
End If
EF.Close
Set EF = Nothing
DB.Close
Set DB = Nothing
Exit Sub
CheckSite:
MsgBox "检查座位号出错：" & Err.Description, vbCritical
Exit Sub
End Sub
Private Sub cmdCancel_Click()
Unload Me
End Sub
Private Sub cmdClose_Click()
Unload Me
End Sub
Private Sub cmdOK_Click()
On Error GoTo Err_Save
' 保存选项======================================================
Unload Me
Exit Sub
Err_Save:
MsgBox "保存选项错误! " & vbCrLf & vbCrLf & Err.Description, vbCritical
End Sub
Private Sub Command1_Click()
Unload Me
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
Private Sub cmbSite_Change()
On Error Resume Next
sPubSite = Trim(cmbSite.Text)
If Trim(cmbSite.Text) <> "" Then
cmdChange.Enabled = True
cmdDC.Enabled = True
cmdCopy.Enabled = True
cmdPast.Enabled = True
cmdClean.Enabled = True
Else
cmdDC.Enabled = False
cmdCopy.Enabled = False
cmdChange.Enabled = False
cmdPast.Enabled = False
cmdClean.Enabled = False
End If
If bDel = True Then
'刷新
ConfigGrid '刷新左边列表
Exit Sub
End If
Dim iStart As Integer
Dim sString As String
Static iLeftOff As Integer
iStart = 1
iStart = cmbSite.SelStart
If iLeftOff <> 0 Then
cmbSite.SelStart = iLeftOff
iStart = iLeftOff
End If
sString = CStr(Left(cmbSite.Text, iStart))
cmbSite.ListIndex = SendMessage(cmbSite.Hwnd, CB_FINDSTRING, -1, ByVal CStr(Left(cmbSite.Text, iStart)))
If cmbSite.ListIndex = -1 Then
iLeftOff = Len(sString)
cmbSite.Text = sString
cmbSite.SelStart = iStart
ConfigGrid '刷新左边列表
End If
cmbSite.SelStart = iStart
If Len(cmbSite) > 1 Then
cmbSite.SelLength = Len(cmbSite) - iStart
Else
cmbSite.SelLength = 0
End If
iLeftOff = 0
End Sub
Private Sub cmbSite_KeyDown(KeyCode As Integer, Shift As Integer)
On Error Resume Next
If KeyCode = 8 Then '退格键
KeyCode = 0
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -