private void button3_Click(object sender, EventArgs e)
{
dttable1 = TestToConnectMySQLServer.FillData(sql1, connection);
dttable2 = TestToConnectMySQLServer.FillData(sql2, connection);
dttable3 = TestToConnectMySQLServer.FillData(sql3, connection);
dttable4 = TestToConnectMySQLServer.FillData(sql4, connection);
DataTable dtReturn = Pivot.GetFixedPivotTable(dttable2, "Date", "Line", "SA_SN", "0", "Count", columnHeaderInput);
DataTable dtReturn2 = Pivot.GetFixedPivotTable(dttable3, "Date", "Line", "SA_SN", "0", "Count", columnHeaderInput);
dataGridView1.DataSource = dttable1.DefaultView;
dataGridView2.DataSource = dtReturn.DefaultView;
dataGridView3.DataSource = dtReturn2.DefaultView;
dataGridView4.DataSource = dttable4.DefaultView;
Pivot.GetDivisionCellFormat(dataGridView2, dataGridView3, rejectHighlightQty);
dataGridView3.DataSource = null;
dataGridView3.DataSource = Pivot.GetPercentagePivotTable(dtReturn2, "Total").DefaultView;
textBox1.Text = ("Last Refresh: " + DateTime.Now.ToLongTimeString());
}
public void GenerateTable(string selectedShift)
{
if (selectedShift == "2-Shift" && DateTime.Now.Hour >= breakShiftMorning.Hours && DateTime.Now.Hour < breakShiftAfternoon2.Hours)
{
columnHeaderInput.Clear();
columnHeaderInput.Add("07");
columnHeaderInput.Add("08");
columnHeaderInput.Add("09");
columnHeaderInput.Add("10");
columnHeaderInput.Add("11");
columnHeaderInput.Add("12");
columnHeaderInput.Add("13");
columnHeaderInput.Add("14");
columnHeaderInput.Add("15");
}
else if (selectedShift == "2-Shift" && (DateTime.Now.Hour >= breakShiftAfternoon2.Hours || DateTime.Now.Hour < breakShiftNight2.Hours))
{
columnHeaderInput.Clear();
columnHeaderInput.Add("16");
columnHeaderInput.Add("17");
columnHeaderInput.Add("18");
columnHeaderInput.Add("19");
columnHeaderInput.Add("20");
columnHeaderInput.Add("21");
columnHeaderInput.Add("22");
columnHeaderInput.Add("23");
columnHeaderInput.Add("00");
}
else if (selectedShift == "3-Shift" && DateTime.Now.Hour >= breakShiftMorning.Hours && DateTime.Now.Hour < breakShiftAfternoon3.Hours)
{
columnHeaderInput.Clear();
columnHeaderInput.Add("07");
columnHeaderInput.Add("08");
columnHeaderInput.Add("09");
columnHeaderInput.Add("10");
columnHeaderInput.Add("11");
columnHeaderInput.Add("12");
columnHeaderInput.Add("13");
columnHeaderInput.Add("14");
}
else if (selectedShift == "3-Shift" && DateTime.Now.Hour >= breakShiftAfternoon3.Hours && DateTime.Now.Hour < breakShiftNight3.Hours)
{
columnHeaderInput.Clear();
columnHeaderInput.Add("15");
columnHeaderInput.Add("16");
columnHeaderInput.Add("17");
columnHeaderInput.Add("18");
columnHeaderInput.Add("19");
columnHeaderInput.Add("20");
columnHeaderInput.Add("21");
columnHeaderInput.Add("22");
}
else
{
columnHeaderInput.Clear();
columnHeaderInput.Add("23");
columnHeaderInput.Add("00");
columnHeaderInput.Add("01");
columnHeaderInput.Add("02");
columnHeaderInput.Add("03");
columnHeaderInput.Add("04");
columnHeaderInput.Add("05");
columnHeaderInput.Add("06");
}
dataGridView1.DataSource = null;
dataGridView2.DataSource = null;
dataGridView3.DataSource = null;
dataGridView4.DataSource = null;
DataTable dtReturn = Pivot.GetFixedPivotTable(dttable2, "Date", "Line", "SA_SN", "0", "Count", columnHeaderInput);
DataTable dtReturn2 = Pivot.GetFixedPivotTable(dttable3, "Date", "Line", "SA_SN", "0", "Count", columnHeaderInput);
dataGridView1.DataSource = dttable1.DefaultView;
dataGridView2.DataSource = dtReturn.DefaultView;
dataGridView3.DataSource = dtReturn2.DefaultView;
dataGridView4.DataSource = dttable4.DefaultView;
Pivot.GetDivisionCellFormat(dataGridView2, dataGridView3, rejectHighlightQty);
dataGridView3.DataSource = null;
dataGridView3.DataSource = Pivot.GetPercentagePivotTable(dtReturn2, "Total").DefaultView;
}