DataGrid内联ComboBox修改数据并提交至数据库 -

yangjay

浏览: 5779 次
性别:
来自: 深圳

最近访客更多访客>>

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

DataGrid内联ComboBox修改数据并提交至数据库

博客分类：

flex

Adobe 工作

单击DataGrid单元格编辑出现ComboBox，选择相应的值，要使数据写入数据库就要调用DataGrid的itemEditEnd事件，itemEditEnd事件是在离开编辑单元格后触发的.

itemEditEnd事件调用的方法

private function updatePro(event:DataGridEvent):void{
             	var dataField:String = event.dataField;//获取绑定字段的名称
             	
           var proId:String = mydate.selectedItem.proId;//获取id
             	if(dataField=="completePreStr"){
             	var newData:String = "";
             	try{
             		newData = ComboBox(event.currentTarget.itemEditorInstance).selectedLabel//获取编辑后的新值
             }catch(errObject:Error){          	}
             	//判断为null的情况,否则很容易出现TypeError: Error #1009: 无法访问空对象引用的属性或方法
             if(newData!=null){
             		myProService.updateCompletePreStr(proId,newData);//调用更新方法
             }
             	}
             }

全部源码:

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" backgroundColor="white" creationComplete="init2();init();" height="1332" backgroundGradientAlphas="[1.0, 1.0]" backgroundGradientColors="[#FCFCFC, #040303]" xmlns:local="*" xmlns:ns1="com.esria.samples.dashboard.view.*">
	<mx:Script>
        <![CDATA[
        	import mx.controls.List;
            import mx.collections.ArrayCollection;
            import mx.events.CuePointEvent;
            import mx.events.VideoEvent;
            import mx.controls.Alert;
			import mx.rpc.events.ResultEvent;
			import mx.events.DataGridEvent;
 
            
            [Bindable]
            private var FLV_URL:String = "zhajm_126296095230hd.flv";
 			
 			[Bindable]
            private var userInfoList:ArrayCollection;
            
            [Bindable]
            private var userInfo:Object;
            
            [Bindable]
            public var cards:ArrayCollection;
            /**
             * Initialize the ArrayCollection object.
             */
            private function init():void {
                department.getDepartment();
            }
            
            private function init2():void {
            	
                myservice.getProInfo("","");
            }
 			
 			public function resultHandler(result:ResultEvent):void{
				userInfoList = result.result as ArrayCollection;
				userInfo = userInfoList.getItemAt(0);
				//Alert.show(userInfo.userName);
			}
			
			private function changeHandler(event:Event):void {
            		myservice.getProInfo(departmentId.text,pageNum.text);
            }
            
            private function closeHandler(result:ResultEvent):void {
                cards = result.result as ArrayCollection;
            }
            
            private function formatDate(item:Object,column:DataGridColumn):String{
                if (item[column.dataField] == null) {
                 return "-";
                }
                return FD.format(item[column.dataField]);
               }
               
            private function formatPre(item:Object,column:DataGridColumn):String{
                if (item[column.dataField] == null) {
                 return "-";
                }
                if (item[column.dataField] == 1) {
                 return "模型";
                }
                if (item[column.dataField] == 2) {
                 return "预演";
                }
                if (item[column.dataField] == 3) {
                 return "小样";
                }
                if (item[column.dataField] == 4) {
                 return "渲染";
                }
                if (item[column.dataField] == 5) {
                 return "后期";
                }
                return item[column.dataField];
               }
             private function updatePro(event:DataGridEvent):void{
             	var dataField:String = event.dataField;//获取绑定字段的名称
             	
             	var proId:String = mydate.selectedItem.proId;//获取id
             	if(dataField=="completePreStr"){
             		var newData:String = "";
             		try{
             			newData = ComboBox(event.currentTarget.itemEditorInstance).selectedLabel//获取编辑后的新值
             		}catch(errObject:Error){
             			
             		}
             		//判断为null的情况,否则很容易出现TypeError: Error #1009: 无法访问空对象引用的属性或方法
             		if(newData!=null){
             			myProService.updateCompletePreStr(proId,newData);//调用更新方法
             		}
             	}
             }
        ]]>
    </mx:Script>
    <mx:Text fontFamily="微软雅黑" fontSize="12" text="项目名称" x="304" y="10"/>
    <mx:Text fontFamily="微软雅黑" fontSize="12" text="所属部门" x="85" y="9"/>
 <mx:ComboBox id="departmentId" dataProvider="{cards}" 
 	x="146" width="150" 
 	color="0x000000" 
 	labelField="departmentName" 
 	y="10" 
 	change="changeHandler(event)" 
 	enabled="true" 
 	editable="true"/>
<mx:TextInput width="150" id="pageNum"  x="365" y="11" change="changeHandler(event)"/>
    
    <mx:RemoteObject id="myservice" destination="provinceService" result="resultHandler(event)"/>
    <mx:RemoteObject id="myProService" destination="provinceService"/>
	<mx:DateFormatter id="FD" formatString="YYYY年MM月DD日" />
	
	<mx:Array id="coffeeArray"> 
<mx:Object label="readsea" data="readsea" /> 
<mx:Object label="readsea1" data="readsea11" /> 
<mx:Object label="readsea2" data="readsea22" /> 
<mx:Object label="readsea3" data="readsea33" /> 
</mx:Array>
	<mx:DataGrid id="mydate" dataProvider="{userInfoList}" height="600" width="100%" fontFamily="微软雅黑" fontSize="12" y="40" editable="true" itemEditEnd="updatePro(event)">
		<mx:columns>
			<mx:DataGridColumn dataField="proId" visible="false" id="proId" editable="false"/>
			<mx:DataGridColumn headerText="项目名称" dataField="proName" editable="false"/>
			<mx:DataGridColumn headerText="客户名称" dataField="customName" editable="false"/>
			<mx:DataGridColumn headerText="项目负责人" dataField="userNamePrincipal" editable="false"/>
			<mx:DataGridColumn headerText="类别" dataField="type" editable="false"/>
			<mx:DataGridColumn headerText="状态" dataField="state" editable="false"/>
			<mx:DataGridColumn headerText="开始日期" dataField="beginTime" labelFunction="formatDate" editable="false"/>
			<mx:DataGridColumn headerText="结束日期" dataField="completeTime" labelFunction="formatDate" editable="false"/>
			<mx:DataGridColumn headerText="实际时长" dataField="atl" editable="false"/>
			<mx:DataGridColumn headerText="总预算" dataField="forecastCost" editable="true"/>
			<mx:DataGridColumn headerText="项目进度" dataField="completePreStr" editorDataField="value" id="jindu" editable="true" >
			<mx:itemEditor>
                <mx:Component>
                    	<mx:ComboBox editable="true" width="100">
                        	<mx:dataProvider>
	                            <mx:String>模型</mx:String>
	                            <mx:String>预演</mx:String>
	                            <mx:String>小样</mx:String>
	                            <mx:String>渲染</mx:String>
	                            <mx:String>后期</mx:String>
                        	</mx:dataProvider>
                    	</mx:ComboBox>
                </mx:Component>
            </mx:itemEditor>
			</mx:DataGridColumn>
			<mx:DataGridColumn headerText="工作量" dataField="commision" editable="false"/>
			<mx:DataGridColumn headerText="任务数量" dataField="taskNum" editable="false"/>
		</mx:columns>
	</mx:DataGrid>
	<mx:Label text="{mydate.selectedItem.proId}" id="huahua"/>
<mx:RemoteObject id="department" destination="myObject" result="closeHandler(event)"/>
</mx:Application>

分享到：