请问一下,下面的(with.....end with)的作用 和用法。。 With TreeView1
If MsgBox("是否删除" & .Nodes(parText).Text & "?", vbOKCancel, "警告") = vbOK Then
txtSQL = "delete from dm_wzlb where lbcode1 = '" & Trim(.Nodes(parText).Key) & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
If .Nodes(parText).Parent Is Nothing Then
txtSQL = "delete from dm_wzlb where lbcode = '" & Trim(.Nodes(parText).Key) & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
End If
TreeView1.Nodes.Clear
ShowClass
Else
Exit Sub
End If
End With
If MsgBox("是否删除" & .Nodes(parText).Text & "?", vbOKCancel, "警告") = vbOK Then
txtSQL = "delete from dm_wzlb where lbcode1 = '" & Trim(.Nodes(parText).Key) & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
If .Nodes(parText).Parent Is Nothing Then
txtSQL = "delete from dm_wzlb where lbcode = '" & Trim(.Nodes(parText).Key) & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
End If
TreeView1.Nodes.Clear
ShowClass
Else
Exit Sub
End If
End With
.Nodes(parText).Parent
End With相当于 TreeView1.Nodes(ParText).Parent
可以简写成: .nodes.clear 这样就可以了