protected void Btn_Next_Click(object sender, EventArgs e)
{
string keys = CheckVali();
string goodsId = "";
string goodsname = "";
string goodspic = "";
if (keys != "")
{
foreach (RepeaterItem item in Rpt_GoodsList.Items)
{
RadioButton rb = item.FindControl("RBtn_Goods") as RadioButton;
if (rb.Checked)
{
Label lbl = item.FindControl("Lbl_GoodsId") as Label;
goodsId = lbl.Text;
Label lblname = item.FindControl("Lbl_GoodsName") as Label;
goodsname = lblname.Text;
Label lblpic = item.FindControl("Lbl_GoodsPic") as Label;
goodspic = lblpic.Text;
break;
}
}
if (goodsId != "")
{
string nick = "nick";
if (Request.Cookies["nick"] != null)
{
nick = HttpUtility.UrlDecode(Request.Cookies["nick"].Value); //"nick";
}
else
{
if (Session["snick"] != null)
{
nick = Session["snick"].ToString();
}
}
TuiGoodsInfo info = new TuiGoodsInfo();
info.GoodsId = goodsId;
info.Keywords = keys;
info.TuiId = Guid.NewGuid();
info.Nick = nick;
info.GoodsName = goodsname;
info.GoodsPic = goodspic;
info.Type = 1;
new TuiGoodsService().InsertTuiGoods(info);
Response.Redirect("BaiShare.aspx?id=" + info.TuiId);
}
}
}
private static SqlParameter[] CreateSqlParameter(TuiGoodsInfo info)
{
SqlParameter[] param = new[]
{
new SqlParameter("@TuiId", info.TuiId),
new SqlParameter("@GoodsPic", info.GoodsPic),
new SqlParameter("@GoodsId", info.GoodsId),
new SqlParameter("@GoodsName", info.GoodsName),
new SqlParameter("@Keywords", info.Keywords),
new SqlParameter("@Nick", info.Nick),
new SqlParameter("@Type", info.Type)
};
return(param);
}
public TuiGoodsInfo GetTuiGoods(Guid tuiId)
{
SqlParameter param = new SqlParameter("@TuiId", tuiId);
TuiGoodsInfo info = null;
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT_BY_ID, param);
foreach (DataRow dr in dt.Rows)
{
info = new TuiGoodsInfo();
info.GoodsId = dr["GoodsId"].ToString();
info.GoodsName = dr["GoodsName"].ToString();
info.Keywords = dr["Keywords"].ToString();
info.GoodsPic = dr["GoodsPic"].ToString();
}
return(info);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"];
TuiGoodsService tuiDal = new TuiGoodsService();
try
{
TuiGoodsInfo info = tuiDal.GetTuiGoods(new Guid(id));
TB_KeyWords.Text = info.Keywords.Replace("[ksp]", " ");
ViewState["GoodsPic"] = info.GoodsPic;
ViewState["GoodsUrl"] = "http://item.taobao.com/item.htm?id=" + info.GoodsId;
ViewState["GoodsName"] = info.GoodsName;
ViewState["Keys"] = info.Keywords.Replace("[ksp]", " ");
ViewState["ShowUrl"] = Request.Url.ToString().Substring(0, Request.Url.ToString().LastIndexOf("/")) + "/?" + id.Substring(0, 8);
}
catch (Exception ex)
{
}
}
}
public IList <TuiGoodsInfo> GetAllTuiGoodsByType(string nick, int type)
{
SqlParameter[] param = new[]
{
new SqlParameter("@nick", nick),
new SqlParameter("@type", type)
};
IList <TuiGoodsInfo> list = new List <TuiGoodsInfo>();
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT_All_BY_TYPE, param);
foreach (DataRow dr in dt.Rows)
{
TuiGoodsInfo info = new TuiGoodsInfo();
info.GoodsId = dr["GoodsId"].ToString();
info.TuiId = new Guid(dr["TuiId"].ToString());
info.GoodsName = dr["GoodsName"].ToString();
info.GoodsPic = dr["GoodsPic"].ToString();
info.Keywords = dr["Keywords"].ToString();
list.Add(info);
}
return(list);
}
public int InsertTuiGoods(TuiGoodsInfo info)
{
return(DBHelper.ExecuteNonQuery(SQL_INSERT, CreateSqlParameter(info)));
}
