/// <summary> /// 查询维修配件基础数据 /// </summary> /// <param name="repairItemPartRequest"></param> /// <returns></returns> public async Task <QueryResult <CrmEntity> > QueryRepairItemPart(RepairItemPartRequest repairItemPartRequest) { try { var fetchString = _baseDataRepository.QueryRepairItemPart(repairItemPartRequest); var fetchXdoc = XDocument.Parse(fetchString); var fetchRequest = new CrmRetrieveMultipleFetchRequestMessage() { EntityName = "mcs_repairitempart", 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 = repairItemPartRequest.page; queryResult.TotalCount = 0; return(queryResult); } catch (Exception ex) { throw ex; } }
public async Task <NewtonsoftJsonActionResult <QueryResult <CrmEntity> > > QueryRepairItemPart(string seachkey = "", string sort = "", int pageSize = 10, int page = 1) { var repairItemPartRequest = new RepairItemPartRequest() { search = seachkey, page = page, pageSize = pageSize, sort = sort }; var list = await app.QueryRepairItemPart(repairItemPartRequest); return(list); }
/// <summary> /// 维修配件基础数据 /// </summary> /// <param name="repairItemPartRequest"></param> /// <returns></returns> public string QueryRepairItemPart(RepairItemPartRequest repairItemPartRequest) { var filter = string.Empty; if (!string.IsNullOrWhiteSpace(repairItemPartRequest.search)) { filter += $"<filter type='or'>"; filter += $"<condition attribute='mcs_name' operator='like' value='%{repairItemPartRequest.search}%' />"; filter += $"<condition attribute='mcs_pinyincode' operator='like' value='%{repairItemPartRequest.search}%' />"; filter += $"</filter>"; } var fetchString = $@"<fetch version='1.0' count='{repairItemPartRequest.pageSize}' page='{repairItemPartRequest.page}' output-format='xml-platform' mapping='logical' distinct='false'> <entity name='mcs_repairitempart'> <attribute name='mcs_name' /> <attribute name='createdon' /> <attribute name='mcs_repairitemid' /> <attribute name='mcs_remark' /> <attribute name='mcs_price' /> <attribute name='mcs_partsid' /> <attribute name='mcs_pinyincode' /> <attribute name='mcs_repairitempartid' /> <order attribute='mcs_name' descending='true' /> <filter type='and'> <condition attribute='statecode' operator='eq' value='0' /> </filter> <link-entity name='mcs_repairiteminfo' from='mcs_repairiteminfoid' to='mcs_repairitemid' visible='false' link-type='outer' alias='repairitem'> <attribute name='mcs_name' /> </link-entity> <link-entity name='mcs_parts' from='mcs_partsid' to='mcs_partsid' visible='false' link-type='outer' alias='part'> <attribute name='mcs_name' /> </link-entity> </entity> </fetch>"; return(fetchString); }
/// <summary> /// 查询维修配件基础数据 /// </summary> /// <param name="repairItemPartRequest"></param> /// <returns></returns> public async Task <QueryResult <CrmEntity> > QueryRepairItemPart(RepairItemPartRequest repairItemPartRequest) { return(await _baseDataService.QueryRepairItemPart(repairItemPartRequest)); }