1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| TreeView1.Items.Clear;
Datamodule1.QAfficheArboLoco.close;
Datamodule1.QAfficheArboLoco.SQL.Clear;
Datamodule1.QAfficheArboLoco.SQL.Add('SELECT ID_Engin_FK3,Module_N1,Module_N2,Module_N3,Module_N4,Module_N5,Module_N6');
Datamodule1.QAfficheArboLoco.SQL.Add('FROM Arbo');
Datamodule1.QAfficheArboLoco.SQL.Add('GROUP BY ID_Engin_FK3,Module_N1,Module_N2,Module_N3,Module_N4,Module_N5,Module_N6');
Datamodule1.QAfficheArboLoco.Open;
Datamodule1.QAfficheArboLoco.First;
L_Acc_FieldCount:= Datamodule1.QAfficheArboLoco.FieldCount;
While not Datamodule1.QAfficheArboLoco.Eof do
begin
if L_Acc_Value[0]<> Datamodule1.QAfficheArboLoco.Fields[0].Value then
L_Acc_Treenode[0]:=TreeView1.Items.Add(nil,vartostr(Datamodule1.QAfficheArboLoco.Fields[0].Value));
for i:=1 to Datamodule1.QAfficheArboLoco.FieldCount -1 do
begin
if (L_Acc_value[i]<> Datamodule1.QAfficheArboLoco.Fields[i].Value) or (Datamodule1.QAfficheArboLoco.Fields[i].Value = NULL) then
L_Acc_Treenode[i]:=TreeView1.Items.AddChild(L_Acc_Treenode[i-1],Vartostr(Datamodule1.QAfficheArboLoco.Fields[i].Value));
L_Acc_value[i]:=Datamodule1.QAfficheArboLoco.Fields[i].Value;
end;
L_Acc_value[0]:=Datamodule1.QAfficheArboLoco.Fields[0].Value;
Datamodule1.QAfficheArboLoco.Next;
end;
DataModule1.QAfficheTypeOperationMP.close ;
DataModule1.QAfficheTypeOperationMP.sql.clear;
DataModule1.QAfficheTypeOperationMP.SQL.add('SELECT * FROM Description_Operation_Maintenance');
DataModule1.QAfficheTypeOperationMP.open;
while jx3<DataModule1.QAfficheTypeOperationMP.RecordCount do
begin
DOM_Combo.Items.Add(DataModule1.QAfficheTypeOperationMPDescr_Operation.value) ;
jx3:=jx3+1;
DataModule1.QAfficheTypeOperationMP.moveby(1);
end;
end; |
Partager