当前位置: 代码迷 >> ASP.NET >> MVC分页,该如何解决
  详细解决方案

MVC分页,该如何解决

热度:8810   发布时间:2013-02-25 00:00:00.0
MVC分页
Models代码
C# code
public static IEnumerable<Article> ListArticle()        {            List<Article> articles = new List<Article>();            using (SqlConnection connection = new SqlConnection(connectionString))            {                string commandText = "select * from He_Article where Deleted = 0";                using (SqlCommand command = new SqlCommand(commandText, connection))                {                    connection.Open();                    SqlDataReader reader = command.ExecuteReader();                    while (reader.Read())                    {                        Article article = new Article();                        article.ID = (int)reader["ID"];                        article.ClassID = (int)reader["ClassID"];                        article.Title = (string)reader["Title"];                        article.Author = (string)reader["Author"];                        article.CopyFrom = (string)reader["CopyFrom"];                        article.Keyword = (string)reader["Keyword"];                        article.Hits = (int)reader["Hits"];                        article.UpdateTime = (DateTime)reader["UpdateTime"];                        article.OnTop = (int)reader["OnTop"];                        article.Elite = (int)reader["Elite"];                        article.Status = (int)reader["Status"];                        article.Content = (string)reader["Content"];                        article.DefaultPicUrl = (string)reader["DefaultPicUrl"];                        article.Deleted = (int)reader["Deleted"];                        articles.Add(article);                    }                    reader.Close();                    connection.Close();                }            }            return articles;        }


Controllers代码
C# code
public ActionResult Admin_Article_Manage()        {            ViewData["ManageList"] = ArticleDataContext.ListArticle();            return View();        }


View代码
C# code
<%foreach (Article article in this.ViewData["ManageList"] as IEnumerable<Article>){%>            <tr>                <td><%:Html.CheckBox("ID")%></td>                <td><%=article.ID%></td>                <td align="left">[<%=article.ClassID%>]<%=article.Title%></td>                <td><%=article.Author%></td>                <td><%=article.Hits%></td>                <td><%=article.ID%></td>                <td><%=article.Status%></td>                <td>修改 删除 固定 设为推荐</td>            </tr><%}%>


请问如何实现分页

------解决方案--------------------------------------------------------
其实分页和什么架构是没有关系的,你以前的webform怎么实现的,其实原理是一样的我要有数据源,有每页显示多少,获取这些参数,都是一样的原理,也可以用jq+ajax

给你个简单的
Contrller
C# code
        public ActionResult Index(int? id = 1)        {            var count = db.Article.Count();            var article = db.Article.OrderByDescending(m => m.ID)                                        .Skip(20 * Convert.ToInt32(id - 1))                                        .Take(20);            ViewBag.Current = id;            ViewBag.Count = (count % 20 == 0) ?                (count / 20) : count / 20 + 1;            return View(article);        }
  相关解决方案