private void ShowInfo(int AuctionId) { NoName.NetShop.BLL.ActionProductModelBll bll = new NoName.NetShop.BLL.ActionProductModelBll(); NoName.NetShop.Model.ActionProductModel model = bll.GetModel(AuctionId); this.lblProductName.Text = model.ProductName; this.lblSmallIamge.Text = model.SmallIamge; this.lblMediumImage.Text = model.MediumImage; this.lblOutLinkUrl.Text = model.OutLinkUrl; this.lblStartPrice.Text = model.StartPrice.ToString(); this.lblAddPrices.Text = model.AddPrices.ToString(); this.lblCurPrice.Text = model.CurPrice.ToString(); this.lblBrief.Text = model.Brief; this.lblStartTime.Text = model.StartTime.ToString(); this.lblEndTime.Text = model.EndTime.ToString(); this.lblStatus.Text = model.Status.ToString(); }
/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Model.ActionProductModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.ActionProductModel model = new NoName.NetShop.Model.ActionProductModel(); object ojb; ojb = dataReader["AuctionId"]; if (ojb != null && ojb != DBNull.Value) { model.AuctionId = (int)ojb; } model.ProductName = dataReader["ProductName"].ToString(); model.SmallIamge = dataReader["SmallIamge"].ToString(); model.MediumImage = dataReader["MediumImage"].ToString(); model.OutLinkUrl = dataReader["OutLinkUrl"].ToString(); ojb = dataReader["StartPrice"]; if (ojb != null && ojb != DBNull.Value) { model.StartPrice = (decimal)ojb; } ojb = dataReader["AddPrices"]; if (ojb != null && ojb != DBNull.Value) { model.AddPrices = (decimal)ojb; } ojb = dataReader["CurPrice"]; if (ojb != null && ojb != DBNull.Value) { model.CurPrice = (decimal)ojb; } model.Brief = dataReader["Brief"].ToString(); ojb = dataReader["StartTime"]; if (ojb != null && ojb != DBNull.Value) { model.StartTime = (DateTime)ojb; } ojb = dataReader["EndTime"]; if (ojb != null && ojb != DBNull.Value) { model.EndTime = (DateTime)ojb; } ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = (int)ojb; } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Model.ActionProductModel GetModel(int AuctionId) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_auActionProduct_GetModel"); db.AddInParameter(dbCommand, "AuctionId", DbType.Int32, AuctionId); NoName.NetShop.Model.ActionProductModel model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.ActionProductModel model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_auActionProduct_Update"); db.AddInParameter(dbCommand, "AuctionId", DbType.Int32, model.AuctionId); db.AddInParameter(dbCommand, "ProductName", DbType.AnsiString, model.ProductName); db.AddInParameter(dbCommand, "SmallIamge", DbType.AnsiString, model.SmallIamge); db.AddInParameter(dbCommand, "MediumImage", DbType.AnsiString, model.MediumImage); db.AddInParameter(dbCommand, "OutLinkUrl", DbType.AnsiString, model.OutLinkUrl); db.AddInParameter(dbCommand, "StartPrice", DbType.Decimal, model.StartPrice); db.AddInParameter(dbCommand, "AddPrices", DbType.Decimal, model.AddPrices); db.AddInParameter(dbCommand, "CurPrice", DbType.Decimal, model.CurPrice); db.AddInParameter(dbCommand, "Brief", DbType.AnsiString, model.Brief); db.AddInParameter(dbCommand, "StartTime", DbType.DateTime, model.StartTime); db.AddInParameter(dbCommand, "EndTime", DbType.DateTime, model.EndTime); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.ExecuteNonQuery(dbCommand); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtProductName.Text == "") { strErr += "ProductName不能为空!\\n"; } if (this.txtSmallIamge.Text == "") { strErr += "SmallIamge不能为空!\\n"; } if (this.txtMediumImage.Text == "") { strErr += "MediumImage不能为空!\\n"; } if (this.txtOutLinkUrl.Text == "") { strErr += "OutLinkUrl不能为空!\\n"; } if (!PageValidate.IsDecimal(txtStartPrice.Text)) { strErr += "StartPrice不是数字!\\n"; } if (!PageValidate.IsDecimal(txtAddPrices.Text)) { strErr += "AddPrices不是数字!\\n"; } if (!PageValidate.IsDecimal(txtCurPrice.Text)) { strErr += "CurPrice不是数字!\\n"; } if (this.txtBrief.Text == "") { strErr += "Brief不能为空!\\n"; } if (!PageValidate.IsDateTime(txtStartTime.Text)) { strErr += "StartTime不是时间格式!\\n"; } if (!PageValidate.IsDateTime(txtEndTime.Text)) { strErr += "EndTime不是时间格式!\\n"; } if (!PageValidate.IsNumber(txtStatus.Text)) { strErr += "Status不是数字!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string ProductName = this.txtProductName.Text; string SmallIamge = this.txtSmallIamge.Text; string MediumImage = this.txtMediumImage.Text; string OutLinkUrl = this.txtOutLinkUrl.Text; decimal StartPrice = decimal.Parse(this.txtStartPrice.Text); decimal AddPrices = decimal.Parse(this.txtAddPrices.Text); decimal CurPrice = decimal.Parse(this.txtCurPrice.Text); string Brief = this.txtBrief.Text; DateTime StartTime = DateTime.Parse(this.txtStartTime.Text); DateTime EndTime = DateTime.Parse(this.txtEndTime.Text); int Status = int.Parse(this.txtStatus.Text); NoName.NetShop.Model.ActionProductModel model = new NoName.NetShop.Model.ActionProductModel(); model.ProductName = ProductName; model.SmallIamge = SmallIamge; model.MediumImage = MediumImage; model.OutLinkUrl = OutLinkUrl; model.StartPrice = StartPrice; model.AddPrices = AddPrices; model.CurPrice = CurPrice; model.Brief = Brief; model.StartTime = StartTime; model.EndTime = EndTime; model.Status = Status; NoName.NetShop.BLL.ActionProductModelBll bll = new NoName.NetShop.BLL.ActionProductModelBll(); bll.Update(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr=""; if(this.txtProductName.Text =="") { strErr+="ProductName����Ϊ�գ�\\n"; } if(this.txtSmallIamge.Text =="") { strErr+="SmallIamge����Ϊ�գ�\\n"; } if(this.txtMediumImage.Text =="") { strErr+="MediumImage����Ϊ�գ�\\n"; } if(this.txtOutLinkUrl.Text =="") { strErr+="OutLinkUrl����Ϊ�գ�\\n"; } if(!PageValidate.IsDecimal(txtStartPrice.Text)) { strErr+="StartPrice�������֣�\\n"; } if(!PageValidate.IsDecimal(txtAddPrices.Text)) { strErr+="AddPrices�������֣�\\n"; } if(!PageValidate.IsDecimal(txtCurPrice.Text)) { strErr+="CurPrice�������֣�\\n"; } if(this.txtBrief.Text =="") { strErr+="Brief����Ϊ�գ�\\n"; } if(!PageValidate.IsDateTime(txtStartTime.Text)) { strErr+="StartTime����ʱ���ʽ��\\n"; } if(!PageValidate.IsDateTime(txtEndTime.Text)) { strErr+="EndTime����ʱ���ʽ��\\n"; } if(!PageValidate.IsNumber(txtStatus.Text)) { strErr+="Status�������֣�\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string ProductName=this.txtProductName.Text; string SmallIamge=this.txtSmallIamge.Text; string MediumImage=this.txtMediumImage.Text; string OutLinkUrl=this.txtOutLinkUrl.Text; decimal StartPrice=decimal.Parse(this.txtStartPrice.Text); decimal AddPrices=decimal.Parse(this.txtAddPrices.Text); decimal CurPrice=decimal.Parse(this.txtCurPrice.Text); string Brief=this.txtBrief.Text; DateTime StartTime=DateTime.Parse(this.txtStartTime.Text); DateTime EndTime=DateTime.Parse(this.txtEndTime.Text); int Status=int.Parse(this.txtStatus.Text); NoName.NetShop.Model.ActionProductModel model=new NoName.NetShop.Model.ActionProductModel(); model.ProductName=ProductName; model.SmallIamge=SmallIamge; model.MediumImage=MediumImage; model.OutLinkUrl=OutLinkUrl; model.StartPrice=StartPrice; model.AddPrices=AddPrices; model.CurPrice=CurPrice; model.Brief=Brief; model.StartTime=StartTime; model.EndTime=EndTime; model.Status=Status; NoName.NetShop.BLL.ActionProductModelBll bll=new NoName.NetShop.BLL.ActionProductModelBll(); bll.Add(model); }
/// <summary> /// ����ʵ������� /// </summary> public NoName.NetShop.Model.ActionProductModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.ActionProductModel model=new NoName.NetShop.Model.ActionProductModel(); object ojb; ojb = dataReader["AuctionId"]; if(ojb != null && ojb != DBNull.Value) { model.AuctionId=(int)ojb; } model.ProductName=dataReader["ProductName"].ToString(); model.SmallIamge=dataReader["SmallIamge"].ToString(); model.MediumImage=dataReader["MediumImage"].ToString(); model.OutLinkUrl=dataReader["OutLinkUrl"].ToString(); ojb = dataReader["StartPrice"]; if(ojb != null && ojb != DBNull.Value) { model.StartPrice=(decimal)ojb; } ojb = dataReader["AddPrices"]; if(ojb != null && ojb != DBNull.Value) { model.AddPrices=(decimal)ojb; } ojb = dataReader["CurPrice"]; if(ojb != null && ojb != DBNull.Value) { model.CurPrice=(decimal)ojb; } model.Brief=dataReader["Brief"].ToString(); ojb = dataReader["StartTime"]; if(ojb != null && ojb != DBNull.Value) { model.StartTime=(DateTime)ojb; } ojb = dataReader["EndTime"]; if(ojb != null && ojb != DBNull.Value) { model.EndTime=(DateTime)ojb; } ojb = dataReader["Status"]; if(ojb != null && ojb != DBNull.Value) { model.Status=(int)ojb; } return model; }