DEP常用脚本集2013

var sh =accountCussentInfo.get(\var txtkpdz = pluginCtx.getKDTextField(\txtkpdz.setText(kpdz);

var txtkpdh = pluginCtx.getKDTextField(\txtkpdh.setText(kpdh);

var txtkhh = pluginCtx.getKDTextField(\txtkhh.setText(khh);

var txtkhzh = pluginCtx.getKDTextField(\txtkhzh.setText(khzh);

var txtsh = pluginCtx.getKDTextField(\txtsh.setText(sh); } } });

2.24. 设置分录F7列的显示名称

在【应付单】编辑界面，DEP 界面加载（onLoad）扩展点，写后置脚本： var editor1 = pluginCtx.getKDTable(\var comp1 = editor1.getComponent(); comp1.setDisplayFormat(\

var editor2 = pluginCtx.getKDTable(\var comp2 = editor2.getComponent(); comp2.setDisplayFormat(\

3. 服务端常用脚本 3.1. 服务端更新单据状态

var imp = JavaImporter();

imp.importPackage(Packages.com.kingdee.eas.util.app); with(imp){

var ctx = pluginCtx.getContext(); var billId = methodCtx.getParamValue(0); var status = 11;

21 / 24

var sql = \T_SD_SALEORDER SET FBASESTATUS = \+ status + \WHERE FID = '\

DbUtil.execute(ctx, sql);

methodCtx.setResultValue(java.lang.Boolean.TRUE); }

3.2. 服务端检查编码重复

var imp = JavaImporter();

imp.importPackage(Packages.com.kingdee.eas.util.app); imp.importPackage(Packages.com.kingdee.bos); with(imp){

var ctx = pluginCtx.getContext();

var sql = \var rowset = DbUtil.executeQuery(ctx, sql); if(rowset.size() > 0){

throw new BOSException(\编码重复！\ } }

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

var imp = JavaImporter();

imp.importPackage(Packages.com.kingdee.eas.util.app); imp.importPackage(Packages.com.kingdee.bos);

imp.importPackage(Packages.com.kingdee.eas.basedata.master.material); imp.importPackage(Packages.com.kingdee.bos.metadata.entity); imp.importPackage(Packages.com.kingdee.bos.metadata.query.util);

with(imp){

var ctx = pluginCtx.getContext();

var billInfo = methodCtx.getParamValue(0);

22 / 24

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(\ev.setFilter(fi);

var iMaterialPlan = MaterialPlanFactory.getLocalInstance(ctx); var materialPlanCol = iMaterialPlan.getMaterialPlanCollection(ev);

if(materialPlanCol.size() > 0){

if(entry.get(\ throw new BOSException(\项目号与跟踪号不能同时为空！\} }

3.4. 传递数组参数

var imp = JavaImporter();

imp.importPackage(Packages.com.kingdee.eas.qm.qc.util); imp.importPackage(Packages.java.lang); imp.importPackage(Packages.java.util); with(imp){

var ctx = pluginCtx.getContext(); var result = methodCtx.getResultValue(); var list = result.get(HQHPUtil.Result_Error); var ary = [\

var msg = new HQHPMsg(\list.add(msg);

23 / 24

}

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

24 / 24