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); }