4,328
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
xmlns:mx="library://ns.adobe.com/flex/mx"
width="433" height="528" minWidth="955" minHeight="600"
creationComplete="initWeb();sendResult();">
<fx:Declarations>
</fx:Declarations>
<fx:Script>
<![CDATA[
import mx.collections.ArrayCollection;
import mx.collections.ICollectionView;
import mx.collections.XMLListCollection;
import mx.controls.Alert;
import mx.rpc.AbstractOperation;
import mx.rpc.events.FaultEvent;
import mx.rpc.events.ResultEvent;
import mx.rpc.soap.WebService;
public var isSucceed:Boolean = new Boolean(false); //定义一个变量用来判断是否登录成功
public var web:WebService;
/* public var codeToName:ArrayCollection = new ArrayCollection([{WellCode:A000001,},{},{},{}]); */
public function initWeb():void{
//初始化Web服务,添加Web服务URL地址
web = new WebService();
//加载Web服务
web.loadWSDL("http://localhost/wenling/Service.asmx?WSDL");
}
public function sendResult():void{
//Web查询方法
var oper:AbstractOperation = web.getOperation("getConnection");
var strSql:String = "SELECT Name FROM SysObjects Where XType='U' and Name like 'A%' and len(Name)=7 order by Name";
/* var strSql:String = "select top 10 ID from A000001"; */
oper.send(strSql);
web.addEventListener(ResultEvent.RESULT,OnResult);
web.addEventListener(FaultEvent.FAULT,OnFault);
}
[Bindable]
public var arr:XML = new XML(); //定义一个变量用来接收数据
public function OnResult(event:ResultEvent):void{
arr= XML(event.result);
/* this.mytree.dataProvider = arr.Table.Name; */
var xl:XMLList = arr.Table.Name;
for each (var xx:XML in xl)
{
xx.@Name = xx.toString();
delete xx.children()[0];
}
var xc:XMLListCollection = new XMLListCollection(xl);
mytree.dataProvider = xc;
}
public function OnFault(event:FaultEvent):void{
var s:String = event.message.toString();
Alert.show(s);
}
private function tree_change(event:Event):void{
var str:String = mytree.selectedItem.@Name;
Alert.show("选中的要素为:" + str);
}
/* private function treeFun(item:XML):String{
return item.@Name;
} */
]]>
</fx:Script>
<mx:Tree x="2" y="3" height="506" width="421" id="mytree" showRoot="false"
change="tree_change(event)" labelField="@Name" ><!-- labelFunction="treeFun">-->
</mx:Tree>
</s:Application>