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

<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;}
}