/// <summary> /// Function to get dataset for printing the report /// </summary> /// <returns></returns> public DataSet getdataset1() { DataSet dsFundFlow = new DataSet(); try { FinancialStatementBll bllFinancialStatement = new FinancialStatementBll(); DataTable dtblFund = dtblageing1(); List<DataTable> listCompany = new List<DataTable>(); listCompany = bllFinancialStatement.FundFlowReportPrintCompany(1);//(PublicVariables._decCurrentCompanyId); dsFundFlow.Tables.Add(dtblFund); dsFundFlow.Tables.Add(listCompany[0]); } catch (Exception ex) { MessageBox.Show("AR7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return dsFundFlow; }
/// <summary> /// Function to convert datatable to dataset /// </summary> /// <returns></returns> public DataSet getdataset() { DataSet dsTrail = new DataSet(); try { FinancialStatementBll bllFinancialStatement = new FinancialStatementBll(); DataTable dtblTrail = Getdatatable(); List<DataTable> list = new List<DataTable>(); list = bllFinancialStatement.FundFlowReportPrintCompany(1); dsTrail.Tables.Add(dtblTrail); dsTrail.Tables.Add(list[0]); } catch (Exception ex) { MessageBox.Show("TB:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return dsTrail; }
/// <summary> /// Function to get dataset /// </summary> /// <returns></returns> public DataSet getdataset() { DataSet dsFundFlow = new DataSet(); try { FinancialStatementBll bllFinancialStatement = new FinancialStatementBll(); DataTable dtblFund = dtblBalanceSheet(); List< DataTable> list = new List<DataTable>(); list = bllFinancialStatement.FundFlowReportPrintCompany(1); dsFundFlow.Tables.Add(dtblFund); dsFundFlow.Tables.Add(list[0]); return dsFundFlow; } catch (Exception ex) { MessageBox.Show("BS :3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return dsFundFlow; }
/// <summary> /// Function to print report /// </summary> /// <param name="fromDate"></param> /// <param name="toDate"></param> public void Print(DateTime fromDate, DateTime toDate) { try { FinancialStatementBll bllFinancialStatement = new FinancialStatementBll(); AccountGroupBll bllAccountGroup = new AccountGroupBll(); DataSet dsAccountGroup = new DataSet(); List<DataTable> ListObj = bllAccountGroup.AccountGroupReportFill(fromDate, toDate); string strSum = lblBalanceTotal.Text; DataTable dtblSum = new DataTable(); dtblSum.Columns.Add("Sum", typeof(string)); DataRow dr = dtblSum.NewRow(); dr[0] = strSum; dtblSum.Rows.InsertAt(dr, 0); List<DataTable> listCompany = bllFinancialStatement.FundFlowReportPrintCompany(1); dsAccountGroup.Tables.Add(ListObj[0]); dsAccountGroup.Tables.Add(listCompany[0]); dsAccountGroup.Tables.Add(dtblSum); frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.AccountGroup(dsAccountGroup); } catch (Exception ex) { MessageBox.Show("AGR:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Convert DataTable to DataSet /// </summary> /// <returns></returns> public DataSet GetdataSet() { FinancialStatementBll bllFinancialStatement = new FinancialStatementBll(); DataSet dsFundFlow = new DataSet(); try { DataTable dtblFund = GetDataTable(); DataTable dtblWC = GetDatagrid2(); List< DataTable> listCompany = new List<DataTable>(); listCompany = bllFinancialStatement.FundFlowReportPrintCompany(1); dsFundFlow.Tables.Add(dtblFund); dsFundFlow.Tables.Add(listCompany[0]); dsFundFlow.Tables.Add(dtblWC); } catch (Exception ex) { MessageBox.Show("FF:03" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return dsFundFlow; }