用友nc65 uap开发参照节点数据拉单之二----直接通过调用查询模版查询上游单据

用友nc65 uap开发参照节点数据拉单之二----直接通过调用查询模版查询上游单据

前面一篇博客讲了利用查询模版并显示在弹窗面板上的拉单方法。此次是直接通过调用查询模版查询上游所有单据。如图所示：

按钮调用查询面板

将符合条件的所有数据直接显示在编辑状态的面板上：

代码如下：

xml代码：

<bean id="refAction" class="nc.ui.fdc_pr.h303201570.ace.action.ReferAction"><property name="model"><ref bean="bmModel" /></property><property name="editor" ref="billForm" /><!--当前单据类型编码 --><property name="currBilltype" value="H338" /><!-- 来源单据类型编码 --><property name="sourceBillType" value="H345" /><!-- 来源单据类型名称 --><property name="sourceBillName" value="参照收费清单" /><property name="exceptionHandler"><ref bean="exceptionHandler" /></property><property name="defaultUIF2RefEditor"><ref bean="defaultUIF2RefEditor" /></property></bean><!-- 导入编辑器 --><bean id="defaultUIF2RefEditor" class="nc.itf.fdc.pub.DefaultUIF2RefEditor"><property name="addAction" ref="addAction" /><property name="billcardPanelEditor" ref="billForm" /><property name="appModel" ref="bmModel" /></bean>

按钮代码类：

package nc.ui.fdc_pr.h303201570.ace.action;import java.awt.Container;import java.awt.event.ActionEvent;import nc.bs.framework.common.NCLocator;import nc.bs.pf.pub.BillTypeCacheKey;import nc.itf.fdc.pub.DefaultUIF2RefEditor;import nc.itf.fdc_pr.IH303201525Maintain;import nc.md.data.access.NCObject;import nc.ui.ml.NCLangRes;import nc.ui.pf.pub.PfUIDataCache;import nc.ui.pr.H30301.LogonBO_Client;import nc.ui.pub.beans.UIDialog;import nc.ui.pub.bill.BillStatus;import nc.ui.pubapp.uif2app.actions.AbstractReferenceAction;import nc.ui.pubapp.uif2app.model.BillManageModel;import nc.ui.querytemplate.IBillReferQuery;import nc.ui.querytemplate.QueryConditionDLG;import nc.ui.uif2.UIState;import nc.ui.uif2.editor.IBillCardPanelEditor;import nc.vo.fdc_pr.h303201525.Bill;import nc.vo.fdc_pr.h303201570.AggDjzb;import nc.vo.fdc_pr.h303201570.Djfb;import nc.vo.fdc_pr.h303201570.Djzb;import nc.vo.pub.BusinessException;import nc.vo.pub.VOStatus;import nc.vo.pub.lang.UFBoolean;import nc.vo.pub.lang.UFDouble;import nc.vo.pub.pf.BillStatusEnum;import nc.vo.pubapp.AppContext;import nc.vo.querytemplate.TemplateInfo;import nc.vo.uap.pf.PFBusinessException;import nc.vo.uif2.LoginContext;import org.apache.commons.lang.StringUtils;public class ReferAction extends AbstractReferenceAction {private static final long serialVersionUID = -7167526730230052116L;// 卡片面板private IBillCardPanelEditor editor;// modelprivate BillManageModel model;private String currBilltype;private IBillReferQuery dlg;private DefaultUIF2RefEditor defaultUIF2RefEditor = null;public ReferAction() {super();}@Overridepublic void doAction(ActionEvent e) throws Exception {LoginContext context = this.getModel().getContext();String funNode = PfUIDataCache.getBillType(new BillTypeCacheKey().buildBilltype(getSourceBillType()).buildPkGroup(context.getPk_group())).getNodecode();if (funNode == null || funNode.equals(""))throw new PFBusinessException(NCLangRes.getInstance().getStrByID("pfworkflow1", "PfUtilClient-000001", null,new String[] { getSourceBillType() })/* 请注册单据{0}的功能节点号 */);// 1.构造查询对话框if (dlg == null) {dlg = setConditionClient(null, context.getEntranceUI(),context.getPk_loginUser(), funNode, context.getPk_group());}if (dlg.showModal() != UIDialog.ID_OK) {return;}//not exists ( select 1 from fdc_pr_FareType ft where nvl(ft.dr,0)=0 and nvl(ft.reserve1,'N')='Y' and ft.pk_head = fdc_pr_Bill.pk_faretypeid )StringBuffer strWhere = new StringBuffer();if(dlg.getWhereSQL()==null||dlg.getWhereSQL().trim().length()==0){strWhere.append(" 1=1 ");}else{strWhere.append(dlg.getWhereSQL());}strWhere.append( " and isnull(fdc_pr_Bill.dr,0)=0 and isnull(fdc_pr_Bill.bisarap,'N')='N' ");strWhere.append( " and not exists ( select 1 from fdc_pr_FareType ft where isnull(ft.dr,0)=0 and isnull(ft.reserve1,'N')='Y' and ft.pk_head = fdc_pr_Bill.pk_faretypeid )  ");strWhere.append( " and isnull(fdc_pr_Bill.bclose,'N')='N'" );//关闭的数据不参照过来// 2.根据查询条件得到收费清单：// 2. 1 根据单据类型，利用元数据查询 ：前提要求上游元数据，实现了IHeadBodyQueryItf接口// IPFConfig pfConfig = (IPFConfig)// NCLocator.getInstance().lookup(IPFConfig.class.getName());// CircularlyAccessibleValueObject[] tmpHeadVo =// pfConfig.queryHeadAllData(getSourceBillType(), tmpWhere);// 2. 2 调用上游查询接口IH303201525Maintain maint = NCLocator.getInstance().lookup(IH303201525Maintain.class);//查询模板查询条件查询收费清单*（已经收完款的不用查出来）NCObject[] bills = maint.querybillbywhere(strWhere.toString());//Bill[] bills = maint.query(strWhere);if (bills == null || bills.length == 0) { throw new BusinessException("未查询到收费清单数据.");}// 3. 转换数据:可以代码 硬编码转换，也可以调用单据转换规则。AggDjzb bill = chg(bills);//生成单据// 4. 设置编辑状态数据getDefaultUIF2RefEditor().addNew();getDefaultUIF2RefEditor().setValue(bill);}/** * 生成“财务应收单” * */private AggDjzb chg(NCObject[] bills) {AggDjzb bill = new AggDjzb();Djzb zb = chgHead(bills);bill.setParentVO(zb);bill.setChildrenVO(chgBodys(bills));return bill;}/** * 设置表头数据 * */public Djzb chgHead(NCObject[] bills) {Djzb head = new Djzb();head.setPk_group(AppContext.getInstance().getPkGroup());//集团head.setDbilldate(AppContext.getInstance().getBusiDate());//单据日期head.setAttributeValue("approvestatus", BillStatusEnum.FREE.value());//单据状态String pk_org = getModel().getContext().getPk_org();if (StringUtils.isBlank(pk_org)) {if (bills != null && bills.length > 0) {pk_org = (String) bills[0].getAttributeValue("pk_org");}    getModel().getContext().setPk_org(pk_org);}head.setPk_org(pk_org);//组织//是否传会计平台head.setFisvoucher(UFBoolean.TRUE);//计财务应收日期head.setDrecordapdate(AppContext.getInstance().getBusiDate());//制单人head.setCreator(AppContext.getInstance().getPkUser());//制单日期head.setMaketime(AppContext.getInstance().getServerTime());//单据状态head.setVbillstatus(BillStatus.FREE);//服务中心//head.setPk_managementsecid();//经办人head.setPk_psndoc(AppContext.getInstance().getPkUser());//单据类型head.setBilltype("H338");//创建人head.setBillmaker(AppContext.getInstance().getPkUser());//币种head.setVdef1("");//head.setStatus(VOStatus.NEW);head.setPk_managementsecid(LogonBO_Client.getManageUnit());//服务中心head.setPk_psndoc(AppContext.getInstance().getPkUser());//经办人return head;}/** * 生成表体数据  *  * */public Djfb[] chgBodys(NCObject[] bills) {if (bills == null) {return null;}Djfb[] bodys = new Djfb[bills.length];for (int i = 0; i < bodys.length; i++) {Bill head = (Bill) bills[i].getModelConsistObject();if(head.getSrnmny()==null||head.getSrnmny().doubleValue()<=0){continue;}/*if(head.getSrnrevmny()!=null&&head.getSrnrevmny().doubleValue()>0&&head.getSrnmny().sub(head.getSrnrevmny()).doubleValue()==0D){continue;}*/Djfb body = new Djfb();body.setVsourcebillid(head.getPk_head());//来源单据ID == 收费清单主键body.setReserve5(head.getReserve1());//合同编号body.setPk_pact(head.getPk_pact());if(head.getPk_currency()!=null){body.setPk_currency(head.getPk_currency());//币种}else{body.setPk_currency("1002Z0100000000001K1");//币种,人民币}body.setPk_faretypeid(head.getPk_faretypeid());//收费项目body.setReserve1(head.getPk_allhouses());//单元body.setReserve2(head.getPk_customer());//租户body.setDbegin(head.getDbegin());//收费开始日期body.setCostbelongmonth(head.getCostbelongmonth());//费用所属月body.setDend(head.getDend());//费用截至日期body.setDshpay(head.getDshpay());//应收款日期body.setBusreceivemonth(head.getBusreceivemonth());//业务应收月body.setReserve3(head.getPk_faretypeid());//收费项目//应收金额信息(原币/本币)UFDouble srnmny = new UFDouble(0);if(null != head.getSrnmny())srnmny =head.getSrnmny();UFDouble srnrevmny = new UFDouble(0);if(null != head.getSrnrevmny())srnrevmny =head.getSrnrevmny();//body.setSrnmny(srnmny.sub(srnrevmny));//应收金额 == 总应收 - 已收金额body.setSrnmny(srnmny);//应收金额 body.setNmny(srnmny.sub(srnrevmny));//body.setNyarapverifmny(nyarapverifmny);//核销金额//收费清单的来源源单据类型body.setSrc_bill_type(head.getVsourcebilltype());// 来源单据信息body.setVsourcebillid(head.getPrimaryKey());//来源单据号body.setSrc_bill_code(head.getVbillcode());//租约类型body.setPk_pacttype(head.getPk_pacttype());body.setStatus(VOStatus.NEW);//上游单据主键body.setVlastbillrowid(head.getPk_head());bodys[i] = body;}return bodys;}/** * 构造一个查询对话框，并为其设置查询模板 *  * @param templateId * @param parent * @param isRelationCorp * @param pkOperator * @param funNode */private IBillReferQuery setConditionClient(String templateId,Container parent, final String pkOperator, final String funNode,String pkCorp) {TemplateInfo ti = new TemplateInfo();ti.setTemplateId(templateId);ti.setPk_Org(pkCorp);ti.setUserid(pkOperator);ti.setCurrentCorpPk(pkCorp);ti.setFunNode(funNode);ti.setNodekey("qt");QueryConditionDLG qcDlg = new QueryConditionDLG(parent, ti);qcDlg.setVisibleNormalPanel(true);return qcDlg;}public IBillCardPanelEditor getEditor() {return this.editor;}/** * @return model */public BillManageModel getModel() {return this.model;}public void setEditor(IBillCardPanelEditor editor) {this.editor = editor;}/** * @param model *            要设置的 model */public void setModel(BillManageModel model) {this.model = model;model.addAppEventListener(this);}public String getCurrBilltype() {return currBilltype;}public void setCurrBilltype(String currBilltype) {this.currBilltype = currBilltype;}/** * 父类方法重写 *  * @see nc.ui.uif2.NCAction#isActionEnable() */@Overrideprotected boolean isActionEnable() {return UIState.NOT_EDIT == this.getModel().getUiState();}/** * 转单是否根据流程过滤 *  * @return */protected boolean isBusiness() {return true;}public DefaultUIF2RefEditor getDefaultUIF2RefEditor() {return defaultUIF2RefEditor;}public void setDefaultUIF2RefEditor(DefaultUIF2RefEditor defaultUIF2RefEditor) {this.defaultUIF2RefEditor = defaultUIF2RefEditor;}}

导入编辑器类

package nc.itf.fdc.pub;import nc.ui.pub.bill.BillData;import nc.ui.uif2.NCAction;import nc.ui.uif2.editor.IBillCardPanelEditor;import nc.ui.uif2.model.AbstractUIAppModel;import nc.vo.pub.AggregatedValueObject;public  class DefaultUIF2RefEditor  { private NCAction addAction = null;private Exception ex;    //保存过程中通过拦截器将异常抛出 private IBillCardPanelEditor billcardPanelEditor = null;private AbstractUIAppModel appModel = null;protected NCAction createAddAction(){return null;}protected NCAction createSaveAction(){return null;} protected NCAction createCancelAction(){return null;}protected IBillCardPanelEditor createBillCardPanelEditor(){return null;}protected AbstractUIAppModel createAppModel(){return null;} /** * 新增操作 *  * @see nc.itf.trade.excelimport.IImportableEditor#addNew() */public void addNew() {try {getAddAction().actionPerformed(null);} catch (Exception e) {nc.bs.logging.Logger.error(e.getMessage());}} /** * 设值操作 *  * 标准的操作步骤如下： * 1，转型VO为ExtendedAggregatedValueObject * 2，根据转换规则处理VO的相关属性值 * 3，将处理后的VO值设置到界面上 */public void setValue(Object obj) {if(getBillcardPanelEditor() != null){BillData bd = getBillcardPanelEditor().getBillCardPanel().getBillData();bd.setBillValueVO((AggregatedValueObject)obj);}}/** * 返回AddAction对象 */public NCAction getAddAction() {if(addAction == null)addAction = createAddAction();return this.addAction;}public void setAddAction(NCAction addAction) {this.addAction = addAction;}public IBillCardPanelEditor getBillcardPanelEditor() {if(billcardPanelEditor == null)billcardPanelEditor = createBillCardPanelEditor();return billcardPanelEditor;}public void setBillcardPanelEditor(IBillCardPanelEditor billcardPanelEditor) {this.billcardPanelEditor = billcardPanelEditor;}public AbstractUIAppModel getAppModel() {if(this.appModel == null)appModel = createAppModel();return appModel;}public void setAppModel(AbstractUIAppModel model) {this.appModel = model;}public int getExportCount() {return 1;}public Exception getEx() {return ex;}public void setEx(Exception ex) {this.ex = ex;}}