動態擴展平臺常用腳本集EAS產品部產品支持部白敏導讀本文檔截取了DEP以前項目開發過程中的一些常用功能的腳本實現，可以仿照該實現，快速編寫項目中實際的業務邏輯的腳本。適用對象DEP擴展腳本開發人員請注意：本文件只作為產品介紹之用，不屬于您與金蝶簽署的任何協議。本文件僅包括金蝶既定策略、產品及功能方面的信息，不能以本文件作為要求金蝶履行商務條款、產品策略以及開發義務的依據。本文件內容可能隨時變更，恕不另行通知。//客戶端在擴展點提交時給F7控件增加監聽器vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(P.kingdee.bos);with(easNames){varroadMap=pluginCtx.getKDBizPromptBox("prmtprmtMyRoadMap");roadMap.addPreChangeListener(function(){ thrownewBOSException("路線圖不允許為空!");});}//客戶端設置F7默認值vareasImporter=JavaImporter();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){varprmtCurrency=pluginCtx.getKDBizPromptBox("prmtCurrency");varcur=newCurrencyInfo();cur.setId(BOSUuid.create("DEB58FDC"));cur.setNumber("1001");cur.setName("BMD");prmtCurrency.setValue(cur);} //服務端更新單據狀態varimp=JavaImporter();imp.importPackage(P.kingdee.eas.util.app);with(imp){varctx=pluginCtx.getContext();varbillId=methodCtx.getParamValue(0);varstatus=11;varsql="updateT_SD_SALEORDERSETFBASESTATUS="+status+"WHEREFID='"+billId+"'";DbUtil.execute(ctx,sql);methodCtx.setResultValue(java.lang.Boolean.TRUE);}//客戶端調用服務端方法vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(P.kingdee.bos);easNames.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){ varpk=newMetaDataPK("com.kingdee.eas.scm.sd.sale.app.SaleOrder"); varname="java.lang.BooleanupdateStatus(com.kingdee.bos.util.BOSUuidbillId)"; varparams=[BOSUuid.read("2s5eatuISSqb7TuLMfibSMSKQjo=")]; varresult=BOClientTool.callCmethod(pk,name,params); MsgBox.showInfo("Resultis:"+result); com.kingdee.eas.util.SysUtil.abort();}//服務端檢查編碼重復varimp=JavaImporter();imp.importPackage(P.kingdee.eas.util.app);imp.importPackage(P.kingdee.bos);with(imp){varctx=pluginCtx.getContext();varsql="select*fromT_SD_SALEORDERWHEREFNumber='SO2007000001'";varrowset=DbUtil.executeQuery(ctx,sql);if(rowset.size()>0){thrownewBOSException("編碼重復！"); }}vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.util);easNames.importPackage(Pmon.client.helper);with(easNames){varentry=pluginCtx.getKDTable("kdtEntries");varcolumn=entry.getColumn("qty");varformat=PrecisionUtil.getFormatString(10);vareditor=FormattedEditorFactory.getBigDecimalCellEditor(10,false);column.setEditor(editor);column.getStyleAttributes().setNumberFormat(format);}varimp=JavaImporter();imp.importPackage(P.kingdee.eas.util.app);with(imp){varctx=pluginCtx.getContext();varbillId=methodCtx.getParamValue(0);varstatus=2;varsql="updateT_SD_SALEORDERSETFBASESTATUS="+status+"WHEREFID='"+billId+"'";DbUtil.execute(ctx,sql);methodCtx.setsetResultValue(java.lang.Boolean.TRUE);}//客戶端設置編碼規則腳本vareasNames=JavaImporter();easNames.importPackage(P.kingdee.eas.base.codingrule);with(easNames){vareditData=pluginCtx.getDataObject();varbizOrgUnit=pluginCtx.getKDBizPromptBox("prmtSaleOrgUnit").getValue();varnumber=CodingRuleManagerFactory.getRemoteInstance().getNumber(editData,bizOrgUnit.getId());pluginCtx.getKDTextField("txtNumber").setText(number);}//客戶端設置銷售訂單分錄數量列背景色為紅色，注意該腳本需要為后置腳本才能用vareasNames=JavaImporter();easNames.importPackage(Pmon.client);with(easNames){varentry=pluginCtx.getKDTable("kdtEntries");varcolumn=entry.getColumn("qty").getStyleAttributes().setBackground(java.awt.Color.RED);}//客戶端設置空間字體屬性varfont=newjava.awt.Font("SansSerif",java.awt.Font.BOLD,14);pluginCtx.getKDTextField("txtDescription").setFont(font);//建滔替換物料驗證vareasNames=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.importPackage(Pmon.constants);easNames.importPackage(P.kingdee.bos.ctrl.kdf.table);with(easNames){vareditData=pluginCtx.getDataObject();vardetailTable=pluginCtx.getKDTable("detailTable");varprmtMaterial=newKDBizPromptBox();prmtMaterial.setQueryInfo(QueryInfoConstants.MATERIAL_INVENTORY_NO_GROUP);varlabelMaterial=newJLabel("物料");labelMaterial.setLabelFor(prmtMaterial);varprmtAssitAttribute=newKDBizPromptBox();varlabelAssitAttribute=newJLabel("輔助屬性");labelAssitAttribute.setLabelFor(prmtAssitAttribute);prmtAssitAttribute.setQueryInfo("com.kingdee.eas.basedata.master.material.app.F7AsstAttrValueQuery");varpane=newJPanel();pane.border=BorderFactory.createEmptyBorder(30,30,10,30);pane.add(labelMaterial);pane.add(prmtMaterial);pane.add(labelAssitAttribute);pane.add(prmtAssitAttribute);varframe=neweasNames.JFrame("替換物料");frame.getContentPane().add(pane,BorderLayout.CENTER);frame.addWindowListener(function(event,methodName){ if(methodName=="windowClosing"){ frame.setVisible(false); var detailTable=pluginCtx.getKDTable("detailTable") varselectManager=detailTable.getSelectManager(); varselectBlock=selectManager.get(); if(selectBlock!=null){ varrowIndex=selectBlock.getTop(); varmaterial=prmtMaterial.getValue(); varassitAttr=prmtAssitAttribute.getValue(); detailTable.getCell(rowIndex,"orderMaterial").setValue(material); detailTable.getCell(rowIndex,"orderAssitAttribute").setValue(assitAttr); } }});frame.pack();frame.setVisible(true);}//服務端更新單據狀態varimp=JavaImporter();imp.importPackage(P.kingdee.eas.util.app);with(imp){varctx=pluginCtx.getContext();varbillId=methodCtx.getParamValue(0);varsql="updateCT_SCA_CheckWeightNoteBillSETCFSTATUSID='2WiVgufPSLmUJJ9rb9F+4b8ogLw='WHEREFNUMBER='001'";DbUtil.execute(ctx,sql);methodCtx.setResultValue(java.lang.Boolean.TRUE);}//客戶端處理送貨單位vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.constants);with(easNames){ varprmtDispatch=pluginCtx.getKDBizPromptBox("prmtprmtDispatchUnit"); prmtDispatch.setQueryInfo(QueryInfoConstants.SUPPLIER_COMPANY);}vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.constants);with(easNames){ vareditData=pluginCtx.getDataObject(); varprmtDispatch=pluginCtx.getKDBizPromptBox("prmtprmtDispatchUnit"); varqueryInfoOrigin=prmtDispatch.getQueryInfo(); if(queryInfoOrigin!=null){ varqueryInfo=queryInfoOrigin.replaceAll("\\\\","."); if(QueryInfoConstants.SUPPLIER_COMPANY.equals(queryInfo)){ editData.put("dispatch_Sup",prmtDispatch.getValue()); }else{ editData.put("dispatch_Org",prmtDispatch.getValue()); }}}vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.constants);with(easNames){ vareditData=pluginCtx.getDataObject(); varprmtDispatch=pluginCtx.getKDBizPromptBox("prmtprmtDispatchUnit"); varqueryInfoOrigin=prmtDispatch.getQueryInfo(); if(queryInfoOrigin!=null){ varqueryInfo=queryInfoOrigin.replaceAll("\\\\","."); if(QueryInfoConstants.SUPPLIER_COMPANY.equals(queryInfo)){ prmtDispatch.setValue(editData.get("dispatch_Sup")); }else{ prmtDispatch.setValue(editData.get("dispatch_Org")); }}}vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.constants);easNames.importPackage(P.kingdee.bos);with(easNames){ vareditData=pluginCtx.getDataObject(); varprmtDispatch=pluginCtx.getKDBizPromptBox("prmtprmtDispatchUnit"); varqueryInfoOrigin=prmtDispatch.getQueryInfo(); if(editData.getSourceBillId()==null) thrownewBOSException("檢斤通知單不允許手工新增！"); if(editData.get("dispatch_Sup")!=null){ prmtDispatch.setQueryInfo(QueryInfoConstants.SUPPLIER_COMPANY); prmtDispatch.setValue(editData.get("dispatch_Sup")); }else{ prmtDispatch.setQueryInfo("com.kingdee.eas.fi.arap.app.AdminOrgUnitQuery"); prmtDispatch.setValue(editData.get("dispatch_Org")); }}varimp=JavaImporter();imp.importPackage(P.kingdee.eas.util.app);with(imp){varctx=pluginCtx.getContext();varbillId=methodCtx.getParamValue(0);varsumQTY=0;varsql="updateT_IM_PurReceivalEntrySETCFSumCheckQTY='".sumQTY."'WHEREFNUMBER='qq-2010-03-12-00000626'";DbUtil.execute(ctx,sql);methodCtx.setResultValue(java.lang.Boolean.TRUE);}//服務端根據物料計劃頁簽檢查項目號與跟蹤號varimp=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(imp){varctx=pluginCtx.getContext();varbillInfo=methodCtx.getParamValue(0);varentrys=billInfo.getEntries();varentry=entrys.get(0);varmaterial=entry.getMaterial();varmaterialId=material.getId();varev=newEntityViewInfo();varfi=newFilterInfo();fi.getFilterItems().add(newFilterItemInfo("material.id",materialId,CompareType.EQUALS));ev.setFilter(fi);variMaterialPlan=MaterialPlanFactory.getLocalInstance(ctx);varmaterialPlanCol=iMaterialPlan.getMaterialPlanCollection(ev);if(materialPlanCol.size()>0){ if(entry.get("myProject")==null&&entry.get("myTrack")==null) thrownewBOSException("項目號與跟蹤號不能同時為空！"); }}//Scm_DynProException需要預先定義vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(P.kingdee.bos);with(easNames){ varprmtCurrency=pluginCtx.getKDBizPromptBox("prmtCurrency"); if(prmtCurrency.getValue()==null) com.kingdee.eas.ep.plugin.ExceptionUtil.throwOnClient('Scm_DynProException','ScmCompany');}varimp=JavaImporter();imp.importPackage(P.kingdee.eas.util.app);imp.importPackage(P.kingdee.bos);with(imp){varctx=pluginCtx.getContext();if(true){thrownewBOSException("編碼重復！"); }}vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(Pmon.util);easNames.importPackage(Pmon.client.helper);with(easNames){varpre=pluginCtx.getKDFormattedTextField("txtPrepayment");pre.setPrecision(10);}//KDTable加入監聽器varswingNames=JavaImporter();swingNames.importPackage(P.kingdee.bos.ctrl.kdf.table.event);swingNames.importPackage(Pmon.client);vartblMain=pluginCtx.getKDTable("kdtEntries");with(swingNames){ tblMain.addKDTEditListener(KDTEditListener(this));}functioneditStarting(e){}functioneditStarted(e){ varentry=pluginCtx.getKDTable("kdtEntries"); varcolumn=entry.getColumn("qty").getStyleAttributes().setBackground(java.awt.Color.ORANGE);}functioneditValueChanged(e){}functioneditStopping(e){}functioneditStopped(e){}functioneditCanceled(e){}//Scm_DynProException需要預先定義vareasNames=JavaImporter();easNames.importPackage(P.kingdee.bos.ctrl.extendcontrols);easNames.importPackage(P.kingdee.bos);easNames.importPackage(P.kingdee.bos.ui);with(easNames){this.setFocusTraversalPolicy(newcom.kingdee.bos.ui.UIFocusTraversalPolicy(newjava.awt.Component[]{kDDateLastUpdateTime,prmtLastUpdateUser,kDDateCreateTime,prmtCreator,prmtAuditor,txtDescription,pkBizDate,txtNumber,