mvc4 数据库增删改查与分页.docx

《mvc4 数据库增删改查与分页.docx》由会员分享，可在线阅读，更多相关《mvc4 数据库增删改查与分页.docx（7页珍藏版）》请在三一办公上搜索。

1、mvc4 数据库增删改查与分页using System;using System.Collections.Generic;using System.Data;using System.Data.Entity;using System.Linq;using System.Web;using System.Web.Mvc;using MvcApplication2;namespace MvcApplication2.Controllerspublic class Default1Controller : Controllerprivate user_infoEntities db = new us

2、er_infoEntities;/列表/ GET: /Default1/public ActionResult Indexreturn View(db.user_table.ToList);/详情/ GET: /Default1/Details/5public ActionResult Details(int id = 0)user_table user_table = db.user_table.Single(u => u.user_id = id);if (user_table = null)return HttpNotFound;return View(user_table);/增加

3、/ GET: /Default1/Createpublic ActionResult Createreturn View;/ POST: /Default1/CreateHttpPostpublic ActionResult Create(user_table user_table)if (ModelState.IsValid)db.user_table.AddObject(user_table);db.SaveChanges;return RedirectToAction(Index);return View(user_table);/编辑/ GET: /Default1/Edit/5pub

4、lic ActionResult Edit(int id = 0)user_table user_table = db.user_table.Single(u => u.user_id = id);if (user_table = null)return HttpNotFound;return View(user_table);/ POST: /Default1/Edit/5HttpPostpublic ActionResult Edit(user_table user_table)if (ModelState.IsValid)db.user_table.Attach(user_table

5、);db.ObjectStateManager.ChangeObjectState(user_table, EntityState.Modified);db.SaveChanges;return RedirectToAction(Index);return View(user_table);/删除/ GET: /Default1/Delete/5public ActionResult Delete(int id = 0)user_table user_table = db.user_table.Single(u => u.user_id = id);if (user_table = nul

6、l)return HttpNotFound;return View(user_table);/ POST: /Default1/Delete/5HttpPost, ActionName(Delete)public ActionResult DeleteConfirmed(int id)user_table user_table = db.user_table.Single(u => u.user_id = id);db.user_table.DeleteObject(user_table);db.SaveChanges;return RedirectToAction(Index);prot

7、ected override void Dispose(bool disposing)db.Dispose;base.Dispose(disposing);/查询/public ActionResult searchuser(string u_name)var usertosearch = from m in db.user_table select m;if (!String.IsNullOrEmpty(u_name)usertosearch = db.user_table.Where(s => s.user_name.Contains(u_name);return View(usert

8、osearch);/分页/public ActionResult pagearrage(int? id)int pagecount = db.user_table.Count;int pagesize = 20;int pagenumber = pagecount / pagesize;int pageindex = id ? 1;ViewBag.pagecount = pagecount;ViewBag.pagesize = pagesize;ViewBag.pagenumber = pagenumber;var pageview = db.user_table.OrderBy(m => m.user_id).Skip(pagesize *( pageindex-1).Take(pagesize).ToList;return View(pageview);