コード例 #1
0
 private void buttonX6_Click(object sender, EventArgs e)
 {
     if (dataGridViewX1.Rows.Count != 0)
     {
         String     Nmvt       = dataGridViewX1.SelectedRows[0].Cells["NuM"].Value + "";
         String     ent        = "eentd";
         String     lent       = "lentd";
         String     numero     = "Devis";
         String     typedition = "D";
         impression form       = new impression(ent, lent, Nmvt, numero, typedition);
         form.ShowDialog();
     }
 }
コード例 #2
0
 private void buttonItem8_Click(object sender, EventArgs e)
 {
     if (dataGridViewX1.Rows.Count != 0)
     {
         if (dataGridViewX1.SelectedRows[0].Cells["mode"].Value.Equals("D"))
         {
             String     Nmvt       = dataGridViewX1.SelectedRows[0].Cells["NuM"].Value + "";
             String     ent        = "eentcs";
             String     lent       = "lentcs";
             String     numero     = "Facture";
             String     typedition = "F";
             impression form       = new impression(ent, lent, Nmvt, numero, typedition);
             form.ShowDialog();
         }
         else if (dataGridViewX1.SelectedRows[0].Cells["mode"].Value.Equals("L"))
         {
             String     Nmvt       = dataGridViewX1.SelectedRows[0].Cells["NuM"].Value + "";
             String     ent        = "eentcs";
             String     lent       = "lentl";
             String     numero     = "Facture";
             String     typedition = "FL";
             impression form       = new impression(ent, lent, Nmvt, numero, typedition);
             form.ShowDialog();
         }
         else if (dataGridViewX1.SelectedRows[0].Cells["mode"].Value.Equals("B"))
         {
             String     Nmvt       = dataGridViewX1.SelectedRows[0].Cells["NuM"].Value + "";
             String     ent        = "eentcs";
             String     lent       = "lentcsb";
             String     numero     = "Facture";
             String     typedition = "FB";
             impression form       = new impression(ent, lent, Nmvt, numero, typedition);
             form.ShowDialog();
         }
     }
 }
コード例 #3
0
        private void buttonX6_Click(object sender, EventArgs e)
        {
            if (dataGridViewX1.Rows.Count != 0)
            {
                String Nmvt       = dataGridViewX1.SelectedRows[0].Cells["NuM"].Value + "";
                String ent        = "eentcb";
                String lent       = "lentcb";
                String numero     = "Bon Comptoir";
                String typedition = "B";
                string impbon     = "";

                string  sql = "Select value From parametre where param ='BonTicket'";
                DataSet tmp = met.recuperer_table(sql);
                if (tmp.Tables[0].Rows.Count != 0)
                {
                    impbon = (string)tmp.Tables[0].Rows[0].ItemArray[0];
                }

                if (impbon == "Oui")
                {
                    ds  = new DataSet();
                    sql = "select * from exercice where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'";
                    met.recuperer_table(sql, ds, "exercice");

                    sql = "select * from ste where code='" + Program.Societe + "'";
                    met.recuperer_table(sql, ds, "ste");

                    sql = "SELECT * FROM entete  where codes='" + Program.Societe + "'";
                    met.recuperer_table(sql, ds, "entete");

                    sql = "select * from magasin where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and code = '" + Program.Magasin + "'";
                    met.recuperer_table(sql, ds, "magasin");

                    sql = "select * from " + ent + " where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem = '" + Program.Magasin + "' and num ='" + Nmvt + "'";
                    met.recuperer_table(sql, ds, "eentl");

                    sql = "select * from " + lent + " where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem = '" + Program.Magasin + "' and num ='" + Nmvt + "'";
                    met.recuperer_table(sql, ds, "lentl");

                    sql = "select * from client where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'  order by code";
                    met.recuperer_table(sql, ds, "client");

                    sql = "SELECT * FROM sarticle  where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' ";
                    met.recuperer_table(sql, ds, "sarticle");

                    sql = "SELECT * FROM gamme  where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' ";
                    met.recuperer_table(sql, ds, "gamme");

                    sql = "SELECT * FROM article WHERE codes='" + Program.Societe + "' AND codee='" + Program.Exercice + "' Order by code";
                    met.recuperer_table(sql, ds, "article");


                    commerciale.rptedit.Iticket ij = new commerciale.rptedit.Iticket();
                    ij.numero = numero;
                    ij.ds     = ds;
                    ij.ShowDialog();
                }
                else
                {
                    impression form = new impression(ent, lent, Nmvt, numero, typedition);
                    form.ShowDialog();
                }
            }
        }