Example #1
0
 /// <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));
     }
 }
Example #2
0
 /// <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));
     }
 }