private void button_Save_Click(object sender, EventArgs e) { var custom1 = new Dashboard_CustomGroup(); custom1.groupName = "Custom_1"; custom1.lineId_1 = (comboBox_Custom1_1.SelectedItem ?? "").ToString(); custom1.lineId_2 = (comboBox_Custom1_2.SelectedItem ?? "").ToString(); custom1.lineId_3 = (comboBox_Custom1_3.SelectedItem ?? "").ToString(); custom1.lineId_4 = (comboBox_Custom1_4.SelectedItem ?? "").ToString(); custom1.lineId_5 = (comboBox_Custom1_5.SelectedItem ?? "").ToString(); custom1.lineId_6 = (comboBox_Custom1_6.SelectedItem ?? "").ToString(); custom1.lineId_7 = (comboBox_Custom1_7.SelectedItem ?? "").ToString(); custom1.lineId_8 = (comboBox_Custom1_8.SelectedItem ?? "").ToString(); var custom2 = new Dashboard_CustomGroup(); custom2.groupName = "Custom_2"; custom2.lineId_1 = (comboBox_Custom2_1.SelectedItem ?? "").ToString(); custom2.lineId_2 = (comboBox_Custom2_2.SelectedItem ?? "").ToString(); custom2.lineId_3 = (comboBox_Custom2_3.SelectedItem ?? "").ToString(); custom2.lineId_4 = (comboBox_Custom2_4.SelectedItem ?? "").ToString(); custom2.lineId_5 = (comboBox_Custom2_5.SelectedItem ?? "").ToString(); custom2.lineId_6 = (comboBox_Custom2_6.SelectedItem ?? "").ToString(); custom2.lineId_7 = (comboBox_Custom2_7.SelectedItem ?? "").ToString(); custom2.lineId_8 = (comboBox_Custom2_8.SelectedItem ?? "").ToString(); var custom3 = new Dashboard_CustomGroup(); custom3.groupName = "Custom_3"; custom3.lineId_1 = (comboBox_Custom3_1.SelectedItem ?? "").ToString(); custom3.lineId_2 = (comboBox_Custom3_2.SelectedItem ?? "").ToString(); custom3.lineId_3 = (comboBox_Custom3_3.SelectedItem ?? "").ToString(); custom3.lineId_4 = (comboBox_Custom3_4.SelectedItem ?? "").ToString(); custom3.lineId_5 = (comboBox_Custom3_5.SelectedItem ?? "").ToString(); custom3.lineId_6 = (comboBox_Custom3_6.SelectedItem ?? "").ToString(); custom3.lineId_7 = (comboBox_Custom3_7.SelectedItem ?? "").ToString(); custom3.lineId_8 = (comboBox_Custom3_8.SelectedItem ?? "").ToString(); try { // Custom 1 var checkCustom1 = db.Dashboard_CustomGroup.AsNoTracking() .Where(x => x.groupName == "Custom_1") .Select(x => x.ID).FirstOrDefault(); if(checkCustom1 == 0) { db.Dashboard_CustomGroup.Add(custom1); } else { var domain = db.Dashboard_CustomGroup.Find(checkCustom1); domain.lineId_1 = custom1.lineId_1; domain.lineId_2 = custom1.lineId_2; domain.lineId_3 = custom1.lineId_3; domain.lineId_4 = custom1.lineId_4; domain.lineId_5 = custom1.lineId_5; domain.lineId_6 = custom1.lineId_6; domain.lineId_7 = custom1.lineId_7; domain.lineId_8 = custom1.lineId_8; var entry = db.Entry(domain); entry.State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } // Custom 2 var checkCustom2 = db.Dashboard_CustomGroup.AsNoTracking() .Where(x => x.groupName == "Custom_2") .Select(x => x.ID).FirstOrDefault(); if (checkCustom2 == 0) { db.Dashboard_CustomGroup.Add(custom2); db.SaveChanges(); } else { var domain = db.Dashboard_CustomGroup.Find(checkCustom2); domain.lineId_1 = custom2.lineId_1; domain.lineId_2 = custom2.lineId_2; domain.lineId_3 = custom2.lineId_3; domain.lineId_4 = custom2.lineId_4; domain.lineId_5 = custom2.lineId_5; domain.lineId_6 = custom2.lineId_6; domain.lineId_7 = custom2.lineId_7; domain.lineId_8 = custom2.lineId_8; var entry = db.Entry(domain); entry.State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } // Custom 3 var checkCustom3 = db.Dashboard_CustomGroup.AsNoTracking() .Where(x => x.groupName == "Custom_3") .Select(x => x.ID).FirstOrDefault(); if (checkCustom3 == 0) { db.Dashboard_CustomGroup.Add(custom3); db.SaveChanges(); } else { var domain = db.Dashboard_CustomGroup.Find(checkCustom3); domain.lineId_1 = custom3.lineId_1; domain.lineId_2 = custom3.lineId_2; domain.lineId_3 = custom3.lineId_3; domain.lineId_4 = custom3.lineId_4; domain.lineId_5 = custom3.lineId_5; domain.lineId_6 = custom3.lineId_6; domain.lineId_7 = custom3.lineId_7; domain.lineId_8 = custom3.lineId_8; var entry = db.Entry(domain); entry.State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } catch(Exception ex) { MessageBox.Show(ex.InnerException.ToString()); } this.Close(); }
// Submit button private void button2_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; bool chkConn = bwk.testConnection(); LineName[0] = ""; LineName[1] = ""; LineName[2] = ""; LineName[3] = ""; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = ""; Lbl_Line_2.Text = ""; Lbl_Line_3.Text = ""; Lbl_Line_4.Text = ""; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; if (chkConn == true) { // Added by Wimok 2014/08/04 if (LineGroup == "Cube Benhil") { LineName[0] = "Benh_1"; LineName[1] = "Benh_2"; LineName[2] = "Benh_3"; LineName[3] = "Benh_4"; LineName[4] = "Benh_5"; LineName[5] = "Benh_6"; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "Benhil 1"; Lbl_Line_2.Text = "Benhil 2"; Lbl_Line_3.Text = "Benhil 3"; Lbl_Line_4.Text = "Benhil 4"; Lbl_Line_5.Text = "Benhil 5"; Lbl_Line_6.Text = "Benhil 6"; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == "Cube Corazza") { LineName[0] = "Corz_1"; LineName[1] = "Corz_2"; LineName[2] = "Corz_3"; LineName[3] = "Corz_4"; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "Corazza 1"; Lbl_Line_2.Text = "Corazza 2"; Lbl_Line_3.Text = "Corazza 3"; Lbl_Line_4.Text = "Corazza 4"; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == "Jok Cup") { LineName[0] = "Cupf_2"; LineName[1] = "Cupf_3"; LineName[2] = "Cupf_4"; LineName[3] = ""; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "Cup Filler 2"; Lbl_Line_2.Text = "Cup Filler 3"; Lbl_Line_3.Text = "Cup Filler 4"; Lbl_Line_4.Text = ""; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == "Jok Sachet") { LineName[0] = "Bart_1"; LineName[1] = "Mesp_1"; LineName[2] = "Mesp_3"; LineName[3] = "Mesp_4"; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "Bartelt 1"; Lbl_Line_2.Text = "Mespack 1"; Lbl_Line_3.Text = "Mespack 3"; Lbl_Line_4.Text = "Mespack 4"; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == "Powder") { LineName[0] = "Bart_2"; LineName[1] = "Bart_3"; LineName[2] = "Upkn_1"; LineName[3] = "Vffs_1"; LineName[4] = "ILpk_1"; LineName[5] = "Dema_2"; LineName[6] = "Mpck_2"; LineName[7] = "Mpck_4"; Lbl_Line_1.Text = "Bartelt 2"; Lbl_Line_2.Text = "Bartelt 3"; Lbl_Line_3.Text = "UP KN 1"; Lbl_Line_4.Text = "VFFS 1"; Lbl_Line_5.Text = "Ilapak 1"; Lbl_Line_6.Text = "Demar 2"; Lbl_Line_7.Text = "MP 2"; Lbl_Line_8.Text = "MP 4"; } else if (LineGroup == "Dry Mix") { LineName[0] = "G2h_1"; LineName[1] = "Updm_1"; LineName[2] = "Mpdm_1"; LineName[3] = ""; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "G2H"; Lbl_Line_2.Text = "UP DM 1"; Lbl_Line_3.Text = "MP DM 1"; Lbl_Line_4.Text = ""; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == "Custom 1") { var qry = from x in db.Dashboard_CustomGroup where x.groupName == "Custom_1" select x; Dashboard_CustomGroup custom = new Dashboard_CustomGroup(); try { custom = qry.FirstOrDefault(); if (custom != null) { LineName[0] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_1 select x.line_id).FirstOrDefault(); LineName[1] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_2 select x.line_id).FirstOrDefault(); LineName[2] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_3 select x.line_id).FirstOrDefault(); LineName[3] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_4 select x.line_id).FirstOrDefault(); LineName[4] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_5 select x.line_id).FirstOrDefault(); LineName[5] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_6 select x.line_id).FirstOrDefault(); LineName[6] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_7 select x.line_id).FirstOrDefault(); LineName[7] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_8 select x.line_id).FirstOrDefault(); Lbl_Line_1.Text = custom.lineId_1; Lbl_Line_2.Text = custom.lineId_2; Lbl_Line_3.Text = custom.lineId_3; Lbl_Line_4.Text = custom.lineId_4; Lbl_Line_5.Text = custom.lineId_5; Lbl_Line_6.Text = custom.lineId_6; Lbl_Line_7.Text = custom.lineId_7; Lbl_Line_8.Text = custom.lineId_8; } } catch(Exception ex) { } } else if (LineGroup == "Custom 2") { var qry = from x in db.Dashboard_CustomGroup where x.groupName == "Custom_2" select x; Dashboard_CustomGroup custom = new Dashboard_CustomGroup(); try { custom = qry.FirstOrDefault(); if (custom != null) { LineName[0] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_1 select x.line_id).FirstOrDefault(); LineName[1] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_2 select x.line_id).FirstOrDefault(); LineName[2] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_3 select x.line_id).FirstOrDefault(); LineName[3] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_4 select x.line_id).FirstOrDefault(); LineName[4] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_5 select x.line_id).FirstOrDefault(); LineName[5] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_6 select x.line_id).FirstOrDefault(); LineName[6] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_7 select x.line_id).FirstOrDefault(); LineName[7] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_8 select x.line_id).FirstOrDefault(); Lbl_Line_1.Text = custom.lineId_1; Lbl_Line_2.Text = custom.lineId_2; Lbl_Line_3.Text = custom.lineId_3; Lbl_Line_4.Text = custom.lineId_4; Lbl_Line_5.Text = custom.lineId_5; Lbl_Line_6.Text = custom.lineId_6; Lbl_Line_7.Text = custom.lineId_7; Lbl_Line_8.Text = custom.lineId_8; } } catch (Exception ex) { } } else if (LineGroup == "Custom 3") { var qry = from x in db.Dashboard_CustomGroup where x.groupName == "Custom_3" select x; Dashboard_CustomGroup custom = new Dashboard_CustomGroup(); try { custom = qry.FirstOrDefault(); if (custom != null) { LineName[0] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_1 select x.line_id).FirstOrDefault(); LineName[1] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_2 select x.line_id).FirstOrDefault(); LineName[2] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_3 select x.line_id).FirstOrDefault(); LineName[3] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_4 select x.line_id).FirstOrDefault(); LineName[4] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_5 select x.line_id).FirstOrDefault(); LineName[5] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_6 select x.line_id).FirstOrDefault(); LineName[6] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_7 select x.line_id).FirstOrDefault(); LineName[7] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_8 select x.line_id).FirstOrDefault(); Lbl_Line_1.Text = custom.lineId_1; Lbl_Line_2.Text = custom.lineId_2; Lbl_Line_3.Text = custom.lineId_3; Lbl_Line_4.Text = custom.lineId_4; Lbl_Line_5.Text = custom.lineId_5; Lbl_Line_6.Text = custom.lineId_6; Lbl_Line_7.Text = custom.lineId_7; Lbl_Line_8.Text = custom.lineId_8; } } catch (Exception ex) { } } Check_SHE_Line1 = "1"; Check_SHE_Line2 = "1"; Check_SHE_Line3 = "1"; Check_SHE_Line4 = "1"; Check_SHE_Line5 = "1"; Check_SHE_Line6 = "1"; Check_SHE_Line7 = "1"; Check_SHE_Line8 = "1"; Check_Quality_Line1 = "1"; Check_Quality_Line2 = "1"; Check_Quality_Line3 = "1"; Check_Quality_Line4 = "1"; Check_Quality_Line5 = "1"; Check_Quality_Line6 = "1"; Check_Quality_Line7 = "1"; Check_Quality_Line8 = "1"; tblPanel_r1_c1.Visible = true; tblPanel_r1_c2.Visible = true; tblPanel_r1_c3.Visible = true; tblPanel_r1_c4.Visible = true; tblPanel_r1_c5.Visible = true; tblPanel_r1_c6.Visible = true; tblPanel_r1_c7.Visible = true; tblPanel_r1_c8.Visible = true; tblPanel_r2_c1.Visible = true; tblPanel_r2_c2.Visible = true; tblPanel_r2_c3.Visible = true; tblPanel_r2_c4.Visible = true; tblPanel_r2_c5.Visible = true; tblPanel_r2_c6.Visible = true; tblPanel_r2_c7.Visible = true; tblPanel_r2_c8.Visible = true; tblPanel_rTotal_c1.Visible = true; tblPanel_rTotal_c2.Visible = true; tblPanel_rTotal_c3.Visible = true; tblPanel_rTotal_c4.Visible = true; tblPanel_rTotal_c5.Visible = true; tblPanel_rTotal_c6.Visible = true; tblPanel_rTotal_c7.Visible = true; tblPanel_rTotal_c8.Visible = true; //------------------------------------------------------------------------------------ _getDataOther(); GetData(1, LineName[0], date_data.Value, grid_r1_c1); GetData(1, LineName[1], date_data.Value, grid_r1_c2); GetData(1, LineName[2], date_data.Value, grid_r1_c3); GetData(1, LineName[3], date_data.Value, grid_r1_c4); GetData(1, LineName[4], date_data.Value, grid_r1_c5); GetData(1, LineName[5], date_data.Value, grid_r1_c6); GetData(1, LineName[6], date_data.Value, grid_r1_c7); GetData(1, LineName[7], date_data.Value, grid_r1_c8); GetData(2, LineName[0], date_data.Value, grid_r2_c1); GetData(2, LineName[1], date_data.Value, grid_r2_c2); GetData(2, LineName[2], date_data.Value, grid_r2_c3); GetData(2, LineName[3], date_data.Value, grid_r2_c4); GetData(2, LineName[4], date_data.Value, grid_r2_c5); GetData(2, LineName[5], date_data.Value, grid_r2_c6); GetData(2, LineName[6], date_data.Value, grid_r2_c7); GetData(2, LineName[7], date_data.Value, grid_r2_c8); GetSummaryData(1, LineName[0], date_data.Value, lblActual_r1_c1, lblDiff_r1_c1, yellow_r1_c1, tblPanel_r1_c1); GetSummaryData(1, LineName[1], date_data.Value, lblActual_r1_c2, lblDiff_r1_c2, yellow_r1_c2, tblPanel_r1_c2); GetSummaryData(1, LineName[2], date_data.Value, lblActual_r1_c3, lblDiff_r1_c3, yellow_r1_c3, tblPanel_r1_c3); GetSummaryData(1, LineName[3], date_data.Value, lblActual_r1_c4, lblDiff_r1_c4, yellow_r1_c4, tblPanel_r1_c4); GetSummaryData(1, LineName[4], date_data.Value, lblActual_r1_c5, lblDiff_r1_c5, yellow_r1_c5, tblPanel_r1_c5); GetSummaryData(1, LineName[5], date_data.Value, lblActual_r1_c6, lblDiff_r1_c6, yellow_r1_c6, tblPanel_r1_c6); GetSummaryData(1, LineName[6], date_data.Value, lblActual_r1_c7, lblDiff_r1_c7, yellow_r1_c7, tblPanel_r1_c7); GetSummaryData(1, LineName[7], date_data.Value, lblActual_r1_c8, lblDiff_r1_c8, yellow_r1_c8, tblPanel_r1_c8); GetSummaryData(2, LineName[0], date_data.Value, lblActual_r2_c1, lblDiff_r2_c1, yellow_r2_c1, tblPanel_r2_c1); GetSummaryData(2, LineName[1], date_data.Value, lblActual_r2_c2, lblDiff_r2_c2, yellow_r2_c2, tblPanel_r2_c2); GetSummaryData(2, LineName[2], date_data.Value, lblActual_r2_c3, lblDiff_r2_c3, yellow_r2_c3, tblPanel_r2_c3); GetSummaryData(2, LineName[3], date_data.Value, lblActual_r2_c4, lblDiff_r2_c4, yellow_r2_c4, tblPanel_r2_c4); GetSummaryData(2, LineName[4], date_data.Value, lblActual_r2_c5, lblDiff_r2_c5, yellow_r2_c5, tblPanel_r2_c5); GetSummaryData(2, LineName[5], date_data.Value, lblActual_r2_c6, lblDiff_r2_c6, yellow_r2_c6, tblPanel_r2_c6); GetSummaryData(2, LineName[6], date_data.Value, lblActual_r2_c7, lblDiff_r2_c7, yellow_r2_c7, tblPanel_r2_c7); GetSummaryData(2, LineName[7], date_data.Value, lblActual_r2_c8, lblDiff_r2_c8, yellow_r2_c8, tblPanel_r2_c8); GetTotalData(LineName[0], date_data.Value, grid_rTotal_c1); GetTotalData(LineName[1], date_data.Value, grid_rTotal_c2); GetTotalData(LineName[2], date_data.Value, grid_rTotal_c3); GetTotalData(LineName[3], date_data.Value, grid_rTotal_c4); GetTotalData(LineName[4], date_data.Value, grid_rTotal_c5); GetTotalData(LineName[5], date_data.Value, grid_rTotal_c6); GetTotalData(LineName[6], date_data.Value, grid_rTotal_c7); GetTotalData(LineName[7], date_data.Value, grid_rTotal_c8); GetSummaryTotal(LineName[0], date_data.Value, lblActual_rTotal_c1, lblDiff_rTotal_c1, yellow_rTotal_c1, tblPanel_rTotal_c1); GetSummaryTotal(LineName[1], date_data.Value, lblActual_rTotal_c2, lblDiff_rTotal_c2, yellow_rTotal_c2, tblPanel_rTotal_c2); GetSummaryTotal(LineName[2], date_data.Value, lblActual_rTotal_c3, lblDiff_rTotal_c3, yellow_rTotal_c3, tblPanel_rTotal_c3); GetSummaryTotal(LineName[3], date_data.Value, lblActual_rTotal_c4, lblDiff_rTotal_c4, yellow_rTotal_c4, tblPanel_rTotal_c4); GetSummaryTotal(LineName[4], date_data.Value, lblActual_rTotal_c5, lblDiff_rTotal_c5, yellow_rTotal_c5, tblPanel_rTotal_c5); GetSummaryTotal(LineName[5], date_data.Value, lblActual_rTotal_c6, lblDiff_rTotal_c6, yellow_rTotal_c6, tblPanel_rTotal_c6); GetSummaryTotal(LineName[6], date_data.Value, lblActual_rTotal_c7, lblDiff_rTotal_c7, yellow_rTotal_c7, tblPanel_rTotal_c7); GetSummaryTotal(LineName[7], date_data.Value, lblActual_rTotal_c8, lblDiff_rTotal_c8, yellow_rTotal_c8, tblPanel_rTotal_c8); _getDataChart(); //GetDefectFactor(); //GetDefect(Qua_Line1_G, Qua_Line1_R, LineName[0], ref Defect_Line1, Defect_Factor); //GetDefect(Qua_Line2_G, Qua_Line2_R, LineName[1], ref Defect_Line2, Defect_Factor); //GetDefect(Qua_Line3_G, Qua_Line3_R, LineName[2], ref Defect_Line3, Defect_Factor); //GetDefect(Qua_Line4_G, Qua_Line4_R, LineName[3], ref Defect_Line4, Defect_Factor); //GetDefect(Qua_Line5_G, Qua_Line5_R, LineName[4], ref Defect_Line5, Defect_Factor); //GetDefect(Qua_Line6_G, Qua_Line6_R, LineName[5], ref Defect_Line6, Defect_Factor); //GetDefect(Qua_Line7_G, Qua_Line7_R, LineName[6], ref Defect_Line7, Defect_Factor); //GetDefect(Qua_Line8_G, Qua_Line8_R, LineName[7], ref Defect_Line8, Defect_Factor); } }
private void button1_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; string DateSelect = dbc.CommonDt(date_data.Value); //string[] LineName = new string[8]; initParam(); if (LineGroup == 1) { LineName[0] = "Benh_1"; LineName[1] = "Benh_2"; LineName[2] = "Benh_3"; LineName[3] = "Benh_4"; LineName[4] = "Benh_5"; LineName[5] = "Benh_6"; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "Benhil 1"; Lbl_Line_2.Text = "Benhil 2"; Lbl_Line_3.Text = "Benhil 3"; Lbl_Line_4.Text = "Benhil 4"; Lbl_Line_5.Text = "Benhil 5"; Lbl_Line_6.Text = "Benhil 6"; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == 2) { LineName[0] = "Corz_1"; LineName[1] = "Corz_2"; LineName[2] = "Corz_3"; LineName[3] = "Corz_4"; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "Corazza 1"; Lbl_Line_2.Text = "Corazza 2"; Lbl_Line_3.Text = "Corazza 3"; Lbl_Line_4.Text = "Corazza 4"; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == 3) { LineName[0] = "Cupf_2"; LineName[1] = "Cupf_3"; LineName[2] = "Cupf_4"; LineName[3] = ""; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "Cup Filler 2"; Lbl_Line_2.Text = "Cup Filler 3"; Lbl_Line_3.Text = "Cup Filler 4"; Lbl_Line_4.Text = ""; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == 4) { LineName[0] = "Bart_1"; LineName[1] = "Mesp_1"; LineName[2] = "Mesp_3"; LineName[3] = "Mesp_4"; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "Bartelt 1"; Lbl_Line_2.Text = "Mespack 1"; Lbl_Line_3.Text = "Mespack 3"; Lbl_Line_4.Text = "Mespack 4"; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == 5) { LineName[0] = "Bart_2"; LineName[1] = "Bart_3"; LineName[2] = "Upkn_1"; LineName[3] = "Vffs_1"; LineName[4] = "ILpk_1"; LineName[5] = "Dema_2"; LineName[6] = "Mpck_2"; LineName[7] = "Mpck_4"; Lbl_Line_1.Text = "Bartelt 2"; Lbl_Line_2.Text = "Bartelt 3"; Lbl_Line_3.Text = "UP KN 1"; Lbl_Line_4.Text = "VFFS 1"; Lbl_Line_5.Text = "Ilapak 1"; Lbl_Line_6.Text = "Demar 2"; Lbl_Line_7.Text = "MP 2"; Lbl_Line_8.Text = "MP 4"; } else if (LineGroup == 6) { LineName[0] = "G2h_1"; LineName[1] = "Updm_1"; LineName[2] = "Mpdm_1"; LineName[3] = ""; LineName[4] = ""; LineName[5] = ""; LineName[6] = ""; LineName[7] = ""; Lbl_Line_1.Text = "G2H"; Lbl_Line_2.Text = "UP DM 1"; Lbl_Line_3.Text = "MP DM 1"; Lbl_Line_4.Text = ""; Lbl_Line_5.Text = ""; Lbl_Line_6.Text = ""; Lbl_Line_7.Text = ""; Lbl_Line_8.Text = ""; } else if (LineGroup == 7) { var qry = from x in db.Dashboard_CustomGroup where x.groupName == "Custom_1" select x; Dashboard_CustomGroup custom = new Dashboard_CustomGroup(); try { custom = qry.FirstOrDefault(); if (custom != null) { LineName[0] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_1 select x.line_id).FirstOrDefault(); LineName[1] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_2 select x.line_id).FirstOrDefault(); LineName[2] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_3 select x.line_id).FirstOrDefault(); LineName[3] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_4 select x.line_id).FirstOrDefault(); LineName[4] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_5 select x.line_id).FirstOrDefault(); LineName[5] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_6 select x.line_id).FirstOrDefault(); LineName[6] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_7 select x.line_id).FirstOrDefault(); LineName[7] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_8 select x.line_id).FirstOrDefault(); Lbl_Line_1.Text = custom.lineId_1; Lbl_Line_2.Text = custom.lineId_2; Lbl_Line_3.Text = custom.lineId_3; Lbl_Line_4.Text = custom.lineId_4; Lbl_Line_5.Text = custom.lineId_5; Lbl_Line_6.Text = custom.lineId_6; Lbl_Line_7.Text = custom.lineId_7; Lbl_Line_8.Text = custom.lineId_8; } } catch (Exception ex) { } } else if (LineGroup == 8) { var qry = from x in db.Dashboard_CustomGroup where x.groupName == "Custom_2" select x; Dashboard_CustomGroup custom = new Dashboard_CustomGroup(); try { custom = qry.FirstOrDefault(); if (custom != null) { LineName[0] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_1 select x.line_id).FirstOrDefault(); LineName[1] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_2 select x.line_id).FirstOrDefault(); LineName[2] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_3 select x.line_id).FirstOrDefault(); LineName[3] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_4 select x.line_id).FirstOrDefault(); LineName[4] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_5 select x.line_id).FirstOrDefault(); LineName[5] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_6 select x.line_id).FirstOrDefault(); LineName[6] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_7 select x.line_id).FirstOrDefault(); LineName[7] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_8 select x.line_id).FirstOrDefault(); Lbl_Line_1.Text = custom.lineId_1; Lbl_Line_2.Text = custom.lineId_2; Lbl_Line_3.Text = custom.lineId_3; Lbl_Line_4.Text = custom.lineId_4; Lbl_Line_5.Text = custom.lineId_5; Lbl_Line_6.Text = custom.lineId_6; Lbl_Line_7.Text = custom.lineId_7; Lbl_Line_8.Text = custom.lineId_8; } } catch (Exception ex) { } } else if (LineGroup == 9) { var qry = from x in db.Dashboard_CustomGroup where x.groupName == "Custom_3" select x; Dashboard_CustomGroup custom = new Dashboard_CustomGroup(); try { custom = qry.FirstOrDefault(); if (custom != null) { LineName[0] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_1 select x.line_id).FirstOrDefault(); LineName[1] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_2 select x.line_id).FirstOrDefault(); LineName[2] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_3 select x.line_id).FirstOrDefault(); LineName[3] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_4 select x.line_id).FirstOrDefault(); LineName[4] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_5 select x.line_id).FirstOrDefault(); LineName[5] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_6 select x.line_id).FirstOrDefault(); LineName[6] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_7 select x.line_id).FirstOrDefault(); LineName[7] = (from x in db.LINE_PRODUCTION where x.line_name == custom.lineId_8 select x.line_id).FirstOrDefault(); Lbl_Line_1.Text = custom.lineId_1; Lbl_Line_2.Text = custom.lineId_2; Lbl_Line_3.Text = custom.lineId_3; Lbl_Line_4.Text = custom.lineId_4; Lbl_Line_5.Text = custom.lineId_5; Lbl_Line_6.Text = custom.lineId_6; Lbl_Line_7.Text = custom.lineId_7; Lbl_Line_8.Text = custom.lineId_8; } } catch (Exception ex) { } } BWK bwk = new BWK(); bool chkConn = bwk.testConnection(); if(chkConn == true) { if(checkBox_RangeFilter.Checked) { switch (comboBox_DateRange.Text) { case "Date": _getDataRange_Date(LineName[0], dateRangePicker_1.Value.Date, dateRangePicker_2.Value.Date, ref grid_datalist_a); _getDataRange_Date(LineName[1], dateRangePicker_1.Value.Date, dateRangePicker_2.Value.Date, ref grid_datalist_b1); _getDataRange_Date(LineName[2], dateRangePicker_1.Value.Date, dateRangePicker_2.Value.Date, ref grid_datalist_b9); _getDataRange_Date(LineName[3], dateRangePicker_1.Value.Date, dateRangePicker_2.Value.Date, ref grid_datalist_c); _getDataRange_Date(LineName[4], dateRangePicker_1.Value.Date, dateRangePicker_2.Value.Date, ref grid_datalist_d); _getDataRange_Date(LineName[5], dateRangePicker_1.Value.Date, dateRangePicker_2.Value.Date, ref grid_datalist_e); _getDataRange_Date(LineName[6], dateRangePicker_1.Value.Date, dateRangePicker_2.Value.Date, ref grid_datalist_g); _getDataRange_Date(LineName[7], dateRangePicker_1.Value.Date, dateRangePicker_2.Value.Date, ref grid_datalist_m); _getPlanActualRange_Date(); _getPlanActualRange_Date_All(); break; case "Week": _getDataRange_Week(LineName[0], Convert.ToInt32(comboBox_Week_1.Text), Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Week_2.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_a); _getDataRange_Week(LineName[1], Convert.ToInt32(comboBox_Week_1.Text), Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Week_2.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_b1); _getDataRange_Week(LineName[2], Convert.ToInt32(comboBox_Week_1.Text), Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Week_2.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_b9); _getDataRange_Week(LineName[3], Convert.ToInt32(comboBox_Week_1.Text), Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Week_2.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_c); _getDataRange_Week(LineName[4], Convert.ToInt32(comboBox_Week_1.Text), Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Week_2.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_d); _getDataRange_Week(LineName[5], Convert.ToInt32(comboBox_Week_1.Text), Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Week_2.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_e); _getDataRange_Week(LineName[6], Convert.ToInt32(comboBox_Week_1.Text), Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Week_2.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_g); _getDataRange_Week(LineName[7], Convert.ToInt32(comboBox_Week_1.Text), Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Week_2.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_m); _getPlanActualRange_Week(); _getPlanActualRange_Week_All(); break; case "Year": _getDataRange_Year(LineName[0], Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_a); _getDataRange_Year(LineName[1], Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_b1); _getDataRange_Year(LineName[2], Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_b9); _getDataRange_Year(LineName[3], Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_c); _getDataRange_Year(LineName[4], Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_d); _getDataRange_Year(LineName[5], Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_e); _getDataRange_Year(LineName[6], Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_g); _getDataRange_Year(LineName[7], Convert.ToInt32(comboBox_Year_1.Text), Convert.ToInt32(comboBox_Year_2.Text), ref grid_datalist_m); _getPlanActualRange_Year(); _getPlanActualRange_Year_All(); break; } lab_day.Text = "Range"; lab_week.Text = ""; lab_day_all.Text = "Range (All group)"; lab_week_all.Text = ""; lab_week_group_plan.Text = ""; lab_week_group_actual.Text = ""; lab_week_p.Text = ""; lab_week_a.Text = ""; tblLayout_status_week.Visible = false; tblLayout_status_week_all.Visible = false; } else { _getDataList(LineName[0], date_data.Value, ref grid_datalist_a); _getDataList(LineName[1], date_data.Value, ref grid_datalist_b1); _getDataList(LineName[2], date_data.Value, ref grid_datalist_b9); _getDataList(LineName[3], date_data.Value, ref grid_datalist_c); _getDataList(LineName[4], date_data.Value, ref grid_datalist_d); _getDataList(LineName[5], date_data.Value, ref grid_datalist_e); _getDataList(LineName[6], date_data.Value, ref grid_datalist_g); _getDataList(LineName[7], date_data.Value, ref grid_datalist_m); lab_day.Text = "Day"; lab_week.Text = "Week"; lab_day_all.Text = "Day (All group)"; lab_week_all.Text = "Week (All group)"; _getPlanActualDay(); _getPlanActualDayPerGroup(); _getPlanActualWeek(); _getPlanActualWeekPerGroup(); tblLayout_status_week.Visible = true; tblLayout_status_week_all.Visible = true; } _getDataOther(); } }