public CategoryModel GetSelectedRegionInfo() { string regionPath = String.Empty; string country = Request.Form["category0"]; string province = Request.Form["category1"]; string city = Request.Form["category2"]; string county = Request.Form["category3"]; int curRegionId = 0; if (curRegionId == 0 && !String.IsNullOrEmpty(county)) { int.TryParse(county, out curRegionId); } if (curRegionId == 0 && !String.IsNullOrEmpty(city)) { int.TryParse(city, out curRegionId); } if (curRegionId == 0 && !String.IsNullOrEmpty(province)) { int.TryParse(province, out curRegionId); } if (curRegionId == 0 && !String.IsNullOrEmpty(country)) { int.TryParse(country, out curRegionId); } CategoryModel result = null; if (curRegionId > 0) { result = new CategoryModelBll().GetModel(curRegionId); } return(result); }
private void DeleteRelation(int CateID, int BrandID) { bll.Delete(BrandID, CateID); DataTable sonCates = new CategoryModelBll().GetList(" parentid=" + CateID).Tables[0]; if (sonCates.Rows.Count > 0) { foreach (DataRow row in sonCates.Rows) { DeleteRelation(Convert.ToInt32(row["cateid"]), BrandID); } } }
//大类>>小类,商品点击量|购买量 批量操作上下架 private void BindData(int PageIndex) { if (SearchCondition != ConstructSearchCondition()) { SearchCondition = ConstructSearchCondition(); } //Response.Write(SearchCondition); int RecordCount = 0; DataTable dt = bll.GetList(PageIndex, AspNetPager.PageSize, SearchCondition, out RecordCount).Tables[0]; //Response.Write("<br/>recordcount:"+RecordCount); dt.Columns.Add("producturl"); dt.Columns.Add("secondarycategoryid"); dt.Columns.Add("secondarycategoryname"); dt.Columns.Add("endcategoryid"); dt.Columns.Add("endcategoryname"); dt.Columns.Add("ishotsale"); dt.Columns.Add("isreduce"); dt.Columns.Add("isrecommend"); foreach (DataRow row in dt.Rows) { string CategoryNamePath = new CategoryModelBll().GetCategoryNamePath(Convert.ToInt32(row["cateid"])); string CategoryIDPath = new CategoryModelBll().GetCategoryPath(Convert.ToInt32(row["cateid"])); row["producturl"] = GetProductUrl(Convert.ToInt32(row["productid"])); row["secondarycategoryid"] = CategoryIDPath.Split('/')[1]; row["endcategoryid"] = CategoryIDPath.Split('/')[CategoryIDPath.Split('/').Length - 2]; row["secondarycategoryname"] = CategoryNamePath.Split('/')[1]; row["endcategoryname"] = CategoryNamePath.Split('/')[CategoryNamePath.Split('/').Length - 2]; SalesProductModelBll salesBll = new SalesProductModelBll(); row["ishotsale"] = salesBll.Exists(Convert.ToInt32(row["productid"]), SalesProductType.热销商品); row["isreduce"] = salesBll.Exists(Convert.ToInt32(row["productid"]), SalesProductType.直降特卖); row["isrecommend"] = salesBll.Exists(Convert.ToInt32(row["productid"]), SalesProductType.鼎鼎推荐); } GridView1.DataSource = dt; GridView1.DataBind(); AspNetPager.RecordCount = RecordCount; AspNetPager.CurrentPageIndex = PageIndex; //InitializeSerchCondition(); }
public XmlNode GetCategoryList() { XmlNode CategoryListNode = xdoc.CreateElement("categorylist"); int AncestorID = new CategoryModelBll().GetAncestorID(Parameter.CategoryID); XmlNode AncestorInfoNode = XmlUtility.AddNewNode(CategoryListNode, "ancestorinfo", null); CategoryModel AncestorCategory = new CategoryModelBll().GetModel(AncestorID); XmlUtility.AddNewNode(AncestorInfoNode, "categoryid", Convert.ToString(AncestorID)); XmlUtility.AddNewNode(AncestorInfoNode, "categoryname", AncestorCategory.CateName); XmlNode CategoriesNode = XmlUtility.AddNewNode(CategoryListNode, "categories", null); DataTable RootCategories = dal.GetCategorySonList(AncestorID); foreach (DataRow row in RootCategories.Rows) { XmlNode FatherNode = XmlUtility.AddNewNode(CategoriesNode, "fathercategory", null); XmlUtility.SetAtrributeValue(FatherNode, "categoryid", Convert.ToString(row["cateid"])); XmlUtility.SetAtrributeValue(FatherNode, "categoryname", Convert.ToString(row["catename"])); int CategoryID = Convert.ToInt32(row["cateid"]); DataTable SonCategories = dal.GetCategorySonList(CategoryID); if (SonCategories.Rows.Count > 0) { foreach (DataRow srow in SonCategories.Rows) { XmlNode SonNode = XmlUtility.AddNewNode(FatherNode, "soncategory", null); XmlUtility.SetAtrributeValue(SonNode, "categoryid", Convert.ToString(srow["cateid"])); XmlUtility.SetAtrributeValue(SonNode, "categoryname", Convert.ToString(srow["catename"])); } } } return(CategoryListNode); }
private void ShowInfo(int scenceId, int cateId) { SolutionCategoryBll scbll = new SolutionCategoryBll(); SolutionCategoryModel scmodel = scbll.GetModel(scenceId, cateId); CategoryModelBll cbll = new CategoryModelBll(); CategoryModel cmodel = cbll.GetModel(cateId); if (cmodel == null) { throw new NoName.NetShop.Common.ShopException("分类不存在", true); } InitConditionItems(cateId); if (scmodel != null) { lblCateId.Text = scmodel.CateId.ToString(); lblSenceId.Text = scmodel.SenceId.ToString(); chkIsShow.Checked = scmodel.IsShow; txtRemark.Text = scmodel.Remark; txtPosition.Text = scmodel.Position; if (!String.IsNullOrEmpty(scmodel.CateImage)) { this.imgCate.Visible = true; this.imgCate.ImageUrl = Common.CommonImageUpload.GetCommonImageFullUrl(scmodel.CateImage); } else { this.imgCate.Visible = false; } PresetConditionItems(scenceId, cateId); } else { lblCateId.Text = cmodel.CateId.ToString(); lblSenceId.Text = scenceId.ToString(); txtRemark.Text = cmodel.CateName; } }
private void InitConditionItems(int cateId) { BrandCategoryRelationBll bcrbll = new BrandCategoryRelationBll(); this.cblBrands.DataSource = bcrbll.GetCategoryBrandList(cateId); this.cblBrands.DataTextField = "BrandName"; this.cblBrands.DataValueField = "BrandId"; this.cblBrands.DataBind(); NoName.NetShop.Product.BLL.CategoryModelBll cbll = new CategoryModelBll(); this.cblSubCate.DataSource = cbll.GetSubCategory(cateId); this.cblSubCate.DataTextField = "CateName"; this.cblSubCate.DataValueField = "CateId"; this.cblSubCate.DataBind(); CategoryParaModelBll cpbll = new CategoryParaModelBll(); List <CategoryParaModel> plist = cpbll.GetModelList("status=1 and paratype=1 and cateid=" + cateId); rpItems.DataSource = plist; rpItems.DataBind(); }
private DataTable GetSubCategory(int ParentID) { CategoryModelBll bll = new CategoryModelBll(); return(bll.GetList("parentid = " + ParentID).Tables[0]); }
private string ConstructSearchCondition() { string condition = String.Empty; //构建搜索条件 if (CheckBox1.Checked || InitialCategoryID != -1) { #region s1 bool IsEnd; int SelectedCategoryID = 0; string s1 = String.Empty; if (IsPostBack) { SelectedCategoryID = CategorySelect1.GetSelectedRegionInfo().CateId; if (SelectedCategoryID == -1) { MessageBox.Show(this, "请至少选择一个分类"); return(String.Empty); } } else { SelectedCategoryID = InitialCategoryID; } if (SelectedCategoryID != -1) { string CategoryPath = new CategoryModelBll().GetModel(SelectedCategoryID).CatePath; s1 = " and catepath like '" + CategoryPath + "%'"; condition += s1; //SearchCondition.Add("s1",s1); if (!CheckBox1.Checked) { CheckBox1.Checked = true; } CategoryPath = CategoryPath.Substring(0, CategoryPath.LastIndexOf("/")); CategorySelect1.PresetRegionInfo(CategoryPath); } #endregion } if (CheckBox2.Checked) { #region s2 string s2 = String.Empty; if (!String.IsNullOrEmpty(TextBox1.Text) && PageValidate.IsNumber(TextBox1.Text)) { s2 = " and productid=" + TextBox1.Text; condition += s2; //SearchCondition.Add("s2",s2); } else { MessageBox.Show(this, "请输入正确的产品ID"); return(String.Empty); } #endregion } if (CheckBox3.Checked) { #region s3 string s3 = String.Empty; int Status = Convert.ToInt32(drpStatus.SelectedValue); s3 = " and status='" + Status + "'"; condition += s3; #endregion } if (CheckBox4.Checked) { if (!String.IsNullOrEmpty(TextBox2.Text)) { condition += " and productname like '%" + TextBox2.Text + "%'"; } else { MessageBox.Show(this, "请输入产品名称"); return(String.Empty); } } if (CheckBox5.Checked) { if (!String.IsNullOrEmpty(TextBox3.Text) && !String.IsNullOrEmpty(TextBox4.Text) && PageValidate.IsDate(TextBox3.Text) && PageValidate.IsDate(TextBox4.Text)) { DateTime start = Convert.ToDateTime(TextBox3.Text); DateTime end = Convert.ToDateTime(TextBox4.Text); condition += String.Format(" and InsertTime >= '{0}' and InsertTime <= '{1}'", start, end); } else { MessageBox.Show(this, "请输入正确的日期"); return(String.Empty); } } if (CheckBox6.Checked) { if (!String.IsNullOrEmpty(TextBoxSearch_ScoreStart.Text) && !String.IsNullOrEmpty(TextBoxSearch_ScoreEnd.Text)) { condition += String.Format(" and score between {0} and {1}", TextBoxSearch_ScoreStart.Text, TextBoxSearch_ScoreEnd.Text); } else { MessageBox.Show(this, "请输入正确的积分"); return(String.Empty); } } if (CheckBox7.Checked) { int StockStatus = Convert.ToInt32(DropDownList_Stock.SelectedValue); if (StockStatus == 0) { condition += " and stock=0"; } else { condition += " and stock>0"; } } if (CheckBox8.Checked) { if (!String.IsNullOrEmpty(TextBoxSearch_StartTime.Text) && !String.IsNullOrEmpty(TextBoxSearch_EndTime.Text) && PageValidate.IsDate(TextBoxSearch_StartTime.Text) && PageValidate.IsDate(TextBoxSearch_EndTime.Text)) { DateTime start = Convert.ToDateTime(TextBoxSearch_StartTime.Text); DateTime end = Convert.ToDateTime(TextBoxSearch_EndTime.Text); condition += String.Format(" and changetime >= '{0}' and changetime <= '{1}'", start, end); } else { MessageBox.Show(this, "请输入正确的日期"); return(String.Empty); } } if (CheckBox9.Checked) { BrandModel model; if (!String.IsNullOrEmpty(TextBoxSearch_Brand.Text.Trim()) && new BrandModelBll().RawExists(TextBoxSearch_Brand.Text.Trim(), out model)) { condition += String.Format(" and brandid = " + model.BrandId); } else { MessageBox.Show(this, "未输入或未查找到您输入的品牌"); return(String.Empty); } } return(condition); }
private int AddProduct() { int rtnValue = 0; string strErr = ""; if (this.txtProductName.Text == "") { strErr += "产品名称不能为空!\\n"; } if (!PageValidate.IsDecimal(txtTradePrice.Text)) { strErr += "市场价输入有误!\\n"; } if (!PageValidate.IsDecimal(txtMerchantPrice.Text)) { strErr += "销售价输入有误!\\n"; } if (!PageValidate.IsDecimal(txtReducePrice.Text)) { strErr += "直降价输入有误!\\n"; } if (!PageValidate.IsNumber(txtScore.Text)) { strErr += "商品积分输入有误!\\n"; } if (!PageValidate.IsDecimal(txtWeight.Text)) { strErr += "商品重量输入有误!\\n"; } if (this.fulImage.FileName == "") { strErr += "产品图片不能为空!\\n"; } if (this.txtKeywords.Text == "") { strErr += "关键词不能为空!\\n"; } if (this.TextBox_Description.Text == "") { strErr += "商品简介不能为空!\\n"; } if (!PageValidate.IsNumber(drpStatus.SelectedValue)) { strErr += "商品状态选择有误!\\n"; } int TempNewsID = 0; if (!String.IsNullOrEmpty(txtNewsID.Text) && !int.TryParse(txtNewsID.Text, out TempNewsID)) { strErr += "关联资讯ID输入有误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); rtnValue = 1; return(rtnValue); } if (bll.Exists(txtProductName.Text)) { MessageBox.Show(this, "对不起,该商品名称已存在,无法添加同名商品"); rtnValue = 1; return(rtnValue); } CategoryModel cate = new CategoryModelBll().GetModel(Convert.ToInt32(txtCategoryID.Value)); string[] MainImages; if (ProductMainImageRule.SaveProductMainImage(ProductID, cate.CatePath, fulImage.PostedFile, out MainImages)) { ProductModel product = new ProductModel(); product.ProductId = ProductID; product.ProductCode = String.IsNullOrEmpty(txtProductCode.Text) ? ProductID.ToString() : txtProductCode.Text; product.ProductName = txtProductName.Text; product.CateId = cate.CateId; product.CatePath = cate.CatePath; product.InsertTime = DateTime.Now; product.ChangeTime = DateTime.Now; product.Keywords = txtKeywords.Text; product.Brief = TextBox_Description.Text; product.BrandID = Convert.ToInt32(DropDown_Brand.SelectedValue); product.SmallImage = MainImages[0]; product.MediumImage = MainImages[1]; product.LargeImage = MainImages[2]; product.MerchantPrice = Convert.ToDecimal(txtMerchantPrice.Text); product.ReducePrice = Convert.ToDecimal(txtReducePrice.Text); product.TradePrice = Convert.ToDecimal(txtTradePrice.Text); product.PageView = 0; product.Score = 0; //product.SortValue = ""; product.Status = Convert.ToInt32(drpStatus.SelectedValue); product.Stock = int.MaxValue; product.Specifications = TextBox_Specification.Text; product.PackingList = TextBox_Packing.Text; product.AfterSaleService = TextBox_Service.Text; product.OfferSet = TextBox_OfferSet.Text; product.Weight = Convert.ToDecimal(txtWeight.Text); product.StockTip = GetStockTip(); product.RelateProducts = txtRelateProduct.Text.Replace(",", ","); new ProductNewsBll().Add(new ProductNewsModel() { ProdutID = ProductID, NewsID = TempNewsID }); bll.Add(product); //添加产品检索属性 foreach (GridViewRow row in GridView_Parameter.Rows) { RadioButtonList ParameterValueList = ((RadioButtonList)row.Cells[0].FindControl("RadioList_ParameterValue")); if (!String.IsNullOrEmpty(ParameterValueList.SelectedValue)) { int ParameterID = Convert.ToInt32(((HiddenField)row.Cells[0].FindControl("Hidden_ParameterID")).Value); string ParameterValue = Convert.ToString(ParameterValueList.SelectedItem.Text); ProductParaModel para = new ProductParaModel(); para.ParaId = ParameterID; para.ProductId = product.ProductId; para.ParaValue = ParameterValue; pvBll.Add(para); } } //添加产品基本属性 foreach (GridViewRow row in GridView_Specification.Rows) { RadioButtonList ParameterValueList = ((RadioButtonList)row.Cells[0].FindControl("RadioList_SpecificationValue")); if (!String.IsNullOrEmpty(ParameterValueList.SelectedValue)) { int ParameterID = Convert.ToInt32(((HiddenField)row.Cells[0].FindControl("Hidden_SpecificationID")).Value); string ParameterValue = Convert.ToString(ParameterValueList.SelectedItem.Text); ProductParaModel para = new ProductParaModel(); para.ParaId = ParameterID; para.ProductId = product.ProductId; para.ParaValue = ParameterValue; pvBll.Add(para); } } //添加商品多图 foreach (string s in Request.Files.AllKeys) { if (s.StartsWith("multiImageUpload") && Request.Files[s].ContentLength > 0) { string[] FileNames; ProductMultiImageRule.SaveProductMultiImage(ProductID, cate.CatePath, Request.Files[s], out FileNames); if (FileNames != null) { ProductImageModel model = new ProductImageModel(); model.ImageId = CommDataHelper.GetNewSerialNum("pd"); model.ProductId = ProductID; model.LargeImage = FileNames[1]; model.OriginImage = FileNames[2]; model.SmallImage = FileNames[0]; model.Title = String.Empty; new ProductImageModelBll().Add(model); } } } //创建索引 try { DataIndexerProduct SearchIndexer = new DataIndexerProduct(Config.Searches["product"]); SearchIndexer.CreateSingleIndex(new Search.Entities.ProductModel() { EntityIdentity = product.ProductId, CategoryID = product.CateId, CategoryPath = product.CatePath, CreateTime = product.InsertTime, Description = product.Brief, Keywords = product.Keywords, Price = product.MerchantPrice, ProcessType = NoName.NetShop.Search.Entities.EntityProcessType.insert, ProductImage = product.MediumImage, ProductName = product.ProductName, UpdateTime = product.ChangeTime }); } catch { } return(rtnValue); } else { MessageBox.Show(this, "图片上传失败,请检查!"); rtnValue = 1; return(rtnValue); } }