/**////
/// 返回數據集
///
///
///
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 "
}
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 "
