/// <summary> /// 查询预约时段 /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <QueryResult <CrmEntity> > QueryReservationconfig(ReservationconfigRequest request) { try { var fetchString = _baseDataRepository.QueryReservationconfig(request); var fetchXdoc = XDocument.Parse(fetchString); var fetchRequest = new CrmRetrieveMultipleFetchRequestMessage() { EntityName = "mcs_reservationconfiguration", 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.page; queryResult.TotalCount = 0; return(queryResult); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取试驾时段 /// </summary> /// <param name="request"></param> /// <returns></returns> public string QueryReservationconfig(ReservationconfigRequest request) { var filter = string.Empty; if (!string.IsNullOrWhiteSpace(request.search)) { //filter += $"<filter type='or'>"; filter += $"<condition attribute='mcs_reservationdate' operator='on' value='{request.search.Split('T')[0]}' />"; //filter += $"<condition attribute='mcs_name' operator='like' value='%{dt.ToString("HH:mm")}%' />"; //filter += $"</filter>"; } if (!string.IsNullOrWhiteSpace(request.carmodel)) { filter += $"<condition attribute='mcs_carmodel' operator='eq' value='{request.carmodel}' />"; } if (!string.IsNullOrWhiteSpace(request.dealerid)) { filter += $"<condition attribute='mcs_dealerid' operator='eq' value='{request.dealerid}' />"; } if (!string.IsNullOrEmpty(request.mcs_ordertime)) { filter += $"<condition attribute='mcs_reservationdate' operator='on' value='{request.mcs_ordertime.Split('T')[0]}' />"; } var fetchString = $@"<fetch version='1.0' count='{request.pageSize}' page='{request.page}' output-format='xml-platform' mapping='logical' distinct='false'> <entity name='mcs_reservationconfiguration'> <attribute name='mcs_name' /> <attribute name='createdon' /> <attribute name='mcs_usednum' /> <attribute name='mcs_reservationdate' /> <attribute name='mcs_begintime' /> <attribute name='mcs_endtime' /> <attribute name='mcs_reservationconfigurationid' /> <order attribute='mcs_reservationdate' descending='true' /> <order attribute='mcs_begintime' descending='false' /> <filter type='and'> <condition attribute='statecode' operator='eq' value='0' /> {filter} </filter> <link-entity name='mcs_carmodel' from='mcs_carmodelid' to='mcs_carmodel' visible='false' link-type='outer' > <attribute name='mcs_name' alias='carmodelname'/> </link-entity> </entity> </fetch>"; return(fetchString); }
public async Task <NewtonsoftJsonActionResult <QueryResult <CrmEntity> > > QueryReservationconfig(string mcs_ordertime, string carmodel, string dealerid, string seachkey = "", string sort = "", int pageSize = 10, int page = 1) { var req = new ReservationconfigRequest() { mcs_ordertime = mcs_ordertime, dealerid = dealerid, carmodel = carmodel, search = seachkey, page = page, pageSize = pageSize, sort = sort }; var list = await app.QueryReservationconfig(req); return(list); }
/// <summary> /// 试驾时段 /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <QueryResult <CrmEntity> > QueryReservationconfig(ReservationconfigRequest request) => await _baseDataService.QueryReservationconfig(request);