private void BindTemplateToData()
{
phContent.Controls.Clear();
// debug
if (State.ReportSet.ReportSetDebug)
{
DebugInfo.Append(QueryText);
}
var ds = ReportData();
var maxPage = 1;
if (ReportExtra.AllowPaging)
{
maxPage = Convert.ToInt32((ds.Tables[0].Rows.Count + ReportExtra.PageSize - 1) / ReportExtra.PageSize);
var pageData = new System.Collections.Generic.List <DataRow>();
for (var i = ((PageNumber - 1) * ReportExtra.PageSize + 1); i <= ((PageNumber) * ReportExtra.PageSize); i++)
{
if (i > ds.Tables[0].Rows.Count)
{
break;
}
pageData.Add(ds.Tables[0].Rows[i - 1]);
}
var pageTable = default(DataTable);
if (pageData.Any()) // check for data as CopyToDataTable errors if empty list
{
pageTable = pageData.CopyToDataTable();
}
else
{
pageTable = ds.Tables[0].Clone(); // just copy table structure
}
ds = new DataSet();
ds.Tables.Add(pageTable);
}
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
phContent.Visible = Report.ReportNoItemsText.Length == 0;
RenderNoItems();
}
else
{
var result = ReportExtra.TemplateText;
// TEMPORARY: until export services changed
if (result.Contains("[EXPORT_EXCEL]"))
{
result = result.Replace("[EXPORT_EXCEL]", "");
cmdExportExcel.Visible = true;
}
// paging support
if (ReportExtra.AllowPaging)
{
var pagerPrevious = "";
var pagerNext = "";
var pagerFirst = "";
var pagerLast = "";
var pagerPages = "";
// previous
var prevPage = PageNumber - 1;
if (prevPage > 0)
{
// insert previous page item
if (ReportExtra.PagingType == PAGINGTYPE_INTERNAL)
{
pagerPrevious = "<asp:LinkButton id=\"cmdPreviousPage\" runat=\"server\" CommandArgument=\"" + prevPage.ToString() + "\">" + ReportExtra.PrevPageText + "</asp:LinkButton>";
}
else
{
pagerPrevious = PageTemplate(prevPage, ReportExtra.PrevPageText, "prev");
}
}
// next
var nextPage = PageNumber + 1;
if (PageNumber < maxPage)
{
// insert next page
if (ReportExtra.PagingType == PAGINGTYPE_INTERNAL)
{
pagerNext = "<asp:LinkButton id=\"cmdNextPage\" runat=\"server\" CommandArgument=\"" + nextPage.ToString() + "\">" + ReportExtra.NextPageText + "</asp:LinkButton>";
}
else
{
pagerNext = PageTemplate(nextPage, ReportExtra.NextPageText, "next");
}
}
// first
if (PageNumber > 1)
{
if (ReportExtra.PagingType == PAGINGTYPE_INTERNAL)
{
pagerFirst = "<asp:LinkButton id=\"cmdFirstPage\" runat=\"server\" CommandArgument=\"" + 1 + "\">" + ReportExtra.FirstPageText + "</asp:LinkButton>";
}
else
{
pagerFirst = PageTemplate(1, ReportExtra.FirstPageText, "first");
}
}
// last
if (PageNumber < maxPage)
{
if (ReportExtra.PagingType == PAGINGTYPE_INTERNAL)
{
pagerLast = "<asp:LinkButton id=\"cmdLastPage\" runat=\"server\" CommandArgument=\"" + maxPage.ToString() + "\">" + ReportExtra.LastPageText + "</asp:LinkButton>";
}
else
{
pagerLast = PageTemplate(maxPage, ReportExtra.LastPageText, "last");
}
}
// pages
if (ReportExtra.PagingType == PAGINGTYPE_QUERYSTRING)
{
for (var i = 1; i <= Math.Min(10, maxPage); i++)
{
pagerPages = pagerPages + PageTemplate(i, i.ToString(), "page");
}
}
// check if no [PAGER*] tokens present, otherwise use a default
if (!result.Contains("[PAGER"))
{
result = result + "[PAGER]";
}
// inject pager controls
result = result.Replace("[PAGER]", "[PAGER:FIRST][PAGER:PREVIOUS][PAGER:PAGES][PAGER:NEXT][PAGER:LAST]");
result = result.Replace("[PAGER:FIRST]", pagerFirst);
result = result.Replace("[PAGER:LAST]", pagerLast);
result = result.Replace("[PAGER:PREVIOUS]", pagerPrevious);
result = result.Replace("[PAGER:NEXT]", pagerNext);
result = result.Replace("[PAGER:PAGES]", pagerPages);
result = result.Replace("[PAGER:NUMBER]", PageNumber.ToString());
result = result.Replace("[PAGER:COUNT]", maxPage.ToString());
}
result = Regex.Replace(result, "<drilldown name=\\\"(?<name>.*)\\\">(?<inner>.*)</drilldown>", "<asp:LinkButton id=\"cmdDrilldown[#RowNumber]\" runat=\"server\" CommandName=\"Drilldown|${name}\" CommandArgument=\"[#RowNumber]\">${inner}</asp:LinkButton>", RegexOptions.IgnoreCase);
result = ReplaceReportTokens(result, ds);
phContent.Controls.Add(ParseControl(result));
// hook up command for drilldown links
var drilldownCtrl = default(LinkButton);
var drilldownIndex = 1;
while (true)
{
drilldownCtrl = (LinkButton)(phContent.FindControl("cmdDrillDown" + drilldownIndex.ToString()));
if (drilldownCtrl != null)
{
drilldownCtrl.Command += new CommandEventHandler(cmdDrilldown);
drilldownIndex++;
}
else
{
break;
}
}
// hookup command for pager links for internal
if (ReportExtra.PagingType == PAGINGTYPE_INTERNAL)
{
var cmdPreviousPage = default(LinkButton);
cmdPreviousPage = (LinkButton)(phContent.FindControl("cmdPreviousPage"));
if (cmdPreviousPage != null)
{
cmdPreviousPage.Command += new CommandEventHandler(Pager_Click);
}
var cmdNextPage = default(LinkButton);
cmdNextPage = (LinkButton)(phContent.FindControl("cmdNextPage"));
if (cmdNextPage != null)
{
cmdNextPage.Command += new CommandEventHandler(Pager_Click);
}
var cmdFirstPage = default(LinkButton);
cmdFirstPage = (LinkButton)(phContent.FindControl("cmdFirstPage"));
if (cmdFirstPage != null)
{
cmdFirstPage.Command += new CommandEventHandler(Pager_Click);
}
var cmdLastPage = default(LinkButton);
cmdLastPage = (LinkButton)(phContent.FindControl("cmdLastPage"));
if (cmdLastPage != null)
{
cmdLastPage.Command += new CommandEventHandler(Pager_Click);
}
}
}
}
