public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SummeryReport rpt = new SummeryReport(); rpt.Site = this.Site; return(rpt); }
private void dataGridView_displayCustomers_CellContentClick(object sender, DataGridViewCellEventArgs e) { var dt = new DataTable(); var UsedClass = new BasicClass(); var crp = new Reports.CustomerReports_Sale_buy(); var form = new PrintForm(); TextObject CustomerName = (TextObject)crp.ReportDefinition.Sections["Section1"].ReportObjects["Text2"]; SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 250); param[1] = new SqlParameter("@InvoiceType", SqlDbType.NVarChar, 250); param[2] = new SqlParameter("@InvoiceStatus", SqlDbType.NVarChar, 250); if (e.RowIndex >= 0) { param[0].Value = dataGridView_displayCustomers.Rows[e.RowIndex].Cells["ColumnCustomerName"].Value.ToString(); CustomerName.Text = dataGridView_displayCustomers.Rows[e.RowIndex].Cells["ColumnCustomerName"].Value.ToString(); switch (e.ColumnIndex) { case 0: //invoiceType.Text = "فواتير الشراء"; param[1].Value = "شراء"; param[2].Value = "Run"; dt = UsedClass.selectdata("Reports_Customers_Select_invoicesDepandonInvoiceType_and_invoiceStatus", param); crp.SetDataSource(dt); form.crystalReportViewer1.ReportSource = crp; if (dt.Rows.Count == 0) { MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE"); } else { form.ShowDialog(); } break; case 1: //invoiceType.Text = "فواتير البيع"; param[1].Value = "بيع"; param[2].Value = "Run"; dt = UsedClass.selectdata("Reports_Customers_Select_invoicesDepandonInvoiceType_and_invoiceStatus", param); crp.SetDataSource(dt); form.crystalReportViewer1.ReportSource = crp; if (dt.Rows.Count == 0) { MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE"); } else { form.ShowDialog(); } //crp.SetDataSource ( dt ); //form.crystalReportViewer1.ReportSource = crp; //form.ShowDialog (); break; case 2: //invoiceType.Text = "فواتير المحجوزة"; param[1].Value = "بيع"; param[2].Value = "Save"; dt = UsedClass.selectdata("Reports_Customers_Select_invoicesDepandonInvoiceType_and_invoiceStatus", param); crp.SetDataSource(dt); form.crystalReportViewer1.ReportSource = crp; if (dt.Rows.Count == 0) { MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE"); } else { form.ShowDialog(); } break; case 3: param[1].Value = "شراء"; param[2].Value = "Save"; dt = UsedClass.selectdata("Reports_Customers_Select_invoicesDepandonInvoiceType_and_invoiceStatus", param); crp.SetDataSource(dt); form.crystalReportViewer1.ReportSource = crp; if (dt.Rows.Count == 0) { MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE"); } else { form.ShowDialog(); } break; case 4: SqlParameter[] parameter = new SqlParameter[1]; parameter[0] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 150); parameter[0].Value = dataGridView_displayCustomers.Rows[e.RowIndex].Cells["ColumnCustomerName"].Value.ToString(); dt = UsedClass.selectdata("Reports_Summery", parameter); var Crp2 = new Reports.SummeryReport(); Crp2.SetDataSource(dt); form.crystalReportViewer1.ReportSource = Crp2; if (dt.Rows.Count == 0) { MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE"); } else { form.ShowDialog(); } break; default: break; } } }