ASP.NET MVC中通过分类下拉列表实现库存商品搜索求助

Hey there! Let's walk through how to get this search functionality working smoothly. You've already got the dropdown value making its way to the controller via Request["DDLName"]—great start! Here's what to do next:

1. 控制器中接收并处理参数 #

First, let's make sure your controller action captures both the selected category value and the search box input. You can use Request directly, but adding parameters to your action method is cleaner. For example:

public ActionResult Index(string ddlCategory, string searchTerm)
{
    // 获取下拉框选中值，兼容两种传参方式
    var selectedCategory = ddlCategory ?? Request["DDLName"];
    
    // 处理搜索词，默认空字符串避免null报错
    var searchKeyword = searchTerm ?? "";
    
    // 接下来写查询逻辑...
}

2. 构建数据库查询（以Entity Framework为例） #

Since your database follows a Category > SubCategory > StockItems hierarchy, you'll need to join these tables to filter stock items under the selected category. Here's a LINQ query example:

// 假设你的DbContext包含这三个DbSet
var filteredItems = db.StockItems
    // 关联StockItems和SubCategory
    .Join(db.SubCategories,
          item => item.SubCategoryId,
          subCat => subCat.Id,
          (item, subCat) => new { StockItem = item, SubCategory = subCat })
    // 关联SubCategory和Category
    .Join(db.Categories,
          combined => combined.SubCategory.CategoryId,
          cat => cat.Id,
          (combined, cat) => new { combined.StockItem, Category = cat })
    // 过滤选中的分类（如果下拉框传的是ID，记得转成int类型匹配）
    .Where(x => x.Category.Name == selectedCategory || x.Category.Id.ToString() == selectedCategory)
    // 过滤搜索关键词（匹配商品名称或描述）
    .Where(x => x.StockItem.Name.Contains(searchKeyword) || x.StockItem.Description.Contains(searchKeyword))
    // 提取最终的StockItems列表
    .Select(x => x.StockItem)
    .ToList();

小提示：如果下拉框传递的是分类ID（数字），优先用ID匹配，比匹配分类名称更高效，还能避免名称重复的问题。

3. 将结果传递给视图 #

Once you have the filtered list, pass it to the view. Using a strongly-typed view model is better for maintainability, but ViewBag works for quick implementations:

// 强类型视图模型方式（推荐）
var viewModel = new HomeViewModel
{
    SelectedCategory = selectedCategory,
    SearchKeyword = searchKeyword,
    FilteredStockItems = filteredItems
};
return View(viewModel);

// 或者用ViewBag的简单方式
// ViewBag.FilteredItems = filteredItems;
// ViewBag.SelectedCat = selectedCategory;
// ViewBag.SearchWord = searchKeyword;

4. 完善视图中的表单与结果展示 #

Make sure your dropdown and search box are wrapped in a form to submit to the controller action. Here's the HTML structure:

@using (Html.BeginForm("Index", "Home", FormMethod.Get))
{
    <!-- 分类下拉框 -->
    @Html.DropDownList("DDLName", ViewBag.CategoryOptions as SelectList, "选择分类", new { @class = "form-control" })
    
    <!-- 搜索框 -->
    <input type="text" name="searchTerm" placeholder="搜索商品..." value="@Model.SearchKeyword" class="form-control" />
    
    <!-- 提交按钮 -->
    <button type="submit" class="btn btn-primary">搜索</button>
}

<!-- 展示搜索结果 -->
@foreach (var item in Model.FilteredStockItems)
{
    <div class="stock-item-card">
        <h4>@item.Name</h4>
        <p>@item.Description</p>
        <span>库存：@item.Quantity</span>
        <!-- 其他商品信息 -->
    </div>
}

额外优化建议 #

• 默认情况处理：如果用户没选分类，返回所有商品；如果没输入搜索词，返回选中分类下的全部商品。
• 分页功能：如果商品数量较多，添加分页避免一次性加载大量数据。
• 数据库索引：在Category.Id、SubCategory.CategoryId、StockItems.SubCategoryId以及商品名称/描述字段创建索引，提升查询速度。
• 防注入：不用担心，LINQ和Entity Framework会自动处理参数化查询，避免SQL注入风险。

内容的提问来源于stack exchange，提问作者cyhyraeth