MVC-Ajax-jquery分页

浏览数：24 / 时间：2015年06月09日

《1》

控制器

<pre class="csharp" name="code">using System;
using System.Collections.Generic;
using System.Data.Entity.Infrastructure;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Script.Serialization;

namespace MvcTest.Controllers
{
    public class TestController : Controller
    {
        salesEntities db = new salesEntities();
        public ActionResult Index()
        {
            //展示数据
            var query3 = (from a in db.T_User
                          select a).OrderBy(r => r.Id).Take(20);
            
            return View(query3); 
        }
		//Ajax请求的数据 （做分页的）
        public JsonResult Paging(int pageIndex) //用户传递一个当前页码过来
        {
            var query = ((from a in db.T_User           //根据当前页来查询数据
                          where a.Id > pageIndex * 5
                          select a).Take(5)).ToList();

            JsonResult json = new JsonResult();
	    json.JsonRequestBehavior = JsonRequestBehavior.AllowGet;  //允许来自客户端的HTTP GET请求
            json.Data = new   
            {
                result = query
            };
            return json;  //返回一个Json数据
		}
		
		
		//--------------------------------------------------------------
		
		//--------------------------------------增
		
		 [HttpGet]                     
        public ActionResult Add()
        {
            return View();
        }
        [HttpPost]
        public ActionResult Add(T_User u)
        {
            db.Entry(u).State = System.Data.EntityState.Added;
            db.SaveChanges();
            return RedirectToAction("Index");
        }
		
		//--------------------------------------删
		
		[HttpGet]                      
        public ActionResult Del(int Id)
        {
            T_User u = db.T_User.SingleOrDefault(r => r.Id == Id);

            return View(u);
        }
        [HttpPost]
        public ActionResult Del(T_User u)
        {
            T_User uu = db.T_User.SingleOrDefault(r => r.Id == u.Id);
            db.Entry(uu).State = System.Data.EntityState.Deleted;
            db.SaveChanges();
            return RedirectToAction("Index");
        }
       
		//--------------------------------------改
		
        public ActionResult Edit(int Id)
        {
            T_User u = db.T_User.SingleOrDefault(r => r.Id == Id);
            return View();
        }
        [HttpPost]
        public ActionResult Edit(T_User u)
        {
            
            db.Entry(u).State = System.Data.EntityState.Modified;
            db.SaveChanges();
            return RedirectToAction("Index");

        }
	}	
}

Index视图

@model IEnumerable<MvcTest.T_User>
@{
    Layout = null;
}
<!DOCTYPE html>
<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
    <script src="~/Scripts/jquery-1.8.2.js"></script>
</head>
<body>
    @*<div>@RenderPage("~/Views/Test/GGGGG.cshtml")</div>*@
    <table id="t1">
        @*@foreach (var i in Model)
        {
            <tr><td>@i.Id</td><td>@i.UserName</td><td>@i.Password</td><td>@i.Errors</td><td>@i.Session</td><td><a href="/Test/Del/@i.Id">删</a> @Html.ActionLink("添", "Add")
                @Html.ActionLink("改", "Edit", new { id=@i.Id})</td></tr>
        }*@
    </table> 
</body>
</html>
<script type="text/javascript">
    $(function () {
        $.get("/Test/Paging", { "pageIndex": 1 }, function (data) {
           
            var jsonData = data.result;
            
            $.each(jsonData, function (key, val) {
              
                var strTb = "<tr><td>" + val.Id + "</td><td>" + val.UserName + "</td><td>" + val.Password + "</td><td>" + val.Errors + "</td><td>" + val.Session + "</td></td><td><a href='/Test/Add'>添</a><td><a href=/Test/Del/" + val.Id + ">删</a></td><td><a href=/Test/Edit/" + val.Id + ">改</a></td></tr>";
                $("#t1").append(strTb);
            })
            
        })
    })
</script>