EAS-DEP常用脚本模板.docx
EAS-DEP 常用脚本模板1. 转变工具栏中按钮的状态with(easNames)var auditAction = pluginCtx.getUI.getActionManager.getAction(“actionBtnAssign“); auditAction.setEnabled(false);/禁用工具栏按钮auditAction.setVisible(false);/隐蔽工具栏按钮注：取工具栏中的按钮，取其对应的功能即可，区分大小写2. 转变分录右上角的按钮的状态with(easNames)var controlPanel = pluginCtx.getKDTable(“kdtEntry“).getParent.getParent.getComponent(0); MsgBox.showWarning(controlPanel.getComponentCount);for(var i = 1; i < controlPanel.getComponentCount; i+) controlPanel.getComponent(i).setEnabled(false);注：想转变具体的按钮状态，将i 改成具体的数字即可资料参考： :/3. 依据选中列表行的状态转变工具栏按钮的状态pluginCtx.getKDTable(“tblMain“).addKDTActiveCellListener( function(afterSelectLine,methodName)/对选中行之后的事情进展监听with(easNames)var entry = pluginCtx.getKDTable(“tblMain“);var baseStatus = SCMClientUtils.getSelectRowFieldValue(entry,“status“);var auditAction = pluginCtx.getUI.getActionManager.getAction(“actionRemove“); auditAction.setEnabled(false);if(“已保存“.equals(baseStatus0) auditAction.setEnabled(true););注：假设想猎取多行，则加 for 循环，baseStatus0baseStatusi4. 把握代办效劳单，上牌备注不能为空var easImporter = JavaImporter;easImporter.importPackage(Packages .kingdee.bos); easImporter.importPackage(Packages .kingdee.eas.util); easImporter.importPackage(Packages .kingdee.eas.util.client); with(easImporter)var txtCause = pluginCtx.getKDTextArea(“txtHangtagRemark“);/取上牌备注控件值/把握分录字段为必录项if(txtCause.getText.equals(“)/推断取值条件MsgBox.showInfo(“<上牌备注不能为空>“); SysUtil.abort;5. 把握代办调整单审核后可调整分录var easNames = JavaImporter;easNames.importPackage(Packages .kingdee.bos.ctrl.swing); easNames.importPackage(Packages.java.math); easNames.importPackage(Packages .kingdee.eas.scm mon.client); easNames.importPackage(Packages .kingdee.eas.util.client); easNames.importPackage(Packages .kingdee.bos.util); easNames.importPackage(Packages .kingdee.eas.scm.im.dt); easNames.importPackage(Packages .kingdee.eas.scm mon.client); easNames.importPackage(Packages .kingdee.bos.metadata); easNames.importPackage(Packages .kingdee.bos.ctrl.extendcontrols); easNames.importPackage(Packages .kingdee.bos.util); easNames.importPackage(Packages .kingdee.bos.metadata); easNames.importPackage(Packages .kingdee.bos.framework); easNames.importPackage(Packages .kingdee.bos.ctrl.extendcontrols); easNames.importPackage(Packages .kingdee.bos.util); easNames.importPackage(Packages .kingdee.eas.util); with(easNames)var kdtEntrys = pluginCtx.getKDTable(“kdtEntrys“);var controlPanel = pluginCtx.getKDTable(“kdtEntrys“).getParent.getParent.getComponent(0);/定义分录按钮/取当前用户var user=pluginCtx.getUIContext.get(“sysContext“).getCurrentUserInfo;/当前组织 getCurrentCtrlUnitvar company = pluginCtx.getUIContext.get(“sysContext“).getCurrentFIUnit;/指定人员可编辑if(user.getPerson=”XXX”) MsgBox.showWarning(user.getPerson); MsgBox.showWarning(company);kdtEntrys.getColumn(“AgentItem“).getStyleAttributes.setLocked(false); kdtEntrys.getColumn(“PreReceiveAmount“).getStyleAttributes.setLocked(false);controlPanel.getComponent(1).setEnabled(true); controlPanel.getComponent(2).setEnabled(true); controlPanel.getComponent(3).setEnabled(true);6. 整车库存配车屏蔽var easNames = JavaImporter; easNames.importPackage(Packages .kingdee.bos.ctrl.swing); easNames.importPackage(Packages.java.math); easNames.importPackage(Packages .kingdee.eas.scm mon.client); easNames.importPackage(Packages .kingdee.eas.util.client); easNames.importPackage(Packages .kingdee.bos.util);easNames.importPackage(Packages .kingdee.eas.scm.im.dt); easNames.importPackage(Packages .kingdee.eas.scm mon.client); easNames.importPackage(Packages .kingdee.bos.metadata); easNames.importPackage(Packages .kingdee.bos.ctrl.extendcontrols); easNames.importPackage(Packages .kingdee.bos.util); easNames.importPackage(Packages .kingdee.bos.metadata); easNames.importPackage(Packages .kingdee.bos.framework); easNames.importPackage(Packages .kingdee.bos.ctrl.extendcontrols); easNames.importPackage(Packages .kingdee.bos.util); easNames.importPackage(Packages .kingdee.eas.util); with(easNames)var auditAction = pluginCtx.getUI.getActionManager.getAction(“actionDecorationOrderAlter“);auditAction.setEnabled(false);7. 把握分录字段不能为空整车销售订单分录为例 var easImporter = JavaImporter; easImporter.importPackage(Packages .kingdee.bos); easImporter.importPackage(Packages .kingdee.eas.util);easImporter.importPackage(Packages .kingdee.eas.util.client); with(easImporter)var kdtEntrys = pluginCtx.getKDTable(“kdtEntrys“); if(kdtEntrys.getRow(0).getCell(“Color“).getValue=null)/推断字段条件MsgBox.showInfo(“<整车订单分录颜色不能为空>“);SysUtil.abort;if(kdtEntrys.getRow(0).getCell(“SubscriptionAmount“).getValue<=0)MsgBox.showInfo(“<订金不能为 0>“); SysUtil.abort;8. 把握整车订单已出库已开票不能做订单变更var easImporter = JavaImporter; easImporter.importPackage(Packages .kingdee.bos); easImporter.importPackage(Packages .kingdee.eas.util); easImporter.importPackage(Packages .kingdee.eas.util.client); with(easImporter)var kdtEntrys = pluginCtx.getKDTable(“kdtEntrys“); if(kdtEntrys.getRow(0).getCell(“TotalIssueQty“).getValue>0) MsgBox.showInfo(“<当前单据已生成整车销售出库单，不能进展变更操作，请反审核删除整车销售出库单！>“);SysUtil.abort;if(kdtEntrys.getRow(0).getCell(“TotalInvoiceAmount“).getValue>0) MsgBox.showInfo(“<当前单据已开票，不能进展变更操作，请反审核删除开票登记单！>“);SysUtil.abort;9. 把握 依据精品销售单类型把握分录字段var easImporter = JavaImporter; easImporter.importPackage(Packages .kingdee.bos); easImporter.importPackage(Packages .kingdee.eas.util); easImporter.importPackage(Packages .kingdee.eas.util.client); with(easImporter)var saletype=pluginCtx.getKDBizPromptBox(“prmtdecorationSaleType“); var kdtEntrys = pluginCtx.getKDTable(“kdtEntry“);var rowCount = kdtEntrys.getRowCount;for(var i = 0;i<rowCount;i+) if(saletype.getValue=”整车现金销售” &&kdtEntrys.getRow(i).getCell(“IsApyGifts“).getValue=1)MsgBox.showInfo(“销售类型为整车现金销售，分录随车赠品不能勾选“); SysUtil.abort;if(saletype.getValue=”整车赠送” && kdtEntrys.getRow(i).getCell(“discountRate“).getValue>0)MsgBox.showInfo(“销售类型为整车赠送，分录折扣率或折扣额不能填“); SysUtil.abort;if(saletype.getValue=”整车赠送” && kdtEntrys.getRow(i).getCell(“favorAmount“).getValue=0)MsgBox.showInfo(“销售类型为整车赠送，分录随车金额不能为空！“); SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“taxPrice“).getValue=0)MsgBox.showInfo(“分录精品含税单价不能为O“); SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“discountRate“).getValue>55 &&saletype.getValue=”整车现金销售”)MsgBox.showInfo(“折扣率不能大于 5.5 折“); SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“discountRate“).getValue>55 &&saletype.getValue=”售后销售”)MsgBox.showInfo(“折扣率不能大于 5.5 折“); SysUtil.abort;10. 把握整车销售出库分录的源单类型不能为空var easImporter = JavaImporter; easImporter.importPackage(Packages .kingdee.bos); easImporter.importPackage(Packages .kingdee.eas.util);easImporter.importPackage(Packages .kingdee.eas.util.client); with(easImporter)var kdtEntry = pluginCtx.getKDTable(“detailTable“);/把握分录字段源单类型不能为空if(kdtEntry.getRow(0).getCell(“coreBillType“).getValue=null)MsgBox.showInfo(“<分录源单类型不能为空，不能保存！请关联单据出库！>“); SysUtil.abort;if(kdtEntry.getRow(0).getCell(“ys“).getValue>kdtEntry.getRow(0).getCell(“ysk“).getValue& &kdtEntry.getRow(0).getCell(“remark“).getValue=”整车赠送”)MsgBox.showInfo(“精品销售单应收小于已收，不能出库，请收款后再作出库！>“); SysUtil.abort;if(kdtEntry.getRow(0).getCell(“ys“).getValue>kdtEntry.getRow(0).getCell(“ysk“).getValue& &kdtEntry.getRow(0).getCell(“remark“).getValue=”整车现金销售”)MsgBox.showInfo(“精品销售单应收小于已收，不能出库，请收款后再作出库！>“); SysUtil.abort;11. 把握整车调拨单调出调入公司不能一样var easImporter = JavaImporter; easImporter.importPackage(Packages .kingdee.bos); easImporter.importPackage(Packages .kingdee.eas.util); easImporter.importPackage(Packages .kingdee.eas.util.client); with(easImporter)var outcompany = pluginCtx.getKDBizPromptBox(“prmtoutOrgUnit“).getValue.tostring;/取调出控件值var incompany = pluginCtx.getKDBizPromptBox(“prmtinOrgUnit“).getValue.tostring;/取调入控件值if(outcompany=incompany)MsgBox.showInfo(“<调出公司与调入公司不能一样！请重修改提交！>“); SysUtil.abort;12. 整车价格特批设置/*var easImporter = JavaImporter; easImporter.importPackage(Packages .kingdee.bos); easImporter.importPackage(Packages .kingdee.eas.util); easImporter.importPackage(Packages .kingdee.eas.util.client); easImporter.importPackage(Packages.java.lang); with(easImporter)var kdtEntrys = pluginCtx.getKDTable(“kdtEntrys“); var rowCount = kdtEntrys.getRowCount;var p1 = 0.0;/整车优待var p2 = 0.0;/精品优待var p3 = 0.0;/裸车总额度var p4 = 0.0;/整车加装优待var p5 = 0.0;/精品加装优待var p6 = 0.0;/加装总额度for(var i = 0;i<rowCount;i+) if(kdtEntrys.getRow(i).getCell(“VehicleDiscount“)!=null&& (kdtEntrys.getRow(i).getCell(“VehicleDiscount“).getValue=null| kdtEntrys.getRow(i).getCell(“VehicleDiscount“).getValue.equals(“) MsgBox.showInfo(“整车优待金额不能为空“);SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“DecorateDiscount“)!=null&& (kdtEntrys.getRow(i).getCell(“DecorateDiscount“).getValue=null| kdtEntrys.getRow(i).getCell(“DecorateDiscount“).getValue.equals(“)MsgBox.showInfo(“精品优待金额不能为空“); SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“totalNullAmount“)!=null&& (kdtEntrys.getRow(i).getCell(“totalNullAmount“).getValue=null| kdtEntrys.getRow(i).getCell(“totalNullAmount“).getValue.equals(“)MsgBox.showInfo(“裸车总特批额度不能为空“); SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“markupCtrl“)!=null&& (kdtEntrys.getRow(i).getCell(“markupCtrl“).getValue=null| kdtEntrys.getRow(i).getCell(“markupCtrl“).getValue.equals(“)MsgBox.showInfo(“整车加装优待金额不能为空“); SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“decorateAddDiscount“)!=null&& (kdtEntrys.getRow(i).getCell(“decorateAddDiscount“).getValue=null| kdtEntrys.getRow(i).getCell(“decorateAddDiscount“).getValue.equals(“)MsgBox.showInfo(“精品加装优待金额不能为空“); SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“totalAddAmount“)!=null&& (kdtEntrys.getRow(i).getCell(“totalAddAmount“).getValue=null| kdtEntrys.getRow(i).getCell(“totalAddAmount“).getValue.equals(“)MsgBox.showInfo(“加装车总特批额度不能为空“); SysUtil.abort;p1 = (Double)(kdtEntrys.getRow(i).getCell(“VehicleDiscount“).getValue);p2=(Double)(kdtEntrys.getRow(i).getCell(“DecorateDiscount“).getValue);p3=(Double)(kdtEntrys.getRow(i).getCell(“totalNullAmount“).getValue);p4=(Double)(kdtEntrys.getRow(i).getCell(“markupCtrl“).getValue);p5=(Double)(kdtEntrys.getRow(i).getCell(“decorateAddDiscount“).getValue);p6=(Double)(kdtEntrys.getRow(i).getCell(“totalAddAmount“).getValue);var p12 = p1.doubleValue + p2.doubleValue; if(p12 > p3)MsgBox.showInfo(“”整车特批额度”和”精品特批额度”之和不能大于”裸车总特批额度”“); SysUtil.abort;if(p2 < p3 * 0.3)MsgBox.showInfo(“”精品特批额度”不能小于”裸车总特批额度”的 30%“); SysUtil.abort;var p45 = p4.doubleValue + p5.doubleValue; if(p45 > p6)MsgBox.showInfo(“”整车加装特批额度”和”精品加装特批额度”之和不能大于”加装车总特批额度”“);SysUtil.abort;if(p5 < p6 * 0.3)MsgBox.showInfo(“”精品加装特批额度”不能小于”加装车总特批额度”的 30%“); SysUtil.abort;*/13. 客户端调用效劳端方法自定义方法脚本：var easImporter = JavaImporter; easImporter.importPackage(Packages.java.math); easImporter.importPackage(Packages .kingdee.bos.util); easImporter.importPackage(Packages .kingdee.eas.util); easImporter.importPackage(Packages .kingdee.eas.util.app); easImporter.importPackage(Packages .kingdee.bos.dao.ormapping); easImporter.importPackage(Packages .kingdee.eas.basedata.scm mon); easImporter.importPackage(Packages .kingdee.eas.basedata.master.material);/加载包，可直接拷贝with(easImporter)var ctx = pluginCtx.getContext;/获得上下文。var fn = methodCtx.getParamValue(0);/获得参数的方式。此参数是个数组。留意个数。var sql = “select fvin from T_ATS_AutoPurOrderEntry where fvin = ”“ + fn + “” and rownum =1“;/SQL取值var cc=com.kingdee.eas.util.app.DbUtil.executeQuery(ctx, sql); /执行，并返回结果值if(cc.next)/从 irowset 中取数varvalue1 = cc.getString(1);methodCtx.setResultValue(value1);/返回值的方法。客户端调用：var easNames = JavaImporter; easNames.importPackage(Packages .kingdee.bos.ctrl.extendcontrols); easNames.importPackage(Packages .kingdee.bos.util); easNames.importPackage(Packages .kingdee.bos.metadata); easNames.importPackage(Packages .kingdee.bos.framework); easNames.importPackage(Packages .kingdee.eas.util.client); easNames.importPackage(Packages.java.math); easNames.importPackage(Packages .kingdee.eas.util.app); easNames.importPackage(Packages .kingdee.eas.ec.contract.sub); easNames.importPackage(Packages .kingdee.eas mon.client); easNames.importPackage(Packages .kingdee.eas.scm mon.util); easNames.importPackage(Packages .kingdee.bos.ui.face); with(easNames)var kdtEntrys=pluginCtx.getKDTable(“kdtEntrys“);var rowCount = kdtEntrys.getRowCount; for(var i=0;i<rowCount;i+)var pv=kdtEntrys.getRow(i).getCell(“vin“);/循环取分录车架号var arg1=pv.getValue.toString;var pk = new MetaDataPK(“com.kingdee.eas.auto4s.vm.vp.app.AutoPurOrder“); var name = “String getvin(String arg1)“;var params = arg1;var result = BOClientTool.callCmethod(pk,name,params);/接收业务方法返回的值if(result!=“undefined“)com.kingdee.eas.util.client.MsgBox.showInfo(“第“+(i+1)+“行“+“VIN:“+pv.getValue+“车辆已存在“); com.kingdee.eas.util.SysUtil.abort;if(kdtEntrys.getRow(i).getCell(“payWay“).getValue = null) MsgBox.showError(“付款方式不能为空“); com.kingdee.eas.util.SysUtil.abort;14. 转变列值，值更公式：var table = pluginCtx.getKDTable(“kdtEntry“); table.addKDTPropertyChangeListener(function(event,methodName)if(methodName = “equals“)return this =event;if(methodName = “propertyChange“) if (event.getType =com.kingdee.bos.ctrl.kdf.table.KDTStyleConstants.BODY_ROW) && (event.getPropertyName= “cellValue“)var curRow =table.getRow(event.getRowIndex); var colName=table.getColumn(event.getColIndex).getKey;/假设当前列为物料if(“material“=colName)var material = curRow.getCell(“material“).getValue;/库存组织var sou = pluginCtx.getKDBizPromptBox (“prmtstorageOrgUnit“).getValue;/财务组织var cou =com.kingdee.eas.scm.im.inv.client.InvClientUtils.getCompanyInfo(sou);/依据物料和财务组织，取单位标准本钱var cost =com.kingdee.eas.scm.im.inv.client.InvClientUtils.getUnitStandardCost (material,cou);curRow.getCell(“unitStandardCost“).setValue(cost);/单数量列转变时，计算标准本钱if(“qty“=colName)var unitcost = curRow.getCell (“unitStandardCost“).getValue;var qty= curRow.getCell(“qty“).getValue; var cost=qty*unitcost;curRow.getCell(“standardCost“).setValue(cost);if(“ManHour“=colName|“recievePayAmount“=colName|“favorAmount“=colName|“IsApyGi fts“=colName)var ManHour= curRow.getCell(“ManHour“).getValue;var recie
