📄 客户基本资料.frm
字号:
Top = 90
Width = 1125
End
Begin VB.Image CMD_IMG1
Height = 375
Index = 0
Left = 210
Picture = "客户基本资料.frx":16338C
Top = 90
Width = 1125
End
End
Begin MSComctlLib.TreeView TreeView1
Height = 6075
Left = 60
TabIndex = 11
Top = 1050
Width = 4095
_ExtentX = 7223
_ExtentY = 10716
_Version = 393217
Style = 3
ImageList = "ImageList1"
Appearance = 1
End
Begin VB.PictureBox Picture1
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 345
Left = 0
Picture = "客户基本资料.frx":16751B
ScaleHeight = 345
ScaleWidth = 9000
TabIndex = 9
Top = 0
Width = 9000
Begin VB.Image Image7
Height = 345
Left = 6150
Picture = "客户基本资料.frx":171715
Top = -1800
Width = 345
End
Begin VB.Image Image5
Height = 345
Left = 30
Picture = "客户基本资料.frx":171DCF
Top = 0
Width = 345
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "客户基本资料"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000E&
Height = 180
Left = 480
TabIndex = 10
Top = 90
Width = 1170
End
Begin VB.Image Image6
Height = 345
Left = 8460
Picture = "客户基本资料.frx":172489
Top = 30
Width = 345
End
End
Begin VB.Line Line1
X1 = 436
X2 = 470
Y1 = 248
Y2 = 248
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "性别"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Index = 7
Left = 7230
TabIndex = 20
Top = 1860
Width = 510
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "公司简称"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Index = 6
Left = 4260
TabIndex = 19
Top = 4260
Width = 1020
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "手机"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Index = 5
Left = 6600
TabIndex = 18
Top = 4230
Width = 510
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "联系电话"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Index = 4
Left = 4275
TabIndex = 17
Top = 3660
Width = 1020
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "详细地址"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Index = 3
Left = 4275
TabIndex = 16
Top = 3060
Width = 1020
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "单位名称"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Index = 2
Left = 4275
TabIndex = 15
Top = 2460
Width = 1020
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "收件人"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Index = 1
Left = 4530
TabIndex = 14
Top = 1860
Width = 765
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "目的地"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Index = 0
Left = 4530
TabIndex = 13
Top = 1260
Width = 765
End
Begin VB.Shape Shape1
Height = 6045
Left = 4200
Top = 1050
Width = 4695
End
End
Attribute VB_Name = "khjbzl"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs As ADODB.Recordset
Dim Save_node As Node
Dim MaxID As String
Dim Current_ID As String
Dim Current_Name As String
Dim OP_Flag As String
Public Sub ShowTreeView()
'初始化imagecombo1
ImageCombo1.ComboItems.Clear
ImageCombo1.ComboItems.Add , , "男", 3
ImageCombo1.ComboItems.Add , , "女", 2
ImageCombo1.ComboItems.Add , , "未知", 4
'初始化combo1
Combo1.Clear
Dim Nd As Node
TreeView1.Nodes.Clear
With TreeView1
sqltext = "select 目的地 from 客户资料 group by 目的地"
'sqltext = "select distinct 目的地 from 客户资料"
Set Nd = .Nodes.Add(, , "root", "地区分类", 1)
Set rs = ExecuteSQL(sqltext, MsgString)
i = "1000"
If Not (rs.EOF And rs.BOF) Then
Do
Set Nd = .Nodes.Add("root", tvwChild, "dq" + rs(0), rs(0), 1)
Combo1.AddItem rs(0)
i = Str(Val(i) + 1)
rs.MoveNext
Loop Until rs.EOF
Else
Exit Sub
End If
.Nodes(.Nodes.Count).EnsureVisible
sqltext = "select * from 客户资料 order by 客户ID"
Set rs = ExecuteSQL(sqltext, MsgString)
If Not (rs.EOF And rs.BOF) Then
Do
If IsNull(rs(4)) Or rs(4) = "" Then
txtname = rs(1)
aa = "mz"
Else
txtname = rs(4)
aa = "dw"
End If
If IsNull(rs(8)) Then
img = 4
ElseIf rs(8) = True Then
img = 3
ElseIf rs(8) = False Then
img = 2
End If
Set Nd = .Nodes.Add("dq" + rs(2), tvwChild, aa + rs(0), txtname, img)
MaxID = rs(0)
rs.MoveNext
Loop Until rs.EOF
Else
Exit Sub
End If
End With
End Sub
Private Sub Set_State(ByVal img1 As Boolean, ByVal img2 As Boolean, ByVal img3 As Boolean, ByVal img5 As Boolean, ByVal img6 As Boolean) '设置菜单栏状态
'设置开关状态
If img1 Then
CMD_IMG1(2).Move CMD_IMG1(0).Left, CMD_IMG1(0).Top
Else
CMD_IMG1(2).Move -3000, -3000
End If
If img2 Then
CMD_IMG2(2).Move CMD_IMG2(0).Left, CMD_IMG2(0).Top
Else
CMD_IMG2(2).Move -3000, -3000
End If
If img3 Then
CMD_IMG3(2).Move CMD_IMG3(0).Left, CMD_IMG3(0).Top
Else
CMD_IMG3(2).Move -3000, -3000
End If
If img5 Then
CMD_IMG5(2).Move CMD_IMG5(0).Left, CMD_IMG5(0).Top
Else
CMD_IMG5(2).Move -3000, -3000
End If
If img6 Then
CMD_IMG6(2).Move CMD_IMG6(0).Left, CMD_IMG6(0).Top
Else
CMD_IMG6(2).Move -3000, -3000
End If
End Sub
Private Sub CMD_IMG1_Click(Index As Integer)
Select Case Index
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -