62,050
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 生成分页用的SQL的演示
/// </summary>
public partial class PagerSQLPage : System.Web.UI.Page
{
protected void btn_Create_Click(object sender, EventArgs e)
{
//生成分页用SQL
string tableName = this.txt_TableName.TextTrimNone ;
string orderByColumns = this.txt_OrderByColumns.TextTrimNone ;
string PKColumn = this.txt_PKColumn.TextTrimNone ;
string tableQuery = this.txt_Query.TextTrimNone ;
string showColumns = this.txt_ShowColumns.TextTrimNone ;
string pageIndex = this.txt_Index.TextTrimNone;
string pageCount = this.txt_PageCount.TextTrimNone;
if (!Functions.IsInt(pageIndex))
{
Functions.PageRegisterAlert(Page, "页号必须是整数!");
return;
}
QuickPagerSQL sql = new QuickPagerSQL();
sql.TableName = tableName; //表名或者视图名
sql.TableShowColumns = showColumns; //要显示的字段
sql.TablePKColumn = PKColumn; //主键
sql.TableOrderByColumns = orderByColumns; //排序字段
sql.TableQuery = tableQuery; //查询条件
sql.PageCount = int.Parse(pageCount); //一页的记录数
//选择一种分页算法
sql.SetPagerSQLKind = (PagerSQLKind)Int32.Parse(this.lst_Kind.SelectedValue) ;
//拼接SQL;
sql.CreateSQL();
//统计总记录数的SQL
this.txt_SQL1.Text = sql.GetRecordCountSQL;
//实际中需要用上面的SQL到数据库里统计,这里“虚构”一个总记录数。
sql.RecordCount = 200;
//获取指定页数据的SQL
this.txt_SQL2.Text = sql.GetSQLByPageIndex(int.Parse(pageIndex));
}
}