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;         }

这篇关于Fetch 别名查找的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！