我有4个实体: Vehicle,VehicleBrand,VehicleModel,VehicleVersion

在一对多的关系中,代码首先由ef生成。
数据库看起来是这样的:

编辑表单使用jQuery,第一个下拉列表是由一个ViewBag提供的,另一个是Json提供的。
编辑表格是:

和当我保存DropDowns时,只返回id!多奥!
但是我的绑定期望实体

如您所见,vbName返回null,在SaveChanges之后。在所有实体中都有name字段null。

以下是编辑的Controller代码:
[HttpGet]
public async Task<IActionResult> YourEditNewCar(int? id)
{
if (id == null)
{
return NotFound();
}
var brands = await _context.VehicleBrands.OrderBy(b => b.vbName).Select(x => new { Id = x.id, Value = x.vbName }).ToListAsync();
var models = await _context.VehicleModels.OrderBy(m => m.vmName).ToListAsync();
var versions= await _context.VehicleVersions.OrderBy(v =>v.vvName).ToListAsync();
var model = new Vehicle();
ViewBag.BrandList = new SelectList(brands, "Id", "Value");
model = await _context.Vehicles.SingleOrDefaultAsync(m => m.id == id);
if (model == null)
{
return NotFound();
}
return View("~/Views/Manage/YourEditNewCar.cshtml", model);
}
public JsonResult getVehicleModelById(int id)
{
List<VehicleModel> vehicleModelList = new List<VehicleModel>();
vehicleModelList = _context.VehicleModels.Where(m => m.VehicleBrand.id == id).OrderBy(m => m.vmName).ToList(); //.Select(y => new { Id = y.id, Value = y.vmName })
vehicleModelList.Insert(0, new VehicleModel { id = 0, vmName = "Car Model" });
return Json(vehicleModelList);
}
public JsonResult getVehicleVersionById(int id)
{
List<VehicleVersion> vehicleVersionList = new List<VehicleVersion>();
vehicleVersionList = _context.VehicleVersions.Where(m => m.VehicleModel.id == id).OrderBy(m => m.vvName).ToList(); //.Select(y => new { Id = y.id, Value = y.vmName })
vehicleVersionList.Insert(0, new VehicleVersion { id = 0, vvName = "Car Version" });
return Json(vehicleVersionList);
}该职位:
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> YourEditNewCar(int id, [Bind("id,DoorsNr,isAvailable,isDamaged,isDeleted,FabricationDate,FuelTankCapacity,TrunckCapacity,OnBoardKm,SeatNr," +
"LicencePlate, VehicleBrand, VehicleModel, VehicleVersion")] Vehicle vehicle)
{
var user = await _userManager.GetUserAsync(User);
if (ModelState.IsValid)
{
try
{
_context.Update(vehicle);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VehicleExists(vehicle.id))
{
return NotFound();
}
else
{
throw;
}
}
return RedirectToAction("YourCar", "Manage");
}
return View(vehicle);
}在编辑表单中,下拉列表如下所示:
<hr>
<div class="col-md-12 text-center"><h4> Please select :</h4></div>
<div class="row row-list">
<div class="form-group col-xs-4">
<label asp-for="VehicleBrand" class="control-label hidden" value=""></label>
@Html.DropDownListFor(model => model.VehicleBrand.id, (SelectList)ViewBag.BrandList, "Car Brand", new { style = "width: 140px;", @class = "form-control" })
</div>
<div class="form-group col-xs-4">
<label asp-for="VehicleModel" class="control-label hidden" value=""></label>
@Html.DropDownListFor(model => model.VehicleModel.id, new SelectList(string.Empty), "Car Model", new { style = "width: 120px;", @class = "form-control" })
</div>
<div class="form-group col-xs-4">
<label asp-for="VehicleVersion" class="control-label hidden" value=""></label>
@Html.DropDownListFor(model => model.VehicleVersion.id, new SelectList(string.Empty), "Car Version", new { style = "width: 110px;", @class = "form-control" })
</div>
</div>从编辑表单到饲料下拉列表的说明是这样的:
<script>
$(function () {
$("#VehicleBrand_id").change(function () {
//alert("Vehicle Brand dd changed !");
var url = '@Url.Content("~/Manage/getVehicleModelById")';
var ddlsource = "#VehicleBrand_id";
$.getJSON(url, { id: $(ddlsource).val() }, function (data) {
var items = '';
$("#VehicleModel_id").empty();
$.each(data, function (i, row) {
items += "<option value='" + row.id + "'>" + row.vmName + "</option>";
});
$("#VehicleModel_id").html(items);
})
});
});
</script>所有的下拉操作都是完美的,返回的只是id。
和SaveChanges时,即使我只想保存在Vehicle表中,它也会通过导航属性在其他实体中更新。
_context.Update(vehicle);
await _context.SaveChangesAsync();我尝试过不更新VehicleBrands,但没有效果:

这需要一个新的对象:

我觉得我错过了一些简单的东西,或者是一个错误的方法。
问题出在模特身上!我只使用:public VehicleBrand VehicleBrand { get;set;},而没有声明字段为ForeignKey
我加入了模型:
ForeignKey("VehicleVersionid")
公共int VehicleVersionid { get;set;}
现在,我在Model中添加了(使用Bold):
ForeignKey("VehicleBrandid")
公共int VehicleBrandid { get;set;}
public VehicleBrand VehicleBrand { get; set; }ForeignKey("VehicleModelid")
公共int VehicleModelid { get;set;}
public VehicleModel VehicleModel { get; set; }ForeignKey("VehicleVersionid")
公共int VehicleVersionid { get;set;}
public VehicleVersion VehicleVersion { get; set; }编辑如下:
[HttpPost] [ValidateAntiForgeryToken] public async Task YourEditNewCar(int id,[Bind("id,DoorsNr,isAvailable,isDamaged,isDeleted,FabricationDate,FuelTankCapacity,TrunckCapacity,OnBoardKm,SeatNr," + "LicencePlate, **VehicleBrandid, VehicleModelid, VehicleVersionid**")] Vehicle vehicle) 谢谢你的耐心!)
工作起来很有魅力!:)
发布于 2017-10-25 21:58:29
你应该用
@Html.DropDownListFor(model => model.VehicleBrandid, (SelectList)ViewBag.BrandList, "Car Brand", new { style = "width: 140px;", @class = "form-control" })不
@Html.DropDownListFor(model => model.VehicleBrand.id, (SelectList)ViewBag.BrandList, "Car Brand", new { style = "width: 140px;", @class = "form-control" })将下拉列表绑定到车辆实体中的id字段,而不是绑定到相关实体中的id字段。
或者,如果您想开始在asp.net核心中使用标签助手,可以使用以下引用:https://learn.microsoft.com/en-us/aspnet/core/mvc/views/working-with-forms#the-select-tag-helper
发布于 2017-10-26 11:08:42
代码的问题是,mvc模型状态验证处理与尊重的模型使用在您张贴的视图。所以在这个模型中,你的模型是车辆,所以对于车辆,我们需要给出模型的值。vehicleBrand、VehicleModel、VehicleVersion是不同的模型,该领域的值在投递时不依赖于车辆模型。因此,考虑到您需要这样使用
<div class="row row-list">
<div class="form-group col-xs-4">
<label asp-for="VehicleBrand" class="control-label hidden" value=""></label>
@Html.DropDownListFor(model => model.VehicleBrandid, (SelectList)ViewBag.BrandList, "Car Brand", new { style = "width: 140px;", @class = "form-control" })
</div>
<div class="form-group col-xs-4">
<label asp-for="VehicleModel" class="control-label hidden" value=""></label>
@Html.DropDownListFor(model => model.VehicleModelid, new SelectList(string.Empty), "Car Model", new { style = "width: 120px;", @class = "form-control" })
</div>
<div class="form-group col-xs-4">
<label asp-for="VehicleVersion" class="control-label hidden" value=""></label>
@Html.DropDownListFor(model => model.VehicleVersionid, new SelectList(string.Empty), "Car Version", new { style = "width: 110px;", @class = "form-control" })
</div>
</div>一旦使用了一个模型,我们就会将整个属性作为实体进行更改,因此很难对entitystate.unchanged属性进行管理和检查。
https://stackoverflow.com/questions/46835863
复制相似问题