//查询所有 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); }