/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.ProductModel model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_pdProduct_Update"); db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId); db.AddInParameter(dbCommand, "ProductName", DbType.AnsiString, model.ProductName); db.AddInParameter(dbCommand, "ProductCode", DbType.AnsiString, model.ProductCode); db.AddInParameter(dbCommand, "CatePath", DbType.AnsiString, model.CatePath); db.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId); db.AddInParameter(dbCommand, "TradePrice", DbType.Decimal, model.TradePrice); db.AddInParameter(dbCommand, "MerchantPrice", DbType.Decimal, model.MerchantPrice); db.AddInParameter(dbCommand, "ReducePrice", DbType.Decimal, model.ReducePrice); db.AddInParameter(dbCommand, "Stock", DbType.Int32, model.Stock); db.AddInParameter(dbCommand, "SmallImage", DbType.AnsiString, model.SmallImage); db.AddInParameter(dbCommand, "MediumImage", DbType.AnsiString, model.MediumImage); db.AddInParameter(dbCommand, "LargeImage", DbType.AnsiString, model.LargeImage); db.AddInParameter(dbCommand, "Keywords", DbType.AnsiString, model.Keywords); db.AddInParameter(dbCommand, "Brief", DbType.AnsiString, model.Brief); db.AddInParameter(dbCommand, "PageView", DbType.Int32, model.PageView); db.AddInParameter(dbCommand, "InsertTime", DbType.DateTime, model.InsertTime); db.AddInParameter(dbCommand, "ChangeTime", DbType.DateTime, model.ChangeTime); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "SortValue", DbType.Int32, model.SortValue); db.AddInParameter(dbCommand, "Score", DbType.Int32, model.Score); db.ExecuteNonQuery(dbCommand); }
private void ShowInfo(int ProductId) { NoName.NetShop.BLL.ProductModelBll bll = new NoName.NetShop.BLL.ProductModelBll(); NoName.NetShop.Model.ProductModel model = bll.GetModel(ProductId); this.lblProductId.Text = model.ProductId.ToString(); this.txtProductName.Text = model.ProductName; this.txtProductCode.Text = model.ProductCode; this.txtCatePath.Text = model.CatePath; this.txtCateId.Text = model.CateId.ToString(); this.txtTradePrice.Text = model.TradePrice.ToString(); this.txtMerchantPrice.Text = model.MerchantPrice.ToString(); this.txtReducePrice.Text = model.ReducePrice.ToString(); this.txtStock.Text = model.Stock.ToString(); this.txtSmallImage.Text = model.SmallImage; this.txtMediumImage.Text = model.MediumImage; this.txtLargeImage.Text = model.LargeImage; this.txtKeywords.Text = model.Keywords; this.txtBrief.Text = model.Brief; this.txtPageView.Text = model.PageView.ToString(); this.txtInsertTime.Text = model.InsertTime.ToString(); this.txtChangeTime.Text = model.ChangeTime.ToString(); this.txtStatus.Text = model.Status.ToString(); this.txtSortValue.Text = model.SortValue.ToString(); this.txtScore.Text = model.Score.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Model.ProductModel GetModel(int ProductId) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_pdProduct_GetModel"); db.AddInParameter(dbCommand, "ProductId", DbType.Int32, ProductId); NoName.NetShop.Model.ProductModel model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr=""; if(this.txtProductName.Text =="") { strErr+="ProductName����Ϊ�գ�\\n"; } if(this.txtProductCode.Text =="") { strErr+="ProductCode����Ϊ�գ�\\n"; } if(this.txtCatePath.Text =="") { strErr+="CatePath����Ϊ�գ�\\n"; } if(!PageValidate.IsNumber(txtCateId.Text)) { strErr+="CateId�������֣�\\n"; } if(!PageValidate.IsDecimal(txtTradePrice.Text)) { strErr+="TradePrice�������֣�\\n"; } if(!PageValidate.IsDecimal(txtMerchantPrice.Text)) { strErr+="MerchantPrice�������֣�\\n"; } if(!PageValidate.IsDecimal(txtReducePrice.Text)) { strErr+="ReducePrice�������֣�\\n"; } if(!PageValidate.IsNumber(txtStock.Text)) { strErr+="Stock�������֣�\\n"; } if(this.txtSmallImage.Text =="") { strErr+="SmallImage����Ϊ�գ�\\n"; } if(this.txtMediumImage.Text =="") { strErr+="MediumImage����Ϊ�գ�\\n"; } if(this.txtLargeImage.Text =="") { strErr+="LargeImage����Ϊ�գ�\\n"; } if(this.txtKeywords.Text =="") { strErr+="Keywords����Ϊ�գ�\\n"; } if(this.txtBrief.Text =="") { strErr+="Brief����Ϊ�գ�\\n"; } if(!PageValidate.IsNumber(txtPageView.Text)) { strErr+="PageView�������֣�\\n"; } if(!PageValidate.IsDateTime(txtInsertTime.Text)) { strErr+="InsertTime����ʱ���ʽ��\\n"; } if(!PageValidate.IsDateTime(txtChangeTime.Text)) { strErr+="ChangeTime����ʱ���ʽ��\\n"; } if(!PageValidate.IsNumber(txtStatus.Text)) { strErr+="Status�������֣�\\n"; } if(!PageValidate.IsNumber(txtSortValue.Text)) { strErr+="SortValue�������֣�\\n"; } if(!PageValidate.IsNumber(txtScore.Text)) { strErr+="Score�������֣�\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string ProductName=this.txtProductName.Text; string ProductCode=this.txtProductCode.Text; string CatePath=this.txtCatePath.Text; int CateId=int.Parse(this.txtCateId.Text); decimal TradePrice=decimal.Parse(this.txtTradePrice.Text); decimal MerchantPrice=decimal.Parse(this.txtMerchantPrice.Text); decimal ReducePrice=decimal.Parse(this.txtReducePrice.Text); int Stock=int.Parse(this.txtStock.Text); string SmallImage=this.txtSmallImage.Text; string MediumImage=this.txtMediumImage.Text; string LargeImage=this.txtLargeImage.Text; string Keywords=this.txtKeywords.Text; string Brief=this.txtBrief.Text; int PageView=int.Parse(this.txtPageView.Text); DateTime InsertTime=DateTime.Parse(this.txtInsertTime.Text); DateTime ChangeTime=DateTime.Parse(this.txtChangeTime.Text); int Status=int.Parse(this.txtStatus.Text); int SortValue=int.Parse(this.txtSortValue.Text); int Score=int.Parse(this.txtScore.Text); NoName.NetShop.Model.ProductModel model=new NoName.NetShop.Model.ProductModel(); model.ProductName=ProductName; model.ProductCode=ProductCode; model.CatePath=CatePath; model.CateId=CateId; model.TradePrice=TradePrice; model.MerchantPrice=MerchantPrice; model.ReducePrice=ReducePrice; model.Stock=Stock; model.SmallImage=SmallImage; model.MediumImage=MediumImage; model.LargeImage=LargeImage; model.Keywords=Keywords; model.Brief=Brief; model.PageView=PageView; model.InsertTime=InsertTime; model.ChangeTime=ChangeTime; model.Status=Status; model.SortValue=SortValue; model.Score=Score; NoName.NetShop.BLL.ProductModelBll bll=new NoName.NetShop.BLL.ProductModelBll(); bll.Update(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Model.ProductModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.ProductModel model = new NoName.NetShop.Model.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 = (int)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; } return(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtProductName.Text == "") { strErr += "ProductName不能为空!\\n"; } if (this.txtProductCode.Text == "") { strErr += "ProductCode不能为空!\\n"; } if (this.txtCatePath.Text == "") { strErr += "CatePath不能为空!\\n"; } if (!PageValidate.IsNumber(txtCateId.Text)) { strErr += "CateId不是数字!\\n"; } if (!PageValidate.IsDecimal(txtTradePrice.Text)) { strErr += "TradePrice不是数字!\\n"; } if (!PageValidate.IsDecimal(txtMerchantPrice.Text)) { strErr += "MerchantPrice不是数字!\\n"; } if (!PageValidate.IsDecimal(txtReducePrice.Text)) { strErr += "ReducePrice不是数字!\\n"; } if (!PageValidate.IsNumber(txtStock.Text)) { strErr += "Stock不是数字!\\n"; } if (this.txtSmallImage.Text == "") { strErr += "SmallImage不能为空!\\n"; } if (this.txtMediumImage.Text == "") { strErr += "MediumImage不能为空!\\n"; } if (this.txtLargeImage.Text == "") { strErr += "LargeImage不能为空!\\n"; } if (this.txtKeywords.Text == "") { strErr += "Keywords不能为空!\\n"; } if (this.txtBrief.Text == "") { strErr += "Brief不能为空!\\n"; } if (!PageValidate.IsNumber(txtPageView.Text)) { strErr += "PageView不是数字!\\n"; } if (!PageValidate.IsDateTime(txtInsertTime.Text)) { strErr += "InsertTime不是时间格式!\\n"; } if (!PageValidate.IsDateTime(txtChangeTime.Text)) { strErr += "ChangeTime不是时间格式!\\n"; } if (!PageValidate.IsNumber(txtStatus.Text)) { strErr += "Status不是数字!\\n"; } if (!PageValidate.IsNumber(txtSortValue.Text)) { strErr += "SortValue不是数字!\\n"; } if (!PageValidate.IsNumber(txtScore.Text)) { strErr += "Score不是数字!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string ProductName = this.txtProductName.Text; string ProductCode = this.txtProductCode.Text; string CatePath = this.txtCatePath.Text; int CateId = int.Parse(this.txtCateId.Text); decimal TradePrice = decimal.Parse(this.txtTradePrice.Text); decimal MerchantPrice = decimal.Parse(this.txtMerchantPrice.Text); decimal ReducePrice = decimal.Parse(this.txtReducePrice.Text); int Stock = int.Parse(this.txtStock.Text); string SmallImage = this.txtSmallImage.Text; string MediumImage = this.txtMediumImage.Text; string LargeImage = this.txtLargeImage.Text; string Keywords = this.txtKeywords.Text; string Brief = this.txtBrief.Text; int PageView = int.Parse(this.txtPageView.Text); DateTime InsertTime = DateTime.Parse(this.txtInsertTime.Text); DateTime ChangeTime = DateTime.Parse(this.txtChangeTime.Text); int Status = int.Parse(this.txtStatus.Text); int SortValue = int.Parse(this.txtSortValue.Text); int Score = int.Parse(this.txtScore.Text); NoName.NetShop.Model.ProductModel model = new NoName.NetShop.Model.ProductModel(); model.ProductName = ProductName; model.ProductCode = ProductCode; model.CatePath = CatePath; model.CateId = CateId; model.TradePrice = TradePrice; model.MerchantPrice = MerchantPrice; model.ReducePrice = ReducePrice; model.Stock = Stock; model.SmallImage = SmallImage; model.MediumImage = MediumImage; model.LargeImage = LargeImage; model.Keywords = Keywords; model.Brief = Brief; model.PageView = PageView; model.InsertTime = InsertTime; model.ChangeTime = ChangeTime; model.Status = Status; model.SortValue = SortValue; model.Score = Score; NoName.NetShop.BLL.ProductModelBll bll = new NoName.NetShop.BLL.ProductModelBll(); bll.Update(model); }