예제 #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            PrintAllOrdersReport rpt = new PrintAllOrdersReport();

            rpt.Site = this.Site;
            return(rpt);
        }
예제 #2
0
        private void PrintAllOrdersForm_Load(object sender, EventArgs e)
        {
            DataSet2             ds = new DataSet2();
            PrintAllOrdersReport cr = new PrintAllOrdersReport();
            SqlConnection        cn = connection.getConnection();
            String         query1   = "select o.id_order,o.signe_order,o.date_order,o.commissaire_judiciaire,o.ville,o.tribunal,c.nom as 'id_client_order',a.nom as 'id_adversaire_order',o.decision,o.type from orderr o,adv_order a,client_order c where o.id_adversaire_order=a.id_adv_order and o.id_client_order=c.id_client_order";
            SqlDataAdapter da       = new SqlDataAdapter(query1, cn);

            da.Fill(ds, "orderr");

            string         query2 = "select nom_avocat,adresse,autorite from avocat";
            SqlDataAdapter da2    = new SqlDataAdapter(query2, cn);

            da2.Fill(ds, "avocat");

            cr.SetDataSource(ds);
            crystalReportViewer1.ReportSource = cr;
            crystalReportViewer1.Refresh();
        }