动态扩展平台常用脚本集

动态扩展平台常用脚本集

EAS 产品部产品支持部白敏

导读

本文档截取了DEP以前项目开发过程中的一些常用功能的脚本实现，可以仿照该实现，快速编写项目中实际的业务逻辑的脚本。

适用对象

DEP扩展脚本开发人员

请注意：本文件只作为产品介绍之用，不属于您与金蝶签署的任何协议。本文件仅包括金蝶既定策略、产品及功能方面的信息，不能以本文件作为要求金蝶履行商务条款、产品策略以及开发义务的依据。本文件内容可能随时变更，恕不另行通知。

//客户端在扩展点提交时给F7控件增加监听器

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols); easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos);

with(easNames){

var roadMap = pluginCtx.getKDBizPromptBox("prmtprmtMyRoadMap"); roadMap.addPreChangeListener(function(){

throw new BOSException("路线图不允许为空!");

});

}

//客户端设置F7默认值

var easImporter = JavaImporter();

easImporter.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols); easImporter.importPackage(https://www.360docs.net/doc/6f15914728.html,mon); easImporter.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.util);

easImporter.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.basedata.assistant); with(easImporter){

var prmtCurrency =pluginCtx.getKDBizPromptBox("prmtCurrency");

var cur = new CurrencyInfo();

cur.setId(BOSUuid.create("DEB58FDC"));

cur.setNumber("1001");

cur.setName("BMD");

prmtCurrency.setValue(cur);

}

//服务端更新单据状态

var imp = JavaImporter();

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.util.app);

with(imp){

var ctx = pluginCtx.getContext();

var billId = methodCtx.getParamValue(0);

var status = 11;

var sql = "update T_SD_SALEORDER SET FBASESTA TUS = " + status + " WHERE FID = '"+billId+"'";

DbUtil.execute(ctx, sql);

methodCtx.setResultValue(https://www.360docs.net/doc/6f15914728.html,ng.Boolean.TRUE);

}

//客户端调用服务端方法

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.util);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.metadata);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.util.client);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.framework);

with(easNames){

var pk = new MetaDataPK("com.kingdee.eas.scm.sd.sale.app.SaleOrder");

var name = "https://www.360docs.net/doc/6f15914728.html,ng.Boolean updateStatus(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();

}

//服务端检查编码重复

var imp = JavaImporter();

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.util.app);

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.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("编码重复！");

}

}

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.util);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.client.helper);

with(easNames){

var entry = pluginCtx.getKDTable("kdtEntries");

var column = entry.getColumn("qty");

var format = PrecisionUtil.getFormatString(10);

var editor = FormattedEditorFactory.getBigDecimalCellEditor(10, false);

column.setEditor(editor);

column.getStyleAttributes().setNumberFormat(format);

}

var imp = JavaImporter();

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.util.app);

with(imp){

var ctx = pluginCtx.getContext();

var billId = methodCtx.getParamValue(0);

var status = 2;

var sql = "update T_SD_SALEORDER SET FBASESTA TUS = " + status + " WHERE FID = '"+billId+"'";

DbUtil.execute(ctx, sql);

methodCtx.setsetResultValue(https://www.360docs.net/doc/6f15914728.html,ng.Boolean.TRUE);

}

//客户端设置编码规则脚本

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.base.codingrule);

with(easNames){

var editData = pluginCtx.getDataObject();

var bizOrgUnit= pluginCtx.getKDBizPromptBox("prmtSaleOrgUnit").getValue();

var number = CodingRuleManagerFactory.getRemoteInstance().getNumber(editData, bizOrgUnit.getId());

pluginCtx.getKDTextField("txtNumber").setText(number);

}

//客户端设置销售订单分录数量列背景色为红色，注意该脚本需要为后置脚本才能用

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.client);

with(easNames){

var entry = pluginCtx.getKDTable("kdtEntries");

var column = entry.getColumn("qty").getStyleAttributes().setBackground(java.awt.Color.RED); }

//客户端设置空间字体属性

var font = new java.awt.Font("SansSerif",java.awt.Font.BOLD,14);

pluginCtx.getKDTextField("txtDescription").setFont(font);

//建滔替换物料验证

var easNames = JavaImporter();

easNames.importPackage(Packages.javax.swing);

easNames.importPackage(Packages.java.awt);

easNames.importPackage(Packages.java.event);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.util);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.constants);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.kdf.table);

with(easNames){

var editData = pluginCtx.getDataObject();

var detailTable = pluginCtx.getKDTable("detailTable");

var prmtMaterial = new KDBizPromptBox();

prmtMaterial.setQueryInfo(QueryInfoConstants.MA TERIAL_INVENTORY_NO_GROUP); var labelMaterial = 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 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("替换物料");

frame.getContentPane().add(pane, BorderLayout.CENTER);

frame.addWindowListener(function(event, methodName){

if(methodName == "windowClosing"){

frame.setVisible(false);

var detailTable = pluginCtx.getKDTable("detailTable")

var selectManager = detailTable.getSelectManager();

var selectBlock =selectManager.get();

if (selectBlock != null) {

var rowIndex = selectBlock.getTop();

var material = prmtMaterial.getValue();

var assitAttr = prmtAssitAttribute.getValue();

detailTable.getCell(rowIndex,"orderMaterial").setValue(material);

detailTable.getCell(rowIndex,"orderAssitAttribute").setValue(assitAttr);

}

}

});

frame.pack();

frame.setVisible(true);

}

//服务端更新单据状态

var imp = JavaImporter();

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.util.app);

with(imp){

var ctx = pluginCtx.getContext();

var billId = methodCtx.getParamValue(0);

var sql = "update CT_SCA_CheckWeightNoteBill SET CFSTA TUSID = '2WiVgufPSLmUJJ9rb9F+4b8ogLw=' WHERE FNUMBER = '001'";

DbUtil.execute(ctx, sql);

methodCtx.setResultValue(https://www.360docs.net/doc/6f15914728.html,ng.Boolean.TRUE);

}

//客户端处理送货单位

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols); easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.constants);

with(easNames){

var prmtDispatch = pluginCtx.getKDBizPromptBox("prmtprmtDispatchUnit");

prmtDispatch.setQueryInfo(QueryInfoConstants.SUPPLIER_COMPANY);

}

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols); easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.constants);

with(easNames){

var editData = pluginCtx.getDataObject();

var prmtDispatch = pluginCtx.getKDBizPromptBox("prmtprmtDispatchUnit");

var queryInfoOrigin = prmtDispatch.getQueryInfo();

if(queryInfoOrigin != null){

var queryInfo = queryInfoOrigin.replaceAll("\\\\",".");

if(QueryInfoConstants.SUPPLIER_COMPANY.equals(queryInfo)){ editData.put("dispatch_Sup",prmtDispatch.getValue());

}else{

editData.put("dispatch_Org",prmtDispatch.getValue());

}}

}

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols); easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.constants);

with(easNames){

var editData = pluginCtx.getDataObject();

var prmtDispatch = pluginCtx.getKDBizPromptBox("prmtprmtDispatchUnit");

var queryInfoOrigin = prmtDispatch.getQueryInfo();

if(queryInfoOrigin != null){

var queryInfo = queryInfoOrigin.replaceAll("\\\\",".");

if(QueryInfoConstants.SUPPLIER_COMPANY.equals(queryInfo)){

prmtDispatch.setValue(editData.get("dispatch_Sup"));

}else{

prmtDispatch.setValue(editData.get("dispatch_Org"));

}}

}

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.constants);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos);

with(easNames){

var editData = pluginCtx.getDataObject();

var prmtDispatch = pluginCtx.getKDBizPromptBox("prmtprmtDispatchUnit");

var queryInfoOrigin = prmtDispatch.getQueryInfo();

if(editData.getSourceBillId() == null)

throw new BOSException("检斤通知单不允许手工新增！");

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"));

}

}

var imp = JavaImporter();

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.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(https://www.360docs.net/doc/6f15914728.html,ng.Boolean.TRUE);

}

//服务端根据物料计划页签检查项目号与跟踪号

var imp = JavaImporter();

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.util.app);

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos);

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.basedata.master.material);

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.metadata.entity);

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.metadata.query.util);

with(imp){

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 FilterItemInfo("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 BOSException("项目号与跟踪号不能同时为空！");

}

}

//Scm_DynProException需要预先定义

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos);

with(easNames){

var prmtCurrency = pluginCtx.getKDBizPromptBox("prmtCurrency");

if(prmtCurrency.getValue() == null)

com.kingdee.eas.ep.plugin.ExceptionUtil.throwOnClient('Scm_DynProException','ScmCom

pany');

}

var imp = JavaImporter();

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.util.app);

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos);

with(imp){

var ctx = pluginCtx.getContext();

if(true){

throw new BOSException("编码重复！");

}

}

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.util);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.client.helper);

with(easNames){

var pre = pluginCtx.getKDFormattedTextField("txtPrepayment");

pre.setPrecision(10);

}

//KDTable加入监听器

var swingNames = JavaImporter();

swingNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.kdf.table.event);

swingNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.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.getColumn("qty").getStyleAttributes().setBackground(java.awt.Color.ORANGE);

}

function editValueChanged(e)

{}

function editStopping(e)

{}

function editStopped(e)

{}

function editCanceled(e)

{}

//Scm_DynProException需要预先定义

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ctrl.extendcontrols);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ui);

with(easNames){

this.setFocusTraversalPolicy(new com.kingdee.bos.ui.UIFocusTraversalPolicy(new https://www.360docs.net/doc/6f15914728.html,ponent[]

{kDDateLastUpdateTime,prmtLastUpdateUser,kDDateCreateTime,prmtCreator,prmtAuditor,txtD escription,pkBizDate,txtNumber,kdtEntrys}));

}

//调用Onload出错

var easNames = JavaImporter();

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.client);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.util);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.bos.ui.face);

easNames.importPackage(https://www.360docs.net/doc/6f15914728.html,mon.client);

with(easNames){

var ui = pluginCtx.getUI();

var uiContext = new UIContext(ui);

//uiContext.put(ui.getMainBizOrgType(), ui.getMainOrgContext().get(

//ui.getMainBizOrgType()));

//uiContext.put("idList", SCMUtils.convertStringToObjectPK(selIDs));

uiContext.put(UIContext.ID,"6LRL/3PNRXWIB1vd6kgaZMSKQjo=");

uiContext.put("lockType", "lock");

var uiFactory = UIFactory

.createUIFactory(https://www.360docs.net/doc/6f15914728.html,mon.client.UIFactoryName.MODEL); var window;

window = uiFactory.create(

"com.kingdee.eas.scm.sd.sale.client.SaleOrderLockUI",

uiContext, null);

window.show();

}

//传递数组参数

var imp = JavaImporter();

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,.kingdee.eas.qm.qc.util);

imp.importPackage(https://www.360docs.net/doc/6f15914728.html,ng);

imp.importPackage(Packages.java.util);

with(imp){

var ctx = pluginCtx.getContext();

var result = methodCtx.getResultValue();

var list = result.get(HQHPUtil.Result_Error);

var ary = ["xxx","yyy"];

var msg = new HQHPMsg("Verify_SubmitBillsFailed",ary);

list.add(msg);

result.put(HQHPUtil.Result_SubmitBills, new Integer(0));

methodCtx.setResultValue(result);

}