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(); }