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