novel.aspx.cs

起点9 V2.0小说整站系统 介绍： 1、 采用企业级标准应用三层架构

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;

public partial class manage_novel : System.Web.UI.Page
{
    protected string boardid = "1";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            if (Request.QueryString["boardid"] != null && Regular.IsId(Request.QueryString["boardid"].ToString()))
                boardid = Request.QueryString["boardid"].ToString();
            else
                boardid = this.List_Type.SelectedValue;
            if (Request.QueryString["hiddenid"] != null && Regular.IsId(Request.QueryString["hiddenid"].ToString()))
                SqlStore.SqlHidden(int.Parse(Request.QueryString["hiddenid"].ToString()));
            if (Request.QueryString["recycler"] != null && Regular.IsId(Request.QueryString["recycler"].ToString()))
                SqlStore.SqlRecycler(int.Parse(Request.QueryString["recycler"].ToString()), true);
            if (Request.QueryString["commend"] != null && Regular.IsId(Request.QueryString["commend"].ToString()))
                SqlStore.SqlCommendNovel(int.Parse(Request.QueryString["commend"].ToString()));
            this.List_Type.SelectedValue = boardid;
            ShowPage(1);
        }
    }
    protected void Button_Jump_Click(object sender, EventArgs e)
    {
        #region GO按扭
        Button button = (Button)sender;
        string page = "";
        page = this.Text_Jump.Text.Trim();
        this.Text_Jump.Text = "";
        page = page == "" ? "1" : page;
        page = Regular.IsId(page) ? page : "1";
        int pageCurrent = int.Parse(page);
        int PageAmount = int.Parse(this.Text_PageCount.Text);
        if (pageCurrent > PageAmount && PageAmount != -1)
            pageCurrent = PageAmount;
        if (pageCurrent < 1)
            pageCurrent = 1;
        ShowPage(pageCurrent);
        #endregion
    }
    protected void LinkButton_Front_Click(object sender, EventArgs e)
    {
        #region 上一页
        this.Button_Next.Enabled = true;
        this.Button_Last.Enabled = true;
        int pageCurrent = int.Parse(this.Text_CurrentPage.Text);
        int PageAmount = int.Parse(this.Text_PageCount.Text);
        if (pageCurrent > PageAmount && PageAmount != -1)
            pageCurrent = PageAmount;
        ShowPage(pageCurrent - 1);
        #endregion
    }
    protected void LinkButton_Next_Click(object sender, EventArgs e)
    {
        #region 下一页
        this.Button_First.Enabled = true;
        this.Button_Front.Enabled = true;
        int pageCurrent = int.Parse(this.Text_CurrentPage.Text);
        int PageAmount = int.Parse(this.Text_PageCount.Text);
        if (pageCurrent > PageAmount && PageAmount != -1)
            pageCurrent = PageAmount;
        ShowPage(pageCurrent + 1);
        #endregion
    }
    protected void LinkButton_First_Click(object sender, EventArgs e)
    {
        this.Button_First.Enabled = false;
        this.Button_Front.Enabled = false;
        ShowPage(1);
    }

    protected void LinkButton_Last_Click(object sender, EventArgs e)
    {
        this.Button_Last.Enabled = false;
        this.Button_Next.Enabled = false;
        int PageAmount = int.Parse(this.Text_PageCount.Text);
        ShowPage(PageAmount);
    }

    protected void ShowPage(int requestPage)
    {
        int recordAmount = 0, pageAmount = 0;
        string showField = @"'novel.aspx?boardid=" + List_Type.SelectedValue + "&commend='+convert(char(10),topicid) as iscommend,'../novelintro.aspx?topicid='+convert(char(10),topicid) as link,title,hits,addtime,updatetime,hidden,'novel.aspx?boardid=" + List_Type.SelectedValue + "&hiddenid='+convert(char(10),topicid) as ishidden,'novel.aspx?boardid=" + List_Type.SelectedValue + "&recycler='+convert(char(10),topicid) as recycler";
        DataTable table = SqlStore.SqlPage("novel_topic", "topicid", showField, "topicid desc", "boardid=" + List_Type.SelectedValue+" and recycler=0", requestPage, 30, ref recordAmount, ref pageAmount);

        this.View_Note.DataSource = table;
        this.View_Note.DataBind();

        if (requestPage > pageAmount)
            requestPage = pageAmount;
        if (pageAmount != 1)
        {
            this.Button_First.Enabled = true;
            this.Button_Front.Enabled = true;
            this.Button_Jump.Enabled = true;
            this.Button_Last.Enabled = true;
            this.Button_Next.Enabled = true;
        }
        if (requestPage == 1)
        {
            this.Button_First.Enabled = false;
            this.Button_Front.Enabled = false;
        }
        if (requestPage == pageAmount)
        {
            this.Button_Last.Enabled = false;
            this.Button_Next.Enabled = false;
        }
        this.Text_CurrentPage.Text = requestPage.ToString();
        this.Text_PageCount.Text = pageAmount.ToString();
        this.Label_Detail.Text = "页次<font color=red>" + requestPage + "</font>/<font color=red>" + pageAmount + "</font> 每页<font color=red>30</font>条 共<font color=red>" + recordAmount + "</font>条记录";
    }
    protected void List_Type_SelectedIndexChanged(object sender, EventArgs e)
    {
        ShowPage(1);
    }
    protected void Button_Hidden_Click(object sender, EventArgs e)
    {
        if (Regular.IsId(Text_Hidden.Text))
            SqlStore.SqlHidden(int.Parse(Text_Hidden.Text));
        ShowPage(1);
    }
    protected void Button_Recycler_Click(object sender, EventArgs e)
    {
        if (Regular.IsId(Text_Recycler.Text))
            SqlStore.SqlRecycler(int.Parse(Text_Recycler.Text), true);
        ShowPage(1);
    }
}