Private Sub Form_Load()
Me.Trv.Nodes.Clear '清除Treeview控件中的所有节点
Call AddMyTree(Trv, "usysDepartment", "Dept_ParentID", "Dept_ID", "Dept_Name")
Me.Trv.SetFocus
End Sub
Private Sub Trv_NodeClick(ByVal Node As Object)
'MsgBox Node.Index & "****" & Node.Tag
Rec.Open "select * from EmploymentInfo where EMP_Units='" & Node & "'", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
If Rec.RecordCount > 0 Then
For i = 0 To Rec.RecordCount - 1
Set Nodeindex = Trv.Nodes.Add(Node, tvwChild, "e" & Rec.Fields("EMP_ID"), Rec.Fields("EMP_Name"), 1, 2)
Node.Tag = Rec.Fields("EMP_ID")
Node.Sorted = True
Rec.MoveNext
Next
End If
Rec.Close
Me.Trv.Refresh
Private Sub Trv_NodeClick(ByVal Node As Object)
on error resume next
Rec.Open "select * from EmploymentInfo where EMP_Units='" & Node & "'", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
If Rec.RecordCount > 0 Then
For i = 0 To Rec.RecordCount - 1
Set Nodeindex=nothing
Set Nodeindex = trv.nodes("e" & Rec.Fields("EMP_ID"))
if nodeindex is nothing then
Set Nodeindex = Trv.Nodes.Add(Node, tvwChild, "e" & Rec.Fields("EMP_ID"), Rec.Fields("EMP_Name"), 1, 2)
Node.Tag = Rec.Fields("EMP_ID")
Node.Sorted = True
end if
Rec.MoveNext
Next
End If
Rec.Close
Me.Trv.Refresh作者: xjb_test 时间: 2013-3-28 16:25
顶顶作者: p51219 时间: 2016-7-10 13:51
好好好