private void InputReceiving_Load(object sender, EventArgs e) { seticon_forbutton(); List <object[]> dtlot = new List <object[]>(); MainMenu flot = new MainMenu(); dtlot = flot.get_data_table_string_exclude("tbreceiving", "tbretouchingdetails", "intlotcode"); if (dtlot.Count > 0) { for (int i = 0; i < dtlot.Count; i++) { cbexistinglot.Items.Add(dtlot[i][1]); } } }
private void InputCutting_Load(object sender, EventArgs e) { seticon_forbutton(); List <object[]> dtlot = new List <object[]>(); MainMenu flot = new MainMenu(); if (Properties.Settings.Default.module.Equals("CUTTING")) { dtlot = flot.get_data_table_string_exclude("tbreceiving", "tbcuttingdetails", "intlotcode"); btnnew.Text = "Create Cutting"; btnopen.Text = "Open Cutting"; groupproductname.Visible = false; } else if (Properties.Settings.Default.module.Equals("RETOUCHING")) { dtlot = flot.get_data_table_string_exclude("tbcuttingdetails", "tbretouchingdetails", "intlotcode"); btnnew.Text = "Create Retouching"; btnopen.Text = "Open Retouching"; groupproductname.Visible = true; List <object[]> data = new List <object[]>(); data = flot.get_data_table_string("tbproductsetup", "", ""); if (data.Count > 0) { cbproductname.Items.Clear(); for (int i = 0; i < data.Count; i++) { cbproductname.Items.Add(data[i][5].ToString().ToUpper()); } if (data.Count == 1) { cbproductname.Text = data[0][5].ToString().ToUpper(); } } } String previntlotcode = ""; if (dtlot.Count > 0) { for (int i = 0; i < dtlot.Count; i++) { if (!previntlotcode.Equals(dtlot[i][1].ToString())) { cbexistinglot.Items.Add(dtlot[i][1]); } previntlotcode = dtlot[i][1].ToString(); } } previntlotcode = ""; List <object[]> dtplot = new List <object[]>(); MainMenu frm = new MainMenu(); if (Properties.Settings.Default.module.Equals("CUTTING")) { dtplot = frm.get_data_table_string_exclude("tbcuttingdetails", "tbretouchingdetails", "intlotcode"); //dtplot = frm.get_data_table_daysearlier(14, "tbcuttingdetails"); } else if (Properties.Settings.Default.module.Equals("RETOUCHING")) { //dtplot = frm.get_data_table_string_exclude("tbretouchingdetails", "tbpacking", "intlotcode"); dtplot = frm.get_data_table_daysearlier(7, "tbretouchingdetails"); } String value = ""; if (dtplot.Count > 0) { for (int i = 0; i < dtplot.Count; i++) { value = dtplot[i][1].ToString(); if (!cbprevlotcode.Items.Contains(value)) { cbprevlotcode.Items.Add(value); } } } }