fetchxml分页和QueryExpression分页

最新推荐文章于 2022-08-11 16:30:07 发布

菜刀2008

最新推荐文章于 2022-08-11 16:30:07 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： CRM 文章标签： QueryExpression分页 fetchxml分页 fetchxml分页和QueryExpr crm分页

本文链接：https://blog.youkuaiyun.com/y_f123/article/details/51307526

CRM 专栏收录该内容

173 篇文章

订阅专栏

本文介绍了在CRM系统中如何使用fetchxml和QueryExpression进行数据分页查询。通过示例代码展示了如何设置分页参数，以及在查询过程中如何处理分页cookie，确保数据的正确分页加载。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/// <summary>
/// fetchxml分页
/// </summary>
public void QueryXmlPage(IOrganizationService service,string fetchxml,Action<EntityCollection> addAction)
{
int fetchCount = 5000;
int pageNumber = 1;
string pagingCookie = null;
EntityCollection ec = null;

do
{
string xml = CreateXml(fetchxml, pagingCookie, pageNumber, fetchCount);
ec = service.RetrieveMultiple(new FetchExpression(xml));
if (ec != null && ec.Entities.Count > 0)
{
addAction(ec);
pageNumber = pageNumber + 1;
pagingCookie = ec.PagingCookie;
}
} while (ec != null && ec.MoreRecords);
}

private string CreateXml(string xml, string cookie, int page, int count)
{
System.IO.StringReader stringReader = new System.IO.StringReader(xml);
XmlTextReader reader = new XmlTextReader(stringReader);
XmlDocument doc = new XmlDocument();
doc.Load(reader);
return CreateXml(doc, cookie, page, count);
}

private string CreateXml(XmlDocument doc, string cookie, int page, int count)
{
XmlAttributeCollection attrs = doc.DocumentElement.Attributes;
if (cookie != null)
{
XmlAttribute pagingAttr = doc.CreateAttribute("paging-cookie");
pagingAttr.Value = cookie;
attrs.Append(pagingAttr);
}
XmlAttribute pageAttr = doc.CreateAttribute("page");
pageAttr.Value = System.Convert.ToString(page);
attrs.Append(pageAttr);

XmlAttribute countAttr = doc.CreateAttribute("count");
countAttr.Value = System.Convert.ToString(count);
attrs.Append(countAttr);

System.Text.StringBuilder sb = new System.Text.StringBuilder(1024);
System.IO.StringWriter stringWriter = new System.IO.StringWriter(sb);

XmlTextWriter writer = new XmlTextWriter(stringWriter);
doc.WriteTo(writer);
writer.Close();

return sb.ToString();
}

/// <summary>
/// QueryExpression分页
/// </summary>
public void QueryPage(IOrganizationService service, QueryExpression query,Action<EntityCollection> addAction)
{
EntityCollection ec = null;
int pageNumber = 1;
do
{
query.PageInfo = new PagingInfo();
query.PageInfo.Count = 5000;
query.PageInfo.PagingCookie =
(pageNumber == 1) ? null : ec.PagingCookie;
query.PageInfo.PageNumber = pageNumber++;

ec = service.RetrieveMultiple(query);
if (ec != null && ec.Entities.Count > 0)
{
addAction(ec);
}
} while (ec != null && ec.MoreRecords);
}