コード例 #1
0
ファイル: Main.cs プロジェクト: NguyenVuNhan/ProP2018
 private void timer2_Tick(object sender, EventArgs e)
 {
     LbInfo.Text    = "";
     LbAlert.Text   = "";
     LbReturn.Text  = "";
     lblReturn.Text = "";
     pbMain.Hide();
     TbReturnValue.Clear();
     timer2.Enabled = false;
 }
コード例 #2
0
ファイル: Main.cs プロジェクト: NguyenVuNhan/ProP2018
        private void TbReturnValue_TextChanged(object sender, EventArgs e)
        {
            if (TbReturnValue.TextLength == 12)
            {
                string sqlCmd = "SELECT COUNT(*) FROM customer WHERE Barcode = '" + TbReturnValue.Text + "'";
                try
                {
                    connection.Open();
                    MySqlCommand CommandCheck = new MySqlCommand(sqlCmd, connection);
                    int          Exist        = Convert.ToInt32(CommandCheck.ExecuteScalar());
                    if (Exist > 0)
                    {
                        LbReturn.Text     = TbReturnValue.Text;
                        LbAlert.ForeColor = Color.Green;
                        LbAlert.Text      = "Scan a new RFID.";
                        pbMain.Image      = Properties.Resources.Check;
                        pbMain.Show();
                    }
                    else
                    {
                        LbAlert.ForeColor = Color.Red;
                        LbAlert.Text      = "Ticket does not exist.";
                        TbReturnValue.Clear();
                        playaudiofail();
                        pbMain.Image = Properties.Resources.Error;
                        pbMain.Show();
                        timer1.Enabled = true;
                    }
                }

                catch (MySqlException)
                {
                    MessageBox.Show("Unable to reach the database. Check your connection.");
                }
                finally
                {
                    if (connection != null)
                    {
                        connection.Close(); connection.Close();
                    }
                }
            }
        }