private void ShowInfo(int productId)
{
if (productId != 0)
{
NoName.NetShop.Product.Model.GiftModel model = gbll.GetModel(productId);
this.litProductId.Text = model.ProductId.ToString();
this.txtProductName.Text = model.ProductName;
this.txtStock.Text = model.Stock.ToString();
this.txtKeywords.Text = model.Keywords;
this.txtBrief.Text = model.Brief;
this.litInsertTime.Text = model.InsertTime.ToString("yyyy-MM-dd HH:mm:ss");
this.litChangeTime.Text = model.ChangeTime.ToString("yyyy-MM-dd HH:mm:ss");
this.rblStatus.Items.FindByValue(model.Status.ToString()).Selected = true;
this.txtScore.Text = model.Score.ToString();
this.txtDecription.Text = model.Decription;
if (!String.IsNullOrEmpty(model.SmallImage))
{
this.imgProduct.Visible = true;
this.imgProduct.ImageUrl = ProductMainImageRule.GetMainImageUrl(model.SmallImage);
}
else
{
this.imgProduct.Visible = false;
}
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Product.Model.GiftModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Product.Model.GiftModel model = new NoName.NetShop.Product.Model.GiftModel();
object ojb;
ojb = dataReader["ProductId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProductId = (int)ojb;
}
model.ProductName = dataReader["ProductName"].ToString();
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 = Convert.ToInt32(ojb);
}
ojb = dataReader["SortValue"];
if (ojb != null && ojb != DBNull.Value)
{
model.SortValue = Convert.ToInt32(ojb);
}
ojb = dataReader["Score"];
if (ojb != null && ojb != DBNull.Value)
{
model.Score = (int)ojb;
}
model.Decription = dataReader["Decription"].ToString();
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Product.Model.GiftModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Product.Model.GiftModel model = new NoName.NetShop.Product.Model.GiftModel();
object ojb;
ojb = dataReader["ProductId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProductId = (int)ojb;
}
model.ProductName = dataReader["ProductName"].ToString();
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 = Convert.ToInt32(ojb);
}
ojb = dataReader["SortValue"];
if (ojb != null && ojb != DBNull.Value)
{
model.SortValue = Convert.ToInt32(ojb);
}
ojb = dataReader["Score"];
if (ojb != null && ojb != DBNull.Value)
{
model.Score = (int)ojb;
}
model.Decription = dataReader["Decription"].ToString();
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Product.Model.GiftModel GetModel(int ProductId)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_pdGift_GetModel");
db.AddInParameter(dbCommand, "ProductId", DbType.Int32, ProductId);
NoName.NetShop.Product.Model.GiftModel model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Save(NoName.NetShop.Product.Model.GiftModel model)
{
Database db = Common.CommDataAccess.DbWriter;
DbCommand dbCommand = db.GetStoredProcCommand("UP_pdGift_Save");
if (model.ProductId == 0)
{
model.ProductId = Common.CommDataHelper.GetNewSerialNum(Common.AppType.Product);
}
db.AddInParameter(dbCommand, "ProductId", DbType.Int32, model.ProductId);
db.AddInParameter(dbCommand, "ProductName", DbType.AnsiString, model.ProductName);
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, "Status", DbType.Byte, model.Status);
db.AddInParameter(dbCommand, "SortValue", DbType.Int32, model.SortValue);
db.AddInParameter(dbCommand, "Score", DbType.Int32, model.Score);
db.AddInParameter(dbCommand, "Decription", DbType.AnsiString, model.Decription);
db.ExecuteNonQuery(dbCommand);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtProductName.Text == "")
{
strErr += "ProductName不能为空！\\n";
}
if (!PageValidate.IsNumber(txtStock.Text))
{
strErr += "Stock不是数字！\\n";
}
if (this.txtKeywords.Text == "")
{
strErr += "Keywords不能为空！\\n";
}
if (this.txtBrief.Text == "")
{
strErr += "Brief不能为空！\\n";
}
if (!PageValidate.IsNumber(txtScore.Text))
{
strErr += "Score不是数字！\\n";
}
if (this.txtDecription.Text == "")
{
strErr += "Decription不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int ProductId;
if (!int.TryParse(this.litProductId.Text, out ProductId))
{
ProductId = 0;
}
string ProductName = this.txtProductName.Text;
int Stock = int.Parse(this.txtStock.Text);
string Keywords = this.txtKeywords.Text;
string Brief = this.txtBrief.Text;
int Status = int.Parse(this.rblStatus.SelectedValue);
int Score = int.Parse(this.txtScore.Text);
string Decription = this.txtDecription.Text;
NoName.NetShop.Product.Model.GiftModel model = new NoName.NetShop.Product.Model.GiftModel();
model.ProductId = ProductId;
if (ProductId == 0)
{
model.ProductId = NoName.NetShop.Common.CommDataHelper.GetNewSerialNum(AppType.Product);
}
model.ProductName = ProductName;
model.Stock = Stock;
if (fulImage.HasFile)
{
string[] MainImages;
if (ProductMainImageRule.SaveProductMainImage(model.ProductId, "gift/", fulImage.PostedFile, out MainImages))
{
model.SmallImage = MainImages[0];
model.MediumImage = MainImages[1];
model.LargeImage = MainImages[2];
}
}
model.Keywords = Keywords;
model.Brief = Brief;
model.Status = Status;
model.SortValue = 0;
model.Score = Score;
model.Decription = Decription;
gbll.Save(model);
Response.Redirect("GiftProductList.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtProductName.Text == "")
{
strErr += "ProductName不能为空！\\n";
}
if (!PageValidate.IsNumber(txtStock.Text))
{
strErr += "Stock不是数字！\\n";
}
if (this.txtKeywords.Text == "")
{
strErr += "Keywords不能为空！\\n";
}
if (this.txtBrief.Text == "")
{
strErr += "Brief不能为空！\\n";
}
if (!PageValidate.IsNumber(txtScore.Text))
{
strErr += "Score不是数字！\\n";
}
if (this.txtDecription.Text == "")
{
strErr += "Decription不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int ProductId;
if (!int.TryParse(this.litProductId.Text, out ProductId))
{
ProductId = 0;
}
string ProductName = this.txtProductName.Text;
int Stock = int.Parse(this.txtStock.Text);
string Keywords = this.txtKeywords.Text;
string Brief = this.txtBrief.Text;
int Status = int.Parse(this.rblStatus.SelectedValue);
int Score = int.Parse(this.txtScore.Text);
string Decription = this.txtDecription.Text;
NoName.NetShop.Product.Model.GiftModel model = new NoName.NetShop.Product.Model.GiftModel();
model.ProductId = ProductId;
if (ProductId == 0)
{
model.ProductId = NoName.NetShop.Common.CommDataHelper.GetNewSerialNum(AppType.Product);
}
model.ProductName = ProductName;
model.Stock = Stock;
if (fulImage.HasFile)
{
string[] MainImages;
if (ProductMainImageRule.SaveProductMainImage(model.ProductId, "gift/", fulImage.PostedFile, out MainImages))
{
model.SmallImage = MainImages[0];
model.MediumImage = MainImages[1];
model.LargeImage = MainImages[2];
}
}
model.Keywords = Keywords;
model.Brief = Brief;
model.Status = Status;
model.SortValue = 0;
model.Score = Score;
model.Decription = Decription;
gbll.Save(model);
Response.Redirect("GiftProductList.aspx");
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Save(NoName.NetShop.Product.Model.GiftModel model)
{
dal.Save(model);
}
