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