LINQ：如何向 LINQ 查询添加多个变量？

发布于 2024-11-19 07:10:55 字数 919 浏览 6 评论 0原文

我有一个名为 List 的控制器操作，它采用以下参数

int Filer、int Field、int Operator、string QueryValue

public enum Filter
{
    ActiveEmployee,
    OnHoldEmployee,
    InactiveEmployee
}
public enum Field
{
    Name,
    ABRAID,
    JobTitle,
    LocationCode,
    Department
}
public enum Operator
{
    Contains,
    StartWith,
    EndWith,
    EqualTo
}

可能的情况：

Select employee where Name Equals "Value"

Select employee where Name EndWith with "Value"

Select employee where Name StartWith with "Value"

Select employee where JobTitle Contains "Value"

Select employee where Department Equals "Value"

我使用 LINQ 来查询数据库

Employees = from p in DB.Employees
            where p.AWCID.Contains(queryvalue)
            select p;

但这意味着我必须编写嵌套的 switch case 来覆盖所有情况。覆盖 3 个变量需要 180 多行代码，

我不太了解 LINQ 语法支持多个值。

有什么想法吗？谢谢。

原文

I have a a controller action called List that take the following parameters

int Filer, int Field, int Operator, string QueryValue

public enum Filter
{
    ActiveEmployee,
    OnHoldEmployee,
    InactiveEmployee
}
public enum Field
{
    Name,
    ABRAID,
    JobTitle,
    LocationCode,
    Department
}
public enum Operator
{
    Contains,
    StartWith,
    EndWith,
    EqualTo
}

Possible cases:

Select employee where Name Equals "Value"

Select employee where Name EndWith with "Value"

Select employee where Name StartWith with "Value"

Select employee where JobTitle Contains "Value"

Select employee where Department Equals "Value"

I'm using LINQ to query the database

Employees = from p in DB.Employees
            where p.AWCID.Contains(queryvalue)
            select p;

But thats mean I have to wite nested switch case to cover all cases.
It's over 180 lines of code to cover 3 variables,

I'm not very aware with LINQ syntax to support multiple values.

Any thoughts?
Thanks.

分享到QQ

分享到微博

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

发布评论

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

不即不离 2024-11-26 07:10:55

假设查询只是一种类型的查询（contains、startswith 等），我会尝试这样的操作：

public IQueryable<Employee> GetEmployees(queryType, value)
{
    var Employees = from p in DB.Employees
            select p;

    // could use a switch statement here as well
    if (queryType == "contains")
        return Employees.where(e => e.contains(value));
    else if...
}

您还可以将查询类型设置为枚举。

Assuming the query will be only one type of query (contains, startswith, etc.), I would try something like this:

public IQueryable<Employee> GetEmployees(queryType, value)
{
    var Employees = from p in DB.Employees
            select p;

    // could use a switch statement here as well
    if (queryType == "contains")
        return Employees.where(e => e.contains(value));
    else if...
}

You could also make the query types an enum.

回复收藏 0 原文