Fetch 别名查找
Fetch 查找
Fetch 查找
if (PlanClass.Attributes.Contains("new_excelcolor_avg"))
{
ClassColorNum = ((AliasedValue)PlanClass["new_excelcolor_avg"]).Value.ToString();
}
private EntityCollection GetPlanClassesCollection(OrganizationServiceProxy organizationServiceProxy, string CenterGuid, DateTime RetrieveDate)
{
//返回值
EntityCollection PlanClassCollection = null;
try
{
string PlanClassQuery = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>" +
"<entity name='new_planclass'>" +
"<attribute name='new_name' />" +
"<attribute name='new_planclassid' />" +
"<attribute name='new_course' />" +
"<attribute name='new_begintime' />" +
"<attribute name='new_classroom' />" +
"<attribute name='new_endtime' />" +
"<attribute name='createdon' />" +
"<attribute name='statecode' />" +
"<attribute name='new_subject' />" +
"<attribute name='new_maxnum' />" +
"<attribute name='new_coursetype' />" +
"<attribute name='new_chineseteacher' />" +
"<attribute name='ownerid' />" +
"<attribute name='new_ordernum' />" +
"<attribute name='new_ordermember' />" +
"<order attribute='new_name' descending='false' />" +
"<filter type='and'>" +
"<condition attribute='new_center' operator='eq' value='" + CenterGuid + "' />" +
"<condition attribute='new_begintime' operator='on' value='" + RetrieveDate.ToString() + "' />" +
"</filter>" +
"<link-entity name='new_kidsclassroom' from='new_kidsclassroomid' to='new_classroom' visible='false' link-type='outer'>" +
"<attribute name='new_shortname' alias='new_shortname_avg'/>" +
"</link-entity>" +
"<link-entity name='new_course' from='new_courseid' to='new_course' visible='false' link-type='outer'>" +
"<attribute name='new_excelcolor' alias='new_excelcolor_avg'/>" +
"<attribute name='new_courseshortname' alias='new_courseshortname_avg'/>" +
"</link-entity>" +
"</entity>" +
"</fetch>";
PlanClassCollection = organizationServiceProxy.RetrieveMultiple(new FetchExpression(PlanClassQuery));
}
catch (Exception ex)
{
PlanClassCollection = null;
}
return PlanClassCollection;
}
