public static string builderAccessPageSQL(string strSql, ParamMap param, int limit)
{
if (AdoHelper.DbType != DatabaseType.ACCESS)
{
return(strSql);
}
if (param.ContainsKey("page_limit"))
{
if (limit != -1)
{
strSql = strSql.Replace("@" + "page_limit", limit.ToString());
}
else
{
strSql = strSql.Replace("@" + "page_limit", param.getString("page_limit"));
}
param.Remove("page_limit");
}
if (param.ContainsKey("page_offset"))
{
strSql = strSql.Replace("@" + "page_offset", param.getString("page_offset"));
param.Remove("page_offset");
}
return(strSql);
}
public static string builderAccessPageSQL(string strSql, ParamMap param)
{
return(builderAccessPageSQL(strSql, param, -1));
}
