mypager.cs

来自「主要实现软件的基本架构」· CS 代码 · 共 47 行

using System;
using System.Data;
using System.Data.SqlClient;
namespace sp
{
	/// <summary>
	/// Mypager 的摘要说明。
	/// </summary>
	public class Mypager
	{	public Wuqi.Webdiyer.AspNetPager mypager=new Wuqi.Webdiyer.AspNetPager();
		public DataSet df=new DataSet();
		public string counts;
		public Wuqi.Webdiyer.AspNetPager _mypager
		{
			get 
			{return _mypager;}
			set
			{mypager=value;}
		}
		public Mypager()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public void main(string sql1,string sql2)
		{ 
			DataSet ds1 = sp.Base.ExecuteSql4Ds(sql2) ;
			
			SqlDataAdapter objCmd=new SqlDataAdapter(sql1,sp.Base.strConn);
			DataSet ds = new DataSet() ;
			ds=ds1;
			
			mypager.RecordCount = (int)ds.Tables[0].Rows[0].ItemArray[0];
			
			objCmd.Fill(df, mypager.PageSize * (mypager.CurrentPageIndex - 1), mypager.PageSize, "Vod_Center");
					
			mypager.CustomInfoText = "记录总数："+"<font"+"color=blue><b>" + mypager.RecordCount.ToString() + "</b></font>";
			mypager.CustomInfoText += " 总页数：<font color=blue><b>" + mypager.PageCount.ToString() + "</b></font>";
			mypager.CustomInfoText += "当前页：<font color=red><b>" + mypager.CurrentPageIndex.ToString() + "</b></font>";
			mypager.CustomInfoText += "每页：<font color=red><b>" + mypager.PageSize.ToString() + "</b></font>条记录";
            counts=mypager.RecordCount.ToString();
		}
	
	}
}