private void button5_Click(object sender, EventArgs e)
{
for (int i = 0; i < (dataGridView2.Rows.Count) - 1; i++)
{
string userid, goodid, num, amount;
userid = DataBusiness.userid;
goodid = dataGridView2.Rows[i].Cells["商品ID"].Value.ToString();
num = dataGridView2.Rows[i].Cells["数量"].Value.ToString();
amount = dataGridView2.Rows[i].Cells["总价"].Value.ToString();
string sql = string.Format("insert into 购买ID综合 values ('{0}','{1}','{2}','{3}',getdate(),'','',null,null)", userid, goodid, num, amount);
DataBusiness.NonQuery(sql);
string balance = string.Format("update 用户信息 set 账户余额=账户余额-{0} where 用户ID={1}", amount, DataBusiness.userid);
DataBusiness.NonQuery(balance);
string inven = string.Format("update 库存提醒 set 实时库存=实时库存-{0} where 商品ID={1}", num, goodid);
DataBusiness.NonQuery(inven);
}
MessageBox.Show("下单成功");
string delete = string.Format("delete from 购物车 where 用户ID={0}", DataBusiness.userid);
DataBusiness.NonQuery(delete);
checkcart();
checkbalance();
label7.Text = DataBusiness.balance;
}
private void button4_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定删除", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.OK)
{
string str = dataGridView1.SelectedRows[0].Cells["用户ID"].Value.ToString();/////获取datagridview特定行列的数值
string cmdText = "Delete from 用户信息 where 用户ID=" + str + "";
DataBusiness.NonQuery(cmdText);
get_users();
}
}
private void button4_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定删除", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.OK)
{
string str = dataGridView2.CurrentRow.Cells["商品ID"].Value.ToString();/////获取datagridview特定行列的数值
string cmdText = "Delete from 购物车 where 用户ID='" + DataBusiness.userid + "' and 商品ID='" + str + "'";
DataBusiness.NonQuery(cmdText);
checkcart();
}
}