C# Query.ToString方法代码示例

 public List<Result> Query(Query query)
 {
     List<Result> results = new List<Result>();
     string tweetMessage = query.ToString().Remove(0, 2);
     results.Add(new Result()
     {
         
         Title = "Tweet: " + tweetMessage,
         IcoPath = "Image\\twitter.png",
         Action = context =>
         {
             postTweet(tweetMessage);
             return true;
         }
     });
     return results;
 }

        /// <summary>
        /// 拼装CacheKey
        /// </summary>
        /// <param name="customPrefix"></param>
        /// <param name="query"></param>
        /// <returns></returns>
        public static string ComputeCacheKey(string customPrefix, Query query)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append(customPrefix);
            if (query != null)
            {
                sb.Append(FilterParams(query.ToString()));

                if (query.Params != null)
                {
                    foreach (QueryParam obj in query.Params)
                    {
                        sb.Append(obj.ToString());
                    }
                }
            }
            return sb.ToString();
        }

 /// <summary>
 /// Handles the Click event of the btnSave control.
 /// </summary>
 /// <param name="sender">The source of the event.</param>
 /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
 protected void btnSave_Click(object sender, EventArgs e)
 {
     try {
     Category category;
     int parentId = 0;
     int categoryId = 0;
     int.TryParse(lblCategoryId.Text, out categoryId);
     if(categoryId > 0) {
       category = new Category(categoryId);
     }
     else {
       category = new Category();
       category.CategoryGuid = Guid.NewGuid();
     }
     category.Name = txtName.Text.Trim();
     int.TryParse(ddlParentCategory.SelectedValue, out parentId);
     //if((category.CategoryId == 0 || category.ParentId != parentId) && parentId != category.CategoryId) {//add it to the end of the new parent category
       object sortOrder = new Query(Category.Schema).WHERE(Category.Columns.ParentId, Comparison.Equals, parentId).GetMax(Category.Columns.SortOrder);
       category.SortOrder = string.IsNullOrEmpty(sortOrder.ToString()) ? 1 : (int)sortOrder + 1;
     //}
     category.ParentId = parentId;
     category.ImageFile = txtImageFile.Text.Trim();
     category.Description = txtDescription.Text.Trim();
     category.Save(WebUtility.GetUserName());
     RefreshCache(categoryId);
     Reset();
     GetCategoryDataSet();
     LoadTreeView(ds);
     LoadChildren(category.ParentId);
     LoadParentCategoryDropDown(ds);
     Master.MessageCenter.DisplaySuccessMessage(LocalizationUtility.GetText("lblProductCategorySaved"));
       }
       catch(Exception ex) {
     Logger.Error(typeof(categoryedit).Name + ".btnSave_Click", ex);
     Master.MessageCenter.DisplayCriticalMessage(ex.Message);
       }
 }

 /// <summary>
 /// Handles the Click event of the btnSave control.
 /// </summary>
 /// <param name="sender">The source of the event.</param>
 /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
 protected void btnSave_Click(object sender, EventArgs e)
 {
     try {
     Content.Page page;
     int parentId = 0;
     int pageId = 0;
     int.TryParse(lblPageId.Text, out pageId);
     if(pageId > 0) {
       page = new Content.Page(pageId);
     }
     else {
       page = new Content.Page();
       page.PageGuid = Guid.NewGuid();
     }
     int.TryParse(ddlParentPage.SelectedValue, out parentId);
     //if(parentId != page.PageId) {//add it to the end of the new parent category
       object sortOrder = new Query(Content.Page.Schema).WHERE(Content.Page.Columns.ParentId, Comparison.Equals, parentId).GetMax(Content.Page.Columns.SortOrder);
       page.SortOrder = string.IsNullOrEmpty(sortOrder.ToString()) ? 1 : (int)sortOrder + 1;
     //}
     page.ParentId = parentId;
     page.Title = txtTitle.Text;
     page.MenuTitle = txtMenuTitle.Text;
     page.Keywords = txtKeywords.Text;
     page.Description = txtDescription.Text;
     int templateId = 1; //default to 3 column
     int.TryParse(ddlPageTemplate.SelectedValue, out templateId);
     page.TemplateId = templateId;
     //page.Content = HttpUtility.HtmlEncode(txtContent.Value);
     page.Save(WebUtility.GetUserName());
     //Remove from cache will make it reload on the next request.
     PageCache.RemovePageByID(pageId);
     PageMenuCache.RefreshMenuPageCollection();
     Reset();
     GetPageDataSet();
     LoadTreeView(ds);
     LoadChildren(page.ParentId);
     LoadParentPageDropDown(ds);
     Master.MessageCenter.DisplaySuccessMessage(LocalizationUtility.GetText("lblPageSaved"));
       }
       catch(Exception ex) {
     Logger.Error(typeof(contentedit).Name + ".btnSave_Click", ex);
     Master.MessageCenter.DisplayCriticalMessage(ex.Message);
       }
 }

 /// <summary>
 /// 查询条件(带复杂关系)
 /// </summary>
 /// <param name="parameterName">参数名（如果是多表请注明字段所属的表名称）</param>
 /// <param name="query">运算符号</param>
 /// <param name="value">值</param>
 /// <param name="orquery">与后一条件的关系</param>
 /// <param name="kuohao">关系括号</param>
 public WhereParameter(string ParameterName, Query AndQuery, object Value, OrAnd OrAndQuery, Kuohao kuohao)
 {
     this.ParameterName = ParameterName;
     this.Value = Value;
     this.AndQuery = (string)AndQuery.ToString();
     this.OrAndQuery = (string)OrAndQuery.ToString();
     this.kuohao = (string)kuohao.ToString();
 }

        public void TestConstantScoreMultiTermQuery()
        {

            numHighlights = 0;

            query = new WildcardQuery(new Term(FIELD_NAME, "ken*"));
            ((WildcardQuery) query).RewriteMethod = MultiTermQuery.CONSTANT_SCORE_FILTER_REWRITE;
            searcher = new IndexSearcher(ramDir, true);
            // can't rewrite ConstantScore if you want to highlight it -
            // it rewrites to ConstantScoreQuery which cannot be highlighted
            // query = unReWrittenQuery.Rewrite(reader);
            Console.WriteLine("Searching for: " + query.ToString(FIELD_NAME));
            hits = searcher.Search(query, null, 1000);

            for (int i = 0; i < hits.TotalHits; i++)
            {
                String text = searcher.Doc(hits.ScoreDocs[i].Doc).Get(HighlighterTest.FIELD_NAME);
                int maxNumFragmentsRequired = 2;
                String fragmentSeparator = "...";
                QueryScorer scorer = null;
                TokenStream tokenStream = null;

                tokenStream = analyzer.TokenStream(FIELD_NAME, new StringReader(text));

                scorer = new QueryScorer(query, FIELD_NAME);

                Highlighter highlighter = new Highlighter(this, scorer);

                highlighter.TextFragmenter = new SimpleFragmenter(20);

                String result = highlighter.GetBestFragments(tokenStream, text, maxNumFragmentsRequired,
                                                             fragmentSeparator);
                Console.WriteLine("\t" + result);
            }
            Assert.IsTrue(numHighlights == 5, "Failed to find correct number of highlights " + numHighlights + " found");

            // try null field

            hits = searcher.Search(query, null, 1000);

            numHighlights = 0;

            for (int i = 0; i < hits.TotalHits; i++)
            {
                String text = searcher.Doc(hits.ScoreDocs[i].Doc).Get(HighlighterTest.FIELD_NAME);
                int maxNumFragmentsRequired = 2;
                String fragmentSeparator = "...";
                QueryScorer scorer = null;
                TokenStream tokenStream = null;

                tokenStream = analyzer.TokenStream(HighlighterTest.FIELD_NAME, new StringReader(text));

                scorer = new QueryScorer(query, null);

                Highlighter highlighter = new Highlighter(this, scorer);

                highlighter.TextFragmenter = new SimpleFragmenter(20);

                String result = highlighter.GetBestFragments(tokenStream, text, maxNumFragmentsRequired,
                                                             fragmentSeparator);
                Console.WriteLine("\t" + result);
            }
            Assert.IsTrue(numHighlights == 5, "Failed to find correct number of highlights " + numHighlights + " found");

            // try default field

            hits = searcher.Search(query, null, 1000);

            numHighlights = 0;

            for (int i = 0; i < hits.TotalHits; i++)
            {
                String text = searcher.Doc(hits.ScoreDocs[i].Doc).Get(HighlighterTest.FIELD_NAME);
                int maxNumFragmentsRequired = 2;
                String fragmentSeparator = "...";
                QueryScorer scorer = null;
                TokenStream tokenStream = null;

                tokenStream = analyzer.TokenStream(HighlighterTest.FIELD_NAME, new StringReader(text));

                scorer = new QueryScorer(query, "random_field", HighlighterTest.FIELD_NAME);

                Highlighter highlighter = new Highlighter(this, scorer);

                highlighter.TextFragmenter = new SimpleFragmenter(20);

                String result = highlighter.GetBestFragments(tokenStream, text, maxNumFragmentsRequired,
                                                             fragmentSeparator);
                Console.WriteLine("\t" + result);
            }
            Assert.IsTrue(numHighlights == 5, "Failed to find correct number of highlights " + numHighlights + " found");
        }

 public void DoSearching(Query unReWrittenQuery)
 {
     searcher = new IndexSearcher(ramDir, true);
     // for any multi-term queries to work (prefix, wildcard, range,fuzzy etc)
     // you must use a rewritten query!
     query = unReWrittenQuery.Rewrite(reader);
     Console.WriteLine("Searching for: " + query.ToString(FIELD_NAME));
     hits = searcher.Search(query, null, 1000);
 }

        public void TestMultiSearcher()
        {
            // setup index 1
            RAMDirectory ramDir1 = new RAMDirectory();
            IndexWriter writer1 = new IndexWriter(ramDir1, new StandardAnalyzer(TEST_VERSION), true,
                                                  IndexWriter.MaxFieldLength.UNLIMITED);
            Document d = new Document();
            Field f = new Field(FIELD_NAME, "multiOne", Field.Store.YES, Field.Index.ANALYZED);
            d.Add(f);
            writer1.AddDocument(d);
            writer1.Optimize();
            writer1.Close();
            IndexReader reader1 = IndexReader.Open(ramDir1, true);

            // setup index 2
            RAMDirectory ramDir2 = new RAMDirectory();
            IndexWriter writer2 = new IndexWriter(ramDir2, new StandardAnalyzer(TEST_VERSION), true,
                                                  IndexWriter.MaxFieldLength.UNLIMITED);
            d = new Document();
            f = new Field(FIELD_NAME, "multiTwo", Field.Store.YES, Field.Index.ANALYZED);
            d.Add(f);
            writer2.AddDocument(d);
            writer2.Optimize();
            writer2.Close();
            IndexReader reader2 = IndexReader.Open(ramDir2, true);

            var searchers = new IndexSearcher[2];
            searchers[0] = new IndexSearcher(ramDir1, true);
            searchers[1] = new IndexSearcher(ramDir2, true);
            MultiSearcher multiSearcher = new MultiSearcher(searchers);
            QueryParser parser = new QueryParser(TEST_VERSION, FIELD_NAME, new StandardAnalyzer(TEST_VERSION));
            parser.MultiTermRewriteMethod = MultiTermQuery.SCORING_BOOLEAN_QUERY_REWRITE;
            query = parser.Parse("multi*");
            Console.WriteLine("Searching for: " + query.ToString(FIELD_NAME));
            // at this point the multisearcher calls combine(query[])
            hits = multiSearcher.Search(query, null, 1000);

            // query = QueryParser.Parse("multi*", FIELD_NAME, new StandardAnalyzer(TEST_VERSION));
            Query[] expandedQueries = new Query[2];
            expandedQueries[0] = query.Rewrite(reader1);
            expandedQueries[1] = query.Rewrite(reader2);
            query = query.Combine(expandedQueries);

            // create an instance of the highlighter with the tags used to surround
            // highlighted text
            Highlighter highlighter = new Highlighter(this, new QueryTermScorer(query));

            for (int i = 0; i < hits.TotalHits; i++)
            {
                String text = multiSearcher.Doc(hits.ScoreDocs[i].Doc).Get(FIELD_NAME);
                TokenStream tokenStream = analyzer.TokenStream(FIELD_NAME, new StringReader(text));
                String highlightedText = highlighter.GetBestFragment(tokenStream, text);
                Console.WriteLine(highlightedText);
            }
            Assert.IsTrue(numHighlights == 2, "Failed to find correct number of highlights " + numHighlights + " found");

        }

        public override string ToString()
        {
            Query cookie = new Query();
              cookie.Prefix = "";
              cookie.SubPrefix = ";";

              cookie.Table.Add(name, value);

              if (path != null) {
            cookie.Table.Add("Path", path);
              }

              if (domain != null) {
            cookie.Table.Add("Domain", domain);
              }

              if (expires != DateTime.MaxValue) {
            cookie.Table.Add("Expires", expires.ToString());
              }

              if (isSecure) {
            cookie.Table.Add("Secure", "");
              }

              if (isHttpOnly) {
            cookie.Table.Add("HttpOnly", "");
              }

              return cookie.ToString();
        }

        /// <summary>
        /// Used to get the query of a view.
        /// </summary>
        /// <param name="query">Specify the type of Query.</param>
        /// <param name="isLookupId">Explicitly specify whether the field referenced in the logical test query condition is a look up field.</param>
        /// <returns>A constructed query root element.</returns>
        protected CamlQueryRoot GetCamlQueryRoot(Query query, bool isLookupId)
        {
            CamlQueryRoot camlQueryRoot = null;
            switch (query)
            {
                case Query.AvailableQueryInfo:
                    camlQueryRoot = this.GetCamlQueryRootForWhere(isLookupId);
                    break;

                case Query.EmptyQueryInfo:
                    camlQueryRoot = new CamlQueryRoot();
                    break;

                case Query.IsCollapse:
                    camlQueryRoot = this.GetCamlQueryRootForGroupBy(true);
                    break;

                case Query.IsNotCollapse:
                    camlQueryRoot = this.GetCamlQueryRootForGroupBy(false);
                    break;

                default:
                    Site.Debug.Fail("Not supported Query type {0}", query.ToString());
                    break;
            }

            return camlQueryRoot;
        }

        public void Load(Query q)
        {
            string url = "http://www.google.com/finance?&gl=us&hl=en&output=json&start=0&num=10000&noIL=1&restype=company&q=" + q.ToString();
            System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
            jss.MaxJsonLength = 80000000;
            string json = FetchFile(url);

            RawGoogle g = jss.Deserialize<RawGoogle>(json.Replace("\n", "").Replace("\\", ""));
            foreach (System.Reflection.PropertyInfo p in g.GetType().GetProperties())
            {
                this.GetType().GetProperty(p.Name).SetValue(this, p.GetValue(g, null), null);
            }
        }