private void reservation_Click(object sender, EventArgs e) //예약 버튼 { Insert.CommandText = "select RES_NUM.nextval from dual"; //현재 시퀀스 번호 seq = Convert.ToInt64(Insert.ExecuteScalar()); MessageBox.Show(seq.ToString()); CheckBox[] checkbox = new CheckBox[] { num1, num2, num3, num4, num_1, num_2, num_3, num_4 }; foreach (CheckBox c in checkbox) { int test = Convert.ToInt32(c.Text); if (test <= 4) { if (c.Checked == true) { class_num = "1호차"; switch (c.Text) { case "1": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room1.Text, t_state, seq); break; case "2": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room1.Text, t_state, seq); break; case "3": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room1.Text, t_state, seq); break; case "4": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room1.Text, t_state, seq); break; } } } else { if (c.Checked == true) { class_num = "2호차"; switch (c.Text) { case "5": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room2.Text, t_state, seq); break; case "6": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room2.Text, t_state, seq); break; case "7": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room2.Text, t_state, seq); break; case "8": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room2.Text, t_state, seq); break; } } } } this.memberTableAdapter1.UpdateQuery(seq, mainPage.M_ID);//회원이 예약하면 예약번호 할당 MessageBox.Show("Reservation 테이블에 삽입"); book2 form = new book2(); form.ShowDialog(); this.Dispose(); }