/// <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));
}
