下面展示一些 内联代码片
。
/// <summary>
/// SQL分页
/// </summary>
/// <param name="strSql">查询SQL</param>
/// <param name="pageIndex">第几页</param>
/// <param name="pageSize">每页多少条</param>
/// <param name="orderColumn">排序字段</param>
/// <returns></returns>
public string SqlSplitPage(string strSql, int pageIndex, int pageSize, string orderColumn)
{
string SqlSplit = string.Format(@" SELECT * FROM
( SELECT ROW_NUMBER() OVER(ORDER BY {1} ) ROWNU, TB.* FROM ({0}) TB ) A
WHERE 1=1 ",
strSql,
orderColumn
);
string dataSql = string.Format(@" {0} AND ROWNU BETWEEN {1} AND {2} ", SqlSplit, (pageIndex - 1) * pageSize + 1, pageIndex * pageSize);
return dataSql;
}