topbook.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text.RegularExpressions;
using System.Text;

public partial class topbook : System.Web.UI.Page
{
    protected string mode = "all",type = "total";
    protected StringBuilder list = new StringBuilder(30000);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["mode"] != null && Request.QueryString["type"] != null)
        {
            mode = Request.QueryString["mode"];
            type = Request.QueryString["type"];
        }
        int tid, i = 1;
        SqlStore sql = new SqlStore();
        DataTable table = sql.Top(mode + "_" + type);
        foreach (DataRow row in table.Rows)
        {//排名　类别　书名　最新章节　作者　更新时间　状态　收藏数　推荐数　点击数
            tid = (int)row["tid"];
            list.Append("<ul>"
                + "<li class=\"l1\">" + i++ + "</li>"
                + "<li class=\"l2\">" + Common.BoardName(Convert.ToInt16(row["boardid"])) + "</li>"
                + "<li class=\"l3\"><a href=\"/novel/" + tid + "/\" title=\"" + row["title"] + "\" target=\"_blank\">" + row["title"] + "</a></li>"
                + "<li class=\"l4\"><a href=\"/chapter/" + tid + "/" + row["cid"] + ".html\" class=\"title\" target=\"_blank\">" + row["ctitle"] + "</a></li>"
                + "<li class=\"l5\">" + row["author"] + "</li>"
                + "<li class=\"l6\">" + Regex.Replace(Convert.ToString(row["updatetime"]), " .+$", "") + "</li>"
                + "<li class=\"l7\">" + (Convert.ToBoolean(row["isfinish"]) ? "完结" : "连载") + "</li>"
                + "<li class=\"l8\">" + row["favor"] + "</li>"
                + "<li class=\"l9\">" + row["commend"] + "</li>"
                + "<li class=\"l10\">" + row["hits"] + "</li>"
                + "</ul>");
        }
    }
}