/// <summary>
/// 添加App推荐产品
/// </summary>
/// <param name="DTO"></param>
/// <returns></returns>
public int AddAppRecommendProduct(AppRecommendProductModle DTO)
{
int result = 0;
var IsExit = DapperUtil.Query <AppRecommendProductModle>("ComBeziWfs_SWfsAppRecommendProduct_SelectInfoByProductNo", new { ProductNo = DTO.ProductNo }).ToList();
if (IsExit.Count() == 0)
{
result = DapperUtil.Execute("ComBeziWfs_SWfsAppRecommendProduct_InsertInfo", new { ProductNo = DTO.ProductNo, SortId = "0", CreateTime = DateTime.Now, Creator = DTO.Creator });
}
return(result);
}
//把商品加入推荐池
public ActionResult AddProductToAppRecommondAjax()
{
string productNO = Request.Form["productNo"];
if (string.IsNullOrEmpty(productNO))
{
TempData["tip"] = "<script>alert('添加失败')</script>";
return(Redirect("/Shangpin/AppRecommendProductManger/Index?categoryNO=" + Request.QueryString["categoryNO"] + "&ProductNo=" + Request.QueryString["ProductNo"] + "&ProductName=" + Request.QueryString["ProductName"] + "&brandNO=" + Request.QueryString["brandNO"] + "&colorId=" + Request.QueryString["colorId"] + "&shelfType=" + Request.QueryString["shelfType"] + "&ShelfDate=" + Request.QueryString["ShelfDate"] + "&MinPrice=" + Request.QueryString["MinPrice"] + "&MaxPrice=" + Request.QueryString["MaxPrice"] + "&MinStock=" + Request.QueryString["MinStock"] + "&MaxStock=" + Request.QueryString["MaxStock"] + "&MinDiscountRate=" + Request.QueryString["MinDiscountRate"] + "&MaxDiscountRate=" + Request.QueryString["MaxDiscountRate"] + "&hot=" + Request.QueryString["hot"] + "&sevenHot=" + Request.QueryString["sevenHot"]));
}
SWfsSortHistoryService sshsDal = new SWfsSortHistoryService();
Passport passport = PresentationHelper.GetPassport();
AppRecommendService zhao = new AppRecommendService();
List <AppRecommendProductModle> saveProductList = zhao.GetAppRecommendProductList();
if ((saveProductList.Count + productNO.Split(',').Length) > 50)
{
int remoteIndex = 0;
remoteIndex = (saveProductList.Count + productNO.Split(',').Length) - 50;
for (int i = 0; i < saveProductList.Count; i++)
{
if (i < remoteIndex)
{
zhao.DelAppRecommendProductById(saveProductList[i].ProductNo);
}
}
}
int result = 0;
for (int i = 0; i < productNO.Split(',').Length; i++)
{
AppRecommendProductModle DTO = new AppRecommendProductModle()
{
ProductNo = productNO.Split(',')[i],
Creator = passport.UserName
};
result = zhao.AddAppRecommendProduct(DTO);
}
sshsDal = null;
TempData["tip"] = "<script>alert('添加成功')</script>";
return(Redirect("/Shangpin/AppRecommendProductManger/Index?categoryNO=" + Request.QueryString["categoryNO"] + "&ProductNo=" + Request.QueryString["ProductNo"] + "&ProductName=" + Request.QueryString["ProductName"] + "&brandNO=" + Request.QueryString["brandNO"] + "&colorId=" + Request.QueryString["colorId"] + "&shelfType=" + Request.QueryString["shelfType"] + "&ShelfDate=" + Request.QueryString["ShelfDate"] + "&MinPrice=" + Request.QueryString["MinPrice"] + "&MaxPrice=" + Request.QueryString["MaxPrice"] + "&MinStock=" + Request.QueryString["MinStock"] + "&MaxStock=" + Request.QueryString["MaxStock"] + "&MinDiscountRate=" + Request.QueryString["MinDiscountRate"] + "&MaxDiscountRate=" + Request.QueryString["MaxDiscountRate"] + "&hot=" + Request.QueryString["hot"] + "&sevenHot=" + Request.QueryString["sevenHot"]));
}
