Esempio n. 1
0
        private void imprimer_adv_cause_Load(object sender, EventArgs e)
        {
            if (cn.State == ConnectionState.Closed)
            {
                cn.Open();
            }
            cmd = new SqlCommand("Select [id_adversaire_cause] as[مرجع ],[type_adv] as[النوع],[cin_adv] as[ر.ب.و],[nom_adv] as[الاسم],[adjoint_adv] as[نائب الخصم],[representant_legal_adv] as[الممثل القانوني],[registre_commerce_adv] as[السجل التجاري],[adresse_adv] as[العنوان] from adversaire_cause where id_adversaire_cause like '" + id + "%'", cn);
            da  = new SqlDataAdapter(cmd);
            da.Fill(ds, "adversaire");
            cmd1 = new SqlCommand("select top(1)*from avocat", cn);
            da1  = new SqlDataAdapter(cmd1);
            da1.Fill(ds, "avocat");

            if (type == "طبيعي")
            {
                repAdv i = new repAdv();
                i.SetDataSource(ds);
                crystalReportViewer1.ReportSource = i;
            }
            if (type == "معنوي")
            {
                repAdv1 i = new repAdv1();
                i.SetDataSource(ds);
                crystalReportViewer1.ReportSource = i;
            }

            cn.Close();
        }
Esempio n. 2
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            repAdv rpt = new repAdv();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void imprimer_adv_cause_Load(object sender, EventArgs e)
        {
            if (cn.State == ConnectionState.Closed)
            {
                cn.Open();
            }
            cmd = new SqlCommand("Select [id_adversaire_cause] as[مرجع ],[type_adv] as[النوع],[cin_adv] as[ر.ب.و],[nom_adv] as[الاسم],[adjoint_adv] as[نائب الخصم],[representant_legal_adv] as[الممثل القانوني],[registre_commerce_adv] as[السجل التجاري],[adresse_adv] as[العنوان] from adversaire_cause where id_adversaire_cause like '" + id + "%'", cn);
            da  = new SqlDataAdapter(cmd);
            da.Fill(ds, "adversaire");
            cmd1 = new SqlCommand("select top(1)*from avocat", cn);
            da1  = new SqlDataAdapter(cmd1);
            da1.Fill(ds, "avocat");
            repAdv i = new repAdv();

            i.SetDataSource(ds);
            crystalReportViewer1.ReportSource = i;
            cn.Close();

            //cmd.Connection = cn;
            //cmd.CommandText = "Select [id_adversaire_cause] as[المرجع],[type_adv] as[الاسم],[cin_adv] as[نائب الخصم],[nom_adv] as[ر.ب.و],[adjoint_adv] as[نائب الخصم],[representant_legal_adv] as[الممثل التجاري],[registre_commerce_adv] as[السجل التجاري],[adresse_adv] as[العنوان] from adversaire_cause where id_adversaire_cause like '"+id+"%'";
            //dr = cmd.ExecuteReader();
            //DataTable dt = new DataTable();
            //dt.Load(dr);
            //PrintAllOrders cr = new PrintAllOrders();
            //cr.SetDataSource(dt);
            //crystalReportViewer1.ReportSource = cr;
            //cn.Close();
            //report_Adv_Cause cr = new report_Adv_Cause();
            //cr.SetParameterValue("id", id);
            //crystalReportViewer1.ReportSource = cr;
            //crystalReportViewer1.Refresh();


            ////reportClientCause cr = new reportClientCause();
            ////cr.SetParameterValue("id", id);
            ////crystalReportViewer1.ReportSource = cr;
            ////crystalReportViewer1.Refresh();

            //strServer = Properties.Settings.Default.Server;
            //strDatabase = Properties.Settings.Default.DataBase;
            //strUserID = Properties.Settings.Default.ID;
            //strPwd = Properties.Settings.Default.PassWord;
            //cr.DataSourceConnections[0].IntegratedSecurity = false;
            //cr.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserID, strPwd);
            //cr.SetParameterValue("id", id);
            //crystalReportViewer1.ReportSource = cr;
            //crystalReportViewer1.Refresh();
        }