pagesetclass.cs

进销存管理软件,包括服装,制造型销售企业等

using System;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using functionClass;

namespace jpgSoftware_SM.webControls
{
	/// <summary>
	/// pageSetClass 的摘要说明。
	/// </summary>
	public class pageSetClass
	{
		DataBaseLink db = new DataBaseLink();
		public int PageSize = 25;
		public pageSetClass()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		// PageSize 每页记录条数   PageNum 页数  tableName 表名 sqlStr 要查询字段内容    whereStr 条件语句
		public string loadPageData(int PageSize,int PageNum,string tableName,string sqlStr,string whereStr)
		{
			int startNum = (PageNum-1)*PageSize;
			int endNum = PageNum*PageSize;
			string sql = "select top "+endNum.ToString()+" fomrid,"+sqlStr+" from "+tableName+" where formid not in (select top "+startNum.ToString()+" fomrid from "+tableName+")  and "+whereStr;
			
			return sql;
		}

		// 返回总记录数
		public int TotalReocrd(string sqlStr,string whereStr)
		{
			string sql = "select "+sqlStr+" from tableName "+whereStr;
			DataTable dt = db.ExecuteQueryReturnTable(sql);
			
			int recordCount = dt.Rows.Count;
			return recordCount;
		}


	}
}