protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtOrderId.Text)) { strErr += "OrderId不是数字!\\n"; } if (!PageValidate.IsNumber(txtProductId.Text)) { strErr += "ProductId不是数字!\\n"; } if (!PageValidate.IsDecimal(txtProductFee.Text)) { strErr += "ProductFee不是数字!\\n"; } if (!PageValidate.IsNumber(txtQuantity.Text)) { strErr += "Quantity不是数字!\\n"; } if (!PageValidate.IsDecimal(txtDerateFee.Text)) { strErr += "DerateFee不是数字!\\n"; } if (!PageValidate.IsDecimal(txtMerchantPrice.Text)) { strErr += "MerchantPrice不是数字!\\n"; } if (!PageValidate.IsDecimal(txtTotalFee.Text)) { strErr += "TotalFee不是数字!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int OrderId = int.Parse(this.txtOrderId.Text); int ProductId = int.Parse(this.txtProductId.Text); decimal ProductFee = decimal.Parse(this.txtProductFee.Text); int Quantity = int.Parse(this.txtQuantity.Text); decimal DerateFee = decimal.Parse(this.txtDerateFee.Text); decimal MerchantPrice = decimal.Parse(this.txtMerchantPrice.Text); decimal TotalFee = decimal.Parse(this.txtTotalFee.Text); NoName.NetShop.Model.OrderItemModel model = new NoName.NetShop.Model.OrderItemModel(); model.OrderId = OrderId; model.ProductId = ProductId; model.ProductFee = ProductFee; model.Quantity = Quantity; model.DerateFee = DerateFee; model.MerchantPrice = MerchantPrice; model.TotalFee = TotalFee; NoName.NetShop.BLL.OrderItemModelBll bll = new NoName.NetShop.BLL.OrderItemModelBll(); bll.Update(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtOrderId.Text)) { strErr+="OrderId�������֣�\\n"; } if(!PageValidate.IsNumber(txtProductId.Text)) { strErr+="ProductId�������֣�\\n"; } if(!PageValidate.IsDecimal(txtProductFee.Text)) { strErr+="ProductFee�������֣�\\n"; } if(!PageValidate.IsNumber(txtQuantity.Text)) { strErr+="Quantity�������֣�\\n"; } if(!PageValidate.IsDecimal(txtDerateFee.Text)) { strErr+="DerateFee�������֣�\\n"; } if(!PageValidate.IsDecimal(txtMerchantPrice.Text)) { strErr+="MerchantPrice�������֣�\\n"; } if(!PageValidate.IsDecimal(txtTotalFee.Text)) { strErr+="TotalFee�������֣�\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int OrderId=int.Parse(this.txtOrderId.Text); int ProductId=int.Parse(this.txtProductId.Text); decimal ProductFee=decimal.Parse(this.txtProductFee.Text); int Quantity=int.Parse(this.txtQuantity.Text); decimal DerateFee=decimal.Parse(this.txtDerateFee.Text); decimal MerchantPrice=decimal.Parse(this.txtMerchantPrice.Text); decimal TotalFee=decimal.Parse(this.txtTotalFee.Text); NoName.NetShop.Model.OrderItemModel model=new NoName.NetShop.Model.OrderItemModel(); model.OrderId=OrderId; model.ProductId=ProductId; model.ProductFee=ProductFee; model.Quantity=Quantity; model.DerateFee=DerateFee; model.MerchantPrice=MerchantPrice; model.TotalFee=TotalFee; NoName.NetShop.BLL.OrderItemModelBll bll=new NoName.NetShop.BLL.OrderItemModelBll(); bll.Update(model); }
private void ShowInfo(int OrderItem) { NoName.NetShop.BLL.OrderItemModelBll bll = new NoName.NetShop.BLL.OrderItemModelBll(); NoName.NetShop.Model.OrderItemModel model = bll.GetModel(OrderItem); this.lblOrderId.Text = model.OrderId.ToString(); this.lblProductId.Text = model.ProductId.ToString(); this.lblProductFee.Text = model.ProductFee.ToString(); this.lblQuantity.Text = model.Quantity.ToString(); this.lblDerateFee.Text = model.DerateFee.ToString(); this.lblMerchantPrice.Text = model.MerchantPrice.ToString(); this.lblTotalFee.Text = model.TotalFee.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.OrderItemModel model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_spOrderItem_Update"); db.AddInParameter(dbCommand, "OrderId", DbType.Int32, model.OrderId); db.AddInParameter(dbCommand, "OrderItem", DbType.Int32, model.OrderItem); db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId); db.AddInParameter(dbCommand, "ProductFee", DbType.Decimal, model.ProductFee); db.AddInParameter(dbCommand, "Quantity", DbType.Int32, model.Quantity); db.AddInParameter(dbCommand, "DerateFee", DbType.Decimal, model.DerateFee); db.AddInParameter(dbCommand, "MerchantPrice", DbType.Decimal, model.MerchantPrice); db.AddInParameter(dbCommand, "TotalFee", DbType.Decimal, model.TotalFee); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Model.OrderItemModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.OrderItemModel model = new NoName.NetShop.Model.OrderItemModel(); object ojb; ojb = dataReader["OrderId"]; if (ojb != null && ojb != DBNull.Value) { model.OrderId = (int)ojb; } ojb = dataReader["OrderItem"]; if (ojb != null && ojb != DBNull.Value) { model.OrderItem = (int)ojb; } ojb = dataReader["ProductId"]; if (ojb != null && ojb != DBNull.Value) { model.ProductId = (int)ojb; } ojb = dataReader["ProductFee"]; if (ojb != null && ojb != DBNull.Value) { model.ProductFee = (decimal)ojb; } ojb = dataReader["Quantity"]; if (ojb != null && ojb != DBNull.Value) { model.Quantity = (int)ojb; } ojb = dataReader["DerateFee"]; if (ojb != null && ojb != DBNull.Value) { model.DerateFee = (decimal)ojb; } ojb = dataReader["MerchantPrice"]; if (ojb != null && ojb != DBNull.Value) { model.MerchantPrice = (decimal)ojb; } ojb = dataReader["TotalFee"]; if (ojb != null && ojb != DBNull.Value) { model.TotalFee = (decimal)ojb; } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Model.OrderItemModel GetModel(int OrderItem) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_spOrderItem_GetModel"); db.AddInParameter(dbCommand, "OrderItem", DbType.Int32, OrderItem); NoName.NetShop.Model.OrderItemModel model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// ����ʵ������� /// </summary> public NoName.NetShop.Model.OrderItemModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.OrderItemModel model=new NoName.NetShop.Model.OrderItemModel(); object ojb; ojb = dataReader["OrderId"]; if(ojb != null && ojb != DBNull.Value) { model.OrderId=(int)ojb; } ojb = dataReader["OrderItem"]; if(ojb != null && ojb != DBNull.Value) { model.OrderItem=(int)ojb; } ojb = dataReader["ProductId"]; if(ojb != null && ojb != DBNull.Value) { model.ProductId=(int)ojb; } ojb = dataReader["ProductFee"]; if(ojb != null && ojb != DBNull.Value) { model.ProductFee=(decimal)ojb; } ojb = dataReader["Quantity"]; if(ojb != null && ojb != DBNull.Value) { model.Quantity=(int)ojb; } ojb = dataReader["DerateFee"]; if(ojb != null && ojb != DBNull.Value) { model.DerateFee=(decimal)ojb; } ojb = dataReader["MerchantPrice"]; if(ojb != null && ojb != DBNull.Value) { model.MerchantPrice=(decimal)ojb; } ojb = dataReader["TotalFee"]; if(ojb != null && ojb != DBNull.Value) { model.TotalFee=(decimal)ojb; } return model; }