Beispiel #1
0
        private void frm_fondation_Load(object sender, EventArgs e)
        {
            DataSet ds  = new DataSet();
            String  sql = "select* from facture where numf = '" + numf + "' and codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'";

            Program.met.recuperer_table(sql, ds, "facture");

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

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

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

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

            TRAVAUXGR editdevis1 = new TRAVAUXGR();

            editdevis1.DataDefinition.FormulaFields["numero"].Text = "'" + numf + "'";
            editdevis1.SetDataSource(ds);
            editdevis1.Refresh();
            crystalReportViewer1.ReportSource = editdevis1;
            crystalReportViewer1.Refresh();
        }
Beispiel #2
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            TRAVAUXGR rpt = new TRAVAUXGR();

            rpt.Site = this.Site;
            return(rpt);
        }