增删改查
using Mvclogin.Models; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Data.Entity; namespace Mvclogin.Controllers { public class HomeController : Controller { // // GET: /Home/ ExampleEntities dben = new ExampleEntities(); public ActionResult Index() { List<StuInfo> list = dben.StuInfo.Take(10).ToList(); return View(list); } public ActionResult Delete() { string id =Request.Form["Id"].ToString(); StuInfo stu = dben.StuInfo.Where(e => e.stuid == id).FirstOrDefault(); dben.StuInfo.Remove(stu); int i = dben.SaveChanges(); if(i>0) { return Content("1"); } else { return Content("0"); } } public ActionResult modifypage(string id) { StuInfo stu = dben.StuInfo.FirstOrDefault(e => e.stuid == id); return View(stu); } public ActionResult Modify() { string id =Request.Form["stuid"]; StuInfo stuinfo = dben.StuInfo.FirstOrDefault(e => e.stuid == id); stuinfo.stuname = Request.Form["stuname"].Trim().ToString(); stuinfo.age = Convert.ToInt32(Request.Form["age"].Trim()); stuinfo.address = Request.Form["address"].Trim().ToString(); dben.Entry<StuInfo>(stuinfo).State=System.Data.EntityState.Modified; dben.SaveChanges(); return RedirectToAction("Index", "Home"); } /// <summary> /// 增加 /// </summary> /// <returns></returns> public ActionResult Add() { StuInfo stuinfo = new StuInfo(); stuinfo.stuname = Request.Form["stuname"].Trim().ToString(); stuinfo.age = Convert.ToInt32(Request.Form["age"]. Trim()); stuinfo.address = Request.Form["address"].Trim().ToString(); dben.StuInfo.Add(stuinfo); dben.SaveChanges(); if(dben.SaveChanges()>0) { return Content("1"); } else { return Content("0"); } } } }