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