private void button_ReportNG_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.textBox_NG_Reason.Text))
{
MessageBox.Show(this, "Must Write down NG reason!", "[Error]", MessageBoxButtons.OK);
return;
}
else if (this.textBox_Password.Text != "admin")
{
MessageBox.Show(this, "Do not match Password!", "[Error]", MessageBoxButtons.OK);
return;
}
if (isTest == true)
{
errorInfo.Reason = this.textBox_NG_Reason.Text;
try
{
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
testResult_CRUD = new BarcodeTestResult_CRUD(conn);
testResult_CRUD.Insert(errorInfo);
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
errorInfo.Time = DateTime.Now;
errorInfo.Reason = this.textBox_NG_Reason.Text;
errorInfo.Reason += " + (Scan Box/Lot Error)";
try
{
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
testResult_CRUD = new BarcodeTestResult_CRUD(conn);
testResult_CRUD.Insert(errorInfo);
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Dispose();
}
private void button_Search_Click(object sender, EventArgs e)
{
startTime = dateTimePicker_StartTime.Value;
endTime = dateTimePicker_EndTime.Value;
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
testResult_CRUD = new BarcodeTestResult_CRUD(conn);
if (checkBox_MasterCodeQuery.Checked == true)
{
if (startTime.Date == endTime.Date)
{
testResult_ds = testResult_CRUD.SelectByTodayTime(startTime, textBox_MasterCode.Text);
}
else
{
testResult_ds = testResult_CRUD.SelectByQueryTime(startTime, endTime, textBox_MasterCode.Text);
}
}
else
{
if (startTime.Date == endTime.Date)
{
testResult_ds = testResult_CRUD.SelectByTodayTime(startTime);
}
else
{
testResult_ds = testResult_CRUD.SelectByQueryTime(startTime, endTime);
}
}
}
dataGridView.RowHeadersVisible = false;
dataGridView.AutoGenerateColumns = true;
dataGridView.DataSource = testResult_ds;
dataGridView.DataMember = "BarcodeTestResultTable";
dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView.Columns[0].Width = 120;
dataGridView.Columns[5].Width = 35; //LineNum
dataGridView.Columns[6].Width = 45; //Result
dataGridView.Columns[8].Width = 80; //Sample_1Box
dataGridView.Columns[9].Width = 80; //Sample_Tray
dataGridView.Columns[10].Width = 80; //TrayNumber
dataGridView.Columns[11].Width = 70; //TestCount
}
private void InitializeDatabaseConfig()
{
string currentFolder = Environment.CurrentDirectory;
string path = Path.Combine(currentFolder, "BarcodeDatabase.sqlite");
connStr = "Data Source=" + path + ";" + "version=3;";
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
testResult_CRUD = new BarcodeTestResult_CRUD(conn);
testResult_ds = testResult_CRUD.SelectByTodayTime(DateTime.Now);
}
dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView.ColumnHeadersDefaultCellStyle.Font = new Font("Corbel", 9, FontStyle.Bold);
dataGridView.EnableHeadersVisualStyles = false;
dataGridView.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
dataGridView.ColumnHeadersDefaultCellStyle.BackColor = Color.Yellow;
dataGridView.DefaultCellStyle.Font = new Font("Corbel", 9);
dataGridView.RowHeadersVisible = false;
dataGridView.AutoGenerateColumns = true;
dataGridView.DataSource = testResult_ds;
dataGridView.DataMember = "BarcodeTestResultTable";
dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView.Columns[0].Width = 120;
dataGridView.Columns[5].Width = 35; //LineNum
dataGridView.Columns[6].Width = 45; //Result
dataGridView.Columns[8].Width = 80; //Sample_1Box
dataGridView.Columns[9].Width = 80; //Sample_Tray
dataGridView.Columns[10].Width = 80; //TrayNumber
dataGridView.Columns[11].Width = 70; //TestCount
dataGridView.Columns[8].HeaderText = "Unit";
dataGridView.Columns[9].HeaderText = "Middle";
dataGridView.Columns[10].HeaderText = "Carton";
}
private void txtSerialScanData_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
txtSerialScanData.Text = scannedCode.ToString();
scannedCode.Clear();
if (txtSerialScanData.Text != "")
{
if (txtSerialScanData.Text != txtSkuScanData.Text)
{
this.BeginInvoke(new Action(delegate()
{
if (!chbSerial.Checked)
{
sumOfPassCount++;
passCount++;
testResultInfo.Time = DateTime.Now;
testResultInfo.Result = true;
testResultInfo.Reason = "TEST OK";
testResultInfo.Compared_Item += ";" + txtSerialScanData.Text.Trim();
this.btnPassFail.Text = "PASS (" + (this.sumOfPassCount).ToString() + ") / FAIL (" + (this.failCount).ToString() + ")";
this.lblTestCount.Text = this.currentSeqQty.ToString();
try
{
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
testResult_CRUD = new BarcodeTestResult_CRUD(conn);
testResult_CRUD.Insert(testResultInfo);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
if (function.BOX_LOT_CODE == false && function.COUNT_SETUP == false)
{
if (this.passCount >= this._unit_1Middle)
{
txtSerialScanData.Text = "Scan Middle Code !";
txtSkuScanData.Text = "";
_scanMiddleCode = true;
timerBlink.Enabled = true;
this.ActiveControl = txtSkuScanData;
return;
}
}
}
else
{
btnPassFail.Text = "OK";
sumOfPassCount++;
passCount++;
this.currentSeqQty++;
this.currentTestCount++;
testResultInfo.Time = DateTime.Now;
testResultInfo.Origin_Item = txtSerialScanData.Text.Trim();
testResultInfo.Compared_Item = txtSerialScanData.Text.Trim();
testResultInfo.Sample_1Box = this._unit_1Carton;
testResultInfo.Sample_Tray = this._unit_1Middle;
testResultInfo.TrayNumber = this.sumOfLot;
testResultInfo.TestCount = this.currentTestCount;
testResultInfo.Result = true;
testResultInfo.Reason = "TEST OK";
this.btnPassFail.Text = "PASS (" + (this.sumOfPassCount).ToString() + ") / FAIL (" + (this.failCount).ToString() + ")";
this.lblTestCount.Text = this.currentSeqQty.ToString();
try
{
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
testResult_CRUD = new BarcodeTestResult_CRUD(conn);
testResult_CRUD.Insert(testResultInfo);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
if (function.BOX_LOT_CODE == true && chbSelectMiddle.Checked && chbSelectCarton.Checked)
{
if (this.currentMiddleNumber >= this._middle_1Carton)
{
if (txtSerialScanData.Text.Trim() == _cartonCode)
{
txtSkuScanData.Text = "Complete Carton";
this.sumOfPassCount = 0;
this.failCount = 0;
this.sumOfLot++;
this.currentMiddleNumber = 0;
this.currentSeqQty = 0;
this.passCount = 0;
//this.btnPassFail.Text = "PASS (" + (this.sumOfPassCount).ToString() + ") / FAIL (" + (this.failCount).ToString() + ")";
//this.lblMiddleBoxNumber.Text = this.currentMiddleNumber.ToString();
txtSerialScanData.Text = "";
_scanCartonCode = false;
timerBlink.Enabled = false;
this.cbbCarton.BackColor = Color.LightSkyBlue;
this.ActiveControl = txtSerialScanData;
//this.lblTestCount.Text = this.currentSeqQty.ToString();
return;
}
else
{
//Phoung want
errorAlarmForm = new ErrorAlarmForm(testResultInfo, false);
errorAlarmForm.Show(this);
txtSkuScanData.Text = "Scan Carton Code !";
txtSerialScanData.Clear();
this.ActiveControl = txtSerialScanData;
return;
}
}
if (this.passCount >= this._unit_1Middle) // lot + 1
{
// CHECK MIDDLE CODE
if (this.passCount == this._unit_1Middle)
{
txtSkuScanData.Text = "Scan Middle Code !";
txtSerialScanData.Clear();
_scanMiddleCode = true;
timerBlink.Enabled = true;
this.ActiveControl = txtSerialScanData;
return;
}
if (txtSerialScanData.Text.Trim() == _middleCode && passCount > _unit_1Middle)
{
passCount = 0;
this.currentMiddleNumber++;
this.sumOfLot++;
txtSerialScanData.Text = "";
txtSkuScanData.Text = "";
this.lblMiddleBoxNumber.Text = this.currentMiddleNumber.ToString();
_scanMiddleCode = false;
timerBlink.Enabled = false;
this.cbbMiddle.BackColor = Color.Khaki;
if (this.currentMiddleNumber >= this._middle_1Carton)
{
//this.sumOfLot--;
this.lblMiddleBoxNumber.Text = (this._middle_1Carton).ToString();
txtSkuScanData.Text = "Scan Carton Code !";
this.ActiveControl = txtSerialScanData;
_scanCartonCode = true;
timerBlink.Enabled = true;
}
this.ActiveControl = txtSerialScanData;
return;
}
else
{
//Phoung want
errorAlarmForm = new ErrorAlarmForm(testResultInfo, false);
errorAlarmForm.Show(this);
txtSkuScanData.Text = "Scan Middle Code !";
txtSerialScanData.Text = "";
this.ActiveControl = txtSerialScanData;
return;
}
}
}
}
txtSkuScanData.Text = "";
txtSerialScanData.Text = "";
}));
}
else
{
this.BeginInvoke(new Action(delegate()
{
errorAlarmForm = new ErrorAlarmForm(testResultInfo, false);
errorAlarmForm.Show(this);
txtSerialScanData.Text = "";
failCount++;
this.btnPassFail.Text = "PASS (" + (this.sumOfPassCount).ToString() + ") / FAIL (" + (this.failCount).ToString() + ")";
this.lblTestCount.Text = this.currentSeqQty.ToString();
this.ActiveControl = txtSerialScanData;
}));
}
}
//this.txtSerialScanData.KeyUp -= this.txtSerialScanData_KeyUp;
delay.Start();
while (true)
{
if (delay.ElapsedMilliseconds > 200)
{
delay.Stop();
break;
}
}
if (!chbSerial.Checked)
{
this.ActiveControl = txtSkuScanData;
}
else
{
this.ActiveControl = txtSerialScanData;
}
//this.txtSerialScanData.KeyUp += this.txtSerialScanData_KeyUp;
}
else
{
scannedCode.Append(KeyToUni.KeyCodeToUnicode(e.KeyCode).ToUpper()); //Khong duoc bam phim nao tren ban phim
}
}
private void textBox_Scanned_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
this.BeginInvoke(new Action(delegate()
{
textBox_Scanned.Text = scannedCode.ToString();
scannedCode.Clear();
if (function.BOX_LOT_CODE == false && function.COUNT_SETUP == false)
{
if (this.currentLotNumber > this.tray_1Box)
{
if (textBox_Scanned.Text == boxCode)
{
textBox_Scanned.Text = "Complete Box";
this.sumOfPassCount = 0;
this.failCount = 0;
this.sumOfLot++;
this.currentLotNumber = 1;
this.currentSeqQty = 0;
this.button_PassFail.Text = "PASS (" + (this.sumOfPassCount).ToString() + ") / FAIL (" + (this.failCount).ToString() + ")";
this.label_TrayNumber.Text = this.currentLotNumber.ToString();
this.label_TestCount.Text = this.currentSeqQty.ToString();
return;
}
else
{
// Phoung want
errorAlarmForm = new ErrorAlarmForm(testResultInfo, false);
errorAlarmForm.Show(this);
textBox_Scanned.Text = "Scan Box Code !";
return;
}
}
if (this.passCount >= this.sample_Tray) // lot + 1
{
// CHECK LOT CODE
if (textBox_Scanned.Text == lotCode)
{
passCount = 0;
this.currentLotNumber++;
this.sumOfLot++;
textBox_Scanned.Text = "";
this.label_TrayNumber.Text = this.currentLotNumber.ToString();
if (this.currentLotNumber > this.tray_1Box)
{
this.sumOfLot--;
this.label_TrayNumber.Text = (this.tray_1Box).ToString();
textBox_Scanned.Text = "Scan Box Code !";
}
return;
}
else
{
// Phoung want
errorAlarmForm = new ErrorAlarmForm(testResultInfo, false);
errorAlarmForm.Show(this);
textBox_Scanned.Text = "Scan Lot Code !";
return;
}
}
}
this.currentSeqQty++;
this.currentTestCount++;
if (this.function.COUNT_SETUP == false)
{
this.label_TestCount.Text = this.currentSeqQty.ToString();
}
testResultInfo.Time = DateTime.Now;
testResultInfo.Origin_Item = masterCode;
testResultInfo.Compared_Item = textBox_Scanned.Text;
testResultInfo.Sample_1Box = this.sample_1Box;
testResultInfo.Sample_Tray = this.sample_Tray;
testResultInfo.TrayNumber = this.sumOfLot;
testResultInfo.TestCount = this.currentTestCount;
if (textBox_Scanned.Text == masterCode)
{
testResultInfo.Result = true;
testResultInfo.Reason = "TEST OK";
button_PassFail.Text = "OK";
sumOfPassCount++;
passCount++;
using (conn = new SQLiteConnection(connStr))
{
conn.Open();
testResult_CRUD = new BarcodeTestResult_CRUD(conn);
testResult_CRUD.Insert(testResultInfo);
}
}
else
{
testResultInfo.Result = false;
errorAlarmForm = new ErrorAlarmForm(testResultInfo, true);
errorAlarmForm.Show(this);
failCount++;
button_PassFail.Text = "NG";
}
this.button_PassFail.Text = "PASS (" + (this.sumOfPassCount).ToString() + ") / FAIL (" + (this.failCount).ToString() + ")";
if (function.BOX_LOT_CODE == false && function.COUNT_SETUP == false)
{
if (this.passCount >= this.sample_Tray)
{
textBox_Scanned.Text = "Scan Lot Code !";
}
}
}));
this.textBox_Scanned.KeyUp -= this.textBox_Scanned_KeyUp;
Stopwatch delay = new Stopwatch();
delay.Start();
while (true)
{
if (delay.ElapsedMilliseconds > 900)
{
delay.Stop();
break;
}
}
this.textBox_Scanned.KeyUp += this.textBox_Scanned_KeyUp;
}
else
{
scannedCode.Append(KeyToUni.KeyCodeToUnicode(e.KeyCode).ToUpper());
}
}
