javascript - 带有级联下拉列表的搜索表单在 asp.net mvc 中不起作用-6ren

javascript - 带有级联下拉列表的搜索表单在 asp.net mvc 中不起作用

转载作者：行者123 更新时间：2023-11-30 16:37:09

我正在创建 asp.net mvc 5 应用程序，在那个应用程序中我有一个模块来过滤带有多个下拉列表的结果，

结果取决于下拉菜单

搜索表单和搜索结果显示在同一 View 页面中

我已经在 stackoverflow 社区的帮助下实现了这个模块，

在那个模块中，它在第一个下拉菜单中工作正常，但是当我放置多个下拉菜单时，它变成了锁，当我点击搜索按钮时没有结果

这是模型类

    public class ProductCollection
    {
        public string Product_ID { get; set; }        

        public string ProductType_ID { get; set; }
        public string Product_TypeEn { get; set; }
        public string Product_TypeAr { get; set; }

        public string ProductCategory_ID { get; set; }
        public string Product_CategoryEn { get; set; }
        public string Product_CategoryAr { get; set; }

        public string Country_ID { get; set; }
        public string Subsidary_Country { get; set; }

        public string Susidary_ID { get; set; }
        public string Susidary_NameEn { get; set; }
        public string Susidary_NameAr { get; set; }

        public string Product_Name_En { get; set; }
        public string Product_Description_En { get; set; }

        public string Product_Name_Ar { get; set; }
        public string Product_Description_Ar { get; set; }

        public string Status { get; set; }


        public string CreatedBy { get; set; }
        public Nullable<System.DateTime> CreatedDate { get; set; }
        public string UpdatedBy { get; set; }
        public Nullable<System.DateTime> UpdatedDate { get; set; }
    }

    // View models
    public class SearchVM
    {
        public string Type { get; set; }
        public string Category { get; set; }
        public string Country { get; set; }
        public string Subsidary { get; set; }
        public DateTime? Date { get; set; }
        public SelectList TypeList { get; set; }
        public SelectList CategoryList { get; set; }
        public SelectList CountryList { get; set; }
        public SelectList SubsidaryList { get; set; }
    }
    public class ProductsVM
    {
        public int ID { get; set; }
        public string Name { get; set; }
        public string Category { get; set; }
    }

    // Data model  

    public class Type
    {
        public string ProductTypeID { get; set; }
        public string ProductTypeNameEn { get; set; }

   }

    public class Category
    {
        public string ProductCategoryID { get; set; }
        public string ProductCategoryNameEn { get; set; }
    }

    public class Country
    {
        public string Country_ID { get; set; }
        public string Country_Name { get; set; }
    }

    public class Subsidary
    {
        public string SubsidaryID { get; set; }
        public string SubsidaryNameEn { get; set; }
    }

这是查看页面

@model project_name.Models.SearchVM

@{
    ViewBag.Title = "Product_Search2";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>Product Search</h2>

<!DOCTYPE html>
<!-- template from http://getbootstrap.com/getting-started -->

<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Bootstrap 101 Template</title>

    <!-- CSS Includes -->
    <link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css">

    <style type="text/css">
        table {
            width: 100%;
            margin-top: 25px;
        }
    </style>
</head>

<body>
    <div class="container">
        <div class="col-md-6 col-md-offset-3">
            <h1>Hello Stranger</h1>

            @using (Html.BeginForm())
            {
                <div class="form-group">
                    @Html.LabelFor(m => m.Type)
                    @Html.DropDownListFor(m => m.Type, Model.TypeList, "Select the type", new { @class = "form-control" })

                    @Html.LabelFor(m => m.Category)
                    @Html.DropDownListFor(m => m.Category, Model.CategoryList, "Select the category", new { @class = "form-control" })

                    @Html.LabelFor(m => m.Country)
                    @Html.DropDownListFor(m => m.Country, Model.CountryList, "Select the country", new { @class = "form-control" })

                    @Html.LabelFor(m => m.Subsidary)
                    @Html.DropDownListFor(m => m.Subsidary, Model.SubsidaryList, "Select the subsidary", new { @class = "form-control" })
                </div>

                    <button id="search" type="button" class="btn btn-success submit">Search</button>
            }

            <table>
                <thead>
                    <tr><th>ID</th><th>Product name</th><th>Category</th><th>Action</th></tr>
                </thead>
                <tbody id="table"></tbody>
            </table>

            <table id="template" style="display: none;">
                <tr><td></td><td></td><td></td><td><a>Edit</a></td></tr>
                <table>



        </div>
    </div>

    <!-- JS includes -->
    <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
    <script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>

    <script src="//ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.min.js"></script>
    <script src="//ajax.aspnetcdn.com/ajax/mvc/4.0/jquery.validate.unobtrusive.min.js"></script>

    <script type="text/javascript">

            var url = '@Url.Action("FetchProducts")';
            var editUrl = '@Url.Action("Edit")';
            var type = $('#Type');

            var template = $('#template');
            var table = $('#table');
            $('#search').click(function() {
                table.empty();
                $.getJSON(url, { type: type.val(), category: category.val(), country: country.val(), subsidary: subsidary.val()}, function (data) {
                    $.each(data, function(index, item) {
                        var clone = template.clone();
                        var cells = clone.find('td');
                        cells.eq(0).text(item.ID);
                        cells.eq(1).text(item.Name);
                        cells.eq(2).text(item.Category);
                        var href = '@Url.Action("Edit")' + '/' + item.ID;
                        cells.eq(3).children('a').attr('href', href);
                        table.append(clone.find('tr'));
                    });
                });
            });



    </script>
</body>
</html>

这是 Controller 类

公共(public)类 HomeController : Controller

    {
        public ProjectEntities db = new ProjectEntities();
        [HttpGet]
        public ActionResult Product_Search2()
        {
            var types = db.AB_ProductType.ToList();
            var categories = db.AB_ProductTypeCategory.ToList();
            var countries = db.AB_Country.ToList();
            var subsidiaries = db.AB_Subsidary.ToList();

            // ...
            SearchVM model = new SearchVM()
            {
                TypeList = new SelectList(types, "ProductTypeID", "ProductTypeNameEn"),
                CategoryList = new SelectList(categories, "ProductCategoryID", "ProductCategoryNameEn"),
                CountryList = new SelectList(countries, "Country_ID", "Country_Name"),
                SubsidaryList = new SelectList(subsidiaries, "SubsidaryID", "SubsidaryNameEn")
                // ....
            };

            return View(model);
        }


        [HttpGet]
        public JsonResult FetchProducts(string type, string category, string country, string subsidary, DateTime? date)
        {
            IEnumerable<ProductCollection> products = (from P in db.AB_Product
                                                join S in db.AB_Subsidary on P.Subsidary_ID equals S.SubsidaryID
                                                where P.Status != "Active"
                                                select new ProductCollection
                                                {
                                                    Product_ID = P.ProductID,
                                                    ProductType_ID = P.ProductTypeID,
                                                    ProductCategory_ID = P.ProductCategoryID,
                                                    Product_Name_En = P.ProductTitleEn,
                                                    Susidary_ID = P.Subsidary_ID,
                                                    Country_ID = S.Country,
                                                    CreatedDate = P.CreatedDate,
                                                    Status = P.Status

                                                }

                                      ).ToList();


            var data = products.Select(p => new
            {
                ID = p.Product_ID,
                Name = p.Product_Name_En,
                Category = p.ProductCategory_ID
            });

            return Json(data, JsonRequestBehavior.AllowGet);
        }

}

一旦我改变 $.getJSON(url, { type: type.val(), category: category.val(), country: country.val(), subsidary: subsidary.val()}, function (data) { to $.getJSON(url, { type: type.val()}, function (data) { in script in view page this working，我的有什么问题方法？

最佳答案

我认为您错过了 category ,country ,subsidiary 的其余变量在脚本中

在 <script></script> 内传递上述字段的其余值

就像您为 Type 传递了值一样像这样var type = $('#Type');您需要传递其余值。

在 Razor 中，您可以通过提供该模型属性来引用变量

例如:m.Type可以用作 ID #Type在脚本中

关于javascript - 带有级联下拉列表的搜索表单在 asp.net mvc 中不起作用，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/32559194/