手写分页sql_手写分页函数c#_c#应用

/**

/// 返回数据集

///

///

///

public DataSet GetData(string sql,string strconn)

{

OleDbConnection ole=new OleDbConnection(“PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=”+strconn);

ole.Open();

OleDbCommand cm=new OleDbCommand(sql,ole);

DataSet ds=new DataSet();

OleDbDataAdapter da=new OleDbDataAdapter(cm);

da.Fill(ds);

ole.Close();

return ds;

}

/**

/// 分页

///

/// 每页大小

/// 当前页数

/// 获取字段名

/// 表名

/// 排序字段

/// 排序方式,true为升序，false为降序

/// 满足的条件

///

public DataSet GetPage(int pagesize,int pageindex,string field,string tablename,string orderfield,bool taxis,string condition)

{

string temp;

if(taxis)

{

temp=”asc”;

}

else

{

temp=”desc”;

}

string sql;

if(pageindex==1)

{

if(condition==””)

{

sql=”select top “+pagesize+” “+field+” from “+tablename+” order by “+orderfield+” “+temp;

return GetData(sql);

}

else

{

sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+condition+” order by “+orderfield+” “+temp;

return GetData(sql);

}

}

else

{

pageindex=(pageindex-1)*pagesize;

if(condition==””)

{

if(taxis)

{

sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+orderfield+”>all(select top “+pageindex+” “+orderfield+” from “+tablename+” order by “+orderfield+” “+temp+”) order by “+orderfield+” “+temp;

}

else

{

sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+orderfield+”

}

return GetData(sql);

}

else

{

if(taxis)

{

sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+condition+” and “+orderfield+”>all(select top “+pageindex+” “+orderfield+” from “+tablename+” where “+condition+” order by “+orderfield+” “+temp+”) order by “+orderfield+” “+temp;

}

else

{

sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+condition+” and “+orderfield+”

}

return GetData(sql);

}

}

}