/// <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));
}
