#region AspNetPagerQuerySql
/// <summary>
/// AspNetPagerQuerySql
/// </summary>
/// <param name="PageIndex">Index Page</param>
/// <param name="PageSize">Page Size</param>
/// <param name="Sql">Sql String</param>
/// <param name="srTable">TableName</param>
/// <param name="error">errorInfomation</param>
/// <returns>DataSet</returns>
public DataSet AspNetPagerQuerySql(int PageIndex, int PageSize, string Sql, string srTable, out string error)
{
error = null;
DataSet ds = new DataSet();
cmd.CommandText = Sql;
sda = new OleDbDataAdapter(cmd);
try
{
sda.Fill(ds, PageIndex * PageSize, PageSize, srTable);
}
catch (Exception e)
{
error = e.Message;
}
return ds;
}
#endregion
#region AspNetPager
/// <summary>
///
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="sErr"></param>
/// <returns></returns>
public static DataSet ViewCX(int PageIndex, int PageSize, out string sErr)
{
sErr = string.Empty;
DataSet ds = null;
OperateAccess OA = new OperateAccess();
try
{
string sSql = string.Format(SqlLanguage.ViewCX);
ds = OA.AspNetPagerQuerySql(PageIndex, PageSize, sSql, "TypeInfo", out sErr);
}
catch (Exception e)
{
sErr = e.Message;
throw new Exception(sErr);
}
finally
{
if (OA != null)
OA.Close();
}
return ds;
}
#endregion