Exemplo n.º 1
0
 /// <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()));
     }
 }