1.获取左右应用程序
SPWebApplicationCollection webs = SPWebService.ContentService.WebApplications;
foreach (SPWebApplication web in webs)
{
listApplication.Items.Add(web.DisplayName);//获取所有应用程序
}
2. 获取列表各列表项的标题字段
SPSite site = new SPSite("http://sharepoint:81/");
SPWeb spweb = site.OpenWeb();
SPList list = spweb.Lists["DepartmentList"];
SPListItemCollection listitems = list.Items;
foreach (SPListItem item in listitems)
{
txtList.Text += item["标题"].ToString() + Environment.NewLine;//获取部门列表标题字段
}
3.删除列表
SPSite site = new SPSite("http://sharepoint:81/");
SPWeb spweb = site.OpenWeb();
SPListCollection lists= spweb.Lists;
SPList list = lists["DepartmentList"];
System.Guid listguid = list.ID;
lists.Delete(listguid);
4.操作视图
SPSite site = new SPSite("http://sharepoint:81/");
SPWeb spweb = site.OpenWeb();
SPList list = spweb.Lists["DepartmentList"];
SPViewCollection listitems = list.Views;
foreach (SPView item in listitems)
{
this.txtList.Text += item.Title + Environment.NewLine;
}
Guid viwGuid = list.Views["我的日常工作"].ID;
SPView sv = list.GetView(viwGuid);
SPListItemCollection collItem = list.GetItems(sv);
SPViewFieldCollection collViewFields = sv.ViewFields;
foreach (SPListItem oitem in collItem)
{
for (int index = 0; index < collViewFields.Count; index++)
{
this.txtList.Text += collViewFields[index].ToString() + ":" + oitem[collViewFields[index]].ToString() + Environment.NewLine;
}
}
5.列表转换为DataTable
SPSite site = new SPSite("http://sharepoint:81/");
SPWeb spweb = site.OpenWeb();
SPList list = spweb.Lists["DepartmentList"];
SPListItemCollection listitems = list.Items;
return listitems.GetDataTable();
6.操作文档库
SPSite site = new SPSite("http://sharepoint:81/");
SPWeb spweb = site.OpenWeb();
SPFolder myFolder = spweb.GetFolder("Doc");
SPFileCollection myfiles = myFolder.Files;
FileStream fstream = File.OpenRead(@"C:\aaa.txt");
byte[] contens = new byte[fstream.Length];
fstream.Read(contens, 0, (int)fstream.Length);
fstream.Close();
string path = site.Url + "/kb/kb/";
string filename = DateTime.Now.ToString().Replace(" ", "").Replace(":", "") + ".txt";
SPFile file = myfiles.Add(path + filename, contens);
file.Item["知识库标题"] = "测试知识库";
file.Item["内容"] = "计算机是以非常复杂的工作";
file.Item["分类"] = "4";
file.Item.Update();
7.操作用户用户组
SPSite site = new SPSite("http://sharepoint:81/");
SPWeb spweb = site.OpenWeb();
foreach (SPUser user in spweb.SiteUsers)
{
this.txtList.Text += user.Name + Environment.NewLine;
}
foreach (SPGroup group in spweb.Groups)
{
this.txtList.Text += group.Name + Environment.NewLine;
}
8.获取MOss内置名称 在CAML语法中使用的字段名并不是创建的字段名而是Moss系统内部名称
SPSite site = new SPSite("http://sharepoint:81/");
SPWeb spweb = site.OpenWeb();
SPList list = spweb.Lists["DepartmentList"];
SPListItemCollection listitems = list.Items;
SPListItem item = listitems[0];
for (int i = 0; i < item.Fields.Count; i++)
{
this.txtList.Text += item.Fields[i].Title + ":" + item.Fields[i].InternalName + Environment.NewLine;
}
9.CAML查询
SPSite site = new SPSite("http://sharepoint:81/");
SPWeb spweb = site.OpenWeb();
SPList list = spweb.Lists["DepartmentList"];
SPQuery query = new SPQuery();
query.ViewFields = "<FieldRef Name='Title'/><FieldRef Name='_x95ee_x9898_x51b3_x65'/><FieldRef Name='Created'/>";
query.Query = "<Where><Contains><FieldRef Name='Title'/><value Type='Text'>计算机</value></Contains></Where>";
query.RowLimit = 5;
SPListItemCollection myiten = list.GetItems(query);
10.得到网站集
SPSite site=new SPSite(“http://yang:9000”)
使用AllWebs得到子站点kb
SPWeb web1=site.AllWebs[“kb”];
MessageBox.Show(web1.Title)
使用OpenWeb获取当前网站集下的知识库子站点
SPWeb web2=site.OpenWeb(“kb”)
OpenWeb方法中的参数是一个相对地址
利用SPControl控制的上下文
SPWeb web=SPControl.GetContextWeb(Context)
利用WSS对象的上下文SPContent
SPWeb web=SPContext.Current.Web
SPWeb web=SPControl.GetContextWeb(Context).webs[“kb”]
SPList treelist=web.Lists[listname]
SPWeb rootweb=SPControl.GetContextSite(Context).RootWeb
列表对象
SPListCollection SPListItem SPListItemCollection
SPViewCollection
SPViewFiledCollection
SPView
SPDocumentLibrary
SPFiled
SPFiledCollection