private void button_extension_Click(object sender, EventArgs e) { try { foreach (DataGridViewRow item in dataGridView1.SelectedRows) { name = item.Cells[1].Value.ToString(); id = Convert.ToInt32(item.Cells[0].Value.ToString()); tuition = Convert.ToInt32(item.Cells[2].Value.ToString()); teacher_id = Convert.ToInt32(item.Cells[3].Value.ToString()); } Subject_Add subject_add = new Subject_Add(); subject_add.Passvalue_id = id; subject_add.Passvalue_name = name; subject_add.Passvalue_num = 1; subject_add.Passvalue_techer = teacher_id; subject_add.Passvalue_tuition = tuition; subject_add.ShowDialog(); } catch (Exception exception) { MessageBox.Show("과목을 선택해주세요", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } string query = "SELECT id as 과목번호, name as 과목명, tuition as 수강료, teacher_id as 강사번호 FROM SUBJECT ORDER BY ID ASC"; OracleDataReader rdr = DBManager.GetInstance().ExecuteReader(query); dataGridView1.DataSource = null; DataTable dt = new DataTable(); dt.Load(rdr); dataGridView1.DataSource = dt; }
public Subject() { InitializeComponent(); aa = false; DBManager.GetInstance().DBConnection(oracleConnection1); string query = "SELECT id as 과목번호, name as 과목명, tuition as 수강료, teacher_id as 강사번호 FROM SUBJECT ORDER BY ID ASC"; OracleDataReader rdr = DBManager.GetInstance().ExecuteReader(query); dataGridView1.DataSource = null; DataTable dt = new DataTable(); dt.Load(rdr); dataGridView1.DataSource = dt; comboBox_Search.Items.Add("과목번호"); comboBox_Search.Items.Add("과목명"); comboBox_Search.Items.Add("수강료"); comboBox_Search.Items.Add("강사번호"); comboBox_Search.Items.Add("월"); query = "select DISTINCT to_char(sub1.day, 'yyyy') AS yyyy FROM register rt1, subject sub1 WHERE rt1.subject_id = sub1.id"; OracleDataReader rdr_year = DBManager.GetInstance().ExecuteReader(query); while (rdr_year.Read()) { comboBox_year.Items.Add(rdr_year["yyyy"]); } chart1.Titles.Add("과목 별 수강생 수 변화"); chart1.Titles[0].Font = new Font(new FontFamily("휴먼모음T"), 15.75f, FontStyle.Bold); }
private void button_Del_Click(object sender, EventArgs e) { string key; DialogResult result = MessageBox.Show("삭제하시겠습니까?", "알림", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { foreach (DataGridViewRow item in dataGridView1.SelectedRows) { key = item.Cells[0].Value.ToString(); string query = "DELETE FROM attendence WHERE lecture_sub_ID = " + Convert.ToInt32(key) + ""; int rdr3 = DBManager.GetInstance().ExecuteNon(query); query = "DELETE FROM register WHERE subject_ID = " + Convert.ToInt32(key) + ""; //삭제 rdr3 = DBManager.GetInstance().ExecuteNon(query); string query_lecture_del = "DELETE FROM LECTURE WHERE subject_ID = " + Convert.ToInt32(key) + ""; //삭제 rdr3 = DBManager.GetInstance().ExecuteNon(query_lecture_del); query = "DELETE FROM SUBJECT WHERE ID = " + Convert.ToInt32(key) + ""; //삭제 rdr3 = DBManager.GetInstance().ExecuteNon(query); string query2 = "SELECT id as 과목번호, name as 과목명, tuition as 수강료, teacher_id as 강사번호 FROM SUBJECT ORDER BY ID ASC"; //데이터 그리드뷰 초기화 OracleDataReader rdr2 = DBManager.GetInstance().ExecuteReader(query2); DataTable dt = new DataTable(); dt.Load(rdr2); dataGridView1.DataSource = dt; } } }
private void button1_Click(object sender, EventArgs e) { string query = "SELECT id as 과목번호, name as 과목명, tuition as 수강료, teacher_id as 강사번호 FROM SUBJECT ORDER BY ID ASC"; OracleDataReader rdr = DBManager.GetInstance().ExecuteReader(query); dataGridView1.DataSource = null; dataGridView2.DataSource = null; DataTable dt = new DataTable(); dt.Load(rdr); dataGridView1.DataSource = dt; }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { string subjectID = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); // 과목아이디 받아오기 string query = "SELECT id as 과목번호, name as 과목명, tuition as 수강료, teacher_id as 강사번호 FROM SUBJECT ORDER BY ID ASC"; OracleDataReader rdr = DBManager.GetInstance().ExecuteReader(query); dataGridView1.DataSource = null; DataTable dt = new DataTable(); dt.Load(rdr); dataGridView1.DataSource = dt; query = "SELECT * FROM LECTURE WHERE SUBJECT_ID = " + Convert.ToInt32(subjectID) + " ORDER BY DAY ASC"; rdr = DBManager.GetInstance().ExecuteReader(query); dt = new DataTable(); dt.Load(rdr); dataGridView2.DataSource = dt; }
private void button_Add_Click(object sender, EventArgs e) { int y = textIsFull(); if (y == 3) { return; } string query_ex = "SELECT id From teacher"; OracleDataReader rdr_ex = DBManager.GetInstance().ExecuteReader(query_ex); while (rdr_ex.Read()) { if (!textBox_TeacherID.Text.Equals(rdr_ex["id"].ToString())) { MessageBox.Show("없는 강사번호입니다.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } query_ex = "SELECT room From room"; rdr_ex = DBManager.GetInstance().ExecuteReader(query_ex); while (rdr_ex.Read()) { if (!textBox_RoomNum.Text.Equals(rdr_ex["room"].ToString())) { MessageBox.Show("없는 강의실입니다.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } //과목 추가 int tuition = Convert.ToInt32(textBox_tuition.Text); int teacherID = Convert.ToInt32(textBox_TeacherID.Text); string year = textBox_year.Text.ToString(); //if(textBox_month.Text) string month = textBox_month.Text.ToString(); string subjectName = textBox_Subname.Text.ToString(); string Room = textBox_RoomNum.Text; ////강의1 추가 string week_1 = textBox_week1.Text; string week_2 = textBox_week2.Text; //시간비교를 위해 입력받은 값을 인트형으로 변환 string[] temp = textBox_Start1.Text.Split(':'); int time_StartTime1 = Convert.ToInt32(temp[0] + temp[1]); temp = textBox_End1.Text.Split(':'); int time_EndTime1 = Convert.ToInt32(temp[0] + temp[1]); temp = textBox_Start2.Text.Split(':'); int time_StartTime2 = Convert.ToInt32(temp[0] + temp[1]); temp = textBox_End2.Text.Split(':'); int time_EndTime2 = Convert.ToInt32(temp[0] + temp[1]); DateTime dateTime2 = DateTime.ParseExact("" + year + "" + month + "01", "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture); //강의 시간 입력하기 int lectureID = 1; DateTime a = dateTime2; bool update = true; //업데이트 조건 최종 true 일 때 if (num == 1) { query_ex = "SELECT subject_id, to_char(DAY, 'HH24mi') AS DAY_TIME, to_char(END_DAY, 'HH24mi') AS END_DAY_TIME, to_char(DAY, 'dy','NLS_DATE_LANGUAGE=korean') AS DAY_WEEK, to_char(DAY, 'mm') AS DAY_MONTH, to_char(DAY, 'yyyy') AS DAY_YEAR, ROOM_NUM FROM LECTURE where to_char(DAY, 'yyyy')='" + textBox_year.Text + "' and to_char(DAY, 'mm')='" + textBox_month.Text + "'"; rdr_ex = DBManager.GetInstance().ExecuteReader(query_ex); while (rdr_ex.Read()) { //비교를 위한 변수들 string sub_id = rdr_ex["subject_id"].ToString(); int time_Day = Convert.ToInt32(rdr_ex["DAY_TIME"]); int time_End_Day = Convert.ToInt32(rdr_ex["END_DAY_TIME"]); string day_week = rdr_ex["DAY_WEEK"].ToString(); string Room_num = rdr_ex["ROOM_NUM"].ToString(); string day_month = rdr_ex["DAY_MONTH"].ToString(); string day_year = rdr_ex["DAY_YEAR"].ToString(); a = dateTime2; if ((id == Convert.ToInt32(sub_id)) && ((day_month.Equals(month)) && year.Equals(day_year))) { MessageBox.Show("이미 있는 달을 입력하셧습니다.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string realmonth = ""; if (a.Month >= 1 && a.Month <= 9) { realmonth = "0" + a.Month.ToString(); } //달이 넘어가면 멈춤 while (realmonth.Equals(month)) { if (year.Equals(day_year)) { //달이 같은지 검사 if (month.Equals(day_month)) { //요일을 한글로 변환해서 받아옴 string week = GetDay(a); //요일이 일치하는지 검사 if (week.Equals(week_1)) { //강의실이 같은지 검사 if (Room_num.Equals(Room)) { //시간 비교 if ((time_Day > time_EndTime1 && time_Day > time_StartTime1) || (time_End_Day < time_EndTime1) && (time_End_Day < time_StartTime1)) { update = true; } else { update = false; MessageBox.Show("이미 " + textBox_week1.Text + "요일의 강의가 있는 시간입니다.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } } if (week.Equals(week_2)) { if (Room_num.Equals(Room)) { if ((time_Day > time_EndTime2 && time_Day > time_StartTime2) || (time_End_Day < time_EndTime2) && (time_End_Day < time_StartTime2)) { update = true; } else { update = false; MessageBox.Show("이미 " + textBox_week2.Text + "요일의 강의가 있는 시간입니다.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } } } } //날을 하루 씩 증가 a = a.AddDays(1); if (a.Month >= 1 && a.Month <= 9) { realmonth = "0" + a.Month.ToString(); } } if (update == false) { break; } } a = dateTime2; string realmonth2 = ""; if (a.Month >= 1 && a.Month <= 9) { realmonth2 = "0" + a.Month.ToString(); } //강의 추가 while (realmonth2.Equals(month)) { if (update == true) { string week = GetDay(a); if (week.Equals(week_1)) { //강의1 추가 string start_time1 = a.ToString("yyyyMMdd"); string end_time1 = a.ToString("yyyyMMdd"); string start = start_time1 + textBox_Start1.Text; string end = end_time1 + textBox_End1.Text; string query3 = "INSERT INTO LECTURE(SUBJECT_ID, ID, DAY, END_DAY, ROOM_NUM)" + "VALUES(" + id + "," + lectureID + ",to_date('" + start + "', 'yyyy-mm-dd hh24:mi'), to_date('" + end + "', 'yyyy-mm-dd hh24:mi'), '" + textBox_RoomNum.Text + "')"; int rdr3 = DBManager.GetInstance().ExecuteNon(query3); lectureID++; } if (week.Equals(week_2)) { //강의2 추가 string start_time2 = a.ToString("yyyyMMdd"); string end_time2 = a.ToString("yyyyMMdd"); string start2 = start_time2 + textBox_Start2.Text; string end2 = end_time2 + textBox_End2.Text; string query3 = "INSERT INTO LECTURE(SUBJECT_ID, ID, DAY, END_DAY, ROOM_NUM)" + "VALUES(" + id + "," + lectureID + ",to_date('" + start2 + "', 'yyyy-mm-dd hh24:mi'), to_date('" + end2 + "', 'yyyy-mm-dd hh24:mi'), '" + textBox_RoomNum.Text + "')"; int rdr3 = DBManager.GetInstance().ExecuteNon(query3); lectureID++; } } //날을 하루 씩 증가 a = a.AddDays(1); if (a.Month >= 1 && a.Month <= 9) { realmonth2 = "0" + a.Month.ToString(); } } } if (num == 1) { return; } lectureID = 1; a = dateTime2; string dateTime = DateParse(DateTime.ParseExact("" + year + "" + month + "", "yyyyMM", System.Globalization.CultureInfo.InvariantCulture).ToString()); string query = "INSERT INTO SUBJECT(ID, NAME, TUITION, TEACHER_ID, DAY)" + "VALUES(SEQ_SUBJECT.nextval,'" + subjectName + "'," + tuition + "," + teacherID + ",to_date('" + dateTime + "', 'yyyy-mm-dd hh24:mi'))"; OracleDataReader rdr = DBManager.GetInstance().ExecuteReader(query); query = "SELECT SEQ_SUBJECT.currval from dual"; int subject_ID = Convert.ToInt32(DBManager.GetInstance().DBSaclar(query)); //과목 추가 query = "SELECT to_char(DAY, 'HH24mi') AS DAY_TIME, to_char(END_DAY, 'HH24mi') AS END_DAY_TIME, to_char(DAY, 'dy','NLS_DATE_LANGUAGE=korean') AS DAY_WEEK, to_char(DAY, 'mm') AS DAY_MONTH, ROOM_NUM FROM LECTURE"; OracleDataReader rdr2 = DBManager.GetInstance().ExecuteReader(query); while (rdr2.Read()) { //비교를 위한 변수들 int time_Day = Convert.ToInt32(rdr2["DAY_TIME"]); int time_End_Day = Convert.ToInt32(rdr2["END_DAY_TIME"]); string day_week = rdr2["DAY_WEEK"].ToString(); string Room_num = rdr2["ROOM_NUM"].ToString(); string day_month = rdr2["DAY_MONTH"].ToString(); a = dateTime2; //달이 넘어가면 멈춤 while (a.Month.ToString().Equals(month)) { //달이 같은지 검사 if (month.Equals(day_month)) { //요일을 한글로 변환해서 받아옴 string week = GetDay(a); //요일이 일치하는지 검사 if (week.Equals(week_1)) { //강의실이 같은지 검사 if (Room_num.Equals(Room)) { //시간 비교 if ((time_Day > time_EndTime1 && time_Day > time_StartTime1) || (time_End_Day < time_EndTime1) && (time_End_Day < time_StartTime1)) { update = true; } else { query = "DELETE FROM SUBJECT WHERE ID = " + subject_ID + ""; int rdr_del = DBManager.GetInstance().ExecuteNon(query); update = false; MessageBox.Show("이미 " + textBox_week1.Text + "요일의 강의가 있는 시간입니다.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } } if (week.Equals(week_2)) { if (Room_num.Equals(Room)) { if ((time_Day > time_EndTime2 && time_Day > time_StartTime2) || (time_End_Day < time_EndTime2) && (time_End_Day < time_StartTime2)) { update = true; } else { query = "DELETE FROM SUBJECT WHERE ID = " + subject_ID + ""; int rdr_del = DBManager.GetInstance().ExecuteNon(query); update = false; MessageBox.Show("이미 " + textBox_week2.Text + "요일의 강의가 있는 시간입니다.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } } } //날을 하루 씩 증가 a = a.AddDays(1); } if (update == false) { break; } } a = dateTime2; //강의 추가 while (a.Month.ToString().Equals(month)) { if (update == true) { string week = GetDay(a); if (week.Equals(week_1)) { //강의1 추가 string start_time1 = a.ToString("yyyyMMdd"); string end_time1 = a.ToString("yyyyMMdd"); string start = start_time1 + textBox_Start1.Text; string end = end_time1 + textBox_End1.Text; string query3 = "INSERT INTO LECTURE(SUBJECT_ID, ID, DAY, END_DAY, ROOM_NUM)" + "VALUES(" + subject_ID + "," + lectureID + ",to_date('" + start + "', 'yyyy-mm-dd hh24:mi'), to_date('" + end + "', 'yyyy-mm-dd hh24:mi'), '" + textBox_RoomNum.Text + "')"; int rdr3 = DBManager.GetInstance().ExecuteNon(query3); lectureID++; } if (week.Equals(week_2)) { //강의2 추가 string start_time2 = a.ToString("yyyyMMdd"); string end_time2 = a.ToString("yyyyMMdd"); string start2 = start_time2 + textBox_Start2.Text; string end2 = end_time2 + textBox_End2.Text; string query3 = "INSERT INTO LECTURE(SUBJECT_ID, ID, DAY, END_DAY, ROOM_NUM)" + "VALUES(" + subject_ID + "," + lectureID + ",to_date('" + start2 + "', 'yyyy-mm-dd hh24:mi'), to_date('" + end2 + "', 'yyyy-mm-dd hh24:mi'), '" + textBox_RoomNum.Text + "')"; int rdr3 = DBManager.GetInstance().ExecuteNon(query3); lectureID++; } } //날을 하루 씩 증가 a = a.AddDays(1); } }
private void button_Search_Click(object sender, EventArgs e) { string x; try { x = comboBox_Search.SelectedItem.ToString(); } catch (Exception exception) { MessageBox.Show("검색키워드를 선택해주십시오.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } switch (x) { case "과목번호": string id = textBox_Search.Text.ToString(); string query = "SELECT * FROM SUBJECT WHERE id = '" + id + "' ORDER BY ID ASC"; OracleDataReader rdr = DBManager.GetInstance().ExecuteReader(query); dataGridView1.DataSource = null; DataTable dt = new DataTable(); dt.Load(rdr); dataGridView1.DataSource = dt; break; case "과목명": string name = textBox_Search.Text.ToString(); query = "SELECT * FROM SUBJECT WHERE name like '" + name + "%' ORDER BY ID ASC"; OracleDataReader rdr_name = DBManager.GetInstance().ExecuteReader(query); dataGridView1.DataSource = null; dt = new DataTable(); dt.Load(rdr_name); dataGridView1.DataSource = dt; break; case "수강료": string tuition = textBox_Search.Text.ToString(); query = "SELECT * FROM SUBJECT WHERE tuition = '" + tuition + "' ORDER BY ID ASC"; OracleDataReader rdr_tuition = DBManager.GetInstance().ExecuteReader(query); dataGridView1.DataSource = null; dt = new DataTable(); dt.Load(rdr_tuition); dataGridView1.DataSource = dt; break; case "강사번호": string teacher_id = textBox_Search.Text.ToString(); query = "SELECT * FROM SUBJECT WHERE teacher_id = '" + teacher_id + "' ORDER BY ID ASC"; OracleDataReader rdr_teacher_id = DBManager.GetInstance().ExecuteReader(query); dataGridView1.DataSource = null; dt = new DataTable(); dt.Load(rdr_teacher_id); dataGridView1.DataSource = dt; break; case "월": try { foreach (DataGridViewRow item in dataGridView1.SelectedRows) { int sub_id = Convert.ToInt32(item.Cells[0].Value.ToString()); } } catch (Exception exception) { MessageBox.Show("과목을 선택해주십시오.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string day = textBox_Search.Text.ToString(); query = "SELECT * FROM lecture WHERE to_char(day, 'mm') = '" + day + "' ORDER BY subject_id, id ASC"; OracleDataReader rdr_day = DBManager.GetInstance().ExecuteReader(query); dataGridView2.DataSource = null; dt = new DataTable(); dt.Load(rdr_day); dataGridView2.DataSource = dt; break; default: MessageBox.Show("데이터가 없습니다", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } }
private void comboBox_year_SelectedIndexChanged(object sender, EventArgs e) { chart1.Series.Clear(); string year = comboBox_year.SelectedItem.ToString(); int month = 1; string mm; for (int i = 1; i < 13; i++) { if (i >= 1 && i < 10) { mm = "0" + i.ToString(); } else { mm = i.ToString(); } string query = "select subject.name subname, qq.a, qq.b from subject, (select count(*) a, register.subject_id b from register join subject on subject.id = register.subject_id where to_char(register.day, 'yyyymm')='" + comboBox_year.Text + mm + "' group by register.subject_id) qq where subject.id = qq.b"; OracleDataReader rdr2 = DBManager.GetInstance().ExecuteReader(query); if (rdr2.HasRows) { while (rdr2.Read()) { string subname = rdr2["subname"].ToString(); if (chart1.Series.IsUniqueName(subname) is false) { chart1.Series.Add(rdr2["subname"].ToString()); } else { chart1.Series["subname"].Points.AddXY(mm, Convert.ToInt32(rdr2["a"])); } } } } /* * while (rdr2.Read()) * { * int mm = Convert.ToInt32(rdr2["mm"]); * string name = rdr2["sub_name"].ToString() + "-" + rdr2["id"].ToString(); * * while (true) * { * if (chart1.Series.IsUniqueName(name) is false) * { * for (month = 1; month < 13; month++) * { * if (mm == month) * { * chart1.Series[name].Points.AddXY(month, Convert.ToInt32(rdr2["stu_num"])); * } * else * { * chart1.Series[name].Points.AddXY(month, 0); * } * } * break; * } * else * { * chart1.Series.Add(name); * chart1.Series[name].ChartType = SeriesChartType.Line; * } * } * }*/ }
static bool update = true; //업데이트 조건 최종 true 일 때 업데이트 private void button_Save_Click(object sender, EventArgs e) { string key; string name; string tuition; string teacher_id; int start_time; int end_time; string room_num; DialogResult result = MessageBox.Show("수정하시겠습니까?", "알림", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { for (int i = 0; i < dataGridView1.Rows.Count; i++) { key = dataGridView1.Rows[i].Cells[0].Value.ToString(); name = dataGridView1.Rows[i].Cells[1].Value.ToString(); tuition = dataGridView1.Rows[i].Cells[2].Value.ToString(); teacher_id = dataGridView1.Rows[i].Cells[3].Value.ToString(); string query = "UPDATE SUBJECT set name = '" + name + "' tuition = '" + Convert.ToInt32(tuition) + "', teacher_id = '" + Convert.ToInt32(teacher_id) + "' where id = " + Convert.ToInt32(key) + ""; int rdr2 = DBManager.GetInstance().ExecuteNon(query); } for (int i = 0; i < dataGridView2.Rows.Count; i++) { //데이터 그리드뷰 모든 데이터 int sub_id = Convert.ToInt32(dataGridView2.Rows[i].Cells[0].Value.ToString()); int id = Convert.ToInt32(dataGridView2.Rows[i].Cells[1].Value.ToString()); start_time = Convert.ToInt32(DateParse_time(dataGridView2.Rows[i].Cells[2].Value.ToString())); end_time = Convert.ToInt32(DateParse_time(dataGridView2.Rows[i].Cells[3].Value.ToString())); room_num = dataGridView2.Rows[i].Cells[4].Value.ToString(); string supply = dataGridView2.Rows[i].Cells[5].Value.ToString(); //날짜 비교를 위한 변수 string week_ = DateParse_day(dataGridView2.Rows[i].Cells[2].Value.ToString()); //시작시간, 끝시간, 날짜, 방번호, 과목번호를 받아온다. 단, 수정하려는 데이터의 강의는 제외한다. string query = "SELECT to_char(DAY, 'HH24mi') AS DAY_TIME, to_char(END_DAY, 'HH24mi') AS END_DAY_TIME, to_char(DAY, 'yyyy-MM-dd') AS DAY_WEEK, ROOM_NUM, subject_id FROM LECTURE where subject_id not in (" + sub_id + ")"; OracleDataReader rdr2 = DBManager.GetInstance().ExecuteReader(query); while (rdr2.Read()) { int time_Day = Convert.ToInt32(rdr2["DAY_TIME"]); int time_End_Day = Convert.ToInt32(rdr2["END_DAY_TIME"]); string day_week = rdr2["DAY_WEEK"].ToString(); string Room_num_ = rdr2["ROOM_NUM"].ToString(); int date_sub_id = Convert.ToInt32(rdr2["subject_id"]); if (week_.Equals(day_week)) { if ((time_Day > end_time && time_Day > start_time) || (time_End_Day < end_time) && (time_End_Day < start_time)) { if (Room_num_.Equals(room_num)) { update = true; } } else { update = false; MessageBox.Show("이미 강의가 있는 시간입니다. 시간표를 확인하십시오", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } } if (update == true) { query = "update lecture set day = to_date('" + DateParse(dataGridView2.Rows[i].Cells[2].Value.ToString()) + "', 'yyyy-mm-dd hh24:mi'), end_day = to_date('" + DateParse(dataGridView2.Rows[i].Cells[3].Value.ToString()) + "', 'yyyy-mm-dd hh24:mi'), room_num = '" + room_num + "' where subject_id = " + sub_id + " AND id = " + id + ""; int rdr3 = DBManager.GetInstance().ExecuteNon(query); } } } }