动态扩展平台常用脚本集(共13页)

1、动态(dngti)扩展平台常用脚本集 EAS 产品部产品支持部 白敏 导读(do d) 本文档截取(jiq)了DEP以前项目开发过程中的一些常用功能的脚本实现，可以仿照该实现，快速编写项目中实际的业务逻辑的脚本。 适用对象 DEP扩展脚本开发人员请注意(zh y)：本文件只作为产品(chnpn)介绍(jisho)之用，不属于您与金蝶签署的任何协议。本文件仅包括金蝶既定策略、产品及功能方面的信息，不能以本文件作为要求金蝶履行商务条款、产品策略以及开发义务的依据。本文件内容可能随时变更，恕不另行通知。/客户端在扩展(kuzhn)点提交时给F7控件增加监听器var easNames = JavaIm

2、porter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(P.kingdee.bos);with(easNames)var roadMap = pluginCtx.getKDBizPromptBox(prmtprmtMyRoadMap);roadMap.addPreChangeListener(function()throw new BOSException(路线图不允许(ynx)为空!););/客户端设置(shzh)F7默认值var easImporter = JavaI

3、mporter();easImporter.importPackage(P.kingdee.bos.ctrl.extendcontrols);easImporter.importPackage(Pmon);easImporter.importPackage(P.kingdee.bos.util);easImporter.importPackage(P.kingdee.eas.basedata.assistant);with(easImporter)var prmtCurrency =pluginCtx.getKDBizPromptBox(prmtCurrency);var cur = new

4、CurrencyInfo();cur.setId(BOSUuid.create(DEB58FDC);cur.setNumber(1001);cur.setName(BMD);prmtCurrency.setValue(cur);/服务端更新单据状态var imp = JavaImporter(); imp.importPackage(P.kingdee.eas.util.app); with(imp)var ctx = pluginCtx.getContext();var billId = methodCtx.getParamValue(0);var status = 11;var sql =

5、 update T_SD_SALEORDER SET FBASESTATUS = + status + WHERE FID = +billId+;DbUtil.execute(ctx, sql);methodCtx.setResultValue(java.lang.Boolean.TRUE);/客户端调用(dioyng)服务端方法var easNames = JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(P.kingdee.bos);easNames

6、.importPackage(P.kingdee.bos.util);easNames.importPackage(P.kingdee.bos.metadata);easNames.importPackage(P.kingdee.eas.util.client);easNames.importPackage(P.kingdee.bos.framework);with(easNames)var pk = new MetaDataPK(com.kingdee.eas.scm.sd.sale.app.SaleOrder);var name = java.lang.Boolean updateStat

7、us(com.kingdee.bos.util.BOSUuid billId);var params = BOSUuid.read(2s5eatuISSqb7TuLMfibSMSKQjo=);var result = BOClientTool.callCmethod(pk,name,params);MsgBox.showInfo(Result is: + result);com.kingdee.eas.util.SysUtil.abort();/服务端检查(jinch)编码重复var imp = JavaImporter(); imp.importPackage(P.kingdee.eas.u

8、til.app); imp.importPackage(P.kingdee.bos);with(imp)var ctx = pluginCtx.getContext();var sql = select * from T_SD_SALEORDER WHERE FNumber = SO2007000001;var rowset = DbUtil.executeQuery(ctx, sql);if(rowset.size() 0)throw new BOSException(编码(bin m)重复！);var easNames = JavaImporter();easNames.importPac

9、kage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.util);easNames.importPackage(Pmon.client.helper);with(easNames)var entry = pluginCtx.getKDTable(kdtEntries);var column = entry.getColumn(qty);var format = PrecisionUtil.getFormatString(10);var editor = FormattedEditorFactory.getBigD

10、ecimalCellEditor(10, false);column.setEditor(editor);column.getStyleAttributes().setNumberFormat(format);var imp = JavaImporter(); imp.importPackage(P.kingdee.eas.util.app); with(imp)var ctx = pluginCtx.getContext();var billId = methodCtx.getParamValue(0);var status = 2;var sql = update T_SD_SALEORD

11、ER SET FBASESTATUS = + status + WHERE FID = +billId+;DbUtil.execute(ctx, sql);methodCtx.setsetResultValue(java.lang.Boolean.TRUE);/客户端设置编码(bin m)规则脚本var easNames = JavaImporter();easNames.importPackage(P.kingdee.eas.base.codingrule);with(easNames)var editData = pluginCtx.getDataObject();var bizOrgUn

12、it= pluginCtx.getKDBizPromptBox(prmtSaleOrgUnit).getValue();var number = CodingRuleManagerFactory.getRemoteInstance().getNumber(editData, bizOrgUnit.getId();pluginCtx.getKDTextField(txtNumber).setText(number);/客户端设置销售(xioshu)订单分录数量列背景色为红色，注意该脚本需要为后置脚本才能用var easNames = JavaImporter();easNames.importP

13、ackage(Pmon.client);with(easNames)var entry = pluginCtx.getKDTable(kdtEntries);var column = entry.getColumn(qty).getStyleAttributes().setBackground(java.awt.Color.RED);/客户端设置空间字体(zt)属性var font = new java.awt.Font(SansSerif,java.awt.Font.BOLD,14);pluginCtx.getKDTextField(txtDescription).setFont(font)

14、;/建滔替换物料(w lio)验证var easNames = JavaImporter();easNames.importPackage(Packages.javax.swing);easNames.importPackage(Packages.java.awt);easNames.importPackage(Packages.java.event);easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(P.kingdee.eas.util);easNames.importPackag

15、e(Pmon.constants);easNames.importPackage(P.kingdee.bos.ctrl.kdf.table);with(easNames)var editData = pluginCtx.getDataObject();var detailTable = pluginCtx.getKDTable(detailTable);var prmtMaterial = new KDBizPromptBox();prmtMaterial.setQueryInfo(QueryInfoConstants.MATERIAL_INVENTORY_NO_GROUP);var labe

16、lMaterial = new JLabel(物料);labelMaterial.setLabelFor(prmtMaterial);var prmtAssitAttribute = new KDBizPromptBox();var labelAssitAttribute = new JLabel(辅助属性);labelAssitAttribute.setLabelFor(prmtAssitAttribute);prmtAssitAttribute.setQueryInfo(com.kingdee.eas.basedata.master.material.app.F7AsstAttrValue

17、Query);var pane = new JPanel();pane.border = BorderFactory.createEmptyBorder(30,30,10,30);pane.add(labelMaterial);pane.add(prmtMaterial);pane.add(labelAssitAttribute);pane.add(prmtAssitAttribute);var frame = new easNames.JFrame(替换(t hun)物料);frame.getContentPane().add(pane, BorderLayout.CENTER);frame

18、.addWindowListener(function(event, methodName)if(methodName = windowClosing)frame.setVisible(false);vardetailTable = pluginCtx.getKDTable(detailTable)var selectManager = detailTable.getSelectManager();var selectBlock =selectManager.get();if (selectBlock != null) var rowIndex = selectBlock.getTop();v

19、ar material = prmtMaterial.getValue();var assitAttr = prmtAssitAttribute.getValue();detailTable.getCell(rowIndex,orderMaterial).setValue(material);detailTable.getCell(rowIndex,orderAssitAttribute).setValue(assitAttr););frame.pack();frame.setVisible(true);/服务端更新(gngxn)单据状态var imp = JavaImporter(); im

20、p.importPackage(P.kingdee.eas.util.app); with(imp)var ctx = pluginCtx.getContext();var billId = methodCtx.getParamValue(0);var sql = update CT_SCA_CheckWeightNoteBill SET CFSTATUSID = 2WiVgufPSLmUJJ9rb9F+4b8ogLw= WHERE FNUMBER = 001;DbUtil.execute(ctx, sql);methodCtx.setResultValue(java.lang.Boolean

21、.TRUE);/客户端处理(chl)送货单位var easNames = JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.constants);with(easNames)var prmtDispatch = pluginCtx.getKDBizPromptBox(prmtprmtDispatchUnit);prmtDispatch.setQueryInfo(QueryInfoConstants.SUPPLIER_COMPANY);var e

22、asNames = JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.constants);with(easNames)var editData = pluginCtx.getDataObject();var prmtDispatch = pluginCtx.getKDBizPromptBox(prmtprmtDispatchUnit);var queryInfoOrigin = prmtDispatch.getQueryInfo();if(q

23、ueryInfoOrigin != null)var queryInfo = queryInfoOrigin.replaceAll(,.);if(QueryInfoConstants.SUPPLIER_COMPANY.equals(queryInfo)editData.put(dispatch_Sup,prmtDispatch.getValue();elseeditData.put(dispatch_Org,prmtDispatch.getValue();var easNames = JavaImporter();easNames.importPackage(P.kingdee.bos.ctr

24、l.extendcontrols);easNames.importPackage(Pmon.constants);with(easNames)var editData = pluginCtx.getDataObject();var prmtDispatch = pluginCtx.getKDBizPromptBox(prmtprmtDispatchUnit);var queryInfoOrigin = prmtDispatch.getQueryInfo();if(queryInfoOrigin != null)var queryInfo = queryInfoOrigin.replaceAll

25、(,.);if(QueryInfoConstants.SUPPLIER_COMPANY.equals(queryInfo)prmtDispatch.setValue(editData.get(dispatch_Sup);elseprmtDispatch.setValue(editData.get(dispatch_Org);var easNames = JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.constants);easNames.i

26、mportPackage(P.kingdee.bos);with(easNames)var editData = pluginCtx.getDataObject();var prmtDispatch = pluginCtx.getKDBizPromptBox(prmtprmtDispatchUnit);var queryInfoOrigin = prmtDispatch.getQueryInfo();if(editData.getSourceBillId() = null)throw new BOSException(检斤通知单不允许(ynx)手工新增！);if(editData.get(di

27、spatch_Sup) != null)prmtDispatch.setQueryInfo(QueryInfoConstants.SUPPLIER_COMPANY);prmtDispatch.setValue(editData.get(dispatch_Sup);elseprmtDispatch.setQueryInfo(com.kingdee.eas.fi.arap.app.AdminOrgUnitQuery);prmtDispatch.setValue(editData.get(dispatch_Org);var imp = JavaImporter(); imp.importPackag

28、e(P.kingdee.eas.util.app); with(imp)var ctx = pluginCtx.getContext();var billId = methodCtx.getParamValue(0);var sumQTY = 0;var sql = update T_IM_PurReceivalEntry SET CFSumCheckQTY = .sumQTY. WHERE FNUMBER = qq-2010-03-12-00000626;DbUtil.execute(ctx, sql);methodCtx.setResultValue(java.lang.Boolean.T

29、RUE);/服务端根据物料计划(jhu)页签检查项目号与跟踪号var imp = JavaImporter(); imp.importPackage(P.kingdee.eas.util.app); imp.importPackage(P.kingdee.bos);imp.importPackage(P.kingdee.eas.basedata.master.material);imp.importPackage(P.kingdee.bos.metadata.entity);imp.importPackage(P.kingdee.bos.metadata.query.util);with(im

30、p)var ctx = pluginCtx.getContext();var billInfo = methodCtx.getParamValue(0);var entrys = billInfo.getEntries();var entry = entrys.get(0);var material = entry.getMaterial();var materialId = material.getId();var ev = new EntityViewInfo();var fi = new FilterInfo();fi.getFilterItems().add(new FilterIte

31、mInfo(material.id, materialId, CompareType.EQUALS);ev.setFilter(fi);var iMaterialPlan = MaterialPlanFactory.getLocalInstance(ctx);var materialPlanCol = iMaterialPlan.getMaterialPlanCollection(ev);if(materialPlanCol.size() 0)if(entry.get(myProject) = null & entry.get(myTrack) = null)throw new BOSExce

32、ption(项目号与跟踪(gnzng)号不能同时为空！); /Scm_DynProException需要(xyo)预先定义var easNames = JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(P.kingdee.bos);with(easNames)var prmtCurrency = pluginCtx.getKDBizPromptBox(prmtCurrency);if(prmtCurrency.getValue() = null)com.

33、kingdee.eas.ep.plugin.ExceptionUtil.throwOnClient(Scm_DynProException,ScmCompany);var imp = JavaImporter(); imp.importPackage(P.kingdee.eas.util.app); imp.importPackage(P.kingdee.bos);with(imp)var ctx = pluginCtx.getContext();if(true)throw new BOSException(编码(bin m)重复！);var easNames = JavaImporter()

34、;easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.util);easNames.importPackage(Pmon.client.helper);with(easNames)var pre = pluginCtx.getKDFormattedTextField(txtPrepayment);pre.setPrecision(10);/KDTable加入监听器var swingNames = JavaImporter();swingNames.importPackage(

35、P.kingdee.bos.ctrl.kdf.table.event);swingNames.importPackage(Pmon.client);var tblMain = pluginCtx.getKDTable(kdtEntries);with (swingNames)tblMain.addKDTEditListener(KDTEditListener(this);function editStarting(e)function editStarted(e)var entry = pluginCtx.getKDTable(kdtEntries);var column = entry.ge

36、tColumn(qty).getStyleAttributes().setBackground(java.awt.Color.ORANGE);function editValueChanged(e)function editStopping(e)function editStopped(e)function editCanceled(e)/Scm_DynProException需要预先(yxin)定义var easNames = JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.i

37、mportPackage(P.kingdee.bos);easNames.importPackage(P.kingdee.bos.ui);with(easNames)this.setFocusTraversalPolicy(new com.kingdee.bos.ui.UIFocusTraversalPolicy(new java.awt.Component kDDateLastUpdateTime,prmtLastUpdateUser,kDDateCreateTime,prmtCreator,prmtAuditor,txtDescription,pkBizDate,txtNumber,kdtEntrys);/调用(dioyng)Onload出错var easNames = JavaImporter();easNames.importPackage(Pmon.client);easNames.importPackage(Pmon.util);ea