现在在家没有事作，就接几个毕业设计，作得好人家还不要呢，搞到最后我作的网站后台全部删除了。无语哦。
我要这么写代码他们才看得懂。
private void Button1_ServerClick(object sender, System.EventArgs e)
{
//获取需要的信息并验证
ProductID = Request.QueryString["id"].ToString();
SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
string sql="select * from Products where ProductState=0 and ProductId="+ProductID; //数据库连接字符串
SqlCommand command=new SqlCommand(sql,connection);//构件执行数据命令
connection.Open();
SqlDataReader dr=command.ExecuteReader();//保存从数据库里面返回的一条记录
if(dr.Read())
{
ProductQuantity=dr["ProductQuantity"].ToString();
}
if(Convert.ToInt32(quantity.Text)<=Convert.ToInt32(ProductQuantity))
{
Quantity=quantity.Text;
}
else
{
Response.Write ("<script language='JavaScript'>");
Response.Write ("alert('不正确数值或库存量不足!!')");
Response.Write ("</script>");
}
checkcode=vaidatecode.Text;
if (Session["CheckCode"].ToString()!=checkcode)
{
Response.Write ("<script language='JavaScript'>");
Response.Write ("alert('输入的验证码有误！请重新输入！')");
Response.Write ("</script>");
return;
}
if(RadioButton1.Checked==true)
{
PostPrice=RadioButton1.Text;
PostType="平邮";
}
else
{
PostPrice=RadioButton2.Text;
PostType="快递";
}
ProductTotal=Convert.ToString(Convert.ToDouble(productprice.Text)*Convert.ToDouble(Quantity));
Payment=Convert.ToString(Convert.ToDouble(ProductTotal)+Convert.ToDouble(PostPrice));
dr.Close();
connection.Close();
//--虚拟币交易
//买家扣钱
SqlConnection connection1=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
string sql1="select * from Users where UserName='"+Session["username"].ToString()+"'"; //数据库连接字符串
SqlCommand command1=new SqlCommand(sql1,connection1);//构件执行数据命令
connection1.Open();
SqlDataReader dr1=command1.ExecuteReader();//保存从数据库里面返回的一条记录
if(dr1.Read())
{
VMoney1=dr1["VMoney"].ToString();
}
if(Convert.ToDouble(VMoney1)>=Convert.ToDouble(Payment))
{
VMoney1=Convert.ToString(Convert.ToDouble(VMoney1)-Convert.ToDouble(Payment));
}
else
{
Response.Write ("<script language='JavaScript'>");
Response.Write ("alert('您的虚拟币不足!!！')");
Response.Write ("</script>");
return;
}
dr1.Close();
string sql2="update Users set VMoney='"+VMoney1+"' where UserName='"+Session["username"].ToString()+"'";
command1=new SqlCommand(sql2,connection1);//构件执行数据命令
command1.ExecuteNonQuery();
connection1.Close();
//卖家加钱
SqlConnection connection2=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
string sql3="select * from Users where UserName=(select UserName from Products where ProductId='"+ProductID+"')";//数据库连接字符串
SqlCommand command2=new SqlCommand(sql3,connection2);//构件执行数据命令
connection2.Open();
SqlDataReader dr2=command2.ExecuteReader();//保存从数据库里面返回的一条记录
if(dr2.Read())
{
VMoney2=dr2["VMoney"].ToString();
}
dr2.Close();
VMoney2=Convert.ToString(Convert.ToDouble(VMoney2)+Convert.ToDouble(Payment));
string sql4="update Users set VMoney='"+VMoney2+"' where UserName=(select UserName from Products where ProductId='"+ProductID+"')";
command2=new SqlCommand(sql4,connection2);
command2.ExecuteNonQuery();
//卖家库存量扣除
Qnum=Convert.ToString(Convert.ToInt32(context.Text)-Convert.ToInt32(Quantity));
string sql5="update Products set ProductQuantity='"+Qnum+"' where ProductId="+ProductID; //数据库连接字符串
SqlCommand command3=new SqlCommand(sql,connection);//构件执行数据命令
command3=new SqlCommand(sql5,connection2);
command3.ExecuteNonQuery();
connection2.Close();
//最终形成定单
SqlConnection conn=new SqlConnection (ConfigurationSettings.AppSettings["ConnStr"]);
string strsql="INSERT INTO Orders(Store,SalesId,BuyerId,ProductId,Quantity,PostType,PostPrice,ConsigneeName,MobilePhone,Telephone,ConsigneeAdress,ConsigneePost,ProductPrice,ProductTotal,Payment) values('"+productid.Text+"','"+salesid.Text+"','"+Session["username"].ToString()+"',"+ProductID+",'"+Quantity+"','"+PostType+"','"+PostPrice+"','"+buyername.Text+"','"+mobileTele.Text+"','"+telephone.Text+"','"+address.Text+"','"+postalcode.Text+"','"+productprice.Text+"','"+ProductTotal+"','"+Payment+"')";
command=new SqlCommand(strsql,conn);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
Response.Redirect("Order_Detail.aspx");
}
