/// <summary>
/// 分页查询 返回总数
/// </summary>
public static DataSet Paging(this StringBuilder strSql, string strOrderby, int iPageIndex, int iPageSize, ParCollection ltEx, out int iCount)
{
using (DBDalOperate dal = new DBDalOperate())
{
return(dal.Paging(strSql.ToString(), strOrderby, iPageIndex, iPageSize, out iCount, ltEx, true));
}
}
/// <summary>
/// 执行分页查询（不反回总页数）
/// </summary>
/// <param name="auto"></param>
/// <param name="strOrderBy"></param>
/// <param name="iPageIndex"></param>
/// <param name="iPageSize"></param>
/// <param name="iCount"></param>
/// <returns></returns>
public static DataSet SelectPaging(this AutoPar auto, string strOrderBy, int iPageIndex, int iPageSize)
{
using (DBDalOperate dal = new DBDalOperate())
{
auto.End();
return(dal.Paging(auto.strSql, strOrderBy, iPageIndex, iPageSize, auto.pars));
}
}