Beispiel #1
0
        private void textBoxClient_TextChanged(object sender, EventArgs e)
        {
            string        sql = "SELECT * FROM Clienti WHERE Nume = '" + textBoxClient.Text + "' ";
            SqlCommand    cmd = new SqlCommand(sql, con);
            SqlDataReader NrReader;

            try
            {
                con.Open();
                NrReader = cmd.ExecuteReader();

                while (NrReader.Read())
                {
                    string sAdresa     = NrReader.GetString(2).ToString();
                    string sCod_fiscal = NrReader.GetString(3).ToString();
                    textBoxAdresaC.Text = sAdresa;
                    textBoxCifC.Text    = sCod_fiscal;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
            }
        }
Beispiel #2
0
        private void textBoxTipProdus_TextChanged(object sender, EventArgs e)
        {
            string        sql = "SELECT * FROM Produse WHERE Nume = '" + textBoxTipProdus.Text + "' ";
            SqlCommand    cmd = new SqlCommand(sql, con);
            SqlDataReader NrReader;

            try
            {
                con.Open();
                NrReader = cmd.ExecuteReader();

                while (NrReader.Read())
                {
                    string sCod_produs = NrReader.GetString(3).ToString();
                    string sLot        = NrReader.GetString(4).ToString();
                    string sData       = NrReader.GetString(5).ToString();
                    string sNatura     = NrReader.GetString(2).ToString();
                    textBoxProdus.Text  = sNatura;
                    textBoxCodP.Text    = sCod_produs;
                    textBoxLot.Text     = sLot;
                    textBoxDataExp.Text = sData;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
            }
        }
Beispiel #3
0
        private void InfoMetrologic_Load(object sender, EventArgs e)
        {
            string sql = "SELECT * FROM Metrologie";

            SqlCommand cmd = new SqlCommand(sql, con);


            SqlDataReader NrReader;

            try
            {
                con.Open();
                NrReader = cmd.ExecuteReader();

                // while (NrReader.Read())
                {
                    NrReader.Read();
                    string sNrCantar           = NrReader.GetString(0).ToString();
                    string sSerie_indicator    = NrReader.GetString(1).ToString();
                    string sBuletin_metrologic = NrReader.GetString(2).ToString();
                    string sClasa_precizie     = NrReader.GetString(3).ToString();
                    string sTip_cantarire      = NrReader.GetString(4).ToString();
                    string sTip_cantar         = NrReader.GetString(6).ToString();

                    // textBoxNrCantar.Text = sNrCantar;
                    textBoxSerieIndicator.Text = sSerie_indicator;
                    textBoxBuletin.Text        = sBuletin_metrologic;
                    textBoxClasaPrecizie.Text  = sClasa_precizie;
                    textBoxTipCantarire.Text   = sTip_cantarire;
                    comboBox1.Text             = sTip_cantar;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
            }
        }
        private void dataGridViewIstoric_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            int RowIndex = e.RowIndex;

            raportId = int.Parse(dataGridViewIstoric.Rows[RowIndex].Cells[0].Value.ToString());
            DataTable dt = rdal.CustomSelect(con, raportId);


            textBoxCodP       = dt.Rows[0].ItemArray[1].ToString();
            textBoxCodC       = dt.Rows[0].ItemArray[2].ToString();
            textBoxCodF       = dt.Rows[0].ItemArray[3].ToString();
            file.GreutateNeta = dt.Rows[0].ItemArray[4].ToString();
            file.DataTichet   = dt.Rows[0].ItemArray[5].ToString();
            file.NrTichet     = dt.Rows[0].ItemArray[6].ToString();

            //initializare campuri necompletate
            file.GreutateBrut = "-";
            file.GreutateTara = "-";

            //autocomplete produss
            #region Repopulare produse
            {
                string        sql = "SELECT * FROM Produse WHERE ID_produs = '" + textBoxCodP + "' ";
                SqlCommand    cmd = new SqlCommand(sql, con);
                SqlDataReader NrReader;

                try
                {
                    con.Open();
                    NrReader = cmd.ExecuteReader();
                    {
                        NrReader.Read();
                        file.DenumireProdus      = NrReader.GetString(1).ToString();
                        file.NaturaProdus        = NrReader.GetString(2).ToString();
                        file.CodProdus           = NrReader.GetString(3).ToString();
                        file.LotProdus           = NrReader.GetString(4).ToString();
                        file.DataExpirariiProdus = NrReader.GetString(5).ToString();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally
                {
                    con.Close();
                }
            }
            #endregion


            //autocomplete furnizori
            #region Repopulare furnizori
            {
                string        sql = "SELECT * FROM Furnizori WHERE ID_furnizor = '" + textBoxCodF + "' ";
                SqlCommand    cmd = new SqlCommand(sql, con);
                SqlDataReader NrReader;
                try
                {
                    con.Open();
                    NrReader = cmd.ExecuteReader();
                    {
                        NrReader.Read();
                        file.DenumireFurnizor = NrReader.GetString(1).ToString();
                        file.AdresaFurnizor   = NrReader.GetString(2).ToString();
                        file.CifFurnizor      = NrReader.GetString(3).ToString();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally
                {
                    con.Close();
                }
            }
            #endregion

            //autocomplete clienti
            #region Repopulare Clienti
            {
                string        sql = "SELECT * FROM Clienti WHERE ID_client = '" + textBoxCodC + "' ";
                SqlCommand    cmd = new SqlCommand(sql, con);
                SqlDataReader NrReader;
                try
                {
                    con.Open();
                    NrReader = cmd.ExecuteReader();
                    {
                        NrReader.Read();
                        file.DenumireClient = NrReader.GetString(1).ToString();
                        file.AdresaClient   = NrReader.GetString(2).ToString();
                        file.CifClient      = NrReader.GetString(3).ToString();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally
                {
                    con.Close();
                }
            }
            #endregion
        }