具有搜索功能的多重复选框逻辑

Question

我有3个复选框，我将用于搜索选项。现在，用户可以选择任意数量的搜索。我的问题是：Is there a more convenient way to write out the logic for the search, rather than doing an if/else or boolean check for for every combination? 3复选框还不错，但是我可以看到5+复选框的问题。是否有更好的方法来实现多个选项的搜索功能？

这就是我目前正在做的事情：

    public ViewResult Index(string sortOrder, string currentFilter, string searchString, int? page, string searchFilter)
    {
        ViewBag.CurrentSort = sortOrder;
        ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "year" : "";

        if (searchString != null)
        {
            page = 1;
        }
        else
        {
            searchString = currentFilter;
        }

        ViewBag.CurrentFilter = searchString;
        ViewBag.CurrentFilterSelection = searchFilter;

        var resolutions = from c in db.AllResolutions select c;
        if (!String.IsNullOrEmpty(searchString))
        {
            resolutions = resolutions.Where(c => c.ResolutionYear.Contains(searchString) || c.ResolutionTextShort.Contains(searchString) || c.ResDescription.Contains(searchString));
        }

        switch (sortOrder)
        {
            case "date":
                resolutions = resolutions.OrderByDescending(c => c.ResDate);
                break;
            case "year":
                resolutions = resolutions.OrderByDescending(c => c.ResolutionYear);
                break;
            case "number":
                resolutions = resolutions.OrderByDescending(c => c.ResolutionNumber);
                break;
            default:
                resolutions = resolutions.OrderBy(c => c.ResolutionYear).ThenBy(c => c.ResolutionNumber);
                break;
        }

        int pageSize = 25;
        int pageNumber = (page ?? 1);
        return View(resolutions.ToPagedList(pageNumber, pageSize));
    }

我目前正在3列中搜索数据库，并返回包含searchString的结果。我希望用户能够选择是否要限制他们正在搜索的列。

ie: I want to search for all 2018 resolutions or I want to search all 2018 resolutions with the keyword here

Answer 1

我认为最明确的方法是这样做：

    if(searchForYear)
    {
        resolutions = resolutions.Where(c => c.ResolutionYear.Contains(searchString));
    }
    if (searchForTextShort)
    {
        resolutions = resolutions.Where(c => c.ResolutionTextShort.Contains(searchString));
    }
    //and so on for each other checkbox value

因此，基本上:是的，唯一的方法是"ifs“的”列表“，但是您可以像上面这样拆分查询构建，这样代码仍然可读且易于维护。