private void BuildResultsTable() { var last_book_month_included = (ctrlCriteria.BookMonth == "00") ? "09" : ctrlCriteria.BookMonth; //get Totals data always: DataSet ds = null; var dsTotals = FSTotalsReport.GetSummaryState(ctrlCriteria.FiscalYear, ctrlCriteria.Organization, ctrlCriteria.BusinessLine, last_book_month_included, ctrlCriteria.ViewMode, false); //get Monthly data only if needed: if (ctrlCriteria.ExpandedByMonthView) { ds = FSTotalsReport.GetSummaryState(ctrlCriteria.FiscalYear, ctrlCriteria.Organization, ctrlCriteria.BusinessLine, last_book_month_included, ctrlCriteria.ViewMode, ctrlCriteria.ExpandedByMonthView); } if (dsTotals == null || dsTotals.Tables[0].Rows.Count == 0) { lblMessages.Text = "No records found."; } else { lblMessages.Text = ""; //draw the table tblData: var drawing_class = new FSReviewUI(); drawing_class.TotalsDataTable = dsTotals.Tables[0]; drawing_class.SourceDataTable = (ds == null) ? null : ds.Tables[0]; drawing_class.TableToDraw = tblData; drawing_class.MonthlyView = ctrlCriteria.ExpandedByMonthView; if (ctrlCriteria.ViewMode == (int)FundsReviewViewMode.fvIncome) { drawing_class.DisplayColumnObjClassCode = false; } drawing_class.BookMonth = ctrlCriteria.BookMonth; var link = String.Format("FundSearch.aspx?vm={0}&org={1}&fy={2}&ba={3}&bl={4}", ctrlCriteria.ViewMode, ctrlCriteria.Organization, ctrlCriteria.FiscalYear, DEFAULT_VALUE_BUDGET_ACTIVITY, ctrlCriteria.BusinessLine); link = link + "&bm={0}&sf={1}&oc={2}"; drawing_class.CellLinkOnClick = link; drawing_class.BuildTheTable(); tblData = drawing_class.TableToDraw; } }
private void BuildFundsReviewTable() { //ctrlCriteria.ExpandedByMonthView - always Expanded view in Excel: var expanded_view = true; //get Query parameters: /************************************/ var ht = (new PageBase()).FundsReviewSelectedValues; var organization = (string)ht[HT_KEY_ORG]; var business_line_code = (string)ht[HT_KEY_BL]; var business_line = (string)ht[HT_KEY_BL_NAME]; var fiscal_year = (string)ht[HT_KEY_YEAR]; var book_month = (string)ht[HT_KEY_BOOK_MONTH]; var obl_income_view = Int32.Parse((string)ht[HT_KEY_VIEW]); var title_text = ""; switch (obl_income_view) { case (int)FundsReviewViewMode.fvObligations: title_text = "Obligations"; break; case (int)FundsReviewViewMode.fvIncome: title_text = "Income"; break; case (int)FundsReviewViewMode.fvOneTimeAdjustments: title_text = "One Time Adjustments"; break; } //start Excel headers: /************************************/ var tr = new HtmlTableRow(); Sheet.Rows.Add(tr); tr = new HtmlTableRow(); tr.Cells.AddCell("Funds Review", "title", CELL_ALIGN_LEFT); Sheet.Rows.Add(tr); tr = new HtmlTableRow(); tr.Cells.AddCell(title_text, "title2", CELL_ALIGN_LEFT); Sheet.Rows.Add(tr); tr = new HtmlTableRow(); Sheet.Rows.Add(tr); //get the data: /************************************/ var last_book_month_included = (book_month == "00") ? "09" : book_month; var dsTotal = FSTotalsReport.GetSummaryState(fiscal_year, organization, business_line_code, last_book_month_included, obl_income_view, false); var ds = FSTotalsReport.GetSummaryState(fiscal_year, organization, business_line_code, last_book_month_included, obl_income_view, true); //display query parameters in Excel: /************************************/ if (business_line_code != "") { tr = new HtmlTableRow(); tr.Cells.AddCell("Business Line:", "reportCaption2", CELL_ALIGN_LEFT); tr.Cells.AddCell(business_line, "title2", CELL_ALIGN_RIGHT); Sheet.Rows.Add(tr); } tr = new HtmlTableRow(); tr.Cells.AddCell("Organization:", "reportCaption2", CELL_ALIGN_LEFT); tr.Cells.AddCell(organization, "title2", CELL_ALIGN_RIGHT); Sheet.Rows.Add(tr); tr = new HtmlTableRow(); tr.Cells.AddCell("Fiscal Year:", "reportCaption2", CELL_ALIGN_LEFT); tr.Cells.AddCell(fiscal_year, "title2", CELL_ALIGN_RIGHT); Sheet.Rows.Add(tr); tr = new HtmlTableRow(); tr.Cells.AddCell("Book Month:", "reportCaption2", CELL_ALIGN_LEFT); if (book_month == "00") { tr.Cells.AddCell("All Available", "title2", CELL_ALIGN_RIGHT); } else { tr.Cells.AddCell(String.Format("{0:MMMM}", DateTime.Parse(book_month + "/" + fiscal_year)), "title2", CELL_ALIGN_RIGHT); } Sheet.Rows.Add(tr); tr = new HtmlTableRow(); Sheet.Rows.Add(tr); if (dsTotal == null || dsTotal.Tables[0].Rows.Count == 0) { //no records: /************************************/ tr = new HtmlTableRow(); tr.Cells.AddCell("No records found", "reportCaption2", CELL_ALIGN_LEFT); Sheet.Rows.Add(tr); } else { //draw the table Sheet that will be displayed in Excel: /******************************************************/ var drawing_class = new FSReviewUI(); drawing_class.TotalsDataTable = dsTotal.Tables[0]; drawing_class.SourceDataTable = (ds == null) ? null : ds.Tables[0]; drawing_class.TableToDraw = Sheet; drawing_class.MonthlyView = true; if (obl_income_view == (int)FundsReviewViewMode.fvIncome) { drawing_class.DisplayColumnObjClassCode = false; } drawing_class.BookMonth = book_month; drawing_class.BuildReportForExcel = true; drawing_class.BuildTheTable(); Sheet = drawing_class.TableToDraw; } }