protected void Btn_Add_Click(object sender, EventArgs e) { string nick = ""; if (Request.Cookies["nick"] != null) { nick = HttpUtility.UrlDecode(Request.Cookies["nick"].Value); //"nick"; } else { nick = Session["snick"].ToString(); } if (nick == "") { Response.Write("请重新登录"); return; } if (CheckVali()) { TaoBaoGoodsInfo info = new TaoBaoGoodsInfo(); try { info.seller_cids = DDL_Cate.SelectedValue; info.num_iid = TB_ID.Text; info.title = TB_GoodsName.Text.Trim(); info.price = decimal.Parse(TB_Price.Text.Trim()); info.pic_url = TB_Url.Text.Trim(); info.cid = ""; info.num = int.Parse(TB_Count.Text); info.modified = DateTime.Now; new GoodsService().InsertGoodsInfo(info, nick); Response.Redirect("UserAddAds.aspx"); } catch (Exception ex) { Page.RegisterStartupScript("error", "<script>alert('" + ex.Message + "');</script>"); } } else { Page.RegisterStartupScript("error", "<script>alert('请完整填写商品信息');</script>"); } }
private static SqlParameter[] CreateParameter(TaoBaoGoodsInfo info, string nick) { SqlParameter[] param = new[] { new SqlParameter("@GoodsId", info.num_iid), new SqlParameter("@GoodsName", info.title), new SqlParameter("@GoodsPrice", info.price), new SqlParameter("@GoodsCount", info.num), new SqlParameter("@GoodsPic", info.pic_url), new SqlParameter("@Modified", info.modified), new SqlParameter("@CateId", info.seller_cids), new SqlParameter("@TaoBaoCId", info.cid), new SqlParameter("@Nick", nick) }; return(param); }
public int InsertGoodsInfo(TaoBaoGoodsInfo info, string nick) { return(DBHelper.ExecuteNonQuery(SQL_INSERT, CreateParameter(info, nick))); }