/// <summary> /// ����һ������ /// </summary> public void Add(ProductModel model) { DbCommand dbCommand = dbw.GetStoredProcCommand("UP_pdProduct_ADD"); dbw.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId); dbw.AddInParameter(dbCommand, "ProductName", DbType.AnsiString, model.ProductName); dbw.AddInParameter(dbCommand, "ProductCode", DbType.AnsiString, model.ProductCode); dbw.AddInParameter(dbCommand, "CatePath", DbType.AnsiString, model.CatePath); dbw.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId); dbw.AddInParameter(dbCommand, "TradePrice", DbType.Decimal, model.TradePrice); dbw.AddInParameter(dbCommand, "MerchantPrice", DbType.Decimal, model.MerchantPrice); dbw.AddInParameter(dbCommand, "ReducePrice", DbType.Decimal, model.ReducePrice); dbw.AddInParameter(dbCommand, "Stock", DbType.Int32, model.Stock); dbw.AddInParameter(dbCommand, "SmallImage", DbType.AnsiString, model.SmallImage); dbw.AddInParameter(dbCommand, "MediumImage", DbType.AnsiString, model.MediumImage); dbw.AddInParameter(dbCommand, "LargeImage", DbType.AnsiString, model.LargeImage); dbw.AddInParameter(dbCommand, "Keywords", DbType.AnsiString, model.Keywords); dbw.AddInParameter(dbCommand, "Brief", DbType.AnsiString, model.Brief); dbw.AddInParameter(dbCommand, "PageView", DbType.Int32, model.PageView); dbw.AddInParameter(dbCommand, "InsertTime", DbType.DateTime, model.InsertTime); dbw.AddInParameter(dbCommand, "ChangeTime", DbType.DateTime, model.ChangeTime); dbw.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); dbw.AddInParameter(dbCommand, "SortValue", DbType.Int32, model.SortValue); dbw.AddInParameter(dbCommand, "Score", DbType.Int32, model.Score); dbw.AddInParameter(dbCommand, "brandid", DbType.Int32, model.BrandID); dbw.AddInParameter(dbCommand, "specifications", DbType.AnsiString, model.Specifications); dbw.AddInParameter(dbCommand, "packinglist", DbType.AnsiString, model.PackingList); dbw.AddInParameter(dbCommand, "aftersaleservice", DbType.AnsiString, model.AfterSaleService); dbw.AddInParameter(dbCommand, "offerset", DbType.AnsiString, model.OfferSet); dbw.AddInParameter(dbCommand, "weight", DbType.Decimal, model.Weight); dbw.AddInParameter(dbCommand, "StockTip", DbType.AnsiString, model.StockTip); dbw.AddInParameter(dbCommand, "RelateProducts", DbType.AnsiString, model.RelateProducts); dbw.ExecuteNonQuery(dbCommand); }
public static ProductModel GetMainImageUrl(ProductModel Product) { Product.SmallImage = config.UrlRoot + Product.SmallImage; Product.MediumImage = config.UrlRoot + Product.MediumImage; Product.LargeImage = config.UrlRoot + Product.LargeImage; return Product; }
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; } }
/// <summary> /// ����ʵ������� /// </summary> public ProductModel ReaderBind(IDataReader dataReader) { ProductModel model=new ProductModel(); object ojb; ojb = dataReader["ProductId"]; if(ojb != null && ojb != DBNull.Value) { model.ProductId=(int)ojb; } model.ProductName=dataReader["ProductName"].ToString(); model.ProductCode=dataReader["ProductCode"].ToString(); model.CatePath=dataReader["CatePath"].ToString(); ojb = dataReader["CateId"]; if(ojb != null && ojb != DBNull.Value) { model.CateId=(int)ojb; } ojb = dataReader["TradePrice"]; if(ojb != null && ojb != DBNull.Value) { model.TradePrice=(decimal)ojb; } ojb = dataReader["MerchantPrice"]; if(ojb != null && ojb != DBNull.Value) { model.MerchantPrice=(decimal)ojb; } ojb = dataReader["ReducePrice"]; if(ojb != null && ojb != DBNull.Value) { model.ReducePrice=(decimal)ojb; } ojb = dataReader["Stock"]; if(ojb != null && ojb != DBNull.Value) { model.Stock=(int)ojb; } model.SmallImage=dataReader["SmallImage"].ToString(); model.MediumImage=dataReader["MediumImage"].ToString(); model.LargeImage=dataReader["LargeImage"].ToString(); model.Keywords=dataReader["Keywords"].ToString(); model.Brief=dataReader["Brief"].ToString(); ojb = dataReader["PageView"]; if(ojb != null && ojb != DBNull.Value) { model.PageView=(int)ojb; } ojb = dataReader["InsertTime"]; if(ojb != null && ojb != DBNull.Value) { model.InsertTime=(DateTime)ojb; } ojb = dataReader["ChangeTime"]; if(ojb != null && ojb != DBNull.Value) { model.ChangeTime=(DateTime)ojb; } ojb = dataReader["Status"]; if(ojb != null && ojb != DBNull.Value) { model.Status=Convert.ToInt32(ojb); } ojb = dataReader["SortValue"]; if(ojb != null && ojb != DBNull.Value) { model.SortValue=(int)ojb; } ojb = dataReader["Score"]; if(ojb != null && ojb != DBNull.Value) { model.Score=(int)ojb; } ojb = dataReader["brandid"]; if (ojb != null && ojb != DBNull.Value) { model.BrandID = Convert.ToInt32(ojb); } model.Specifications = Convert.ToString(dataReader["Specifications"]); model.PackingList = Convert.ToString(dataReader["PackingList"]); model.AfterSaleService = Convert.ToString(dataReader["AfterSaleService"]); model.OfferSet = Convert.ToString(dataReader["OfferSet"]); model.Weight = Convert.ToDecimal(dataReader["weight"]); model.StockTip = Convert.ToString(dataReader["stocktip"]); model.RelateProducts = Convert.ToString(dataReader["RelateProducts"]); return model; }
/// <summary> /// ����һ������ /// </summary> public void Add(ProductModel model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(ProductModel model) { dal.Update(model); }
/// <summary> /// ��������б� /// </summary> public List<ProductModel> GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); List<ProductModel> modelList = new List<ProductModel>(); int rowsCount = ds.Tables[0].Rows.Count; if (rowsCount > 0) { ProductModel model; for (int n = 0; n < rowsCount; n++) { model = new ProductModel(); if(ds.Tables[0].Rows[n]["ProductId"].ToString()!="") { model.ProductId=int.Parse(ds.Tables[0].Rows[n]["ProductId"].ToString()); } model.ProductName=ds.Tables[0].Rows[n]["ProductName"].ToString(); model.ProductCode=ds.Tables[0].Rows[n]["ProductCode"].ToString(); model.CatePath=ds.Tables[0].Rows[n]["CatePath"].ToString(); if(ds.Tables[0].Rows[n]["CateId"].ToString()!="") { model.CateId=int.Parse(ds.Tables[0].Rows[n]["CateId"].ToString()); } if(ds.Tables[0].Rows[n]["TradePrice"].ToString()!="") { model.TradePrice=decimal.Parse(ds.Tables[0].Rows[n]["TradePrice"].ToString()); } if(ds.Tables[0].Rows[n]["MerchantPrice"].ToString()!="") { model.MerchantPrice=decimal.Parse(ds.Tables[0].Rows[n]["MerchantPrice"].ToString()); } if(ds.Tables[0].Rows[n]["ReducePrice"].ToString()!="") { model.ReducePrice=decimal.Parse(ds.Tables[0].Rows[n]["ReducePrice"].ToString()); } if(ds.Tables[0].Rows[n]["Stock"].ToString()!="") { model.Stock=int.Parse(ds.Tables[0].Rows[n]["Stock"].ToString()); } model.SmallImage=ds.Tables[0].Rows[n]["SmallImage"].ToString(); model.MediumImage=ds.Tables[0].Rows[n]["MediumImage"].ToString(); model.LargeImage=ds.Tables[0].Rows[n]["LargeImage"].ToString(); model.Keywords=ds.Tables[0].Rows[n]["Keywords"].ToString(); model.Brief=ds.Tables[0].Rows[n]["Brief"].ToString(); if(ds.Tables[0].Rows[n]["PageView"].ToString()!="") { model.PageView=int.Parse(ds.Tables[0].Rows[n]["PageView"].ToString()); } if(ds.Tables[0].Rows[n]["InsertTime"].ToString()!="") { model.InsertTime=DateTime.Parse(ds.Tables[0].Rows[n]["InsertTime"].ToString()); } if(ds.Tables[0].Rows[n]["ChangeTime"].ToString()!="") { model.ChangeTime=DateTime.Parse(ds.Tables[0].Rows[n]["ChangeTime"].ToString()); } if(ds.Tables[0].Rows[n]["Status"].ToString()!="") { model.Status=int.Parse(ds.Tables[0].Rows[n]["Status"].ToString()); } if(ds.Tables[0].Rows[n]["SortValue"].ToString()!="") { model.SortValue=int.Parse(ds.Tables[0].Rows[n]["SortValue"].ToString()); } if(ds.Tables[0].Rows[n]["Score"].ToString()!="") { model.Score=int.Parse(ds.Tables[0].Rows[n]["Score"].ToString()); } modelList.Add(model); } } return modelList; }