/// <summary>
/// 专题页的商品管理
/// </summary>
/// <returns></returns>
public ActionResult ManageProduct(string topicNo, int pageindex = 1)
{
int pageSize = 10;
string categoryNo = Request["CategoryNo"];
string brandNo = Request["BrandNo"];
string productNoOrName = Request["ProductNameOrNo"];
if (!string.IsNullOrEmpty(productNoOrName) && productNoOrName.Equals("商品编号/商品名称"))
{
productNoOrName = "";
}
/////////////////////////分页保留查询数据用///////////////////////////////
ViewBag.CategoryNo = categoryNo ?? "";
ViewBag.ProductNameOrNo = productNoOrName ?? "";
ViewBag.BrandName = Request.QueryString["BrandName"] ?? "";
ViewBag.BrandNo = brandNo ?? "";
///////////////////////////分页保留查询数据用/////////////////////////////
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("brandNo", brandNo ?? "");
dic.Add("productNoOrName", productNoOrName ?? "");
dic.Add("gCategroyNo", categoryNo ?? "");
dic.Add("topicId", topicNo ?? "");
SWfsTopicService topicServ = new SWfsTopicService();
var productList = topicServ.GetProductListByTopicNo(dic, pageindex, pageSize);
SWfsProductService productService = new SWfsProductService();
ProductInventory pin = new ProductInventory();
foreach (var product in productList.Items)
{
pin = productService.GetInventoryByProductNo(product.ProductNo);
product.Quantity = pin.SumQuantity;
product.LockQuantity = pin.SumLockQuantity;
}
//所有的一级分类
SWfsSubjectService subject = new SWfsSubjectService();
ViewBag.AllFirstCategory = subject.SelectErpCategoryByParentNo("ROOT");
ViewBag.TopicNo = topicNo;
SWfsTopics topicModel = topicServ.GetSWfsTopics(topicNo);
ViewBag.TopicName = (null != topicModel) ? topicModel.TopicName : "";
return(View(productList));
}
public ActionResult UpdateGoods(int pageIndex = 1, int pageSize = 20)
{
string id = Request.QueryString["GoodsId"].ToString();
int total = 0;
IEnumerable <ProductInfo> list = productService.GetUpdateGoods(int.Parse(id));
SWfsProductService service = new SWfsProductService();
foreach (var item in list)
{
//商品下的Skulist
var skuList = productService.GetSkuListByProductNo(item.ProductNo);
if (skuList.Any())
{
//价格，上下架状态
item.MarketPriceRegion = skuList.Select(n => n.MarketPrice).Min().ToString() + "~" + skuList.Select(n => n.MarketPrice).Max().ToString();
item.StandardPriceRegion = skuList.Select(n => n.StandardPrice).Min().ToString() + "~" + skuList.Select(n => n.StandardPrice).Max().ToString();
item.GoldPriceRegion = skuList.Select(n => n.GoldPrice).Min().ToString() + "~" + skuList.Select(n => n.GoldPrice).Max().ToString();
item.PlatinumPriceRegion = skuList.Select(n => n.PlatinumPrice).Min().ToString() + "~" + skuList.Select(n => n.PlatinumPrice).Max().ToString();
item.DiamondPriceRegion = skuList.Select(n => n.DiamondPrice).Min().ToString() + "~" + skuList.Select(n => n.DiamondPrice).Max().ToString();
item.OutletPriceRegion = skuList.Select(n => n.OutletPrice).Min().ToString() + "~" + skuList.Select(n => n.OutletPrice).Max().ToString();
item.PromotionPriceRegion = skuList.Select(n => n.PromotionPrice).Min().ToString() + "~" + skuList.Select(n => n.PromotionPrice).Max().ToString();
item.IsShelf = skuList.Select(n => n.IsShelf = 2).FirstOrDefault();
item.PcShowState = skuList.Select(n => n.PcShowState = 1).FirstOrDefault();
item.DisabledState = skuList.Select(n => n.DisabledState = 0).FirstOrDefault();
}
//库存
ProductInventory inventory = service.GetInventoryByProductNo(item.ProductNo);
item.Quantity = inventory.SumQuantity;
item.LockQuantity = inventory.SumLockQuantity;
}
ViewBag.totalCount = total;
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
var list1 = list.OrderByDescending(e => e.sortvalue);
return(View(list1));
}
/// <summary>
/// 商品列表--查询添加
/// </summary>
/// <param name="topicNo"></param>
/// <param name="categoryNo"></param>
/// <param name="brandNo"></param>
/// <param name="productNameOrNo"></param>
/// <param name="pageindex"></param>
/// <returns></returns>
public ActionResult AddProduct(string topicNo, int pageindex = 1)
{
int pageSize = 10;
string categoryNo1 = Request["CategoryNo1"];
string categoryNo2 = Request["CategoryNo2"];
string categoryNo3 = Request["CategoryNo3"];
string categoryNo4 = Request["CategoryNo4"];
string brandNo = Request["BrandNo"];
string productNoOrName = Request["ProductNameOrNo"];
string gender = Request["Gender"];
if (!string.IsNullOrEmpty(productNoOrName) && productNoOrName.Equals("商品编号/商品名称"))
{
productNoOrName = "";
}
/////////////////////////分页保留查询数据用///////////////////////////////
ViewBag.CategoryNo = categoryNo1 ?? "";
ViewBag.CategoryNo2 = categoryNo2 ?? "";
ViewBag.CategoryNo3 = categoryNo3 ?? "";
ViewBag.CategoryNo4 = categoryNo4 ?? "";
ViewBag.ProductNameOrNo = productNoOrName ?? "";
ViewBag.BrandName = Request.QueryString["BrandName"] ?? "";
ViewBag.Gender = gender ?? "";
///////////////////////////分页保留查询数据用/////////////////////////////
string gCategroyNo = categoryNo1;
if (!string.IsNullOrEmpty(categoryNo2))
{
gCategroyNo = categoryNo2;
}
if (!string.IsNullOrEmpty(categoryNo3))
{
gCategroyNo = categoryNo3;
}
if (!string.IsNullOrEmpty(categoryNo4))
{
gCategroyNo = categoryNo4;
}
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("brandNo", brandNo ?? "");
dic.Add("productNoOrName", productNoOrName ?? "");
dic.Add("gender", gender ?? "");
dic.Add("gCategroyNo", gCategroyNo ?? "");
SWfsTopicService topicServ = new SWfsTopicService();
var productList = topicServ.GetProductList(dic, pageindex, pageSize);
SWfsProductService productService = new SWfsProductService();
//ProductInventory pin = new ProductInventory();
ProductInventoryNew pin = new ProductInventoryNew();
SWfsNewProductService service = new SWfsNewProductService();
decimal bid = 0;
foreach (var product in productList.Items)
{
//pin = productService.GetInventoryByProductNo(product.ProductNo);
pin = service.GetInventoryByProductNo(product.ProductNo);
product.Quantity = pin.SumQuantity;
product.LockQuantity = pin.SumLockQuantity;
bid = productService.GetProductBuyPriceByProductNo(product.ProductNo);
product.sellBid = product.SellPrice - bid;
product.marketBid = product.MarketPrice - bid;
product.platinumBid = product.PlatinumPrice - bid;
product.diamondBid = product.DiamondPrice - bid;
product.limitedBid = product.LimitedPrice - bid;
product.limitedVipBid = product.LimitedVipPrice - bid;
product.selBidRate = product.SellPrice.Equals(0) ? 100 : Math.Round((product.sellBid / product.SellPrice) * 100, 2);
product.marketBidRate = product.MarketPrice.Equals(0) ? 100 : Math.Round((product.marketBid / product.MarketPrice) * 100, 2); // Convert.ToDecimal(Math.Round((Convert.ToDecimal(marketBid) / Convert.ToDecimal(marketPrice)) * 100, 2)).ToString() + "%";
product.platinumBidRate = product.PlatinumPrice.Equals(0) ? 100 : Math.Round((product.platinumBid / product.PlatinumPrice) * 100, 2); // Convert.ToDecimal(Math.Round((Convert.ToDecimal(platinumBid) / Convert.ToDecimal(platinumPrice)) * 100, 2)).ToString() + "%";
product.diamondBidRate = product.DiamondPrice.Equals(0) ? 100 : Math.Round((product.diamondBid / product.DiamondPrice) * 100, 2); //Convert.ToDecimal(Math.Round((Convert.ToDecimal(diamondBid) / Convert.ToDecimal(diamondPrice)) * 100, 2)).ToString() + "%";
product.limitedBidRate = product.LimitedPrice.Equals(0) ? 100 : Math.Round((product.limitedBid / product.LimitedPrice) * 100, 2); // Convert.ToDecimal(Math.Round((Convert.ToDecimal(limitedBid) / Convert.ToDecimal(limitedPrice)) * 100, 2)).ToString() + "%";
product.limitedVipBidRate = product.LimitedVipPrice.Equals(0) ? 100 : Math.Round((product.limitedVipBid / product.LimitedVipPrice) * 100, 2); // Convert.ToDecimal(Math.Round((Convert.ToDecimal(limitedVipBid) / Convert.ToDecimal(limitedVipPrice)) * 100, 2)).ToString() + "%";
}
//所有的一级分类
SWfsSubjectService subject = new SWfsSubjectService();
ViewBag.AllFirstCategory = subject.SelectErpCategoryByParentNo("ROOT");
//该活动下的一级分类
//ViewBag.FirstCategory = subject.GetErpCategoryListBySubjectNo(subjectNo);
ViewBag.Category2 = subject.SelectErpCategoryByParentNo(categoryNo1);
ViewBag.Category3 = subject.SelectErpCategoryByParentNo(categoryNo2);
ViewBag.Category4 = subject.SelectErpCategoryByParentNo(categoryNo3);
ViewBag.TopicNo = topicNo;
SWfsTopics topicModel = topicServ.GetSWfsTopics(topicNo);
ViewBag.TopicName = (null != topicModel) ? topicModel.TopicName : "";
ViewBag.SCategoryNo = gCategroyNo;
return(View(productList));
}
public ActionResult AddGoods(int pageIndex = 1, int pageSize = 20)
{
if (Request.QueryString["GoodsId"] != null)
{
ViewBag.GoodsId = Request.QueryString["GoodsId"];
}
int total = 0;
if (Request.QueryString["keyWord"] != null)
{
ViewBag.keyWord = Request.QueryString["keyWord"];
}
if (Request.QueryString["CategoryNo"] != null)
{
ViewBag.category = Request.QueryString["CategoryNo"];
}
if (Request.QueryString["Gender"] != null)
{
ViewBag.Gender = Request.QueryString["Gender"];
}
if (Request.QueryString["brandNO"] != null)
{
ViewBag.BrandNO = Request.QueryString["brandNO"];
}
if (Request.QueryString["starttime"] != null && Request.QueryString["starttime"] != "")
{
ViewBag.StartDateShelf = Request.QueryString["starttime"];
}
if (Request.QueryString["endtime"] != null && Request.QueryString["endtime"] != "")
{
ViewBag.EndDateShelf = Request.QueryString["endtime"];
}
ViewBag.produclist = Request.Cookies["MyCook"] == null ? "" : Request.Cookies["MyCook"].Value + "";
IEnumerable <ProductInfo> list = productService.GetSWfsProductList(ViewBag.Gender, ViewBag.BrandNO, ViewBag.category, ViewBag.keyWord, ViewBag.StartDateShelf, ViewBag.EndDateShelf, pageIndex, pageSize, out total);
SWfsProductService service = new SWfsProductService();
foreach (var item in list)
{
//商品下的Skulist
IEnumerable <SpfSkuExtendInfo> skuList = productService.GetSkuListByProductNo(item.ProductNo);
if (skuList.Any())
{
//价格，上下架状态
item.MarketPriceRegion = skuList.Select(n => n.MarketPrice).Min().ToString() + "~" + skuList.Select(n => n.MarketPrice).Max().ToString();
item.StandardPriceRegion = skuList.Select(n => n.StandardPrice).Min().ToString() + "~" + skuList.Select(n => n.StandardPrice).Max().ToString();
item.GoldPriceRegion = skuList.Select(n => n.GoldPrice).Min().ToString() + "~" + skuList.Select(n => n.GoldPrice).Max().ToString();
item.PlatinumPriceRegion = skuList.Select(n => n.PlatinumPrice).Min().ToString() + "~" + skuList.Select(n => n.PlatinumPrice).Max().ToString();
item.DiamondPriceRegion = skuList.Select(n => n.DiamondPrice).Min().ToString() + "~" + skuList.Select(n => n.DiamondPrice).Max().ToString();
item.OutletPriceRegion = skuList.Select(n => n.OutletPrice).Min().ToString() + "~" + skuList.Select(n => n.OutletPrice).Max().ToString();
item.PromotionPriceRegion = skuList.Select(n => n.PromotionPrice).Min().ToString() + "~" + skuList.Select(n => n.PromotionPrice).Max().ToString();
item.IsShelf = skuList.Select(n => n.IsShelf = 2).FirstOrDefault();
item.PcShowState = skuList.Select(n => n.PcShowState = 1).FirstOrDefault();
item.DisabledState = skuList.Select(n => n.DisabledState = 0).FirstOrDefault();
}
ProductInventory inventory = service.GetInventoryByProductNo(item.ProductNo);
item.Quantity = inventory.SumQuantity;
item.LockQuantity = inventory.SumLockQuantity;
}
ViewBag.totalCount = total;
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
return(View(list));
}
