我在使用C#和ADO.NET开发MVC Web应用程序，遇到一个问题，即无法根据下拉列表的选择索引更改来显示员工数据。
如果用户从下拉列表中选择“Pending Request”，则应选择员工状态为1的员工。
如果用户从下拉列表中选择“Done Request”，则应选择员工状态为2的员工。
我的代码如下：
表结构
CREATE TABLE [dbo].[Employee](
    [EmployeeId] [int] NOT NULL,
    [EmployeeName] [nvarchar](100) NULL,
    [EmployeeStatus] [int] NULL,
 CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED 
(
    [EmployeeId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [EmployeeStatus]) VALUES (1211, N'ahmed', 1)
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [EmployeeStatus]) VALUES (1222, N'eslam', 1)
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [EmployeeStatus]) VALUES (1223, N'adel', 2)
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [EmployeeStatus]) VALUES (1224, N'mohamed', 2)
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [EmployeeStatus]) VALUES (1225, N'mosh', 2)
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [EmployeeStatus]) VALUES (1227, N'ali', 1)
存储过程有逻辑
create Procedure [dbo].[LoadDropDownEmployee] 
@EmployeeStatus int
as  
begin  
   select * from Employee  where EmployeeStatus=@EmployeeStatus
End 
create Procedure [dbo].[GetEmployees]  
as  
begin  
   select *from Employee  
End 
员工模型
public class EmpModel
{
    public int EmployeeId { get; set; }
    public string EmployeeName { get; set; }
    public int EmployeeStatus { get; set; }
}
员工仓库有用于控制器的函数
public List<EmpModel> GetAllEmployees()
{
    connection();
    List<EmpModel> EmpList = new List<EmpModel>();
    SqlCommand com = new SqlCommand("GetEmployees", con);
    com.CommandType = CommandType.StoredProcedure;
    SqlDataAdapter da = new SqlDataAdapter(com);
    DataTable dt = new DataTable();
    con.Open();
    da.Fill(dt);
    con.Close();   
    foreach (DataRow dr in dt.Rows)
    {
        EmpList.Add(
            new EmpModel
            {
                EmployeeId = Convert.ToInt32(dr["EmployeeId"]),
                EmployeeName = Convert.ToString(dr["EmployeeName"]),
                EmployeeStatus = Convert.ToInt32(dr["EmployeeStatus"])
            }
        );
    }
    return EmpList;
}
public List<EmpModel> LoadDropDownLists(int EmployeeStatus)
{
    connection();
    List<EmpModel> EmpList = new List<EmpModel>();
    SqlCommand com = new SqlCommand("LoadDropDownEmployee", con);
    com.CommandType = CommandType.StoredProcedure;
    com.Parameters.Add("@EmployeeStatus", SqlDbType.VarChar, 50);
    com.Parameters["@EmployeeStatus"].Value = EmployeeStatus;
    SqlDataAdapter da = new SqlDataAdapter(com);
    DataTable dt = new DataTable();
    con.Open();
    da.Fill(dt);
    con.Close();  
    foreach (DataRow dr in dt.Rows)
    {
        EmpList.Add(
            new EmpModel
            {
                EmployeeId = Convert.ToInt32(dr["EmployeeId"]),
                EmployeeName = Convert.ToString(dr["EmployeeName"])
            }
        );
    }
    return EmpList;
}
控制器Employee
public class EmployeeController : Controller
{
    public ActionResult LoadDropDownList(int EmployeeStatus)
    {
        EmpRepository EmpRepo = new EmpRepository();
        return View();
    }
    public ActionResult GetAllEmpDetails()
    {
        EmpRepository EmpRepo = new EmpRepository();
        ModelState.Clear();
        return View(EmpRepo.GetAllEmployees());
    }
}
视图GetAllEmpDetails.cshtml
@model IEnumerable<Ado.netMvc.Models.EmpModel>
@{
    ViewBag.Title = "GetAllEmpDetails";
}
<h2>GetAllEmpDetails</h2>
<th>
    <select class="form-control" id="statusselect" name="statusselectName">
        <option>Select Status</option>
        <option>Pending Request</option>
        <option>All requests </option>
    </select>
</th>
<table class="table">
    <tr>
        <th>
            @Html.DisplayNameFor(model => model.EmployeeId)
        </th>
        <th>
            @Html.DisplayNameFor(model => model.EmployeeName)
        </th>
        <th>
            @Html.DisplayNameFor(model => model.EmployeeStatus)
        </th>
        <th></th>
    </tr>
    @foreach (var item in Model)
    {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.EmployeeId)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.EmployeeName)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.EmployeeStatus)
            </td>
        </tr>
    }
</table>
**所以，在下拉列表`statusselect`的选择索引更改时，如何在视图`GetAllEmpDetails`上获取数据？**

@model IEnumerable<Ado.netMvc.Models.EmpModel>
@{
    ViewBag.Title = "GetAllEmpDetails";
}
<script type="text/javascript">
    $(document).ready(function () {
        $("#statusselect").change(function () {
              var postData = {
                  empStatus: $(this).val()
                };
                $.ajax({
                    cache: false,
                    type: 'POST',
                    url: '../Employee/GetAllEmpDetailsByStatus',
                    data: postData,
                    dataType: 'json',
                    success: function (data) {
                        $("#employeeContainer").html(data.html);
                    },
                    failure: function () {
                    }
                });
        });
    });
</script>
<h2>GetAllEmpDetails</h2>
<th>
    <select class="form-control" id="statusselect" name="statusselectName">
        <option value="1">选择状态</option>
        <option value="2">待处理请求</option>
        <option value="0">所有请求</option>
    </select>
</th>
<div id="employeeContainer">
  @Html.Partial("_AllEmployee", Model)
</div>

@model IEnumerable<Ado.netMvc.Models.EmpModel>
<table class="table">
    <tr>
        <th>
            员工ID
        </th>
        <th>
            员工姓名
        </th>
        <th>
             员工状态
        </th>
    </tr>
    @foreach (var item in Model)
    {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.EmployeeId)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.EmployeeName)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.EmployeeStatus)
            </td>
        </tr>
    }
</table>

public class EmployeeController : Controller
{
    [HttpPost]
    public ActionResult GetAllEmpDetailsByStatus(int empStatus)
    {
        EmpRepository EmpRepo = new EmpRepository();
        ModelState.Clear();
        var theData = EmpRepo.LoadDropDownLists(empStatus);
        return Json(new
        {
            html = RenderPartialViewToString("_AllEmployee", theData)
        });
    }
    public virtual string RenderPartialViewToString(string viewName, object model)
    {
        if (string.IsNullOrEmpty(viewName))
            viewName = this.ControllerContext.RouteData.GetRequiredString("action");
        this.ViewData.Model = model;
        using (var sw = new StringWriter())
        {
            ViewEngineResult viewResult = System.Web.Mvc.ViewEngines.Engines.FindPartialView(this.ControllerContext, viewName);
            var viewContext = new ViewContext(this.ControllerContext, viewResult.View, this.ViewData, this.TempData, sw);
            viewResult.View.Render(viewContext, sw);
            return sw.GetStringBuilder().ToString();
        }
    }
}