//
        // GET: /StoreManager/

        public ActionResult Index(SortField sortField = SortField.Name, SortDirection sortDirection = SortDirection.Up)
        {
            var products = db.Products.Include("Category").ToList();

            var sorted = Sort(products, sortField, sortDirection);

            return View(sorted);
        }
        public void SortResults(SortField sortField)
        {
            // set portal query based on sort field
            SetQuery(GetPortalQuery(sortField));

            // refresh search results            
            UpdateResults();
        }
        public void BuildWithCriteria(long countryID, long storeID, long? storeToWorldID, ViewType viewType, DateTime startDate, bool additionalManual, bool manualOnly, bool hideSums, SortField[] sortFields)
        {
            _viewType = viewType;

            if(startDate < DateTimeSql.DatetimeMin || startDate > DateTimeSql.DatetimeMax)
            {
                throw new ValidationException("ErrorBeginDateIncorrect", null);
            }

            if (viewType == ViewType.Weekly)
            {
                if (startDate.DayOfWeek != DayOfWeek.Monday)
                {
                    throw new ValidationException("ErrorBeginDateIncorrect", null);
                }
                _startDate = startDate;
                _endDate = DateTimeHelper.GetSunday(startDate);
            } else if (viewType == ViewType.Daily)
            {
                _viewDate = startDate;
                _startDate = DateTimeHelper.GetMonday(startDate);
                _endDate = DateTimeHelper.GetSunday(startDate);
            }

            _countryID = countryID;
            _storeID = storeID;
            _sortFields = sortFields;

            // Use A4 landscape for single world and A3 for all worlds
            if (storeToWorldID.HasValue)
            {
                _storeToWorldIDs = new long[] { storeToWorldID.Value };
                PaperKind = PaperKind.A4;
                Landscape = true;
            } else
            {
                PaperKind = PaperKind.A3;
                Landscape = false;
            }

            _additionalManual = additionalManual;
            _manualOnly = manualOnly;
            _hideSums = hideSums;

            PrintHeader();

            LoadData();
        }
        private IQueryable<Product> Sort(IQueryable<Product> products, SortField sortField, SortDirection sortDirection)
        {
            if (sortField == SortField.Name)
            {
                if (sortDirection == SortDirection.Up)
                {
                    return products.OrderBy(o => o.Category.Name);
                }
                else
                {
                    return products.OrderByDescending(o => o.Category.Name);
                }
            }

            if (sortField == SortField.Price)
            {
                if (sortDirection == SortDirection.Up)
                {
                    return products.OrderBy(o => o.Price);
                }
                else
                {
                    return products.OrderByDescending(o => o.Price);
                }
            }

            if (sortField == SortField.Title)
            {
                if (sortDirection == SortDirection.Up)
                {
                    return products.OrderBy(o => o.Title);
                }
                else
                {
                    return products.OrderByDescending(o => o.Title);
                }
            }

            // Should not reach here, but return products for compiler
            return products;
        }
Exemple #5
0
        /// <summary>
        /// Initializes a new instance of the <see cref="T:Switchvox.CallQueueLogs.Search"/> class to be executed against one or more call queues
        /// </summary>
        /// <param name="startDate">The minimum date to search from.</param>
        /// <param name="endDate">The maximum date to search to.</param>
        /// <param name="queueAccountIds">A list of Call Queue Account IDs to retrieve data for. At least 1 Account ID must be specified.</param>
        /// <param name="callTypes">A combination of flags indicating the type of calls to include in the search results.</param>
        /// <param name="ignoreWeekends">Whether weekends should be excluded from the search results.</param>
        /// <param name="itemsPerPage">The number of results to return in this request. Additional items can be retrieved by making additional requests and incrementing the pageNumber parameter</param>
        /// <param name="pageNumber">The page of results to return in this request. Used in conjunction with the itemsPerPage parameter.</param>
        /// <param name="sortOrder">How the search results will be sorted.</param>
        /// <param name="sortField">The field of the search results to sort on</param>
        public Search(DateTime startDate, DateTime endDate, string[] queueAccountIds, CallTypes callTypes, bool ignoreWeekends = false, int itemsPerPage = 50, int pageNumber = 1, SortOrder sortOrder = SortOrder.Asc, SortField sortField = SortField.StartTime)
            : base("switchvox.callQueueLogs.search")
        {
            if (queueAccountIds.Length == 0)
                throw new ArgumentException();

            List<XElement> xml = new List<XElement>
            {
                new XElement("start_date", startDate.ToString("yyyy-MM-dd HH:mm:ss")),
                new XElement("end_date",  endDate.ToString("yyyy-MM-dd HH:mm:ss")),
                new XElement("ignore_weekends", Convert.ToInt32(ignoreWeekends)),
                new XElement("queue_account_ids", CreateAccountIdElms(queueAccountIds)),
                new XElement("call_types", CreateCallTypeElms(callTypes)),
                new XElement("sort_field", GetSortField(sortField)),
                new XElement("sort_order", sortOrder.ToString()),
                new XElement("items_per_page", itemsPerPage),
                new XElement("page_number", pageNumber)
            };

            SetXml(xml);
        }
 public static PortalQuery GetPortalQuery(SortField sortField)
 {
     switch (sortField)
     {
         case SortField.None:
             return PortalQuery.Default; // no sort field
         case SortField.HighestRated:
             return PortalQuery.HighestRated; //"avgrating";
         case SortField.MostPopular:
             return PortalQuery.MostPopular; //"numviews";
         case SortField.MostComments:
             return PortalQuery.MostComments; //"numcomments";
         case SortField.Recent:
             return PortalQuery.Recent; //"uploaded";
         case SortField.Title:
             return PortalQuery.Title; //"title";
         case SortField.Owner:
             return PortalQuery.Owner; //"owner";
         default:
             return PortalQuery.Default;
     }
 }
        //
        // GET: /StoreManager/

        public IActionResult Index(SortField sortField = SortField.Name, SortDirection sortDirection = SortDirection.Up)
        {
            // TODO [EF] Swap to native support for loading related data when available
            var products = from product in _db.Products
                           join category in _db.Categories on product.CategoryId equals category.CategoryId
                           select new Product()
                           {
                               ProductArtUrl = product.ProductArtUrl,
                               ProductId = product.ProductId,
                               CategoryId = product.CategoryId,
                               Price = product.Price,
                               Title = product.Title,
                               Category = new Category()
                               {
                                   CategoryId = product.CategoryId,
                                   Name = category.Name
                               }
                           };

            var sorted = Sort(products, sortField, sortDirection);

            return View(sorted);
        }
        private KeyValuePair<string, string>? GetSortParameter(SortField? sortField, SortOrder? sortOrder)
        {
            JsonConvert.DefaultSettings = (() =>
            {
                var settings = new JsonSerializerSettings();
                settings.Converters.Add(new StringEnumConverter {CamelCaseText = true});
                return settings;
            });

            if (!sortOrder.HasValue && !sortField.HasValue)
                return null;

            if (sortOrder.HasValue && sortField.HasValue)
                return new KeyValuePair<string, string>("sort", string.Format("{0},{1}",
                    sortField.Value.ToRequestParameter(),
                    sortOrder.Value.ToRequestParameter()));

            if (sortOrder.HasValue)
                return new KeyValuePair<string, string>("sort", string.Format("{0}",
                    sortOrder.Value.ToRequestParameter()));

            return new KeyValuePair<string, string>("sort", string.Format("{0}",
                sortField.Value.ToRequestParameter()));
        }
Exemple #9
0
        public int Compare(SysFileIf x, SysFileIf y, SortField field, SortDirectrion direction)
        {
            int result = 0;

            switch (field)
            {
            case SortField.Name:
                if (direction == SortDirectrion.Ascending)
                {
                    result = x.Name.CompareTo(y.Name);
                }
                else
                {
                    result = y.Name.CompareTo(x.Name);
                }
                break;

            case SortField.Type:
                if (direction == SortDirectrion.Ascending)
                {
                    result = x.Type.CompareTo(y.Type);
                }
                else
                {
                    result = y.Type.CompareTo(x.Type);
                }
                break;

            case SortField.Size:
                if (direction == SortDirectrion.Ascending)
                {
                    result = x.SizeValue.CompareTo(y.SizeValue);
                }
                else
                {
                    result = y.SizeValue.CompareTo(x.SizeValue);
                }
                break;

            case SortField.CreateTime:
                if (direction == SortDirectrion.Ascending)
                {
                    result = x.CreateDateTime.CompareTo(y.CreateDateTime);
                }
                else
                {
                    result = y.CreateDateTime.CompareTo(x.CreateDateTime);
                }
                break;

            case SortField.WriteTime:
                if (direction == SortDirectrion.Ascending)
                {
                    result = x.WriteDateTime.CompareTo(y.WriteDateTime);
                }
                else
                {
                    result = y.WriteDateTime.CompareTo(x.WriteDateTime);
                }
                break;
            }

            return(result);
        }
 public IList <HospitalModel> Search(ApiHeader apiHeader, string hospitalId, int start = GlobalConstant.StartIndex,
                                     int length        = GlobalConstant.Length, string searchKeyword = null, SortField sortField = SortField.None,
                                     SortType sortType = SortType.Desc, object status                = null)
 {
     throw new NotImplementedException();
 }
Exemple #11
0
 public IList<WebRecordingBasic> GetRecordings(SortField? sort = SortField.Name, SortOrder? order = SortOrder.Asc)
 {
     return Recording.ListAll().Select(rec => rec.ToWebRecording()).SortRecordingList(sort, order).ToList();
 }
Exemple #12
0
 public void Sort(SortField field, SortOrder order, bool recurse)
 {
     Sort(ItemPtr, field, order, recurse);
 }
Exemple #13
0
        /// <summary>
        /// Search for listings by tags.
        /// </summary>
        /// <param name="tags">Specify one or more tags, separated by spaces or semicolons.</param>
        /// <param name="sortOn">Specify the field to sort on</param>
        /// <param name="sortOrder">Specify the direction to sort on </param>
        /// <param name="offset">To page through large result sets</param>
        /// <param name="limit">Specify the number of results to return</param>
        /// <param name="detailLevel">control how much information to return</param>
        /// <returns>the async state of the request</returns>
        public IAsyncResult GetListingsByTags(IEnumerable<string> tags, SortField sortOn, SortOrder sortOrder, int offset, int limit, DetailLevel detailLevel)
        {
            if (!ServiceHelper.TestCallPrerequisites(this, this.GetListingsByTagsCompleted, this.etsyContext))
            {
                return null;
            }

            UriBuilder uriBuilder = UriBuilder.Start(this.etsyContext, "listings/tags/")
                .Append(tags)
                .Sort(sortOn, sortOrder)
                .OffsetLimit(offset, limit)
                .DetailLevel(detailLevel);

            return ServiceHelper.GenerateRequest(this, uriBuilder.Result(), this.GetListingsByTagsCompleted);
        }
Exemple #14
0
        private string GetStringFromField(Document doc, SortField sortField)
        {
            var field = doc.GetField(sortField.Field);

            return(field == null ? "" : field.StringValue);
        }
 /// <summary>
 /// Get all the listings in a shop.
 /// </summary>
 /// <param name="userName">the user name</param>
 /// <param name="sortOn">field to sort on</param>
 /// <param name="sortOrder">sort ascending or descending</param>
 /// <param name="sectionId">shop section to show</param>
 /// <param name="offset">the search results offset</param>
 /// <param name="limit">the search limit</param>
 /// <param name="detailLevel">the level of detail</param>
 /// <returns>the async state</returns>
 public IAsyncResult GetShopListings(string userName, SortField sortOn, SortOrder sortOrder, int? sectionId, int offset, int limit, DetailLevel detailLevel)
 {
     return this.wrappedService.GetShopListings(userName, sortOn, sortOrder, sectionId, offset, limit, detailLevel);
 }
Exemple #16
0
        private IQueryable <Domain.MainBoundedContext.Reports.Aggregates.Report> GetReportsByLogic(Logic logic, SortField sortField, SortOrder sortOrder, ParameterProvider parameterProvider, Int32 pageNum, Int32 pageSize)
        {
            IQueryable <Domain.MainBoundedContext.Reports.Aggregates.Report> query = _reportRepository.GetReportByLogic(logic, parameterProvider);

            if (sortOrder == SortOrder.ASC)
            {
                query = query.OrderBy(sortFields[sortField].GetSortExpression());
            }
            else
            {
                query = query.OrderByDescending(sortFields[sortField].GetSortExpression());
            }

            return(query.Skip(pageNum * pageSize).Take(pageSize));
        }
Exemple #17
0
        private List <AppReport> GetReportsByTeam(Guid teamSiteGuid, Int32 tileId,
                                                  ReportFilter filter, Boolean isCurrentUserTeamSiteAdmin,
                                                  String userAlias, Int32 pageNum, Int32 pageSize, SortField sortField, SortOrder sortOrder)
        {
            #region Get the logic
            TileServices tService = new TileServices(_tileRepository, _teamRepository, _reportRepository, null, null, null, _tileQueryRepository);

            AppTile ap = null;
            bool    hasAdminTeamSite = isCurrentUserTeamSiteAdmin;
            ap = tService.GetTileById(tileId);
            #endregion

            #region Combine the logic

            var topLevelLogic = (new TeamSiteGUID()).Equal(teamSiteGuid).And(ap.GetCombinedLogic(hasAdminTeamSite, tileId));

            var logic = GenerateLogicByFilter(filter);
            if (logic != null)
            {
                topLevelLogic.AddElement(logic);
            }
            #endregion

            #region Compose the logic parameter
            ParameterProvider pp = new ParameterProvider();
            //if (userAlias != "")
            //{
            //pp.AddParameter(ContextVariable.CurrentUser.ToString(), userAlias);
            //}
            pp.AddParameter(ContextVariable.CurrentTeamSiteGuid.ToString(), teamSiteGuid);
            //if (isCurrentUserTeamSiteAdmin)
            //{
            pp.AddParameter(ContextVariable.TeamSiteGuidUnderControl.ToString(), (new List <Guid>()
            {
                teamSiteGuid
            }));
            //}
            #endregion

            #region generate the result

            return(GetReportsByLogic(topLevelLogic, sortField, sortOrder, pp, pageNum, pageSize).ToArray().Select(_ => _.ToAppReport()).ToList());

            #endregion
        }
 private static IOrderedQueryable <T> SortThenBy <T>(this SortField <T> sortField, IOrderedQueryable <T> query) where T : class
 {
     return(sortField.SortOrder == SortOrder.Ascending ? query.ThenBy(sortField.PropertyName.ToExpression <T>()) : query.ThenByDescending(sortField.PropertyName.ToExpression <T>()));
 }
Exemple #19
0
 public IList<WebScheduleBasic> GetSchedulesByRange(int start, int end, SortField? sort = SortField.Name, SortOrder? order = SortOrder.Asc)
 {
     return Schedule.ListAll().Select(s => s.ToWebSchedule()).SortScheduleList(sort, order).TakeRange(start, end).ToList();
 }
Exemple #20
0
 public IList<WebScheduleBasic> GetSchedules(SortField? sort = SortField.Name, SortOrder? order = SortOrder.Asc)
 {
     return Schedule.ListAll().Select(s => s.ToWebSchedule()).SortScheduleList(sort, order).ToList();
 }
Exemple #21
0
 public IList<WebRecordingBasic> GetRecordingsByRange(int start, int end, SortField? sort = SortField.Name, SortOrder? order = SortOrder.Asc)
 {
     return Recording.ListAll().Select(rec => rec.ToWebRecording()).SortRecordingList(sort, order).TakeRange(start, end).ToList();
 }
 private List <OfferModel> DefaultSort()
 {
     _sort = SortField.DateDescending;
     return(Offers !.OrderByDescending(x => x.OfferDate).ToList());
 }
Exemple #23
0
 public IList<WebChannelBasic> GetRadioChannelsBasic(int groupId, SortField? sort = SortField.User, SortOrder? order = SortOrder.Asc)
 {
     return _tvBusiness.GetRadioGuideChannelsForGroup(groupId).Select(ch => ch.ToWebChannelBasic()).SortChannelList(sort, order).ToList();
 }
Exemple #24
0
        private void btncal_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            List <SortField> fields     = new List <SortField>();
            IWorkbook        workbook   = spreadsheetControl1.Document;
            Worksheet        worksheet0 = workbook.Worksheets[0]; //井位信息
            Worksheet        worksheet1 = workbook.Worksheets[1]; //井完整性评价
            Worksheet        worksheet2 = workbook.Worksheets[3]; //权重
            // First sorting field. First column (offset = 0) will be sorted using ascending order.
            SortField sortField1 = new SortField();

            sortField1.ColumnOffset = 0;
            sortField1.Comparer     = worksheet1.Comparers.Ascending;
            fields.Add(sortField1);

            // Second sorting field. Second column (offset = 1) will be sorted using ascending order.
            SortField sortField2 = new SortField();

            sortField2.ColumnOffset = 1;
            sortField2.Comparer     = worksheet1.Comparers.Ascending;
            fields.Add(sortField2);

            // Sort the range by sorting fields.
            // A rectangular range whose left column index is 0, top row index is 0,
            // right column index is 3 and bottom row index is 2. This is the A1:D3 cell range.
            int[] datanum = new int[2];
            datacount(datanum, worksheet1);
            DevExpress.Spreadsheet.Range range = worksheet1.Range.FromLTRB(0, 1, datanum[1], datanum[0]);
            worksheet1.Sort(range, fields);
            List <double>   welllocationx = new List <double>();
            List <double>   welllocationy = new List <double>();
            List <double[]> getDatasource = new List <double[]>();

            wellname          = new List <string>();   //井完整性的井名
            DataTimesource    = new List <DateTime>(); //井完整性的时间
            resultlistfen     = new List <double>();   //井完整性的结果
            resultlistfendraw = new List <double>();   //用于画结果图的评价结果,主要是用时间筛选
            wellnamedraw      = new List <string>();   //用于画结果图的井名
            List <double> result       = new List <double>();
            List <double> weightData   = new List <double>();
            List <string> wellfullname = new List <string>();
            int           countcol     = importdata(getDatasource, DataTimesource, wellname, worksheet1); //井完整性评价

            importdata(weightData, worksheet2);                                                           //权重
            importdata(welllocationx, welllocationy, wellfullname, worksheet0);                           //井坐标
            List <double> topten = new List <double>();

            for (int i = 0; i < getDatasource.Count; i++)
            {
                List <double> tempdata = new List <double>();
                for (int j = 0; j < countcol; j++)
                {
                    tempdata.Add(getDatasource[i][j]);
                }
                tempdata.Sort();
                topten.Add(tempdata[(int)(tempdata.Count * 0.1)]);
            }
            for (int i = 0; i < getDatasource.Count; i++)
            {
                double temp  = 0;
                double temp2 = 0;
                for (int j = 0; j < countcol; j++)
                {
                    temp = temp + getDatasource[i][j] * weightData[j];
                }

                if (temp < 6)
                {
                    temp2 = 0; worksheet1.Cells[i + 1, countcol + 3].Value = "安全";
                }
                else if (temp < 7)
                {
                    temp2 = 1; worksheet1.Cells[i + 1, countcol + 3].Value = "较安全";
                }
                else if (temp < 8)
                {
                    temp2 = 2; worksheet1.Cells[i + 1, countcol + 3].Value = "中等";
                }
                else if (temp < 9)
                {
                    temp2 = 3; worksheet1.Cells[i + 1, countcol + 3].Value = "较危险";
                    string ss = "";
                    for (int j = 0; j < countcol; j++)
                    {
                        if (getDatasource[i][j] > topten[j])
                        {
                            ss = "2";
                        }
                    }
                }
                else
                {
                    temp2 = 4; worksheet1.Cells[i + 1, countcol + 3].Value = "危险";
                }
                resultlistfen.Add(temp2);
                worksheet1.Cells[i + 1, countcol + 2].Value = temp;
                //worksheet2.Visible = false;
            }
            worksheet1.Cells[0, countcol + 2].Value = "综合得分";
            worksheet1.Cells[0, countcol + 3].Value = "评价结果";


            listdate = DataTimesource.Distinct().ToList();

            for (int i = 0; i < listdate.Count; i++)
            {
                (timeselect.Edit as RepositoryItemComboBox).Items.Add(listdate[i].ToShortDateString());
            }
            timeselect.EditValue = (timeselect.Edit as RepositoryItemComboBox).Items[0];
            adddraw(wellfullname, welllocationx, welllocationy);
            adddraw2(listdate[0].ToShortDateString() + "井筒完整性评价结果图");
            //ComboBoxproperties.Items.AddRange
            for (int i = 0; i < DataTimesource.Count; i++)
            {
                if (DataTimesource[i] == listdate[0])
                {
                    resultlistfendraw.Add(resultlistfen[i]); // = new List<double>();//用于画结果图的评价结果,主要是用时间筛选
                    wellnamedraw.Add(wellname[i]);           // = new List<string>();//用于画结果图的井名
                }
            }
        }
Exemple #25
0
 public IList<WebChannelDetailed> GetChannelsDetailed(int groupId, SortField? sort = SortField.User, SortOrder? order = SortOrder.Asc)
 {
     return _tvBusiness.GetTVGuideChannelsForGroup(groupId).Select(ch => ch.ToWebChannelDetailed()).SortChannelList(sort, order).ToList();
 }
Exemple #26
0
 public MyOrderDetailFilter()
 {
     Id = new SortField <int>(SortMode.Desc);
 }
Exemple #27
0
        /// <summary>
        /// Search for listings by category.
        /// </summary>
        /// <param name="category">the category name</param>
        /// <param name="sortOn">Specify the field to sort on</param>
        /// <param name="sortOrder">Specify the direction to sort on</param>
        /// <param name="offset">To page through large result sets</param>
        /// <param name="limit">Specify the number of results to return</param>
        /// <param name="detailLevel">control how much information to return</param>
        /// <returns>the async state of the request</returns>
        public IAsyncResult GetListingsByCategory(string category, SortField sortOn, SortOrder sortOrder, int offset, int limit, DetailLevel detailLevel)
        {
            if (!ServiceHelper.TestCallPrerequisites(this, this.GetListingsByCategoryCompleted, this.etsyContext))
            {
                return null;
            }

            UriBuilder uriBuilder = UriBuilder.Start(this.etsyContext, "listings/category", category)
                .Sort(sortOn, sortOrder)
                .OffsetLimit(offset, limit)
                .DetailLevel(detailLevel);

            return ServiceHelper.GenerateRequest(this, uriBuilder.Result(), this.GetListingsByCategoryCompleted);
        }
Exemple #28
0
 public IList <ClinicResult> Search(ApiHeader apiHeader, string hospitalId, int start = 0, int length = int.MaxValue, string searchKeyword = null, SortField sortField = SortField.None, SortType sortType = SortType.Desc, object status = null)
 {
     throw new NotImplementedException();
 }
        public void TestSearchAfterWhenSortingByFunctionValues()
        {
            Directory         dir = NewDirectory();
            IndexWriterConfig iwc = NewIndexWriterConfig(TEST_VERSION_CURRENT, null);

            iwc.SetMergePolicy(NewLogMergePolicy()); // depends on docid order
            RandomIndexWriter writer = new RandomIndexWriter(Random(), dir, iwc);

            Document doc   = new Document();
            Field    field = new StringField("value", "", Field.Store.YES);

            doc.Add(field);

            // Save docs unsorted (decreasing value n, n-1, ...)
            const int NUM_VALS = 5;

            for (int val = NUM_VALS; val > 0; val--)
            {
                field.StringValue = Convert.ToString(val);
                writer.AddDocument(doc);
            }

            // Open index
            IndexReader reader = writer.Reader;

            writer.Dispose();
            IndexSearcher searcher = NewSearcher(reader);

            // Get ValueSource from FieldCache
            IntFieldSource src = new IntFieldSource("value");
            // ...and make it a sort criterion
            SortField sf      = src.GetSortField(false).Rewrite(searcher);
            Sort      orderBy = new Sort(sf);

            // Get hits sorted by our FunctionValues (ascending values)
            Query   q    = new MatchAllDocsQuery();
            TopDocs hits = searcher.Search(q, reader.MaxDoc, orderBy);

            assertEquals(NUM_VALS, hits.ScoreDocs.Length);
            // Verify that sorting works in general
            int i = 0;

            foreach (ScoreDoc hit in hits.ScoreDocs)
            {
                int valueFromDoc = Convert.ToInt32(reader.Document(hit.Doc).Get("value"));
                assertEquals(++i, valueFromDoc);
            }

            // Now get hits after hit #2 using IS.searchAfter()
            int      afterIdx = 1;
            FieldDoc afterHit = (FieldDoc)hits.ScoreDocs[afterIdx];

            hits = searcher.SearchAfter(afterHit, q, reader.MaxDoc, orderBy);

            // Expected # of hits: NUM_VALS - 2
            assertEquals(NUM_VALS - (afterIdx + 1), hits.ScoreDocs.Length);

            // Verify that hits are actually "after"
            int afterValue = (int)((double?)afterHit.Fields[0]);

            foreach (ScoreDoc hit in hits.ScoreDocs)
            {
                int val = Convert.ToInt32(reader.Document(hit.Doc).Get("value"));
                assertTrue(afterValue <= val);
                assertFalse(hit.Doc == afterHit.Doc);
            }
            reader.Dispose();
            dir.Dispose();
        }
Exemple #30
0
        /// <summary>
        /// 获取分页信息
        /// </summary>
        /// <returns></returns>
        public List <Cost> GetPageList(int pageSize, int pageIndex, List <QueryField> queryList, SortField sort, out int recordCount)
        {
            List <Cost> li = new Repository <Cost>().GetList(pageSize, pageIndex, queryList, sort, out recordCount) as List <Cost>;

            return(li);
        }
        private Sort GetSortCriteria(string sortByField = null)
        {
            if (String.IsNullOrWhiteSpace(sortByField))
                return Sort.RELEVANCE;
                      
            var fieldName = sortByField.Trim().TrimStart('+');
            var isDescending = fieldName.StartsWith("-", StringComparison.InvariantCulture);
            if (isDescending)
                fieldName = fieldName.TrimStart('-');

            var sortBySchemaField = Schema.FindField(fieldName, false);
            if (sortBySchemaField == null)
                throw new LuceneQueryParserException($"Invalid sortBy field: '{fieldName}'.");

            // Notes: 
            // 1. The actual sort fieldname is different, e.g. 'fieldName' ==> '__fieldName_sort__'
            // 2. If a document does not have a value for the sort field, a default 'missing value' is assigned
            //    so that the document always appears last in the resultset.

            var sortFieldName = fieldName.ToSortFieldName();
            SortField sortField = null;

            switch (sortBySchemaField.DataType)
            {
                case Schema.DataType.Number:
                    sortField = new SortField(sortFieldName, SortFieldType.DOUBLE, isDescending);
                    sortField.SetMissingValue(isDescending ? LuceneUtils.DOUBLE_MIN_VALUE : LuceneUtils.DOUBLE_MAX_VALUE);
                    break;

                case Schema.DataType.DateTime:
                case Schema.DataType.Boolean:
                    sortField = new SortField(sortFieldName, SortFieldType.LONG, isDescending);
                    sortField.SetMissingValue(isDescending ? LuceneUtils.LONG_MIN_VALUE : LuceneUtils.LONG_MAX_VALUE);
                    break;

                case Schema.DataType.Text:
                case Schema.DataType.Guid:
                    sortField = new SortField(sortFieldName, SortFieldType.STRING, isDescending);
                    sortField.SetMissingValue(isDescending ?  SortField.STRING_FIRST : SortField.STRING_LAST );
                    break;

                default:
                    throw new LuceneQueryParserException($"Invalid sortBy field: '{fieldName}'. Only Number, DateTime, Boolean, Text, and GUID fields can be used for sorting.");
            }

            if (sortField == null)
                return Sort.RELEVANCE;
            else   
                return new Sort(new[] { sortField });
        }
Exemple #32
0
        /// <summary>
        /// 获取翻页一览
        /// </summary>
        /// <param name="pageSize"></param>
        /// <param name="pageIndex"></param>
        /// <param name="queryList"></param>
        /// <param name="sort"></param>
        /// <param name="recordCount"></param>
        /// <returns></returns>
        public virtual IList <T> GetList(int pageSize, int pageIndex, List <QueryField> queryList, SortField sort, out int recordCount)
        {
            int       startIndex = pageSize * (pageIndex - 1);
            ICriteria crit       = Session.CreateCriteria <T>();

            if (queryList != null)
            {
                foreach (var query in queryList)
                {
                    crit.Add(GetExpression(query));
                }
            }



            // Copy current ICriteria instance to the new one for getting the pagination records.
            ICriteria pageCrit = CriteriaTransformer.Clone(crit);

            // Get the total record count
            recordCount = Convert.ToInt32(pageCrit.SetProjection(Projections.RowCount()).UniqueResult());

            if (sort != null)
            {
                crit.AddOrder(GetOrder(sort));
            }

            return(crit.SetFirstResult(startIndex)
                   .SetMaxResults(pageSize)
                   .List <T>());
        }
Exemple #33
0
        private IDisposable GetSort(IndexQueryServerSide query, Index index, Func <string, SpatialField> getSpatialField, DocumentsOperationContext documentsContext, out Sort sort)
        {
            sort = null;
            if (query.PageSize == 0) // no need to sort when counting only
            {
                return(null);
            }

            var orderByFields = query.Metadata.OrderBy;

            if (orderByFields == null)
            {
                if (query.Metadata.HasBoost == false && index.HasBoostedFields == false)
                {
                    return(null);
                }

                sort = SortByFieldScore;
                return(null);
            }

            int sortIndex = 0;
            var sortArray = new ArraySegment <SortField>(ArrayPool <SortField> .Shared.Rent(orderByFields.Length), sortIndex, orderByFields.Length);

            foreach (var field in orderByFields)
            {
                if (field.OrderingType == OrderByFieldType.Random)
                {
                    string value = null;
                    if (field.Arguments != null && field.Arguments.Length > 0)
                    {
                        value = field.Arguments[0].NameOrValue;
                    }

                    sortArray[sortIndex++] = new RandomSortField(value);
                    continue;
                }

                if (field.OrderingType == OrderByFieldType.Score)
                {
                    if (field.Ascending)
                    {
                        sortArray[sortIndex++] = SortField.FIELD_SCORE;
                    }
                    else
                    {
                        sortArray[sortIndex++] = new SortField(null, 0, true);
                    }
                    continue;
                }

                if (field.OrderingType == OrderByFieldType.Distance)
                {
                    var spatialField = getSpatialField(field.Name);

                    int   lastArgument;
                    Point point;
                    switch (field.Method)
                    {
                    case MethodType.Spatial_Circle:
                        var cLatitude  = field.Arguments[1].GetDouble(query.QueryParameters);
                        var cLongitude = field.Arguments[2].GetDouble(query.QueryParameters);
                        lastArgument = 2;
                        point        = spatialField.ReadPoint(cLatitude, cLongitude).GetCenter();
                        break;

                    case MethodType.Spatial_Wkt:
                        var          wkt          = field.Arguments[0].GetString(query.QueryParameters);
                        SpatialUnits?spatialUnits = null;
                        lastArgument = 1;
                        if (field.Arguments.Length > 1)
                        {
                            spatialUnits = Enum.Parse <SpatialUnits>(field.Arguments[1].GetString(query.QueryParameters), ignoreCase: true);
                            lastArgument = 2;
                        }

                        point = spatialField.ReadShape(wkt, spatialUnits).GetCenter();
                        break;

                    case MethodType.Spatial_Point:
                        var pLatitude  = field.Arguments[0].GetDouble(query.QueryParameters);
                        var pLongitude = field.Arguments[1].GetDouble(query.QueryParameters);
                        lastArgument = 2;
                        point        = spatialField.ReadPoint(pLatitude, pLongitude).GetCenter();
                        break;

                    default:
                        throw new ArgumentOutOfRangeException();
                    }

                    var roundTo = field.Arguments.Length > lastArgument ?
                                  field.Arguments[lastArgument].GetDouble(query.QueryParameters)
                        : 0;

                    var dsort = new SpatialDistanceFieldComparatorSource(spatialField, point, query, roundTo);
                    sortArray[sortIndex++] = new SortField(field.Name, dsort, field.Ascending == false);
                    continue;
                }

                var fieldName   = field.Name.Value;
                var sortOptions = SortField.STRING;

                switch (field.OrderingType)
                {
                case OrderByFieldType.Custom:
                    var cName = field.Arguments[0].NameOrValue;
                    var cSort = new CustomComparatorSource(cName, _index.DocumentDatabase.Name, query);
                    sortArray[sortIndex++] = new SortField(fieldName, cSort, field.Ascending == false);
                    continue;

                case OrderByFieldType.AlphaNumeric:
                    var anSort = new AlphaNumericComparatorSource(documentsContext);
                    sortArray[sortIndex++] = new SortField(fieldName, anSort, field.Ascending == false);
                    continue;

                case OrderByFieldType.Long:
                    sortOptions = SortField.LONG;
                    fieldName  += Constants.Documents.Indexing.Fields.RangeFieldSuffixLong;
                    break;

                case OrderByFieldType.Double:
                    sortOptions = SortField.DOUBLE;
                    fieldName  += Constants.Documents.Indexing.Fields.RangeFieldSuffixDouble;
                    break;
                }

                sortArray[sortIndex++] = new SortField(fieldName, sortOptions, field.Ascending == false);
            }

            sort = new Sort(sortArray);
            return(new ReturnSort(sortArray));
        }
Exemple #34
0
 public void Visit(SortField component)
 {
     throw new NotImplementedException();
 }
Exemple #35
0
 public void Visit(SortField component)
 {
     component.Field.Accept(this);
     sql.Append(component.Descending ? " DESC" : " ASC");
 }
Exemple #36
0
        /// <summary>
        ///根据关键字进行查询,根据int的范围进行搜索
        /// </summary>
        /// <param name="Title"></param>
        /// <returns></returns>
        public List <Bpo_JobEntity> SearchJobList4(string Title, string FullAddress, int MinId, int MaxId)
        {
            List <Bpo_JobEntity> jobList = new List <Bpo_JobEntity>();
            string      path             = "F://LuceneIndexDir";
            FSDirectory dir = FSDirectory.Open(path);

            //IndexSearcher searcher = new IndexSearcher(dir);//声明一个查询器,或者以下面一种方式声明
            IndexReader   reader   = IndexReader.Open(dir, true);//查询器
            IndexSearcher searcher = new IndexSearcher(reader);

            //搜索条件,BooleanQuery可以同时制定多个搜索条件
            BooleanQuery booleanQuery = new BooleanQuery();

            //Query query = new TermQuery(new Term("Title", $"*{Title}*"));//不支持通配符
            //Query query = new WildcardQuery(new Term("Title", $"*{Title}*")); // 通配符

            if (!string.IsNullOrEmpty(Title))//空格隔开,按照多个词进行搜索
            {
                Title = new LuceneAnalyze().AnalyzerKeyword("Title", Title);
                QueryParser parser = new QueryParser(Lucene.Net.Util.Version.LUCENE_30, "Title", new PanGuAnalyzer());
                Query       query  = parser.Parse(Title);
                booleanQuery.Add(query, Occur.MUST);
            }
            if (MinId > 0)//空格隔开,按照多个词进行搜索
            {
                //string idStr = new LuceneAnalyze().AnalyzerKeyword("Id", MinId.ToString());
                QueryParser parser = new QueryParser(Lucene.Net.Util.Version.LUCENE_30, "Id", new PanGuAnalyzer());
                Query       query  = parser.Parse(MinId.ToString());
                booleanQuery.Add(query, Occur.MUST);
            }

            if (!string.IsNullOrEmpty(FullAddress))
            {
                FullAddress = new LuceneAnalyze().AnalyzerKeyword("FullAddress", FullAddress);
                QueryParser parser = new QueryParser(Lucene.Net.Util.Version.LUCENE_30, "FullAddress", new PanGuAnalyzer());
                Query       query  = parser.Parse(FullAddress);
                booleanQuery.Add(query, Occur.MUST);

                //使用WildcardQuery,相当于sql的like
                //Query query2 = new WildcardQuery(new Term("FullAddress", $"*{FullAddress}*")); // 通配符
                //booleanQuery.Add(query2, Occur.MUST);
            }

            //根据id区间区间搜索(此时id存储索引时要是NumericField类型)
            NumericRangeFilter <int> intFilter = null;
            //if (MinId > 0 && MaxId == 0)
            //{
            //    intFilter = NumericRangeFilter.NewIntRange("Id", MinId, int.MaxValue, true, true);
            //}
            //else if (MaxId > 0 && MinId == 0)
            //{
            //    intFilter = NumericRangeFilter.NewIntRange("Id", 0, MaxId, true, true);
            //}
            //else if (MaxId > 0 && MinId > 0)
            //{
            //    intFilter = NumericRangeFilter.NewIntRange("Id", MinId, MaxId, true, true);
            //}

            //定义排序
            SortField sortField  = new SortField("Id", SortField.STRING, false);     //降序
            SortField sortField2 = new SortField("CompanyId", SortField.INT, false); //降序
            Sort      sort       = new Sort(sortField, sortField2);

            //取搜索结果方法1:
            TopDocs docs = searcher.Search(booleanQuery, intFilter, 10000, sort); //找到的结果取100条数据

            foreach (ScoreDoc sd in docs.ScoreDocs)                               //从docs.ScoreDocs取数据
            {
                Document doc = searcher.Doc(sd.Doc);
                jobList.Add(new Bpo_JobEntity
                {
                    Id          = Convert.ToInt32(doc.Get("Id") ?? "-100"),
                    Title       = doc.Get("Title"),
                    UserId      = Convert.ToInt32(doc.Get("UserId") ?? "-100"),
                    UserName    = doc.Get("UserName"),
                    CompanyId   = Convert.ToInt32(doc.Get("CompanyId") ?? "-100"),
                    CompanyName = doc.Get("CompanyName"),
                    FullAddress = doc.Get("FullAddress"),
                    CreateDate  = Convert.ToDateTime(doc.Get("CreateDate"))
                });
            }
            return(jobList);
        }
        public void AddGridToCollection(DBSNAPGridView sdg, DataGridNameCollection thispage_dgnc)
        {
            // is it already in the collection ?
            //if not, create a new datagridcouple and add it to the collection
            if (!IsDGNinDGNC(sdg.ID, thispage_dgnc))
            {
                DataGridControl dc = new DataGridControl();
                dc.GridName      = sdg.ID;
                dc.ViewSource    = sdg.ViewSource;
                dc.ActionTarget  = sdg.ActionTarget;
                dc.SQLB.Distinct = sdg.Distinct;

                if (sdg.AllowPaging)
                {
                    dc.SQLB.PageIndex = sdg.PageIndex;
                    dc.SQLB.PageSize  = sdg.PageSize;
                }
                else
                {
                    dc.SQLB.PageSize = -1;
                }

                //setting the keyfields in the SQLB of the dc
                string[] keyfields = sdg.PrimaryKey.Split(',');
                foreach (string keyfield in keyfields)
                {
                    string    kf     = keyfield.Trim();
                    DataField dfield = new DataField();
                    dfield.Name    = kf;
                    dfield.PKField = true;
                    dc.SQLB.DataFields.Add(dfield);
                }

                dc.ParentControl       = sdg.ParentControl;
                dc.ParentKeyExpression = sdg.ParentKeyExpression;

                //setting the parentkey fields as filters
                //getting the keys
                if (dc.ParentKeyExpression != null && dc.ParentKeyExpression != "")
                {
                    string[] parentkeys = sdg.ParentKeyExpression.Split(',');

                    foreach (string parentkey in parentkeys)
                    {
                        string[] keys = parentkey.Split('=');

                        FilterField ffield = new FilterField();
                        ffield.Name       = keys[1].Trim();
                        ffield.FilterType = snpFilterType.Equal;
//						ffield.Value = keys[0].Trim();
                        ffield.ParentKey = true;

                        dc.SQLB.FilterFields.Add(ffield);
                    }
                }

                //putting in the datagrid columns as datafields

                DataControlFieldCollection cols = sdg.Columns;

                foreach (DataControlField col in cols)
                {
                    string dfieldname = string.Empty;

                    try
                    {
                        Type t = col.GetType();
                        dfieldname = (string)t.InvokeMember("DataField", System.Reflection.BindingFlags.GetProperty, null, col, new object[] { });
                    }
                    catch
                    { }

                    if (dfieldname != string.Empty || dfieldname.Trim() != string.Empty)
                    {
                        DataField dfield = new DataField();

                        dfield.Name = dfieldname.Trim();

                        dc.SQLB.DataFields.Add(dfield);
                    }
                }

                //setting the sortfields in the SQLB of the dc
                string[] sortfields = sdg.OrderBy.Split(',');

                foreach (string sortfield in sortfields)
                {
                    string   sf  = sortfield.Trim();
                    string[] sfe = sf.Split(' ');

                    string sfe0 = sfe[0] == null || sfe[0] == "" ? "" : sfe[0].Trim();

                    if (sfe0 != "")
                    {
                        SortField sfield = new SortField();
                        sfield.Name = sfe0;

                        string sfe1 = sfe[1] == null || sfe[1] == "" ? "" : sfe[1].Trim();

                        if (sfe1 != "")
                        {
                            sfe1 = sfe1.ToUpper();
                            if (sfe1 == "ASC")
                            {
                                sfield.Order = snpOrder.ASC;
                            }
                            else
                            {
                                sfield.Order = snpOrder.DESC;
                            }
                        }

                        dc.SQLB.SortFields.Add(sfield);
                    }
                }

                dc.GridPage = sdg.Page.ToString();
                dc.OnPage   = true;
                thispage_dgnc.Add(dc);

                //also adding the parentdatagrid
                //this is necessary for 2 reasons :
                //-sorting the grids
                //-also, when there are no controls on the page

                if (dc.ParentControl != null && dc.ParentControl != "")
                {
                    AddParentControl(sdg.Page, dc, thispage_dgnc);
                }
            }
        }
Exemple #38
0
 /// ------------------------------------------------------------------------------------
 internal NodeComparer(string srcLangId, string tgtLangId, SortOrder sortOrder, SortField sortField)
 {
     _srcLangId = srcLangId;
     _tgtLangId = tgtLangId;
     _sortOrder = sortOrder;
     _sortField = sortField;
 }
Exemple #39
0
        public void DeserialiseSearchResultJson_SortFieldNotNull_ReturnsSortFieldEnum(SortField expectedValue, string sortFieldJson)
        {
            string sampleJson = $"{{\"foodSearchCriteria\":{{\"sortField\":\"{sortFieldJson}\"}}}}";

            SearchResult searchResult = JsonConvert.DeserializeObject <SearchResult>(sampleJson);

            Assert.Equal(expectedValue, searchResult.FoodSearchCriteria.SortField);
        }
Exemple #40
0
        public static void Show()
        {
            FSDirectory   dir      = FSDirectory.Open(StaticConstant.TestIndexPath);
            IndexSearcher searcher = new IndexSearcher(dir);               //查找器
            {
                TermQuery query = new TermQuery(new Term("title", "图书馆")); //包含
                TopDocs   docs  = searcher.Search(query, null, 10000);     //找到的数据
                foreach (ScoreDoc sd in docs.ScoreDocs)
                {
                    Document doc = searcher.Doc(sd.Doc);
                    Console.WriteLine("***************************************");
                    Console.WriteLine(string.Format("id={0}", doc.Get("id")));
                    Console.WriteLine(string.Format("title={0}", doc.Get("title")));
                    Console.WriteLine(string.Format("time={0}", doc.Get("time")));
                    Console.WriteLine(string.Format("price={0}", doc.Get("price")));
                    Console.WriteLine(string.Format("content={0}", doc.Get("content")));
                }
                Console.WriteLine("1一共命中了{0}个", docs.TotalHits);
            }

            QueryParser parser = new QueryParser(Lucene.Net.Util.Version.LUCENE_30, "title", new PanGuAnalyzer());//解析器
            {
                //string keyword = "高中政治人教新课标选修生活中的法律常识";
                string keyword = "高中政治 人 教 新课 标 选修 生活 中的 法律常识";
                {
                    Query   query = parser.Parse(keyword);
                    TopDocs docs  = searcher.Search(query, null, 10000);//找到的数据

                    int i = 0;
                    foreach (ScoreDoc sd in docs.ScoreDocs)
                    {
                        if (i++ < 1000)
                        {
                            Document doc = searcher.Doc(sd.Doc);
                            Console.WriteLine("***************************************");
                            Console.WriteLine(string.Format("id={0}", doc.Get("id")));
                            Console.WriteLine(string.Format("title={0}", doc.Get("title")));
                            Console.WriteLine(string.Format("time={0}", doc.Get("time")));
                            Console.WriteLine(string.Format("price={0}", doc.Get("price")));
                        }
                    }
                    Console.WriteLine($"一共命中{docs.TotalHits}");
                }
                {
                    Query query = parser.Parse(keyword);
                    NumericRangeFilter <int> timeFilter = NumericRangeFilter.NewIntRange("time", 20190101, 20191231, true, true); //过滤
                    SortField sortPrice = new SortField("price", SortField.DOUBLE, false);                                        //降序
                    SortField sortTime  = new SortField("time", SortField.INT, true);                                             //升序
                    Sort      sort      = new Sort(sortTime, sortPrice);                                                          //排序 哪个前哪个后

                    TopDocs docs = searcher.Search(query, timeFilter, 10000, sort);                                               //找到的数据
                    int     i    = 0;
                    foreach (ScoreDoc sd in docs.ScoreDocs)
                    {
                        if (i++ < 1000)
                        {
                            Document doc = searcher.Doc(sd.Doc);
                            Console.WriteLine("***************************************");
                            Console.WriteLine(string.Format("id={0}", doc.Get("id")));
                            Console.WriteLine(string.Format("title={0}", doc.Get("title")));
                            Console.WriteLine(string.Format("time={0}", doc.Get("time")));
                            Console.WriteLine(string.Format("price={0}", doc.Get("price")));
                        }
                    }
                    Console.WriteLine("3一共命中了{0}个", docs.TotalHits);
                }
            }
        }
 public SymbolsListComparer(int displayIndex, bool isAscending)
 {
     Debug.Assert(displayIndex >= 0 && displayIndex <= 4);
     mIsAscending = isAscending;
     mSortField   = (SortField)displayIndex;
 }
Exemple #42
0
        /// <summary>
        /// 产品搜索
        /// 从索引
        /// </summary>
        /// <param name="key">搜索关键字</param>
        /// <param name="categorySysNo">分类编号</param>
        /// <param name="attributes">属性列表</param>
        /// <param name="pageIndex">页码</param>
        /// <param name="pageSize">页大小</param>
        /// <param name="pageCount">分页总数</param>
        /// <param name="recCount">总记录数</param>
        /// <param name="highLight">是否高亮关键字</param>
        /// <param name="sort">排序(0:相关度 1:销量 2:价格 3:评分 4:上架时间)</param>
        /// <param name="isDescending">true 为降序 false为升序</param>
        /// <param name="productSysNo">商品编号</param>
        /// <param name="priceSource">产品价格来源</param>
        /// <param name="priceSourceSysNo">产品价格来源编号(会员等级编号)</param>
        /// <param name="showNotFrontEndOrder">搜索前台不能下单的商品(2014-2-14 黄波 添加 物流APP需要)</param>
        /// <returns>商品列表</returns>
        /// <remarks>2013-08-08 黄波 创建</remarks>
        /// <remarks>2013-11-12 邵斌 修改 添加搜索商品系统编号:该方法暂时闲置</remarks>
        /// <remarks>2013-12-23 邵斌 添加前台是否下单字段</remarks>
        /// <remarks>2014-02-14 黄波 添加是否搜索前台不能下单的商品(物流APP需要)</remarks>
        public IList <PdProductIndex> Search(string key
                                             , int?categorySysNo
                                             , List <int> attributes
                                             , int pageSize
                                             , ref int pageIndex
                                             , ref int pageCount
                                             , ref int recCount
                                             , bool highLight    = false
                                             , int sort          = 1
                                             , bool isDescending = false
                                             , int productSysNo  = 0
                                             , ProductStatus.产品价格来源 priceSource = ProductStatus.产品价格来源.会员等级价
                                             , int priceSourceSysNo             = CustomerLevel.初级
                                             , bool showNotFrontEndOrder        = false)
        {
            var returnValue = new List <PdProductIndex>();
            var indexSearch = Hyt.Infrastructure.Lucene.ProductIndex.Searcher;

            try
            {
                pageIndex = pageIndex == 0 ? 1 : pageIndex;
                key       = key ?? ""; //查询设置初始值

                #region 搜索条件
                BooleanQuery query = new BooleanQuery();
                BooleanQuery childQuery;
                BooleanQuery esenQuery;

                #region 关键字搜索
                string keywords = key.Trim();
                if (!string.IsNullOrWhiteSpace(keywords))
                {
                    childQuery = new BooleanQuery();
                    esenQuery  = new BooleanQuery();
                    if (!IsErpCode(keywords))
                    {
                        ////全词去空格
                        //esenQuery.Add(new TermQuery(new Term("ProductName", Regex.Replace(keywords, @"\s", ""))),
                        //        BooleanClause.Occur.SHOULD);
                        //esenQuery.SetBoost(3.0F);
                        //esenQuery.Add(new TermQuery(new Term("ProductSubName", Regex.Replace(keywords, @"\s", ""))),
                        //        BooleanClause.Occur.SHOULD);
                        //esenQuery.SetBoost(3.0F);
                        //childQuery.Add(esenQuery, BooleanClause.Occur.SHOULD);

                        esenQuery = new BooleanQuery();
                        //分词 盘古分词
                        var keyWordsSplitBySpace = GetKeyWordsSplitBySpace(keywords);

                        if (string.IsNullOrWhiteSpace(keyWordsSplitBySpace))
                        {
                            return(null);
                        }

                        keyWordsSplitBySpace = string.Format("{0}^{1}.0", keywords, (int)Math.Pow(3, 5));

                        QueryParser productNameQueryParser = new QueryParser(Lucene.Net.Util.Version.LUCENE_29, "ProductName", new PanGuAnalyzer(true));
                        Query       productNameQuery       = productNameQueryParser.Parse(keyWordsSplitBySpace);
                        childQuery.Add(productNameQuery, BooleanClause.Occur.SHOULD);

                        //以什么开头,输入“ja”就可以搜到包含java和javascript两项结果了
                        Query prefixQuery_productName = new PrefixQuery(new Term("ProductName", key));
                        //直接模糊匹配,假设你想搜索跟‘wuzza’相似的词语,你可能得到‘fuzzy’和‘wuzzy’。
                        Query fuzzyQuery_productName = new FuzzyQuery(new Term("ProductName", key));
                        //通配符搜索
                        Query wildcardQuery_productName = new WildcardQuery(new Term("ProductName", string.Format("*{0}*", key.Trim())));


                        childQuery.Add(prefixQuery_productName, BooleanClause.Occur.SHOULD);
                        childQuery.Add(fuzzyQuery_productName, BooleanClause.Occur.SHOULD);
                        childQuery.Add(wildcardQuery_productName, BooleanClause.Occur.SHOULD);
                        //esenQuery.Add(new QueryParser("ProductName", new PanGuAnalyzer(true)).Parse(keyWordsSplitBySpace), BooleanClause.Occur.SHOULD);
                        //esenQuery.Add(new QueryParser("ProductSubName", new PanGuAnalyzer(true)).Parse(keyWordsSplitBySpace), BooleanClause.Occur.SHOULD);

                        ////分词  按空格
                        //var keyColl = keywords.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
                        //foreach (var item in keyColl)
                        //{
                        //    esenQuery.Add(new TermQuery(new Term("ProductName", item)),
                        //        BooleanClause.Occur.SHOULD);
                        //    esenQuery.Add(new TermQuery(new Term("ProductSubName", item)),
                        //        BooleanClause.Occur.SHOULD);
                        //}
                        //esenQuery.SetBoost(2.9F);
                        //childQuery.Add(esenQuery, BooleanClause.Occur.SHOULD);
                    }
                    else
                    {
                        esenQuery.Add(new TermQuery(new Term("ErpCode", Regex.Replace(keywords, @"\s", ""))),
                                      BooleanClause.Occur.SHOULD);
                        esenQuery.SetBoost(3.0F);
                        childQuery.Add(esenQuery, BooleanClause.Occur.SHOULD);
                    }

                    query.Add(childQuery, BooleanClause.Occur.MUST);
                }
                #endregion

                #region 分类搜索
                if (categorySysNo.HasValue && categorySysNo.Value != 0)
                {
                    childQuery = new BooleanQuery();

                    esenQuery = new BooleanQuery();
                    esenQuery.Add(new TermQuery(new Term("Category", categorySysNo.Value.ToString())),
                                  BooleanClause.Occur.SHOULD);
                    esenQuery.SetBoost(3.0F);
                    childQuery.Add(esenQuery, BooleanClause.Occur.SHOULD);

                    esenQuery = new BooleanQuery();
                    esenQuery.Add(new WildcardQuery(new Term("AssociationCategory", string.Format("*,{0},*", categorySysNo.Value.ToString()))),
                                  BooleanClause.Occur.SHOULD);
                    esenQuery.SetBoost(2.8F);
                    childQuery.Add(esenQuery, BooleanClause.Occur.SHOULD);

                    //所有子分类
                    var childCategoryList = Hyt.BLL.Web.PdCategoryBo.Instance.GetChildAllCategory(categorySysNo.Value);
                    foreach (var item in childCategoryList)
                    {
                        esenQuery = new BooleanQuery();
                        esenQuery.Add(new TermQuery(new Term("Category", item.SysNo.ToString())),
                                      BooleanClause.Occur.SHOULD);
                        esenQuery.SetBoost(3.0F);
                        childQuery.Add(esenQuery, BooleanClause.Occur.SHOULD);

                        esenQuery = new BooleanQuery();
                        esenQuery.Add(new WildcardQuery(new Term("AssociationCategory", string.Format("*,{0},*", item.SysNo.ToString()))),
                                      BooleanClause.Occur.SHOULD);
                        childQuery.Add(esenQuery, BooleanClause.Occur.SHOULD);
                    }

                    query.Add(childQuery, BooleanClause.Occur.MUST);
                }
                #endregion

                #region 属性搜索
                if (attributes != null)
                {
                    childQuery = new BooleanQuery();
                    esenQuery  = new BooleanQuery();

                    foreach (var item in attributes)
                    {
                        esenQuery.Add(new WildcardQuery(new Term("Attributes", string.Format("*,*:{0},*", item.ToString()))),
                                      BooleanClause.Occur.MUST);
                    }
                    childQuery.Add(esenQuery, BooleanClause.Occur.MUST);

                    query.Add(childQuery, BooleanClause.Occur.MUST);
                }
                #endregion

                #region 品牌搜索
                //if (brandSysNo.Value != 0)
                //{
                //    childQuery = new BooleanQuery();
                //    childQuery.Add(new TermQuery(new Term("BrandSysNo", brandSysNo.Value.ToString())),
                //               BooleanClause.Occur.SHOULD);
                //    childQuery.SetBoost(3.0F);
                //    query.Add(childQuery, BooleanClause.Occur.MUST);
                //}
                #endregion

                #region 仅搜索有效的商品

                childQuery = new BooleanQuery();
                childQuery.Add(new TermQuery(new Term("Status", ((int)Hyt.Model.WorkflowStatus.ProductStatus.产品上线状态.效).ToString())),
                               BooleanClause.Occur.SHOULD);
                query.Add(childQuery, BooleanClause.Occur.MUST);

                //2013-12-23 邵斌 添加前台是否下单字段
                if (!showNotFrontEndOrder)
                {
                    childQuery = new BooleanQuery();
                    childQuery.Add(new TermQuery(new Term("CanFrontEndOrder", ((int)Hyt.Model.WorkflowStatus.ProductStatus.商品是否前台下单.是).ToString())),
                                   BooleanClause.Occur.SHOULD);
                    query.Add(childQuery, BooleanClause.Occur.MUST);
                }

                #endregion

                #region 排序

                //isDescending true为降序 false为升序
                SortField sf = null;
                switch (Math.Abs(sort))
                {
                case 1:    //销量
                    sf = new SortField("SalesCount", SortField.INT, isDescending);
                    break;

                case 2:    //价格
                    sf = new SortField("BasicPrice", SortField.FLOAT, isDescending);
                    break;

                case 3:    //评分
                    sf = new SortField("CommentCount", SortField.INT, isDescending);
                    break;

                case 4:    //上架时间
                    sf = new SortField("CreatedDate", SortField.STRING, isDescending);
                    break;

                default:
                    sf = new SortField(null, SortField.SCORE, false);
                    break;
                }

                Sort luceneSort;                            //排序对象

                //默认匹配度,表明是对固定信息进行搜索,所以就要进行先安匹配度来排序。这样用户搜索的商品将排在前面,方便用户筛选
                if (Math.Abs(sort) != (int)CommonEnum.LuceneProductSortType.默认匹配度)
                {
                    //无搜索关键字的时候就按模式设置的进行排序
                    luceneSort = new Sort();
                    luceneSort.SetSort(sf);
                }
                else
                {
                    //收搜索关键字时,就要先安匹配度进行排序,然后才是设置排序。
                    luceneSort = new Sort(new SortField[] { SortField.FIELD_SCORE, sf });
                }

                #endregion

                #region 商品系统编号搜索

                if (productSysNo > 0)
                {
                    childQuery = new BooleanQuery();

                    esenQuery = new BooleanQuery();
                    esenQuery.Add(new TermQuery(new Term("SysNo", productSysNo.ToString())),
                                  BooleanClause.Occur.SHOULD);
                    esenQuery.SetBoost(3.0F);
                    childQuery.Add(esenQuery, BooleanClause.Occur.SHOULD);

                    query.Add(childQuery, BooleanClause.Occur.MUST);
                }

                #endregion

                #endregion

                Hits hits = indexSearch.Search(query, luceneSort);

                recCount  = hits.Length();
                pageCount = (int)Math.Ceiling((double)recCount / (double)pageSize);
                if (pageIndex <= 0)
                {
                    pageIndex = 1;
                }
                if (pageIndex > pageCount)
                {
                    pageIndex = pageCount;
                }

                var recordIndex = Math.Max((pageIndex - 1) * pageSize, 0);

                PdProductIndex pdProductIndex;
                var            simpleHtmlFormatter = new PanGu.HighLight.SimpleHTMLFormatter("<font color=\"red\">", "</font>");
                var            T_ProductName       = "";
                while (recordIndex < recCount && returnValue.Count < pageSize)
                {
                    try
                    {
                        pdProductIndex = Hyt.Infrastructure.Lucene.ProductIndex.Instance.DocumentToModel(hits.Doc(recordIndex));
                        string productName = pdProductIndex.ProductName;
                        if (highLight && !string.IsNullOrEmpty(key))
                        {
                            var highlighter = new PanGu.HighLight.Highlighter(simpleHtmlFormatter, new PanGu.Segment())
                            {
                                FragmentSize = 50
                            };
                            T_ProductName = highlighter.GetBestFragment(key.Trim(), pdProductIndex.ProductName);
                            if (!string.IsNullOrWhiteSpace(T_ProductName))
                            {
                                pdProductIndex.ProductName = T_ProductName;
                            }
                        }
                        pdProductIndex.RankPrice = GetProductRankPrice(pdProductIndex.Prices, pdProductIndex.BasicPrice, priceSource, priceSourceSysNo);

                        returnValue.Add(pdProductIndex);
                    }
                    catch (Exception ex)
                    {
                        BLL.Log.SysLog.Instance.Error(LogStatus.系统日志来源.后台, ex.Message, ex);
                    }
                    finally
                    {
                        recordIndex++;
                    }
                }
            }
            catch (Exception ex)
            {
                BLL.Log.SysLog.Instance.Error(LogStatus.系统日志来源.后台, ex.Message, ex);
            }
            finally
            {
                // indexSearch.Close();
            }
            return(returnValue);
        }
Exemple #43
0
 /// <summary>
 /// Add a sort specification for the <see cref="P:BrowseResult.Hits"/>.
 /// </summary>
 /// <param name="sortSpec">sort specification</param>
 public virtual void AddSortField(SortField sortSpec)
 {
     m_sortSpecs.Add(sortSpec);
 }
Exemple #44
0
 public SortingParam(SortField field, SortOrder order)
 {
     Field = field;
     Order = order;
 }
Exemple #45
0
 /// <summary>
 /// Append a sort field and sort order to the uri
 /// </summary>
 /// <param name="sortField">the sort field</param>
 /// <param name="sortOrder">the sort order</param>
 /// <returns>the uri builder</returns>
 public UriBuilder Sort(SortField sortField, SortOrder sortOrder)
 {
     this.Param("sort_on", sortField.ToStringLower());
     return this.Param("sort_order", sortOrder.ToStringLower());
 }
Exemple #46
0
        public JsonResult Index(int sortField, string sortType)
        {
            List <SupportModel> models =
                (from mp in _session.Query <MP_CustomerMarketPlace>()
                 where mp.UpdateError != null && mp.UpdateError != ""
                 select new SupportModel
            {
                Umi = mp.Id,
                Type = mp.Marketplace.Name,
                CustomerId = mp.Customer.Id,
                ErrorMessage = mp.UpdateError,
                Name = mp.DisplayName,
                UpdateStartDate = mp.UpdatingStart,
                Status = mp.GetUpdatingStatus(null)
            }).ToList();

            SortField sortFieldEnum = sortField == 0 ? SortField.UpdateStartDate : (SortField)sortField;

            switch (sortFieldEnum)
            {
            case SortField.Umi:
                models = sortType == "asc"
                        ? models.OrderBy(x => x.Umi).ToList()
                        : models.OrderByDescending(x => x.Umi).ToList();
                break;

            case SortField.MpType:
                models = sortType == "asc"
                        ? models.OrderBy(x => x.Type).ToList()
                        : models.OrderByDescending(x => x.Type).ToList();
                break;

            case SortField.MpName:
                models = sortType == "asc"
                        ? models.OrderBy(x => x.Name).ToList()
                        : models.OrderByDescending(x => x.Name).ToList();
                break;

            case SortField.ErrorMessage:
                models = sortType == "asc"
                        ? models.OrderBy(x => x.ErrorMessage).ToList()
                        : models.OrderByDescending(x => x.ErrorMessage).ToList();
                break;

            case SortField.CustomerId:
                models = sortType == "asc"
                        ? models.OrderBy(x => x.CustomerId).ToList()
                        : models.OrderByDescending(x => x.CustomerId).ToList();
                break;

            case SortField.Status:
                models = sortType == "asc"
                        ? models.OrderBy(x => x.Status).ToList()
                        : models.OrderByDescending(x => x.Status).ToList();
                break;

            //case SortField.UpdateStartDate:
            default:
                models = sortType == "asc"
                        ? models.OrderBy(x => x.UpdateStartDate).ToList()
                        : models.OrderByDescending(x => x.UpdateStartDate).ToList();
                break;
            }
            return(Json(new { models }, JsonRequestBehavior.AllowGet));
        }
Exemple #47
0
        /// <summary>
        /// 分页获取商品信息数据
        /// </summary>
        /// <param name="queryString"></param>
        /// <param name="pageIndex">第一页为1</param>
        /// <param name="pageSize"></param>
        /// <param name="totalCount"></param>
        /// <returns></returns>
        public List <Commodity> QueryIndexPage(string queryString, int pageIndex, int pageSize, out int totalCount, string priceFilter, string priceOrderBy)
        {
            totalCount = 0;
            IndexSearcher searcher = null;

            try
            {
                List <Commodity> ciList = new List <Commodity>();
                FSDirectory      dir    = FSDirectory.Open(StaticConstant.IndexPath);
                searcher = new IndexSearcher(dir);
                Analyzer analyzer = new PanGuAnalyzer();

                //--------------------------------------这里配置搜索条件
                QueryParser parser = new QueryParser(Lucene.Net.Util.Version.LUCENE_30, "title", analyzer);
                Query       query  = parser.Parse(queryString);

                pageIndex = Math.Max(1, pageIndex);//索引从1开始
                int startIndex = (pageIndex - 1) * pageSize;
                int endIndex   = pageIndex * pageSize;

                NumericRangeFilter <float> numPriceFilter = null;
                if (!string.IsNullOrWhiteSpace(priceFilter))
                {
                    bool     isContainStart = priceFilter.StartsWith("[");
                    bool     isContainEnd   = priceFilter.EndsWith("]");
                    string[] floatArray     = priceFilter.Replace("[", "").Replace("]", "").Replace("{", "").Replace("}", "").Split(',');
                    float    start          = 0;
                    float    end            = 0;
                    if (!float.TryParse(floatArray[0], out start) || !float.TryParse(floatArray[1], out end))
                    {
                        throw new Exception("Wrong priceFilter");
                    }
                    numPriceFilter = NumericRangeFilter.NewFloatRange("price", start, end, isContainStart, isContainEnd);
                }

                Sort sort = new Sort();
                if (!string.IsNullOrWhiteSpace(priceOrderBy))
                {
                    SortField sortField = new SortField("price", SortField.FLOAT, priceOrderBy.EndsWith("asc", StringComparison.CurrentCultureIgnoreCase));
                    sort.SetSort(sortField);
                }

                TopDocs docs = searcher.Search(query, numPriceFilter, 10000, sort);
                //TopDocs docs = searcher.Search(query, null, 10000);

                totalCount = docs.TotalHits;
                //PrintScores(docs, startIndex, endIndex, searcher);
                for (int i = startIndex; i < endIndex && i < totalCount; i++)
                {
                    Document doc = searcher.Doc(docs.ScoreDocs[i].Doc);
                    ciList.Add(DocumentToCommodityInfo(doc));
                }

                return(ciList);
            }
            finally
            {
                if (searcher != null)
                {
                    searcher.Dispose();
                }
            }
        }
Exemple #48
0
        private string GetSortField(SortField sortField)
        {
            string val = string.Empty;

            switch (sortField)
            {
                case SortField.StartTime:
                    val = "start_time";
                    break;

                case SortField.Type:
                    val = "type";
                    break;

                case SortField.QueueAccountId:
                    val = "queue_account_id";
                    break;

                case SortField.CallerIdNumber:
                    val = "caller_id_number";
                    break;

                case SortField.WaitTime:
                    val = "wait_time";
                    break;

                case SortField.TalkTime:
                    val = "talk_time";
                    break;

                case SortField.MemberAccountId:
                    val = "member_account_id";
                    break;

                case SortField.EnterPosition:
                    val = "enter_position";
                    break;

                case SortField.ExitPosition:
                    val = "exit_position";
                    break;

                case SortField.AbandonPosition:
                    val = "abandon_position";
                    break;

                default:
                    throw new NotImplementedException("No handler for the value " + sortField.ToString() + " has been implemented.");
            }

            return val;
        }
Exemple #49
0
        /// <summary>
        /// Search for listings by keyword.
        /// </summary>
        /// <param name="searchTerms">Specify keywords to search on, separated by spaces or semicolons. You can also use the operators AND and NOT to control keyword matching.</param>
        /// <param name="sortOn">Specify the field to sort on</param>
        /// <param name="sortOrder">Specify the direction to sort on </param>
        /// <param name="minPrice">Minimum for restricting price ranges. Values are in US dollars and may include cents.</param>
        /// <param name="maxPrice">Maximum for restricting price ranges. Values are in US dollars and may include cents.</param>
        /// <param name="searchDescription">If true, listing descriptions will count towards search matches. (This may produce less relevant results.)</param>
        /// <param name="offset">To page through large result sets</param>
        /// <param name="limit">Specify the number of results to return</param>
        /// <param name="detailLevel">control how much information to return</param>
        /// <returns>the async state of the request</returns>
        public IAsyncResult GetListingsByKeyword(IEnumerable<string> searchTerms, SortField sortOn, SortOrder sortOrder, decimal? minPrice, decimal? maxPrice, bool searchDescription, int offset, int limit, DetailLevel detailLevel)
        {
            if (!ServiceHelper.TestCallPrerequisites(this, this.GetListingsByKeywordCompleted, this.etsyContext))
            {
                return null;
            }

            // error if the given min price is more than the given max price
            if (minPrice.HasValue && maxPrice.HasValue && (minPrice.Value > maxPrice.Value))
            {
                var errorResult = new ResultEventArgs<Listings>(null, new ResultStatus("Invalid price range", null));
                ServiceHelper.TestSendEvent(this.GetListingsByKeywordCompleted, this, errorResult);
                return null;
            }

            UriBuilder uriBuilder = UriBuilder.Start(this.etsyContext, "listings/keywords/")
                .Append(searchTerms)
                .Sort(sortOn, sortOrder)
                .OptionalParam("min_price", minPrice)
                .OptionalParam("max_price", maxPrice)
                .Param("search_description", searchDescription)
                .OffsetLimit(offset, limit)
                .DetailLevel(detailLevel);

            return ServiceHelper.GenerateRequest(this, uriBuilder.Result(), this.GetListingsByKeywordCompleted);
        }
Exemple #50
0
 /// <summary>
 /// Initializes a new instance of the <see cref="T:Switchvox.CallQueueLogs.Search"/> class to be executed against a single call queue
 /// </summary>
 /// <param name="startDate">The minimum date to search from.</param>
 /// <param name="endDate">The maximum date to search to.</param>
 /// <param name="queueAccountId">The Call Queue Account ID to retrieve data for.</param>
 /// <param name="callTypes">A combination of flags indicating the type of calls to include in the search results.</param>
 /// <param name="ignoreWeekends">Whether weekends should be excluded from the search results.</param>
 /// <param name="itemsPerPage">The number of results to return in this request. Additional items can be retrieved by making additional requests and incrementing the pageNumber parameter</param>
 /// <param name="pageNumber">The page of results to return in this request. Used in conjunction with the itemsPerPage parameter.</param>
 /// <param name="sortOrder">How the search results will be sorted.</param>
 /// <param name="sortField">The field of the search results to sort on</param>
 public Search(DateTime startDate, DateTime endDate, string queueAccountId, CallTypes callTypes, bool ignoreWeekends = false, int itemsPerPage = 50, int pageNumber = 1, SortOrder sortOrder = SortOrder.Asc, SortField sortField = SortField.StartTime)
     : this(startDate, endDate, new[] {  queueAccountId }, callTypes, ignoreWeekends, itemsPerPage, pageNumber, sortOrder, sortField)
 {
 }
Exemple #51
0
 /// <summary>Adds a <see cref="SortField"/> to the bindings.</summary>
 /// <remarks>
 /// Adds a <see cref="SortField"/> to the bindings.
 /// <para/>
 /// This can be used to reference a DocValuesField, a field from
 /// FieldCache, the document's score, etc.
 /// </remarks>
 public void Add(SortField sortField)
 {
     map[sortField.Field] = sortField;
 }
Exemple #52
0
 public IList<WebChannelGroup> GetRadioGroups(SortField? sort = SortField.User, SortOrder? order = SortOrder.Asc)
 {
     return RadioChannelGroup.ListAll().Select(chg => chg.ToWebChannelGroup()).SortGroupList(sort, order).ToList();
 }
Exemple #53
0
        /// <summary>
        /// Get all the listings in a shop.
        /// </summary>
        /// <param name="userId">the user id</param>
        /// <param name="sortOn">field to sort on</param>
        /// <param name="sortOrder">sort ascending or descending</param>
        /// <param name="sectionId">shop section to show</param>
        /// <param name="offset">the search results offset</param>
        /// <param name="limit">the search limit</param>
        /// <param name="detailLevel">the level of detail</param>
        /// <returns>the async state</returns>
        public IAsyncResult GetShopListings(int userId, SortField sortOn, SortOrder sortOrder, int? sectionId, int offset, int limit, DetailLevel detailLevel)
        {
            if (!ServiceHelper.TestCallPrerequisites(this, this.GetShopListingsCompleted, this.etsyContext))
            {
                return null;
            }

            UriBuilder uriBuilder = UriBuilder.Start(this.etsyContext, "shops", userId)
                .Append("/listings")
                .Sort(sortOn, sortOrder)
                .OptionalParam("section_id", sectionId)
                .OffsetLimit(offset, limit)
                .DetailLevel(detailLevel);

            return ServiceHelper.GenerateRequest(this, uriBuilder.Result(), this.GetShopListingsCompleted);
        }
Exemple #54
0
 public IList<WebChannelDetailed> GetRadioChannelsDetailedByRange(int groupId, int start, int end, SortField? sort = SortField.User, SortOrder? order = SortOrder.Asc)
 {
     return _tvBusiness.GetRadioGuideChannelsForGroup(groupId).Select(ch => ch.ToWebChannelDetailed()).SortChannelList(sort, order).TakeRange(start, end).ToList();
 }
Exemple #55
0
 protected static extern void Sort(IntPtr pItem, SortField eField, SortOrder eOrder, [MarshalAs(UnmanagedType.U1)]bool bRecurse);
Exemple #56
0
 protected bool IsSortByPoint(UserPointType type)
 {
     return(SortField.ToString() == type.ToString());
 }
Exemple #57
0
 /// <summary>
 /// Creates one of these objects. </summary>
 /// <param name="totalHits">  Total number of hits for the query. </param>
 /// <param name="scoreDocs">  The top hits for the query. </param>
 /// <param name="fields">     The sort criteria used to find the top hits. </param>
 /// <param name="maxScore">   The maximum score encountered. </param>
 public TopFieldDocs(int totalHits, ScoreDoc[] scoreDocs, SortField[] fields, float maxScore)
     : base(totalHits, scoreDocs, maxScore)
 {
     this.Fields = fields;
 }
Exemple #58
0
 public IList<WebChannelGroup> GetRadioGroupsByRange(int start, int end, SortField? sort = SortField.User, SortOrder? order = SortOrder.Asc)
 {
     return RadioChannelGroup.ListAll().Select(chg => chg.ToWebChannelGroup()).SortGroupList(sort, order).TakeRange(start, end).ToList();
 }
Exemple #59
0
        /// <summary>
        /// Get all the listings in a shop.
        /// </summary>
        /// <param name="userName">the user name</param>
        /// <param name="sortOn">field to sort on</param>
        /// <param name="sortOrder">sort ascending or descending</param>
        /// <param name="sectionId">shop section to show</param>
        /// <param name="offset">the search results offset</param>
        /// <param name="limit">the search limit</param>
        /// <param name="detailLevel">the level of detail</param>
        /// <returns>the async state</returns>
        public IAsyncResult GetShopListings(string userName, SortField sortOn, SortOrder sortOrder, int? sectionId, int offset, int limit, DetailLevel detailLevel)
        {
            if (!RequestHelper.TestCallPrerequisites(this, this.GetShopListingsCompleted, this.etsyContext))
            {
                return null;
            }

            EtsyUriBuilder etsyUriBuilder = EtsyUriBuilder.Start(this.etsyContext, "shops", userName)
                .Append("/listings")
                .Sort(sortOn, sortOrder)
                .OptionalParam("section_id", sectionId)
                .OffsetLimit(offset, limit)
                .DetailLevel(detailLevel);

            return this.dataRetriever.StartRetrieve(etsyUriBuilder.Result(), this.GetShopListingsCompleted);
        }
Exemple #60
0
 private void AssertSortFieldEquals(SortField sortField, string expectedFieldName, OrderingDirection expectedDirection, int expectedType)
 {
     Assert.That(sortField.Field, Is.EqualTo(expectedFieldName));
     Assert.That(sortField.Type, Is.EqualTo(expectedType), "SortField type for field " + expectedFieldName);
     Assert.That(sortField.Reverse, Is.EqualTo(expectedDirection == OrderingDirection.Desc), "Reverse");
 }