CRM多表链接查询+分页

ConditionExpression condition2 = new ConditionExpression(); condition2.AttributeName = "accountcategorycode"; condition2.Operator = ConditionOperator.Equal; condition2.Values.Add(0); ConditionExpression condition3 = new ConditionExpression(); condition3.AttributeName = "name"; condition3.Operator = ConditionOperator.Like; condition3.Values.Add("%" + txtKeyWord.Text.Trim() + "%"); ConditionExpression condition6 = new ConditionExpression(); condition6.AttributeName = "parentaccountid"; condition6.Operator = ConditionOperator.Null; FilterExpression filter1 = new FilterExpression(); filter1.Conditions.Add(condition2); if (txtKeyWord.Text.Trim().Length > 0) { filter1.Conditions.Add(condition3); } if (cbxaccount.Checked == true) { filter1.Conditions.Add(condition6); } FilterExpression filter2 = new FilterExpression(LogicalOperator.Or); ConditionExpression condition4 = new ConditionExpression(); condition4.AttributeName = "crm_is_group"; condition4.Operator = ConditionOperator.Null; ConditionExpression condition5 = new ConditionExpression(); condition5.AttributeName = "crm_is_group"; condition5.Operator = ConditionOperator.Equal; condition5.Values.Add(100000001); filter2.Conditions.Add(condition4); filter2.Conditions.Add(condition5); QueryExpression query = new QueryExpression("account"); query.ColumnSet.AddColumns("accountid", "name", "crm_cust_state", "crm_cust_certtype", "crm_cust_certno", "telephone1", "fax", "telephone3", "emailaddress1", "fax", "parentaccountid"); query.Criteria.AddFilter(filter1); query.Criteria.AddFilter(filter2); LinkEntity linkEntity = new LinkEntity("account", "crm_tradeaccount", "accountid", "crm_account", JoinOperator.Inner); ConditionExpression conLink = new ConditionExpression(); conLink.AttributeName = "crm_distributor_netcode"; conLink.Operator=ConditionOperator.Equal; conLink.Values.Add(_distributor_netcode); linkEntity.LinkCriteria.AddCondition(conLink); query.LinkEntities.Add(linkEntity); query.Distinct = true; query.AddOrder("name", OrderType.Ascending); query.PageInfo = new PagingInfo(); query.PageInfo.Count = GridView1.PageSize; query.PageInfo.PageNumber = (GridView1.PageIndex + 1); query.PageInfo.PagingCookie = null; query.PageInfo.ReturnTotalRecordCount = true; Method method = new Method();//OrganizationServiceProxy或者IOrganizationService类型对象 EntityCollection entitys = method.RetrieveMultiple(query);

 

转载于:https://www.cnblogs.com/lmy213/p/3272377.html

相关资源：JAVA上百实例源码以及开源项目