private void Select_Click(object sender, EventArgs e) { SeatSelect seatSelect = new SeatSelect(); seatSelect.ShowDialog(); }
private void SelectSeat(object sender, DataGridViewCellEventArgs e)////************ { if (e.RowIndex < 0) { return; } MessageBox.Show("운행 기본 요금은 1인당 " + cost + "원 입니다"); int count = 0; for (int i = 1; i <= 2; ++i) { for (int j = 1; j <= 4; ++j) { seatArray[i, j] = 0; } } DataTable dtStatus; drow = dataGridView2.Rows[e.RowIndex]; string t_ID = drow.Cells[0].Value.ToString(); string startStation = drow.Cells[1].Value.ToString(); string startTime = drow.Cells[3].Value.ToString(); for (int i = 1; i <= 2; ++i) { for (int j = 1; j <= 4; ++j) { try { seaT_STATUSTableAdapter1.FillByStatus(dataSet11.SEAT_STATUS, i, j, t_ID, startStation, direc, startTime); // START_TIME 확인할 것 ** dtStatus = dataSet11.SEAT_STATUS; foreach (DataRow drStatus in dtStatus.Rows) { if (drStatus["STATUS"].ToString().Equals("1")) { seatArray[i, j] = 1; count++; } } } catch (SystemException ex) { // MessageBox.Show(ex.Message); } } } while (true) { cmdSeatHelper.Parameters["T_ID"].Value = t_ID; cmdSeatHelper.Parameters["ST"].Value = startStation; cmdSeatHelper.Parameters["DIREC"].Value = direc; OracleDataReader rdr = cmdSeatHelper.ExecuteReader(); rdr.Read(); startStation = rdr["ST_NAME"].ToString(); if (startStation.Equals("부산") || startStation.Equals("서울")) { break; } else if (startStation.Equals(cb_end.Text)) { break; } startTime = rdr["START_TIME"].ToString(); for (int i = 1; i <= 2; ++i) { for (int j = 1; j <= 4; ++j) { try { // 열차번호, 현재 역, 방향, 출발 시간 seaT_STATUSTableAdapter1.FillByStatus(dataSet11.SEAT_STATUS, i, j, t_ID, startStation, direc, startTime); // START_TIME 확인할 것 ** dtStatus = dataSet11.SEAT_STATUS; foreach (DataRow drStatus in dtStatus.Rows) { if (drStatus["STATUS"].ToString().Equals("1")) // 예약이 있을 때 { seatArray[i, j] = 1; count++; } } } catch (SystemException ex) { // MessageBox.Show(ex.Message); } } } } ////////////////////////////////////////////////////////////////////////////// for (int i = 0; i < 3; ++i) { for (int j = 0; j < 5; ++j) { arr[i, j] = 0; } } /////////////////////********************************** if (direc.Equals("서울행")) { startStation = "부산"; } else { startStation = "서울"; } for (int i = 1; i <= 2; ++i) { for (int j = 1; j <= 4; ++j) { try { seaT_STATUSTableAdapter1.FillByTEST(dataSet11.SEAT_STATUS, i, j, t_ID, startStation, direc); dtStatus = dataSet11.SEAT_STATUS; foreach (DataRow drStatus in dtStatus.Rows) { if (drStatus["STATUS"].ToString().Equals("0")) { arr[i, j]++; } } } catch (SystemException) { // MessageBox.Show(ex.Message); } } } while (true) { cmdSeatHelper.Parameters["T_ID"].Value = t_ID; cmdSeatHelper.Parameters["ST"].Value = startStation; cmdSeatHelper.Parameters["DIREC"].Value = direc; OracleDataReader rdr = cmdSeatHelper.ExecuteReader(); rdr.Read(); // MessageBox.Show(rdr["ST_NAME"].ToString()); startStation = rdr["ST_NAME"].ToString(); if (startStation.Equals("부산") || startStation.Equals("서울")) { break; } for (int i = 1; i <= 2; ++i) { for (int j = 1; j <= 4; ++j) { try { seaT_STATUSTableAdapter1.FillByTEST(dataSet11.SEAT_STATUS, i, j, t_ID, startStation, direc); dtStatus = dataSet11.SEAT_STATUS; foreach (DataRow drStatus in dtStatus.Rows) { if (drStatus["STATUS"].ToString().Equals("0")) { arr[i, j]++; } } } catch (SystemException) { // MessageBox.Show(ex.Message); } } } } ///////////////////////////////////////////////////////////////////////////////////////// SeatSelect seatSelect = new SeatSelect(); seatSelect.ShowDialog(); }