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