?? 收銀員收款統(tǒng)計條件查詢.frm
字號:
VERSION 5.00
Begin VB.Form search4
Caption = "收銀員收款統(tǒng)計條件查詢"
ClientHeight = 3315
ClientLeft = 60
ClientTop = 345
ClientWidth = 6450
Icon = "收銀員收款統(tǒng)計條件查詢.frx":0000
LinkTopic = "Form1"
ScaleHeight = 3315
ScaleWidth = 6450
StartUpPosition = 3 '窗口缺省
Begin VB.Frame Frame2
Caption = "查詢條件"
Height = 2445
Left = 0
TabIndex = 5
Top = 720
Width = 6345
Begin VB.TextBox Text5
Height = 315
Left = 2010
TabIndex = 16
Top = 1590
Width = 2835
End
Begin VB.CheckBox Check3
Caption = "Check3"
Height = 285
Left = 330
TabIndex = 14
Top = 1620
Width = 255
End
Begin VB.CheckBox Check1
Caption = "Check1"
Height = 375
Left = 330
TabIndex = 11
Top = 390
Width = 195
End
Begin VB.CheckBox Check2
Caption = "Check2"
Height = 315
Left = 330
TabIndex = 10
Top = 990
Width = 255
End
Begin VB.TextBox Text1
Height = 345
Left = 2010
TabIndex = 9
Top = 390
Width = 2805
End
Begin VB.TextBox Text2
Height = 330
Left = 2010
TabIndex = 8
Top = 990
Width = 2835
End
Begin VB.CommandButton Command1
Caption = "確定"
Height = 525
Left = 5250
TabIndex = 7
Top = 300
Width = 1035
End
Begin VB.CommandButton Command2
Caption = "取消"
Height = 495
Left = 5250
TabIndex = 6
Top = 1080
Width = 1065
End
Begin VB.Label Label5
Caption = "收銀員編碼："
Height = 315
Left = 720
TabIndex = 15
Top = 1620
Width = 1245
End
Begin VB.Label Label1
Caption = "連鎖店名稱："
Height = 315
Left = 720
TabIndex = 13
Top = 480
Width = 1185
End
Begin VB.Label Label2
Caption = "收銀員名稱："
Height = 345
Left = 720
TabIndex = 12
Top = 990
Width = 1275
End
End
Begin VB.Frame Frame1
Caption = "日期范圍"
Height = 795
Left = 0
TabIndex = 0
Top = 0
Width = 6345
Begin VB.TextBox Text3
Height = 315
Left = 1140
TabIndex = 2
Text = "Text3"
Top = 240
Width = 1575
End
Begin VB.TextBox Text4
Height = 315
Left = 4590
TabIndex = 1
Text = "Text4"
Top = 240
Width = 1455
End
Begin VB.Label Label3
Caption = "起始日期："
Height = 345
Left = 240
TabIndex = 4
Top = 300
Width = 915
End
Begin VB.Label Label4
Caption = "終止日期："
Height = 285
Left = 3690
TabIndex = 3
Top = 330
Width = 1125
End
End
End
Attribute VB_Name = "search4"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub Command1_Click()
Dim txtSQL(0 To 2) As String
Dim mrc As ADODB.Recordset
Dim MsgText As String
Static miCount As Integer
'ToDo: create test for correct password
'check for correct password
If Trim(Text1.Text) = "" And Trim(Text2.Text) = "" And Trim(Text5.Text) = "" Then
MsgBox "沒有選擇查詢條件！"
Exit Sub
End If
If Check1.Value = 1 Then
txtSQL(0) = "select * from 數(shù)據(jù)存取表 where 連鎖店編碼 = '" & Text1.Text & "'"
Set mrc = ExecuteSQL(txtSQL(0), MsgText)
If mrc.EOF = True Then
MsgBox "沒有連鎖店加盟!", vbOKOnly + vbExclamation, "警告"
'VB 在線
'www.VBzx.net
' VB在線 收集整理
'+------------------------------------------------+
' http://www.VBzx.net
'+------------------------------------------------+
End If
End If
If Check2.Value = 1 Then
txtSQL(1) = "select * from 數(shù)據(jù)存取表 where 收銀員名稱 = '" & Text2.Text & "'"
Set mrc = ExecuteSQL(txtSQL(1), MsgText)
If mrc.EOF = True Then
MsgBox "對不起，無此收銀員!", vbOKOnly + vbExclamation, "警告"
End If
End If
If Check3.Value = 1 Then
txtSQL(2) = "select * from 數(shù)據(jù)存取表 where 收銀員編碼 = '" & Text5.Text & "'"
Set mrc = ExecuteSQL(txtSQL(2), MsgText)
If mrc.EOF = True Then
MsgBox "對不起，沒有收銀員的紀(jì)錄!", vbOKOnly + vbExclamation, "警告"
End If
End If
sqlresult4.txtSQL = txtSQL(0) & txtSQL(1) & txtSQL(2)
sqlresult4.Show
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -