使用Sharepoint 2007中的webservice操作列表

简介:

Sharepoint中提供了很多开箱即用的Web Service,使用这些web service我们可以进行远程调用, 在"web server extensions\12\ISAPI"(其通常位于C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\ISAPI")之下的"Microsoft Shared"目录中有大部分Web Services的物理文件。用于管理中心工具的管理Web Service位于ADMISAPI文件夹中,其在管理中心控制台里是一个名为"_vti_adm"的虚拟目录。当你创建了一个SharePoint站点时,它将包含一个名为"_vti_bin"的虚拟目录,以指向这个位置。IIS不为子站点包含任何应用程序或虚拟目录,它们只是包含通过 SharePoint元数据和HttpModules实现的对_vti_bin虚拟目录的映射。当然web service支持的功能没有sharepoint的对象模型丰富,不过基本都有了,本文主要说下Lists.asmx中的一些常用功能。

clip_image002[4]

 

下面是一些常用的功能,关于其中一些CAML的使用请参考这篇文章http://www.cnblogs.com/carysun/archive/2011/01/12/moss-caml.html

1.得到Lists对象

 

static SPListsWS.Lists GetSPListWS()

        {

            SPListsWS.Lists spListsWS = new SPListsWS.Lists();

            if (UrlListSite != null && UrlListSite.Length > 0)

            {

                spListsWS.Url = UrlListSite;

            }

            if (SPWSUsername != null && SPWSUsername.Length > 0)

            {

                spListsWS.Credentials = new System.Net.NetworkCredential(SPWSUsername, SPWSUserPassword, SPWSDomain);

            }

            else

                spListsWS.Credentials = System.Net.CredentialCache.DefaultCredentials;

 

            return spListsWS;

        }

2.得到列表ID

static string GetSPListID(SPListsWS.Lists spListsWS, string listName,

            ref bool sourceFieldFound, ref bool targetFieldFound)

        {

            string listID;

            XmlNode aNode;

            XmlNode GetListResult;

            IEnumerator ienum;

 

            GetListResult = spListsWS.GetList(listName);

 

            listID = GetListResult.Attributes["ID"].Value;

 

            return listID;

        }

 

3.得到列表的item,可以通过CAML进行条件筛选

       static XmlNode GetListItems(SPListsWS.Lists spListsWS)

        {

            string rowLimit = "1000000", xDocQueryString, xDocFieldsString;

            //string getAllRecordsQuery = "<Query><Where><Gt><FieldRef Name=\"ID\" /><Value Type=\"Counter\">-1</Value></Gt></Where></Query>";

            string getAllRecordsQuery = "<Query><Where><Eq><FieldRef Name=\"a\" /><Value Type=\"String\">Approved</Value></Eq></Where></Query>";

            XmlNode result = null;

            XmlDocument xDocQuery = null, xDocFields;

 

            xDocQueryString = ConfigurationManager.AppSettings["SPListItemQueryString"];

            if (xDocQueryString != null && xDocQueryString.Length > 0)

            {

                xDocQuery = new XmlDocument();

                xDocQuery.LoadXml(xDocQueryString);

            }

            else

            {

                xDocQuery = new XmlDocument();

                xDocQuery.LoadXml(getAllRecordsQuery);

            }

 

            xDocFieldsString = "<ViewFields><FieldRef Name=\"ID\"></FieldRef>" +

                "<FieldRef Name=\"" + SourceField + "\"></FieldRef>" +

                "<FieldRef Name=\"" + TargetField + "\"></FieldRef>" +

                "</ViewFields>";

            xDocFields = new XmlDocument();

            xDocFields.LoadXml(xDocFieldsString);

 

           // result = spListsWS.GetListItems(ListName, null, xDocQuery, xDocFields, rowLimit, null, null);

            result = spListsWS.GetListItems(ListName, null, null, null, rowLimit, null, null);

 

            return result;

        }

4.更新列表中的item,使用CAML的方式

  static bool UpdateListItem(SPListsWS.Lists spListsWS, string strlistItemID, string newHistoryValue)

        {

            bool sucess = false;

            string strErrorCode = null;

            long lngErrorCode = -1;

            XmlDocument xDocSyncCmd = new XmlDocument();

            XmlNode xNodeResult;

            string updateCommand;

 

            updateCommand = "<Batch OnError=\"Continue\">" +

                "<Method ID=\"1\" Cmd=\"Update\">" +

                "<Field Name=\"ID\">" + strlistItemID + "</Field>" +

                "<Field Name=\"" + TargetField + "\">" + EscapeIllegalChars(newHistoryValue) + "</Field>" +

                "</Method>" +

                "</Batch>";

 

            xDocSyncCmd.LoadXml(updateCommand);

            xNodeResult = spListsWS.UpdateListItems(ListName, xDocSyncCmd);

            xNodeResult = xNodeResult.FirstChild;

            xNodeResult = xNodeResult.FirstChild;

            if (xNodeResult.Name == "ErrorCode")

            {

                strErrorCode = xNodeResult.InnerXml;

                if (long.TryParse(strErrorCode.Replace("0x",""), out lngErrorCode))

                {

                    if (lngErrorCode == 0)

                    {

                        sucess = true;

                    }

                }

            }

 

            return sucess;

        }

 

 

 

static void UpdateListItemsHistory(SPListsWS.Lists spListsWS, XmlNode listItems)

        {

            IEnumerator ienum;

            XmlNode current, xNodeCommentHistory, xNodeEditorHistory, xDataNode = null;

            XmlAttribute xAttribCommentHistory, xAttribRecordCount;

            string strlistItemID, currHistoryValue, newHistoryValue;

 

            ienum = listItems.GetEnumerator();

            while (ienum.MoveNext())

            {

                current = (XmlNode)ienum.Current;

                if (current.Name == "rs:data")

                {

                    xDataNode = current;

                    xAttribRecordCount = xDataNode.Attributes["ItemCount"];

                    if (xAttribRecordCount != null)

                        long.TryParse(xAttribRecordCount.Value, out TotalRecords);

 

                    break;

                }

            }

 

            ienum = xDataNode.GetEnumerator();

            while (ienum.MoveNext())

            {

                current = (XmlNode)ienum.Current;

                if (current.Name == "z:row")

                {

                    strlistItemID = current.Attributes["ows_ID"].Value;

                    xAttribCommentHistory = current.Attributes["ows_" + TargetField];

                    if (xAttribCommentHistory != null)

                        currHistoryValue = current.Attributes["ows_" + TargetField].Value;

                    else

                        currHistoryValue = "";

                    xNodeCommentHistory = spListsWS.GetVersionCollection(ListName, strlistItemID, SourceField);

                    xNodeEditorHistory = spListsWS.GetVersionCollection(ListName, strlistItemID, "Editor");

                    newHistoryValue = ConcatenateHistory(xNodeCommentHistory, xNodeEditorHistory);

                    if (currHistoryValue != newHistoryValue)

                    {

                        UpdateListItem(spListsWS, strlistItemID, newHistoryValue);

                    }

                }

            }

        }

 

基本这些是最常用的功能了

 

 

本文转自Justin博客园博客,原文链接:http://www.cnblogs.com/carysun/archive/2011/01/14/sharepoint2007-listsasmx.html,如需转载请自行联系原作者

相关文章
|
API 网络架构 数据格式
SharePoint REST API - 同步SharePoint列表项
博客地址:http://blog.csdn.net/FoxDave 本篇只讲REST服务中的GetListItemChangesSinceToken这个东西。
1092 0
|
JSON API 网络架构
SharePoint REST API - 列表和列表项
博客地址:http://blog.csdn.net/FoxDave 本篇主要讲述如何用SharePoint REST操作列表和列表项。阅读本篇时请先了解前面讲述的REST介绍和基本操作。
1216 0
SharePoint 2013 网站搜索规则的使用示例
前言   SharePoint 2013搜索中,有一个非常好用的细化搜索结果的功能,就是“查询规则”。可以通过对于某些特定查询时,起到细化显示结果的作用。下面,我们简单的介绍一下该功能的使用和效果。   1、通常SharePoint搜索,我们在管理中心的搜索中心,对内容源进行爬网,然后在搜索核心...
1120 0
SharePoint\O365 CSOM操作"请求访问设置"功能
博客地址:http://blog.csdn.net/FoxDave 请求访问设置是在SharePoint网站权限菜单中的一个功能,如下图: 它用来设置成员是否可以共享网站以及个别文件和文件夹,是否允许成员邀请其他人加入站点某个成员组,以及是否允许访问请求。
1036 0