private void button3_Click(object sender, EventArgs e)//购票
{
orno++;
string id = login.Id;
try
{
string date = dateTimePicker1.Value.ToString("yyyy/MM/dd");
string sql = string.Format("insert into orders(orno,fno,fclass,date,price,idno) values('{0}',N'{1}',N'{2}',N'{3}',N'{4}','{5}')", orno, dataGridView1.CurrentRow.Cells[0].Value.ToString(), dataGridView1.CurrentRow.Cells[1].Value.ToString(), date, dataGridView1.CurrentRow.Cells[2].Value.ToString(), id);
//MessageBox.Show(sql);
// string sql3 = string.Format("insert into returns(reno,fno,fclass,date,price,idno) values('{0}',N'{1}',N'{2}',N'{3}',N'{4}','{5}')", orno, dataGridView1.CurrentRow.Cells[0].Value.ToString(), dataGridView1.CurrentRow.Cells[1].Value.ToString(), date, dataGridView1.CurrentRow.Cells[2].Value.ToString(), id);
// SqlCommand com = new SqlCommand();
//com.CommandText = "select yupiao from ticket";
//SqlDataReader dr = com.ExecuteReader();
//if (dr.Read())
//{
// if (String.Equals(dr[0].ToString(), "0"))
// //if(dr[0].ToString()=='0')
// {
// MessageBox.Show("余票以为0，不能购买！");
// }
//}
string sql2 = "update ticket set yupiao=yupiao-1";
// MessageBox.Show(sql);
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand(sql2, conn);
cmd2.ExecuteNonQuery();
// SqlCommand cmd3 = new SqlCommand(sql3, conn);
// cmd3.ExecuteNonQuery();
订单信息 a = new 订单信息();
a.ShowDialog();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.DialogResult = DialogResult.Cancel;
}
private void 订单ToolStripMenuItem_Click(object sender, EventArgs e)
{
订单信息 a = new 订单信息();
a.Show();
}
