用友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;
// model
private BillManageModel model;
private String currBilltype;
private IBillReferQuery dlg;
private DefaultUIF2RefEditor defaultUIF2RefEditor = null;
public ReferAction() {
super();
}
@Override
public 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()
*/
@Override
protected 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;
}
}
原文链接：https://blog.csdn.net/qq_31968809/article/details/54587896
5287
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
