泛微Ecology9-实现明细表行数据的模糊或精确查询

扫描二维码关注微信，回复密码，即可获取密码

<script>
jQuery(document).ready(function(){
  // alert(123);
	WfForm.registerCheckEvent(WfForm.OPER_SAVE+","+WfForm.OPER_SUBMIT+','+WfForm.OPER_SUBMITCONFIRM, function(callback){
		WfForm.changeFieldValue("field8730", {value:""});
		WfForm.changeFieldValue("field8732", {value:""});
		WfForm.changeFieldValue("field8734", {value:""});
		WfForm.controlDetailRowDisplay("detail_1", "all", false);  
		//继续提交需调用callback，不调用代表阻断
        callback();    
    });
	//添加查询按钮
		jQuery(".searchevent").html("<input type='button'  onclick='searchEvent()' class='ant-btn ant-btn-primary' value='查询'/>"); 
	//添加清空查询按钮
		jQuery(".clearsearch").html("<input type='button'  onclick='clearsearch()' class='ant-btn ant-btn-primary' value='清空查询'/>"); 
	//添加展示所有明细数据按钮
		jQuery(".showall").html("<input type='button'  onclick='showall()' class='ant-btn ant-btn-primary' value='展示所有明细数据'/>"); 
    });
  
	function searchEvent() {
		// 获取查询字段值
		var dhwb_v = WfForm.getFieldValue("field8730");
		var llan_v = WfForm.getFieldValue("field8732");//获取浏览按钮字段的显示值
		var xzk_v = WfForm.getFieldValue("field8734");//获取选择框字段的显示值
		// 查询字段为空时，显示所有明细
		if (dhwb_v == ''&& llan_v==''&& xzk_v=='') {
			WfForm.controlDetailRowDisplay("detail_1", "all", false);
		} else {			
			var rowArr = WfForm.getDetailAllRowIndexStr("detail_1").split(",");
			for (var i = 0; i < rowArr.length; i++) {
				var rowIndex = rowArr[i];
				if (rowIndex !== "") {
					// 遍历明细字段
					var dhwb_mx = WfForm.getFieldValue("field8725_" + rowIndex);
					var llan_mx=WfForm.getFieldValue("field8727_" + rowIndex);
					var xzk_mx=WfForm.getFieldValue("field8729_" + rowIndex);
					var index=0;
					if(dhwb_v=="" || dhwb_mx.indexOf(dhwb_v)>= 0){
					  index++;
					}
					if(llan_v=="" || llan_mx==llan_v){
					  index++;
					}
					if(xzk_v=="" || xzk_mx==xzk_v){
					  index++;
					}
				// 	alert(index)
					if(index<3){
					WfForm.controlDetailRowDisplay("detail_1", rowIndex+"", true)
					}
				}
			}
		}
	}
	function clearsearch() {
		WfForm.changeFieldValue("field8730", {value:""});
		WfForm.changeFieldValue("field8732", {value:""});
		WfForm.changeFieldValue("field8734", {value:""});
		WfForm.controlDetailRowDisplay("detail_1", "all", false);
	}
  	function showall() {
  		WfForm.controlDetailRowDisplay("detail_1", "all", false);  
  	}
</script>