/// <summary> /// 获取分页数据 /// </summary> /// <param name="index"></param> /// <returns></returns> private DataTable GetPages(string connectionString, int currentPage, string where_, string OrderByColumn, string ColumnList, string TableList, int PageSize, bool IsAccount, out int TotalRecord, out int TotalPage) { DataSet set = new DataSet(); SqlParameter[] parm = { new SqlParameter("@OrderByColumn", SqlDbType.NVarChar, 500), new SqlParameter("@ColumnList", SqlDbType.NVarChar, 8000), new SqlParameter("@TableList", SqlDbType.NVarChar, 4000), new SqlParameter("@Condition", SqlDbType.NVarChar, 4000), new SqlParameter("@PageSize", SqlDbType.Int, 4), new SqlParameter("@CurrentPage", SqlDbType.Int, 4), new SqlParameter("@IsAccount", SqlDbType.Bit, 1), new SqlParameter("@TotalRecord", SqlDbType.Int), new SqlParameter("@TotalPage", SqlDbType.Int) }; parm[0].Value = OrderByColumn; parm[1].Value = ColumnList; parm[2].Value = TableList; parm[3].Value = where_; parm[4].Value = PageSize; parm[5].Value = currentPage; parm[6].Value = IsAccount; parm[7].Direction = ParameterDirection.Output; parm[8].Direction = ParameterDirection.Output; ExecuteDataset(connectionString, set, CommandType.StoredProcedure, "Sp_CustomPage2015_V1", parm); TotalRecord = 0; TotalPage = 0; if (Convert.ToBoolean(DataTableHelper.CheckDbObject(parm[7].Value, 0)) && Convert.ToBoolean(DataTableHelper.CheckDbObject(parm[8].Value, 1))) { TotalRecord = Convert.ToInt32(parm[7].Value); TotalPage = Convert.ToInt32(parm[8].Value); } return(DataTableHelper.GetTable(set)); }