<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" backgroundColor="black" fontSize="12"
verticalAlign="middle" horizontalAlign="center" color="#000506" creationComplete="init()">
<mx:RemoteObject id="lo" destination="ObjectDAO" result="handleResult(event)" fault="handleFault(event)">
<mx:channelSet>
<mx:ChannelSet>
<mx:channels>
<mx:AMFChannel
uri="http://127.0.0.1:8400/spring/messagebroker/amf"/>
</mx:channels>
</mx:ChannelSet>
</mx:channelSet>
</mx:RemoteObject>
<mx:RemoteObject id="remoteObjectUpload" destination="fileUploadService" fault="Alert.show(event.fault.message);">
<mx:channelSet>
<mx:ChannelSet>
<mx:channels>
<mx:AMFChannel
uri="http://127.0.0.1:8400/spring/messagebroker/amf"/>
</mx:channels>
</mx:ChannelSet>
</mx:channelSet>
</mx:RemoteObject>
<mx:Script>
<![CDATA[
import mx.rpc.events.ResultEvent;
import mx.rpc.events.FaultEvent;
import mx.controls.Alert;
import mx.collections.ArrayCollection;
import mx.utils.ObjectProxy;
import mx.utils.ArrayUtil;
[Bindable]public var sql:String;
[Bindable]public var dp:ArrayCollection = new ArrayCollection();
[Bindable]
private var selectedFiles:Array = new Array();
private var selectedFileReferences:Array = new Array();
private var fileRefList:FileReferenceList;
private function browseFiles(event:MouseEvent):void
{
fileRefList = new FileReferenceList();
fileRefList.addEventListener(Event.SELECT, selectFiles);
fileRefList.browse();
}
private function selectFiles(e:Event):void
{
for each(var fileRef : FileReference in fileRefList.fileList)
{
selectedFiles.push(fileRef.name);
selectedFileReferences.push(fileRef);
fileRef.load();
}
dataGrid.dataProvider = selectedFiles;
}
private function uploadFiles(e:MouseEvent):void
{
for each(var fileRef : FileReference in selectedFileReferences)
{
remoteObjectUpload.doUpload(fileRef.name, fileRef.data);
}
}
private function init():void{
}
private function handleResult(event:ResultEvent):void{
dp = ArrayCollection(event.result);
trace(event.result);
trace("回傳資料");
}
private function handleFault(event:FaultEvent):void
{
Alert.show(event.fault.message, "錯誤警示");
}
private function serviceDAO():void
{
sql =" CALL DS.update_items_status('DS01') ";
lo.callProcBySQL(sql);
var batchSQL:Array = new Array();
batchSQL[0] = " delete from xx.testdata where groupname='1' ";
batchSQL[1] = " update xx.testdata set member1 = '測試更新1' where groupname='1' ";
batchSQL[2] = " update xx.testdata set member1 = '測試更新2' where groupname='2' ";
batchSQL[3] = " update xx.testdata set member1 = '測試更新3' where groupname='3'";
lo.updateBatch(batchSQL);
}
]]>
</mx:Script>
<mx:Panel height="364" width="592" title="測試視窗" horizontalAlign="center" verticalAlign="middle">
<mx:VBox>
<mx:ApplicationControlBar dock="true" width="551">
<mx:Button label="CALL !!" click="serviceDAO()"/>
</mx:ApplicationControlBar>
<mx:DataGrid height="255" width="551" dataProvider="{dp}" id="dg">
<mx:columns>
<mx:DataGridColumn headerText="資料成員一" dataField="MEMBER1"/>
<mx:DataGridColumn headerText="資料成員二" dataField="MEMBER2"/>
<mx:DataGridColumn headerText="資料成員三" dataField="MEMBER3"/>
<mx:DataGridColumn headerText="資料成員四" dataField="MEMBER4"/>
<mx:DataGridColumn headerText="資料成員五" dataField="MEMBER5"/>
</mx:columns>
</mx:DataGrid>
</mx:VBox>
<mx:Button label="Browse Files" click="browseFiles(event)" />
<mx:DataGrid id="dataGrid" width="200">
<mx:columns>
<mx:DataGridColumn headerText="Selected files"/>
</mx:columns>
</mx:DataGrid>
<mx:Button label="Upload Files" click="uploadFiles(event)"/>
</mx:Panel>
</mx:Application>
全站熱搜
留言列表
站台介紹 (1)