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, 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); }
public static string builderAccessPageSQL(string strSql, ParamMap param) { return(builderAccessPageSQL(strSql, param, -1)); }