JZTXT

Common code

发布时间 2023-04-14 10:41:31作者: GongDonghai

Common code

代表段库

Csharp

查询

简单查询

var query = new QueryExpression("account");
var condition = new ConditionExpression("name", ConditionOperator.Equal, "Contoso");
query.Criteria.AddCondition(condition);
var order = new OrderExpression("accountnumber", OrderType.Ascending);
query.Orders.Add(order);
query.ColumnSet.AddColumns("name", "telephone1");
var results = _service.RetrieveMultiple(query);
foreach(Entity entity in results.Entities)
{
    Console.WriteLine("Name: {0}", entity.GetAttributeValue<string>("name"));
}

多实体联合查询（并查询）

var query = new QueryExpression("account");

var link1 = query.AddLink("contact", "primarycontactid", "contactid");
link1.LinkCriteria.AddCondition("address1_city", ConditionOperator.Equal, "Seattle");

var link2 = link1.AddLink("lead", "leadid", "originatingleadid");
link2.LinkCriteria.AddCondition("statecode", ConditionOperator.Equal, 0);

query.ColumnSet.AddColumns("name", "emailaddress1");

var results = _service.RetrieveMultiple(query);
foreach (Entity entity in results.Entities)
{
    Console.WriteLine("Name: {0}", entity.GetAttributeValue<string>("name"));
    Console.WriteLine("Email: {0}", entity.GetAttributeValue<string>("emailaddress1"));
}

或查询

var query = new QueryExpression("account");

var nameCondition = new ConditionExpression("name", ConditionOperator.Like, "%b%");
var cityCondition = new ConditionExpression("address1_city", ConditionOperator.Like, "%c%");
var filter = new FilterExpression(LogicalOperator.Or);
filter.AddCondition(nameCondition);
filter.AddCondition(cityCondition);

query.Criteria.AddFilter(filter);

query.ColumnSet.AddColumns("name", "address1_city", "telephone1");

var results = _service.RetrieveMultiple(query);
foreach (Entity entity in results.Entities)
{
    Console.WriteLine("Name: {0}", entity.GetAttributeValue<string>("name"));
    Console.WriteLine("City: {0}", entity.GetAttributeValue<string>("address1_city"));
    Console.WriteLine("Phone: {0}", entity.GetAttributeValue<string>("telephone1"));
}