//弹框
_self.showWarning("请先填写实付金额");
console.log("跳转的id:"+billIds);//弹选择框
waf.msgBox.showConfirm({title: "信息提示",summaryMsg: "是否删除",buttonType: "yes-no",buttonCallBack: [function () {console.log("是");},function () {console.log("否");}]
});//脚本中方法之间调用 
_private.selectSourceBillId();//获取id
var model = _self.getCurrentModel();//设置值
1、var su = $("#list2").wafGrid('addRow',{data:datarow});
2、waf("#id").wafText("setValue", "this is a demo!");
//设置值:分录指定行
1、$("#entrys").wafGrid("setCell",rowid,"ywy",ywy2[0]);
2、分录指定行清空
$("#editGrid2").wafGrid("setCell",rowid2,"fundFlowItem",null);
//获取Model值
var sourceBillId =_self.getCurrentModel().entrys[0].sourceBillId;
//获取控件值
var text = waf("#text").wafText("getValue");
//获取分录所有数据
var ret = waf("#ext_editgrid1").wafGrid("getAllRowData"); 
//获取行id
var rowId = waf("#entrys").wafGrid("getRowId", 0);//隐藏按钮
waf("#synchronousApprove_btn").wafLinkButton("option","disabled",true);
document.getElementById('labelaccountCussentTypeEnum').style.visibility = 'visible';
document.getElementById('labelaccountCussentTypeEnum').style.visibility = 'hidden';//隐藏复选框
waf("#ext_isFgs").wafCheckbox("option","hidden",true); //批量隐藏分录$("#list2").wafGrid("hideColumn","amount",true);
//批量显示分录$("#list2").wafGrid("showColumn ","amount",true);//控件不可编辑
waf("#id").wafLinkButton("option","editable ",false);//不可编辑,指定某行不可编辑
var rowId = waf("#entrys").wafGrid("getRowId", (i + 1));
var claimAmountConfig = waf("#entrys").wafGrid("getCellConfig", "claimAmount", rowId);
claimAmountConfig.editable = false;
waf("#entrys").wafGrid("changeCellConfig", rowId, "claimAmount", claimAmountConfig);//刷新表格
var cuGridDom = waf("#queryGrid");
cuGridDom.dataGrid("reloadGrid");  //清空分录var ret = waf("#list2").wafGrid("clearGridData",true);//关闭窗口
waf.window.close();//分录过滤//自定义辅助项目过滤非“其他应付项目”var ret = waf("#ext_editgrid1").wafGrid("getAllRowData");var colConfig = waf("#entrys").wafGrid("getCellConfig", "qtyfxm", rowid).editoptions;for (var i = 0; i < ret; i++) {var rowId = waf("#entrys").wafGrid("getRowId", i);colConfig.subTagJson.filteritem = waf.parseSql.getFilter("group.number", "=", "14");waf("#entrys").wafGrid("setCellConfig", "qtyfxm", "editoptions", colConfig, rowId);}//分录某字段统一过滤PS:收款认领单编辑界面
查询过滤条件:group.number='14'//值改变,分录值改变见下图在该文档最下面获取分录数据
var allRowData = waf("#ext_editgrid").wafGrid('getAllRowData');
var endorseno = "";
var amount = 0;
for(var i = 0; i < allRowData.length; i++){endorseno = endorseno+allRowData[i].endorseno+",";amount = amount+allRowData[i].amount;
}获取当前选中行数据
var gridCol = waf("#editgrid").getSelectedRows();
var ret = jQuery('#editgrid').wafGrid('getRowRealData', gridCol);
alert("当前选中的是:"+ret);后台GetBillEntryAmount,访问数据库
var imp=JavaImporter();
imp.importPackage(Packages.com.kingdee.eas.custom);
imp.importPackage(Packages.java.lang);
imp.importPackage(Packages.org.apache.commons.lang3);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.webframework.context);
imp.importPackage(Packages.com.kingdee.eas.base.permission);
imp.importPackage(Packages.com.kingdee.eas.common);
imp.importPackage(Packages.com.kingdee.eas.basedata.org);
imp.importPackage(Packages.javax.servlet.http);
imp.importPackage(Packages.com.kingdee.eas.util.app);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.dao.ormapping);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.eas.ep);
imp.importPackage(Packages.com.kingdee.bos.metadata);
imp.importPackage(Packages.com.kingdee.bos.util);
imp.importPackage(Packages.com.kingdee.eas.basedata.person);
imp.importPackage(Packages.com.kingdee.bos.webframework.exception);
imp.importPackage(Packages.com.kingdee.bos.webframework.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.application);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.event.view);
imp.importPackage(Packages.com.kingdee.bos.webframework.json);
imp.importPackage(Packages.java.util);
imp.importPackage(Packages.com.alibaba.fastjson);
imp.importPackage(Packages.java.math);
imp.importPackage(Packages.org.apache.log4j);with(imp){var logger = Logger.getLogger("getPaymentBillEntryAmount");var request = kdevent.getReqeustContext().getHttpServletRequest();var billNumber = request.getParameter("billNumber");var sumAmount = request.getParameter("sumAmount");var id = request.getParameter("mode");var zero = new BigDecimal("0");var ctx = WafContext.getInstance().getContext();var sqlTwo="";var sql ="";//查询var rowSet = DbUtil.executeQuery(ctx, sql);var array = new JSONArray();while(rowSet.next()){var corebillNumber = rowSet.getString("FCOREBILLNUMBER");var bgctrlamt = rowSet.getBigDecimal("sum(b.FAMOUNT)");}JSONUtils.SUCCESS(array.toJSONString());//修改if(id != null && id != ""){var sql ="DELETE FROM CT_CAS_endorseEntry WHERE  FPARENTID ='"+id+"' and CFAMOUNT is null  and CFENDORSENO is null and CFTICKETID is null and CFTICKETSTYLE is null and CFTICKETDATE is null and CFTICKETUSER is null and CFTICKETBANK is null";DbUtil.execute(ctx, sql);  }  }脚本调用上面后台GetBillEntryAmount
waf.doPost({action: "GetBillEntryAmount",data:{billNumber:billNumber,sumAmount:sumAmount,mode:mode},async: false,success:function(result){for(var i = 0; i < result.length; i++){var coreBillEntryId = result[i].coreBillEntryId;var corebillNumber = result[i].corebillNumber;var bgctrlamt = result[i].bgctrlamt;}}
});var imp=JavaImporter();
imp.importPackage(Packages.com.kingdee.eas.custom);
imp.importPackage(Packages.java.lang);
imp.importPackage(Packages.org.apache.commons.lang3);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.webframework.context);
imp.importPackage(Packages.com.kingdee.eas.base.permission);
imp.importPackage(Packages.com.kingdee.eas.common);
imp.importPackage(Packages.com.kingdee.eas.basedata.org);
imp.importPackage(Packages.javax.servlet.http);
imp.importPackage(Packages.com.kingdee.eas.util.app);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.dao.ormapping);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.metadata);
imp.importPackage(Packages.com.kingdee.bos.util);
imp.importPackage(Packages.com.kingdee.bos.metadata.query.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.exception);
imp.importPackage(Packages.com.kingdee.bos.webframework.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.application);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.event.view);
imp.importPackage(Packages.java.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.json);
imp.importPackage(Packages.com.alibaba.fastjson);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.metadata.entity);with(imp){var ctx = WafContext.getInstance().getContext();var view = new  EntityViewInfo();var coll=new SelectorItemCollection();coll.add(new SelectorItemInfo("id"));coll.add(new SelectorItemInfo("name"));coll.add(new SelectorItemInfo("number"));view.setSelector(coll);var filterInfo = new FilterInfo();var filterItemInfo = new FilterItemInfo("name","费用共享类型",CompareType.EQUALS);filterInfo.getFilterItems().add(filterItemInfo);view.setFilter(filterInfo);var col = com.kingdee.eas.custom.prpayment.PaymentTypeFactory.getLocalInstance(ctx).getPaymentTypeCollection(view);JSONUtils.SUCCESS(col);
}var imp=JavaImporter();
imp.importPackage(Packages.com.kingdee.eas.custom);
imp.importPackage(Packages.java.lang);
imp.importPackage(Packages.org.apache.commons.lang3);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.webframework.context);
imp.importPackage(Packages.com.kingdee.eas.base.permission);
imp.importPackage(Packages.com.kingdee.eas.common);
imp.importPackage(Packages.com.kingdee.eas.basedata.org);
imp.importPackage(Packages.javax.servlet.http);
imp.importPackage(Packages.com.kingdee.eas.util.app);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.dao.ormapping);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.metadata);
imp.importPackage(Packages.com.kingdee.bos.util);
imp.importPackage(Packages.com.kingdee.bos.metadata.query.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.exception);
imp.importPackage(Packages.com.kingdee.bos.webframework.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.application);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.event.view);
imp.importPackage(Packages.java.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.json);
imp.importPackage(Packages.com.alibaba.fastjson);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.metadata.entity);with(imp){var ctx = WafContext.getInstance().getContext();var request = kdevent.getReqeustContext().getHttpServletRequest();var paymentId = request.getParameter("paymentId");var paymentBillInfo =com.kingdee.eas.fi.cas.PaymentBillFactory.getLocalInstance(ctx).getPaymentBillInfo(new com.kingdee.bos.dao.ormapping.ObjectUuidPK(paymentId));var req = com.kingdee.eas.custom.fundplan.FundplanFacadeFactory.getLocalInstance(ctx).closingRemindPaymentBill(paymentBillInfo);JSONUtils.SUCCESS(req);
}
web监听(值改变)

分录值改变

web端设置导出





















