private void btnPrinOrder_Click(object sender, EventArgs e)
{
if (OrderLabel.Text == "فـــاتـــورة بيـــــع")
{
this.Cursor = Cursors.WaitCursor;
Reports.rpt_LastSalesOrderPrint report = new Reports.rpt_LastSalesOrderPrint();
report.SetDatabaseLogon(Program.ID,
Program.Password,
Program.Server,
Program.Database);
Reports.ReportsViewer view = new Reports.ReportsViewer();
view.CRViewer.ReportSource = report;
report.Refresh();
view.ShowDialog();
this.Cursor = Cursors.Default;
}
else
{
this.Cursor = Cursors.WaitCursor;
Reports.rpt_LastBuysOrderPrint report = new Reports.rpt_LastBuysOrderPrint();
report.SetDatabaseLogon(Program.ID,
Program.Password,
Program.Server,
Program.Database);
Reports.ReportsViewer view = new Reports.ReportsViewer();
view.CRViewer.ReportSource = report;
report.Refresh();
view.ShowDialog();
this.Cursor = Cursors.Default;
}
}
private void btnPrinOrder_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
Reports.rpt_LastBackOrderPrint report = new Reports.rpt_LastBackOrderPrint();
report.SetDatabaseLogon(Program.ID,
Program.Password,
Program.Server,
Program.Database);
Reports.ReportsViewer view = new Reports.ReportsViewer();
view.CRViewer.ReportSource = report;
report.Refresh();
view.ShowDialog();
this.Cursor = Cursors.Default;
}
private void btnBackOrdersPrint_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
Reports.rpt_MonthBackReports report = new Reports.rpt_MonthBackReports();
report.SetDatabaseLogon(Program.ID,
Program.Password,
Program.Server,
Program.Database);
Reports.ReportsViewer view = new Reports.ReportsViewer();
report.SetDataSource(rpt.MonthBackOrdersForPrint(dtmonth, "RT"));
view.CRViewer.ReportSource = report;
report.Refresh();
view.ShowDialog();
this.Cursor = Cursors.Default;
}
private void btnPrintSalesOrders_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
Reports.rpt_DayReports report = new Reports.rpt_DayReports();
report.SetDatabaseLogon(Program.ID,
Program.Password,
Program.Server,
Program.Database);
Reports.ReportsViewer view = new Reports.ReportsViewer();
report.SetDataSource(rpt.DaySalesOrders(dtdayreports.Value.Date, "SO"));
view.CRViewer.ReportSource = report;
report.Refresh();
view.ShowDialog();
this.Cursor = Cursors.Default;
}
private void بياناتالموردينToolStripMenuItem_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
Reports.ReportsViewer view = new Reports.ReportsViewer();
Reports.rpt_AllProvidersDetailes report = new Reports.rpt_AllProvidersDetailes();
report.SetDatabaseLogon(Program.ID,
Program.Password,
Program.Server,
Program.Database);
view.CRViewer.ReportSource = report;
view.ShowDialog();
Cursor = Cursors.Default;
}
private void btnPrintAccount_Click(object sender, EventArgs e)
{
if (this.Text == " كشف حساب العملاء")
{
this.Cursor = Cursors.WaitCursor;
int cusId = Convert.ToInt32(dgvPersonsList.CurrentRow.Cells[0].Value);
Reports.ReportsViewer view = new Reports.ReportsViewer();
Reports.rpt_CustomerPapersReport subreport = new Reports.rpt_CustomerPapersReport();
Reports.rpt_CustomerAccountReport report = new Reports.rpt_CustomerAccountReport();
report.SetDatabaseLogon(Program.ID,
Program.Password,
Program.Server,
Program.Database);
report.SetDataSource(acc.CustomerAccountDetailes(cusId));
subreport.SetDataSource(acc.CustomerPapersDetailes(cusId));
view.CRViewer.ReportSource = report;
report.Refresh();
view.ShowDialog();
this.Cursor = Cursors.Default;
}
else
{
this.Cursor = Cursors.WaitCursor;
int prvId = Convert.ToInt32(dgvPersonsList.CurrentRow.Cells[0].Value);
Reports.ReportsViewer view = new Reports.ReportsViewer();
Reports.rpt_ProviderAccountReport report = new Reports.rpt_ProviderAccountReport();
report.SetDatabaseLogon(Program.ID,
Program.Password,
Program.Server,
Program.Database);
Reports.rpt_ProviderrPapersReport subreport = new Reports.rpt_ProviderrPapersReport();
report.SetDataSource(acc.ProviderAccountDetailes(prvId));
subreport.SetDataSource(acc.ProviderPapersDetailes(prvId));
view.CRViewer.ReportSource = report;
report.Refresh();
view.ShowDialog();
this.Cursor = Cursors.Default;
}
}