private static Tab_TryProduct ToModel(DataRow row)
{
Tab_TryProduct model = new Tab_TryProduct();
model.Idx = row.IsNull("Idx")?null:(System.Int32?)row["Idx"];
model.ProductTitle = row.IsNull("ProductTitle")?null:(System.String)row["ProductTitle"];
model.ProductPictures = row.IsNull("ProductPictures")?null:(System.String)row["ProductPictures"];
model.ProductPictures2 = row.IsNull("ProductPictures2")?null:(System.String)row["ProductPictures2"];
model.ProductPictures3 = row.IsNull("ProductPictures3")?null:(System.String)row["ProductPictures3"];
model.ProductPictures4 = row.IsNull("ProductPictures4")?null:(System.String)row["ProductPictures4"];
model.ProductDescription = row.IsNull("ProductDescription")?null:(System.String)row["ProductDescription"];
model.TotalCount = row.IsNull("TotalCount")?null:(System.Int32?)row["TotalCount"];
model.LeftCount = row.IsNull("LeftCount")?null:(System.Int32?)row["LeftCount"];
model.DateCreated = row.IsNull("DateCreated")?null:(System.DateTime?)row["DateCreated"];
model.currentBool = row.IsNull("currentBool")?null:(System.String)row["currentBool"];
return(model);
}
public int AddNew(Tab_TryProduct model)
{
string sql = "insert into Tab_TryProduct(ProductTitle,ProductPictures,ProductPictures2,ProductPictures3,ProductPictures4,ProductDescription,TotalCount,LeftCount,DateCreated,currentBool) values(@ProductTitle,@ProductPictures,@ProductPictures2,@ProductPictures3,@ProductPictures4,@ProductDescription,@TotalCount,@LeftCount,@DateCreated,@currentBool); select @@identity ;";
int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql
, new SqlParameter("@ProductTitle", model.ProductTitle)
, new SqlParameter("@ProductPictures", model.ProductPictures)
, new SqlParameter("@ProductPictures2", model.ProductPictures2)
, new SqlParameter("@ProductPictures3", model.ProductPictures3)
, new SqlParameter("@ProductPictures4", model.ProductPictures4)
, new SqlParameter("@ProductDescription", model.ProductDescription)
, new SqlParameter("@TotalCount", model.TotalCount)
, new SqlParameter("@LeftCount", model.LeftCount)
, new SqlParameter("@DateCreated", model.DateCreated)
, new SqlParameter("@currentBool", model.currentBool)
));
return(Idx);
}
public bool Update(Tab_TryProduct model)
{
string sql = "update Tab_TryProduct set ProductTitle=@ProductTitle,ProductPictures=@ProductPictures,ProductPictures2=@ProductPictures2,ProductPictures3=@ProductPictures3,ProductPictures4=@ProductPictures4,ProductDescription=@ProductDescription,TotalCount=@TotalCount,LeftCount=@LeftCount,DateCreated=@DateCreated,currentBool=@currentBool where Idx=@Idx";
int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql
, new SqlParameter("@ProductTitle", model.ProductTitle)
, new SqlParameter("@ProductPictures", model.ProductPictures)
, new SqlParameter("@ProductPictures2", model.ProductPictures2)
, new SqlParameter("@ProductPictures3", model.ProductPictures3)
, new SqlParameter("@ProductPictures4", model.ProductPictures4)
, new SqlParameter("@ProductDescription", model.ProductDescription)
, new SqlParameter("@TotalCount", model.TotalCount)
, new SqlParameter("@LeftCount", model.LeftCount)
, new SqlParameter("@DateCreated", model.DateCreated)
, new SqlParameter("@currentBool", model.currentBool)
, new SqlParameter("Idx", model.Idx)
);
return(rows > 0);
}
public Tab_TryProduct Get(string Idx)
{
DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_TryProduct where Idx=@Idx",
new SqlParameter("Idx", Idx)).Tables[0];
if (dt.Rows.Count > 1)
{
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
Tab_TryProduct model = ToModel(row);
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.DateCreated.Text = DateTime.Now.ToString();
if (!string.IsNullOrEmpty(Request["Idx"]))
{
this.Image1.Visible = true;
this.Image2.Visible = true;
this.Image3.Visible = true;
this.Image4.Visible = true;
DBEntity.Tab_TryProduct ent = new DBEntity.Tab_TryProduct();
ent = ent.Get(Request["Idx"]);
this.ProductTitle.Text = ent.ProductTitle;
this.ProductDescription.Text = ent.ProductDescription;
this.Image1.ImageUrl = string.Format("~/upload/ProductTry/{0}", ent.ProductPictures);
this.Image2.ImageUrl = string.Format("~/upload/ProductTry/{0}", ent.ProductPictures2);
this.Image3.ImageUrl = string.Format("~/upload/ProductTry/{0}", ent.ProductPictures3);
this.Image4.ImageUrl = string.Format("~/upload/ProductTry/{0}", ent.ProductPictures4);
this.TotalCount.Text = ent.TotalCount.ToString();
this.LeftCount.Text = ent.LeftCount.ToString();
this.DateCreated.Text = ent.DateCreated.ToString();
for (int i = 0; i < currentBool.Items.Count; i++)
{
if (currentBool.Items[i].Value == ent.currentBool)
{
currentBool.Items[i].Selected = true;
break;
}
}
//保存编辑的时候使用
this.hiddenFileName.Value = ent.ProductPictures;
this.hiddenFileName2.Value = ent.ProductPictures2;
this.hiddenFileName3.Value = ent.ProductPictures3;
this.hiddenFileName4.Value = ent.ProductPictures4;
}
}
}
