sharepoint常见操作

青旅半醒 2021-11-26 22:40 280阅读 0赞

1.获取左右应用程序

SPWebApplicationCollection webs = SPWebService.ContentService.WebApplications;  
foreach (SPWebApplication web in webs)  
\{  
listApplication.Items.Add(web.DisplayName);//获取所有应用程序  
\}

2. 获取列表各列表项的标题字段

SPSite site = new SPSite("[http://sharepoint:81/][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/][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/][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

6.操作文档库

SPSite site = new SPSite("[http://sharepoint:81/][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/][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/][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/][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

转载于:https://www.cnblogs.com/GreenGrass/archive/2013/04/25/3042569.html

[http_sharepoint_81]: http://sharepoint:81/