pagechange.txt

Pagechange触发器运用

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using SQLServerDAL;
using System.Data.SqlClient;


/// <summary>
/// PageChange 的摘要说明
/// </summary>
namespace WebComponents
{
    public class PageChange
    {
        private const string PARM_TAG = "@tag";
        private const string PARM_TABLENAME = "@tblName";
        private const string PARM_WHERE = "@strWhere";

        public PageChange()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        public void DatalistBind(DataSet ds, int StartIndex, int PageSize, string StoredProcedure, string TableName, string tblName, int tag, string strwhere)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = new SqlConnection(SqlHelper.CONN);
            cmd.CommandText = StoredProcedure;
            cmd.CommandType=CommandType.StoredProcedure;
            SqlParameter[] parm = new SqlParameter[3];
            parm[0] = new SqlParameter(PARM_TABLENAME, SqlDbType.VarChar,255);
            parm[1] = new SqlParameter(PARM_TAG,SqlDbType.Int);
            parm[2] = new SqlParameter(PARM_WHERE, SqlDbType.VarChar,1500);
            parm[0].Value = tblName;
            parm[1].Value = tag;
            parm[2].Value = strwhere;
            cmd.Parameters.AddRange(parm);
            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = cmd;
            sda.Fill(ds, StartIndex, PageSize, TableName);
        }
        public DataSet getList(string tblName, int tag, string strwhere,string StoredProcedure)
        {
            SqlParameter[] parm = new SqlParameter[3];
            parm[0] = new SqlParameter(PARM_TABLENAME, SqlDbType.VarChar, 255);
            parm[1] = new SqlParameter(PARM_TAG, SqlDbType.Int);
            parm[2] = new SqlParameter(PARM_WHERE, SqlDbType.VarChar, 1500);
            parm[0].Value = tblName;
            parm[1].Value = tag;
            parm[2].Value = strwhere;
            return SqlHelper.ExecuteDataset(SqlHelper.CONN, CommandType.StoredProcedure, StoredProcedure, parm);
        }

        public int getListCount(string tblName, int tag, string strwhere, string StoredProcedure)
        {
            SqlParameter[] parm = new SqlParameter[3];
            parm[0] = new SqlParameter(PARM_TABLENAME, SqlDbType.VarChar, 255);
            parm[1] = new SqlParameter(PARM_TAG, SqlDbType.Int);
            parm[2] = new SqlParameter(PARM_WHERE, SqlDbType.VarChar, 1500);
            parm[0].Value = tblName;
            parm[1].Value = tag;
            parm[2].Value = strwhere;
            return (int)SqlHelper.ExecuteScalar(SqlHelper.CONN, CommandType.StoredProcedure,StoredProcedure, parm);
        }
        
        public int LinkButtonClick(string TxtCount, int CurrentPage, int PageCount, string e)
        {
            string cmd = e;
            //判断cmd，以判定翻页方向
            switch (cmd)
            {
                case "prev"://上一页
                    if (CurrentPage > 0) CurrentPage--;
                    break;

                case "next":
                    if (CurrentPage < (PageCount - 1)) CurrentPage++;//下一页
                    break;

                case "first"://第一页
                    CurrentPage = 0;
                    break;

                case "end"://最后一页
                    CurrentPage = PageCount - 1;
                    break;

                case "jump"://跳转到第几页
                    if (TxtCount == "" || Int32.Parse(TxtCount) > PageCount)//如果输入数字为空或超出范围则返回
                    {
                        break;
                    }
                    else
                    {
                        CurrentPage = Int32.Parse(TxtCount.ToString()) - 1;
                        break;
                    }
            }
            return CurrentPage;
        }
    }
}