金蝶EAS开发文档.pdf

BOS技术Apusic connot from bostype错误在BOS 下：工 程 metadataentity_pkmapping.properties 文 件 中 查 找 对 应 的bostype 号的记录行将 entity_pkmapping.properties在复制到服务器的目录Kingdee/eas/server/mates/sp-bim-mates.jar Kingdee/eas/server/deploy/fileserver.ear/easWebClient/mates/sp-bim-mates.jar EAS工程发布路径server Kingdee/eas/server/lib/sp/eas_sp.jar Kingdee/eas/server/mates/sp-bim-mates.jar client Kingdee/eas/server/deploy/fileserver.ear/easWebClient/lib/sp/eas_sp.jarKingdee/eas/server/deploy/fileserver.ear/easWebClient/mates/sp-bim-mates.jar Server 执行 SQL StringBuffer selectSQL=new StringBuffer();selectSQL.append(/*dialect*/SELECT TOPD.FOLEBILLINGAMOUN,);selectSQL.append(FROM T_OPE_OPENINVOICES TOPC);selectSQL.append(WHERE TOPC.FID=+fid+);IRowSet returnIRow=DbUtil.executeQuery(ctx,selectSQL.toString();while(returnIRow.next()StringBuffer updateSQL=new StringBuffer();updateSQL.append(/*dialect*/UPDATE T_OPE_ORDERMANAGEMENTENTRY);updateSQL.append(SET FORICURRENCYBILA=+returnIRow.getString(2);DbUtil.execute(ctx,updateSQL.toString();名师资料总结-精品资料欢迎下载-名师精心整理-第 1 页，共 6 页 -Client 页面之间传参SysContext.getSysContext().setProperty(khname,khname);SysContext.getSysContext().getProperty(khname).toString();BigDecimal操作加法：b1.add(b2)减法：b1.subtract(b2)乘法：b1.multiply(b2)除法：div(v1,v2,DEF_DIV_SCALE)比较：pareTo(b2)相等返回0，第一个数比第二个数大则返回1，反之返回-1 获取当前页面状态String pageType=this.getOprtState();页面状态值：新增ADDNEW 修改EDIT 查看VIEW 控件常用属性Visible 是否显示Enabled 是否可用Locked 是否锁定Table相关操作删除交点tableName.getSelectManager().removeAll();新增行tableName.addRow().getCell(TableType).setValue(默认值);名师资料总结-精品资料欢迎下载-名师精心整理-第 2 页，共 6 页 -单元格锁定tableName.getRow(i).getCell(TType).getStyleAttributes().setLocked(true);Table 条数tableName.getRowCount();获取当前行号tableName.getSelectManager().get(0).getTop();删除所有行tableName.removeRows();Edit 页面 Table 添加合计行this.setTableToSumField(tableName,new StringFlocals,factCost);列数据融合this.tblMain.getColumn(projectName).setGroup(true);SplitPane相关操作设制中间分档线位置this.kDSplitPane1.setDividerLocation(200);闭关当前窗口方法super.disposeUIWindow();名师资料总结-精品资料欢迎下载-名师精心整理-第 3 页，共 6 页 -根据单据编号获取info String number=row.getCell(orderID).getValue().toString();OrderManagementInfo ominfo=null;try OrderManagementCollection c=OrderManagementFactory.getRemoteInstance().getOrderManagementCollection(select*where number=+number+);ominfo=c.get(0);catch(BOSException e1)e1.printStackTrace();将 ID 转换为 PK的方法ObjectUuidPK pk=new ObjectUuidPK(materialinfo.getId();获取前台页面菜单注册参数String cs=getUIContext().get(UIClassParam).toString()EAS 报表开发原数据继承关系com.kingdee.eas.framework.report.app.CommRptBase Facade com.kingdee.eas.framework.report.client.CommRptBaseUI ListUI com.kingdee.eas.framework.report.client.CommRptBaseConditionUI QuryUI 列表页面构造方法中：this.kDTable1.getDataRequestManager().addDataRequestListener(this);this.kDTable1.getDataRequestManager().setDataRequestMode(0);this.kDTable1.getStyleAttributes().setLocked(true);this.kDTable1.getSelectManager().setSelectMode(2);KDT ableHelper.setEnterKeyJumpOrientation(this.kDT able1,2);KDT ableHelper.setTabKeyJumpOrientation(this.kDTable1,2);名师资料总结-精品资料欢迎下载-名师精心整理-第 4 页，共 6 页 -enableExportExcel(this.kDTable1);this.kDTable1.getHeadMergeManager().setMergeMode(KDTMergeManager.FREE_MERGE);this.kDTable1.getGroupManager().setGroup(true);Vector colName=this.getColName();Vector colCNName=this.getColCNName();Helper.setTableHeader(colName,colCNName,this.kDTable1);设置列名：private Vector getColName()Vector v=new Vector();v.add(0,fkh);v.add(1,fpc);return v;private Vector getColCNName()Vector v=new Vector();v.add(0,客户);v.add(1,批次);return v;设计返回 RptParams protected RptParams getParamsForInit()RptParams params=new RptParams();return params;注册查询条件UI 页面protected CommRptBaseConditionUI getQueryDialogUserPanel()throws Exception CustomerBatchProfitQuryUI cui=null;if(cui=null)cui=new CustomerBatchProfitQuryUI();return cui;ListUI 传参数方法protected void query()params.setString(gl,getUIContext().get(UIClassParam).toString();this.kDT able1.removeColumns();this.kDT able1.removeRows();返回数据集写到页面UI 上public void tableDataRequest(KDTDataRequestEvent arg0)RptRowSet rs=null;try RptParams parm=com.kingdee.eas.cmt.report.TranFacadeFactory.getRemoteInstance().query(params);rs=(RptRowSet)parm.getObject(Result);名师资料总结-精品资料欢迎下载-名师精心整理-第 5 页，共 6 页 -Vector colName=this.getColName();Vector colCNName=this.getColCNName();Helper.setTableHeader(colName,colCNName,this.kDTable1);this.setUITitle(大连有限-客户批次利润表);Helper.insertKDT ableRows(rs,this.kDTable1);catch(Exception ex)handleException(ex);设置先弹出查询页面public boolean isShowFilter()return true;后台方法protected RptParams _query(Context ctx,RptParams params)throws BOSException,EASBizException /获取前台查询方案中的参数String startdatess=params.getObject(startdatess).toString();StringBuffer selectSQLjck=new StringBuffer();RptRowSet rs=executeQuery(selectSQLjck.toString(),null,ctx);RptParams param=new RptParams();param.setObject(Result,rs);return param;名师资料总结-精品资料欢迎下载-名师精心整理-第 6 页，共 6 页 -。