示例#1
0
        protected void PrintPage()
        {
            long     t1 = Environment.TickCount;
            DateTime sBegin, sEnd;
            string   newKey, sAuthor;

            Hashtable hnick   = Functions.hashNick;
            Hashtable hrating = Functions.hashRating;

            string chk = checkQuery(hnick, out sBegin, out sEnd, out sAuthor, out newKey);

            if (chk != "")
            {
                Response.Write("<br />" + chk);
                return;
            }

            if (search == null) //第一次搜索,加载搜索模块
            {
                search = new SearchMessage(Server.MapPath("Data") + "\\");
            }

            SearchResult result = search.Search(newKey);


            SqlConnection conn = new SqlConnection(connstr);

            conn.Open();

            if (result.documentID.Length == 0)
            {
                Response.Write(string.Format("<br />" + "找不到和您的查询 \"<strong>{0}</strong>\" 相符的内容或信息。", key));
            }
            else
            {
                StringBuilder content = new StringBuilder();


                if (sBegin != begin || sEnd != end)
                {
                    initMinMaxID(conn, sBegin, sEnd);//第一次搜索时间,加载时间加速模块

                    int           min   = minID[sBegin];
                    int           max   = maxID[sEnd];
                    List <int>    res   = new List <int>();
                    List <double> tfidf = new List <double>();
                    for (int i = 0; i < result.documentID.Length; i++)
                    {
                        if (result.documentID[i] >= min && result.documentID[i] <= max)
                        {
                            res.Add(result.documentID[i]);
                            tfidf.Add(result.tfidf[i]);
                        }
                    }
                    result.documentID = res.ToArray();
                    result.tfidf      = tfidf.ToArray();
                }

                int cnt = 0;

                int pageNum = (result.documentID.Length - 1) / 10 + 1;
                if (pageNum > maxPage)
                {
                    pageNum = maxPage;
                }
                if (page > pageNum)
                {
                    page = pageNum;
                }

                if (rank >= 2)
                {
                    Array.Sort(result.documentID);
                    if (rank == 3)
                    {
                        Array.Reverse(result.documentID);
                    }
                }

                for (int j = (page - 1) * 10; j < result.documentID.Length && cnt < 10; j++)
                {
                    SqlCommand cmd = new SqlCommand("SELECT [Message],[qq],[time],[qun],[groupnum] FROM [data] WHERE [id]=@id", conn);
                    cmd.Parameters.Add("id", SqlDbType.Int).Value = result.documentID[j];
                    SqlDataReader dr = cmd.ExecuteReader();

                    dr.Read();
                    string msg = PreProcessUtility.HTML2Text((string)dr["message"]);
                    msg = search.getSnippet(result.words, msg);
                    string   qq       = ((string)dr["qq"]).Trim();
                    int      qun      = (int)dr["qun"];
                    DateTime time     = (DateTime)dr["time"];
                    int      msgCount = (int)dr["groupnum"];

                    dr.Close();

                    content.Append(string.Format("<tr><td><div class='a'><div class='b'><a href=\"Rating.aspx?qq={0}\" class=\"{4}\">{3}({0})</a></div>{1} <a href=\"Message.aspx?date={6}&qun={7}#m{5}\">查看</a>{8}</div><div class='c'>{2}</div></td></tr>\n", qq, time, msg, hnick[qq], Functions.GetColor((double)hrating[qq]), result.documentID[j], time.ToShortDateString(), qun, (msgCount == 1 ? "" : " " + msgCount + " 条相同消息")));

                    cnt++;
                }

                if (pageNum != 1)
                {
                    content.Append("<tr><th class='sub'>");
                    int pb = Math.Max(1, page - 5);
                    int pe = Math.Min(pageNum, page + 5);

                    if (pb > 1)
                    {
                        content.Append(string.Format(" <a href=\"Search.aspx?q={0}&p={1}{2}\"><strong>...</strong></a> ", key, Math.Max(pb - 5, 1), getRankStr(rank)));
                    }

                    for (int i = pb; i <= pe; i++)
                    {
                        if (i == page)
                        {
                            content.Append(string.Format(" [{0}] ", i));
                        }
                        else
                        {
                            content.Append(string.Format(" <a href=\"Search.aspx?q={0}&p={1}{2}\">{1}</a> ", key, i, getRankStr(rank)));
                        }
                    }

                    if (pe < pageNum)
                    {
                        content.Append(string.Format(" <a href=\"Search.aspx?q={0}&p={1}{2}\"><strong>...</strong></a> ", key, Math.Min(pe + 5, maxPage), getRankStr(rank)));
                    }
                    content.Append("</th></tr>");
                }
                content.Append("</table>");

                string strDate = "";
                if (sBegin != begin || sEnd != end)
                {
                    if (sBegin == begin)
                    {
                        strDate = string.Format("从开始到 <strong>{0}</strong> ", sEnd.ToShortDateString());
                    }
                    else if (sEnd == end)
                    {
                        strDate = string.Format("从 <strong>{0}</strong> 到现在", sBegin.ToShortDateString());
                    }
                    else
                    {
                        if (sBegin == sEnd)
                        {
                            strDate = string.Format("在 <strong>{0}</strong> ", sBegin.ToShortDateString());
                        }
                        else
                        {
                            strDate = string.Format("从 <strong>{0}</strong> 到 <strong>{1}</strong> ", sBegin.ToShortDateString(), sEnd.ToShortDateString());
                        }
                    }
                }
                string strAuthor = "";
                if (sAuthor != "")
                {
                    strAuthor = string.Format("由 <a href=\"Rating.aspx?qq={1}\" class=\"{2}\">{0}({1})</a> ", (string)hnick[sAuthor], sAuthor, Functions.GetColor((double)hrating[sAuthor]));
                }

                string strDescription = strDate + strAuthor;
                if (strDescription != "")
                {
                    strDescription += " 发表的";
                }

                string strSort = "";
                if (rank == 1)
                {
                    strSort = string.Format("<strong>默认排序</strong> | <a href=\"Search.aspx?q={0}&p={1}&r=asc\">时间排序↑</a>", key, page);
                }
                else if (rank == 2)
                {
                    strSort = string.Format("<a href=\"Search.aspx?q={0}&p={1}\">默认排序</a> | <a href=\"Search.aspx?q={0}&p={1}&r=dec\"><strong>时间排序↑</strong></a>", key, page);
                }
                else
                {
                    strSort = string.Format("<a href=\"Search.aspx?q={0}&p={1}\">默认排序</a> | <a href=\"Search.aspx?q={0}&p={1}&r=asc\"><strong>时间排序↓</strong></a>", key, page);
                }

                Response.Write(string.Format("<table class='full'><thead><tr><th style=\"font-weight:normal\">搜索 {3} <strong>{0}</strong>,获得 {1} 条搜索结果 (用时 {2:F3} 秒) | {4}</th></tr></thead>\n",
                                             newKey, result.documentID.Length, (Environment.TickCount - t1) / 1000.0, strDescription, strSort));
                Response.Write(content.ToString());
            }

            SqlCommand cmdRec = new SqlCommand("INSERT INTO [SearchHistory] ([keyword],[IP],[time],[sort],[page]) VALUES (@keyword, @ip, @time, @sort, @page)", conn);

            cmdRec.Parameters.Add("keyword", SqlDbType.Char).Value  = key;
            cmdRec.Parameters.Add("ip", SqlDbType.Char).Value       = Request.ServerVariables["REMOTE_ADDR"];
            cmdRec.Parameters.Add("time", SqlDbType.DateTime).Value = DateTime.Now;
            cmdRec.Parameters.Add("sort", SqlDbType.TinyInt).Value  = rank;
            cmdRec.Parameters.Add("page", SqlDbType.TinyInt).Value  = page;
            cmdRec.ExecuteNonQuery();

            conn.Close();
        }
示例#2
0
        protected void PrintPage()
        {
            SqlConnection conn = new SqlConnection(connstr);

            conn.Open();

            SqlCommand cmd = new SqlCommand("SELECT TOP 11 [Message],[groupNum] FROM [data] WHERE [time]>=@t1 and [time]<@t2 AND [groupNum]>1 ORDER BY [groupNum] DESC", conn);

            cmd.Parameters.Add("t1", SqlDbType.DateTime).Value = dt;
            cmd.Parameters.Add("t2", SqlDbType.DateTime).Value = dt.AddDays(1);

            Response.Write("<table class='full'>\n");
            Response.Write(string.Format("<thead><tr><th colspan='3'>热门消息</th></tr></thead>\n"));
            Response.Write("<tbody><tr><th>排名</th><th>消息</th><th>次数</th></tr>\n");

            SqlDataReader dr  = cmd.ExecuteReader();
            int           cnt = 0;

            while (dr.Read())
            {
                string s = PreProcessUtility.HTML2Text((string)dr["Message"]);

                if (s != "")
                {
                    cnt++;
                    Response.Write(string.Format("<tr><th class='sub'>{0}</th><td>{1}</td><td>{2}</td></tr>\n", cnt, dr["Message"], dr["groupNum"]));
                }
            }

            Response.Write("</tbody></table>");
            dr.Close();

            cmd = new SqlCommand("SELECT [Message] FROM [data] WHERE [time]>=@t1 and [time]<@t2", conn);
            cmd.Parameters.Add("t1", SqlDbType.DateTime).Value = dt;
            cmd.Parameters.Add("t2", SqlDbType.DateTime).Value = dt.AddDays(1);
            dr = cmd.ExecuteReader();

            Dictionary <string, int> picCount = new Dictionary <string, int>();

            while (dr.Read())
            {
                string txt = (string)dr["Message"];

                int p = txt.IndexOf("<IMG");
                while (p != -1)
                {
                    int    e = txt.IndexOf(">", p);
                    string s = txt.Substring(p, e - p + 1);
                    txt = txt.Remove(p, e - p + 1);

                    int    st  = s.IndexOf("\"");
                    int    ed  = s.IndexOf("\"", st + 1);
                    string url = s.Substring(st + 1, ed - st - 1);
                    if (url.Contains("msg"))
                    {
                        if (url == "msg/{3829986E-A56D-B399-818B-F5F378ACFBF1}.gif")
                        {
                            url = "msg/{CC350580-F5C6-7354-D337-29AD641E0C54}.gif";
                        }
                        if (picCount.ContainsKey(url))
                        {
                            picCount[url]++;
                        }
                        else
                        {
                            picCount.Add(url, 1);
                        }
                    }
                    p = txt.IndexOf("<IMG");
                }
            }
            dr.Close();
            conn.Close();

            int[]    cnts  = new int[picCount.Count];
            string[] paths = new string[picCount.Count];
            cnt = 0;
            foreach (var o in picCount)
            {
                cnts[cnt]  = o.Value;
                paths[cnt] = o.Key;
                cnt++;
            }

            Array.Sort(cnts, paths);
            Array.Reverse(cnts);
            Array.Reverse(paths);

            cnt = 0;

            Response.Write("<hr /><table class='full'>\n");
            Response.Write(string.Format("<thead><tr><th colspan='3'>热门图片</th></tr></thead>\n"));
            Response.Write("<tbody><tr><th>排名</th><th>图片</th><th>次数</th></tr>\n");
            for (int i = 0; i < 5 && i < cnts.Length && cnts[i] > 1; i++)
            {
                cnt++;
                Response.Write(string.Format("<tr><th class='sub'>{0}</th><td><img src=\"{1}\" onload=\"javascript:if(480<this.width){{this.width=480}}\"  onerror=\"javascript:this.src='img/e.gif'\" /></td><td>{2}</td></tr>\n", cnt, paths[i], cnts[i]));
            }
            Response.Write("</tbody></table>");
        }