private void LoadOrders(Delivery delivery) { if (delivery.Details.Count == 0) { return; } listOrder = new List <SearchOrder>(); foreach (var detail in delivery.Details) { var searchOrder = new SearchOrder(); searchOrder.DeliveryTime = detail.Time; searchOrder.Status = detail.Order.Status; searchOrder.CustomerName = detail.Order.CustomerName; searchOrder.OrderNo = detail.Order.OrderNo; searchOrder.Id = detail.Order.Id; searchOrder.DeliveryInternal = detail.Order.DeliveryInternal; listOrder.Add(searchOrder); } dataGridView.DataSource = null; dataGridView.DataSource = listOrder; dataGridView.Refresh(); }
public ActionResult NewTweetsSince(long lastTweetId, string search, SearchOrder? order) { SearchOrder searchOrder = order.GetValueOrDefault(SearchOrder.Latest); IPagedList<TweetReport> tweets = TweetRepository.Search(App, 1, 20, Tweeter, search, searchOrder != SearchOrder.Latest, DefaultLanguage, searchOrder, lastTweetId); TweetViewList tweetList = new TweetViewList("", tweets.TotalItems, tweets.PageNumber, tweets.ItemsPerPage); tweetList.SearchTerm = String.IsNullOrWhiteSpace(search) ? null : search; foreach (TweetReport tweet in tweets) { TweetView tweetView = new TweetView() { Id = tweet.Id, TwitterId = tweet.TwitterId, Username = tweet.Username, ProfileImageUrl = tweet.ProfileImageUrl, Message = tweet.Message, DatePosted = tweet.DatePosted, DeviceName = tweet.DeviceName, DeviceUrl = tweet.DeviceUrl, TotalVotes = (int)tweet.TotalVotes, HasBeenVotedByUser = tweet.HasBeenVotedByUser }; tweetList.Tweets.Add(tweetView); } return PartialView("Tweet", tweetList); }
protected void Page_Load(object sender, EventArgs e) { SearchOrder su = new SearchOrder(CurrentAdmin, CurrentLanguage.Code); model = su.Model; callback = RequestTool.RequestString("callback"); }
public static YoutubeSearch OrderBy(this YoutubeSearch search, SearchOrder order) { var settings = search.Settings.Clone(); settings.Order = order; return(Search(settings)); }
private void SelectOrder(object sender, EventArgs e) { if (dataGridView.SelectedRows.Count > 0) { try { int index = dataGridView.SelectedRows[0].Index; SelectedOrder = dataGridView.SelectedRows[0].DataBoundItem as SearchOrder; ListSelectedOrder.Add(SelectedOrder); var deliveryForm = this.ParentForm as DeliveryForm; if (deliveryForm != null) { deliveryForm.UpdateGrid(SelectedOrder); } var list = dataGridView.DataSource as List <SearchOrder>; list.RemoveAt(index); dataGridView.DataSource = null; dataGridView.DataSource = list; dataGridView.Refresh(); } catch (Exception ex) { logger.EnterMethod("Select Order"); logger.LogException(ex); } } }
// In C# because SQL's SUM returns NULL on an empty list, so we need the ?? operator, which doesn't exist in F#. At least not one that LINQ to Entities can parse public static IOrderedQueryable <RevisionEntity> Search( this IQueryable <RevisionEntity> revisions, string searchTerm, string plain, string wildcard, SearchOrder searchOrder ) { const NpgsqlTsRankingNormalization normalization = NpgsqlTsRankingNormalization.DivideBy1PlusLogLength | NpgsqlTsRankingNormalization.DivideByMeanHarmonicDistanceBetweenExtents; IQueryable <RevisionEntity> where (IQueryable <RevisionEntity> query) => string.IsNullOrWhiteSpace(searchTerm) ? query : query.Where(x => x.Tsv.Matches(Functions.WebSearchToTsQuery(plain).And(Functions.ToTsQuery(wildcard)))); IOrderedQueryable <RevisionEntity> order(IQueryable <RevisionEntity> query) => searchOrder == SearchOrder.Popularity ? query.OrderByDescending(x => x.Example.Users) : query.OrderByDescending(x => x.Tsv.RankCoverDensity(Functions.WebSearchToTsQuery(plain).And(Functions.ToTsQuery(wildcard)), normalization)); return(revisions .Apply(where) .Apply(order)); }
/// <summary> /// 处理搜索订单的条件 /// </summary> public void OrderSearch() { SearchOrder su = new SearchOrder(CurrentAdmin, CurrentLanguage.Code); string url = su.URL; Response.Write("{\"msg\":\"OK\",\"url\":\"" + url + "\"}"); }
public SearchOrder GetOrderByUserId(long id) { SearchOrder searchorder = new SearchOrder(); searchProduct searchproduct = new searchProduct(); Order order = new Order(); Product product = new Product(); List <OrderDetail> listorderdetail = new List <OrderDetail>(); List <Order> listorder = new List <Order>(); List <searchProduct> listsearchproduct = new List <searchProduct>(); int i = 1; listorder = db.Orders.Where(x => x.UserId == id).ToList(); listorder.ForEach(c => { List <Product> listproduct = new List <Product>(); var listorderdetails = db.OrderDetails.Where(a => a.OrderId == c.Id).ToList(); listorderdetails.ForEach(z => { product = db.Products.Where(d => d.Id == z.ProductId).FirstOrDefault(); listproduct.Add(product); }); searchproduct.order = c; searchproduct.listorderdetail = listorderdetails; searchproduct.listproduct = listproduct; listsearchproduct.Add(searchproduct); }); return(searchorder); }
public PagedResponse <OrderGetDto> Execute(SearchOrder search) { var query = _context.Orders .Include(x => x.User) .Include(x => x.OrderLines).AsQueryable(); if (search.UserId.HasValue) { query = query.Where(order => order.UserId == search.UserId); } if (search.MinOrderLines.HasValue) { query = query.Where(order => order.OrderLines.Count() >= search.MinOrderLines.Value); } if (search.Status.HasValue) { query = query.Where(o => o.OrderStatus == search.Status); } if (search.MinPrice.HasValue) { query = query.Where(o => o.OrderLines.Sum(x => x.Quantity * x.Price) >= search.MinPrice.Value); } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <OrderGetDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = _mapper.Map <List <OrderGetDto> >(query.Skip(skipCount).Take(search.PerPage).ToList()) }; return(response); }
public List <HelpRequestModel> Search(SearchOrder order) { List <HelpRequestModel> results = new List <HelpRequestModel>(); string query = @"SELECT [HelpRequest].Id, [HelpRequest].Title, [HelpRequest].Date, [HelpRequest].Address, [HelpRequest].Urgency, [User].Name FROM [HelpRequest] JOIN [User] ON [HelpRequest].HelpSeekerUserId = [User].Id WHERE [HelpRequest].Closed = 0 ORDER BY " + orderString(order); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) using (SqlCommand cmd = new SqlCommand(query, conn)) { conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { results.Add(new HelpRequestModel { Id = reader.GetInt32(0), Title = reader.GetString(1), Date = reader.GetDateTime(2), Address = reader.GetString(3), Urgency = (HelpRequestUrgency)reader.GetInt32(4), HelpSeeker = new UserModel { Name = reader.GetString(5) } }); } } } return(results); }
Order IOrderDA.GetOrderList(SearchOrder order) { DataSet dt = new DataSet(); Order orderDet = new Order(); if (connString.State == ConnectionState.Closed) { connString.Open(); } cmd = new SqlCommand("uspCustomerOrders", connString); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CustomerId", order.CustomerId); cmd.Parameters.AddWithValue("@MobileNo", order.MobileNo); cmd.Parameters.AddWithValue("@OrderId", order.OrderId); cmd.Parameters.AddWithValue("@OrderNumber", order.OrderNumber); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); sda.Dispose(); connString.Close(); orderDet.OrderMasters = ExtensionMethods.ConvertToListOf <OrderMaster>(dt.Tables[0]); orderDet.OrderDetail = ExtensionMethods.ConvertToListOf <OrderDetails>(dt.Tables[1]); return(orderDet); }
public List <HelpRequestModel> Search(GeoCoordinate location, int distance, SearchOrder order) { var results = from helpRequest in Tables.HelpRequest join user in Tables.User on helpRequest.HelpSeeker.Id equals user.Id let getDistance = helpRequest.Location.GetDistanceTo(location) where (getDistance <= distance * 1000 || distance == 0) && helpRequest.Closed == false orderby order == SearchOrder.DATE_ASC ? helpRequest.Date : default(DateTime), order == SearchOrder.DATE_DESC ? helpRequest.Date : default(DateTime)descending, order == SearchOrder.DISTANCE_ASC ? getDistance : 0, order == SearchOrder.DISTANCE_DESC ? getDistance : 0 descending select new HelpRequestModel { Id = helpRequest.Id, Title = helpRequest.Title, Date = helpRequest.Date, Address = helpRequest.Address, Urgency = helpRequest.Urgency, Distance = getDistance, HelpSeeker = new UserModel { Name = user.Name } }; return(results.ToList()); }
public List <HelpRequestModel> Search(string keywords, SearchOrder order) { var results = from helpRequest in Tables.HelpRequest join user in Tables.User on helpRequest.HelpSeeker.Id equals user.Id let matches = Functions.KeywordMatches(helpRequest.Title + helpRequest.Content, keywords, ' ') where matches > 0 && helpRequest.Closed == false orderby order == SearchOrder.DATE_ASC ? helpRequest.Date : default(DateTime), order == SearchOrder.DATE_DESC ? helpRequest.Date : default(DateTime)descending, order == SearchOrder.RELEVANCE_ASC ? matches : 0, order == SearchOrder.RELEVANCE_DESC ? matches : 0 descending select new HelpRequestModel { Id = helpRequest.Id, Title = helpRequest.Title, Date = helpRequest.Date, Address = helpRequest.Address, Urgency = helpRequest.Urgency, HelpSeeker = new UserModel { Name = user.Name } }; return(results.ToList()); }
void HistoryPaneItem_Click(object sender, SmartItemClickEventArgs e) { Xceed.SmartUI.SmartItem item = sender as Xceed.SmartUI.SmartItem; SearchHistoryInfo his = item.Tag as SearchHistoryInfo; m_sm.FirstResult = 0; m_sm.LoadData(SearchExpression.Parse(his.Expression), SearchOrder.Parse(his.Order)); }
public async Task <PagedList <Order> > ListAsync(SearchOrder search, Pagination pagination) { var queryable = _context.Orders.AsQueryable(); if (!string.IsNullOrEmpty(search.UserId)) { queryable = queryable.Where(x => x.UserId == search.UserId); } if (!string.IsNullOrEmpty(search.ShipperId) && search.ShipperId != "isNullOrEmpty") { queryable = queryable.Where(x => x.ShipperId == search.ShipperId); } if (search.ShipperId == "isNullOrEmpty") { queryable = queryable.Where(x => string.IsNullOrEmpty(x.ShipperId)); } if (!string.IsNullOrEmpty(search.Email)) { queryable = queryable.Where(x => x.Email.Contains(search.Email)); } if (search.Id != 0) { queryable = queryable.Where(x => x.Id == search.Id); } if (!string.IsNullOrEmpty(search.Status)) { queryable = queryable.Where(x => x.Status == search.Status); } // selector if (search.SelectStatus != null) { queryable = queryable.Where(x => search.SelectStatus.Contains(x.Status)); } // sorter if (pagination.SortAsc == "CreatedAt") { queryable = queryable.OrderBy(x => x.CreatedAt); } if (pagination.SortDesc == "CreatedAt") { queryable = queryable.OrderByDescending(x => x.CreatedAt); } if (pagination.SortAsc == "Status") { queryable = queryable.OrderBy(x => x.Status); } if (pagination.SortDesc == "Status") { queryable = queryable.OrderByDescending(x => x.Status); } var pagedList = await PagedList <Order> .ToPagedListAsync(queryable, pagination.PageNumber, pagination.PageSize); return(pagedList); }
public static Order Convert(this SearchOrder entity) { return(new Order { ClientName = entity.ClientName, Date = entity.Date, Id = entity.Id, Products = entity.ProductList.Select(p => p.Convert()).ToList() }); }
public SalesPropertiesM(SalesPropertiesM prop) { MinPrice = prop.MinPrice; MaxPrice = prop.MaxPrice; InstanceMultiply = prop.InstanceMultiply; RecurrencePerInstance = prop.RecurrencePerInstance; IsBroadSale = prop.IsBroadSale; DateFrom = prop.DateFrom; DateTo = prop.DateTo; FavourOrder = prop.FavourOrder; }
Order IOrder.GetOrderList(SearchOrder order) { try { return(iorder.GetOrderList(order)); } catch (Exception ex) { return(null); } }
public bool LoadLayout(AMS.Profile.IProfile profile) { int r = profile.GetValue("SearchManager." + m_sm.Name, "MaxResult", -1); if (r != -1) { m_sm.MaxResult = r; } string history = profile.GetValue("SearchManager." + m_sm.Name, "History", string.Empty); if (!string.IsNullOrEmpty(history)) { string[] ss = history.Split(new string[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries); for (int i = ss.Length - 1; i >= 0; --i) { string s = ss[i]; if (string.IsNullOrEmpty(s)) { continue; } string[] sss = s.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); if (sss.Length == 0) { continue; } ISearchExpression se = null; try { se = SearchExpression.Parse(sss[0]); } catch (Exception) { } if (se == null) { continue; } IList <ISearchOrder> so = null; if (sss.Length > 1) { so = SearchOrder.Parse(sss[1]); } SearchHistoryInfo his = m_sm.SetHistory(se, so); his.IsCurrentSession = false; } } bool ret = this.searchControlContainer1.LoadLayout(profile); return(ret); }
public ActionResult OrdersGridPartial(int employeeID, DateTime dateFrom, DateTime dateTo) { SearchOrder search = new SearchOrder() { EmployeeID = employeeID, DateFrom = dateFrom, DateTo = dateTo }; ViewData["SearchOrder"] = search; return(PartialView("_OrdersGridPartial", Order.SearchOrders(search))); }
public List <LevelRowDTO> SearchLevelsByUserId(Int64 userId, SearchOrder order, SearchDirection dir, Int16?page) { IQueryable <Level> levels = this.dbContext.Levels .Where(l => l.AuthorId == userId && !l.IsDeleted && l.IsPublished && l.Versions.Count > 0); FilterAndSortLevels(ref levels, order, dir, page); List <LevelRowDTO> levelRows = levels.Select(Level.ToLevelRowDTO).ToList(); FillLevelVersionData(levelRows); return(levelRows); }
/// <summary>Constructs the <see cref="FilePathEnumerable"/>.</summary> /// /// <param name="path"> /// The relative or absolute path to the directory to search. This string is not case-sensitive. /// </param> /// <param name="searchPattern"> /// The search string to match against file-system entries in path. This parameter can contain a /// combination of valid literal path and wildcard (* and ?) characters (see Remarks), but doesn't /// support regular expressions. /// </param> /// <param name="files">True if files are returned.</param> /// <param name="subdirs">True if directories are returned.</param> /// <param name="searchOrder">How subdirectories should be searched, if at all.</param> /// <param name="ignoreCase">True if pattern casing should be ignored.</param> public FilePathEnumerable(string path, string searchPattern, bool files, bool subdirs, SearchOrder searchOrder, bool ignoreCase) { if (!Enum.IsDefined(typeof(SearchOrder), searchOrder)) { throw new ArgumentException(nameof(searchOrder)); } if (!files && !subdirs) { throw new ArgumentException($"{nameof(files)} or {nameof(subdirs)} must be true!"); } search = new SearchInfo(path, searchPattern, files, subdirs, searchOrder, ignoreCase); }
/// <summary> /// 根据查询条件查询数据 /// </summary> /// <param name="searchExpression"></param> /// <param name="searchOrders"></param> /// <returns></returns> public override System.Collections.IEnumerable GetData(ISearchExpression searchExpression, IList <ISearchOrder> searchOrders) { string exp = SearchExpression.ToString(searchExpression); string order = SearchOrder.ToString(searchOrders); var list = m_client.GetData(exp, order, this.FirstResult, this.MaxResult); var ret = new List <T>(); foreach (var i in list) { ret.Add(Feng.Net.Utils.TypeHelper.ConvertTypeFromWSToReal <T>(i)); } return(ret); }
public static SpatialQueryFilter CreateSpatialFilter( [NotNull] ArcGIS.Core.Geometry.Geometry filterGeometry, SpatialRelationship spatialRelationship = SpatialRelationship.Intersects, SearchOrder searchOrder = SearchOrder.Spatial) { Assert.ArgumentNotNull(filterGeometry, nameof(filterGeometry)); return(new SpatialQueryFilter { FilterGeometry = filterGeometry, SpatialRelationship = spatialRelationship, SearchOrder = searchOrder }); }
public SalesPropertiesM(double minPrice, double?maxPrice, int maxInstances, int maxRecurrences, bool IsBroad, DateTime from, DateTime?to) { MinPrice = minPrice; MaxPrice = maxPrice; InstanceMultiply = maxInstances; RecurrencePerInstance = maxRecurrences; IsBroadSale = IsBroad; DateFrom = from; DateTo = to; //TODO - add to DB as property FavourOrder = SearchOrder.highToLow; }
static void ChangeSettings(string path, string pattern, SearchOption option, SearchOrder order) { Path = path; Pattern = pattern; Option = option; Order = order; Console.ForegroundColor = ConsoleColor.DarkGray; Console.WriteLine($"Path : {Path}"); Console.WriteLine($"Pattern : {Pattern}"); Console.WriteLine($"Option : {Option}"); Console.WriteLine($"Order : {Order}"); Console.WriteLine(); Console.ResetColor(); }
public void UpdateGrid(SearchOrder order) { if (order != null) { if (listOrder == null) { listOrder = new List <SearchOrder>(); } listOrder.Add(order); dataGridView.DataSource = null; dataGridView.DataSource = listOrder; dataGridView.Refresh(); } }
internal SearchOrder GetOrder() { SearchOrder order = SearchOrder.Invalid; if (radioButtonColumns.Checked) { order = SearchOrder.Columns; } else if (radioButtonRows.Checked) { order = SearchOrder.Rows; } return(order); }
private string GenerateRequestUrl( string queryString, string from, string until, SearchOrder order = SearchOrder.DESC, int size = 50) { var requestUrl = BaseUrl + $"/search?{queryString}"; requestUrl += $"&from={from}"; requestUrl += $"&until={until}"; requestUrl += $"&order={order.GetDescription()}"; requestUrl += $"&size={size}"; return(requestUrl); }
internal SearchOptions(string query = "", string type = "", SearchEntitlement entitlement = default(SearchEntitlement), long offset = -1, long limit = -1, SearchOrderBy orderBy = default(SearchOrderBy), SearchOrder order = default(SearchOrder)) { m_Query = query; m_Type = type; m_Entitlement = entitlement; m_Offset = offset; m_Limit = limit; m_OrderBy = orderBy; m_Order = order; }
private void OnButtonSearchClick(object o, EventArgs e) { _orderNumberToConfirm = -1; PanelOrderInfo.Visible = false; LabelOrderContent.Visible = false; PanelProductsInOrder.Visible = false; PanelProductsInOrder.Controls.Clear(); if (TextBoxOrderNumber.Text.Length != 0) { SearchOrder?.Invoke(); } else { MessageBox.Show("Введите номер поставки, а затем осуществите поиск", "Отсутствует номер поставки"); } }
private void SelectOrder(object sender, EventArgs e) { if (dataGridView.SelectedRows.Count > 0) { try { int index = dataGridView.SelectedRows[0].Index; SelectedOrder = dataGridView.SelectedRows[0].DataBoundItem as SearchOrder; ListSelectedOrder.Add(SelectedOrder); var deliveryForm = this.ParentForm as DeliveryForm; if (deliveryForm != null) { deliveryForm.UpdateGrid(SelectedOrder); } var list = dataGridView.DataSource as List<SearchOrder>; list.RemoveAt(index); dataGridView.DataSource = null; dataGridView.DataSource = list; dataGridView.Refresh(); } catch (Exception ex) { logger.EnterMethod("Select Order"); logger.LogException(ex); } } }
protected ActionResult Display(string pageTitle, DisplayFormat format, SearchOrder order, bool votedOnly, int? page, string search) { int pageNumber = page.GetValueOrDefault(1); if (format == DisplayFormat.Rss) { pageNumber = 1; } IPagedList<TweetReport> tweets = TweetRepository.Search(App, pageNumber, 20, Tweeter, search, votedOnly, DefaultLanguage, order, null); TweetViewList tweetList = new TweetViewList(pageTitle, tweets.TotalItems, tweets.PageNumber, tweets.ItemsPerPage); tweetList.SearchTerm = String.IsNullOrWhiteSpace(search) ? null : search; foreach (TweetReport tweet in tweets) { TweetView tweetView = new TweetView() { Id = tweet.Id, TwitterId = tweet.TwitterId, Username = tweet.Username, ProfileImageUrl = tweet.ProfileImageUrl, Message = tweet.Message, DatePosted = tweet.DatePosted, DeviceName = tweet.DeviceName, DeviceUrl = tweet.DeviceUrl, TotalVotes = (int)tweet.TotalVotes, HasBeenVotedByUser = tweet.HasBeenVotedByUser }; tweetList.Tweets.Add(tweetView); } if (format == DisplayFormat.Html) { return View(tweetList); } else if (format == DisplayFormat.HtmlSnippet) { return PartialView("Tweet", tweetList); } else if (format == DisplayFormat.Json) { return Json(tweetList, JsonRequestBehavior.AllowGet); } else if (format == DisplayFormat.Rss) { string rssTitle = pageTitle; if (!String.IsNullOrWhiteSpace(search)) { rssTitle += " Containing \"" + search + "\""; } rssTitle += " - " + App.Title; RssResult<TweetView> rssResult = new RssResult<TweetView>(rssTitle, "http://" + App.Url, App.Blurb); rssResult.DataSource = tweetList.Tweets; Uri requestUrl = Request.Url; string baseUrl = "http://" + requestUrl.Host + (requestUrl.Port != 80 ? ":" + requestUrl.Port : ""); rssResult.SetDataSourceFields(t => t.Message, t => baseUrl + Url.Action("Status", new { twitterId = t.TwitterId, message = t.Message.ToFriendlyUrl() }), t => "@" + t.Username + " tweeted \"" + t.Message + "\"", t => "@" + t.Username, t => t.DatePosted); return rssResult; } else { throw new NotSupportedException(format + " is not supported"); } }
public void UpdateGrid(SearchOrder order) { if (order != null) { if (listOrder == null) { listOrder = new List<SearchOrder>(); } listOrder.Add(order); dataGridView.DataSource = null; dataGridView.DataSource = listOrder; dataGridView.Refresh(); } }
private void LoadOrders(Delivery delivery) { if (delivery.Details.Count == 0) return; listOrder = new List<SearchOrder>(); foreach (var detail in delivery.Details) { var searchOrder = new SearchOrder(); searchOrder.DeliveryTime = detail.Time; searchOrder.Status = detail.Order.Status; searchOrder.CustomerName = detail.Order.CustomerName; searchOrder.OrderNo = detail.Order.OrderNo; searchOrder.Id = detail.Order.Id; searchOrder.DeliveryInternal = detail.Order.DeliveryInternal; listOrder.Add(searchOrder); } dataGridView.DataSource = null; dataGridView.DataSource = listOrder; dataGridView.Refresh(); }