图瓦卢 ∗ UNEP/POPS/POPRC.2/6。

Dim getOrders = From d In db.Orders _
                Where d.Status = OrderStatus.Approved _
                Select d

  Then a for loop adding parameters via Predicatebuilder... 


If over2000 = True Then
      over 2000
    predicate1 = predicate1.And(Function(d) (d.OrderProducts.Sum(Function(c) c.ProductQty > 2000)))

Else
      under 2000
    predicate1 = predicate1.And(Function(d) (d.OrderProducts.Sum(Function(c) c.ProductQty < 2000)))

End If

basePredicate = basePredicate.Or(predicate1)


  End For loop

getOrders = getOrders.Where(basePredicate)

页: 1 页: 1