private void Set_Queries_CurReport(int Guarantor) { ReportSimpleGrid report = new ReportSimpleGrid(); report.Query = DetailReport(Guarantor); report.SubmitQuery(); // Fill the report.TableQ report.TableQ = (new Report1_GuarantorAllocation()).ConvertTableToAllStrings(report.TableQ); AddColBalance(report);// Calculates and Adds the Balance Column to the Query. // Also Adds Providers Abbreviations report.Title = "Allocation to Guarantor "; DataTable dtGuarantorName = Db.GetTableOld("SELECT "+DbHelper.Concat("LName","' '","FName")+"FROM Patient WHERE PatNum = " + Guarantor); string GuarantorName = dtGuarantorName.Rows[0][0].ToString(); report.SubTitle.Add("Guarantor Account: " + GuarantorName + " " + DateTime.Now.ToShortDateString()); this._MainReportTable = report.TableQ; this._Title = report.Title + "\n" + report.SubTitle[0]; BuildSummaryTable(Guarantor, DateTime.MinValue, DateTime.MaxValue); report.Summary = SummaryTable_as_Strings(); // No Summary Table until built //DataTable dtSummary = Db.GetTable(ProviderRevenueByGuarantor(Guarantor)); }
private void Set_Queries_CurReport(int Guarantor) { ReportSimpleGrid report = new ReportSimpleGrid(); report.Query = DetailReport(Guarantor); report.SubmitQuery(); // Fill the report.TableQ report.TableQ = (new Report1_GuarantorAllocation()).ConvertTableToAllStrings(report.TableQ); AddColBalance(report); // Calculates and Adds the Balance Column to the Query. // Also Adds Providers Abbreviations report.Title = "Allocation to Guarantor "; DataTable dtGuarantorName = Db.GetTableOld("SELECT " + DbHelper.Concat("LName", "' '", "FName") + "FROM Patient WHERE PatNum = " + Guarantor); string GuarantorName = dtGuarantorName.Rows[0][0].ToString(); report.SubTitle.Add("Guarantor Account: " + GuarantorName + " " + DateTime.Now.ToShortDateString()); this._MainReportTable = report.TableQ; this._Title = report.Title + "\n" + report.SubTitle[0]; BuildSummaryTable(Guarantor, DateTime.MinValue, DateTime.MaxValue); report.Summary = SummaryTable_as_Strings(); // No Summary Table until built //DataTable dtSummary = Db.GetTable(ProviderRevenueByGuarantor(Guarantor)); }
/// <summary> /// This expects that the last column will be Amount. If not It will do nothing. /// RunDetialReport(Guarantor) query first. // Adds Provider's abbreviations to Table as well /// /// Adds a column to report.TableQ /// </summary> private static void AddColBalance(ReportSimpleGrid report) //to report.TableQ { if (report.TableQ != null && report.TableQ.Columns.Count == 10) if (report.TableQ.Columns[8].ColumnName == "Amount") { decimal RunningBalance = 0; // Find Provider Abbreviations System.Collections.Hashtable htProvs = new System.Collections.Hashtable(); try { DataTable dt = Db.GetTableOld("SELECT ProvNum, Abbr FROM Provider"); if (dt.Rows.Count != 0) foreach (DataRow dr in dt.Rows) if (!htProvs.ContainsKey(dr[0].ToString())) htProvs[dr[0].ToString()] = dr[1].ToString(); if (!htProvs.ContainsKey("0")) htProvs["0"] = "UnEarned"; } catch { } for (int i = 0; i < report.TableQ.Rows.Count; i++) { try { decimal amount = 0; try { amount = decimal.Parse(report.TableQ.Rows[i][8].ToString()); } catch { } RunningBalance += amount; if (amount > 0) { report.TableQ.Rows[i][5] = amount.ToString("F2"); report.TableQ.Rows[i][6] = ""; } else { report.TableQ.Rows[i][5] = ""; report.TableQ.Rows[i][6] = amount.ToString("F2"); } report.TableQ.Rows[i][7] = RunningBalance.ToString("F2"); // Fix Provider Column From # to Abreviation, Need to do it here // because Prov# = 0 is undefined if (htProvs.Count != 0) if (htProvs.ContainsKey(report.TableQ.Rows[i][9].ToString())) report.TableQ.Rows[i][4] = htProvs[report.TableQ.Rows[i][9].ToString()].ToString(); // Change Column 0 Date Display if Date on previous row has been displayed if (i > 0) if (report.TableQ.Rows[i][0].ToString() == report.TableQ.Rows[i - 1][0].ToString()) report.TableQ.Rows[i][0] = ""; // makes Dates more readable if not redundant. } catch { report.TableQ.Rows[i][7] = "ERROR"; } } report.TableQ.Columns.RemoveAt(8);// Remove Amount report.TableQ.Columns.RemoveAt(8); // Remove ProvNums DataRow dr2 = report.TableQ.NewRow(); report.TableQ.Rows.Add(dr2); // add blank row dr2 = report.TableQ.NewRow(); dr2[6] = "Total"; dr2[7] = RunningBalance.ToString("F"); report.TableQ.Rows.Add(dr2); } }
/// <summary> /// This expects that the last column will be Amount. If not It will do nothing. /// RunDetialReport(Guarantor) query first. // Adds Provider's abbreviations to Table as well /// /// Adds a column to report.TableQ /// </summary> private static void AddColBalance(ReportSimpleGrid report) //to report.TableQ { if (report.TableQ != null && report.TableQ.Columns.Count == 10) { if (report.TableQ.Columns[8].ColumnName == "Amount") { decimal RunningBalance = 0; // Find Provider Abbreviations System.Collections.Hashtable htProvs = new System.Collections.Hashtable(); try { DataTable dt = Db.GetTableOld("SELECT ProvNum, Abbr FROM Provider"); if (dt.Rows.Count != 0) { foreach (DataRow dr in dt.Rows) { if (!htProvs.ContainsKey(dr[0].ToString())) { htProvs[dr[0].ToString()] = dr[1].ToString(); } } } if (!htProvs.ContainsKey("0")) { htProvs["0"] = "UnEarned"; } } catch { } for (int i = 0; i < report.TableQ.Rows.Count; i++) { try { decimal amount = 0; try { amount = decimal.Parse(report.TableQ.Rows[i][8].ToString()); } catch { } RunningBalance += amount; if (amount > 0) { report.TableQ.Rows[i][5] = amount.ToString("F2"); report.TableQ.Rows[i][6] = ""; } else { report.TableQ.Rows[i][5] = ""; report.TableQ.Rows[i][6] = amount.ToString("F2"); } report.TableQ.Rows[i][7] = RunningBalance.ToString("F2"); // Fix Provider Column From # to Abreviation, Need to do it here // because Prov# = 0 is undefined if (htProvs.Count != 0) { if (htProvs.ContainsKey(report.TableQ.Rows[i][9].ToString())) { report.TableQ.Rows[i][4] = htProvs[report.TableQ.Rows[i][9].ToString()].ToString(); } } // Change Column 0 Date Display if Date on previous row has been displayed if (i > 0) { if (report.TableQ.Rows[i][0].ToString() == report.TableQ.Rows[i - 1][0].ToString()) { report.TableQ.Rows[i][0] = ""; // makes Dates more readable if not redundant. } } } catch { report.TableQ.Rows[i][7] = "ERROR"; } } report.TableQ.Columns.RemoveAt(8); // Remove Amount report.TableQ.Columns.RemoveAt(8); // Remove ProvNums DataRow dr2 = report.TableQ.NewRow(); report.TableQ.Rows.Add(dr2); // add blank row dr2 = report.TableQ.NewRow(); dr2[6] = "Total"; dr2[7] = RunningBalance.ToString("F"); report.TableQ.Rows.Add(dr2); } } }