/// <summary>
/// 列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <QueryResult <CrmEntity> > getlist(VehlisenseListRequest request)
{
try
{
var fetchXdoc = _Repository.GetListFetchXml(request);
var fetchRequest = new CrmRetrieveMultipleFetchRequestMessage()
{
EntityName = "mcs_vehlisense",
FetchXml = fetchXdoc.Result
};
var fetchResponse = await _crmService.Execute(fetchRequest);
var fetchResponseResult = fetchResponse as CrmRetrieveMultipleFetchResponseMessage;
var queryResult = new QueryResult <CrmEntity>();
queryResult.Results = fetchResponseResult.Value.Results;
queryResult.CurrentPage = request.PageSize;
queryResult.TotalCount = 0;
return(queryResult);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 列表获取
/// </summary>
/// <param name="deliveryListRequest"></param>
/// <returns></returns>
public async Task <XDocument> GetListFetchXml(VehlisenseListRequest deliveryListRequest)
{
return(await Task <XDocument> .Run(() =>
{
var filterStr = "";
if (deliveryListRequest.Type == 0) //已上牌
{
filterStr += $@"<condition attribute='mcs_name' operator='not-null' />"; //包含数据
}
if (deliveryListRequest.Type == 1) //未上牌
{
filterStr += $@"<condition attribute='mcs_name' operator='null' />"; //不包含数据
}
if (!string.IsNullOrEmpty(deliveryListRequest.SearchKey))
{
filterStr += $@" <filter type='or'>
<condition attribute='mcs_name' operator='like' value='%{deliveryListRequest.SearchKey}%' />
<condition attribute='mcs_fullname' operator='like' value='%{deliveryListRequest.SearchKey}%' />
<condition attribute='mcs_idcard' operator='like' value='%{deliveryListRequest.SearchKey}%' />
</filter>/>
";
}
var fetchXml = $@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'
count='{deliveryListRequest.PageSize}' page='{deliveryListRequest.PageIndex}'>
<entity name='mcs_vehlisense'>
<attribute name='mcs_name' />
<attribute name='createdon' />
<attribute name='mcs_lisensedate' />
<attribute name='mcs_address' />
<attribute name='mcs_vehdelivery' />
<attribute name='mcs_vehlicense' />
<attribute name='mcs_idcard' />
<attribute name='mcs_fullname' />
<attribute name='mcs_vehorder' />
<attribute name='mcs_dealer' />
<attribute name='mcs_contact' />
<attribute name='mcs_vehlisenseid' />
<order attribute='createdon' descending='true' />
<filter type='and'>
<condition attribute='statecode' operator='eq' value='0' />
<condition attribute='mcs_dealer' operator='eq' value='{deliveryListRequest.DealerId}' />
{filterStr}
</filter>
<link-entity name='mcs_vehicle' from='mcs_vehicleid' to='mcs_vin' visible='false' link-type='outer' >
<attribute name='mcs_name' alias='vinname'/>
</link-entity>
</entity>
</fetch>";
return XDocument.Parse(fetchXml);
}));
}
public async Task <QueryResult <CrmEntity> > getlist(VehlisenseListRequest request)
{
return(await _service.getlist(request));
}
public async Task <NewtonsoftJsonActionResult <QueryResult <CrmEntity> > > getlist(VehlisenseListRequest request)
{
return(await _appVehlisense.getlist(request));
}
