private void ApplyFilters(PXSelectBase <CCProcTran> query) { CCPaymentFilter filter = this.Filter.Current; if (!string.IsNullOrEmpty(filter.ProcessingCenterID)) { query.WhereAnd <Where <CCProcTran.processingCenterID, Equal <Current <CCPaymentFilter.processingCenterID> > > >(); } if (!string.IsNullOrEmpty(filter.CustomerClassID)) { query.WhereAnd <Where <Customer.customerClassID, Equal <Current <CCPaymentFilter.customerClassID> > > >(); } if (filter.CustomerID.HasValue) { query.WhereAnd <Where <Customer.bAccountID, Equal <Current <CCPaymentFilter.customerID> > > >(); } if (filter.DisplayType == DisplayTypes.Failed) { query.Join <LeftJoin <CCProcTranH, On <CCProcTranH.docType, Equal <CCProcTran.docType>, And <CCProcTranH.refNbr, Equal <CCProcTran.refNbr>, And <CCProcTranH.tranNbr, Greater <CCProcTran.tranNbr> > > > > >(); query.WhereAnd <Where <CCProcTranH.tranNbr, IsNull, And <Where <CCProcTran.tranStatus, NotEqual <CCTranStatusCode.approved>, Or <CCProcTran.tranStatus, IsNull> > > > >(); } }
private object[] AppendCommitmentCondition(string commitmentNumber, PXSelectBase <ComplianceDocument> query, object[] parameters) { var purchaseOrder = CommitmentDataProvider.GetCommitment(graph, commitmentNumber, POOrderType.RegularOrder); if (purchaseOrder == null) { query.WhereAnd <Where <ComplianceDocument.subcontract.IsEqual <P.AsString> > >(); return(parameters.Append(commitmentNumber)); } query.Join <InnerJoin <ComplianceDocumentReference, On <ComplianceDocumentReference. complianceDocumentReferenceId.IsEqual <ComplianceDocument.purchaseOrder> > > >(); query.WhereAnd <Where <ComplianceDocumentReference.refNoteId.IsEqual <P.AsGuid> > >(); return(parameters.Append(purchaseOrder.NoteID)); }
public virtual void AddCommonFilters(SOOrderFilter filter, PXSelectBase <SOOrder> cmd, AddCommonFiltersDelegate baseMethod) { baseMethod.Invoke(filter, cmd); switch (filter.Action) { case "SO301000$createDCLShipment": cmd.WhereAnd <Where <SOOrder.status, Equal <SOOrderStatus.open> > >(); cmd.WhereAnd <Where <SOOrderExt.usrDCLShipmentCreated, Equal <False>, Or <SOOrderExt.usrDCLShipmentCreated, IsNull> > >(); break; case "SO301000$lumCallDCLShipemnt": cmd.WhereAnd <Where <SOOrder.status, Equal <SOOrderStatus.open> > >(); cmd.WhereAnd <Where <SOOrderExt.usrDCLShipmentCreated, Equal <True> > >(); break; case "SO301000$lumGenerate3PLUKFile": cmd.Join <InnerJoin <vSOSiteMapping, On <SOOrder.orderType, Equal <vSOSiteMapping.orderType>, And <SOOrder.orderNbr, Equal <vSOSiteMapping.orderNbr> > > > >(); cmd.Join <InnerJoin <INSite, On <vSOSiteMapping.siteid, Equal <INSite.siteID> > > >(); cmd.WhereAnd <Where <SOOrder.status, Equal <SOOrderStatus.open> > >(); cmd.WhereAnd <Where <INSite.siteCD.IsEqual <P3PLAttr> > >(); cmd.WhereAnd <Where <SOOrderExt.usrSendToMiddleware, Equal <False>, Or <SOOrderExt.usrSendToMiddleware, IsNull> > >(); break; case "SO301000$lumGenerateYUSENCAFile": cmd.Join <InnerJoin <vSOSiteMapping, On <SOOrder.orderType, Equal <vSOSiteMapping.orderType>, And <SOOrder.orderNbr, Equal <vSOSiteMapping.orderNbr> > > > >(); cmd.Join <InnerJoin <INSite, On <vSOSiteMapping.siteid, Equal <INSite.siteID> > > >(); cmd.WhereAnd <Where <SOOrder.status, Equal <SOOrderStatus.open> > >(); cmd.WhereAnd <Where <INSite.siteCD.IsEqual <YusenAttr> > >(); cmd.WhereAnd <Where <SOOrderExt.usrSendToMiddleware, Equal <False>, Or <SOOrderExt.usrSendToMiddleware, IsNull> > >(); break; case "SO301000$lumGererateYUSENNLFile": cmd.Join <InnerJoin <vSOSiteMapping, On <SOOrder.orderType, Equal <vSOSiteMapping.orderType>, And <SOOrder.orderNbr, Equal <vSOSiteMapping.orderNbr> > > > >(); cmd.Join <InnerJoin <INSite, On <vSOSiteMapping.siteid, Equal <INSite.siteID> > > >(); cmd.WhereAnd <Where <SOOrder.status, Equal <SOOrderStatus.open> > >(); cmd.WhereAnd <Where <INSite.siteCD.IsEqual <YusenAttr> > >(); cmd.WhereAnd <Where <SOOrderExt.usrSendToMiddleware, Equal <False>, Or <SOOrderExt.usrSendToMiddleware, IsNull> > >(); break; } }