//查询所有
public IList <WfsBrandSort> SelectWfsBrandAll()
{
IList <WfsBrandSort> listWfsBrand = DapperUtil.Query <WfsBrandSort>("ComBeziWfs_Brand_Sort_List").ToList();
ProductRulesService prs = new ProductRulesService();
IList <SWfsSortOcsCategory> listocs = prs.IsRuleCategoryAll();
foreach (WfsBrandSort item in listWfsBrand)
{
//IList<SWfsSortOcsCategory> list=listocs.Where(t=>t.CategoryNo==item.BrandNo).ToList();
if (listocs.Count(p => p.CategoryNo == item.BrandNo && p.DateUpdate.ToString("yyyy-MM-dd") != "1900-01-01") == 1)
{
item.AutoLastFlag = listocs.Single(p => p.CategoryNo == item.BrandNo).AutoLastFlag;
item.SortUpdateDate = listocs.Single(p => p.CategoryNo == item.BrandNo).DateUpdate.ToString("yyyy-MM-dd");
item.IsUpdateDateOne = IsOne(listocs.Single(p => p.CategoryNo == item.BrandNo).DateUpdate, System.DateTime.Now);
}
//SWfsSortOcsCategory ocsCategory = prs.IsRuleCategoryAll(item.BrandNo);
//item.AutoLastFlag = list.Count != 0 ? list[0].AutoLastFlag : 0;
//if (list.Count != 0 != null && ocsCategory.DateUpdate.ToString("yyyy-MM-dd") != "1900-01-01")
//{
// item.SortUpdateDate = ocsCategory.DateUpdate.ToString("yyyy-MM-dd");
// item.IsUpdateDateOne = IsOne(ocsCategory.DateUpdate, System.DateTime.Now);
//}
}
return(listWfsBrand);
}
public ActionResult ProductList()
{
//数据验证
Parameters param = new Parameters();
param.productNO = Request.Form["productNo"];
if (string.IsNullOrEmpty(Request.Form["categoryNo"]))
{
TempData["tip"] = "<script>alert('商品分类不存在')</script>";
return(Redirect("/productflat/product/ProductList?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"]));
}
if (string.IsNullOrEmpty(param.productNO))
{
TempData["tip"] = "<script>alert('请选择加入排序的商品')</script>";
return(Redirect("/productflat/product/ProductList?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"]));
}
ProductSortService tian = new ProductSortService();
List <SortProduct> searchProductList = tian.GetXMLProductByProductNo(param);
ProductRulesService zhao = new ProductRulesService();
for (int i = 0; i < searchProductList.Count; i++)
{
//searchProductList.ElementAt(i).RuleType
zhao.AddProductToSort(Request.Form["categoryNo"], "", Request.QueryString["categoryType"], searchProductList.ElementAt(i));
//zhao.AddProductToSort(Request.Form["categoryNo"], Request.Form["categoryName"], searchProductList.ElementAt(i));
}
TempData["tip"] = "<script>alert('操作成功')</script>";
return(Redirect("/productflat/product/ProductList?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"] + "&pageindex=" + Request.QueryString["pageindex"] + "&categoryType=" + Request.QueryString["categoryType"] + "&isLast=" + Request.QueryString["isLast"] + "&CategoryPath=" + Request.QueryString["CategoryPath"]));
}
public string ClearProductListByCategory(string CategoryNo)
{
string result = "";
ProductRulesService SortService = new ProductRulesService();
result = SortService.DelProductByCategoryNo(CategoryNo) + "";
result = SortService.DelSortRuleByCategoryNo(CategoryNo) + "";
return(result);
}
//验证是否已经加入
public ActionResult AddProductAjax()
{
Parameters param = new Parameters();
param.productNO = Request.Form["productNo"];
if (string.IsNullOrEmpty(Request.Form["categoryNo"]))
{
return(Json(new
{
error = 1,
msg = "商品分类不存在"
}));
}
if (string.IsNullOrEmpty(param.productNO))
{
return(Json(new
{
error = 1,
msg = "商品编号不存在"
}));
}
if (string.IsNullOrEmpty(Request.Form["categoryType"]))
{
return(Json(new
{
error = 1,
msg = "请选择左侧的分类或则品牌"
}));
}
ProductSortService tian = new ProductSortService();
List <SortProduct> searchProductList = tian.GetXMLProductByProductNo(param);
SWfsSortProduct saveProductObj = tian.GetSortProductByProductNo(Request.Form["productNo"], Request.Form["categoryNo"]);
if (saveProductObj != null)
{
if (searchProductList.Count(p => p.ProductNo == saveProductObj.ProductNo) > 0)
{
return(Json(new
{
error = 1,
msg = "该商品已加入排序"
}));
}
}
ProductRulesService zhao = new ProductRulesService();
for (int i = 0; i < searchProductList.Count; i++)
{
zhao.AddProductToSort(Request.Form["categoryNo"].ToUpper(), "", Request.Form["categoryType"], searchProductList.ElementAt(i));
}
return(Json(new
{
error = 0,
msg = "加入成功"
}));
}
/// <summary>
/// 查找子类别
/// </summary>
/// <param name="parentNo">父级NO</param>
/// <returns></returns>
public IList <OCSInfo> SelectCategoryByParentNo(string parentNo)
{
IList <OCSInfo> CategoryList = DapperUtil.Query <OCSInfo>("ComBeziWfs_WfsCategory_CategoryByParentNO", new { ParentNo = parentNo }).ToList();
foreach (OCSInfo item in CategoryList)
{
//int ChildCount = DapperUtil.Query<int>("ComBeziWfs_WfsCategory_CategoryByIsParent", new { ParentNo = item.CategoryNo }).First();
item.isParent = true;
ProductRulesService prs = new ProductRulesService();
SWfsSortOcsCategory ocsCategory = prs.IsRuleCategory(item.CategoryNo);
item.AutoLastFlag = ocsCategory != null?ocsCategory.AutoLastFlag:0;
if (ocsCategory != null && ocsCategory.DateUpdate.ToString("yyyy-MM-dd") != "1900-01-01")
{
item.SortUpdateDate = ocsCategory.DateUpdate.ToString("yyyy-MM-dd");
item.IsUpdateDateOne = IsOne(ocsCategory.DateUpdate, System.DateTime.Now);
}
}
return(CategoryList);
}
//根据搜索条件生成搜索参数
private Parameters CreateParam(int pageIndex, int pageSize)
{
Parameters p = new Parameters();
if (Request.QueryString["childCategoryNO"] != null && Request.QueryString["childCategoryNO"] != "0")
{
p.categoryNO = Request.QueryString["childCategoryNO"].ToUpper();
p.OCSCategoryName = Server.UrlDecode(Request.QueryString["childCategoryname"]);
//p.OCSCategoryName = Request.QueryString["childCategoryname"];
}
p.start = ((pageIndex - 1) * pageSize + 1) + "";
p.end = (pageIndex * pageSize) + "";
if (!string.IsNullOrEmpty(Request.QueryString["ProductNo"]))
{
p.productNO = Request.QueryString["ProductNo"];
}
if (!string.IsNullOrEmpty(Request.QueryString["brandNO"]) && Request.QueryString["brandNO"] != "0")
{
p.brandNO = Request.QueryString["brandNO"].ToUpper();
p.BrandName = Server.UrlDecode(Request.QueryString["brandName"]);
//p.BrandName = Request.QueryString["brandName"];
}
if (!string.IsNullOrEmpty(Request.QueryString["colorId"]) && Request.QueryString["colorId"] != "0")
{
p.colorId = Request.QueryString["colorId"].ToUpper();
p.ColorName = Server.UrlDecode(Request.QueryString["colorName"]);
//p.ColorName = Request.QueryString["colorName"];
}
if (!string.IsNullOrEmpty(Request.QueryString["ProductName"]))
{
p.productName = Server.UrlEncode(Request.QueryString["ProductName"]);
//p.productName = Server.UrlDecode(Request.QueryString["ProductName"]);
//p.productName = Url.Encode(Request.QueryString["ProductName"]);
}
if (Request.QueryString["shelfType"] == "0")
{
p.shelfType = "0";
if (Request.QueryString["categoryType"] == "1")
{
ProductRulesService prs = new ProductRulesService();
SWfsSortOcsCategory ocsCategory = prs.IsRuleCategory(Request.QueryString["categoryno"]);//用分类的ID查询
if (ocsCategory != null && ocsCategory.DateUpdate.ToString("yyyy-MM-dd") != "1900-01-01")
{
p.shelfDate = ocsCategory.DateUpdate.ToString("yyyy-MM-dd HH:mm:ss") + "~" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
}
else if (Request.QueryString["categoryType"] == "2")
{
ProductRulesService prs = new ProductRulesService();
SWfsSortOcsCategory ocsCategory = prs.IsRuleCategory(Request.QueryString["BrandNO"]);//用品牌ID查询
if (ocsCategory != null && ocsCategory.DateUpdate.ToString("yyyy-MM-dd") != "1900-01-01")
{
p.shelfDate = ocsCategory.DateUpdate.ToString("yyyy-MM-dd HH:mm:ss") + "~" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
}
}
else if (Request.QueryString["shelfType"] == "1")
{
if (!string.IsNullOrEmpty(Request.QueryString["shelfDateStart"]) && !string.IsNullOrEmpty(Request.QueryString["shelfDateEnd"]))
{
p.shelfType = "1";
p.shelfDate = Request.QueryString["shelfDateStart"] + "~" + Request.QueryString["shelfDateEnd"];
p.StartShelfDate = Request.QueryString["shelfDateStart"];
p.EndShelfDate = Request.QueryString["shelfDateEnd"];
}
}
if (!string.IsNullOrWhiteSpace(Request.QueryString["postArea"]))
{
p.postArea = Request.QueryString["postArea"];
}
if (!string.IsNullOrEmpty(Request.QueryString["MinPrice"]))
{
p.price = Request.QueryString["MinPrice"] + "~" + (string.IsNullOrEmpty(Request.QueryString["MaxPrice"]) ? "10000000" : Request.QueryString["MaxPrice"]);
p.StartPrice = Request.QueryString["MinPrice"];
p.EndPrice = string.IsNullOrEmpty(Request.QueryString["MaxPrice"]) ? "10000000" : Request.QueryString["MaxPrice"];
}
else if (!string.IsNullOrEmpty(Request.QueryString["MaxPrice"]))
{
p.price = "0" + "~" + Request.QueryString["MaxPrice"];
p.StartPrice = "0";
p.EndPrice = Request.QueryString["MaxPrice"];
}
if (!string.IsNullOrEmpty(Request.QueryString["MinStock"]))
{
p.stock = Request.QueryString["MinStock"] + "~" + (string.IsNullOrEmpty(Request.QueryString["MaxStock"]) ? "100000" : Request.QueryString["MaxStock"]);
p.StartStock = Request.QueryString["MinStock"];
p.EndStock = string.IsNullOrEmpty(Request.QueryString["MaxStock"]) ? "100000" : Request.QueryString["MaxStock"];
}
else if (!string.IsNullOrEmpty(Request.QueryString["MaxStock"]))
{
p.stock = "0" + "~" + Request.QueryString["MaxStock"];
p.StartStock = "0";
p.EndStock = Request.QueryString["MaxStock"];
}
if (Server.UrlDecode(Request.QueryString["MinDiscountRate"]) != null && Server.UrlDecode(Request.QueryString["MinDiscountRate"]) != "")
{
p.discountRate = Request.QueryString["MinDiscountRate"] + "~" + (string.IsNullOrEmpty(Request.QueryString["MaxDiscountRate"]) ? "100000" : Request.QueryString["MaxDiscountRate"]);
p.StartDiscountRate = Request.QueryString["MinDiscountRate"];
p.EndDiscountRate = string.IsNullOrEmpty(Request.QueryString["MaxDiscountRate"]) ? "100000" : Request.QueryString["MaxDiscountRate"];
}
else if (Server.UrlDecode(Request.QueryString["MaxDiscountRate"]) != null && Server.UrlDecode(Request.QueryString["MaxDiscountRate"]) != "")
{
p.discountRate = "0" + "~" + Request.QueryString["MaxDiscountRate"];
p.StartDiscountRate = "0";
p.EndDiscountRate = Request.QueryString["MaxDiscountRate"];
}
if (!string.IsNullOrEmpty(Request.QueryString["MinHot"]) && !string.IsNullOrEmpty(Request.QueryString["MaxHot"]))
{
if (Request.QueryString["HotType"] == "0")
{
p.hot = Request.QueryString["MinHot"] + "~" + Request.QueryString["MaxHot"];
}
else if (Request.QueryString["HotType"] == "1")
{
p.sevenHot = Request.QueryString["MinHot"] + "~" + Request.QueryString["MaxHot"];
}
}
return(p);
}
public string SaveProductSort(PageDateInfo PageDateList)
{
PageDateList.CategoryNo = PageDateList.CategoryNo;
ProductRulesService PsortService = new ProductRulesService();
string result = "0";
//没有执行规则
int sortInt = 0;
if (PageDateList.ProductList != null)
{
sortInt = sortInt + PageDateList.ProductList.Count();
}
if (PageDateList.RuleList != null)
{
for (int i = 0; i < PageDateList.RuleList.Count(); i++)
{
if (PageDateList.RuleList[i].ProductList != null)
{
sortInt = sortInt + PageDateList.RuleList[i].ProductList.Count();
}
if (PageDateList.RuleList[i].RuleList != null)
{
for (int k = 0; k < PageDateList.RuleList[i].RuleList.Count(); k++)
{
if (PageDateList.RuleList[i].RuleList[k].ProductList != null)
{
sortInt = sortInt + PageDateList.RuleList[i].RuleList[k].ProductList.Count();
}
}
}
}
}
if (PageDateList.IsRule == "0")
{
PsortService.DelSortRuleByCategoryNo(PageDateList.CategoryNo);
PsortService.DelProductByCategoryNo(PageDateList.CategoryNo);
PsortService.UpdateCateogryTime(PageDateList.CategoryNo, PageDateList.IsLast);
if (PageDateList.ProductList != null)
{
for (int i = 0; i < PageDateList.ProductList.Count(); i++)
{
SWfsSortProduct pdto = new SWfsSortProduct();
pdto.Sort = sortInt;
pdto.RuleId = -1;
pdto.ProductNo = PageDateList.ProductList[i].ProductNo;
pdto.DateCreate = DateTime.Now;
pdto.OcsCategoryNo = PageDateList.CategoryNo;// PageDateList.productlist[i].ocscategoryno;
PsortService.AddProductToSortSingle(pdto);
sortInt = sortInt - 1;
}
}
}
else
{
PsortService.DelSortRuleByCategoryNo(PageDateList.CategoryNo);
PsortService.DelProductByCategoryNo(PageDateList.CategoryNo);
PsortService.UpdateCateogryTime(PageDateList.CategoryNo, PageDateList.IsLast);
string parentid = "0";
if (PageDateList.RuleList != null)
{
for (int i = 0; i < PageDateList.RuleList.Count(); i++)
{
SWfsSortRule pruledto = new SWfsSortRule();
pruledto.OcsCategoryNo = PageDateList.CategoryNo;
pruledto.ParentId = 0;
pruledto.RuleObjectName = PageDateList.RuleList[i].RuleName;
pruledto.RuleObjectNo = PageDateList.RuleList[i].RuleNo;
pruledto.RuleType = Convert.ToInt16(PageDateList.RuleList[i].RuleType);
pruledto.Sort = PageDateList.RuleList.Count() - i;
parentid = PsortService.AddRuleToSort(pruledto);
if (PageDateList.RuleList[i].RuleList != null)
{
for (int j = 0; j < PageDateList.RuleList[i].RuleList.Count(); j++)
{
SWfsSortRule ruledto = new SWfsSortRule();
ruledto.OcsCategoryNo = PageDateList.CategoryNo;// PageDateList.categoryno;
ruledto.ParentId = Convert.ToInt32(parentid);
ruledto.RuleObjectName = PageDateList.RuleList[i].RuleList[j].RuleName;
ruledto.RuleObjectNo = PageDateList.RuleList[i].RuleList[j].RuleNo;
ruledto.RuleType = Convert.ToInt16(PageDateList.RuleList[i].RuleList[j].RuleType);
ruledto.Sort = PageDateList.RuleList[i].RuleList.Count() - j;
string ruleid = PsortService.AddRuleToSort(ruledto);
if (PageDateList.RuleList[i].RuleList[j].ProductList != null)
{
for (int k = 0; k < PageDateList.RuleList[i].RuleList[j].ProductList.Count(); k++)
{
SWfsSortProduct ptdto = new SWfsSortProduct();
ptdto.Sort = sortInt;
ptdto.RuleId = Convert.ToInt32(ruleid);
ptdto.ProductNo = PageDateList.RuleList[i].RuleList[j].ProductList[k].ProductNo;
ptdto.DateCreate = DateTime.Now;
ptdto.OcsCategoryNo = PageDateList.CategoryNo;// PageDateList.rulelist[i].rulelist[k].productlist[k].ocscategoryno;
PsortService.AddProductToSortSingle(ptdto);
sortInt = sortInt - 1;
}
}
}
}
if (PageDateList.RuleList[i].ProductList != null)
{
for (int l = 0; l < PageDateList.RuleList[i].ProductList.Count(); l++)
{
SWfsSortProduct podto = new SWfsSortProduct();
podto.Sort = sortInt;
podto.RuleId = Convert.ToInt32(parentid);
podto.ProductNo = PageDateList.RuleList[i].ProductList[l].ProductNo;
podto.OcsCategoryNo = PageDateList.CategoryNo;// PageDateList.rulelist[i].productlist[l].ocscategoryno;
podto.DateCreate = DateTime.Now;
PsortService.AddProductToSortSingle(podto);
sortInt = sortInt - 1;
}
}
if (PageDateList.ProductList != null)
{
for (int m = 0; m < PageDateList.ProductList.Count(); m++)
{
SWfsSortProduct dto = new SWfsSortProduct();
dto.Sort = sortInt;
dto.RuleId = 0;
dto.ProductNo = PageDateList.ProductList[m].ProductNo;
dto.OcsCategoryNo = PageDateList.CategoryNo;// PageDateList.productlist[m].ocscategoryno;
dto.DateCreate = DateTime.Now;
PsortService.AddProductToSortSingle(dto);
sortInt = sortInt - 1;
}
}
}
}
}
return(result);
}
