/// <summary>
/// Gets all lists inside a website (excluding Document Libraries and Picture Libraries)
/// </summary>
/// <param name="parentId"></param>
/// <returns></returns>
public SPListDefinitionCollection GetLists(string parentId)
{
System.Text.StringBuilder sbSQL = new StringBuilder();
SPListDefinitionCollection oLists = new SPListDefinitionCollection();
sbSQL.Append("SELECT l.tp_Title AS Title, l.tp_Id AS Id, l.tp_BaseType AS BaseType, l.tp_ServerTemplate AS ServerTemplate, l.tp_Fields AS Fields ");
sbSQL.Append("FROM Lists l ");
sbSQL.Append("INNER JOIN Webs w ON (w.Id = l.tp_WebId) ");
sbSQL.AppendFormat("WHERE l.tp_WebId = '{0}' ", parentId);
DataSet dsLists = _DB.ExecuteDataSet(sbSQL.ToString(), "Lists");
foreach (DataRow drList in dsLists.Tables["Lists"].Rows)
{
oLists.Add(new SPListDefinition(drList));
}
return(oLists);
}
public void AddRange(SPListDefinitionCollection items)
{
this.InnerList.AddRange(items);
}
public void AddRange(SPListDefinitionCollection items)
{
this.InnerList.AddRange(items);
}
/// <summary>
/// Gets all lists inside a website (excluding Document Libraries and Picture Libraries)
/// </summary>
/// <param name="parentId"></param>
/// <returns></returns>
public SPListDefinitionCollection GetLists(string parentId)
{
System.Text.StringBuilder sbSQL = new StringBuilder();
SPListDefinitionCollection oLists = new SPListDefinitionCollection();
sbSQL.Append("SELECT l.tp_Title AS Title, l.tp_Id AS Id, l.tp_BaseType AS BaseType, l.tp_ServerTemplate AS ServerTemplate, l.tp_Fields AS Fields ");
sbSQL.Append("FROM Lists l ");
sbSQL.Append("INNER JOIN Webs w ON (w.Id = l.tp_WebId) ");
sbSQL.AppendFormat("WHERE l.tp_WebId = '{0}' ", parentId);
DataSet dsLists = _DB.ExecuteDataSet(sbSQL.ToString(), "Lists");
foreach (DataRow drList in dsLists.Tables["Lists"].Rows)
{
oLists.Add(new SPListDefinition(drList));
}
return (oLists);
}
