首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >编辑表单中的Asp.net核心EF 3 3DropDown,保存将删除导航属性表中的字段

问编辑表单中的Asp.net核心EF 3 3DropDown,保存将删除导航属性表中的字段
EN

Stack Overflow用户
提问于 2017-10-19 17:42:32
回答 2查看 260关注 0票数 1

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

​

​

在一对多的关系中,代码首先由ef生成。

数据库看起来是这样的:

​

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

编辑表格是:

​

和当我保存DropDowns时,只返回id!多奥!

但是我的绑定期望实体

​

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

​

以下是编辑的Controller代码:

代码语言:javascript
复制
[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);
    }

该职位:

代码语言:javascript
复制
   [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);
    }

在编辑表单中,下拉列表如下所示:

代码语言:javascript
复制
  <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>

从编辑表单到饲料下拉列表的说明是这样的:

代码语言:javascript
复制
<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表中,它也会通过导航属性在其他实体中更新。

代码语言:javascript
复制
 _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;}

代码语言:javascript
复制
     public VehicleBrand VehicleBrand { get; set; }

ForeignKey("VehicleModelid")

公共int VehicleModelid { get;set;}

代码语言:javascript
复制
     public VehicleModel VehicleModel { get; set; }

ForeignKey("VehicleVersionid")

公共int VehicleVersionid { get;set;}

代码语言:javascript
复制
     public VehicleVersion VehicleVersion { get; set; }

编辑如下:

代码语言:javascript
复制
   [HttpPost]
代码语言:javascript
复制
   [ValidateAntiForgeryToken]
代码语言:javascript
复制
   public async Task YourEditNewCar(int id,[Bind("id,DoorsNr,isAvailable,isDamaged,isDeleted,FabricationDate,FuelTankCapacity,TrunckCapacity,OnBoardKm,SeatNr," +                                                                         "LicencePlate, **VehicleBrandid, VehicleModelid, VehicleVersionid**")] Vehicle vehicle) 

谢谢你的耐心!)

工作起来很有魅力!:)

EN

回答 2

Stack Overflow用户

发布于 2017-10-25 21:58:29

你应该用

代码语言:javascript
复制
@Html.DropDownListFor(model => model.VehicleBrandid, (SelectList)ViewBag.BrandList, "Car Brand", new { style = "width: 140px;", @class = "form-control" })

不

代码语言:javascript
复制
@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

票数 1
EN

Stack Overflow用户

发布于 2017-10-26 11:08:42

代码的问题是,mvc模型状态验证处理与尊重的模型使用在您张贴的视图。所以在这个模型中,你的模型是车辆,所以对于车辆,我们需要给出模型的值。vehicleBrand、VehicleModel、VehicleVersion是不同的模型,该领域的值在投递时不依赖于车辆模型。因此,考虑到您需要这样使用

代码语言:javascript
复制
<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属性进行管理和检查。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/46835863

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档