MVC 下拉框聯動效果(單選)

下拉框聯動效果,我們以部門--職位為例,選擇部門時,關聯到該部門的職位.下拉框的寫法就不多說了,詳細請參照前文.

視圖:

其中,dept是部門的屬性,deptlist是部門下拉框的屬性,job是職位的屬性,joblist是職位下拉框的屬性,下拉框綁定請參照前文

@using (Html.BeginForm("aaai003sch", "aaa", FormMethod.Post, new { @class = "form-horizontal", role = "form" }))
{
    @Html.AntiForgeryToken()
    <div class="modal-body">
        <div class="form-horizontal">
               <div class="form-group">
                    @Html.LabelFor(m => m.dept, new { @class = "col-sm-2 control-label" })
                        <div class="col-sm-10">
                            @Html.DropDownListFor(model => model.dept, Model.deptlist, new { @class = "form-control select2 ", style = "width: 100%;" })
                            @Html.ValidationMessageFor(m => m.dept, "", new { @class = "text-danger" })
                       </div>
               </div>
               <div class="form-group">
                @   Html.LabelFor(m => m.job, new { @class = "col-sm-2 control-label" })
                       <div class="col-sm-10">
                            @Html.DropDownListFor(model => model.job, Model.joblist, new { @class = "form-control select2 page-select2-area", style = "width: 100%;" })
                            @Html.ValidationMessageFor(m => m.job, "", new { @class = "text-danger" })
                       </div>
               </div>
        </div>
    </div>
</div>

當部門變動的時候,職位也相應改變:

    //根據城市獲取酒店
    $("#dept").change(function () {
        var url = rootUrl + "aaa/GetJobByDept";
            var dept = $(this).val();   //獲取部門的值
            var job = $("#job");
            job.empty();     //清空當前職位的值
            //這句很重要，因我們用的是select2插件，若沒有用這個插件可以去掉這句
            job.select2('val', '');
            $.ajax({
                cache: false,
                type: "GET",
                url: url,
                data: { "Dept": dept},
                success: function (data) {
                    $.each(data, function (id, option) {

                        job.append($('<option></option>').val(option.Id).html(option.Name));
                    });
                    job.trigger('change');
                },
                error: function (xhr, ajaxOptions, thrownError) {
                    toastr["error"]("請選擇部門");
                }
            });
    });

執行js里的URL,這個程式寫在控制器里:

        [Description("根據部門獲取職位")]
        [AcceptVerbs(HttpVerbs.Get)]
        [LoginAllowView]
        public ActionResult GetJobByDept(string dept)
        {
            if (String.IsNullOrEmpty(dept))
            {
                throw new ArgumentNullException("dept");
            }
            StringBuilder sb = new StringBuilder();
            sb = new StringBuilder();
            sb.Append(" SELECT jobid,jobname ");
            sb.Append(" FROM job_file ");
            sb.Append(" LEFT JOIN dept_file ON jobdept = deptid ");
            sb.AppendFormat(" WHERE deptid='{0}'", dept);
            DataTable dt = sqlHelper.getData(sb.ToString());
            var result = dt.AsEnumerable().Select(row => new Item
            {
                Name = Utils.ObjToStr(row["jobname"]),
                Id = Utils.ObjToInt(row["jobid"], 0)
            }).ToList();
            return Json(result, JsonRequestBehavior.AllowGet);
        }