/// <summary> /// 获得数据列表 /// </summary> public List <ProductParaModel> GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); List <ProductParaModel> modelList = new List <ProductParaModel>(); int rowsCount = ds.Tables[0].Rows.Count; if (rowsCount > 0) { ProductParaModel model; for (int n = 0; n < rowsCount; n++) { model = new ProductParaModel(); if (ds.Tables[0].Rows[n]["ProductId"].ToString() != "") { model.ProductId = int.Parse(ds.Tables[0].Rows[n]["ProductId"].ToString()); } if (ds.Tables[0].Rows[n]["ParaId"].ToString() != "") { model.ParaId = int.Parse(ds.Tables[0].Rows[n]["ParaId"].ToString()); } model.ParaValue = ds.Tables[0].Rows[n]["ParaValue"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// ����һ������ /// </summary> public void Add(ProductParaModel model) { DbCommand dbCommand = dbw.GetStoredProcCommand("UP_pdProductPara_ADD"); dbw.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId); dbw.AddInParameter(dbCommand, "ParaId", DbType.Int32, model.ParaId); dbw.AddInParameter(dbCommand, "ParaValue", DbType.AnsiString, model.ParaValue); dbw.ExecuteNonQuery(dbCommand); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ProductParaModel model) { DbCommand dbCommand = dbw.GetStoredProcCommand("UP_pdProductPara_Update"); dbw.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId); dbw.AddInParameter(dbCommand, "ParaId", DbType.Int32, model.ParaId); dbw.AddInParameter(dbCommand, "ParaValue", DbType.AnsiString, model.ParaValue); dbw.ExecuteNonQuery(dbCommand); }
public void Save(ProductParaModel model) { if (!Exists(model.ProductId, model.ParaId)) { Add(model); } else { Update(model); } }
/// <summary> /// 对象实体绑定数据 /// </summary> public ProductParaModel ReaderBind(IDataReader dataReader) { ProductParaModel model = new ProductParaModel(); object ojb; ojb = dataReader["ProductId"]; if (ojb != null && ojb != DBNull.Value) { model.ProductId = (int)ojb; } ojb = dataReader["ParaId"]; if (ojb != null && ojb != DBNull.Value) { model.ParaId = (int)ojb; } model.ParaValue = dataReader["ParaValue"].ToString(); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ProductParaModel GetModel(int ProductId, int ParaId) { DbCommand dbCommand = dbr.GetStoredProcCommand("UP_pdProductPara_GetModel"); dbr.AddInParameter(dbCommand, "ProductId", DbType.Int32, ProductId); dbr.AddInParameter(dbCommand, "ParaId", DbType.Int32, ParaId); ProductParaModel model = null; using (IDataReader dataReader = dbr.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
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; } }
private void SaveData() { 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.txtKeywords.Text == "") { strErr += "关键词不能为空!\\n"; } if (this.TextBox_Brief.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输入有误"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } ProductModel product = bll.GetModel(ProductID); product.ProductName = txtProductName.Text; product.ProductCode = txtProductCode.Text; product.CateId = Convert.ToInt32(txtCategoryID.Value); product.TradePrice = Convert.ToDecimal(txtTradePrice.Text); product.MerchantPrice = Convert.ToDecimal(txtMerchantPrice.Text); product.ReducePrice = Convert.ToDecimal(txtReducePrice.Text); product.Status = Convert.ToInt32(drpStatus.SelectedValue); product.Keywords = txtKeywords.Text; product.Brief = TextBox_Brief.Text; product.BrandID = Convert.ToInt32(DropDown_Brand.SelectedValue); product.Specifications = TextBox_Specification.Text; product.OfferSet = TextBox_OfferSet.Text; product.PackingList = TextBox_Packing.Text; product.AfterSaleService = TextBox_Service.Text; product.Weight = Convert.ToDecimal(txtWeight.Text); product.StockTip = GetStockTip(); product.RelateProducts = txtRelateProduct.Text.Replace(",", ","); product.ChangeTime = DateTime.Now; if (fulImage.FileName != String.Empty) { string[] MainImages; ProductMainImageRule.SaveProductMainImage(ProductID, product.CatePath, fulImage.PostedFile, out MainImages); product.SmallImage = MainImages[0]; product.MediumImage = MainImages[1]; product.LargeImage = MainImages[2]; } //更新检索属性 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.Save(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.Save(para); } } //添加商品多图 foreach (string s in Request.Files.AllKeys) { if (s.StartsWith("multiImageUpload") && Request.Files[s].ContentLength > 0) { string[] FileNames; ProductMultiImageRule.SaveProductMultiImage(ProductID, product.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); } } } //更新关联资讯ID new ProductNewsBll().Save(new ProductNewsModel() { ProdutID = product.ProductId, NewsID = TempNewsID }); bll.Update(product); //重建索引 try { DataIndexerProduct SearchIndexer = new DataIndexerProduct(Config.Searches["product"]); SearchIndexer.DeleteSingleIndex(product.ProductId); 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 { } }
/// <summary> /// ����ʵ������� /// </summary> public ProductParaModel ReaderBind(IDataReader dataReader) { ProductParaModel model=new ProductParaModel(); object ojb; ojb = dataReader["ProductId"]; if(ojb != null && ojb != DBNull.Value) { model.ProductId=(int)ojb; } ojb = dataReader["ParaId"]; if(ojb != null && ojb != DBNull.Value) { model.ParaId=(int)ojb; } model.ParaValue=dataReader["ParaValue"].ToString(); return model; }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ProductParaModel model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ProductParaModel model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Add(ProductParaModel model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(ProductParaModel model) { dal.Update(model); }
/// <summary> /// ��������б� /// </summary> public List<ProductParaModel> GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); List<ProductParaModel> modelList = new List<ProductParaModel>(); int rowsCount = ds.Tables[0].Rows.Count; if (rowsCount > 0) { ProductParaModel model; for (int n = 0; n < rowsCount; n++) { model = new ProductParaModel(); if(ds.Tables[0].Rows[n]["ProductId"].ToString()!="") { model.ProductId=int.Parse(ds.Tables[0].Rows[n]["ProductId"].ToString()); } if(ds.Tables[0].Rows[n]["ParaId"].ToString()!="") { model.ParaId=int.Parse(ds.Tables[0].Rows[n]["ParaId"].ToString()); } model.ParaValue=ds.Tables[0].Rows[n]["ParaValue"].ToString(); modelList.Add(model); } } return modelList; }