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);
//}
}
