保存一个iEnumerable模型

Question

我的视图有2个日期选择器，其中一个是开始日期，另一个是结束日期。我能够让用户选择开始日期和结束日期，重定向到一个可以在用户可以更改日期，输入时间的时间列表的视图，一旦完成，他们应该能够单击保存按钮，它应该创建一个在数据库中工作的新实例。我得到了毫无问题的视图显示，但是当表单发布我的枚举模型是空的，表单集合只有一个可访问的项目，我不确定为什么。请查看我在下面创建的视图，以了解我的工作，并让我知道您是否能够以任何方式帮助我。

@model IEnumerable<TimeCollection.Models.TimeWorked>
@{
    ViewBag.Title = "Create TimeWorked Range";
}
<h2>Create TimeWorked Range</h2>
@using (Html.BeginForm()) {
    @Html.ValidationSummary(true)
<table>
    <tr>
        <th>
            @Html.DisplayNameFor(model => model.WorkDate)
        </th>
        <th>
            @Html.DisplayNameFor(model => model.HoursWorked)
        </th>
    </tr>
@foreach (var item in Model) {
    <tr>
        @Html.HiddenFor(modelItem => item.EmployeeId)
        <td>
            @Html.EditorFor(modelItem => item.WorkDate)
        </td>
        <td>
            @Html.EditorFor(modelItem => item.HoursWorked)
        </td>
        <td>
            @Html.HiddenFor(modelItem => item.BeenSubmitted)
        </td>
    </tr>
}
</table>
    <p>
        <input type="submit" value="Save" />
    </p>
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace TimeCollection.Models
{
    public class TimeWorked
    {
        public int TimeWorkedId { get; set; }
        public int EmployeeId { get; set; }
        public DateTime WorkDate { get; set; }
        public int HoursWorked { get; set; }
        public bool BeenSubmitted { get; set; }
        public static void CreateTimeWorked(TimeWorked timeWorkedToCreate)
        {
            string insertQuery = string.Format("insert into time_worked (employee_id, work_date, work_hours, been_submitted) values ('{0}', '{1}', '{2}', '{3}')", timeWorkedToCreate.EmployeeId, timeWorkedToCreate.WorkDate.ToString("yyyy/MM/dd"), timeWorkedToCreate.HoursWorked, (timeWorkedToCreate.BeenSubmitted == true ? "1" : "0"));
            SpectrumData.Utility.ExecuteMySqlCommand(SpectrumData.Properties.Resources.SpectrumTSDatabaseConnectionString, insertQuery);
        }
        public static TimeWorked ReadTimeWorked(int timeWorkedId)
        {
            string selectQuery = string.Format("select * from time_worked where time_worked_id = '{0}'", timeWorkedId);
            return ConvertDataRowIntoTimeWorked(SpectrumData.Utility.FillDataSet(SpectrumData.Properties.Resources.SpectrumTSDatabaseConnectionString, selectQuery).Tables[0].Rows[0]);
        }
        public static void UpdateTimeWorked(TimeWorked timeWorkedToUpdate)
        {
            string updateQuery = string.Format("update time_worked set work_date = '{0}', work_hours = '{1}', been_submitted = '{2}' where time_worked_id = '{2}'", timeWorkedToUpdate.WorkDate, timeWorkedToUpdate.HoursWorked, timeWorkedToUpdate.BeenSubmitted, timeWorkedToUpdate.TimeWorkedId);
            SpectrumData.Utility.ExecuteMySqlCommand(SpectrumData.Properties.Resources.SpectrumTSDatabaseConnectionString, updateQuery);
        }
        public static void DeleteTimeWorked(int timeWorkedId)
        {
            string deleteQuery = string.Format("delete from time_worked where time_worked_id = '{0}'", timeWorkedId);
            SpectrumData.Utility.ExecuteMySqlCommand(SpectrumData.Properties.Resources.SpectrumTSDatabaseConnectionString, deleteQuery);
        }
        private static TimeWorked ConvertDataRowIntoTimeWorked(System.Data.DataRow timeWorkedDataRow)
        {
            TimeWorked timeWorked = new TimeWorked();
            timeWorked.BeenSubmitted = (timeWorkedDataRow["been_submitted"].ToString() == "1" ? true : false);
            timeWorked.EmployeeId = int.Parse(timeWorkedDataRow["employee_id"].ToString());
            timeWorked.HoursWorked = int.Parse(timeWorkedDataRow["work_hours"].ToString());
            timeWorked.TimeWorkedId = int.Parse(timeWorkedDataRow["time_worked_id"].ToString());
            timeWorked.WorkDate = DateTime.Parse(timeWorkedDataRow["work_date"].ToString());
            return timeWorked;
        }
    }
}
 public ActionResult CreateTimeWorkedRange(DateTime startDate, DateTime endDate)
    {
        List<Models.TimeWorked> listOfTimeWorked = new List<Models.TimeWorked>();
        DateTime beginning = startDate;
        DateTime ending = endDate;
        while (beginning <= ending)
        {
            Models.TimeWorked dayWorked = new Models.TimeWorked()
            {
                EmployeeId = (Session["InventoryReviewUser"] as SpectrumData.SpectrumTS.InventoryReviewUser).EmployeeId,
                WorkDate = beginning
            };
            if (listOfTimeWorked.Contains(dayWorked) == false)
            {
                listOfTimeWorked.Add(dayWorked);
            }
            beginning = beginning.AddDays(1);
        }
        return View(listOfTimeWorked);
    }
    [HttpPost]
    public ActionResult CreateTimeWorkedRange(List<Models.TimeWorked> modelList)
    {
        foreach (Models.TimeWorked timeWorked in modelList)
        {
            Models.TimeWorked.CreateTimeWorked(timeWorked);
        }
    }

Answer 1

我不知道有更好的方法，但是一种方法是使用数组的索引来绑定您的项目，如下所示：

@for (int i = 0; i < Model.Count; ++i) {
    <tr>
        @Html.HiddenFor(modelItem => Model[i].EmployeeId)
        <td>
            @Html.TextBoxFor(modelItem => Model[i].WorkDate)
        </td>
        <td>
            @Html.TextBoxFor(modelItem => Model[i].HoursWorked)
        </td>
        <td>
            @Html.HiddenFor(modelItem => Model[i].BeenSubmitted)
        </td>
    </tr>
}

您需要用于模型的其他收集类型（IList<TimeWorked>应该没问题）才能使用索引器，但这不是我想象的问题。发布时，该集合应正确填充。