protected void btnAdd_Click(object sender, EventArgs e) { if (!ProductClassManage.IsLeafNode(Convert.ToInt32(ProductClassDDL1.currentValue))) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(),"err", "<script>alert('产品只能添加到子分类',请选择一个正确的分类!);</script>"); } else { Product myProduct = new Product(); myProduct.Prod_Name = this.txtName.Text; myProduct.Prod_Number = this.txtNumber.Text; if (!string.IsNullOrEmpty(this.txtPrice.Text)) { myProduct.Prod_Price = Convert.ToDecimal(this.txtPrice.Text); } myProduct.Prod_Content = CKEditor1.Text; myProduct.Prod_Click = 0; myProduct.Prod_Date = DateTime.Now; myProduct.IsTop = this.cbxTop.Checked; myProduct.IsCommend = this.cbxCommand.Checked; myProduct.Pc_Id = Convert.ToInt32(ProductClassDDL1.currentValue); if (string.IsNullOrEmpty(this.txtImage.Text) || this.txtImage.Text == "") { string fckStr = CKEditor1.Text; MatchCollection matchs = Regex.Matches(fckStr, @"<img[^src]*src=""[^http\://]*(?<src>[^""]*?)""", RegexOptions.IgnoreCase); foreach (Match m in matchs) { myProduct.Prod_Image = m.Groups["src"].Value.ToString(); break; } if (string.IsNullOrEmpty(myProduct.Prod_Image)) { myProduct.Prod_Image = " "; } } else { myProduct.Prod_Image = this.txtImage.Text.Trim(); } if (ProductManage.Insert(myProduct)) { Response.Write("<script>alert('产品添加成功!!!');window.location.href=document.URL;</script>"); } else { this.lblError.Visible = true; } } }
public static ProductCollection GetCommend() { ProductCollection list = ProductService.GetCommend(); int length = list.Count; if (length < 18) { int i = 0; while(i < 18 - length) { Product product = new Product(); list.Add(product); i++; } } return list; }
/// <summary> /// 条件查询产品 /// </summary> /// <param name="prod_id">产品id</param> /// <returns>Product模型 包含一条产品记录</returns> public static Product GetItem(int prod_id) { Product myProduct = new Product(); string sql = "select * from t_product where prod_id=?prod_id"; MySqlParameter[] parms = { new MySqlParameter("?prod_id", MySqlDbType.Int32) }; parms[0].Value = prod_id; MySqlDataReader reader = DbHelper.ExecuteDataReader(sql, parms); if (reader.HasRows) { if (reader.Read()) { myProduct = FillDataRecord(reader); } } reader.Close(); return myProduct; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string prodId = null; try { prodId = Request.QueryString["id"].ToString(); } catch (Exception ex) { } Product myProduct = new Product(); if (BaseCommon.ValidQueryString(prodId)) { ProductManage.Update(Convert.ToInt32(prodId)); myProduct = ProductManage.GetItem(Convert.ToInt32(prodId)); pcnav = ProductClassManage.ProductClassNav(Convert.ToInt32(myProduct.Pc_Id), pcnav); Page.Title = myProduct.Prod_Name; //HtmlMeta keywords = (HtmlMeta)Master.FindControl("keywords"); //HtmlMeta Description = (HtmlMeta)Master.FindControl("Description"); //keywords.Attributes["content"] = keywords.Attributes["content"] + "," + myProduct.Prod_Name; // Description.Attributes["content"] = Description.Attributes["content"] + "," + myProduct.Prod_Name; this.lblTitle.Text = myProduct.Prod_Name; this.lblNumber.Text = myProduct.Prod_Number; this.lblClick.Text = myProduct.Prod_Click.ToString(); this.lblContent.Text = myProduct.Prod_Content; this.imgProd.ImageUrl = myProduct.Prod_Image; } else { Response.Write("错误的链接!"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { myProduct = ProductManage.GetItem(Convert.ToInt32(Request.QueryString["id"])); if (string.IsNullOrEmpty(myProduct.Prod_Name)) { Response.Write("<script language=JavaScript>alert('错误的链接!');document.location.href='ProductMgmt.aspx'</script>"); } else { this.ProductClassDDL1.LoadTree(); this.ProductClassDDL1.InnerDropDownListTree.Items.FindByValue(myProduct.Pc_Id.ToString()).Selected = true; this.tbxName.Text = myProduct.Prod_Name; this.tbxNumber.Text = myProduct.Prod_Number; this.tbxPrice.Text = string.Format("{0:N2}", myProduct.Prod_Price); this.tbxImage.Text = myProduct.Prod_Image; CKEditor1.Text = myProduct.Prod_Content; this.cbxTop.Checked = myProduct.IsTop; this.cbxCommend.Checked = myProduct.IsCommend; Page.Title = myProduct.Prod_Name; } } else { Response.Write("<script language=JavaScript>alert('错误的链接!');document.location.href='ProductMgmt.aspx'</script>"); } } CKFinder.FileBrowser _FileBrowser = new CKFinder.FileBrowser(); _FileBrowser.BasePath = ""; _FileBrowser.SetupCKEditor(CKEditor1); }
private static Product FillDataRecord(IDataRecord myDataRecord) { Product myProduct = new Product(); myProduct.Prod_Id = myDataRecord.GetInt32(myDataRecord.GetOrdinal("prod_id")); myProduct.Prod_Name = myDataRecord.GetString(myDataRecord.GetOrdinal("prod_name")); myProduct.Prod_Content = myDataRecord.GetString(myDataRecord.GetOrdinal("prod_content")); myProduct.Prod_Date = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("prod_date")); myProduct.Pc_Id = myDataRecord.GetInt32(myDataRecord.GetOrdinal("pc_id")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("prod_number"))) { myProduct.Prod_Number = myDataRecord.GetString(myDataRecord.GetOrdinal("prod_number")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("prod_price"))) { myProduct.Prod_Price = myDataRecord.GetDecimal(myDataRecord.GetOrdinal("prod_price")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("prod_image"))) { myProduct.Prod_Image = myDataRecord.GetString(myDataRecord.GetOrdinal("prod_image")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("prod_click"))) { myProduct.Prod_Click = myDataRecord.GetInt32(myDataRecord.GetOrdinal("prod_click")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("istop"))) { myProduct.IsTop = myDataRecord.GetBoolean(myDataRecord.GetOrdinal("istop")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("iscommend"))) { myProduct.IsCommend = myDataRecord.GetBoolean(myDataRecord.GetOrdinal("iscommend")); } return myProduct; }
/// <summary> /// 修改产品 /// </summary> /// <param name="myProduct">产品模型</param> /// <returns>返回<c>true</c>修改成功,或<c>false</c>修改失败.</returns> public static bool Update(Product myProduct) { int result = 0; string sql = @"update t_product set prod_name = ?prod_name, prod_number = ?prod_number, prod_price = ?prod_price, prod_image = ?Prod_image, prod_content = ?prod_content, prod_date = ?prod_date, istop = ?istop, iscommend = ?iscommend, pc_id = ?pc_id WHERE prod_id = ?prod_id"; MySqlParameter[] parms = { new MySqlParameter("@prod_name",MySqlDbType.VarChar), new MySqlParameter("@prod_number",MySqlDbType.VarChar), new MySqlParameter("@prod_price",MySqlDbType.Decimal), new MySqlParameter("@prod_image",MySqlDbType.VarChar), new MySqlParameter("@prod_content",MySqlDbType.Text), new MySqlParameter("@prod_date",MySqlDbType.Date), new MySqlParameter("@istop",MySqlDbType.Bit), new MySqlParameter("@iscommend",MySqlDbType.Bit), new MySqlParameter("@pc_id",MySqlDbType.Int32), new MySqlParameter("@prod_id",MySqlDbType.Int32) }; parms[0].Value = myProduct.Prod_Name; parms[1].Value = myProduct.Prod_Number; parms[2].Value = myProduct.Prod_Price; parms[3].Value = myProduct.Prod_Image; parms[4].Value = myProduct.Prod_Content; parms[5].Value = myProduct.Prod_Date; parms[6].Value = myProduct.IsTop; parms[7].Value = myProduct.IsCommend; parms[8].Value = myProduct.Pc_Id; parms[9].Value = myProduct.Prod_Id; result = DbHelper.ExecuteNonQuery(sql, parms); return result > 0; }
/// <summary> /// 插入产品记录 /// </summary> /// <param name="myProduct">myProduct 模型</param> /// <returns>返回<c>true</c>插入成功,或<c>false</c>插入失败.</returns> public static bool Insert(Product myProduct) { int result = 0; string sql = @"insert into t_product( prod_name, prod_number, prod_price, prod_image, prod_content, prod_date, prod_click, istop, iscommend, pc_id ) values ( ?prod_name, ?prod_number, ?prod_price, ?prod_image, ?prod_content, ?prod_date, ?prod_click, ?istop, ?iscommend, ?pc_id )"; MySqlParameter[] parms = { new MySqlParameter("?prod_name",MySqlDbType.VarChar), new MySqlParameter("?prod_number",MySqlDbType.VarChar), new MySqlParameter("?prod_price",MySqlDbType.Decimal), new MySqlParameter("?prod_image",MySqlDbType.VarChar), new MySqlParameter("?prod_content",MySqlDbType.Text), new MySqlParameter("?prod_date",MySqlDbType.Date), new MySqlParameter("?prod_click",MySqlDbType.Int32), new MySqlParameter("?istop",MySqlDbType.Bit), new MySqlParameter("?iscommend",MySqlDbType.Bit), new MySqlParameter("?pc_id",MySqlDbType.Int32), }; parms[0].Value = myProduct.Prod_Name; parms[1].Value = myProduct.Prod_Number; parms[2].Value = myProduct.Prod_Price; parms[3].Value = myProduct.Prod_Image; parms[4].Value = myProduct.Prod_Content; parms[5].Value = myProduct.Prod_Date; parms[6].Value = myProduct.Prod_Click; parms[7].Value = myProduct.IsTop; parms[8].Value = myProduct.IsCommend; parms[9].Value = myProduct.Pc_Id; result = DbHelper.ExecuteNonQuery(sql, parms); return result > 0; }
public static bool Insert(Product myProduct) { if(!string.IsNullOrEmpty(myProduct.Prod_Name) && !string.IsNullOrEmpty(myProduct.Prod_Content) && myProduct.Pc_Id > 0) { myProduct.Prod_Date = DateTime.Now; return ProductService.Insert(myProduct); } else { return false; } }