/// <summary>
/// 用户车辆列表查询
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <QueryResult <CrmEntity> > QueryList(UserCarInfoListRequest request)
{
try
{
var fetchString = _usercarinfoRepository.QueryList(request);
var fetchXdoc = XDocument.Parse(fetchString);
var fetchRequest = new CrmRetrieveMultipleFetchRequestMessage()
{
EntityName = "mcs_usercarinfo",
FetchXml = fetchXdoc
};
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 QueryList(UserCarInfoListRequest request)
{
var filter = string.Empty;
if (!string.IsNullOrWhiteSpace(request.mcs_carinfoid))
{
filter += $"<condition attribute='mcs_carinfoid' operator='eq' value='{request.mcs_carinfoid}' />";
}
if (!string.IsNullOrWhiteSpace(request.mcs_username))
{
filter += $"<condition attribute='mcs_username' operator='eq' value='{request.mcs_username}' />";
}
if (!string.IsNullOrWhiteSpace(request.mcs_phone))
{
filter += $"<condition attribute='mcs_phone' operator='eq' value='{request.mcs_phone}' />";
}
if (!string.IsNullOrWhiteSpace(request.mcs_plate))
{
filter += $"<condition attribute='mcs_plate' operator='eq' value='{request.mcs_plate}' />";
}
if (!string.IsNullOrWhiteSpace(request.mcs_userid))
{
filter += $"<condition attribute='mcs_userid' operator='eq' value='{request.mcs_userid}' />";
}
var fetchString = $@"<fetch version='1.0' count='{request.PageSize}' page='{request.PageIndex}' output-format='xml-platform' mapping='logical' distinct='false'>
<entity name='mcs_usercarinfo'>
<all-attributes />
<order attribute='createdon' descending='false' />
<link-entity name='mcs_vehowner' from='mcs_vehownerid' to='mcs_carinfoid' link-type='inner' alias='bb'>
<all-attributes/>
</link-entity>
<link-entity name='mcs_carmodel' from='mcs_carmodelid' to='mcs_model' link-type='inner' alias='cc'>
<attribute name='mcs_name' />
</link-entity>
<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> > QueryList(UserCarInfoListRequest request)
{
return(await _usercarinfoService.QueryList(request));
}
public async Task <NewtonsoftJsonActionResult <QueryResult <CrmEntity> > > QueryList([FromQuery] UserCarInfoListRequest request)
{
var list = await app.QueryList(request);
return(list);
}
