protected override void Render(HtmlTextWriter writer)
{
base.Render(writer);
try
{
if (this.ListToDisplay != null)
{
SPList selectedList = SPContext.Current.Web.Lists[new Guid(this._listToDisplay)];
SPView defaultView = selectedList.DefaultView;
if (this.IsExternalList)
{
SPViewFieldCollection fields = defaultView.ViewFields;
System.Collections.Specialized.StringCollection stringCol = fields.ToStringCollection();
// Nik20121105 - Write the table headers;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine("<table class=\"wet-boew-zebra\">");
sb.Append("<tr>");
foreach (string field in stringCol)
{
sb.Append("<th>" + field + "</th>");
}
sb.Append("</tr>");
foreach (SPListItem item in selectedList.Items)
{
sb.AppendLine("<tr>");
bool firstCol = true;
foreach (string field in stringCol)
{
if (firstCol)
{
firstCol = false;
sb.AppendLine("<td><a href=\"" + SPContext.Current.Web.Url + "/_layouts/listform.aspx?PageType=4&ListId={" + this._listToDisplay + "}&ID=" + item["BdcIdentity"].ToString() + "\">" + item[field].ToString() + "</a></td>");
}
else
{
sb.AppendLine("<td>" + item[field].ToString() + "</td>");
}
}
sb.AppendLine("</tr>");
}
sb.AppendLine("</table>");
writer.Write(sb.ToString());
}
else
{
writer.Write(defaultView.RenderAsHtml());
}
}
}
catch (Exception ex)
{
writer.Write(ex.ToString());
}
}
protected override void Render(HtmlTextWriter writer)
{
base.Render(writer);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
string CAMLQuery = null;
try
{
if (this._listId != null && this._viewName != null)
{
using (SPSite site = new SPSite(SPContext.Current.Site.Url))
{
using (SPWeb web = site.OpenWeb(this.ListWebId))
{
SPList selectedList = web.Lists[this._listId];
SPListItemCollection items = selectedList.Items;
SPView defaultView = selectedList.Views[this._viewName];
uint itemsPerPage = defaultView.RowLimit;
SPViewFieldCollection fields = defaultView.ViewFields;
System.Collections.Specialized.StringCollection stringCol = fields.ToStringCollection();
if (Page.Request.QueryString != null && Page.Request.QueryString.Count > 0)
{
FilterEngine filterEngine = new FilterEngine(Page.Request.QueryString, selectedList);
CAMLQuery = filterEngine.CAMLQuery;
}
// Nik20121105 - Write the table headers;
sb.AppendLine("<table class=\"wet-boew-zebra\">");
sb.Append("<tr>");
foreach (string field in stringCol)
{
sb.Append("<th>" + selectedList.Fields.GetFieldByInternalName(field).Title + "</th>");
}
sb.Append("</tr>");
if (CAMLQuery == null)
{
CAMLQuery = "";
}
SPQuery query = new SPQuery();
query.Query = CAMLQuery;
query.RowLimit = itemsPerPage;
items = selectedList.GetItems(query);
if (Page.Request.QueryString["p_ID"] != null)
{
string prev = "";
if (Page.Request.QueryString["PagedPrev"] == "TRUE")
{
prev = "&PagedPrev=TRUE";
}
SPListItemCollectionPosition position = new SPListItemCollectionPosition("Paged=TRUE&p_ID=" + Page.Request.QueryString["p_ID"] + prev);
query.ListItemCollectionPosition = position;
}
string lastId = "";
foreach (SPListItem item in items)
{
sb.AppendLine("<tr>");
bool firstCol = true;
foreach (string field in stringCol)
{
if (firstCol)
{
firstCol = false;
string itemUrl = string.Empty;
SPField test = item.Fields.TryGetFieldByStaticName("BdcIdentity");
if (test != null)
{
itemUrl = HttpUtility.UrlEncode(this._listWeb + "/_layouts/listform.aspx?PageType=4&ListId={" + this._listId.ToString() + "}&ID=" + item["BdcIdentity"].ToString());
}
else
{
itemUrl = HttpUtility.UrlEncode(this._listWeb + "/_layouts/listform.aspx?PageType=4&ListId={" + this._listId.ToString() + "}&ID=" + item.ID.ToString());
}
string renderedField = string.Empty;
if (item[field] != null)
{
renderedField = item[field].ToString();
}
sb.AppendLine("<td><a href=\"" + this.ItemViewerUrl + "?ItemUrl=" + itemUrl + "\">" + renderedField.Replace("string;#", "").Replace("datetime;#", "").Replace("number;#", "") + "</a></td>");
}
else
{
string renderedField = string.Empty;
if (item[field] != null)
{
renderedField = FieldRenderer.RenderField(item[field].ToString(), item.Fields.GetFieldByInternalName(field));
}
sb.AppendLine("<td>" + renderedField + "</td>");
}
}
sb.AppendLine("</tr>");
lastId = item.ID.ToString();
}
sb.AppendLine("</table>");
string curUrl = Page.Request.Url.OriginalString;
string forwardUrl = curUrl.Replace("p_ID=" + Page.Request.QueryString["p_ID"], "p_ID=" + lastId).Replace("&PagedPrev=TRUE", "");
string prevUrl = curUrl.Replace("p_ID=" + Page.Request.QueryString["p_ID"], "p_ID=" + items[0].ID.ToString());
if (forwardUrl.IndexOf("p_ID") < 0)
{
if (!forwardUrl.Contains("?"))
{
forwardUrl += "?p_ID=" + lastId;
}
else
{
forwardUrl += "&p_ID=" + lastId;
}
}
if (prevUrl.IndexOf("p_ID") < 0)
{
if (!prevUrl.Contains("?"))
{
prevUrl += "?p_ID=" + items[0].ID.ToString();
}
else
{
prevUrl += "&p_ID=" + items[0].ID.ToString();
}
}
if (!prevUrl.Contains("PagedPrev"))
{
prevUrl += "&PagedPrev=TRUE";
}
if (CAMLQuery != null)
{
SPQuery newQuery = new SPQuery();
newQuery.Query = CAMLQuery;
if (items[0].ID != selectedList.GetItems(newQuery)[0].ID)
{
sb.AppendLine("<a href=\"" + prevUrl + "\">< Previous</a> ");
}
}
else if (items[0].ID != selectedList.Items[0].ID)
{
sb.AppendLine("<a href=\"" + prevUrl + "\">< Previous</a> ");
}
if ((int.Parse(lastId) + itemsPerPage) < selectedList.Items.Count)
{
sb.AppendLine("<a href=\"" + forwardUrl + "\">Next ></a>");
}
writer.Write(sb.ToString());
}
}
}
}
catch (Exception ex)
{
LogEngine.Log(ex, "Accessible Lists");
}
}
