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" οnclick="webPageHome_Click">首页</asp:LinkButton>    
        <asp:LinkButton ID="webPagePrev" runat="server" οnclick="webPagePrev_Click">上一页</asp:LinkButton>    
        <asp:LinkButton ID="webPageNext" runat="server" οnclick="webPageNext_Click">下一页</asp:LinkButton>    
        <asp:LinkButton ID="webPageEnd" runat="server" οnclick="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="确定" οnclick="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();     
    }