asp.net mvc2,linq to entity的创建，编辑，删除

来源：互联网发布：仿生活家家居网站源码编辑：程序博客网时间：2024/05/26 17:47

说明：以下使用的OjbectContext为: StudentApartmentStoreEntities StudentApartmentDB = new StudentApartmentStoreEntities();

1.创建新一项

[HttpPost]

public ActionResult Create(FormCollection collection)

｛

try

{

string NewApartName = collection["ApartName"].Trim();

var checkapp = StudentApartmentDB.Apartment_Info.SingleOrDefault(item => item.ApartName == NewApartName);

if (checkapp == null)

{

checkapp = new Apartment_Info

{

ApartmentId = Guid.NewGuid(),

ApartName = NewApartName

};

StudentApartmentDB.AddToApartment_Info(checkapp);

StudentApartmentDB.SaveChanges();

return RedirectToAction("Index");

}

else

{

return SendMessage("公寓名称已经存在", "公寓名称已经存在，请换一个名称。", true);

}

catch

{

return View();

}

try

{

// TODO: Add update logic here

string NewApartName = collection["ApartName"].Trim();

var checkapp = StudentApartmentDB.Apartment_Info.SingleOrDefault(item => item.ApartName == NewApartName);

if (checkapp == null)

{

checkapp = new Apartment_Info

{

ApartmentId = Guid.NewGuid(),

ApartName = NewApartName

};

StudentApartmentDB.AddToApartment_Info(checkapp);

StudentApartmentDB.SaveChanges();

return RedirectToAction("Index");

}

else

{

return SendMessage("公寓名称已经存在", "公寓名称已经存在，请换一个名称。", true);

}

catch

{

return View();

}

｝

2.编辑项：

public ActionResult Edit(Guid id)

{

return View();

}

[HttpPost]

public ActionResult Edit(Guid id, FormCollection collection)

{

string NewApartName = collection["ApartName"].Trim();

Apartment_Info updateApartent = new Apartment_Info

{

ApartmentId = id,

ApartName = NewApartName

};

System.Data.EntityKey key = default(System.Data.EntityKey);

object originalItem = null;

using (StudentApartmentDB)

{

key = StudentApartmentDB.CreateEntityKey("Apartment_Info", updateApartent);

if (StudentApartmentDB.TryGetObjectByKey(key, out originalItem))

{

StudentApartmentDB.ApplyCurrentValues(key.EntitySetName, updateApartent);

}

try

{

StudentApartmentDB.SaveChanges();

return RedirectToAction("Index");

}

catch

{

return SendMessage("修改公寓失败", "修改公寓失败",true);

}

2.删除项：

public ActionResult Delete(Guid id)

{

var album = StudentApartmentDB.Apartment_Info.Single(a => a.ApartmentId == id);

return View(album);

}

[HttpPost]

public ActionResult Delete(Guid id, FormCollection collection)

{

try

{

var cartItem = StudentApartmentDB.Apartment_Info.Single(

apart => apart.ApartmentId == id);

if (cartItem != null)

{

StudentApartmentDB.Apartment_Info.DeleteObject(cartItem);

StudentApartmentDB.SaveChanges();

}

return View("Deleted", cartItem);

}

catch

{

return SendMessage("删除失败", "删除失败!", true);

}