团队成员查询-dynamics

团队成员查询-dynamics

///
/// 查询团队下的所有用户创建待办
///
/// 组织服务对象
/// 条件–团队id
/// 待办主题
/// 关联实体对象
/// 待办说明
///
public static object SelectTeamAwaitTask(IOrganizationService service,Guid entityid, string subject, EntityReference entityReference, string remark = “”)
{
//查询团队或者用户
QueryExpression query = new QueryExpression();
query.EntityName = “team”;//团队名称
query.ColumnSet = new ColumnSet(“businessunitid”);//查询数据–业务部门
query.Criteria.AddCondition(“teamid”, ConditionOperator.Equal, entityid);//查询条件–页面id
EntityCollection x = service.RetrieveMultiple(query);//查询结果
if (x.Entities.Count<=0)
{
return false;
}
foreach (var item in x.Entities)
{

            //var businessunitid = item.GetAttributeValue<EntityReference>("businessunitid");
            //查询用户
            QueryExpression sysquery = new QueryExpression();
            sysquery.EntityName = "teammembership";//用户团队关系实体名称
            sysquery.ColumnSet = new ColumnSet("systemuserid");//查询数据--用户id
            sysquery.Criteria.AddCondition("teamid", ConditionOperator.Equal, item.Id);//查询条件--团队id
            EntityCollection xsys = service.RetrieveMultiple(sysquery);//查询结果
            if (xsys.Entities.Count>0)
            {
                foreach (var itemsys in xsys.Entities)
                {
                    var systemuserid = itemsys.GetAttributeValue<Guid>("systemuserid");
                   
                }
            }
        }
        return true;
    }