数据分页_双TOP二分法.docVIP

using System; using System.Collections.Generic; using System.Text; ? /// summary /// 构造分页后的SQL语句 /// /summary public static class PagingHelper { ????/// summary ????/// 获取分页SQL语句，排序字段需要构成唯一记录 ????/// /summary ????/// param name=_recordCount记录总数/param ????/// param name=_pageSize每页记录数/param ????/// param name=_pageIndex当前页数/param ????/// param name=_safeSqlSQL查询语句/param ????/// param name=_orderField排序字段，多个则用“,”隔开/param ????/// returns分页SQL语句/returns ????public static string CreatePagingSql(int _recordCount, int _pageSize, int _pageIndex, string _safeSql, string _orderField) ????{ ????????//重新组合排序字段，防止有错误 ????????string[] arrStrOrders = _orderField.Split(new char[] { , }, StringSplitOptions.RemoveEmptyEntries); ????????StringBuilder sbOriginalOrder = new StringBuilder(); //原排序字段 ????????StringBuilder sbReverseOrder = new StringBuilder(); //与原排序字段相反，用于分页 ????????for (int i = 0; i arrStrOrders.Length; i++) ????????{ ????????????arrStrOrders[i] = arrStrOrders[i].Trim();? //去除前后空格 ????????????if (i != 0) ????????????{ ????????????????sbOriginalOrder.Append(, ); ????????????????sbReverseOrder.Append(, ); ????????????} ????????????sbOriginalOrder.Append(arrStrOrders[i]); ? ????????????int index = arrStrOrders[i].IndexOf( ); //判断是否有升降标识 ????????????if (index 0) ????????????{ ????????????????//替换升降标识，分页所需 ????????????????bool flag = arrStrOrders[i].IndexOf( DESC, StringComparison.OrdinalIgnoreCase) != -1; ????????????????sbReverseOrder.AppendFormat({0} {1}, arrStrOrders[i].Remove(index), flag ? ASC : DESC); ????????????} ????????????else ????????????{ ????????????????sbReverseOrder.AppendFormat({0} DESC, arrStrOrders[i]); ????????????} ????????} ? ????????//计算总页数 ????????_pageSize = _pageSize == 0 ? _recordCount : _pageSize; ????????int pageCount = (_recordCount + _pageSize - 1) / _pageSize; ? ????????//检查当前页数 ????????if (_pageIndex 1) ????????{ ????????????_pageIndex = 1; ????????} ????????else if (_pageIndex pageCount) ????????{ ????????????_pageIndex = pageCount; ????