protected string GetReport()
{
string sql = Session["ReportSQL"].ToNonNullString();
string sName = Request.QueryString["Name"] ?? "";
DataTable dt = gData.GetDataTable2(sql);
string sCols = Session["ReportColumns"].ToNonNullString();
string[] vCols = sCols.Split(",");
string sHTML = "<table class=saved>";
sHTML += GetReportHeader(dt, sCols);
int nRowsPerPage = 15;
int nRowsConsumed = 0;
int nPageNo = (int)GetDouble(Request.QueryString["pag"] ?? "");
int nStartRow = nPageNo * nRowsPerPage;
int nEndRow = nStartRow + nRowsPerPage - 1;
double nTotalPages = (int)Math.Ceiling((double)(dt.Rows.Count / nRowsPerPage)) + 1;
for (int y = nStartRow; y <= nEndRow && y < dt.Rows.Count; y++)
{
string sRow = "<tr>";
for (int i = 0; i < vCols.Length; i++)
{
string sValue = dt.Rows[y][vCols[i]].ToNonNullString();
if (sValue.Contains("https://"))
{
sValue = "<a href='" + sValue + "' target=_blank>View</a>";
}
string sMoniker = "";
string sEndMoniker = "";
if (vCols[i] == "TXID")
{
sMoniker = "<small><nobr>";
sEndMoniker = "</nobr></small>";
}
sRow += "<td>" + sMoniker + sValue + sEndMoniker + "</td>";
}
sRow += "</tr>";
sHTML += sRow;
nRowsConsumed++;
if (nRowsConsumed > nRowsPerPage)
{
break;
}
}
sHTML += "</table>";
string sURL = "Report?name=" + sName;
sHTML += UICommon.GetPagControl(sURL, nPageNo, (int)nTotalPages);
if (dt.Rows.Count == 0)
{
sHTML += "<div>You have no sponsored orphans.</div>";
}
return(sHTML);
}
