/// <summary> /// 安装单列表查询 /// </summary> /// <param name="_request"></param> /// <returns></returns> public async Task <QueryResult <CrmEntity> > GetInstallationorderList(InstallationorderRequest _request) { try { var userInfo = ContextContainer.GetValue <UserInfo>(ContextExtensionTypes.CurrentUserInfo); if (userInfo != null) { _request.mcs_dealerid = userInfo.mcs_dealerid; } var fetchString = _InstallationRepository.GetInstallationorderList(_request); var fetchXdoc = XDocument.Parse(fetchString); var fetchRequest = new CrmRetrieveMultipleFetchRequestMessage() { EntityName = "mcs_installationorder", FetchXml = fetchXdoc, ProxyUserId = userInfo != null ? userInfo.systemuserid : null }; var fetchResponse = await _crmService.Execute(fetchRequest); var fetchResponseResult = fetchResponse as CrmRetrieveMultipleFetchResponseMessage; var queryResult = new QueryResult <CrmEntity>(); queryResult.Results = fetchResponseResult.Value.Results; queryResult.CurrentPage = _request.PageIndex; queryResult.TotalCount = 0; return(queryResult); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取安装单列表 /// </summary> /// <param name="_request"></param> /// <returns></returns> public string GetInstallationorderList(InstallationorderRequest _request) { var filter = string.Empty; //if (_request.mcs_dealerid != null) // filter += $"<condition attribute='mcs_dealerid' operator='eq' value='{_request.mcs_dealerid}' />"; if (_request.mcs_installationstatus != 0) { filter += $"<condition attribute='mcs_installationstatus' operator='eq' value='{_request.mcs_installationstatus}' />"; } if (!string.IsNullOrWhiteSpace(_request.SearchKey)) { filter += $"<filter type='or'>"; filter += $"<condition attribute='mcs_name' operator='like' value='%{_request.SearchKey}%' />"; filter += $"<condition attribute='mcs_username' operator='like' value='%{_request.SearchKey}%' />"; filter += $"<condition attribute='mcs_userphone' operator='like' value='%{_request.SearchKey}%' />"; filter += $"<condition attribute='mcs_detailaddress' operator='like' value='%{_request.SearchKey}%' />"; filter += $"</filter>"; } var fetchString = $@"<fetch version='1.0' count='{_request.PageSize}' page='{_request.PageIndex}' output-format='xml-platform' mapping='logical' distinct='false'> <entity name='mcs_installationorder'> <attribute name='mcs_installationorderid' /> <attribute name='mcs_name' /> <attribute name='createdon' /> <attribute name='mcs_username' /> <attribute name='mcs_userphone' /> <attribute name='mcs_dealerid' /> <attribute name='mcs_installationstatus' /> <order attribute='createdon' descending='true' /> <filter type='and'> <condition attribute='statecode' operator='eq' value='0' /> {filter} </filter> </entity> </fetch>"; return(fetchString); }
/// <summary> /// 安装单列表查询接口 /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <QueryResult <CrmEntity> > GetInstallationorderList(InstallationorderRequest _request) { return(await _installService.GetInstallationorderList(_request)); }
public async Task <NewtonsoftJsonActionResult <QueryResult <CrmEntity> > > GetInstallationorderList(InstallationorderRequest _request) { var list = await app.GetInstallationorderList(_request); return(list); }