public void LoadData()
{
TfSQL tf = new TfSQL();
string sqlExport = "select row_number() over(order by a90_datetime asc) stt, a90_model Model, a90_line line, a90_barcode Barcode, a90_status ThurstStatus,a90_noise_status as NoiseStatus, a90_datetime DateTime from t_checkpusha90main where a90_datetime > '" + dtpFrom.Value.ToString() + "' order by a90_datetime desc";
DataTable dt = new DataTable();
tf.sqlDataAdapterFillDatatable(sqlExport, ref dt);
dgvData.DataSource = dt;
dgvData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvData.Columns["stt"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
if (dgvData.RowCount > 0)
{
for (int i = 0; i < dgvData.RowCount; i++)
{
if (dgvData.Rows[i].Cells["ThurstStatus"].Value.ToString() == "NG")
{
dgvData.Rows[i].Cells["ThurstStatus"].Style.BackColor = Color.Red;
}
if (dgvData.Rows[i].Cells["NoiseStatus"].Value.ToString() == "NG")
{
dgvData.Rows[i].Cells["NoiseStatus"].Style.BackColor = Color.Red;
}
}
}
}
public void LoadDGVOQC(DataGridView datagv, string barcode, bool order)
{
TfSQL tf = new TfSQL();
DataTable dt = new DataTable();
string sqlDGV = "select a90_barcode, a90_status, a90_noise_status,a90_oqc_status, a90_oqc_data, a90_datetime from t_checkpusha90main where a90_barcode = '" + barcode + "' ";
if (order)
{
sqlDGV += "order by a90_datetime desc limit 1";
}
else
{
sqlDGV += "order by a90_datetime desc";
}
tf.sqlDataAdapterFillDatatable(sqlDGV, ref dt);
datagv.DataSource = dt;
if (datagv.RowCount > 0)
{
datagv.Columns["a90_barcode"].HeaderText = "Barcode";
datagv.Columns["a90_status"].HeaderText = "Thurst Status ";
datagv.Columns["a90_datetime"].HeaderText = "DateTime";
datagv.Columns["a90_noise_status"].HeaderText = "Noise Status";
datagv.Columns["a90_oqc_status"].HeaderText = "OQC Status";
datagv.Columns["a90_oqc_data"].HeaderText = "OQC Data";
}
datagv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public void UpdateStatusOQC(MouseEventArgs e)
{
if (login)
{
if (txt_barcodeOQC.Text.Trim() != "" || txt_dataOQC.Text.Trim() != "")
{
TfSQL tf = new TfSQL();
string sqlcheckbarcode = "select count(*) from t_checkpusha90main where a90_barcode = '" + txt_barcodeOQC.Text + "'";
int checkbarcode = int.Parse(tf.sqlExecuteScalarString(sqlcheckbarcode));
if (checkbarcode > 0)
{
string status = "";
if (e.Button == MouseButtons.Right)
{
status = "NG";
btn_statusOQC.Text = "NG";
btn_statusOQC.BackColor = Color.Red;
}
if (e.Button == MouseButtons.Left)
{
status = "OK";
btn_statusOQC.Text = "OK";
btn_statusOQC.BackColor = Color.Green;
}
string sqlUpdate = "update t_checkpusha90main set a90_oqc_status = '" + status + "', a90_oqc_data = '" + txt_dataOQC.Text + "' where a90_barcode = '" + txt_barcodeOQC.Text + "'";
if (tf.sqlExecuteNonQuery(sqlUpdate, false))
{
LoadDGVOQC(dgv_OQC, txt_barcodeOQC.Text, true);
txt_barcodeOQC.Text = null;
txt_barcodeOQC.SelectNextControl(txt_barcodeOQC, true, false, true, true); //trả lại con chỏ vô textbox
timerOQC.Interval = int.Parse(txt_timerOQC.Text) * 1000;
timerOQC.Enabled = true;
}
else
{
dgv_OQC.DataSource = null;
}
}
else
{
MessageBox.Show("Barocde No is Null <Không có Mã barcode này >", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
else
{
return;
}
}
else
{
MessageBox.Show("Not Login <Chưa đăng nhập> ", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
public void AddStatus(MouseEventArgs e)
{
if (login)
{
if (txt_barcode.Text.Trim() != "")
{
string status = "";
if (e.Button == MouseButtons.Right)
{
status = "NG";
btn_status.Text = "NG";
btn_status.BackColor = Color.Red;
}
if (e.Button == MouseButtons.Left)
{
status = "OK";
btn_status.Text = "OK";
btn_status.BackColor = Color.Green;
}
TfSQL tf = new TfSQL();
string sqlInsert = "insert into t_checkpusha90main(a90_model, a90_line, a90_barcode, a90_status, a90_datetime ,a90_factory) ";
sqlInsert += "values('" + lbl_model.Text + "','" + lbl_line.Text + "','" + txt_barcode.Text + "','" + status + "', now(),'NCVP')";
if (tf.sqlExecuteNonQuery(sqlInsert, false))
{
LoadDGV(dgv, txt_barcode.Text, true);
txt_barcode.Text = null;
txt_barcode.SelectNextControl(txt_barcode, true, false, true, true);
timer1.Interval = int.Parse(txtTimer.Text) * 1000;
timer1.Enabled = true;
}
else
{
dgv.DataSource = null;
}
}
else
{
return;
}
}
else
{
MessageBox.Show("Not Login <Chưa đăng nhập> ", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void btn_check_Click(object sender, EventArgs e)
{
if (txt_barcodeCheck.Text != "")
{
LoadDGVOQC(dgvCheck, txt_barcodeCheck.Text, false);
TfSQL con = new TfSQL();
string sql_thurst = "select a90_status from t_checkpusha90main where a90_barcode = '" + txt_barcodeCheck.Text + "' order by a90_id desc limit 1";
string sql_noise = "select a90_noise_status from t_checkpusha90main where a90_barcode = '" + txt_barcodeCheck.Text + "' order by a90_id desc limit 1";
string sql_oqc = "select a90_oqc_status from t_checkpusha90main where a90_barcode = '" + txt_barcodeCheck.Text + "' order by a90_id desc limit 1";
string thurst_status = con.sqlExecuteScalarString(sql_thurst);
string noise_status = con.sqlExecuteScalarString(sql_noise);
string oqc_status = con.sqlExecuteScalarString(sql_oqc);
if (thurst_status == "OK")
{
btn_thurststatus.Text = "OK";
btn_thurststatus.BackColor = Color.Green;
txt_barcodeCheck.Text = "";
}
else if (thurst_status == "NG")
{
btn_thurststatus.Text = "NG";
btn_thurststatus.BackColor = Color.Red;
txt_barcodeCheck.Text = "";
}
if (noise_status == "OK")
{
btn_noisestatus.Text = "OK";
btn_noisestatus.BackColor = Color.Green;
txt_barcodeCheck.Text = "";
}
else if (noise_status == "NG")
{
btn_noisestatus.Text = "NG";
btn_noisestatus.BackColor = Color.Red;
txt_barcodeCheck.Text = "";
}
if (oqc_status == "OK")
{
lblOQC.Text = "Checked";
txt_barcodeCheck.Text = "";
}
else if (oqc_status == "NG")
{
lblOQC.Text = "Checked";
txt_barcodeCheck.Text = "";
}
if (oqc_status == "")
{
lblOQC.Text = "Not Checked";
txt_barcodeCheck.Text = "";
//192, 192, 255
}
if (thurst_status == "")
{
btn_thurststatus.Text = "WAITING";
btn_thurststatus.BackColor = SystemColors.Control;
txt_barcodeCheck.Text = "";
}
if (noise_status == "")
{
btn_noisestatus.Text = "WAITING";
btn_noisestatus.BackColor = SystemColors.Control;
txt_barcodeCheck.Text = "";
}
}
else
{
MessageBox.Show("Barocde No is Null <Chưa nhập Barcode>", "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
btn_thurststatus.Text = "WAITING";
btn_thurststatus.BackColor = SystemColors.Control;
btn_noisestatus.Text = "WAITING";
btn_noisestatus.BackColor = SystemColors.Control;
}
}
