MVC POST 編輯示例
假設我們有一個具有多種顏色的 Product 類,可以在許多產品上使用。
public class Product
{
public int ProductId { get; set; }
public ICollection<ColorProduct> ColorProducts { get; set; }
}
public class ColorProduct
{
public int ProductId { get; set; }
public int ColorId { get; set; }
public virtual Color Color { get; set; }
public virtual Product Product { get; set; }
}
public class Color
{
public int ColorId { get; set; }
public ICollection<ColorProduct> ColorProducts { get; set; }
}
使用此擴充套件程式可以更輕鬆:
public static class Extensions
{
public static void TryUpdateManyToMany<T, TKey>(this DbContext db, IEnumerable<T> currentItems, IEnumerable<T> newItems, Func<T, TKey> getKey) where T : class
{
db.Set<T>().RemoveRange(currentItems.Except(newItems, getKey));
db.Set<T>().AddRange(newItems.Except(currentItems, getKey));
}
public static IEnumerable<T> Except<T, TKey>(this IEnumerable<T> items, IEnumerable<T> other, Func<T, TKey> getKeyFunc)
{
return items
.GroupJoin(other, getKeyFunc, getKeyFunc, (item, tempItems) => new { item, tempItems })
.SelectMany(t => t.tempItems.DefaultIfEmpty(), (t, temp) => new { t, temp })
.Where(t => ReferenceEquals(null, t.temp) || t.temp.Equals(default(T)))
.Select(t => t.t.item);
}
}
更新產品的顏色看起來像這樣(MVC 編輯 POST 方法)
[HttpPost]
public IActionResult Edit(ProductVm vm)
{
if (ModelState.IsValid)
{
var model = db.Products
.Include(x => x.ColorProducts)
.FirstOrDefault(x => x.ProductId == vm.Product.ProductId);
db.TryUpdateManyToMany(model.ColorProducts, vm.ColorsSelected
.Select(x => new ColorProduct
{
ColorId = x,
ProductId = vm.Product.ProductId
}), x => x.ColorId);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(vm);
}
public class ProductVm
{
public Product Product { get; set; }
public IEnumerable<int> ColorsSelected { get; set; }
}
程式碼已儘可能簡化,任何類都沒有額外的屬性。