private void ShowInfo(int OrderId)
{
NoName.NetShop.BLL.OrderModelBll bll = new NoName.NetShop.BLL.OrderModelBll();
NoName.NetShop.Model.OrderModel model = bll.GetModel(OrderId);
this.txtUserId.Text = model.UserId.ToString();
this.lblOrderId.Text = model.OrderId.ToString();
this.txtOrderStatus.Text = model.OrderStatus.ToString();
this.txtPayMethod.Text = model.PayMethod.ToString();
this.txtShipMethod.Text = model.ShipMethod.ToString();
this.txtPayStatus.Text = model.PayStatus.ToString();
this.txtPaysum.Text = model.Paysum.ToString();
this.txtShipFee.Text = model.ShipFee.ToString();
this.txtProductFee.Text = model.ProductFee.ToString();
this.txtDerateFee.Text = model.DerateFee.ToString();
this.txtAddressId.Text = model.AddressId.ToString();
this.txtRecieverName.Text = model.RecieverName;
this.txtRecieverEmail.Text = model.RecieverEmail;
this.txtRecieverPhone.Text = model.RecieverPhone;
this.txtPostalcode.Text = model.Postalcode;
this.txtRecieverCity.Text = model.RecieverCity;
this.txtRecieverProvince.Text = model.RecieverProvince;
this.txtAddressDetial.Text = model.AddressDetial;
this.txtChangeTime.Text = model.ChangeTime.ToString();
this.txtPayTime.Text = model.PayTime.ToString();
this.txtCreateTime.Text = model.CreateTime.ToString();
this.txtOrderType.Text = model.OrderType.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(NoName.NetShop.Model.OrderModel model)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_spOrder_Update");
db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId);
db.AddInParameter(dbCommand, "OrderId", DbType.Int32, model.OrderId);
db.AddInParameter(dbCommand, "OrderStatus", DbType.Byte, model.OrderStatus);
db.AddInParameter(dbCommand, "PayMethod", DbType.Byte, model.PayMethod);
db.AddInParameter(dbCommand, "ShipMethod", DbType.Byte, model.ShipMethod);
db.AddInParameter(dbCommand, "PayStatus", DbType.Byte, model.PayStatus);
db.AddInParameter(dbCommand, "Paysum", DbType.Decimal, model.Paysum);
db.AddInParameter(dbCommand, "ShipFee", DbType.Decimal, model.ShipFee);
db.AddInParameter(dbCommand, "ProductFee", DbType.Decimal, model.ProductFee);
db.AddInParameter(dbCommand, "DerateFee", DbType.Decimal, model.DerateFee);
db.AddInParameter(dbCommand, "AddressId", DbType.Int32, model.AddressId);
db.AddInParameter(dbCommand, "RecieverName", DbType.AnsiString, model.RecieverName);
db.AddInParameter(dbCommand, "RecieverEmail", DbType.AnsiString, model.RecieverEmail);
db.AddInParameter(dbCommand, "RecieverPhone", DbType.AnsiString, model.RecieverPhone);
db.AddInParameter(dbCommand, "Postalcode", DbType.AnsiString, model.Postalcode);
db.AddInParameter(dbCommand, "RecieverCity", DbType.AnsiString, model.RecieverCity);
db.AddInParameter(dbCommand, "RecieverProvince", DbType.AnsiString, model.RecieverProvince);
db.AddInParameter(dbCommand, "AddressDetial", DbType.AnsiString, model.AddressDetial);
db.AddInParameter(dbCommand, "ChangeTime", DbType.DateTime, model.ChangeTime);
db.AddInParameter(dbCommand, "PayTime", DbType.DateTime, model.PayTime);
db.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, model.CreateTime);
db.AddInParameter(dbCommand, "OrderType", DbType.Byte, model.OrderType);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Model.OrderModel GetModel(int OrderId)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_spOrder_GetModel");
db.AddInParameter(dbCommand, "OrderId", DbType.Int32, OrderId);
NoName.NetShop.Model.OrderModel 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 (!PageValidate.IsNumber(txtUserId.Text))
{
strErr += "UserId不是数字！\\n";
}
if (!PageValidate.IsNumber(txtOrderStatus.Text))
{
strErr += "OrderStatus不是数字！\\n";
}
if (!PageValidate.IsNumber(txtPayMethod.Text))
{
strErr += "PayMethod不是数字！\\n";
}
if (!PageValidate.IsNumber(txtShipMethod.Text))
{
strErr += "ShipMethod不是数字！\\n";
}
if (!PageValidate.IsNumber(txtPayStatus.Text))
{
strErr += "PayStatus不是数字！\\n";
}
if (!PageValidate.IsDecimal(txtPaysum.Text))
{
strErr += "Paysum不是数字！\\n";
}
if (!PageValidate.IsDecimal(txtShipFee.Text))
{
strErr += "ShipFee不是数字！\\n";
}
if (!PageValidate.IsDecimal(txtProductFee.Text))
{
strErr += "ProductFee不是数字！\\n";
}
if (!PageValidate.IsDecimal(txtDerateFee.Text))
{
strErr += "DerateFee不是数字！\\n";
}
if (!PageValidate.IsNumber(txtAddressId.Text))
{
strErr += "AddressId不是数字！\\n";
}
if (this.txtRecieverName.Text == "")
{
strErr += "RecieverName不能为空！\\n";
}
if (this.txtRecieverEmail.Text == "")
{
strErr += "RecieverEmail不能为空！\\n";
}
if (this.txtRecieverPhone.Text == "")
{
strErr += "RecieverPhone不能为空！\\n";
}
if (this.txtPostalcode.Text == "")
{
strErr += "Postalcode不能为空！\\n";
}
if (this.txtRecieverCity.Text == "")
{
strErr += "RecieverCity不能为空！\\n";
}
if (this.txtRecieverProvince.Text == "")
{
strErr += "RecieverProvince不能为空！\\n";
}
if (this.txtAddressDetial.Text == "")
{
strErr += "AddressDetial不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtChangeTime.Text))
{
strErr += "ChangeTime不是时间格式！\\n";
}
if (!PageValidate.IsDateTime(txtPayTime.Text))
{
strErr += "PayTime不是时间格式！\\n";
}
if (!PageValidate.IsDateTime(txtCreateTime.Text))
{
strErr += "CreateTime不是时间格式！\\n";
}
if (!PageValidate.IsNumber(txtOrderType.Text))
{
strErr += "OrderType不是数字！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int UserId = int.Parse(this.txtUserId.Text);
int OrderStatus = int.Parse(this.txtOrderStatus.Text);
int PayMethod = int.Parse(this.txtPayMethod.Text);
int ShipMethod = int.Parse(this.txtShipMethod.Text);
int PayStatus = int.Parse(this.txtPayStatus.Text);
decimal Paysum = decimal.Parse(this.txtPaysum.Text);
decimal ShipFee = decimal.Parse(this.txtShipFee.Text);
decimal ProductFee = decimal.Parse(this.txtProductFee.Text);
decimal DerateFee = decimal.Parse(this.txtDerateFee.Text);
int AddressId = int.Parse(this.txtAddressId.Text);
string RecieverName = this.txtRecieverName.Text;
string RecieverEmail = this.txtRecieverEmail.Text;
string RecieverPhone = this.txtRecieverPhone.Text;
string Postalcode = this.txtPostalcode.Text;
string RecieverCity = this.txtRecieverCity.Text;
string RecieverProvince = this.txtRecieverProvince.Text;
string AddressDetial = this.txtAddressDetial.Text;
DateTime ChangeTime = DateTime.Parse(this.txtChangeTime.Text);
DateTime PayTime = DateTime.Parse(this.txtPayTime.Text);
DateTime CreateTime = DateTime.Parse(this.txtCreateTime.Text);
int OrderType = int.Parse(this.txtOrderType.Text);
NoName.NetShop.Model.OrderModel model = new NoName.NetShop.Model.OrderModel();
model.UserId = UserId;
model.OrderStatus = OrderStatus;
model.PayMethod = PayMethod;
model.ShipMethod = ShipMethod;
model.PayStatus = PayStatus;
model.Paysum = Paysum;
model.ShipFee = ShipFee;
model.ProductFee = ProductFee;
model.DerateFee = DerateFee;
model.AddressId = AddressId;
model.RecieverName = RecieverName;
model.RecieverEmail = RecieverEmail;
model.RecieverPhone = RecieverPhone;
model.Postalcode = Postalcode;
model.RecieverCity = RecieverCity;
model.RecieverProvince = RecieverProvince;
model.AddressDetial = AddressDetial;
model.ChangeTime = ChangeTime;
model.PayTime = PayTime;
model.CreateTime = CreateTime;
model.OrderType = OrderType;
NoName.NetShop.BLL.OrderModelBll bll = new NoName.NetShop.BLL.OrderModelBll();
bll.Update(model);
}
/// <summary>
/// ����ʵ�������
/// </summary>
public NoName.NetShop.Model.OrderModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.OrderModel model=new NoName.NetShop.Model.OrderModel();
object ojb;
ojb = dataReader["UserId"];
if(ojb != null && ojb != DBNull.Value)
{
model.UserId=(int)ojb;
}
ojb = dataReader["OrderId"];
if(ojb != null && ojb != DBNull.Value)
{
model.OrderId=(int)ojb;
}
ojb = dataReader["OrderStatus"];
if(ojb != null && ojb != DBNull.Value)
{
model.OrderStatus=(int)ojb;
}
ojb = dataReader["PayMethod"];
if(ojb != null && ojb != DBNull.Value)
{
model.PayMethod=(int)ojb;
}
ojb = dataReader["ShipMethod"];
if(ojb != null && ojb != DBNull.Value)
{
model.ShipMethod=(int)ojb;
}
ojb = dataReader["PayStatus"];
if(ojb != null && ojb != DBNull.Value)
{
model.PayStatus=(int)ojb;
}
ojb = dataReader["Paysum"];
if(ojb != null && ojb != DBNull.Value)
{
model.Paysum=(decimal)ojb;
}
ojb = dataReader["ShipFee"];
if(ojb != null && ojb != DBNull.Value)
{
model.ShipFee=(decimal)ojb;
}
ojb = dataReader["ProductFee"];
if(ojb != null && ojb != DBNull.Value)
{
model.ProductFee=(decimal)ojb;
}
ojb = dataReader["DerateFee"];
if(ojb != null && ojb != DBNull.Value)
{
model.DerateFee=(decimal)ojb;
}
ojb = dataReader["AddressId"];
if(ojb != null && ojb != DBNull.Value)
{
model.AddressId=(int)ojb;
}
model.RecieverName=dataReader["RecieverName"].ToString();
model.RecieverEmail=dataReader["RecieverEmail"].ToString();
model.RecieverPhone=dataReader["RecieverPhone"].ToString();
model.Postalcode=dataReader["Postalcode"].ToString();
model.RecieverCity=dataReader["RecieverCity"].ToString();
model.RecieverProvince=dataReader["RecieverProvince"].ToString();
model.AddressDetial=dataReader["AddressDetial"].ToString();
ojb = dataReader["ChangeTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.ChangeTime=(DateTime)ojb;
}
ojb = dataReader["PayTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.PayTime=(DateTime)ojb;
}
ojb = dataReader["CreateTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.CreateTime=(DateTime)ojb;
}
ojb = dataReader["OrderType"];
if(ojb != null && ojb != DBNull.Value)
{
model.OrderType=(int)ojb;
}
return model;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr="";
if(!PageValidate.IsNumber(txtUserId.Text))
{
strErr+="UserId�������֣�\\n";
}
if(!PageValidate.IsNumber(txtOrderStatus.Text))
{
strErr+="OrderStatus�������֣�\\n";
}
if(!PageValidate.IsNumber(txtPayMethod.Text))
{
strErr+="PayMethod�������֣�\\n";
}
if(!PageValidate.IsNumber(txtShipMethod.Text))
{
strErr+="ShipMethod�������֣�\\n";
}
if(!PageValidate.IsNumber(txtPayStatus.Text))
{
strErr+="PayStatus�������֣�\\n";
}
if(!PageValidate.IsDecimal(txtPaysum.Text))
{
strErr+="Paysum�������֣�\\n";
}
if(!PageValidate.IsDecimal(txtShipFee.Text))
{
strErr+="ShipFee�������֣�\\n";
}
if(!PageValidate.IsDecimal(txtProductFee.Text))
{
strErr+="ProductFee�������֣�\\n";
}
if(!PageValidate.IsDecimal(txtDerateFee.Text))
{
strErr+="DerateFee�������֣�\\n";
}
if(!PageValidate.IsNumber(txtAddressId.Text))
{
strErr+="AddressId�������֣�\\n";
}
if(this.txtRecieverName.Text =="")
{
strErr+="RecieverName����Ϊ�գ�\\n";
}
if(this.txtRecieverEmail.Text =="")
{
strErr+="RecieverEmail����Ϊ�գ�\\n";
}
if(this.txtRecieverPhone.Text =="")
{
strErr+="RecieverPhone����Ϊ�գ�\\n";
}
if(this.txtPostalcode.Text =="")
{
strErr+="Postalcode����Ϊ�գ�\\n";
}
if(this.txtRecieverCity.Text =="")
{
strErr+="RecieverCity����Ϊ�գ�\\n";
}
if(this.txtRecieverProvince.Text =="")
{
strErr+="RecieverProvince����Ϊ�գ�\\n";
}
if(this.txtAddressDetial.Text =="")
{
strErr+="AddressDetial����Ϊ�գ�\\n";
}
if(!PageValidate.IsDateTime(txtChangeTime.Text))
{
strErr+="ChangeTime����ʱ���ʽ��\\n";
}
if(!PageValidate.IsDateTime(txtPayTime.Text))
{
strErr+="PayTime����ʱ���ʽ��\\n";
}
if(!PageValidate.IsDateTime(txtCreateTime.Text))
{
strErr+="CreateTime����ʱ���ʽ��\\n";
}
if(!PageValidate.IsNumber(txtOrderType.Text))
{
strErr+="OrderType�������֣�\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int UserId=int.Parse(this.txtUserId.Text);
int OrderStatus=int.Parse(this.txtOrderStatus.Text);
int PayMethod=int.Parse(this.txtPayMethod.Text);
int ShipMethod=int.Parse(this.txtShipMethod.Text);
int PayStatus=int.Parse(this.txtPayStatus.Text);
decimal Paysum=decimal.Parse(this.txtPaysum.Text);
decimal ShipFee=decimal.Parse(this.txtShipFee.Text);
decimal ProductFee=decimal.Parse(this.txtProductFee.Text);
decimal DerateFee=decimal.Parse(this.txtDerateFee.Text);
int AddressId=int.Parse(this.txtAddressId.Text);
string RecieverName=this.txtRecieverName.Text;
string RecieverEmail=this.txtRecieverEmail.Text;
string RecieverPhone=this.txtRecieverPhone.Text;
string Postalcode=this.txtPostalcode.Text;
string RecieverCity=this.txtRecieverCity.Text;
string RecieverProvince=this.txtRecieverProvince.Text;
string AddressDetial=this.txtAddressDetial.Text;
DateTime ChangeTime=DateTime.Parse(this.txtChangeTime.Text);
DateTime PayTime=DateTime.Parse(this.txtPayTime.Text);
DateTime CreateTime=DateTime.Parse(this.txtCreateTime.Text);
int OrderType=int.Parse(this.txtOrderType.Text);
NoName.NetShop.Model.OrderModel model=new NoName.NetShop.Model.OrderModel();
model.UserId=UserId;
model.OrderStatus=OrderStatus;
model.PayMethod=PayMethod;
model.ShipMethod=ShipMethod;
model.PayStatus=PayStatus;
model.Paysum=Paysum;
model.ShipFee=ShipFee;
model.ProductFee=ProductFee;
model.DerateFee=DerateFee;
model.AddressId=AddressId;
model.RecieverName=RecieverName;
model.RecieverEmail=RecieverEmail;
model.RecieverPhone=RecieverPhone;
model.Postalcode=Postalcode;
model.RecieverCity=RecieverCity;
model.RecieverProvince=RecieverProvince;
model.AddressDetial=AddressDetial;
model.ChangeTime=ChangeTime;
model.PayTime=PayTime;
model.CreateTime=CreateTime;
model.OrderType=OrderType;
NoName.NetShop.BLL.OrderModelBll bll=new NoName.NetShop.BLL.OrderModelBll();
bll.Update(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Model.OrderModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.OrderModel model = new NoName.NetShop.Model.OrderModel();
object ojb;
ojb = dataReader["UserId"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserId = (int)ojb;
}
ojb = dataReader["OrderId"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderId = (int)ojb;
}
ojb = dataReader["OrderStatus"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderStatus = (int)ojb;
}
ojb = dataReader["PayMethod"];
if (ojb != null && ojb != DBNull.Value)
{
model.PayMethod = (int)ojb;
}
ojb = dataReader["ShipMethod"];
if (ojb != null && ojb != DBNull.Value)
{
model.ShipMethod = (int)ojb;
}
ojb = dataReader["PayStatus"];
if (ojb != null && ojb != DBNull.Value)
{
model.PayStatus = (int)ojb;
}
ojb = dataReader["Paysum"];
if (ojb != null && ojb != DBNull.Value)
{
model.Paysum = (decimal)ojb;
}
ojb = dataReader["ShipFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.ShipFee = (decimal)ojb;
}
ojb = dataReader["ProductFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProductFee = (decimal)ojb;
}
ojb = dataReader["DerateFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.DerateFee = (decimal)ojb;
}
ojb = dataReader["AddressId"];
if (ojb != null && ojb != DBNull.Value)
{
model.AddressId = (int)ojb;
}
model.RecieverName = dataReader["RecieverName"].ToString();
model.RecieverEmail = dataReader["RecieverEmail"].ToString();
model.RecieverPhone = dataReader["RecieverPhone"].ToString();
model.Postalcode = dataReader["Postalcode"].ToString();
model.RecieverCity = dataReader["RecieverCity"].ToString();
model.RecieverProvince = dataReader["RecieverProvince"].ToString();
model.AddressDetial = dataReader["AddressDetial"].ToString();
ojb = dataReader["ChangeTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.ChangeTime = (DateTime)ojb;
}
ojb = dataReader["PayTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.PayTime = (DateTime)ojb;
}
ojb = dataReader["CreateTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateTime = (DateTime)ojb;
}
ojb = dataReader["OrderType"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderType = (int)ojb;
}
return(model);
}
