Web/manage/Sys/LinkList.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Common;
using System.Data.SqlClient;
using System.Data;

namespace HotelShop.manage.Sys
{
    public partial class LinkList : System.Web.UI.Page
    {
        public int count = 0, pageindex = 1, pagesize = 10;        //总页数，当前页
        public string wd = "", webUrl = "", strWhere = "", ddl_status = "", ddl_Hotel = "";
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (HttpContext.Current.Request.QueryString["pageindex"] != null && HttpContext.Current.Request.QueryString["pageindex"].Trim() != "")
                {

                    pageindex = Convert.ToInt32(HttpContext.Current.Request.QueryString["pageindex"]);     //当前页
                }
                if (HttpContext.Current.Request.QueryString["wd"] != null && HttpContext.Current.Request.QueryString["wd"].Trim() != "")
                {
                    wd = HttpContext.Current.Request.QueryString["wd"];
                    webUrl += "&wd=" + wd;
                }
                if (HttpContext.Current.Request.QueryString["ddl_status"] != null && HttpContext.Current.Request.QueryString["ddl_status"].Trim() != "")
                {
                    ddl_status = HttpContext.Current.Request.QueryString["ddl_status"];     //当前页
                    webUrl += "&ddl_status=" + ddl_status;
                }
                if (HttpContext.Current.Request.QueryString["ddl_Hotel"] != null && HttpContext.Current.Request.QueryString["ddl_Hotel"].Trim() != "")
                {
                    ddl_Hotel = HttpContext.Current.Request.QueryString["ddl_Hotel"];     //当前页
                    webUrl += "&ddl_Hotel=" + ddl_Hotel;
                }
                MyDataBind();
            }
        }
        public void MyDataBind()
        {
            string sort = " LinkID desc";
            strWhere = " m.Status<>0 ";
            //if (ddl_Hotel != "")
            //    strWhere += " and m.HotelID=" + this.ddl_Hotel;
            if (ddl_status != "")
                strWhere += " and m.Status=" + this.ddl_status;
            if (this.wd != "")
            {
                strWhere += "  and (m.LinkTitle like '%" + this.wd + "%' )";
            }
            string sql = @"select m.LinkID,m.LinkTitle,m.LinkUrl,m.Remark,m.Sort,m.AddDate,case when m.Status=1 then '可用' else '禁用' end StatusName,m.Status from T_Link m ";
            sql += " where " + strWhere;
            sql = DataTableHelper.GetPageSql(sql, pageindex, pagesize, sort);
            DataSet ds = DbHelperSQL.Query(sql);
            if (ds.Tables[0].Rows.Count > 0)