コード例 #1
0
ファイル: FichePrg.cs プロジェクト: sidot411/AGERFOR-SOFT
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            FichePrg rpt = new FichePrg();

            rpt.Site = this.Site;
            return(rpt);
        }
コード例 #2
0
        private void report_Load(object sender, EventArgs e)
        {
            if (NatureProgramme == "Logement")
            {
                try
                {
                    string           query = "select * from projet,programme,edd,permisdeconstruire where programme.RefProgramme='" + CodeProgramme + "' and programme.RefProgramme= edd.RefProgramme and programme.RefProgramme = permisdeconstruire.RefProgramme AND programme.RefProjet = projet.RefProjet and edd.DatePubli=(SELECT MAX(DatePubli) from edd where RefProgramme='" + CodeProgramme + "')";
                    MySqlConnection  con   = new MySqlConnection(Database.ConnectionString());
                    FichePrg         FP    = new FichePrg();
                    MySqlDataAdapter dab   = new MySqlDataAdapter(query, con);
                    DataSet1         DSP   = new DataSet1();
                    dab.Fill(DSP.DataTable1);
                    FP.SetDataSource((DataTable)DSP.DataTable1);

                    crystalReportViewer1.ReportSource = FP;
                    crystalReportViewer1.Refresh();
                    con.Close();
                }

                catch (Exception ex)
                {
                    MessageBox.Show("Veuillez selectionner un programme \n" + ex.Message + "\n");
                }
            }
            else if (NatureProgramme == "Terrain")
            {
                try
                {
                    string           query = "select * from projet,programme,permilotir,cahierchargeprogramme where programme.RefProgramme='" + CodeProgramme + "' and programme.RefProgramme=cahierchargeprogramme.RefProgramme and programme.RefProgramme = permilotir.RefProgramme AND programme.RefProjet = projet.RefProjet and permilotir.DatePL=(SELECT MAX(DatePL) from permilotir where RefProgramme='" + CodeProgramme + "') and cahierchargeprogramme.DatePubli=(SELECT MAX(DatePubli) from cahierchargeprogramme where RefProgramme='" + CodeProgramme + "'))";
                    MySqlConnection  con   = new MySqlConnection(Database.ConnectionString());
                    FichePrgT        FP    = new FichePrgT();
                    MySqlDataAdapter dab   = new MySqlDataAdapter(query, con);
                    DataSet1         DSP   = new DataSet1();
                    dab.Fill(DSP.DataTable1);
                    FP.SetDataSource((DataTable)DSP.DataTable1);

                    crystalReportViewer1.ReportSource = FP;
                    crystalReportViewer1.Refresh();
                    con.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Veuillez selectionner un programme \n" + ex.Message + "\n");
                }
            }
        }