/// <summary>

        /// 对DataTable进行分页,起始页为1

        /// </summary>

        /// <param name="dt"></param>

        /// <param name="PageIndex"></param>

        /// <param name="PageSize"></param>

        /// <returns></returns>

        public static DataTable GetPagedTable(DataTable dt, int PageIndex, int PageSize)

        {

            if (PageIndex == )

                return dt;

            DataTable newdt = dt.Copy();

            newdt.Clear();

            int rowbegin = (PageIndex - ) * PageSize;

            int rowend = PageIndex * PageSize;

            if (rowbegin >= dt.Rows.Count)

                return newdt;

            if (rowend > dt.Rows.Count)

                rowend = dt.Rows.Count;

            for (int i = rowbegin; i <= rowend - ; i++)

            {

                DataRow newdr = newdt.NewRow();

                DataRow dr = dt.Rows[i];

                foreach (DataColumn column in dt.Columns)

                {

                    newdr[column.ColumnName] = dr[column.ColumnName];

                }

                newdt.Rows.Add(newdr);

            }

            return newdt;

        }

        /// <summary>

        /// 获取总页数

        /// </summary>

        /// <param name="sumCount">结果集数量</param>

        /// <param name="pageSize">页面数量</param>

        /// <returns></returns>

        public static int getPageCount(int sumCount, int pageSize)

        {

            int page = sumCount / pageSize;

            if (sumCount % pageSize > )

            {

                page = page + ;

            }

            return page;

        }