• 数据量太大时,如何实现分页查询-CSOM


    static List<ListItem> getEmployee()
    {
    string account = ConfigurationManager.AppSettings["account"];
    string password = ConfigurationManager.AppSettings["password"];
    string empUrl = ConfigurationManager.AppSettings["empUrl"];
    using(ClientContext ctx=new ClientContext(empUrl)){
    SecureString securepassWord = new SecureString();
    foreach (char c in password.ToCharArray())
    {
    securepassWord.AppendChar(c);
    }
    ctx.Credentials = new SharePointOnlineCredentials(account, securepassWord);//针对online的验证
    List<ListItem> employeeItem = new List<ListItem>();
    List employee = ctx.Web.Lists.GetByTitle("llistName");
    CamlQuery camlQuery = new CamlQuery();
    camlQuery.ViewXml = "<View>"
    //+ "<Query><Where>"
    //+ "<And>"
    //+ "<IsNotNull><FieldRef Name='column1'/></IsNotNull>"
    //+ "<And>"
    //+ "<Eq><FieldRef Name='column2'/><Value Type='Text'>A</Value></Eq>"
    //+ "<Eq><FieldRef Name='column3'/><Value Type='Text'>Y</Value></Eq>"
    //+ "</And>"
    //+ "</And>"
    //+ "</Where></Query>"
    + "<ViewFields>"
    + "<FieldRef Name='column1'/>"
    + "<FieldRef Name='column2'/>"
    + "<FieldRef Name='column3'/>"
    + "<FieldRef Name='column4'/>"
    + "<FieldRef Name='column5'/>"
    + "</ViewFields>"
    + "<RowLimit>5000</RowLimit>"
    +"</View>";
    ListItemCollectionPosition position = null;
    do
    {
    camlQuery.ListItemCollectionPosition = position; 
    ListItemCollection empColl = employee.GetItems(camlQuery);
    ctx.Load(empColl);
    ctx.Load(empColl, items => items.Include(item => item["column1"], item => item["column2"], item => item["column3"], item => item["column4"], item => item["column5"]));
    ctx.ExecuteQuery();
    position = empColl.ListItemCollectionPosition;
    if (empColl.Count>0)
    employeeItem.AddRange(empColl.ToList());
    } while (position != null); 
    return employeeItem;
    }
    }
  • 相关阅读:
    Nginx得知——Hello World模
    Web静态和动态项目委托代理基于面向方面编程AOP
    PIC16SCM设置不同IO功耗端口状态的影响
    $.ajax通路RESTful Web Service一个错误:Unsupported Media Type
    什么是Entitlement
    加解密
    Types of Security Vulnerabilities
    fork后子进程从哪里开始执行
    进程间通信(IPC)介绍
    Using URL Schemes to Communicate with Apps
  • 原文地址:https://www.cnblogs.com/learning-life/p/10405333.html
Copyright © 2020-2023  润新知