ASP.NET MVC下拉框值传递失败及数据库更新问题求助

嘿，我看了你遇到的这俩问题——点击更新按钮时下拉框值传不过去，而且数据库也没完成更新，这都是MVC开发里常见的表单绑定和视图初始化坑，咱们一步步来搞定：

一、解决下拉框值回显与传递问题 #

你的下拉框（尤其是Department、Course、Subject）存在两个核心问题：初始化时没有选中原有数据，以及动态加载的下拉框（Course/Subject）在页面加载时没有自动填充对应选项。

1. 修复Department下拉框的回显 #

你现在手动循环生成Department的option，但没根据模型的DepartmentId设置选中状态，修改Edit.cshtml里的Department下拉框代码：

<select name="DepartmentId" id="DepartmentId">
    @foreach (var department in ViewBag.DepartmentId)
    {
        <!-- 增加selected判断，匹配模型的DepartmentId -->
        <option value="@department.ID" @(Model.DepartmentId == department.ID ? "selected" : "")>@department.Code</option>
    }
</select>

2. 修复动态加载的Course/Subject下拉框初始化 #

因为Course和Subject是通过AJAX动态加载的，页面初始化时不会自动根据模型里的CourseId和SubjectID加载对应选项，需要在脚本里手动触发加载并选中：
修改Edit.cshtml里的Script部分：

$(document).ready(function () {
    // 页面加载完成后，先处理Department的初始化
    var deptId = $("#DepartmentId").val();
    if (deptId) {
        // 触发Department的change事件，加载对应Course
        $("#DepartmentId").trigger("change");
        
        // 延迟一点（避免AJAX还没返回），处理Course的选中和Subject加载
        setTimeout(function() {
            var courseId = "@Model.CourseId";
            if (courseId) {
                $("#CourseId").val(courseId);
                // 触发Course的change事件，加载对应Subject
                $("#CourseId").trigger("change");
                
                // 再延迟处理Subject的选中
                setTimeout(function() {
                    var subjectId = "@Model.SubjectID";
                    if (subjectId) {
                        $("#SubjectID").val(subjectId);
                    }
                }, 100);
            }
        }, 100);
    }

    // 保留原有的Department change事件代码
    $("#DepartmentId").change(function () {
        var deptId = $("#DepartmentId").val();
        $("#CourseId").empty();
        $("#CourseId").append('<option value="">Select</option>');
        var json = { DepartmentId: deptId };
        $.ajax({
            type: "POST",
            url: '/AllocateClassRooms/GetCourseByDepartmentId',
            contentType: "application/json; charset=utf-8",
            data: JSON.stringify(json),
            success: function (data) {
                $.each(data, function (key, value) {
                    $("#CourseId").append('<option value="' + value.Id + '">' + value.Code + '</option>');
                });
            }
        });
    });

    // 保留原有的Course change事件代码
    $("#CourseId").change(function () {
        var courId = $("#CourseId").val();
        $("#SubjectID").empty();
        $("#SubjectID").append('<option value="">Select</option>');
        var json = { CourseId: courId };
        $.ajax({
            type: "POST",
            url: '/AllocateClassRooms/GetSubjectByCourseId',
            contentType: "application/json; charset=utf-8",
            data: JSON.stringify(json),
            success: function (data) {
                $.each(data, function (key, value) {
                    $("#SubjectID").append('<option value="' + value.SubjectID + '">' + value.Code + '</option>');
                });
            }
        });
    });
});

二、解决数据库更新失败问题 #

你的HttpPost Edit方法存在几个潜在问题：数据库上下文未正确实例化、未检查模型验证状态、实体更新方式不够安全，咱们逐一修复：

1. 修复数据库上下文实例化 #

你的HttpGet方法用了using包裹上下文，但HttpPost方法直接用db，如果没有在方法内实例化，会导致上下文异常。另外，建议用查询现有实体再更新字段的方式，比直接设置EntityState.Modified更安全（避免覆盖未提交的字段）。

修改AllocateClassRoomsController.cs里的HttpPost Edit方法：

[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Edit(AllocateClassRoom allocateClassRoom)
{
    // 先检查模型验证是否通过
    if (!ModelState.IsValid)
    {
        // 验证失败时重新填充ViewBag，返回视图
        using (UniversityDbContext db = new UniversityDbContext())
        {
            ViewBag.CourseId = new SelectList(db.Courses, "Id", "Code", allocateClassRoom.CourseId);
            ViewBag.SubjectID = new SelectList(db.Subjects, "SubjectID", "Code", allocateClassRoom.SubjectID);
            ViewBag.DepartmentId = db.Departments.ToList();
            ViewBag.RoomId = new SelectList(db.Rooms, "Id", "RoomNo", allocateClassRoom.RoomId);
        }
        return View(allocateClassRoom);
    }

    using (UniversityDbContext db = new UniversityDbContext())
    {
        // 从数据库查询现有的分配记录
        var existingAllocation = db.AllocateClassRooms.Find(allocateClassRoom.Id);
        if (existingAllocation == null)
        {
            return HttpNotFound();
        }

        // 手动更新需要修改的字段
        existingAllocation.DepartmentId = allocateClassRoom.DepartmentId;
        existingAllocation.CourseId = allocateClassRoom.CourseId;
        existingAllocation.SubjectID = allocateClassRoom.SubjectID;
        existingAllocation.RoomId = allocateClassRoom.RoomId;
        existingAllocation.date = allocateClassRoom.date;
        existingAllocation.Day = allocateClassRoom.Day;
        existingAllocation.From = allocateClassRoom.From;
        existingAllocation.To = allocateClassRoom.To;
        
        // 处理时间转换
        existingAllocation.StartTime = DateTime.ParseExact(allocateClassRoom.From, "h:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
        existingAllocation.FinishTime = DateTime.ParseExact(allocateClassRoom.To, "h:mm tt", CultureInfo.InvariantCulture).TimeOfDay;

        // 保存更改
        db.SaveChanges();
        return RedirectToAction("Index");
    }
}

2. 修复HttpGet Edit方法的缺失代码 #

你的HttpGet方法里用了getAllocationDetails变量，但没看到查询逻辑，补充这段代码：

[HttpGet]
public ActionResult Edit(int ID)
{
    using (UniversityDbContext db=new UniversityDbContext())
    {
        // 从数据库查询要编辑的记录
        var getAllocationDetails = db.AllocateClassRooms.Find(ID);
        if (getAllocationDetails == null)
        {
            return HttpNotFound();
        }

        ViewBag.SubjectID = new SelectList(db.Subjects, "SubjectID", "Code");
        ViewBag.CourseId = new SelectList(db.Courses, "Id", "Code");
        ViewBag.DepartmentId = db.Departments.ToList();
        // 补充RoomId的ViewBag，因为Edit视图里用到了
        ViewBag.RoomId = new SelectList(db.Rooms, "Id", "RoomNo", getAllocationDetails.RoomId);

        AllocateClassRoom allocateClassRoom = new AllocateClassRoom();
        allocateClassRoom.Id = getAllocationDetails.Id; // 别忘记传递Id！
        allocateClassRoom.DepartmentId = getAllocationDetails.DepartmentId;
        allocateClassRoom.CourseId = getAllocationDetails.CourseId;
        allocateClassRoom.SubjectID = getAllocationDetails.SubjectID;
        allocateClassRoom.RoomId = getAllocationDetails.RoomId;
        allocateClassRoom.date = getAllocationDetails.date;
        allocateClassRoom.Day = getAllocationDetails.Day;
        allocateClassRoom.From = getAllocationDetails.From;
        allocateClassRoom.To = getAllocationDetails.To;
        allocateClassRoom.StartTime = getAllocationDetails.StartTime;
        allocateClassRoom.FinishTime = getAllocationDetails.FinishTime;

        return View(allocateClassRoom);
    }
}

注意：一定要传递Id属性，否则Post时无法找到要更新的实体！

最后再检查两个关键点 #

1. 用浏览器F12的网络面板查看Post请求的Form Data，确认DepartmentId、CourseId、SubjectID这些值是否正确提交到后台。
2. 开启调试模式，在Post方法里打断点，查看allocateClassRoom的属性值是否正确绑定。

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