Exemple #1
0
        /// <summary>
        /// 接待员
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public async Task <QueryResult <CrmEntity> > QueryReceptioncommissioner(ReceptioncommissionerRequest request)
        {
            try
            {
                var fetchString = _baseDataRepository.QueryReceptioncommissioner(request);

                var fetchXdoc    = XDocument.Parse(fetchString);
                var fetchRequest = new CrmRetrieveMultipleFetchRequestMessage()
                {
                    EntityName = "mcs_receptioncommissioner",
                    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;
            }
        }
Exemple #2
0
        /// <summary>
        /// 接待专员
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public string QueryReceptioncommissioner(ReceptioncommissionerRequest request)
        {
            var filter = string.Empty;

            if (!string.IsNullOrWhiteSpace(request.search))
            {
                filter += $"<filter type='or'>";
                filter += $"<condition attribute='mcs_code' operator='like' value='%{request.search}%' />";
                filter += $"<condition attribute='mcs_name' operator='like' value='%{request.search}%' />";
                filter += $"</filter>";
            }

            var fetchString = $@"<fetch version='1.0' count='{request.pageSize}' page='{request.page}' output-format='xml-platform' mapping='logical' distinct='false'>
                  <entity name='mcs_receptioncommissioner'>
                    <attribute name='mcs_name' /> 
                    <attribute name='mcs_code' />   
                    <order attribute='createdon' descending='true' />
                    <filter type='and'>
                      <condition attribute='statecode' operator='eq' value='0' />
                        {filter}
                    </filter> 
                  </entity>
                </fetch>";

            return(fetchString);
        }
Exemple #3
0
        public async Task <NewtonsoftJsonActionResult <QueryResult <CrmEntity> > > QueryReceptioncommissioner(string seachkey = "", string sort = "", int pageSize = 10, int page = 1)
        {
            var req = new ReceptioncommissionerRequest()
            {
                search   = seachkey,
                page     = page,
                pageSize = pageSize,
                sort     = sort
            };
            var list = await app.QueryReceptioncommissioner(req);

            return(list);
        }
Exemple #4
0
 /// <summary>
 /// 接待员
 /// </summary>
 /// <param name="request"></param>
 /// <returns></returns>
 public async Task <QueryResult <CrmEntity> > QueryReceptioncommissioner(ReceptioncommissionerRequest request) =>
 await _baseDataService.QueryReceptioncommissioner(request);