private void RESET_Click(object sender, EventArgs e) { MySqlConnection myConnection = new MySqlConnection(connectionString); myConnection.Open(); PlanInfoDAC dac = new PlanInfoDAC(myConnection); DataTable line1 = dac.SelectLine("1번라인").Tables[0]; DataTable line2 = dac.SelectLine("2번라인").Tables[0]; DataTable line3 = dac.SelectLine("3번라인").Tables[0]; DataTable line4 = dac.SelectLine("4번라인").Tables[0]; Line1_Grid.DataSource = line1; Line1_Grid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; Line2_Grid.DataSource = line2; Line2_Grid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; Line3_Grid.DataSource = line3; Line3_Grid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; Line4_Grid.DataSource = line4; Line4_Grid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; //예약 -> 주황색, 가동중 -> 초록색, null - > 빨강 //red_Circle.png orange_Circle green_Circle ShowLineSituation(line1, Line1_LightPicture); ShowLineSituation(line2, Line2_LightPicture); ShowLineSituation(line3, Line3_LightPicture); ShowLineSituation(line4, Line4_LightPicture); myConnection.Close(); }
} //cell 더블클릭 이벤트 추가예정 private void button2_Click_1(object sender, EventArgs e) //예약(O) { MySqlConnection myConnection = new MySqlConnection(connectionString); myConnection.Open(); int ID = 0; try { PlanInfoDAC dac = new PlanInfoDAC(myConnection); DataTable dt = new DataTable(); dt = dac.SelectMaxId().Tables[0]; if (dt.Rows[0][0].ToString() == "") { ID = 1; } else { ID = Convert.ToInt16(dt.Rows[0][0].ToString()) + 1; } PlanInfo item = new PlanInfo(); item.입력날짜 = DateTime.Now; item.라인 = SelectProductionLine.Text; item.목표수 = Convert.ToInt16(Line_num.Text); item.상황 = "예약"; item.제품명 = Line_Product.Text; item.ID = ID; dac.Insert(item); LinePlanGrid.DataSource = dac.SelectSituation("예약").Tables[0]; LinePlanGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; MessageBox.Show("입력이 완료되었습니다."); myConnection.Close(); } catch (Exception) { MessageBox.Show("제품명 , 제품 수량 , 생산 라인을 입력해주세요."); } finally { if (myConnection != null && myConnection.State == System.Data.ConnectionState.Open) { myConnection.Close(); } } Line_num.Clear(); }
private void Page_planTab_SelectedIndexChanged_1(object sender, EventArgs e) // O { MySqlConnection myConnection = new MySqlConnection(connectionString); myConnection.Open(); if (Page_planTab.SelectedIndex == 0) { PlanInfoDAC dac = new PlanInfoDAC(myConnection); LinePlanGrid.DataSource = dac.SelectSituation("예약").Tables[0]; LinePlanGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } if (Page_planTab.SelectedIndex == 1) { RESET_Click(sender, e); } }
private void Delete_Plan_Click_1(object sender, EventArgs e) //예약 취소 { MySqlConnection myConnection = null; try { myConnection = new MySqlConnection(connectionString); myConnection.Open(); PlanInfoDAC dac = new PlanInfoDAC(myConnection); string ID = LinePlanGrid[5, LinePlanGrid.SelectedRows[0].Index].Value.ToString(); PlanInfo item = new PlanInfo(); item.제품명 = Line_Product.Text; item.ID = Convert.ToInt32(ID); dac.DeleteDB(item); LinePlanGrid.DataSource = dac.SelectSituation("예약").Tables[0]; LinePlanGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; myConnection.Close(); } catch (MySqlException) { MessageBox.Show("셀을 선택해주세요."); } finally { if (myConnection != null && myConnection.State == System.Data.ConnectionState.Open) { myConnection.Close(); } } }
private void timer1_Tick(object sender, EventArgs e) { MySqlConnection myConnection = new MySqlConnection(connectionString); myConnection.Open(); PlanInfoDAC dac = new PlanInfoDAC(myConnection); DataTable dt = dac.SelectSituation("중지").Tables[0]; // 1개만 서치 if (dt.Rows.Count != 0) { timer1.Enabled = false; if (MessageBox.Show("재가동 하시겠습니까 ?", dt.Rows[0][3].ToString() + dt.Rows[0][4].ToString(), MessageBoxButtons.OK) == DialogResult.OK) { PlanInfo item = new PlanInfo(); item.ID = Convert.ToInt32(dt.Rows[0][5].ToString()); dac.UpdateID(item); myConnection.Close(); timer1.Enabled = true; } } }