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