生成动态 IQueryable来自英孚

发布于 2024-12-17 11:05:46 字数 342 浏览 0 评论 0原文

我有一个充满订单的表，其中每个订单都有一个状态（例如：失败、拒绝、待处理、取消或成功）

如何编写动态查询来按状态返回订单，其中我要经过一个或多个州？

即所有失败、拒绝或取消的订单：

IQueryable<MyType> query = from o in Model.Orders
                           where o.OrderStatus == ("Failed" || "Denied" || "Cancelled")
                           select o;

原文

I have a table full of orders, where each order has a state (for example: failed, denied, pending, cancelled or success)

How can I write a dynamic query to return orders, by state, where I'm passing one or more states?

ie something like all failed, denied or cancelled orders:

IQueryable<MyType> query = from o in Model.Orders
                           where o.OrderStatus == ("Failed" || "Denied" || "Cancelled")
                           select o;

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

中二柚 2024-12-24 11:05:46

您可以尝试使用Contains方法

string[] status = {"Failed", "Denied", "Cancelled"};

IQueryable<MyType> query = from o in Model.Orders
                           where status.Contains(o.OrderStatus)
                           select o;

You can try to use the Contains method

string[] status = {"Failed", "Denied", "Cancelled"};

IQueryable<MyType> query = from o in Model.Orders
                           where status.Contains(o.OrderStatus)
                           select o;

回复收藏 0 原文

~没有更多了~