admin/news/news.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;

namespace web.admin.news
{
    public partial class news : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                if (Request.QueryString["typeid"] != null)
                {
                    int uid = Convert.ToInt32(Request.QueryString["typeid"]);
                    int x = 20;
                    int p = 1;
                    if (Request.QueryString["pagex"] != null)
                    {
                        p = Convert.ToInt32(Request.QueryString["pagex"]);
                    }
                    string username = new Random().Next(100).ToString();

                    string sqlstring = "";

                    string sqlwere = " type=" + uid.ToString() + " ";
                    string sqlandwrer = " and type=" + uid.ToString() + " ";

                    if ((p - 1) * x == 0)
                    {
                        sqlstring = "select top " + x + " * from news where "+sqlwere+" order by px ";
                    }
                    else
                    {
                        sqlstring = "select top " + x + " * from news where px >(select max(px) from news where px in (select top " + (p - 1) * x + " px from news where " + sqlwere + " order by px) ) " + sqlandwrer + " order by px ";
                    }



                    using (DataTable dt = new AcsHelper().ExecuteDataTable(sqlstring))
                    {
                        this.Repeater1.DataSource = dt;
                        this.Repeater1.DataBind();
                    }

                    username = "typeid=" + uid.ToString();

                    this.Literal1.Text = liu.fystr_new(x, "news where " + sqlwere, username, p, "pagex", "id");

                }
            }
        }
        public static string typeid(object ob) 
        {
            string fig = "";