public void ShowPassBoxData(ClassPassBox passBox) { btn_queue.Text = passBox.Queue.ToString(); lbl_LotNo.Text = passBox.LotNo; lbl_Package.Text = passBox.Package; lbl_Input.Text = "INPUT DATE : " + passBox.In_Date; lbl_Shipment.Text = "SHIPMENT DATE : " + passBox.Out_Date; bgPanel.BackColor = passBox.BgColor; timeInput = passBox.EndTimeBeforeProcess; timer1.Start(); }
private void btn_queue_Click(object sender, EventArgs e) { if (lbl_LotNo.Text != "") { wBMP = new DataSetPassBox.WBMPPassboxDataTable(); adapter = new DataSetPassBoxTableAdapters.WBMPPassboxTableAdapter(); wBMP = adapter.GetDataPassBox(Properties.Settings.Default.MCNo); //List<ClassPassBox> history = new List<ClassPassBox>(); foreach (DataSetPassBox.WBMPPassboxRow row in wBMP) { if (this.Name == "uc_" + row.ChannelNumber) { Frm_Main f2 = new Frm_Main(); row.LotEndTime = DateTime.Now; row.OPNoOut = ParameterPB.OP; adapter.Update(wBMP); ClassPassBox historyData = new ClassPassBox(); historyData.LotNo = "LotNo : " + lbl_LotNo.Text; historyData.Package = "Package : " + lbl_Package.Text; historyData.In_Date = lbl_Input.Text; //historyData.Out_Date = "EndTime : " + row.LotEndTime; historyData.channel = "Channel : " + row.ChannelNumber; //XmlSave.SaveData(historyData, @"C:\Users\user454\Desktop\Witchaya M\MP_PassBox\MP_PassBox\bin\Debug\HistoryPassBox.xml"); addlogfile("(Queue Out) " + "OP In : " + row.OPNoIn + ", " + historyData.LotNo + ", " + historyData.Package + ", " + historyData.In_Date + ", " + historyData.channel + ", " + "Time in " + row.ChannelNumber + " : " + lbl_time.Text); ClearData(); break; } } } else { Frm_message f1 = new Frm_message(); if (f1.ShowDialog() == DialogResult.OK) { wBMP = new DataSetPassBox.WBMPPassboxDataTable(); adapter = new DataSetPassBoxTableAdapters.WBMPPassboxTableAdapter(); wBMP = adapter.GetDataBackup(Properties.Settings.Default.MCNo, this.Name.Substring(3, 8)); foreach (DataSetPassBox.WBMPPassboxRow row1 in wBMP) { if (this.Name == "uc_" + row1.ChannelNumber) { row1.SetLotEndTimeNull(); adapter.Update(wBMP); ClassPassBox BackupData = new ClassPassBox(); BackupData.LotNo = "LotNo : " + row1.LotNo; //BackupData.Package = "Package : " + lbl_Package.Text; //BackupData.In_Date = "Input Date : "; //BackupData.Out_Date = lbl_Shipment.Text; BackupData.channel = "Channel : " + row1.ChannelNumber; addlogfile("(BackupData) " + "OP Out : " + row1.OPNoOut + ", " + BackupData.LotNo + ", " + BackupData.channel); break; } } } } }
private void Getdata() { dataAll = new DataSetPassBox.DataPassBoxDataTable(); _data = new DataSetPassBoxTableAdapters.DataPassBoxTableAdapter(); dataAll = _data.GetData(Settings.Default.MCNo); c_PassBoxList = new List <ClassPassBox>(); List <string> pgk = new List <string>(); foreach (DataSetPassBox.DataPassBoxRow row in dataAll) { if (!pgk.Contains(row.Package)) { pgk.Add(row.Package); int count = 0; foreach (DataSetPassBox.DataPassBoxRow row2 in dataAll) { if (row.Package == row2.Package) { count += 1; ClassPassBox c_PassBox = new ClassPassBox(); c_PassBox.LotNo = row2.LotNo; //c_PassBox.BgColor = Color.LightBlue; c_PassBox.channel = row2.ChannelNumber; c_PassBox.In_Date = row2.IN_DAY; c_PassBox.Out_Date = row2.OUT_DAY; c_PassBox.Package = row2.Package; c_PassBox.EndTimeBeforeProcess = row2.EndTimeBeforeProcess; c_PassBox.Queue = count; c_PassBoxList.Add(c_PassBox); } } } //if (!passbox.ContainsKey(row.Package)) //{ // passbox.Add(row.Package, null); //} } //wBMP = new DataSetPassBox.WBMPPassboxDataTable(); //adapter = new DataSetPassBoxTableAdapters.WBMPPassboxTableAdapter(); //wBMP = adapter.GetDataPassBox(); //c_PassBoxList = new List<ClassPassBox>(); //foreach(DataSetPassBox.WBMPPassboxRow row in wBMP) //{ // ClassPassBox c_PassBox = new ClassPassBox(); // c_PassBox.LotNo = row.LotNo; // //c_PassBox.EndTimeBeforeProcess = row.LotStartTime; // c_PassBox.BgColor = Color.LightBlue; // c_PassBox.channel = row.ChannelNumber; // DataSetPassBox.LOT2_TABLEDataTable lOT2Table = new DataSetPassBox.LOT2_TABLEDataTable(); // DataSetPassBoxTableAdapters.LOT2_TABLETableAdapter lOT2 = new DataSetPassBoxTableAdapters.LOT2_TABLETableAdapter(); // lOT2Table = lOT2.GetShipmentDate(row.LotNo); // foreach (DataSetPassBox.LOT2_TABLERow row1 in lOT2Table) // { // c_PassBox.In_Date = row1.IN_DAY; // c_PassBox.Out_Date = row1.OUT_DAY; // } // DataSetPassBox.BeforeProcessEndTimeDataTable beforeProcess = new DataSetPassBox.BeforeProcessEndTimeDataTable(); // DataSetPassBoxTableAdapters.BeforeProcessEndTimeTableAdapter package = new DataSetPassBoxTableAdapters.BeforeProcessEndTimeTableAdapter(); // beforeProcess = package.GetBeforeProcessEndTime(row.LotNo); // foreach (DataSetPassBox.BeforeProcessEndTimeRow row2 in beforeProcess) // { // c_PassBox.Package = row2.Package; // c_PassBox.EndTimeBeforeProcess = row2.EndTime; // } // c_PassBoxList.Add(c_PassBox); //} }