2-3SharePoint 服务器端对象模型

使用具有管理使用得权限得域账户登录服务器——>生产使用64位 否则会报错

权限问题导致访问不到

 

引入程序集

 

内部字段查看

List列表操作，查询，修改，删除

 

using Microsoft.SharePoint;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    class Program
    {
        static string SiteUrl = "http://sp2016:8000/sites/topsite ";
        static string WebUrl = string.Empty;
        static string ListUrl = "sites/topsite/Lists/ListCode";
        static string DocUrl = "sites/topsite/Lists/ListCode";
        static void Main(string[] args)
        {
            using (SPSite site = new SPSite(SiteUrl))
            {
                using (SPWeb web = site.OpenWeb())//顶级站点不用参数
                {
                    GetListData(web, ListUrl);
                }
            }
        }
        public static void GetListData(SPWeb web, string listUrl)
        {
            //删除
            #region 删除
            //SPList list = web.GetList(listUrl);
            //SPListItem item = list.GetItemById(1);
            //item.Delete();
            #endregion

            //更新
            #region 更新
            //SPList list = web.GetList(listUrl);
            //SPListItem item = list.GetItemById(1);
            //Console.WriteLine(item["Title"]);
            //item["Title"] = "11 updated!";
            //item.Update();
            //Console.WriteLine("finishied");
            #endregion

            //查询
            #region 查询
            //SPList list = web.GetList(listUrl);
            //SPListItemCollection itemColl = list.Items;
            //foreach (SPListItem item in itemColl)
            //{
            //    Console.WriteLine(item["Title"]);
            //}
            #endregion

            
        }
    }
}

　　文件库操作，上传和删除文件

using Microsoft.SharePoint;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DemoFileOpera
{
    class Program
    {
        static string SiteUrl = "http://sp2016:8000/sites/topsite ";
        static string WebUrl = string.Empty;
        static string ListUrl = "sites/topsite/Lists/ListCode";
        static string DocUrl = "sites/topsite/Documents";

        static void Main(string[] args)
        {
            using (SPSite site = new SPSite(SiteUrl))
            {
                using (SPWeb web = site.OpenWeb())
                {
                    UploadDocumnet(web, DocUrl);
                }
            }
        }

        public static void UploadDocumnet(SPWeb web, string libUrl)
        {
            //删除文件
            #region 删除文件
            SPList docLib = web.GetList(libUrl);
            SPFile file = web.GetFile("http://sp2016:8000/sites/topsite/Documents/backup.bak");
            //SPListItem item = docLib.GetItemById(1);
            //item.Delete();
            file.Delete();
            #endregion

            //上传文档
            #region 上传文档
            //SPList docLib = web.GetList(libUrl);
            //string direct = @"C:\backup.bak";
            //FileStream fs = new FileStream(direct, FileMode.Open, FileAccess.Read);
            //BinaryReader br = new BinaryReader(fs);
            //Byte[] filecontents = br.ReadBytes((int)fs.Length);
            //br.Close();
            //fs.Close();
            //string fileName = "backup.bak";
            //SPFile file = docLib.RootFolder.Files.Add(fileName, filecontents,true);
            //Console.WriteLine("Updated!");
            #endregion
        }

    }
}

caml查询语言，查询条件和select显示 SPQuery SPView

using Microsoft.SharePoint;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DemoSPQueryAndSPView
{
    class Program
    {
        static string SiteUrl = "http://sp2016:8000/sites/topsite ";
        static string WebUrl = string.Empty;
        static string ListUrl = "sites/topsite/Lists/ListCode";
        static string DocUrl = "sites/topsite/Lists/ListCode";

        static void Main(string[] args)
        {
            using (SPSite site = new SPSite(SiteUrl))
            {
                using (SPWeb web = site.OpenWeb())//顶级站点不用参数
                {
                    GetListData(web, ListUrl);
                }
            }
        }

        public static void GetListData(SPWeb web, string listUrl)
        {

            //查询
            #region 查询
            SPList list = web.GetList(listUrl);
            SPQuery query = new SPQuery();
            query.Query = string.Empty;
            //query.Query = @"<Where>
            //            <Contains>
            //            <FieldRef Name='Title' />
            //            <Value Type='Text'>1</Value>
            //            </Contains>                      
            //    </Where>
            //    <OrderBy>
            //        <FieldRef Name='Modified' />
            //    </OrderBy>";
            query.ViewFields = "<FieldRef Name='Title' />";
            query.RowLimit = 5;//查询5条
            SPListItemCollection itemColl = list.GetItems(query);
            foreach (SPListItem item in itemColl)
            {
                Console.WriteLine(item["Title"]);
            }
            #endregion


        }
    }
}