Пример #1
0
 private void Txt_NumCde_KeyPress(object sender, KeyPressEventArgs e)
 {
     if (e.KeyChar == (char)13)
     {
         Boolean val = CommandeDAO.Existe_Commande(Txt_NumCde.Text);
         if (val)
         {
             Pan_LigC.Visible = true;
             DataTable dtlc = LigneCommandeDAO.List_LigneCommande_ParNum(Txt_NumCde.Text);
             foreach (DataRow row in dtlc.Rows)
             {
                 DataTable dtpr = ProduitDAO.List_Prod_Ref(row["Ref_Prod"].ToString());
                 Dg_Prod.Rows.Add(row["Ref_Prod"].ToString(), dtpr.Rows[0]["Desig_Prod"].ToString(), dtpr.Rows[0]["PrixV_Prod"].ToString(), row["qte"].ToString(), Convert.ToInt32(dtpr.Rows[0]["PrixV_Prod"].ToString()) * Convert.ToInt32(row["qte"].ToString()));
                 totalCde += Convert.ToInt32(dtpr.Rows[0]["PrixV_Prod"].ToString()) * Convert.ToInt32(row["qte"].ToString());
             }
             DataTable dtc = CommandeDAO.List_Com_Num(Txt_NumCde.Text);
             DataTable dt  = ClientADO.Liste_Client_ParCin(Convert.ToInt64(dtc.Rows[0]["cin_cl"].ToString()));
             Txt_cin.Text      = dt.Rows[0]["cin_cl"].ToString();
             Txt_nom.Text      = dt.Rows[0]["Nom_cl"].ToString();
             Txt_prenom.Text   = dt.Rows[0]["pren_cl"].ToString();
             Txt_vil.Text      = dt.Rows[0]["ville_cl"].ToString();
             Txt_tel.Text      = dt.Rows[0]["tel_cl"].ToString();
             Txt_TotalCde.Text = totalCde.ToString();
         }
         else
         {
             Pan_LigC.Visible = true;
         }
     }
 }
Пример #2
0
 private void Rechercher_Click(object sender, EventArgs e)
 {
     if (!string.IsNullOrEmpty(Txt_Ref.Text))
     {
         DG_Prod.DataSource = ProduitDAO.List_Prod_Ref(Txt_Ref.Text);
     }
     else if (!string.IsNullOrEmpty(Txt_Desig.Text))
     {
         DG_Prod.DataSource = ProduitDAO.List_Prod_Des(Txt_Desig.Text);
     }
     else if (!string.IsNullOrEmpty(Cmb_Categ.Text))
     {
         DG_Prod.DataSource = ProduitDAO.List_Prod_ParCateg(Cmb_Categ.Text);
     }
 }
Пример #3
0
        private void pictureBox2_Click(object sender, EventArgs e)
        {
            FProduit f = new FProduit();

            f.TypeOP = "M";
            DataTable dt = new DataTable();

            dt               = ProduitDAO.List_Prod_Ref(Txt_Ref.Text);
            f.Txt_Ref.Text   = dt.Rows[0]["Ref_Prod"].ToString();
            f.Txt_Desig.Text = dt.Rows[0]["Desig_Prod"].ToString();
            f.Cmb_Categ.Text = dt.Rows[0]["Categ_Prod"].ToString();
            f.Txt_Prix.Text  = dt.Rows[0]["PrixV_Prod"].ToString();
            f.Txt_Qte.Text   = dt.Rows[0]["Qte_prod"].ToString();
            f.ShowDialog();
        }