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