private void ShowInfo(int ImageId)
{
NoName.NetShop.BLL.ProductImageModelBll bll = new NoName.NetShop.BLL.ProductImageModelBll();
NoName.NetShop.Model.ProductImageModel model = bll.GetModel(ImageId);
this.lblProductId.Text = model.ProductId.ToString();
this.lblSmallImage.Text = model.SmallImage;
this.lblLargeImage.Text = model.LargeImage;
this.lblOriginImage.Text = model.OriginImage;
this.lblTitle.Text = model.Title;
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(NoName.NetShop.Model.ProductImageModel model)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_pdProductImage_Update");
db.AddInParameter(dbCommand, "ImageId", DbType.Int32, model.ImageId);
db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId);
db.AddInParameter(dbCommand, "SmallImage", DbType.AnsiString, model.SmallImage);
db.AddInParameter(dbCommand, "LargeImage", DbType.AnsiString, model.LargeImage);
db.AddInParameter(dbCommand, "OriginImage", DbType.AnsiString, model.OriginImage);
db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
db.ExecuteNonQuery(dbCommand);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtProductId.Text))
{
strErr += "ProductId不是数字！\\n";
}
if (this.txtSmallImage.Text == "")
{
strErr += "SmallImage不能为空！\\n";
}
if (this.txtLargeImage.Text == "")
{
strErr += "LargeImage不能为空！\\n";
}
if (this.txtOriginImage.Text == "")
{
strErr += "OriginImage不能为空！\\n";
}
if (this.txtTitle.Text == "")
{
strErr += "Title不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int ProductId = int.Parse(this.txtProductId.Text);
string SmallImage = this.txtSmallImage.Text;
string LargeImage = this.txtLargeImage.Text;
string OriginImage = this.txtOriginImage.Text;
string Title = this.txtTitle.Text;
NoName.NetShop.Model.ProductImageModel model = new NoName.NetShop.Model.ProductImageModel();
model.ProductId = ProductId;
model.SmallImage = SmallImage;
model.LargeImage = LargeImage;
model.OriginImage = OriginImage;
model.Title = Title;
NoName.NetShop.BLL.ProductImageModelBll bll = new NoName.NetShop.BLL.ProductImageModelBll();
bll.Update(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Model.ProductImageModel GetModel(int ImageId)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_pdProductImage_GetModel");
db.AddInParameter(dbCommand, "ImageId", DbType.Int32, ImageId);
NoName.NetShop.Model.ProductImageModel 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(txtProductId.Text))
{
strErr+="ProductId�������֣�\\n";
}
if(this.txtSmallImage.Text =="")
{
strErr+="SmallImage����Ϊ�գ�\\n";
}
if(this.txtLargeImage.Text =="")
{
strErr+="LargeImage����Ϊ�գ�\\n";
}
if(this.txtOriginImage.Text =="")
{
strErr+="OriginImage����Ϊ�գ�\\n";
}
if(this.txtTitle.Text =="")
{
strErr+="Title����Ϊ�գ�\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int ProductId=int.Parse(this.txtProductId.Text);
string SmallImage=this.txtSmallImage.Text;
string LargeImage=this.txtLargeImage.Text;
string OriginImage=this.txtOriginImage.Text;
string Title=this.txtTitle.Text;
NoName.NetShop.Model.ProductImageModel model=new NoName.NetShop.Model.ProductImageModel();
model.ProductId=ProductId;
model.SmallImage=SmallImage;
model.LargeImage=LargeImage;
model.OriginImage=OriginImage;
model.Title=Title;
NoName.NetShop.BLL.ProductImageModelBll bll=new NoName.NetShop.BLL.ProductImageModelBll();
bll.Update(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Model.ProductImageModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.ProductImageModel model = new NoName.NetShop.Model.ProductImageModel();
object ojb;
ojb = dataReader["ImageId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ImageId = (int)ojb;
}
ojb = dataReader["ProductId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProductId = (int)ojb;
}
model.SmallImage = dataReader["SmallImage"].ToString();
model.LargeImage = dataReader["LargeImage"].ToString();
model.OriginImage = dataReader["OriginImage"].ToString();
model.Title = dataReader["Title"].ToString();
return(model);
}
/// <summary>
/// ����ʵ�������
/// </summary>
public NoName.NetShop.Model.ProductImageModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.ProductImageModel model=new NoName.NetShop.Model.ProductImageModel();
object ojb;
ojb = dataReader["ImageId"];
if(ojb != null && ojb != DBNull.Value)
{
model.ImageId=(int)ojb;
}
ojb = dataReader["ProductId"];
if(ojb != null && ojb != DBNull.Value)
{
model.ProductId=(int)ojb;
}
model.SmallImage=dataReader["SmallImage"].ToString();
model.LargeImage=dataReader["LargeImage"].ToString();
model.OriginImage=dataReader["OriginImage"].ToString();
model.Title=dataReader["Title"].ToString();
return model;
}
