在Acumatica中获取已创建表单的缓存,可以通过以下步骤实现:
[PXCacheName("AR Invoice")]
public class ARInvoiceEntry : PXGraph<ARInvoiceEntry, ARInvoice>
{
// ...
}
ARInvoice invoice = PXSelect<ARInvoice,
Where<ARInvoice.docType, Equal<Required<ARInvoice.docType>>,
And<ARInvoice.refNbr, Equal<Required<ARInvoice.refNbr>>>>>
.Select(Base, docType, refNbr);
其中,"Base"是当前Graph类的实例,"docType"和"refNbr"是要查询的AR Invoice的类型和参考号。
DateTime? invoiceDate = invoice?.InvoiceDate;
public PXSelect<ARTran,
Where<ARTran.tranType, Equal<Current<ARInvoice.docType>>,
And<ARTran.refNbr, Equal<Current<ARInvoice.refNbr>>>>> Transactions;
其中,"ARTran"是AR Invoice的子表,"Transactions"是一个PXSelect对象,可以通过该对象获取所有相关的发票行项目。
总结: 在Acumatica中获取已创建表单的缓存,需要确保已经启用了缓存功能,并使用PXSelect或PXSelectJoin等查询方法来获取缓存数据。通过访问缓存对象的属性,可以获取具体的字段值。如果需要获取相关记录,可以使用PXParent和PXChildren等属性来获取。
领取专属 10元无门槛券
手把手带您无忧上云