c# - 选择项目时,剃刀过滤器下拉列表不过滤
问题描述
您好,我有一个页面有两个完全相同的过滤器,但其中一个无法正常工作,我不确定我的代码有什么问题!
先感谢您!
这是我在视图中的代码:
@Html.DropDownList("Projects", (SelectList)ViewBag.Projects, "请选择一个项目...", htmlAttributes: new { @class = "form-control" })
这是我的控制器中的代码:
public ActionResult Index(string projects, int? EmployeeId)
{
var status = db.Projects.Select(m => new SelectListItem { Value =
m.ProjectName.ToString(), Text = m.ProjectName }).Distinct().ToList();
ViewBag.Projects = new SelectList(status, "Value", "Text");
ViewBag.EmployeeId = db.Employees.Select(p => new SelectListItem
{
Text = p.FirstName + " " + p.LastName,
Value = p.ID.ToString()
});
var employee = db.EmployeeTimesheets.Where(student => student.Projects != null);
if (!string.IsNullOrEmpty(projects))
{
employee = employee.Where(student => student.Projects == projects);
}
if (EmployeeId > 0)
{
employee = employee.Where(student => student.EmployeeId == EmployeeId);
}
return View(employee);
}