admin/product/fenyeType.ascx.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;
using System.IO;

public partial class news_fenye : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int iPageSize = 2;
            string strTableName = "Type";
            string strKey = "TypeId";
            string strORDER = "DESC";

            string strFilelds = "*";
            int iCurPage;
            int iMaxPage = 1;
            string sql = "";
            string sqlstr = "SELECT count(*) FROM " + strTableName;
            if (Request.QueryString["page"] != "")
                iCurPage = Convert.ToInt32(Request.QueryString["Page"]);
            else
                iCurPage = 1;
            int intTotalRec = Convert.ToInt32(MyClass.ExecuteScalar(sqlstr));

            if (intTotalRec % iPageSize == 0)
                iMaxPage = intTotalRec / iPageSize;
            else
                iMaxPage = intTotalRec / iPageSize + 1;
            if (iMaxPage == 0) iMaxPage = 1;
            if (iCurPage < 1) iCurPage = 1;
            else
                if (iCurPage > iMaxPage) iCurPage = iMaxPage;
            if (intTotalRec != 0)
            {
                if (iCurPage == 1)
                    sql = "SELECT top " + iPageSize + " " + strFilelds + " FROM " + strTableName + " ORDER BY " + strKey + " " + strORDER;
                else
                    sql = "SELECT top " + iPageSize + " " + strFilelds + " FROM " + strTableName + " WHERE " + strKey + " not in (SELECT top " + (iCurPage - 1) * iPageSize + " " + strKey + " FROM " + strTableName + " ORDER BY " + strKey + " " + strORDER + ") ORDER BY " + strKey + " " + strORDER;

            }
            Repeater1.DataSource = MyClass.OfflineSelect(sql);
            Repeater1.DataBind();
            lblTotal.Text = "共有" + intTotalRec.ToString() + "条记录 当前是第" + iCurPage.ToString() + "/" + iMaxPage.ToString() + "页 ";

            if (iCurPage != 1)
            {
                hlFirst.NavigateUrl = Request.FilePath + "?page=1";
                hlPre.NavigateUrl = Request.FilePath + "?page=" + (iCurPage - 1);