admin/lxwm/lxwm.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.lxwm
{
    public partial class lxwm : System.Web.UI.Page
    {
        public string fystr;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                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 sqlw = "";

                string sqlstring = "";
                if ((p - 1) * x == 0)
                {
                    sqlstring = "select top " + x + " * from lxwm where id <> 0" + sqlw + " order by id desc";
                }
                else
                {
                    string zid_sql_one = "select top " + (p - 1) * x + " id from lxwm where id <> 0 " + sqlw + " order by id desc";
                    string zid_sqltwo = "select top 1 id from lxwm where id in (" + zid_sql_one + ") order by id";
                    string zid = new access().ExecuteScalar(zid_sqltwo);
                    sqlstring = "select top " + x + " * from lxwm where id <(" + zid + ") " + sqlw + " order by id desc";
                }
                using (DataTable dt = new AcsHelper().ExecuteDataTable(sqlstring))
                {
                    this.Repeater1.DataSource = dt;
                    this.Repeater1.DataBind();
                }
                fystr = liu.fystr_new(x, "lxwm where id <> 0" + sqlw, username, p, "pagex", "id");
            }
        }
        protected void Rp_OnItemCommand(object o, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "del")
            {
                string sqlstring = "delete from lxwm where id=" + e.CommandArgument;
                int a = new AcsHelper().ExecuteNonQuery(sqlstring);
                if (a > 0)
                {
                    Response.Redirect(Request.RawUrl);
                }
            }
        }
    }