📄 client_query.frm
字号:
VERSION 5.00
Begin VB.Form Client_Query
BorderStyle = 1 'Fixed Single
Caption = "客户信息查询"
ClientHeight = 4410
ClientLeft = 45
ClientTop = 330
ClientWidth = 9855
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4410
ScaleWidth = 9855
StartUpPosition = 2 '屏幕中心
Begin VB.CommandButton cmdQuery
Caption = "查询"
Height = 495
Left = 7200
TabIndex = 38
Top = 3840
Width = 1215
End
Begin VB.CommandButton cmdCancel
Caption = "取消"
Height = 495
Left = 8400
TabIndex = 37
Top = 3840
Width = 1215
End
Begin VB.Frame Frame1
Caption = "客户数据查询条件"
Height = 3615
Left = 120
TabIndex = 0
Top = 120
Width = 9615
Begin VB.TextBox Djrq2
Height = 375
Left = 4200
TabIndex = 36
Top = 2940
Width = 1815
End
Begin VB.TextBox Khmc
Height = 375
Left = 1200
TabIndex = 17
Top = 360
Width = 4500
End
Begin VB.TextBox Khdz
Height = 375
Left = 1200
TabIndex = 16
Top = 840
Width = 4500
End
Begin VB.TextBox Dh
Height = 375
Left = 6960
TabIndex = 15
Top = 360
Width = 2000
End
Begin VB.TextBox Cz
Height = 375
Left = 6960
TabIndex = 14
Top = 840
Width = 2000
End
Begin VB.TextBox Wz
Height = 375
Left = 1200
TabIndex = 13
Top = 1320
Width = 2500
End
Begin VB.TextBox Dzyj
Height = 375
Left = 4560
TabIndex = 12
Top = 1320
Width = 2385
End
Begin VB.TextBox Yzbm
Height = 375
Left = 7950
MaxLength = 6
TabIndex = 11
Top = 1320
Width = 1000
End
Begin VB.ComboBox Ssqy
Height = 300
Left = 1200
Style = 2 'Dropdown List
TabIndex = 10
Top = 1800
Width = 1800
End
Begin VB.ComboBox Khlx
Height = 300
Left = 4200
Style = 2 'Dropdown List
TabIndex = 9
Top = 1800
Width = 1800
End
Begin VB.ComboBox Khly
Height = 300
Left = 7150
Style = 2 'Dropdown List
TabIndex = 8
Top = 1800
Width = 1800
End
Begin VB.ComboBox Hylx
Height = 300
Left = 1200
Style = 2 'Dropdown List
TabIndex = 7
Top = 2190
Width = 1800
End
Begin VB.ComboBox Khzt
Height = 300
Left = 4200
Style = 2 'Dropdown List
TabIndex = 6
Top = 2190
Width = 1800
End
Begin VB.ComboBox Khdj
Height = 300
Left = 7150
Style = 2 'Dropdown List
TabIndex = 5
Top = 2190
Width = 1800
End
Begin VB.ComboBox Gj
Height = 300
Left = 1200
Style = 2 'Dropdown List
TabIndex = 4
Top = 2560
Width = 1800
End
Begin VB.ComboBox Sf
Height = 300
Left = 4200
Style = 2 'Dropdown List
TabIndex = 3
Top = 2560
Width = 1800
End
Begin VB.ComboBox Cs
Height = 300
Left = 7150
Style = 2 'Dropdown List
TabIndex = 2
Top = 2560
Width = 1800
End
Begin VB.TextBox Djrq1
Height = 375
Left = 1200
TabIndex = 1
Top = 2940
Width = 1815
End
Begin VB.Label Label1
Caption = "客户名称"
Height = 255
Left = 240
TabIndex = 35
Top = 400
Width = 795
End
Begin VB.Label Label2
Caption = "客户地址"
Height = 255
Left = 240
TabIndex = 34
Top = 880
Width = 795
End
Begin VB.Label Label3
Caption = "电话"
Height = 255
Left = 6120
TabIndex = 33
Top = 400
Width = 795
End
Begin VB.Label Label4
Caption = "传真"
Height = 255
Left = 6120
TabIndex = 32
Top = 880
Width = 795
End
Begin VB.Label Label5
Caption = "网址"
Height = 255
Left = 240
TabIndex = 31
Top = 1350
Width = 795
End
Begin VB.Label Label6
Caption = "电子邮件"
Height = 255
Left = 3720
TabIndex = 30
Top = 1350
Width = 795
End
Begin VB.Label Label7
Caption = "邮政编码"
Height = 255
Left = 7080
TabIndex = 29
Top = 1350
Width = 795
End
Begin VB.Label Label8
Caption = "所属区域"
Height = 255
Left = 240
TabIndex = 28
Top = 1850
Width = 795
End
Begin VB.Label Label9
Caption = "客户类型"
Height = 255
Left = 3240
TabIndex = 27
Top = 1850
Width = 795
End
Begin VB.Label Label10
Caption = "客户来源"
Height = 255
Left = 6120
TabIndex = 26
Top = 1845
Width = 795
End
Begin VB.Label Label11
Caption = "行业类型"
Height = 255
Left = 240
TabIndex = 25
Top = 2240
Width = 795
End
Begin VB.Label Label12
Caption = "客户状态"
Height = 255
Left = 3240
TabIndex = 24
Top = 2240
Width = 795
End
Begin VB.Label Label13
Caption = "客户等级"
Height = 255
Left = 6120
TabIndex = 23
Top = 2240
Width = 795
End
Begin VB.Label Label14
Caption = "国家"
Height = 255
Left = 240
TabIndex = 22
Top = 2590
Width = 795
End
Begin VB.Label Label15
Caption = "省份"
Height = 255
Left = 3240
TabIndex = 21
Top = 2590
Width = 795
End
Begin VB.Label Label16
Caption = "城市"
Height = 255
Left = 6120
TabIndex = 20
Top = 2590
Width = 795
End
Begin VB.Label Label17
Caption = "登记日期"
Height = 255
Left = 240
TabIndex = 19
Top = 2950
Width = 795
End
Begin VB.Label Label18
Caption = "--->>>"
Height = 255
Left = 3240
TabIndex = 18
Top = 2950
Width = 795
End
End
End
Attribute VB_Name = "Client_Query"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private ListRS As New ADODB.Recordset
Private Sub cmdCancel_Click()
Unload Me
End Sub
Private Sub cmdQuery_Click()
Dim Sql As String
Sql = "select * from Client_BASE where 1=1 "
If Khmc.Text <> "" Then
Sql = Sql + "and 客户名称 like '%%" & Khmc.Text & "%%' "
End If
If Khdz.Text <> "" Then
Sql = Sql + "and 客户地址 like '%%" & Khdz.Text & "%%' "
End If
If Dh.Text <> "" Then
Sql = Sql + "and 电话='" & Dh.Text & "' "
End If
If Cz.Text <> "" Then
Sql = Sql + "and 传真='" & Cz.Text & "' "
End If
If Wz.Text <> "" Then
Sql = Sql + "and 网址='" & Wz.Text & "' "
End If
If Dzyj.Text <> "" Then
Sql = Sql + "and 电子邮件='" & Dzyj.Text & "' "
End If
If Yzbm.Text <> "" Then
Sql = Sql + "and 邮政编码='" & Yzbm.Text & "' "
End If
If Ssqy.Text <> "" Then
Sql = Sql + "and 所属区域='" & Ssqy.Text & "' "
End If
If Khlx.Text <> "" Then
Sql = Sql + "and 客户类型='" & Khlx.Text & "' "
End If
If Khly.Text <> "" Then
Sql = Sql + "and 客户来源='" & Khly.Text & "' "
End If
If Hylx.Text <> "" Then
Sql = Sql + "and 行业类型='" & Hylx.Text & "' "
End If
If Khzt.Text <> "" Then
Sql = Sql + "and 客户状态='" & Khzt.Text & "' "
End If
If Khdj.Text <> "" Then
Sql = Sql + "and 客户等级='" & Khdj.Text & "' "
End If
If Gj.Text <> "" Then
Sql = Sql + "and 国家='" & Gj.Text & "' "
End If
If Sf.Text <> "" Then
Sql = Sql + "and 省份='" & Sf.Text & "' "
End If
If Cs.Text <> "" Then
Sql = Sql + "and 城市='" & Cs.Text & "' "
End If
If Djrq1.Text <> "" And Djrq2.Text <> "" Then
Sql = Sql + "and 登记日期>=#" & Djrq1.Text & "# and 登记日期<=#" & Djrq2.Text & "# "
End If
Set MainRS = Nothing
MainRS.Open Sql, MainDB, adOpenStatic, adLockOptimistic
Set Data_list.Adodc1.Recordset = MainRS
Unload Me
End Sub
Private Sub Form_Activate()
Khmc.SetFocus
End Sub
Private Sub Form_Load()
Dim I As Integer
Set ListRS = Nothing
ListRS.Open "select * from JC_SSQY", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Ssqy.AddItem ListRS!区域名称
ListRS.MoveNext
Wend
Set ListRS = Nothing
ListRS.Open "select * from JC_KHLX", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Khlx.AddItem ListRS!客户类型名称
ListRS.MoveNext
Wend
Set ListRS = Nothing
ListRS.Open "select * from JC_KHLY", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Khly.AddItem ListRS!来源名称
ListRS.MoveNext
Wend
Set ListRS = Nothing
ListRS.Open "select * from JC_HYLX", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Hylx.AddItem ListRS!行业类型名称
ListRS.MoveNext
Wend
Set ListRS = Nothing
ListRS.Open "select * from JC_KHZT", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Khzt.AddItem ListRS!状态名称
ListRS.MoveNext
Wend
Set ListRS = Nothing
ListRS.Open "select * from JC_KHDJ", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Khdj.AddItem ListRS!等级名称
ListRS.MoveNext
Wend
Set ListRS = Nothing
ListRS.Open "select 国家 from JC_SSDQ group by 国家", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Gj.AddItem ListRS!国家
ListRS.MoveNext
Wend
End Sub
Private Sub Form_Unload(Cancel As Integer)
MDIForm1.Enabled = True
End Sub
Private Sub Gj_Click()
Sf.Clear
Set ListRS = Nothing
ListRS.Open "select 省份 from JC_SSDQ where 国家='" & Gj.Text & "' group by 省份", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Sf.AddItem ListRS!省份
ListRS.MoveNext
Wend
End Sub
Private Sub Sf_Click()
Cs.Clear
Set ListRS = Nothing
ListRS.Open "select * from JC_SSDQ where 国家='" & Gj.Text & "' and 省份='" & Sf.Text & "'", MainDB, adOpenStatic, adLockOptimistic
While Not ListRS.EOF
Cs.AddItem ListRS!城市
ListRS.MoveNext
Wend
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -