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();
}