2005 自定义控件 ASCX

ascx 文件<%@ Control Language="C#" AutoEventWireup="true" CodeFile="webAspNetPage.ascx.cs" Inherits="FormModel_webAspNetPage" %><%@ Register Assembly="Infragistics2.WebUI.WebDataInput.v6.2, Version=6.2.20062.34, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"    Namespace="Infragistics.WebUI.WebDataInput" TagPrefix="igtxt" %><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">  <tr>    <td height="35" align="center">        记录总数：<asp:Label ID="webPageDataCount" runat="server"></asp:Label>                        页码：<asp:Label ID="webPageNumber" runat="server"></asp:Label> /         <asp:Label ID="webPageCount" runat="server"></asp:Label>                <asp:LinkButton ID="webPageHome" runat="server" onclick="webPageHome_Click">首页</asp:LinkButton>            <asp:LinkButton ID="webPagePrev" runat="server" onclick="webPagePrev_Click">上一页</asp:LinkButton>            <asp:LinkButton ID="webPageNext" runat="server" onclick="webPageNext_Click">下一页</asp:LinkButton>            <asp:LinkButton ID="webPageEnd" runat="server" onclick="webPageEnd_Click">末页</asp:LinkButton>              跳转至<igtxt:WebNumericEdit ID="webPageGoTo"                                      Width="50px" runat="server"                                    MinDecimalPlaces="None" MinValue="0"            DataMode="Int" HorizontalAlign="Left"                                     MaxValue="100">                                    <SpinButtons Display="OnRight" />                                </igtxt:WebNumericEdit>页                                  <asp:Button             ID="webPageGoToOk" runat="server" Text="确定" onclick="webPageGoToOk_Click" />        <asp:Label ID="webPageGridViewId" Visible="false" runat="server" />        <asp:Label ID="webPageTableName" Visible="false" runat="server" />        <asp:Label ID="webPageFileName" Visible="false" runat="server" />        <asp:Label ID="webPageSize" Visible="false" runat="server" />        <asp:Label ID="webPageAsc" Visible="false" runat="server" />        <asp:Label ID="webPageWhere" Visible="false" runat="server" />        <asp:Label ID="webPageSum" Visible="false" runat="server" />    </td>  </tr></table> ascx 后台：using System;using System.Collections.Generic;using System.Web;using System.Data;using System.Web.UI;using System.Web.UI.WebControls;public partial class FormModel_webAspNetPage : System.Web.UI.UserControl{    private string pGridViewId = "";    private string pTableName = "";           //查询数据的表名    private string pFileName = "fNo";         //排序字段名    private int pSize = 20;                   //页数大小    private int pPrve = 1;                    //当前页    private int pAsc = 1;                     //排序，非 0 值则降序    private string pWhere = "";               //查询条件(注意: 不要加 where 查询关键词)    public string pageGridViewId    {        get        {            return pGridViewId;        }        set        {            pGridViewId = value;        }    }    public string pageTableName    {        get        {            return pTableName;        }        set        {            pTableName = value;        }    }    public string pageFileName    {        get        {            return pFileName;        }        set        {            pFileName = value;        }    }    public int pageSize    {        get        {            return pSize;        }        set        {            pSize = value;        }    }    public int pagePrve    {        get        {            return pPrve;        }        set        {            pPrve = value;        }    }    public int pageAsc    {        get        {            return pAsc;        }        set        {            pAsc = value;        }    }    public string pageWhere    {        get        {            return pWhere;        }        set        {            pWhere = value;        }    }    protected void Page_Load(object sender, EventArgs e)    {        if (Page.IsPostBack == false)        {            if (webPageGridViewId.Text == "") webPageGridViewId.Text = pGridViewId;            if (webPageTableName.Text == "") webPageTableName.Text = pTableName;            if (webPageFileName.Text == "") webPageFileName.Text = pFileName;            if (webPageAsc.Text == "") webPageAsc.Text = pAsc.ToString();        }    }    /// <summary>    /// 分页数据读取    /// </summary>    public void pageDataBind()    {        GridView pageGridView = (GridView)this.Page.FindControl(pGridViewId);        if (pWhere != "") webPageWhere.Text = pWhere.ToString();        if (pSize > 0) webPageSize.Text = pSize.ToString();        int iPageCount = Convert.ToInt32("0" + new SqlHelper().ExecuteQuery("Exec executeSelectBatch '" + pTableName + "','" + pFileName + "'," + pSize.ToString() + "," + pPrve.ToString() + "," + pAsc.ToString() + ",1,'" + pWhere.Replace("'", "''") + "'").Rows[0][0].ToString());        webPageDataCount.Text = iPageCount.ToString();        if (iPageCount % pSize > 0 && iPageCount > pSize)        {            iPageCount = iPageCount / pSize + 1;        }        else if (iPageCount > pSize)        {            iPageCount = iPageCount / pSize;        }        else        {            iPageCount = 1;        }        webPageSum.Text = iPageCount.ToString();        webPageCount.Text = iPageCount.ToString();        webPageGoTo.Text = pagePrve.ToString();        webPageNumber.Text = pagePrve.ToString();        webPageGoTo.MaxValue = iPageCount;        pageGridView.DataSource = new SqlHelper().ExecuteQuery("Exec executeSelectBatch '" + pTableName + "','" + pFileName + "'," + pSize.ToString() + "," + pPrve.ToString() + "," + pAsc.ToString() + ",0,'" + pWhere.Replace("'", "''") + "'");        pageGridView.DataBind();        //设置按扭生效状态        if (pagePrve == 1) { webPageHome.Enabled = false; webPagePrev.Enabled = false; } else { webPageHome.Enabled = true; webPagePrev.Enabled = true; };        if (pagePrve == iPageCount) { webPageNext.Enabled = false; webPageEnd.Enabled = false; } else { webPageNext.Enabled = true; webPageEnd.Enabled = true; };    }    protected void webPageHome_Click(object sender, EventArgs e)    {        pTableName = webPageTableName.Text;        pFileName = webPageFileName.Text;        pSize = Convert.ToInt32(webPageSize.Text);        pPrve = 1;        pAsc = Convert.ToInt32(webPageAsc.Text);        pWhere = webPageWhere.Text;        pageDataBind();    }    protected void webPagePrev_Click(object sender, EventArgs e)    {        pGridViewId = webPageGridViewId.Text;        pTableName = webPageTableName.Text;        pFileName = webPageFileName.Text;        pSize = Convert.ToInt32(webPageSize.Text);        pPrve = Convert.ToInt32(webPageNumber.Text) - 1;        pAsc = Convert.ToInt32(webPageAsc.Text);        pWhere = webPageWhere.Text;        pageDataBind();    }    protected void webPageNext_Click(object sender, EventArgs e)    {        pGridViewId = webPageGridViewId.Text;        pTableName = webPageTableName.Text;        pFileName = webPageFileName.Text;        pSize = Convert.ToInt32(webPageSize.Text);        pPrve = Convert.ToInt32(webPageNumber.Text) + 1;        pAsc = Convert.ToInt32(webPageAsc.Text);        pWhere = webPageWhere.Text;        pageDataBind();    }    protected void webPageEnd_Click(object sender, EventArgs e)    {        pGridViewId = webPageGridViewId.Text;        pTableName = webPageTableName.Text;        pFileName = webPageFileName.Text;        pSize = Convert.ToInt32(webPageSize.Text);        pPrve = Convert.ToInt32(webPageSum.Text);        pAsc = Convert.ToInt32(webPageAsc.Text);        pWhere = webPageWhere.Text;        pageDataBind();    }    protected void webPageGoToOk_Click(object sender, EventArgs e)    {        pGridViewId = webPageGridViewId.Text;        pTableName = webPageTableName.Text;        pFileName = webPageFileName.Text;        pSize = Convert.ToInt32(webPageSize.Text);        pPrve = Convert.ToInt32(webPageGoTo.Text.Replace(",", ""));        pAsc = Convert.ToInt32(webPageAsc.Text);        pWhere = webPageWhere.Text;        pageDataBind();    }} aspx 前台：<%@ Register Src="FormModel/webAspNetPage.ascx" TagName="webAspNetPage" TagPrefix="uc3" %><uc3:webAspNetPage ID="webPage" pageGridViewId="gvPur" pageTableName="vPur" pageFileName="fDatetime"                        pageSize="16" pageAsc="1" runat="server" /> aspx 后台： /// <summary>    /// 重新查询数据    /// </summary>    public void pReGetData()    {        webPage.pageWhere = gstrWhere;        webPage.pageDataBind();         }