protected void btnShop_Click(object sender, EventArgs e)
{
string Orderid;
if (Session["UserName"] == null)
{
Alert.AlertAndRedirect("您还没有登录,请登录后再购买,谢谢合作!", "Default.aspx");
}
else
{
SqlDataReader dr = data.GetDataReader("select top 1 * from tb_Order where IsCheckout='否' and Ordeuser='" + Session["UserName"].ToString() + "' order by id desc ");
if (dr.Read())
{
Orderid = dr["Orderid"].ToString();
}
else
{
Orderid = DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString();
string sqlOrder = "insert into tb_Order(Orderid,Ordeuser,OrderStite,ShangPinId,shuliang)values('" + Orderid + "','" + Session["UserName"].ToString() + "','未发货','" + Request.QueryString["id"].ToString() + "','"+TextBox1.Text+"')";
data.RunSql(sqlOrder);
}
sqlconn.Open();
string strid = Page.Request.QueryString["ShangPinID"];
string sqlstr = "insert into tb_OrderInfo"
+ "(OrderID,OrderMember,ShangPinID,ShangPinName,ShangPinTypeID,ShangPinTypeName,ShangPinPrice,IsCheckout,shuliang)"
+ " values('" + Orderid + "','" + Session["UserName"].ToString() + "','" + Request.QueryString["id"].ToString() + "','"
+ Label2.Text + "','" + Hidden1.Value + "','" + Label3.Text
+ "','" + Label4.Text + "','否','" + TextBox1.Text + "')";
data.RunSql(sqlstr);
Response.Redirect("Shopping.aspx");
}
}
}