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> > > > >(); } }
protected virtual void AddInventoryFilter(PXSelectBase <INSiteStatus> command, LumDeadStockEnqFilter filter) { if (filter.InventoryID != null) { command.WhereAnd <Where <INSiteStatus.inventoryID .IsEqual <LumDeadStockEnqFilter.inventoryID.FromCurrent> > >(); } command.WhereAnd <Where <InventoryItem.itemStatus.IsNotIn < InventoryItemStatus.markedForDeletion, InventoryItemStatus.inactive> > >(); }
protected virtual void AddCommonFilters(SOOrderFilter filter, PXSelectBase <SOOrder> cmd) { if (filter.EndDate != null) { switch (filter.DateSel) { case "S": cmd.WhereAnd <Where <SOOrder.shipDate, LessEqual <Current <SOOrderFilter.endDate> > > >(); break; case "C": cmd.WhereAnd <Where <SOOrder.cancelDate, LessEqual <Current <SOOrderFilter.endDate> > > >(); break; case "O": cmd.WhereAnd <Where <SOOrder.orderDate, LessEqual <Current <SOOrderFilter.endDate> > > >(); break; } } if (filter.StartDate != null) { switch (filter.DateSel) { case "S": cmd.WhereAnd <Where <SOOrder.shipDate, GreaterEqual <Current <SOOrderFilter.startDate> > > >(); break; case "C": cmd.WhereAnd <Where <SOOrder.cancelDate, GreaterEqual <Current <SOOrderFilter.startDate> > > >(); break; case "O": cmd.WhereAnd <Where <SOOrder.orderDate, GreaterEqual <Current <SOOrderFilter.startDate> > > >(); break; } } if (!string.IsNullOrEmpty(filter.CarrierPluginID)) { cmd.WhereAnd <Where <Carrier.carrierPluginID, Equal <Current <SOOrderFilter.carrierPluginID> > > >(); } if (!string.IsNullOrEmpty(filter.ShipVia)) { cmd.WhereAnd <Where <SOOrder.shipVia, Equal <Current <SOOrderFilter.shipVia> > > >(); } if (filter.CustomerID != null) { cmd.WhereAnd <Where <SOOrder.customerID, Equal <Current <SOOrderFilter.customerID> > > >(); } }
protected virtual void AddSiteFilter(PXSelectBase <INSiteStatus> command, LumDeadStockEnqFilter filter) { if (filter.SiteID != null) { command.WhereAnd <Where <INSiteStatus.siteID.IsEqual <LumDeadStockEnqFilter.siteID.FromCurrent> > >(); } }
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)); }
protected virtual void AddItemClassFilter(PXSelectBase <INSiteStatus> command, LumDeadStockEnqFilter filter) { if (filter.ItemClassID != null) { command.WhereAnd <Where <InventoryItem.itemClassID. IsEqual <LumDeadStockEnqFilter.itemClassID.FromCurrent> > >(); } }
protected virtual void AddQtyOnHandFilter(PXSelectBase <INSiteStatus> command) { command.WhereAnd <Where <INSiteStatus.qtyOnHand.IsGreater <decimal0> > >(); var fields = GetNegativePlanFields(); // QtySOBackOrdered + QtyPOPrepared + QtySOBooked + ... < qtyOnHand var lastField = fields.Last(); var whereTypes = new List <Type>() { typeof(Where <,>) }; whereTypes.AddRange( fields.Where(field => field != lastField) .SelectMany(field => new[] { typeof(Add <,>), field })); whereTypes.Add(lastField); whereTypes.Add(typeof(Less <INSiteStatus.qtyOnHand>)); var whereNegativePlansLessOnHand = BqlCommand.Compose(whereTypes.ToArray()); command.WhereAnd(whereNegativePlansLessOnHand); }
protected virtual void AddNoSalesSinceFilter(PXSelectBase <INSiteStatus> command, List <object> parameters, DateTime?noSalesSince) { if (noSalesSince != null) { command.WhereAnd <Where <NotExists <SelectFrom <INItemSiteHistDay> .Where <INItemSiteHistDay.siteID.IsEqual <INSiteStatus.siteID> .And <INItemSiteHistDay.inventoryID.IsEqual <INSiteStatus.inventoryID> > .And <INItemSiteHistDay.subItemID.IsEqual <INSiteStatus.subItemID> > .And <INItemSiteHistDay.sDate.IsGreaterEqual <@P.AsDateTime> > .And <INItemSiteHistDay.qtySales.IsGreater <decimal0> > > > > >(); parameters.Add(noSalesSince); } }
protected override void AppendSerialStatusCmdWhere(PXSelectBase <INLotSerialStatus> cmd, ARTran row, INLotSerClass lotSerClass) { if (row.SubItemID != null) { cmd.WhereAnd <Where <INLotSerialStatus.subItemID, Equal <Current <INLotSerialStatus.subItemID> > > >(); } if (row.LocationID != null) { cmd.WhereAnd <Where <INLotSerialStatus.locationID, Equal <Current <INLotSerialStatus.locationID> > > >(); } else { cmd.WhereAnd <Where <INLocation.salesValid, Equal <boolTrue> > >(); } if (!string.IsNullOrEmpty(row.LotSerialNbr)) { cmd.WhereAnd <Where <INLotSerialStatus.lotSerialNbr, Equal <Current <INLotSerialStatus.lotSerialNbr> > > >(); } else if (lotSerClass.IsManualAssignRequired == true) { cmd.WhereAnd <Where <boolTrue, Equal <boolFalse> > >(); } }
public virtual void ApplyShipmentFilters(PXSelectBase <SOShipment> shCmd, SOShipmentFilter filter, ApplyShipmentFiltersDelegate baseMthod) { baseMthod?.Invoke(shCmd, filter); switch (filter.Action) { // Yusen NL case "SO302000$lumGererateYUSENNLFile": shCmd.WhereAnd <Where <INSite.siteCD.IsEqual <YusenAttr> > >(); shCmd.WhereAnd <Where <SOShipment.status.IsEqual <SOShipmentStatus.open> > >(); break; // Yusen CA case "SO302000$lumGenerateYUSENCAFile": shCmd.WhereAnd <Where <INSite.siteCD.IsEqual <YusenAttr> > >(); shCmd.WhereAnd <Where <SOShipment.status.IsEqual <SOShipmentStatus.open> > >(); break; // P3PL UK case "SO302000$lumGenerate3PLUKFile": shCmd.WhereAnd <Where <INSite.siteCD.IsEqual <P3PLAttr> > >(); shCmd.WhereAnd <Where <SOShipment.status.IsEqual <SOShipmentStatus.open> > >(); break; } }
public virtual System.Type SetWhereStatus(bool?statusOpen, bool?statusInProcess, bool?statusCanceled, bool?statusCompleted, bool?statusClosed, PXSelectBase <FSRouteDocument> commandFilter) { // Open if (statusOpen == true && statusInProcess == false && statusCanceled == false && statusCompleted == false && statusClosed == false) { commandFilter.WhereAnd <Where <FSRouteDocument.status, Equal <ListField_Status_Route.Open> > >(); } // InProcess if (statusOpen == false && statusInProcess == true && statusCanceled == false && statusCompleted == false && statusClosed == false) { commandFilter.WhereAnd <Where <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess> > >(); } // Canceled if (statusOpen == false && statusInProcess == false && statusCanceled == true && statusCompleted == false && statusClosed == false) { commandFilter.WhereAnd <Where <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled> > >(); } // Completed if (statusOpen == false && statusInProcess == false && statusCanceled == false && statusCompleted == true && statusClosed == false) { commandFilter.WhereAnd <Where <FSRouteDocument.status, Equal <ListField_Status_Route.Completed> > >(); } // Closed if (statusOpen == false && statusInProcess == false && statusCanceled == false && statusCompleted == false && statusClosed == true) { commandFilter.WhereAnd <Where <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > >(); } // Open + InProcess if (statusOpen == true && statusInProcess == true && statusCanceled == false && statusCompleted == false && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess> > > >(); } // Open + Canceled if (statusOpen == true && statusInProcess == false && statusCanceled == true && statusCompleted == false && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled> > > >(); } // Open + Completed if (statusOpen == true && statusInProcess == false && statusCanceled == false && statusCompleted == true && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed> > > >(); } // Open + Closed if (statusOpen == true && statusInProcess == false && statusCanceled == false && statusCompleted == false && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > >(); } // InProcess + Canceled if (statusOpen == false && statusInProcess == true && statusCanceled == true && statusCompleted == false && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled> > > >(); } // InProcess + Completed if (statusOpen == false && statusInProcess == true && statusCanceled == false && statusCompleted == true && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed> > > >(); } // InProcess + Closed if (statusOpen == false && statusInProcess == true && statusCanceled == false && statusCompleted == false && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > >(); } // Canceled + Completed if (statusOpen == false && statusInProcess == false && statusCanceled == true && statusCompleted == true && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed> > > >(); } // Canceled + Closed if (statusOpen == false && statusInProcess == false && statusCanceled == true && statusCompleted == false && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > >(); } // Completed + Closed if (statusOpen == false && statusInProcess == false && statusCanceled == false && statusCompleted == true && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Completed>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > >(); } // Open + InProcess + Canceled if (statusOpen == true && statusInProcess == true && statusCanceled == true && statusCompleted == false && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled> > > > >(); } // Open + InProcess + Completed if (statusOpen == true && statusInProcess == true && statusCanceled == false && statusCompleted == true && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed> > > > >(); } // Open + InProcess + Closed if (statusOpen == true && statusInProcess == true && statusCanceled == false && statusCompleted == false && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > >(); } // Open + Canceled + Completed if (statusOpen == true && statusInProcess == false && statusCanceled == true && statusCompleted == true && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed> > > > >(); } // Open + Canceled + Closed if (statusOpen == true && statusInProcess == false && statusCanceled == true && statusCompleted == false && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > >(); } // Open + Completed + Closed if (statusOpen == true && statusInProcess == false && statusCanceled == false && statusCompleted == true && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > >(); } // InProcess + Canceled + Completed if (statusOpen == false && statusInProcess == true && statusCanceled == true && statusCompleted == true && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed> > > > >(); } // InProcess + Canceled + Closed if (statusOpen == false && statusInProcess == true && statusCanceled == true && statusCompleted == false && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > >(); } // InProcess + Completed + Closed if (statusOpen == false && statusInProcess == true && statusCanceled == false && statusCompleted == true && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > >(); } // Canceled + Completed + Closed if (statusOpen == false && statusInProcess == false && statusCanceled == true && statusCompleted == true && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > >(); } // Open + InProcess + Canceled + Completed if (statusOpen == true && statusInProcess == true && statusCanceled == true && statusCompleted == true && statusClosed == false) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed> > > > > >(); } // Open + Canceled + Completed + Closed if (statusOpen == true && statusInProcess == false && statusCanceled == true && statusCompleted == true && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > > >(); } // Open + InProcess + Completed + Closed if (statusOpen == true && statusInProcess == true && statusCanceled == false && statusCompleted == true && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > > >(); } // Open + InProcess + Canceled + Closed if (statusOpen == true && statusInProcess == true && statusCanceled == true && statusCompleted == false && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > > >(); } // InProcess + Canceled + Completed + Closed if (statusOpen == false && statusInProcess == true && statusCanceled == true && statusCompleted == true && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > > >(); } // Open + InProcess + Canceled + Completed + Closed if (statusOpen == true && statusInProcess == true && statusCanceled == true && statusCompleted == true && statusClosed == true) { commandFilter.WhereAnd <Where < FSRouteDocument.status, Equal <ListField_Status_Route.Open>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.InProcess>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Canceled>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Completed>, Or <FSRouteDocument.status, Equal <ListField_Status_Route.Closed> > > > > > >(); } return(null); }
private void AddExtraCondition(PXSelectBase <SOOrder> query) { query.WhereAnd <Where <SOOrder.orderDate, Equal <SOOrder.orderDate> > >(); }
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; } }