关于EAS 套打配置审批结果信息的相关思路

在我们配置套打开发的时候，有时候我们需要单据流程的审批结果信息，对于有的流程我们可能异常终止过，我们如果需要获取当前的审批结果信息的话的情况，我们可以参考一下几点思路

1、首先需要在套打管理中新增一个动态元数据 其中名称、别名可以自定义

2、在字段列表中添加我们需要套打出来的字段 比如 审批人、审批结果、审批意见  类型（String）

3、在我们的套打模版（套打设计器中添加审批意见元素据）————数据——添加元数据——套打元素据，选择我们的审批元数据

4、在我们的editUI中编写代码（重写方法，一级对应的sql）    public void actionPrint_actionPerformed(ActionEvent e) throws Exception {          ArrayList idList = new ArrayList();            if (editData != null && !StringUtils.isEmpty(editData.getString("id"))) {                idList.add(editData.getString("id"));            }            if (idList == null || idList.size() == 0 || getTDQueryPK() == null || getTDFileName() == null)                return;            MyDataProvider data = new MyDataProvider();            com.kingdee.bos.ctrl.report.forapp.kdnote.client.KDNoteHelper appHlp = new com.kingdee.bos.ctrl.report.forapp.kdnote.client.KDNoteHelper();            appHlp.printPreview(getTDFileName(), data, javax.swing.SwingUtilities.getWindowAncestor(this));        super.actionPrint_actionPerformed(e);    }    public void actionPrintPreview_actionPerformed(ActionEvent e)            throws Exception {          ArrayList idList = new ArrayList();            if (editData != null && !StringUtils.isEmpty(editData.getString("id"))) {                idList.add(editData.getString("id"));            }            if (idList == null || idList.size() == 0 || getTDQueryPK() == null || getTDFileName() == null)                return;            MyDataProvider data = new MyDataProvider();            com.kingdee.bos.ctrl.report.forapp.kdnote.client.KDNoteHelper appHlp = new com.kingdee.bos.ctrl.report.forapp.kdnote.client.KDNoteHelper();            appHlp.printPreview(getTDFileName(), data, javax.swing.SwingUtilities.getWindowAncestor(this));        super.actionPrintPreview_actionPerformed(e);    }        public class MyDataProvider extends AbstractPrintDataProvider{                @Override        public IRowSet getData(R1PrintDataSource dataSource) throws Exception {            IRowSet irow = null;            String curBillID = editData.getId().toString();            IQueryExecutor iqec = null;              FilterInfo filterInfo = new FilterInfo();              EntityViewInfo viewInfo = new EntityViewInfo();             if("PurchaseRequestBillQuery.bos-query".equals(dataSource.getId())){                iqec = QueryExecutorFactory.getRemoteInstance(new MetaDataPK(                          "com.kingdee.eas.custom.office.purchase.app",                          "PurchaseRequestBillQuery"));                  filterInfo.getFilterItems().add(                          new FilterItemInfo("id", curBillID,                                  CompareType.EQUALS));                  viewInfo.setFilter(filterInfo);                  iqec.setObjectView(viewInfo);                  iqec.option().isAutoTranslateBoolean = true;                  iqec.option().isAutoTranslateEnum = true;                                              try {                    irow = iqec.executeQuery();                } catch (BOSException e) {                    MsgBox.showInfo("获取套打数据有误:"+e.getMessage());                }                                            }             if("PurchaseRequestAppove".equals(dataSource.getId())){                FilterInfo filter= WfUtils.getApproveFilter(curBillID);                String filterSql=filter.toSql();                filterSql=filterSql.substring(filterSql.indexOf("IN"));                StringBuffer sql = new StringBuffer();                sql.append("SELECT ");                 sql.append("A.FID AS billID2,")                    .append("A.FCreateTime as auditDate,")                    .append("A.FIsPass  as auditResult,")                    .append("B.FName_l2 as auditPerson,")                    .append("A.FOpinion_l2 as auditAdvise");                sql.append(" FROM T_BAS_MultiApprove A")                    .append(" INNER JOIN T_PM_User   B ON A.FCreatorID = B.FID")                    .append(" INNER JOIN T_BD_Person   C ON B.FPersonId = C.FID");                                sql.append(" where A.FBillID='").append(curBillID).append("' AND fstatus = 1  and A.fassignmentid ").append(filterSql).append(" order by A.FCreateTime");                                                ISQLExecutor isexe = SQLExecutorFactory.getRemoteInstance(sql.toString());                try {                    irow = isexe.executeSQL();                    return irow;                } catch (BOSException e) {                    MsgBox.showInfo("获取套打数据有误:"+e.getMessage());                }            }             if("PurchaseRequestBillR1Query".equals(dataSource.getId())){                iqec = QueryExecutorFactory.getRemoteInstance(new MetaDataPK(                          "com.kingdee.eas.custom.office.purchase.app",                          "PurchaseRequestBillR1Query"));                  filterInfo.getFilterItems().add(                          new FilterItemInfo("id", curBillID,                                  CompareType.EQUALS));                  viewInfo.setFilter(filterInfo);                  iqec.setObjectView(viewInfo);                  iqec.option().isAutoTranslateBoolean = true;                  iqec.option().isAutoTranslateEnum = true;                                              try {                    irow = iqec.executeQuery();                } catch (BOSException e) {                    MsgBox.showInfo("获取套打数据有误:"+e.getMessage());                }            }             return irow;                }            }