MyTextEntities mye = new MyTextEntities();
//添加新数据
public ActionResult Create(T_User user)
{
try
{
// TODO: Add insert logic here
#region vs2010
mye.T_User.AddObject(user);
mye.SaveChanges();
return RedirectToAction("Index");
#endregion
#region vs2012
mye.T_User.Add(user);
mye.SaveChanges();
return RedirectToAction("Index");
#endregion
}
catch
{
return View();
}
}
//修改数据
public ActionResult Edit(int id)
{
var user = (from c in mye.T_User
where c.id == id
select c).FirstOrDefault<T_User>();
if (user == null)
{
return HttpNotFound();
}
return View(user);
}
[HttpPost]
public ActionResult Edit(T_User user)
{
try
{
#region vs2010
// mye.AttachTo("T_User",user);
//mye.ObjectStateManager.ChangeObjectState(user, System.Data.EntityState.Modified);
//mye.SaveChanges();
//return RedirectToAction("Index");
#endregion
// TODO: Add update logic here
#region vs2012
DbEntityEntry entry= mye.Entry(user);
entry.State = System.Data.EntityState.Modified;
mye.SaveChanges();
return RedirectToAction("Index");
#endregion
}
catch
{
return View();
}
}
//删除数据
public ActionResult Delete(int id)
{
var user = (from c in mye.T_User
where c.id == id
select c).FirstOrDefault<T_User>();
return View(user);
}
//
// POST: /User/Delete/5
[HttpPost]
public ActionResult Delete(int id, FormCollection collection)
{
try
{
// TODO: Add delete logic here
#region vs2010
//T_User user = new T_User() { UserId = id };
//mye.AttachTo("T_User", user);
//mye.ObjectStateManager.ChangeObjectState(user, System.Data.EntityState.Deleted);
//mye.SaveChanges();
//return RedirectToAction("Index");
#endregion
#region vs2012
T_User user = new T_User() { id=id};
DbEntityEntry entity = mye.Entry(user);
entity.State = System.Data.EntityState.Deleted;
mye.SaveChanges();
return RedirectToAction("Index");
#endregion
}
catch
{
return View();
}
}