/// <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); }
/// <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); }