/// <summary> /// 被打包后的Sql 求分页数据 /// </summary> /// <param name="startCount"></param> /// <param name="endCount"></param> /// <param name="packagedsql"></param> /// <returns></returns> public string GetPageSqlWithPackageSql(int startCount, int endCount, string packagedsql) { SqlScriptManager sqlMng = this; var pageWrapFormat = @"SELECT * FROM ({0}) " + WrapPagedAlias + " WHERE " + WrapPagedAlias + "._$tmpRowNum BETWEEN " + startCount + " AND " + endCount; return(sqlMng.CtePart + string.Format(pageWrapFormat, packagedsql)); }
/// <summary> /// GetCountSql /// </summary> /// <returns></returns> public string GetPageCountSql() { SqlScriptManager sqlMng = this; string countPackage = @"SELECT COUNT(1) FROM ( {0} ) " + WrapAlias + " "; var s = GetPackagedSql(string.Empty, false); return(sqlMng.CtePart + string.Format(countPackage, s)); }
/// <summary> /// 获取分页Sql /// </summary> /// <param name="startCount"></param> /// <param name="endCount"></param> /// <param name="orderBy"></param> /// <returns></returns> public string GetPageSql(int startCount, int endCount, string orderBy = "") { SqlScriptManager sqlMng = this; var pagePackage = @"SELECT * FROM ({0}) " + WrapPagedAlias + " WHERE " + WrapPagedAlias + "._$tmpRowNum BETWEEN " + startCount + " AND " + endCount; var queryPackage = GetPackagedSql(orderBy); return(sqlMng.CtePart + string.Format(pagePackage, queryPackage)); }