Entity Framework和MVC 实现增删改查的控制器代码
一.更新一条数据的关键代码
- ExcrciseEntities db = new ExcrciseEntities();
- db.Entry(user).State = EntityState.Modified;
- //user是修改之后的条目对象
- db.SaveChanges();
二.全部控制器代码
- using MvcApp3.Models;
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Linq;
- using System.Web;
- using System.Web.Mvc;
- namespace MvcApp3.Controllers
- {
- public class Default1Controller : Controller
- {
- //
- // GET: /Default1/
- public ActionResult Index()
- {
- ExcrciseEntities db = new ExcrciseEntities();
- return View(db.UserInfo);
- }
- public ActionResult Details(int id)
- {
- ExcrciseEntities db = new ExcrciseEntities();
- var item = db.UserInfo.Where<UserInfo>(u => u.ID == id).FirstOrDefault();
- ViewData.Model = item;
- return View();
- }
- //
- // GET: /Default1/Create
- // 创建新条目,出现添加记录的表单
- public ActionResult Create()
- {
- return View();
- }
- //
- // POST: /Default1/Create
- //接收用户填写的表单记录
- [HttpPost]//标识该方法只能接受post请求
- public ActionResult Create(UserInfo userInfo)
- {
- try
- {
- // TODO: Add insert logic here
- ExcrciseEntities db = new ExcrciseEntities();
- db.UserInfo.Add(userInfo);
- db.SaveChanges();
- return RedirectToAction("Index");
- }
- catch
- {
- return View();
- }
- }
- //
- // GET: /Default1/Edit/5
- //展示一下要修改的条目
- public ActionResult Edit(int id)
- {
- ExcrciseEntities db = new ExcrciseEntities();
- var item = db.UserInfo.Where<UserInfo>(u => u.ID == id).FirstOrDefault();
- db.UserInfo.Remove(item);
- return View(item);
- }
- //
- // POST: /Default1/Edit/5
- [HttpPost]
- public ActionResult Edit(int id, UserInfo user)
- {
- try
- {
- // TODO: Add update logic here
- ExcrciseEntities db = new ExcrciseEntities();
- db.Entry(user).State = EntityState.Modified;
- db.SaveChanges();
- return RedirectToAction("Index");
- }
- catch
- {
- return View();
- }
- }
- //
- // GET: /Default1/Delete/5
- //把要删除的数据展示一下
- public ActionResult Delete(int id)
- {
- ExcrciseEntities db = new ExcrciseEntities();
- var item = db.UserInfo.Where<UserInfo>(u => u.ID == id).FirstOrDefault<UserInfo>();
- return View(item);
- }
- //
- // POST: /Default1/Delete/5
- [HttpPost]
- public ActionResult Delete(int id, FormCollection collection)
- {
- try
- {
- // TODO: Add delete logic here
- ExcrciseEntities db = new ExcrciseEntities();
- var item = db.UserInfo.Where<UserInfo>(u => u.ID == id).FirstOrDefault<UserInfo>();
- db.UserInfo.Remove(item);
- db.SaveChanges();
- return RedirectToAction("Index");
- }
- catch
- {
- return View();
- }
- }
- }
- }
posted on 2017-06-08 15:44 alex5211314 阅读(390) 评论(0) 编辑 收藏 举报