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
|
public function clicRation():void
{
sqls4.sqlConnection = sqlc;
sqls4.text = "select id_besoinF,lbl_besoinF,Unite,AffichF,coordX,coordY,largeur from besoinF order by AffichF DESC;";
sqls4.addEventListener(SQLEvent.RESULT, CreerChps);
sqls4.execute();
}
public function CreerChps(e:SQLEvent):void
{
var donnees:Array = sqls4.getResult().data;
dapa = new ArrayCollection(donnees);
var lab:Label;
for (var j:uint=0; j<donnees.length;j++){
lab=new Label();
lab.id="valBesoinF"+donnees[j]["id_besoinF"];
lab.name="valBesoinF"+donnees[j]["id_besoinF"];
lab.text="0";
lab.move(donnees[j]["coordX"]+donnees[j]["largeur"]+10,donnees[j]["coordY"]);
lab.height=21;
lab.width=42;
if(donnees[j]["id_besoinF"]==1){lab.text="124"; resRationT.addElementAt(lab,5)/*Alert.show("champ= "+lab.id)*/}
else{
resRationT.addElement(lab);
}
}
resultats_ration();
}
public function resultats_ration():void
{
(resRationT.getElementAt(5) as Label).text = 'toto'
} |