//添加历史记录
public int AddSearchHistory(SWfsProductSearchHistory obj)
{
Passport passport = PresentationHelper.GetPassport();
if (passport != null && !string.IsNullOrEmpty(passport.UserName))
{
obj.CreateDate = DateTime.Now;
obj.SearchUser = passport.UserName;
obj.LogType = 1;
return(DapperUtil.Insert <SWfsProductSearchHistory>(obj, true));
}
return(0);
}
public ActionResult ProductManager(int pageIndex = 1, int pageSize = 20)
{
Passport passport = PresentationHelper.GetPassport();
System.Text.StringBuilder sb = new System.Text.StringBuilder(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " " + passport.UserName + " ");
int total = 0;
if (Request.QueryString["editePeople"] != null)
{
sb.Append("编辑人:" + Request.QueryString["editePeople"] + " ");
}
if (Request.QueryString["publishPeople"] != null)
{
sb.Append("发布人:" + Request.QueryString["editePeople"] + " ");
}
if (Request.QueryString["keyWord"] != null)
{
sb.Append("关键字:" + Request.QueryString["keyWord"] + " ");
}
if (Request.QueryString["productNo"] != null)
{
sb.Append("商品编号:" + Request.QueryString["productNo"] + " ");
}
if (Request.QueryString["CategoryNo"] != null)
{
sb.Append("商品分类:" + Request.QueryString["CategoryName"] + " ");
}
if (Request.QueryString["brandNO"] != null)
{
sb.Append("品牌:" + Request.QueryString["BrandName"] + " ");
}
if (Request.QueryString["isnewShelf"] == "0")
{
sb.Append("新上架: ");
}
if (Request.QueryString["timeType"] == "1")
{
sb.Append(">编辑时间 :" + Request.QueryString["startTime"] + "到" + Request.QueryString["endTime"] + " ");
}
if (Request.QueryString["timeType"] == "2")
{
sb.Append(">发布时间 :" + Request.QueryString["startTime"] + "到" + Request.QueryString["endTime"] + " ");
}
if (Request.QueryString["timeType"] == "3")
{
sb.Append(">上架时间 :" + Request.QueryString["startTime"] + "到" + Request.QueryString["endTime"] + " ");
}
if (Request.QueryString["priceStart"] != null || Request.QueryString["priceEnd"] != null)
{
sb.Append("商品价格:" + (Request.QueryString["priceStart"] == null ? "0" : Request.QueryString["priceStart"]) + "到" + (Request.QueryString["priceEnd"] == null ? "最大" : Request.QueryString["priceEnd"]) + " ");
}
if (Request.QueryString["rateStart"] != null || Request.QueryString["rateEnd"] != null)
{
sb.Append("商品折扣:" + (Request.QueryString["rateStart"] == null ? "0" : Request.QueryString["rateStart"]) + "到" + (Request.QueryString["rateEnd"] == null ? "最大" : Request.QueryString["rateEnd"]) + " ");
}
if (Request.QueryString["IsRecord"] == "1" && string.IsNullOrEmpty(Request.QueryString["addProductListText"]))
{
SWfsProductSearchHistory obj = new SWfsProductSearchHistory()
{
SearchName = sb.ToString(),
SearchUser = passport.UserName,
SearchUrl = Request.Url.ToString().Replace("http://" + Request.Url.Host, "").Replace("IsRecord", "IsRecordAdd"),
LogType = 1
};
productService.AddSearchHistory(obj);
return(Redirect(obj.SearchUrl));
}
//加载历史查询数据
ViewBag.HistoryList = productService.GetSearchHistory(10);
IEnumerable <SkillProductExtends> list = productService.GetSWfsProductList(Request.QueryString["editePeople"], Request.QueryString["publishPeople"], Request.QueryString["keyWord"],
Request.QueryString["productNo"], Request.QueryString["CategoryNo"], Request.QueryString["brandNO"], Request.QueryString["isnewShelf"], Request.QueryString["timeType"],
Request.QueryString["startTime"], Request.QueryString["endTime"], Request.QueryString["priceStart"], Request.QueryString["priceEnd"], Request.QueryString["rateStart"],
Request.QueryString["rateEnd"], Request.QueryString["addProductListText"], Request.QueryString["IsEdite"], Request.QueryString["IsPublish"], pageIndex, pageSize, Request.QueryString["isout"], out total);
ViewBag.totalCount = total;
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
list = list.GroupBy(p => p.ProductNo).Select(p => new SkillProductExtends
{
ProductNo = p.ElementAt(0).ProductNo,
LimitedPrice = p.ElementAt(0).LimitedPrice,
GoodsNo = p.ElementAt(0).GoodsNo,
ProductModel = p.ElementAt(0).ProductModel,
ProductName = p.ElementAt(0).ProductName,
ProductPicFile = p.ElementAt(0).ProductPicFile,
ProductShowPic = p.ElementAt(0).ProductShowPic,
BrandCnName = p.ElementAt(0).BrandCnName,
BrandEnName = p.ElementAt(0).BrandEnName,
Id = p.ElementAt(0).Id,
IsPublish = p.ElementAt(0).IsPublish,
EditeDate = p.ElementAt(0).EditeDate,
PublishTime = p.ElementAt(0).PublishTime,
PublishPeople = p.ElementAt(0).PublishPeople,
EditePeople = p.ElementAt(0).EditePeople,
IsEdite = p.ElementAt(0).IsEdite,
DiscountShangpin = p.ElementAt(0).DiscountShangpin,
MarketPriceRegion = p.Min(a => a.MarketPrice) + "~" + p.Max(a => a.MarketPrice),
StandardPriceRegion = p.Min(a => a.StandardPrice) + "~" + p.Max(a => a.StandardPrice),
PlatinumPriceRegion = p.Min(a => a.PlatinumPrice) + "~" + p.Max(a => a.PlatinumPrice),
DiamondPriceRegion = p.Min(a => a.DiamondPrice) + "~" + p.Max(a => a.DiamondPrice),
PromotionPriceRegion = p.Min(a => a.PromotionPrice) + "~" + p.Max(a => a.PromotionPrice),
GoldPriceRegion = p.Min(a => a.GoldPrice) + "~" + p.Max(a => a.GoldPrice),
DiscountShangpinRegion = p.Min(a => a.DiscountRate) + "~" + p.Max(a => a.DiscountRate),
IsOutSide = p.ElementAt(0).IsOutSide
});
return(View(list));
}
