• SharePoint中删除列表记录


    方法1(快速,以理解,可以封装):

    SPList spListQuestion = spWeb.Lists["Question List"];
    for (int i = spListQuestion.Items.Count - 1; i >= 0; i--)
    {
        spListQuestion.Items[i].Delete();
    }

    方法2(繁琐):

    SPList spListQuestion = spWeb.Lists["Question List"];
    string sDIDTitle = spListQuestion.Fields["DID"].InternalName;
    SPQuery spQuery = new SPQuery();
    spQuery.Query = "" + "" + spDocItem.ID.ToString() + "";
    SPListItemCollection collListItems = spListQuestion.GetItems (spQuery);
    for (int i = 0; i < collListItems.Count; i++)
    {
        string ID = collListItems[i]["ID"].ToString();
        SPItem spItem = spListQuestion.GetItemById (Int16.Parse (ID) );
        spItem.Delete();
    }

    方法3(推荐):

    SPList targetList = null;
    try
    {
        targetList = currentWeb.GetList (currentWeb.ServerRelativeUrl.TrimEnd ('/') + listUrl);
    }
    catch { }
    if (targetList != null)
    {
        StringBuilder sbDelete = new StringBuilder();
        sbDelete.Append ("<?xml version="1.0" encoding="UTF-8"?><Batch>");
        foreach (SPItem item in targetList.Items)
        {
            if (item["Title"] != null)
            {
                sbDelete.Append ("<Method>");
                sbDelete.Append ("<SetList Scope="Request">" + targetList.ID + "</SetList>");
                sbDelete.Append ("<SetVar Name="ID">" + Convert.ToString (item.ID) + "</SetVar>");
                sbDelete.Append ("<SetVar Name="Cmd">Delete</SetVar>");
                sbDelete.Append ("</Method>");
            }
        }
        sbDelete.Append ("</Batch>");
        try
        {
            currentWeb.ProcessBatchData (sbDelete.ToString() );
            targetList.Update();
        }
        catch (Exception ex)
        { }
    }
  • 相关阅读:
    版本控制器 git
    JS 严格模式
    backquote
    linux内存监控 free
    好的linux网站
    linux查看进程开始时间
    命令之 ulimit
    using JSTL
    javax.servlet.jsp.PageContext cannot be resolved to a type
    jstl c
  • 原文地址:https://www.cnblogs.com/yixiaozi/p/3702614.html
Copyright © 2020-2023  润新知