public ViewResult QueryString(int pageIndex = 1) { using (var db = new DataContext()) { return View(db.Orders.OrderBy(o=>o.OrderId).ToPagedList(pageIndex, 5)); } }
public ActionResult AjaxPartialLoading(int id = 1) { using (var db = new DataContext()) { return View(db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, 8)); } }
public ViewResult Basic(int id = 1) { using (var db = new DataContext()) { return View(db.Orders.OrderBy(o=>o.OrderId).ToPagedList(id, 5)); } }
public ActionResult ApplyCSS(int id = 1) { using (var db = new DataContext()) { return View(new PagedList<string>(new string[0], id, 1, 80)); } }
public ActionResult CustomRouting(int pageindex = 1) { using (var db = new DataContext()) { return View(db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(pageindex, 5)); } }
public ActionResult CustomRouting(int pageindex = 1) { using (var db = new DataContext()) { return View(db.Orders.OrderBy(o=>o.OrderId).ToPagedList(pageindex, 5)); } }
public ViewResult Basic(int id = 1) { using (var db = new DataContext()) { return View(db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, 5)); } }
//public ViewResult HtmlSorting(string field, string order, int pageIndex = 1) //{ // using (var db = new DataContext()) // { // string sql = string.Format("Select * from articles order by {0} {1}",field,order); // return View(db.Database.SqlQuery<Article>(sql).ToPagedList(pageIndex,5)); // } //} public ViewResult QueryString(int pageIndex = 1) { using (var db = new DataContext()) { return View(db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(pageIndex, 5)); } }
public ActionResult PageIndexBox(int id = 1) { using (var db = new DataContext()) { return View(db.Orders.OrderBy(o=>o.OrderId).ToPagedList(id, 5)); } }
public ActionResult PageIndexBox(int id = 1) { using (var db = new DataContext()) { return View(db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, 5)); } }
public ActionResult AjaxPaging(int id = 1) { using (var db = new DataContext()) { var model = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, 8); if (Request.IsAjaxRequest()) return PartialView("_ArticleList", model); return View(model); } }
public ActionResult AjaxLoading(int id = 1) { using (var db = new DataContext()) { var model = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, 8); if (Request.IsAjaxRequest()) { System.Threading.Thread.Sleep(2000); return PartialView("_AjaxLoading", model); } return View(model); } }
public ActionResult AjaxEvents(int id = 1) { using (var db = new DataContext()) { if (id == 2) { Response.StatusCode = 500; return Content("测试用的服务器端错误信息"); } //throw new ApplicationException("测试用的服务器端错误信息"); var model = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, 8); if (Request.IsAjaxRequest()) return PartialView("_AjaxEvents", model); return View(model); } }
public ActionResult JavascriptApiHtml(int id = 1, int pageIndex = 1) { using (var db = new DataContext()) { return View(db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, 5)); } }
private ActionResult ajaxSearchPostResult(string title,string author,string source, int id = 1) { using (var db = new DataContext()) { var qry = db.Articles.AsQueryable(); if (!string.IsNullOrWhiteSpace(title)) qry = qry.Where(a => a.Title.Contains(title)); if (!string.IsNullOrWhiteSpace(author)) qry = qry.Where(a => a.Author.Contains(author)); if (!string.IsNullOrWhiteSpace(source)) qry = qry.Where(a => a.Source.Contains(source)); var model = qry.OrderByDescending(a => a.PubDate).ToPagedList(id, 5); if (Request.IsAjaxRequest()) return PartialView("_AjaxSearchPost", model); return View(model); } }
public ActionResult AjaxDegradation(int id = 1) { using (var db = new DataContext()) { var model = db.Orders.OrderBy(o=>o.OrderId).ToPagedList(id, 5); if (Request.IsAjaxRequest()) return PartialView("_Degradation", model); return View(model); } }
public ActionResult MultipleAjaxPagers(int id = 1,int pageIndex=1) { using (var db = new DataContext()) { var pageSize = 5; var model = new CompositeArticles(); model.ArticleList1 = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(pageIndex, pageSize); model.ArticleList2 = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, pageSize); return View(model); } }
public ActionResult AjaxPagers(int id = 1, int pageIndex = 1, int page = 1) { using (var db = new DataContext()) { const int pageSize = 5; if (Request.IsAjaxRequest()) { var target = Request.QueryString["target"]; if (target == "articles") { return PartialView("_AjaxArticles1", db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, pageSize)); } if (target == "articles2") { return PartialView("_AjaxArticles2", db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(pageIndex, pageSize)); } return PartialView("_AjaxArticles3", db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(page, pageSize)); } var model = new CompositeArticles { ArticleList1 = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, pageSize), ArticleList2 = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(pageIndex, pageSize), ArticleList3 = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(page, pageSize) }; return View(model); } }
public ActionResult JavascriptApiHtml(int id = 1, int pageIndex = 1) { using (var db = new DataContext()) { return View(db.Orders.OrderBy(o=>o.OrderId).ToPagedList(id, 5)); } }
public ActionResult LoadByAjax(int id = 1) { using (var db = new DataContext()) { var model = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, 5); if (Request.IsAjaxRequest()) { return PartialView("_LoadByAjax", model); } return View(); } }
public ActionResult PageSize(int pagesize = 10, int pageindex = 1) { using (var db = new DataContext()) { return View(db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(pageindex, pagesize)); } }
public ActionResult ContentPaging(int id=1) { using (var db = new DataContext()) { var art = db.Articles.SingleOrDefault(a => a.ID == 25); //获取演示用的长文章 if (art != null) { return View(new PagedArticle(art, id)); } return new HttpNotFoundResult("找不到指定的文章"); } }
public ActionResult JavascriptApiAjax(int id = 1) { using (var db = new DataContext()) { var model = db.Orders.OrderBy(o=>o.OrderId).ToPagedList(id, 5); if (Request.IsAjaxRequest()) return PartialView("_OrderList", model); return View(model); } }
public ActionResult CustomizeAjaxPager(int id = 1) { using (var db = new DataContext()) { var model = db.Orders.OrderBy(o=>o.OrderId).ToPagedList(id, 5); if (Request.IsAjaxRequest()) return PartialView("_AjaxPagerHidden", model); return View(model); } }
public ActionResult CustomizeHtmlPager(int id = 1) { using (var db = new DataContext()) { return View(db.Orders.OrderBy(o=>o.OrderId).ToPagedList(id, 5)); } }
public ActionResult MultipleMvcPagers(int id = 1,int pageIndex=1) { using (var db = new DataContext()) { var pageSize = 5; List<Tuple<int,string,string>> usrs=new List<Tuple<int, string, string>>(); var startIndex = (pageIndex - 1) * pageSize + 1; for (int i = startIndex; i < pageSize + startIndex; i++) { usrs.Add(new Tuple<int, string, string>(i, "会员" + i, "住址" + i)); } CustomViewModel model=new CustomViewModel(); model.Users = new PagedList<Tuple<int, string, string>>(usrs, pageIndex, pageSize, 89); model.Articles = db.Articles.OrderByDescending(a => a.PubDate).ToPagedList(id, pageSize); return View(model); } }
public ActionResult MultipleAjaxPagers(int id = 1,int pageIndex=1) { using (var db = new DataContext()) { var pageSize = 5; var model = new Tuple<PagedList<Order>, PagedList<Order>>( db.Orders.OrderBy(o => o.OrderId).ToPagedList(pageIndex, pageSize), db.Orders.OrderBy(o => o.OrderId).ToPagedList(id, pageSize)); return View(model); } }
public ActionResult Search(int id = 1, string kword = null) { using (var db = new DataContext()) { var query = db.Articles.AsQueryable(); if (!string.IsNullOrWhiteSpace(kword)) query = query.Where(a => a.Title.Contains(kword)); var model = query.OrderByDescending(a => a.PubDate).ToPagedList(id, 5); return View(model); } }
public ActionResult StoredProcedure(int id = 1) { using (var db = new DataContext()) { var pageSize = 5; var startIndex = (id - 1)*pageSize + 1; SqlParameter prmStart = new SqlParameter("@startIndex", startIndex); SqlParameter prmEnd = new SqlParameter("@endIndex", startIndex + pageSize); SqlParameter prmTotal = new SqlParameter("@totalItems", SqlDbType.Int); prmTotal.Direction = ParameterDirection.Output; var articles = db.Database.SqlQuery<Article>( "exec [USP_GetPagedArticleList] @startIndex,@endIndex,@totalItems out", prmStart, prmEnd, prmTotal).ToList(); var totalItems = (int) prmTotal.Value; var model = new PagedList<Article>(articles, id, pageSize, totalItems); return View(model); } }
private ActionResult ajaxSearchPostResult(string emp, int id = 1) { using (var db = new DataContext()) { var qry = db.Orders.AsQueryable(); if (!string.IsNullOrWhiteSpace(emp)) qry = qry.Where(a => a.EmployeeName.Contains(emp)); var model = qry.OrderBy(o=>o.OrderId).ToPagedList(id, 5); if (Request.IsAjaxRequest()) return PartialView("_AjaxSearchPost", model); return View(model); } }