private void BindRecommend(ProductDetailModel info) { if (info.RecommonItems.Count == 0) { var items = PROD_MASTERService.PROD_MASTERList.Where(t => t.CategoryCode == info.CategoryCode) .AsEnumerable() .Select(t => new ProductModel { ID = t.ID, ProductNo = t.ProductNo, ProductName = t.Item03 == "1" ? t.Item02 : t.ProductName, ProductType = t.ProductType, StockType = t.StockType, BigPic = Common.Util.GetProductImgUrl(t.BigPic, false), MiddlePic = Common.Util.GetProductImgUrl(t.SmallPic).Replace("Small", "Middl"), SmallPic = Common.Util.GetProductImgUrl(t.SmallPic), ProdCategoryCode = t.CategoryCode, BaseUOFM = t.BaseUOFM, ListPrice = Common.Util.TransformObjToDou(t.ListPrice), SellPrice = PROD_MASTERService.GetSellPrice(t.ProductNo, Common.Util.TransformObjToDou(t.ListPrice), (double)t.SpecialPrice), }).Take(4); info.RecommonItems = items.ToList(); } }
// GET: Product public ActionResult Index(int id = 1) { //分页控件语言定义 Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en-US"); string tab_type = Common.Util.GetCookie("snell_product_tab_type"); if (string.IsNullOrEmpty(tab_type)) { Common.Util.SetCookie("snell_product_tab_type", "list"); } var categorycode = Request.Params["categorycode"] ?? "P01"; if (!string.IsNullOrEmpty(categorycode)) { ViewBag.LeftMenusModel = base.InitNavMenu(categorycode); } var filterResult = PROD_MASTERService.PROD_MASTERList.Where(t => t.CategoryCode.Equals(categorycode) || t.ProdGroupID.Equals(categorycode) || t.ProdSubclassID.Equals(categorycode)) .AsEnumerable() .Select(t => new ProductModel { ID = t.ID, ProductNo = t.ProductNo, ProductName = t.Item03 == "1" ? t.Item02 : t.ProductName, ProductType = t.ProductType, StockType = t.StockType, BigPic = Common.Util.GetProductImgUrl(t.BigPic, false), MiddlePic = Common.Util.GetProductImgUrl(t.SmallPic).Replace("Small", "Middl"), SmallPic = Common.Util.GetProductImgUrl(t.SmallPic), ProdCategoryCode = t.CategoryCode, BaseUOFM = t.BaseUOFM, ListPrice = Common.Util.TransformObjToDou(t.ListPrice), SellPrice = PROD_MASTERService.GetSellPrice(t.ProductNo, Common.Util.TransformObjToDou(t.ListPrice), (double)t.SpecialPrice), }).OrderByDescending(t => t.ID).ToPagedList(id, 24); ViewBag.PagedListProductModel = filterResult; if (Request.IsAjaxRequest()) { return(PartialView("_ProductsList")); } return(View()); }
public ActionResult Hotspecials(string cate, int id = 1) { //分页控件语言定义 Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en-US"); string tab_type = Common.Util.GetCookie("snell_product_tab_type"); if (string.IsNullOrEmpty(tab_type)) { Common.Util.SetCookie("snell_product_tab_type", "list"); } var orderby = Request.Params["sortModle"] ?? " ProductName asc"; var category = Request.Params["category"] ?? ""; if (!string.IsNullOrEmpty(category)) { var cates = JsonConvert.DeserializeObject <List <string> >(category); category = string.Join(",", cates.ToArray()); } int pageSize = 40; int pageCount = 0; string strWhere = string.Empty; if (!string.IsNullOrEmpty(category)) { string cateWhere = string.Empty; string[] cateArr = category.Split(','); List <string> cateList = new List <string>(); foreach (string c in cateArr) { cateList.Add("'" + c + "'"); } cateWhere = string.Join(",", cateList.ToArray()); strWhere = string.Format(" and {1} in ({0})", cateWhere, "a.CategoryCode"); } //if (condition.Count > 0) strWhere = string.Join(" and ", condition.ToArray()); var dt = PROD_MASTERService.GetHotSpecials(cate, strWhere, string.Empty);// Ben 2012-12-25 if (dt != null && dt.Count() > 0) { pageCount = dt.Count(); var items = dt.AsEnumerable() .Select(t => new EOF_PAGE_MASTER { ProductID = t.ID, ProductNo = t.ProductNo, ProductName = t.ProductName, BigPic = Common.Util.GetProductImgUrl(t.BigPic, false), SmallPic = Common.Util.GetProductImgUrl(t.SmallPic), MiddlePic = Common.Util.GetProductImgUrl(t.SmallPic).Replace("Small", "Middl"), StockType = t.StockType, SellPrice = PROD_MASTERService.GetSellPrice(t.ProductNo, Common.Util.TransformObjToDou(t.ListPrice), (double)t.SpecialPrice), //在EasiorderForm不需要对价格进行处理,因为已经登陆了 CategoryName = string.IsNullOrEmpty(t.CategoryName) ? t.CategoryCode : t.CategoryName, CategoryCode = t.CategoryCode, BaseUOFM = t.BaseUOFM, ListPrice = t.ListPrice, pCount = pageCount, altPath = Common.Util.SiteRootURL + "detailchart.aspx?proNo=" + t.ProductNo }); if (!string.IsNullOrEmpty(orderby) && orderby.IndexOf("SellPrice") > -1) { if (orderby.IndexOf("asc") > -1) { items.OrderBy(i => i.SellPrice); } if (orderby.IndexOf("desc") > -1) { items.OrderByDescending(i => i.SellPrice); } } items = items.Skip((id - 1) * pageSize).Take(pageSize); ViewBag.PagedListModel = new PagedList <EOF_PAGE_MASTER>(items, id, pageSize, pageCount); EOF_PAGE_Other2_MASTER eof_master = new EOF_PAGE_Other2_MASTER(); ViewBag.EOF_Model = eof_master; eof_master.Categories = BindHotspecialsCategory(items).ToList(); } if (Request.IsAjaxRequest()) { System.Threading.Thread.Sleep(1000); return(PartialView("../Office/_CustomizedProdList")); } return(View()); }
public ActionResult Detail(string id, string ptype = "id") { if (string.IsNullOrEmpty(id)) { return(View("Error")); } var model = new ProductDetailModel(); var entity = new PROD_MASTER(); if (ptype == "id") { entity = PROD_MASTERService.PROD_MASTERList.FirstOrDefault(t => t.ID == id); } else { entity = PROD_MASTERService.PROD_MASTERList.FirstOrDefault(t => t.ProductNo == id); } if (null != entity) { var photos = PROD_PHOTOService.PROD_PHOTOList.Where(t => t.EntityID == entity.ID) .AsEnumerable() .Select(t => new PROD_PHOTOModel { ID = t.ID, PhotoTitle = t.PhotoTitle, FilePath = t.FilePath, IsDefault = t.IsDefault, PhotoType = t.PhotoType, EntityID = t.EntityID, SmallPic = Common.Util.GetProductImgUrl(t.SmallPic), BigPic = Common.Util.GetProductImgUrl(t.BigPic), MiddlePic = t.MiddlePic, CreateDate = t.CreateDate, ModiDate = t.ModiDate, Creator = t.Creator, Modifier = t.Modifier, DisplayOrder = t.DisplayOrder, Status = t.Status, Item01 = t.Item01, Item02 = t.Item02, Item03 = t.Item03, Item04 = t.Item04, Item05 = t.Item05, }).Take(4); var commonItems = PROD_MASTERCOMMONService.PROD_MASTERCOMMONList.Where(t => t.ProductNo == entity.ProductNo) .Select(t => new PROD_MASTERCOMMONModel { ID = t.ID, ProductNo = t.ProductNo, CommTitle = t.CommTitle, CommSummary = t.CommSummary, CommContent = t.CommContent, Creator = t.Creator, CreateDate = t.CreateDate, Modifier = t.Modifier, ModiDate = t.ModiDate, Status = t.Status, Item01 = t.Item01, Item02 = t.Item02, Item03 = t.Item03, Item04 = t.Item04, Item05 = t.Item05, }); var subItems = PROD_PROPERTIESService.PROD_PROPERTIESList.Where(t => t.ProductNo == entity.ProductNo) .Select(t => new PROD_PROPERTIESModel { ID = t.ID, ProductNo = t.ProductNo, PropertyID = t.PropertyID, PropertyValue = t.PropertyValue, PLevel = t.PLevel, ParentID = t.ParentID, RelationCode = t.RelationCode, RowID = t.RowID, RealProductNo = t.RealProductNo, DisplayOrder = t.DisplayOrder, Remark = t.Remark, Status = t.Status, }); var recommonItems = PROD_RELATEDITEMService.PROD_RELATEDITEM_MASTERList.Where(t => t.ProductNo == entity.ProductNo) .AsEnumerable() .Select(t => new ProductModel { ProductNo = t.ProductNo, ProductName = t.ProductName, BigPic = Common.Util.GetProductImgUrl(t.BigPic, false), SmallPic = Common.Util.GetProductImgUrl(t.SmallPic), ProdCategoryCode = t.CategoryCode, BaseUOFM = t.BaseUOFM, ListPrice = Common.Util.TransformObjToDou(t.ListPrice), SellPrice = PROD_MASTERService.GetSellPrice(t.ProductNo, Common.Util.TransformObjToDou(t.ListPrice), (double)t.SpecialPrice), }).Take(10); model = new ProductDetailModel { ID = entity.ID, ProductNo = entity.ProductNo, ProductName = entity.ProductName, Description = entity.Description, ProductType = entity.ProductType, StndCost = entity.StndCost, CurrCost = entity.CurrCost, ListPrice = entity.ListPrice, SpecialPrice = entity.SpecialPrice, ClearPrice = entity.ClearPrice, ProdCategoryID = entity.ProdCategoryID, CategoryCode = entity.CategoryCode, SchdlUOM = entity.SchdlUOM, PriceShed = entity.PriceShed, BaseUOFM = entity.BaseUOFM, AvailableQTY = entity.AvailableQTY, ProdGroupID = entity.ProdGroupID, ProdSubclassID = entity.ProdSubclassID, LeadTime = entity.LeadTime, QtySales = entity.QtySales, QtyMin = entity.QtyMin, QtyMax = entity.QtyMax, CustomerID = entity.CustomerID, StockType = entity.StockType, SalesRepID = entity.SalesRepID, PriceBookItem = entity.PriceBookItem, PriceLevel = entity.PriceLevel, BarCode = entity.BarCode, Ranking = entity.Ranking, Notes = entity.Notes, Substitute1 = entity.Substitute1, Substitute2 = entity.Substitute2, Qty1 = entity.Qty1, Qty3 = entity.Qty3, Qty6 = entity.Qty6, Qty12 = entity.Qty12, Sales1 = entity.Sales1, Sales3 = entity.Sales3, Sales6 = entity.Sales6, Sales12 = entity.Sales12, GPD1 = entity.GPD1, GPD3 = entity.GPD3, GPD6 = entity.GPD6, GPD12 = entity.GPD12, LastDate = entity.LastDate, CreateDate = entity.CreateDate, Creator = entity.Creator, Modifier = entity.Modifier, ModiDate = entity.ModiDate, Status = entity.Status, P01 = entity.P01, P02 = entity.P02, P03 = entity.P03, P04 = entity.P04, P05 = entity.P05, P06 = entity.P06, P07 = entity.P07, P08 = entity.P08, P09 = entity.P09, P10 = entity.P10, IsCommend = entity.IsCommend, IsHot = entity.IsHot, ExteriorPart = entity.ExteriorPart, ExteriorPartPrice = entity.ExteriorPartPrice, ViewTimes = entity.ViewTimes, BigPic = Common.Util.GetProductImgUrl(entity.BigPic, false), SmallPic = Common.Util.GetProductImgUrl(entity.SmallPic), LocationStocks1 = entity.LocationStocks1, LocationStocks2 = entity.LocationStocks2, LocationStocks3 = entity.LocationStocks3, LocationStocks4 = entity.LocationStocks4, LocationStocks5 = entity.LocationStocks5, LocationStocks6 = entity.LocationStocks6, LocationStocks7 = entity.LocationStocks7, LocationStocks8 = entity.LocationStocks8, LocationStocks9 = entity.LocationStocks9, LocationStocks10 = entity.LocationStocks10, LocationStocks11 = entity.LocationStocks11, LocationStocks12 = entity.LocationStocks12, LocationStocks13 = entity.LocationStocks13, LocationStocks14 = entity.LocationStocks14, LocationStocks15 = entity.LocationStocks15, LocationAllocate1 = entity.LocationAllocate1, LocationAllocate2 = entity.LocationAllocate2, LocationAllocate3 = entity.LocationAllocate3, LocationAllocate4 = entity.LocationAllocate4, LocationAllocate5 = entity.LocationAllocate5, LocationAllocate6 = entity.LocationAllocate6, LocationAllocate7 = entity.LocationAllocate7, LocationAllocate8 = entity.LocationAllocate8, LocationAllocate9 = entity.LocationAllocate9, LocationAllocate10 = entity.LocationAllocate10, LocationAllocate11 = entity.LocationAllocate11, LocationAllocate12 = entity.LocationAllocate12, LocationAllocate13 = entity.LocationAllocate13, LocationAllocate14 = entity.LocationAllocate14, LocationAllocate15 = entity.LocationAllocate15, Introduction = entity.Introduction, Brand = entity.Brand, Item01 = entity.Item01, Item02 = entity.Item02, Item03 = entity.Item03, Item04 = entity.Item04, Item05 = entity.Item05, PhotoList = photos.ToList(), CommonItems = commonItems.ToList(), SubItems = subItems.ToList(), RecommonItems = recommonItems.ToList(), PDF_file = BindPDF(entity.Introduction), }; } GetProductPrice(model); BindInformation(model); BindRecommend(model); BindDefalultPic(model); ViewBag.ProductDetailModel = model; var barChart = new BarChart(); if (CurrentUser != null) { Chart("Your most recently purchased quantities", model.ProductNo, barChart); } ViewBag.Chart = barChart; return(View()); }