private void DataHistoryMachine_Load(object sender, EventArgs e) { dataTable = new DataSetPassBox.WBMPPassboxDataTable(); adapter = new DataSetPassBoxTableAdapters.WBMPPassboxTableAdapter(); dataTable = adapter.GetHistoryData(Properties.Settings.Default.MCNo); dataGridView1.DataSource = dataTable; }
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; } } } } }