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