C# FilterExpression 的多个条件
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14318160/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Multiple conditions for a FilterExpression
提问by Kittu
I am using Condition expression but I'm unable to add more than one condition to a FilterExpression.
Can any one help? I have posted my source code here.
我正在使用 Condition 表达式，但我无法将多个条件添加到FilterExpression. 任何人都可以帮忙吗？我已经在这里发布了我的源代码。
ConditionExpression with Filters:
带过滤器的条件表达式：
// Filter1
FilterExpression filter1 = new FilterExpression();
filter1.FilterOperator = LogicalOperator.And;
filter1.Conditions.Add(new ConditionExpression("A_LogicalName", ConditionOperator.Equal, id1));
filter1.Conditions.Add(new ConditionExpression("B_LogicalName", ConditionOperator.Equal, id2));
query.Criteria.Filters.Add(filter1);
// Filter2
// 过滤器 2
FilterExpression filter2 = new FilterExpression();
filter2.FilterOperator = LogicalOperator.And;
filter2.Conditions.Add(new ConditionExpression("B_LogicalName", ConditionOperator.Equal, id3));
filter2.Conditions.Add(new ConditionExpression("C_LogicalName", ConditionOperator.Equal, id4));
q_ShoppingCartItemQuantityCheck.Criteria.Filters.Add(filter2);
回答by StampedeXV
Not sure if I understand your question correctly. If I got it right, you want to build a hierarchical expression like this:
不确定我是否正确理解您的问题。如果我猜对了，你想构建一个像这样的分层表达式：
(A_logicalName AND B_LogicalName) OR (B_LogicalName AND C_LogicalName)
(A_logicalName AND B_LogicalName) OR (B_LogicalName AND C_LogicalName)
is that correct?
那是对的吗？
Wouldn't the following then solve your problem?
那么以下内容不能解决您的问题吗？
query.Criteria = new FilterExpression();
query.Criteria.FilterOperator = LogicalOperator.Or;
FilterExpression filter1 = query.Criteria.AddFilter(LogicalOperator.And);
filter1.Conditions.Add(new ConditionExpression("A_LogicalName", ConditionOperator.Equal, id1));
filter1.Conditions.Add(new ConditionExpression("B_LogicalName", ConditionOperator.Equal, id2));
FilterExpression filter2 = query.Criteria.AddFilter(LogicalOperator.And);
filter2.Conditions.Add(new ConditionExpression("B_LogicalName", ConditionOperator.Equal, id2));
filter2.Conditions.Add(new ConditionExpression("C_LogicalName", ConditionOperator.Equal, id3));
See also example on MSDN.
另请参阅MSDN 上的示例。
回答by Konrad Viltersten
Here's what I'm using. For some reason, I find it clearer to grasp. It's probably due to the fact that I use initializer syntax so YMMV.
这是我正在使用的。出于某种原因，我发现它更容易掌握。这可能是因为我使用初始化语法所以 YMMV。
...
Criteria = new FilterExpression
{
FilterOperator = LogicalOperator.Or,
Filters =
{
new FilterExpression
{
FilterOperator = LogicalOperator.And,
Conditions =
{
new ConditionExpression("field1", ConditionOperator.NotNull),
new ConditionExpression("field2", ConditionOperator.NotNull)
}
},
new FilterExpression
{
FilterOperator = LogicalOperator.And,
Conditions =
{
new ConditionExpression("field3", ConditionOperator.NotNull),
new ConditionExpression("field4", ConditionOperator.NotNull)
}
}
}
}
...
回答by r23
Condition:
健康）状况：
(A_logicalName AND B_LogicalName) OR (B_LogicalName AND C_LogicalName)
can be expressed in this way too:
也可以这样表达：
FilterExpression filter = new FilterExpression(LogicalOperator.Or);
FilterExpression filter1 = new FilterExpression(LogicalOperator.And);
filter1.Conditions.Add(new ConditionExpression("A_LogicalName", ConditionOperator.Equal, id1));
filter1.Conditions.Add(new ConditionExpression("B_LogicalName", ConditionOperator.Equal, id2));
FilterExpression filter2 = new FilterExpression(LogicalOperator.And);
filter2.Conditions.Add(new ConditionExpression("B_LogicalName", ConditionOperator.Equal, id2));
filter2.Conditions.Add(new ConditionExpression("C_LogicalName", ConditionOperator.Equal, id3));
filter.AddFilter(filter1);
filter.AddFilter(filter2);
query.Criteria = filter;
A more complex query can be found on MSDN.
可以在MSDN上找到更复杂的查询。
