cs_Troopers
Messages postés
81
Date d'inscription
lundi 18 février 2002
Statut
Membre
Dernière intervention
29 août 2003
25 juin 2002 à 12:16
voici un exemple de code
si tu veux plus d'explication n'hésite pas à me demander
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<OBJECT id=TreeView1 style="WIDTH: 190px; HEIGHT: 700px" classid=clsid:C74190B6-8589-11D1-B16A-00C0F0283628 VIEWASTEXT>
</OBJECT>
<OBJECT id=ImageList1 classid=clsid:2C247F23-8591-11D1-B16A-00C0F0283628 VIEWASTEXT>
</OBJECT>
<SCRIPT LANGUAGE="VBScript">
TreeView1.Font.Name = "Arial"
TreeView1.Font.Size = 7
ImageList1.ListImages.Add 1,"Site",loadpicture("D:\temp\site.gif")
ImageList1.ListImages.Add 2,"Batiment",loadpicture("D:\temp\batiment.gif")
ImageList1.ListImages.Add 3,"Etage",loadpicture("D:\temp\etage.gif")
ImageList1.ListImages.Add 4,"Local",loadpicture("D:\temp\local.gif")
set TreeView1.ImageList = ImageList1
<%
'ImageList1.ListImages.Add 1,"Site",loadpicture("D:\temp\site.gif")
'set TreeView1.ImageList = ImageList1
'Ouverture d'une connexion à la base de données
Dim Connect
Dim ConnectDBQ
Set Connect = Server.CreateObject("ADODB.Connection")
connect.Provider="MSDataShape"
ConnectDBQ="DRIVER={Microsoft Access Driver (*.mdb)};"&"DBQ=E:\www\ocp\basedonnees\Ocp.mdb;"
Connect.Open ConnectDBQ
'Création de la variable de l'instruction SQL
Dim strSQL
strSQL = "SHAPE {select [sit_N°],sit_Libelle from site ORDER BY sit_Libelle} " & _
"APPEND ((SHAPE {select [bat_N°], [bat_N°Site], bat_Libelle from Batiment ORDER BY bat_Libelle} " & _
"APPEND ((SHAPE {SELECT [eta_N°],eta_code,[eta_N°batiment] FROM Etage ORDER BY eta_Code} " & _
"APPEND ({SELECT [loc_N°],loc_code,[loc_N°etage] FROM locaux ORDER BY loc_Code} AS DataLocaux RELATE [eta_N°] TO [loc_N°etage])) AS DataEtage RELATE [bat_N°] TO [eta_N°Batiment])) as DataBatiment RELATE [sit_N°] TO [bat_N°Site])"
'Création d'une instance de l'objet Recordset
Dim ObjRS, ObjRS2, ObjRS3, ObjRS4
Set ObjRS = Server.CreateObject("ADODB.Recordset")
ObjRS.Open strSQL, Connect
Dim cleSite,cleBatiment,cleEtage,cleLocal
'Affichage dans le treeview
While Not ObjRS.EOF
Set ObjRS2 = ObjRS.Fields("DataBatiment").Value
cleSite = "s-" & ObjRS.Fields("sit_N°")
response.write "TreeView1.Nodes.Add ,,""" & cleSite & """,""" & ObjRS.Fields("sit_Libelle") & """,""Site""" & chr(10)
While Not ObjRS2.EOF
Set ObjRS3 = ObjRS2.Fields("DataEtage").Value
cleBatiment = "b-" & ObjRS2.Fields("bat_N°")
response.write "TreeView1.Nodes.Add """ & cleSite & """, 4,""" & cleBatiment & """,""" & ObjRS2.Fields("bat_Libelle") & """,""Batiment""" & chr(10)
While Not ObjRS3.EOF
Set ObjRS4 = ObjRS3.Fields("Datalocaux").Value
cleEtage = "e-" & ObjRS3.Fields("eta_N°")
response.write "TreeView1.Nodes.Add """ & cleBatiment & """, 4,""" & cleEtage & """,""" & ObjRS3.Fields("eta_Code") & """,""Etage""" & chr(10)
While Not ObjRS4.EOF
cleLocal = "l-" & ObjRS4.Fields("loc_N°")
response.write "TreeView1.Nodes.Add """ & cleEtage & """, 4,""" & cleLocal & """,""" & ObjRS4.Fields("loc_Code") & """,""Local""" & chr(10)
ObjRS4.MoveNext
wend
ObjRS3.MoveNext
wend
ObjRS2.MoveNext
wend
ObjRS.MoveNext
wend
ObjRS.Close
Set ObjRS = Nothing
Connect.Close
set Connect = Nothing
%>
sub Treeview1_NodeClick(ByVal Node)
msgbox node.key
select case mid(Node.Key,1,1)
case "s"
window.parent.frames(1).location.href="../cadmanager/site.asp?num_sit=" & mid(Node.Key,3)
case "b"
window.parent.frames(1).location.href="../cadmanager/batiment.asp?num_bat=" & mid(Node.Key,3)
case "e"
window.parent.frames(1).location.href="../cadmanager/etage.asp?num_eta=" & mid(Node.Key,3)
case "l"
window.parent.frames(1).location.href="../cadmanager/local.asp?num_loc=" & mid(Node.Key,3)
end select
end sub
</SCRIPT>
</HTML>