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; } } }