『泛微OA』明细表数据赋值给主表字段

 

功能

本代码通过获取明细表中的字段值,并将其凭借成一个以逗号来分隔的字符串。然后将这个字符串赋值给主表的一个字段。

代码还绑定了一个明细字段的提交事件,当明细字段的值发生变化时,会重新获取字段值,并更新主表字段的值。

代码

<script type="text/javascript">
$(function(){
	var rowArr = WfForm.getDetailAllRowIndexStr("detail_1").split(",");//遍历明细行
	var mess = '-1';
	if(rowArr.length > 0){
		for(var i=0; i<rowArr.length; i++){
			var rowIndex = rowArr[i];
			if(rowIndex != ''){
				var thisDataSourceID = WfForm.getFieldValue("field10979_" + rowIndex);//明细表字段ID
				if(thisDataSourceID != ''){
					mess = mess + ',' + thisDataSourceID;  //遍历明细字段
				}
			}			
		}
	}
	WfForm.changeFieldValue("field10980", {value:mess});  //主表字段ID
});
	WfForm.bindDetailFieldChangeEvent("field10979",function(id,rowIndex,value){
		var rowArr = WfForm.getDetailAllRowIndexStr("detail_1").split(",");
		var mess = '-1';
		if(rowArr.length > 0){
			for(var i=0; i<rowArr.length; i++){
				var rowIndex = rowArr[i];
				if(rowIndex != ''){
					var thisDataSourceID = WfForm.getFieldValue("field10979_" + rowIndex);
					if(thisDataSourceID != ''){
						mess = mess + ',' + thisDataSourceID;
					}
				}			
			}
		}
		WfForm.changeFieldValue("field10980", {value:mess});
	});
</script>

 

阅读剩余
THE END