protected void Button1_Click(object sender, EventArgs e)
{
int i;
int zsl = 0;
int zjr = 0;
//更新Products表的数量
for (i = 0; i < GridView1.Rows.Count; i++)
{
string spno = GridView1.Rows[i].Cells[0].Text.Trim(); //商品编号
string gwsl = GridView1.Rows[i].Cells[7].Text.Trim(); //购物数量
string money = GridView1.Rows[i].Cells[8].Text.Trim();
Label1.Text = "数量" + gwsl;
mysql = "UPDATE Products SET 库存数量 = 库存数量 - " + gwsl
+ "WHERE 商品编号 = '" + spno + "'";
mydb.ExecuteNonQuery(mysql);
zsl += int.Parse(gwsl);
zjr += int.Parse(money);
}
Session["zsl"] = zsl;
Session["zjr"] = zjr;
//求订单编号
mysql = "SELECT COUNT( * ) FROM (SELECT distinct 订单号 FROM Sales) tmp";
string dds = mydb.ExecuteAggregateQuery(mysql); //求订单数
string ndds = (int.Parse(dds) + 1).ToString(); //新订单编号
Session["ndds"] = ndds;
//将订单的顾客信息插入OrderForm(顾客信息)表
string name, dq, sf, cs, xm, dz, yx, th;
mysql = "SELECT 姓名,地区,省份,市,县,住址,邮箱,电话 FROM Customers " +
"WHERE 用户名 = '" + Session["uname"] + "'";
myds = mydb.ExecuteQuery(mysql, "Customers");
DataRow mydr = myds.Tables["Customers"].Rows[0];//获取查询结果第一行
name = mydr["姓名"].ToString().Trim();
dq = mydr["地区"].ToString().Trim();
sf = mydr["省份"].ToString().Trim();
cs = mydr["市"].ToString().Trim();
xm = mydr["县"].ToString().Trim();
dz = mydr["住址"].ToString().Trim();
yx = mydr["邮箱"].ToString().Trim();
th = mydr["电话"].ToString().Trim();
Session["name"] = name; //收件人姓名
Session["sjrdz"] = sf + cs + xm + dz; //收件人地址
Session["th"] = th;
mysql = "INSERT INTO OrderForm(订单号,日期,用户名,姓名,地区,省份,市,县,住址,邮箱,电话,总数量,总金额,处理否,结算否) VALUES("
+ ndds + ",'" + DateTime.Now + "','" + Session["uname"] + "','"
+ name + "','" + dq + "','" + sf + "','" + cs + "','"
+ xm + "','" + dz + "','" + yx + "','" + th + "',"
+ Session["zsl"] + "," + Session["zjr"] + ",0,0)";
Label1.Text = mysql;
mydb.ExecuteNonQuery(mysql);
//将购物车全部信息移动到Sales中
for (i = 0; i < GridView1.Rows.Count; i++)
{
mysql = "INSERT INTO Sales(订单号,日期,用户名,商品编号,分类,子类,品牌,型号,单价,数量,金额) "
+ "VALUES ( " + ndds + ",'"
+ DateTime.Now + "','"
+ Session["uname"] + "','"
+ GridView1.Rows[i].Cells[0].Text.Trim() + "','"
+ GridView1.Rows[i].Cells[1].Text.Trim() + "','"
+ GridView1.Rows[i].Cells[2].Text.Trim() + "','"
+ GridView1.Rows[i].Cells[3].Text.Trim() + "','"
+ GridView1.Rows[i].Cells[4].Text.Trim() + "',"
+ GridView1.Rows[i].Cells[5].Text.Trim() + ","
+ GridView1.Rows[i].Cells[7].Text.Trim() + ","
+ GridView1.Rows[i].Cells[8].Text.Trim() + ")";
mydb.ExecuteNonQuery(mysql);
}
mysql = "DELETE ShoppingCart WHERE 用户名 = '" + Session["uname"] + "'";
mydb.ExecuteNonQuery(mysql);
Response.Redirect("Orderform.aspx");
}
