📄 frmkhcxgr.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form frmKHCXGR
Caption = "个人业务查询"
ClientHeight = 7365
ClientLeft = 60
ClientTop = 450
ClientWidth = 10245
LinkTopic = "Form1"
LockControls = -1 'True
MDIChild = -1 'True
ScaleHeight = 7365
ScaleWidth = 10245
Begin VB.Frame Frame3
Height = 7095
Left = 7680
TabIndex = 2
Top = 120
Width = 2535
Begin VB.CommandButton CmdFind
Caption = "查找"
Height = 480
Left = 480
TabIndex = 8
Top = 2520
Width = 1650
End
Begin VB.ComboBox findbt
Height = 300
Left = 480
TabIndex = 7
Text = "查找项目"
Top = 1080
Width = 1620
End
Begin VB.TextBox findnr
Height = 330
Left = 480
TabIndex = 6
Top = 1695
Width = 1620
End
End
Begin VB.Frame Frame2
Height = 6255
Left = 120
TabIndex = 1
Top = 960
Width = 7455
Begin MSComctlLib.ListView LstKH
Height = 5895
Left = 120
TabIndex = 5
Top = 240
Width = 7215
_ExtentX = 12726
_ExtentY = 10398
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
_Version = 393217
Icons = "ImageList1"
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
NumItems = 0
End
End
Begin VB.Frame Frame1
Height = 855
Left = 120
TabIndex = 0
Top = 120
Width = 7455
Begin VB.OptionButton Option2
Caption = "企业客户"
Height = 375
Left = 4320
TabIndex = 4
Top = 240
Width = 2655
End
Begin VB.OptionButton Option1
Caption = "个人客户"
Height = 375
Left = 720
TabIndex = 3
Top = 240
Width = 2655
End
Begin MSComctlLib.ImageList ImageList1
Left = 0
Top = 0
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 32
ImageHeight = 32
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 19
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":0000
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":031A
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":0634
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":1486
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":17A0
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":1ABA
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":2394
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":26B6
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":2F90
Key = ""
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":386A
Key = ""
EndProperty
BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":3B84
Key = ""
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":43D6
Key = ""
EndProperty
BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":6B88
Key = ""
EndProperty
BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":7E0A
Key = ""
EndProperty
BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":9F44
Key = ""
EndProperty
BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":A25E
Key = ""
EndProperty
BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":A580
Key = ""
EndProperty
BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":A89A
Key = ""
EndProperty
BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmKHCXGR.frx":ABB4
Key = ""
EndProperty
EndProperty
End
End
End
Attribute VB_Name = "frmKHCXGR"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub CmdFind_Click()
Dim rs As ADODB.Recordset
Dim strsql As String
Set rs = New ADODB.Recordset
If Option1.Value = True Then
If findbt = "" Then
strsql = "select * from viewgr where 客户类型=0 and 操作员='" & gUser & "'"
Else
strsql = "select * from viewgr where " & findbt & " like '%" & findnr & "%' and 客户类型=0 and 操作员='" & gUser & "'"
End If
Else
If findbt = "" Then
strsql = "select * from viewqy where 客户类型=1 and 操作员='" & gUser & "'"
Else
strsql = "select * from viewqy where " & findbt & " like '%" & findnr & "%' and 客户类型=1 and 操作员='" & gUser & "'"
End If
End If
rs.Open strsql, gCnn, adOpenStatic, adLockReadOnly
Call ShowListViewJ(LstKH, rs, False)
End Sub
Private Sub Form_Load()
If Me.WindowState = 0 Then Me.Move 0, 0, 10365, 7875
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim i As Long
rs.Open "select * from VIEWGR", gCnn, adOpenStatic, adLockReadOnly
findbt.Clear
For i = 0 To rs.Fields.count - 2
findbt.AddItem rs.Fields(i).name
Next
End Sub
Private Sub Option1_Click()
Dim rs As ADODB.Recordset
Dim strsql As String
Dim msg As String
Set rs = New ADODB.Recordset
strsql = "select * from viewgr where 客户类型=0 and 操作员='" & gUser & "'"
rs.Open strsql, gCnn, adOpenStatic, adLockReadOnly
Call ShowListViewJ(LstKH, rs, False)
Dim i As Long
If rs.State = 1 Then rs.Close
rs.Open "select * from VIEWGR", gCnn, adOpenStatic, adLockReadOnly
findbt.Clear
For i = 0 To rs.Fields.count - 2
findbt.AddItem rs.Fields(i).name
Next
End Sub
Private Sub Option2_Click()
Dim rs As ADODB.Recordset
Dim strsql As String
Dim msg As String
Set rs = New ADODB.Recordset
strsql = "select * from viewqy where 客户类型=1 and 操作员='" & gUser & "'"
rs.Open strsql, gCnn, adOpenStatic, adLockReadOnly
Call ShowListViewJ(LstKH, rs, False)
Dim i As Long
If rs.State = 1 Then rs.Close
rs.Open "select * from VIEWqy", gCnn, adOpenStatic, adLockReadOnly
findbt.Clear
For i = 0 To rs.Fields.count - 2
findbt.AddItem rs.Fields(i).name
Next
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -