ASP.NET MVC使用Boostrap实现产品展示、查询、排序、分页_实用技巧_

 public class Product { public int Id { get; set; } public string Name { get; set; } public string Description { get; set; } public string Category { get; set; } public string Brand { get; set; } public decimal Price { get; set; } public string ImageUrl { get; set; } public int Age { get; set; } }

 public class QueryBase { public int PageIndex { get; set; } public int PageSize { get; set; } public short PaiXu { get; set; } }

 public class ProductQuery : QueryBase { public string CategoryName { get; set; } public string BrandName { get; set; } public string Age { get; set; } public string LowPrice { get; set; } public string HighPrice { get; set; } }

 public enum AscDescEnum { asc = 0, desc = 1 }

 public class Database { public static IEnumerable GetProducts() { return new List() { new Product(){Id = 1, Name = "羽绒服新时尚",Category = "服饰",Brand = "南极人",Age = 1, ImageUrl = "~/images/1.jpg",Price = 85m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 2, Name = "最新鲜潮货",Category = "服饰",Brand = "初语",Age = 2, ImageUrl = "~/images/2.jpg",Price = 95m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 3, Name = "新鲜态度",Category = "服饰",Brand = "文艺",Age = 3, ImageUrl = "~/images/3.jpg",Price = 105m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 4, Name = "儿童保暖内衣",Category = "服饰",Brand = "南极人",Age = 4, ImageUrl = "~/images/4.jpg",Price = 115m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 5, Name = "韩版蝴蝶结",Category = "服饰",Brand = "南极人",Age = 5, ImageUrl = "~/images/5.jpg",Price = 125m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 6, Name = "时尚童装加绒",Category = "服饰",Brand = "南极人",Age = 6, ImageUrl = "~/images/6.jpg",Price = 135m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 7, Name = "棉质儿童短袜",Category = "服饰",Brand = "南极人",Age = 7, ImageUrl = "~/images/7.jpg",Price = 145m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 8, Name = "灯芯绒打底单裤",Category = "服饰",Brand = "南极人",Age = 8, ImageUrl = "~/images/8.jpg",Price = 155m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 9, Name = "公主范裤子",Category = "服饰",Brand = "南极人",Age = 9, ImageUrl = "~/images/9.jpg",Price = 165m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 10, Name = "儿童百搭潮流",Category = "服饰",Brand = "南极人",Age = 10, ImageUrl = "~/images/10.jpg",Price = 175m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 11, Name = "童装牛仔裤",Category = "服饰",Brand = "南极人",Age = 11, ImageUrl = "~/images/11.jpg",Price = 185m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 12, Name = "吸汗条纹袜",Category = "服饰",Brand = "南极人",Age = 12, ImageUrl = "~/images/12.jpg",Price = 195m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 13, Name = "秋衣秋裤",Category = "服饰",Brand = "南极人",Age = 13, ImageUrl = "~/images/13.jpg",Price = 205m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 14, Name = "全棉棉毛套",Category = "服饰",Brand = "南极人",Age = 14, ImageUrl = "~/images/14.jpg",Price = 215m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 15, Name = "卡内衣套装",Category = "服饰",Brand = "南极人",Age = 15, ImageUrl = "~/images/15.jpg",Price = 215m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 16, Name = "保暖内衣套装",Category = "服饰",Brand = "南极人",Age = 16, ImageUrl = "~/images/16.jpg",Price = 225m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 17, Name = "精纱全棉内衣",Category = "服饰",Brand = "南极人",Age = 17, ImageUrl = "~/images/17.jpg",Price = 235m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 18, Name = "真我香水EDP",Category = "香水",Brand = "迪奥",Age = 18, ImageUrl = "~/images/18.jpg",Price = 245m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 19, Name = "晶钻粉钻香恋",Category = "香水",Brand = "范思哲",Age = 19, ImageUrl = "~/images/19.jpg",Price = 255m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"}, new Product(){Id = 20, Name = "绿邂逅清新",Category = "香水",Brand = "香奈儿",Age = 20, ImageUrl = "~/images/20.jpg",Price = 235m,Description = "产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述产品描述"} }; } public static IEnumerable GetPageProducts(ProductQuery query, out int total) { var allProducts = GetProducts(); if (!string.IsNullOrEmpty(query.BrandName)) { allProducts = allProducts.Where(p => p.Brand == query.BrandName); } if (!string.IsNullOrEmpty(query.CategoryName)) { allProducts = allProducts.Where(p => p.Category == query.CategoryName); } if (!string.IsNullOrEmpty(query.Age)) { int intAge = int.Parse(query.Age); allProducts = allProducts.Where(p => p.Age == intAge); } if (!string.IsNullOrEmpty(query.LowPrice) && !string.IsNullOrEmpty(query.HighPrice)) { decimal lowerPrice = decimal.Parse(query.LowPrice); decimal higherPrice = decimal.Parse(query.HighPrice); allProducts = allProducts.Where(p => p.Price >= lowerPrice && p.Price <= higherPrice); } if (!string.IsNullOrEmpty(query.LowPrice) && string.IsNullOrEmpty(query.HighPrice)) { decimal lowerPrice = decimal.Parse(query.LowPrice); allProducts = allProducts.Where(p => p.Price <= lowerPrice); } if (string.IsNullOrEmpty(query.LowPrice) && !string.IsNullOrEmpty(query.HighPrice)) { decimal higherPrice = decimal.Parse(query.HighPrice); allProducts = allProducts.Where(p => p.Price >= higherPrice); } total = allProducts.Count(); if (query.PaiXu == (short) AscDescEnum.asc) { allProducts = allProducts .OrderBy(p => p.Price) .Skip(query.PageSize*(query.PageIndex - 1)) .Take(query.PageSize); } else { allProducts = allProducts .OrderByDescending(p => p.Price) .Skip(query.PageSize * (query.PageIndex - 1)) .Take(query.PageSize); } return allProducts; } }

 public class HomeController : Controller { public ActionResult Index() { return View(); } //品牌 public ActionResult GetBrandsJson() { var allProducts = Database.GetProducts(); var result = from p in allProducts group p by p.Brand into g select new {brand = g.Key}; return Json(result, JsonRequestBehavior.AllowGet); } //类别 public ActionResult GetCategoriesJson() { var allProducts = Database.GetProducts(); var result = from p in allProducts group p by p.Category into g select new {category = g.Key}; return Json(result, JsonRequestBehavior.AllowGet); } //年限 public ActionResult GetAgesJson() { var allProducts = Database.GetProducts(); var result = from p in allProducts group p by p.Age into g select new { age = g.Key }; return Json(result, JsonRequestBehavior.AllowGet); } //加载产品第一页 private string _categoryName = string.Empty; private string _brandName = string.Empty; private string _age = string.Empty; private string _lowerPrice = string.Empty; private string _higherPrice = string.Empty; public ActionResult GetFirstPage() { var temp = new ProductQuery() { PageIndex = 1, PageSize = 6, Age = _age, BrandName = _brandName, CategoryName = _categoryName, HighPrice = _higherPrice, LowPrice = _lowerPrice, PaiXu = (short)AscDescEnum.asc }; int totalNum = 0; var allProducts = Database.GetPageProducts(temp, out totalNum); var result = from p in allProducts select new {p.Name, p.Brand, p.Category, p.Age, p.Description, p.Price}; var tempTotal = Convert.ToInt32(Math.Ceiling((double)(totalNum / 6))) +1; var jsonResult = new { total = tempTotal, rows = result }; return Json(jsonResult, JsonRequestBehavior.AllowGet); } //根据搜索排序分页条件加载 [HttpPost] public ActionResult GetProductsBySearchSortPage(ProductQuery productQuery) { int totalNum = 0; var allProducts = Database.GetPageProducts(productQuery, out totalNum); var result = from p in allProducts select new { p.Name, p.Brand, p.Category, p.Age, p.Description, p.Price }; var tempTotal = Convert.ToInt32(Math.Ceiling((double)(totalNum / 6))) + 1; var jsonResult = new { total = tempTotal, rows = result }; return Json(jsonResult); } }

 @Styles.Render("~/Content/css") 提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                

                

                

                                            
上一篇：.NET使用StackTrace获取方法调用信息的代码演示_实用技巧_
                                                                
下一篇：.Net中的Http请求调用详解(Post与Get)_实用技巧_