public static List <RecommendProductModel> GetTireEnforceRecommendByPids(List <string> pids) { var returnResult = new List <RecommendProductModel>(); if (pids == null || !pids.Any() || pids.Count == 0) { return(returnResult); } try { using (var client = new ProductConfigClient()) { var result = client.GetTireEnforceRecommendByPids(pids.Distinct().ToList()); result.ThrowIfException(true); if (result.Success && result.Result != null && result.Result.Any() && result.Result.Count > 0) { var recommendPids = result.Result.Where(p => !string.IsNullOrWhiteSpace(p.RecommendPID)) .Select(p => p.RecommendPID) .Distinct() .ToList(); var displayNames = DALRecommendTire.GetDisplayName(recommendPids); var displayNameDic = displayNames?.GroupBy(p => p.PID)?.ToDictionary(p => p.Key?.ToUpper(), p => p.FirstOrDefault()?.DisplayName ?? ""); result.Result.ForEach(item => { var model = new RecommendProductModel { PID = item.PId, Image = item.Image, Postion = item.Position, Reason = item.Reason, RecommendPID = item.RecommendPID, }; var ProductName = ""; if ((bool)displayNameDic?.ContainsKey(model.RecommendPID?.ToUpper())) { displayNameDic.TryGetValue(model.RecommendPID?.ToUpper(), out ProductName); } model.ProductName = ProductName; returnResult.Add(model); }); } } return(returnResult); } catch (Exception ex) { //TODO:log return(returnResult); } }
public static int InsertQZTJ(SqlDbHelper dbHelper, RecommendProductModel model, string PID) { return(dbHelper.ExecuteNonQuery(@"INSERT INTO Tuhu_productcatalog.dbo.tbl_TireEnforceRecommend ( PID, RecommendPID, Position, Reason, Image ) VALUES ( @PID, @RecommendPID, @Postion, @Reason, @Image )" , CommandType.Text, new SqlParameter[] { new SqlParameter("@PID", PID), new SqlParameter("@RecommendPID", model.PID), new SqlParameter("@Postion", model.Postion), new SqlParameter("@Reason", model.Reason), new SqlParameter("@Image", model.Image) })); }
public APIResponse Home(int userId, int merchantId) { HomeModel model = new HomeModel(); //获取bannder var banner = CurrentDb.SysBanner.Where(m => m.Type == Enumeration.BannerType.MainHomeTop).ToList(); List <BannerImageModel> bannerImageModel = new List <BannerImageModel>(); foreach (var m in banner) { BannerImageModel imageModel = new BannerImageModel(); imageModel.Id = m.Id; imageModel.Title = m.Title; imageModel.LinkUrl = SysFactory.Banner.GetLinkUrl(m.Id); imageModel.ImgUrl = m.ImgUrl; bannerImageModel.Add(imageModel); } model.Banner = bannerImageModel; //获取车务服务 var carServiceApps = CurrentDb.ExtendedApp.Where(m => m.Type == Enumeration.ExtendedAppType.CarService && m.IsDisplay == true).Take(4).ToList(); List <ExtendedAppModel> carServiceAppsModel = new List <ExtendedAppModel>(); foreach (var m in carServiceApps) { ExtendedAppModel extendedAppModel = new ExtendedAppModel(); extendedAppModel.Id = m.Id; extendedAppModel.Name = m.Name; extendedAppModel.ImgUrl = m.ImgUrl; extendedAppModel.LinkUrl = m.LinkUrl; extendedAppModel.AppKey = m.AppKey; extendedAppModel.AppSecret = m.AppSecret; carServiceAppsModel.Add(extendedAppModel); } model.CarService = carServiceAppsModel; //获取推荐服务 var recommendApps = CurrentDb.ExtendedApp.Where(m => m.Type != Enumeration.ExtendedAppType.CarService && m.IsDisplay == true).Take(4).ToList(); List <ExtendedAppModel> recommendAppsModel = new List <ExtendedAppModel>(); foreach (var m in recommendApps) { ExtendedAppModel extendedAppModel = new ExtendedAppModel(); extendedAppModel.Id = m.Id; extendedAppModel.Name = m.Name; extendedAppModel.ImgUrl = m.ImgUrl; extendedAppModel.LinkUrl = m.LinkUrl; extendedAppModel.AppKey = m.AppKey; extendedAppModel.AppSecret = m.AppSecret; recommendAppsModel.Add(extendedAppModel); } model.RecommendService = recommendAppsModel; //获取推荐商品 var recommendProduct = (from m in CurrentDb.Product where ((int)m.Type).ToString().StartsWith("101") select new { m.Id, m.Name, m.Price, m.Type, m.CreateTime, m.MainImgUrl }).OrderByDescending(r => r.CreateTime).Skip(0).Take(6).ToList(); List <RecommendProductModel> recommendProductModel = new List <RecommendProductModel>(); foreach (var m in recommendProduct) { RecommendProductModel product = new RecommendProductModel(); product.Id = m.Id; product.Name = m.Name; product.Price = m.Price; product.Type = m.Type.GetCnName(); product.ImgUrl = m.MainImgUrl; product.LinkUrl = BizFactory.Product.GetLinkUrl(m.Type, m.Id); recommendProductModel.Add(product); } model.RecommendProduct = recommendProductModel; APIResult result = new APIResult() { Result = ResultType.Success, Code = ResultCode.Success, Message = "获取成功", Data = model }; return(new APIResponse(result)); }