/// <summary> /// 分页查询,返回DataSet /// </summary> /// <param name="sql">除去分页之外的SQL语句</param> /// <param name="pageSize">页面大小(单页记录条数)</param> /// <param name="pageIndex">当前页码(页号从1开始)</param> /// <returns></returns> public DataSet ExecuteDataSetPage(string sql, int pageSize, int pageIndex) { try { return(_db.ExecuteDataSetPage(sql, pageSize, pageIndex)); } catch (Exception ex) { throw new Exception(string.Format("查询失败!\r\n数据库:{0}。\r\nSQL语句:{1}。\r\n{2}", DbType, sql, ex.ToString())); } }