ViShow.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class VipShow : System.Web.UI.Page
{
    public int fid;
    public int sid;
    public string stitle = "";//二级标题
    public string surl = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        fid = Convert.ToInt32(Request.QueryString["fid"].ToString());
        sid = Convert.ToInt32(Request.QueryString["sid"].ToString());
        if (!IsPostBack)
        {
            if (sid != 0)
            {
                stitle = SQLClass.GetSingle("select sname from tb_second where sid=" + sid).ToString();
                surl = SQLClass.GetSingle("select url from tb_second where sid=" + sid).ToString();
            }
            dh.DataSource = SQLClass.Query("select * from tb_second where fid=" + fid + "  order by sid");
            dh.DataBind();
            int totalOrders;
            totalOrders = int.Parse(SQLClass.GetSingle("select count(*) from tb_vishow").ToString());
            NewsPager.RecordCount = totalOrders;
            klit.DataSource = GetList(NewsPager.CurrentPageIndex);
            klit.DataBind();
        }
    }
    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        klit.DataSource = GetList(NewsPager.CurrentPageIndex);
        klit.DataBind();
        NewsPager.PageIndexOutOfRangeErrorMessage = "页索引超出范围,当前共" + NewsPager.PageCount.ToString() + "页!";
    }
    /// <summary>
    /// 分页获取数据列表
    /// </summary>
    public DataSet GetList(int pagerIndex)
    {
        string sql;
        if (pagerIndex == 1)
        {
            sql = "select top " + (pagerIndex * NewsPager.PageSize).ToString() + " * from tb_vishow   order by uid desc";

        }
        else
        {
            sql = "select top " + (pagerIndex * NewsPager.PageSize).ToString() + " * from tb_vishow where  uid not in (select top " + ((pagerIndex - 1) * NewsPager.PageSize).ToString() + " uid from tb_vishow  order by uid desc )   order by uid desc";
        }