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