Web/manage/Sys/T_BasicPageTemplateList.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.T_BasicPageTemplate
{
    public partial class T_BasicPageTemplateList : System.Web.UI.Page
    {
        public int count = 0, pageindex = 1, pagesize = 10;        //总页数，当前页
        public string wd = "", webUrl = "", strWhere = "", ddl_status = "";
        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;
                }
                MyDataBind();
            }
        }
        public void MyDataBind()
        {
            string sort = " sort  asc";
            strWhere = " 1=1  ";
            if (ddl_status != "")
                strWhere += " and  isShow=" + this.ddl_status;
            if (this.wd != "")
            {
                strWhere += "  and (templateSkuName like '%" + this.wd + "%' )";
            }
            string sql = @" select  
            *,(select Name from T_ProductClass where ProductClassID=T_BasicPageTemplate.ClassId) ClassName,(select Template from T_BasicTemplate where id  =T_BasicPageTemplate.templateId) Template,

case when T_BasicPageTemplate.isShow=1 then '显示' else '隐藏' end StatusName  from  T_BasicPageTemplate
            ";
            sql += " where " + strWhere;
            sql = DataTableHelper.GetPageSql(sql, pageindex, pagesize, sort);