NC 查询聚合VO

我是个假程序员

已于 2022-10-25 14:21:50 修改

阅读量440

点赞数

分类专栏： NC 文章标签： NC

于 2022-10-25 11:07:05 首次发布

原文链接：https://blog.csdn.net/siyi1219/article/details/121637916

版权

NC 专栏收录该内容

347 篇文章 85 订阅

订阅专栏

NC 查询聚合VO

一、客户端调用

IMDPersistenceQueryService service = NCLocator.getInstance().lookup(IMDPersistenceQueryService.class);
MaterialVO materialVO = (MaterialVO) service.queryBillOfNCObjectByPK(MaterialVO.class, pk_material.toString()).getContainmentObject();

IMDPersistenceQueryService 查询出dr等于1 的数据

nc.itf.pubapp.pub.smart.IBillQueryService
 
IBillQueryService billquery = NCLocator.getInstance().lookup(IBillQueryService.class);
AbstractBill[] fill_dataVOS = (AbstractBill[]) billquery.queryAbstractBillsByPks(src_class, pk_list.toArray(new String[pk_list.size()]));
IMDPersistenceQueryService qryService = NCLocator.getInstance().lookup(IMDPersistenceQueryService.class);
List<AggSamplerecipeHVO> dataList = (List<AggSamplerecipeHVO>) qryService.queryBillOfVOByCond(AggSamplerecipeHVO.class, 
					"pk_material='"+pk_material+"' and detectiontype='"+DetectiontypeEnum.AGAIN.getValue()+"' and fstatusflag=1 and isdefault='Y' and nvl(dr,0)=0" , true, false);

二、私有端

AggDecisionVO billvo=(AggDecisionVO) new HYPubBO().queryBillVOByPrimaryKey(new String[]{AggDecisionVO.class.getName(),
					nc.vo.ebpur.decision.DecisionVO.class.getName(),
					nc.vo.ebpur.decision.DecisionSuppItemVO.class.getName(),
					nc.vo.ebpur.decision.SupplyPriceVO.class.getName(),
					nc.vo.ebpur.decision.DecisionProjStepItemVO.class.getName()
			}, pk_bill);

 BillQuery<WzsqBillVO> billquery = new BillQuery<WzsqBillVO>(WzsqBillVO.class);
 WzsqBillVO[] praybills = (WzsqBillVO[])billquery.query(new String[]{pk_bill});
 
BillQueryByCond billQueryByCond = new BillQueryByCond(clas);
IBill[] bills = billQueryByCond.query(" and " + whereSql, orderSql, true);

三、私有端客户端都可用

IUifService iUifService = NCLocator.getInstance().lookup(IUifService.class);
PrdtaskHVO prdtaskHVO = (PrdtaskHVO) iUifService.queryByPrimaryKey(PrdtaskHVO.class, pk_prdtask);
AggDecisionVO billvo=(AggDecisionVO) NCLocator.getInstance().lookup(IUifService.class).queryBillVOByPrimaryKey(new String[]{AggDecisionVO.class.getName(),
						nc.vo.ebpur.decision.DecisionVO.class.getName(),
						nc.vo.ebpur.decision.DecisionSuppItemVO.class.getName(),
						nc.vo.ebpur.decision.SupplyPriceVO.class.getName(),
						nc.vo.ebpur.decision.DecisionProjStepItemVO.class.getName()
				}, pkHead);