private void btnOK_Click(object sender, EventArgs e) { BalanceReportDataTable balanceReportDataTable; ReportDocument reportDocument = new ReportDocument(); reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\BalanceReportCR.rpt")); ReportBll reportBll = new ReportBll(); DateTime @value = this.dtDate.Value; DateTime date = @value.Date; int selectedValue = (int)this.ddlAccounts.SelectedValue; string str = string.Concat(this.ddlAccounts.SelectedValue.ToString(), " | ", this.ddlAccounts.GetItemText(this.ddlAccounts.SelectedItem)); if (this.category != 0) { balanceReportDataTable = reportBll.BalanceReportByCategory(selectedValue, date); } else { balanceReportDataTable = reportBll.BalanceReportByAccount(selectedValue, date); } reportDocument.SetDataSource(balanceReportDataTable); ParameterValues parameterValue1 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue(); parameterDiscreteValue1.set_Value(str); parameterValue1.Add(parameterDiscreteValue1); reportDocument.DataDefinition.ParameterFields["account"].ApplyCurrentValues(parameterValue1); ParameterValues parameterValue2 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue2 = new ParameterDiscreteValue(); parameterDiscreteValue2.set_Value(date); parameterValue2.Add(parameterDiscreteValue2); reportDocument.DataDefinition.ParameterFields["dtTo"].ApplyCurrentValues(parameterValue2); ReportFrom reportFrom = new ReportFrom(); reportFrom.crViewer.set_ReportSource(reportDocument); reportFrom.MdiParent = this.form1; reportFrom.Anchor = AnchorStyles.Top | AnchorStyles.Right; reportFrom.Dock = DockStyle.Fill; reportFrom.reportType = ReportType.None; reportFrom.Show(); base.Close(); base.Dispose(); }
internal void btnPrint_Click(object sender, EventArgs e) { if (this.dgvJournal.Rows.Count <= 0) { MessageBox.Show("لا يوجد بيانات للطباعه"); } else { if (this._journal.getJournal().Count == 0) { MessageBox.Show("لا يمكن طباعة بيانات غير مرحلة"); } else { ReportDocument reportDocument = new ReportDocument(); reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\JournalCR.rpt")); DailyJournalDataTable dailyJournalDataTable = this.fillTable(this._journal.getJournal()); reportDocument.SetDataSource(dailyJournalDataTable); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); ParameterValues parameterValue = new ParameterValues(); if (string.IsNullOrEmpty(this.dateString)) { DateTime @value = this.dtDate.Value.set_Value(@value.ToShortDateString()); } else { parameterDiscreteValue.set_Value(this.dateString); } parameterValue.Add(parameterDiscreteValue); reportDocument.DataDefinition.ParameterFields["date"].ApplyCurrentValues(parameterValue); if (this.printDialog1.ShowDialog() == 1) { reportDocument.PrintOptions.set_PrinterName(this.printDialog1.PrinterSettings.PrinterName); reportDocument.PrintToPrinter(1, false, 1, 1); } } } }
private void TransactionsReportFrom_Load(object sender, EventArgs e) { string str; ReportDocument reportDocument; ReportDataTable reportDataTable; ParameterValues parameterValue; ParameterDiscreteValue parameterDiscreteValue; ParameterValues parameterValue2; ParameterDiscreteValue parameterDiscreteValue2; ParameterValues parameterValue3; ParameterDiscreteValue parameterDiscreteValue3; ParameterValues parameterValue4; ParameterDiscreteValue parameterDiscreteValue4; ReportDocument reportDocument2; ParameterValues parameterValue5; ParameterDiscreteValue parameterDiscreteValue5; ParameterValues parameterValue6; ParameterDiscreteValue parameterDiscreteValue6; ReportDocument reportDocument3; ParameterValues parameterValue7; ParameterDiscreteValue parameterDiscreteValue7; ParameterValues parameterValue8; ParameterDiscreteValue parameterDiscreteValue8; ReportDocument reportDocument4; ParameterValues parameterValue9; ParameterDiscreteValue parameterDiscreteValue9; ParameterValues parameterValue10; ParameterDiscreteValue parameterDiscreteValue10; ReportDocument reportDocument5; AccountsViewDataTable accountsViewDataTable; ReportDocument reportDocument6; ReportDocument reportDocument7; ReportDocument reportDocument8; ParameterValues parameterValue11; ParameterDiscreteValue parameterDiscreteValue11; ParameterValues parameterValue12; ParameterDiscreteValue parameterDiscreteValue12; AccountsBLL accountsBLL = new AccountsBLL(); Cursor.Current = Cursors.WaitCursor; base.WindowState = FormWindowState.Maximized; switch (this.reportType) { case ReportType.TrialBalance: { this.set_Text("ميزان المراجعة"); reportDocument3 = new ReportDocument(); reportDocument3.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\TrialBalanceCR.rpt")); reportDocument3.SetDataSource(this._reportBll.getTrialBalance(this.From, this.To)); parameterValue7 = new ParameterValues(); parameterDiscreteValue7 = new ParameterDiscreteValue(); parameterDiscreteValue7.set_Value(this.From); parameterValue7.Add(parameterDiscreteValue7); reportDocument3.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue7); parameterValue8 = new ParameterValues(); parameterDiscreteValue8 = new ParameterDiscreteValue(); parameterDiscreteValue8.set_Value(this.To); parameterValue8.Add(parameterDiscreteValue8); reportDocument3.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue8); this.crViewer.set_ReportSource(reportDocument3); } case ReportType.BalanceSheet: { this.set_Text("الميزانية العمومية"); reportDocument4 = new ReportDocument(); reportDocument4.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\BalanceSheetCR.rpt")); reportDocument4.SetDataSource(this._reportBll.getBalanceSheet(this.From, this.To)); parameterValue9 = new ParameterValues(); parameterDiscreteValue9 = new ParameterDiscreteValue(); parameterDiscreteValue9.set_Value(this.From); parameterValue9.Add(parameterDiscreteValue9); reportDocument4.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue9); parameterValue10 = new ParameterValues(); parameterDiscreteValue10 = new ParameterDiscreteValue(); parameterDiscreteValue10.set_Value(this.To); parameterValue10.Add(parameterDiscreteValue10); reportDocument4.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue10); this.crViewer.set_ReportSource(reportDocument4); } case ReportType.Transactions: { this.set_Text("كشف حركة حساب"); str = accountsBLL.GetAccountByID(this.account)[0].GL_Name_VC; reportDocument = new ReportDocument(); reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\reportTest.rpt")); reportDataTable = this._reportBll.getByCodeDate(this.From, this.To, this.account); reportDocument.SetDataSource(reportDataTable); parameterValue = new ParameterValues(); parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.set_Value(str); parameterValue.Add(parameterDiscreteValue); reportDocument.DataDefinition.ParameterFields["account"].ApplyCurrentValues(parameterValue); parameterValue2 = new ParameterValues(); parameterDiscreteValue2 = new ParameterDiscreteValue(); parameterDiscreteValue2.set_Value(this.From); parameterValue2.Add(parameterDiscreteValue2); reportDocument.DataDefinition.ParameterFields["dtFrom"].ApplyCurrentValues(parameterValue2); parameterValue3 = new ParameterValues(); parameterDiscreteValue3 = new ParameterDiscreteValue(); parameterDiscreteValue3.set_Value(this.To); parameterValue3.Add(parameterDiscreteValue3); reportDocument.DataDefinition.ParameterFields["dtTo"].ApplyCurrentValues(parameterValue3); parameterValue4 = new ParameterValues(); parameterDiscreteValue4 = new ParameterDiscreteValue(); parameterDiscreteValue4.set_Value(reportDataTable[reportDataTable.Count - 1].Balance); parameterValue4.Add(parameterDiscreteValue4); reportDocument.DataDefinition.ParameterFields["tBalance"].ApplyCurrentValues(parameterValue4); this.crViewer.set_ReportSource(reportDocument); } case ReportType.ProfitAndLoss: { this.set_Text("بيان الأرباح والخسائر"); reportDocument2 = new ReportDocument(); reportDocument2.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\ProfitLossCR.rpt")); reportDocument2.SetDataSource(this._reportBll.getProfitAndLoss(this.From, this.To)); parameterValue5 = new ParameterValues(); parameterDiscreteValue5 = new ParameterDiscreteValue(); parameterDiscreteValue5.set_Value(this.From); parameterValue5.Add(parameterDiscreteValue5); reportDocument2.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue5); parameterValue6 = new ParameterValues(); parameterDiscreteValue6 = new ParameterDiscreteValue(); parameterDiscreteValue6.set_Value(this.To); parameterValue6.Add(parameterDiscreteValue6); reportDocument2.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue6); this.crViewer.set_ReportSource(reportDocument2); } case ReportType.Accounts: { this.set_Text("كشف أرصدة مجموعة حسابات"); reportDocument5 = new ReportDocument(); reportDocument5.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\AccountsCR.rpt")); accountsViewDataTable = new AccountsBLL().GetAccountsView(); reportDocument5.SetDataSource(accountsViewDataTable); this.crViewer.set_ReportSource(reportDocument5); this.set_Text("الموظفون"); reportDocument6 = new ReportDocument(); reportDocument6.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\EmployeeCR.rpt")); reportDocument6.SetDataSource(new EmployeeBll().getEmployee()); this.crViewer.set_ReportSource(reportDocument6); this.set_Text("الموردون"); reportDocument7 = new ReportDocument(); reportDocument7.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\SupplierCR.rpt")); reportDocument7.SetDataSource(new SupplierBll().getSuppliers()); this.crViewer.set_ReportSource(reportDocument7); this.set_Text("مجمع الإهلاك"); reportDocument8 = new ReportDocument(); reportDocument8.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\fixedCR.rpt")); reportDocument8.SetDataSource(this._reportBll.FixedAssetsReport(this.From, this.To)); parameterValue11 = new ParameterValues(); parameterDiscreteValue11 = new ParameterDiscreteValue(); parameterDiscreteValue11.set_Value(this.From); parameterValue11.Add(parameterDiscreteValue11); reportDocument8.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue11); parameterValue12 = new ParameterValues(); parameterDiscreteValue12 = new ParameterDiscreteValue(); parameterDiscreteValue12.set_Value(this.To); parameterValue12.Add(parameterDiscreteValue12); reportDocument8.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue12); this.crViewer.set_ReportSource(reportDocument8); goto; } case ReportType.None: { this.set_Cursor(Cursors.Default); return; } } }
internal void tsPrint_Click(object sender, EventArgs e) { if (WithdrawalForm._print != 0) { if (this.printDialog1.ShowDialog() == 1) { VoucherDataTable voucher = this._voucher.getVoucher(WithdrawalForm._voucherID); ReportDocument reportDocument = new ReportDocument(); reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\VoucherCR.rpt")); ParameterValues parameterValue1 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue(); parameterDiscreteValue1.set_Value("سند صرف"); parameterValue1.Add(parameterDiscreteValue1); reportDocument.DataDefinition.ParameterFields["title"].ApplyCurrentValues(parameterValue1); ParameterValues parameterValue2 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue2 = new ParameterDiscreteValue(); parameterDiscreteValue2.set_Value(this.lblName.Text); parameterValue2.Add(parameterDiscreteValue2); reportDocument.DataDefinition.ParameterFields["lblAccName"].ApplyCurrentValues(parameterValue2); ParameterValues parameterValue3 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue3 = new ParameterDiscreteValue(); parameterDiscreteValue3.set_Value(voucher[0].CName); parameterValue3.Add(parameterDiscreteValue3); reportDocument.DataDefinition.ParameterFields["AccName"].ApplyCurrentValues(parameterValue3); ParameterValues parameterValue4 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue4 = new ParameterDiscreteValue(); parameterDiscreteValue4.set_Value(voucher[0].CAcc); parameterValue4.Add(parameterDiscreteValue4); reportDocument.DataDefinition.ParameterFields["AccNumber"].ApplyCurrentValues(parameterValue4); ParameterValues parameterValue5 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue5 = new ParameterDiscreteValue(); parameterDiscreteValue5.set_Value(voucher[0].Amount_NU); parameterValue5.Add(parameterDiscreteValue5); reportDocument.DataDefinition.ParameterFields["Amount"].ApplyCurrentValues(parameterValue5); ParameterValues parameterValue6 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue6 = new ParameterDiscreteValue(); parameterDiscreteValue6.set_Value(voucher[0].Descrip_VC); parameterValue6.Add(parameterDiscreteValue6); reportDocument.DataDefinition.ParameterFields["Desc"].ApplyCurrentValues(parameterValue6); ParameterValues parameterValue7 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue7 = new ParameterDiscreteValue(); try { int item = voucher[0].chkNumber.set_Value((!voucher[0].chkNumber ? "" : item.ToString())); } catch { parameterDiscreteValue7.set_Value(""); } parameterValue7.Add(parameterDiscreteValue7); reportDocument.DataDefinition.ParameterFields["chkNumber"].ApplyCurrentValues(parameterValue7); ParameterValues parameterValue8 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue8 = new ParameterDiscreteValue(); parameterDiscreteValue8.set_Value((!voucher[0].BankName ? "" : voucher[0].BankName)); parameterValue8.Add(parameterDiscreteValue8); reportDocument.DataDefinition.ParameterFields["Bank"].ApplyCurrentValues(parameterValue8); ParameterValues parameterValue9 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue9 = new ParameterDiscreteValue(); DateTime dateDT = voucher[0].Date_DT.set_Value(dateDT.ToShortDateString()); parameterValue9.Add(parameterDiscreteValue9); reportDocument.DataDefinition.ParameterFields["Date"].ApplyCurrentValues(parameterValue9); ParameterValues parameterValue10 = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue10 = new ParameterDiscreteValue(); parameterDiscreteValue10.set_Value(WithdrawalForm._voucherID); parameterValue10.Add(parameterDiscreteValue10); reportDocument.DataDefinition.ParameterFields["VNumber"].ApplyCurrentValues(parameterValue10); reportDocument.PrintOptions.set_PrinterName(this.printDialog1.PrinterSettings.PrinterName); reportDocument.PrintToPrinter(this.printDialog1.PrinterSettings.Copies, this.printDialog1.PrinterSettings.Collate, 1, 1); MessageBox.Show(string.Concat("Report Error", exception.Message)); } try { } catch (Exception exception) { } } else { MessageBox.Show("الرجاء حفظ السند"); } }