protected void btnAdd_Click(object sender, EventArgs e) { L_ProductInfo pInfo = new L_ProductInfo(); pInfo.Pronumber = txtProNumber.Text.Trim(); pInfo.ProductName = txtProductName.Text.Trim(); pInfo.Keyword = ""; string categoryDetail = this.ddlLeavl.SelectedItem.Value; string categoryDetail1 = this.ddlLeavl.SelectedItem.Value; string categoryID = categoryDetail.Split(',')[1]; pInfo.ProductCategoryID = Convert.ToInt32(categoryID); pInfo.ParentNameRoute = categoryDetail1.ToString(); pInfo.CategoryName = this.ddlLeavl.Items[ddlLeavl.SelectedIndex].Text; pInfo.ProductImage = ViewState["photo"].ToString(); pInfo.Price = Convert.ToDecimal(txtPrice.Text.Trim()); pInfo.CurrentPrice = Convert.ToDecimal(txtCurrentPrince.Text.Trim()); pInfo.MenberPrince = Convert.ToDecimal(txtMenberPrince.Text.Trim()); pInfo.ProducStore = Convert.ToInt32(txtPoductStore.Text.Trim()); pInfo.Danwei = ddlDanWei.SelectedValue; pInfo.FreightType = ddlFreightType.SelectedValue; pInfo.Freight = Convert.ToDecimal(txtFreight.Text.Trim()); pInfo.LinkQQID = ddlQQList.SelectedIndex.ToString(); pInfo.LinkQQName = ddlQQList.Items[ddlQQList.SelectedIndex].Text; pInfo.Ispost = 1; if (rbDesc.Checked) { isReviewEnable = 1; } else { isReviewEnable = 0; } pInfo.Isreviewenable = isReviewEnable; //出错误处 pInfo.RemainDay = Int32.Parse(ddlRemainDay.SelectedValue); pInfo.ProductDesc = this.txtContent.Text; pInfo.Addtime = DateTime.Now; if (productinfo.InsertProduct(pInfo) == 1) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("产品发布成功!")); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("产品发布失败,请您检查一下!!")); } txtContent.Text = ""; txtCurrentPrince.Text = ""; txtFreight.Text = ""; txtMenberPrince.Text = ""; txtPoductStore.Text = ""; txtPrice.Text = ""; txtProductName.Text = ""; txtProNumber.Text = ""; }
public int updateProduct(L_ProductInfo productInfo) { SqlParameter[] para = new SqlParameter[27]; para[0] = new SqlParameter("@productID", productInfo.ProductID); para[1] = new SqlParameter("@proNumber", productInfo.Pronumber); para[2] = new SqlParameter("@ProductName", productInfo.ProductName); para[3] = new SqlParameter("@keyWord", productInfo.Keyword); para[4] = new SqlParameter("@productCategoryID", productInfo.ProductCategoryID); para[5] = new SqlParameter("@categoryName", productInfo.CategoryName); para[6] = new SqlParameter("@parentIDRoute", productInfo.ParentIDRoute); para[7] = new SqlParameter("@parentNameRounte", productInfo.ParentNameRoute); para[8] = new SqlParameter("@productImage", productInfo.ProductImage); para[9] = new SqlParameter("@currentPrice", productInfo.CurrentPrice); para[10] = new SqlParameter("@price", productInfo.Price); para[11] = new SqlParameter("@menberPrice", productInfo.MenberPrince); para[12] = new SqlParameter("@danwei", productInfo.Danwei); para[13] = new SqlParameter("@productStore", productInfo.ProducStore); para[14] = new SqlParameter("@productDesc", productInfo.ProductDesc); para[15] = new SqlParameter("@remainDay", productInfo.RemainDay); para[16] = new SqlParameter("@clickNum", productInfo.ClickNum); para[17] = new SqlParameter("@isReviewEnable", productInfo.Isreviewenable); para[18] = new SqlParameter("@isPost", productInfo.Ispost); para[19] = new SqlParameter("@isCommend", productInfo.Iscommend); para[20] = new SqlParameter("@addTime", productInfo.Addtime); para[21] = new SqlParameter("@linkQQid", productInfo.LinkQQID); para[22] = new SqlParameter("@linkQQName", productInfo.LinkQQName); para[23] = new SqlParameter("@freightType", productInfo.FreightType); para[24] = new SqlParameter("@freight", productInfo.Freight); para[25] = new SqlParameter("@AdminID", productInfo.AdminID); para[26] = new SqlParameter("@result", SqlDbType.Int); para[26].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "p_UpdateShopping", para); return(Int32.Parse(para[26].Value.ToString())); }
public IList GetIndexBindProductShow(Int16 isType, string topNum) { IList list = new ArrayList(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@IsType", isType); param[1] = new SqlParameter("@topNum", topNum); DataSet Set = SqlHelper.ExecuteDateSet(CommandType.StoredProcedure, "L_ProductListByIsTypeIndexShow", param); for (int i = 0; i < Set.Tables[0].Rows.Count; i++) { DataRow drv = Set.Tables[0].Rows[i]; L_ProductInfo pInfo = new L_ProductInfo(); pInfo.ProductID = Int32.Parse(drv["productID"].ToString()); pInfo.ProductName = drv["productName"].ToString(); pInfo.ProductImage = drv["productImage"].ToString(); pInfo.Price = decimal.Parse(drv["price"].ToString()); pInfo.CurrentPrice = decimal.Parse(drv["currentPrice"].ToString()); pInfo.MenberPrince = decimal.Parse(drv["menberprice"].ToString()); pInfo.Danwei = drv["danwei"].ToString(); pInfo.RemainDay = Int32.Parse(drv["remainDay"].ToString()); pInfo.Addtime = DateTime.Parse(drv["addTime"].ToString()); list.Add(pInfo); } return(list); }
public IList GetIndexBindHottuiJian(int classID, Int16 isType, string TopNum) { IList list = new ArrayList(); SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@classID", classID); param[1] = new SqlParameter("@isType", isType); param[2] = new SqlParameter("@TopNum", TopNum); DataSet dSet = SqlHelper.ExecuteDateSet(CommandType.StoredProcedure, "p_indexBindhottuijian", param); for (int i = 0; i < dSet.Tables[0].Rows.Count; i++) { DataRow drv = dSet.Tables[0].Rows[i]; L_ProductInfo pinfo = new L_ProductInfo(); pinfo.ProductID = Int32.Parse(drv["productID"].ToString()); pinfo.ProductName = drv["productName"].ToString(); pinfo.ProductImage = drv["productImage"].ToString(); pinfo.CurrentPrice = decimal.Parse(drv["currentPrice"].ToString()); pinfo.MenberPrince = decimal.Parse(drv["menberprice"].ToString()); pinfo.Danwei = drv["danWei"].ToString(); pinfo.RemainDay = Int32.Parse(drv["remainDay"].ToString()); pinfo.Addtime = DateTime.Parse(drv["addTime"].ToString()); list.Add(pinfo); } return(list); }
public L_ProductInfo GetProductInfoByProductID(int productID) { L_ProductInfo productinfo = null; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@productID ", productID); param[1] = new SqlParameter("@result", SqlDbType.Int); param[1].Direction = ParameterDirection.Output; DataSet set = SqlHelper.ExecuteDateSet(CommandType.StoredProcedure, "p_ProductGetInfoByProduct", param); if (set.Tables.Count > 0) { if (set.Tables[0].Rows.Count > 0) { DataRow drv = set.Tables[0].Rows[0]; productinfo = new L_ProductInfo( Int32.Parse(drv["productID"].ToString()), drv["ProNumber"].ToString(), drv["productName"].ToString(), drv["keyWord"].ToString(), Int32.Parse(drv["productCategoryID"].ToString()), drv["categoryName"].ToString(), drv["parentIDRoute"].ToString(), drv["parentNameRounte"].ToString(), drv["productImage"].ToString(), Decimal.Parse(drv["currentPrice"].ToString()), Decimal.Parse(drv["price"].ToString()), Decimal.Parse(drv["menberPrice"].ToString()), drv["danwei"].ToString(), Int32.Parse(drv["productStore"].ToString()), drv["productDesc"].ToString(), Int32.Parse(drv["remainDay"].ToString()), Int32.Parse(drv["clickNum"].ToString()), Int32.Parse(drv["isReviewEnable"].ToString()), Int16.Parse(drv["isPost"].ToString()), Int16.Parse(drv["isCommend"].ToString()), DateTime.Parse(drv["addTime"].ToString()), drv["linkQQID"].ToString(), drv["linkQQName"].ToString(), drv["freightType"].ToString(), Decimal.Parse(drv["freight"].ToString()), Int32.Parse(drv["adminID"].ToString())); } } return(productinfo); }
private void BindProductInfoByProductID(int pId) { pInfo = product.GetProductInfoByProductID(pId); if (pInfo == null) { } else { StringBuilder sb = new StringBuilder(); sb.Append("<li>首页></li>" + pInfo.CategoryName + ">" + pInfo.ProductName); liClass.Text = sb.ToString(); //计算还剩几天,产品过期 DateTime dtOverTime; TimeSpan howDays; dtOverTime = DateTime.Parse(DateTime.Now.ToShortDateString()); DateTime postTime = pInfo.Addtime; int HowDay = pInfo.RemainDay; howDays = dtOverTime.Subtract(DateTime.Parse(postTime.ToShortDateString())); remainDayNum = HowDay - howDays.Days; } }
protected void btnUpdate_Click(object sender, EventArgs e) { L_ProductInfo pInfo = new L_ProductInfo(); pInfo.Pronumber = txtProNumber.Text.Trim(); pInfo.ProductName = txtProductName.Text.Trim(); pInfo.Keyword = ""; string categoryDetail = this.ddlLeavl.SelectedItem.Value; string categoryDetail1 = this.ddlLeavl.SelectedItem.Value; string categoryID = categoryDetail.Split(',')[1]; pInfo.ProductCategoryID = Convert.ToInt32(categoryID); pInfo.ParentNameRoute = categoryDetail1.ToString(); pInfo.CategoryName = this.ddlLeavl.Items[ddlLeavl.SelectedIndex].Text; pInfo.ProductImage = ViewState["photo"].ToString(); pInfo.Price = Convert.ToDecimal(txtPrice.Text.Trim()); pInfo.CurrentPrice = Convert.ToDecimal(txtCurrentPrince.Text.Trim()); pInfo.MenberPrince = Convert.ToDecimal(txtMenberPrince.Text.Trim()); pInfo.ProducStore = Convert.ToInt32(txtPoductStore.Text.Trim()); pInfo.Danwei = ddlDanWei.SelectedValue; pInfo.FreightType = ddlFreightType.SelectedValue; pInfo.Freight = Convert.ToDecimal(txtFreight.Text.Trim()); pInfo.LinkQQID = ddlQQList.SelectedIndex.ToString(); pInfo.LinkQQName = ddlQQList.Items[ddlQQList.SelectedIndex].Text; pInfo.Ispost = 1; if (rbDesc.Checked) { isReviewEnable = 1; } else { isReviewEnable = 0; } pInfo.Isreviewenable = isReviewEnable; //出错误处 pInfo.RemainDay = Int32.Parse(ddlRemainDay.SelectedValue); pInfo.ProductDesc = this.txtContent.Text; pInfo.Addtime = DateTime.Now; pInfo.ProductID = Int32.Parse(Request.QueryString["pID"]); int result = productinfo.updateProduct(pInfo); switch (result) { case 1: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("产品修改成功!", "manageProduct.aspx")); break; case -2: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("修改产品的信息不存在,请您检查!")); break; default: Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("产品修改不成功!", "manageProduct.aspx")); break; } }
public int updateProduct(L_ProductInfo productInfo) { return(product.updateProduct(productInfo)); }
public int InsertProduct(L_ProductInfo productinfo) { return(product.AddProduct(productinfo)); }