e-shahshahani
جمعه 12 بهمن 1386, 19:08 عصر
من برای این کار از stored procedure و کد #c زیر استفاده می کنم
متد #c برای ایجاد صفحه بندی استفاده می شود.
در صفحه aspx هم از یک repeater استفاده کرده ام. البته می شود از gridview هم استفاده کرد ولی باید paging آن را غیرفعال کرد
کد :
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[product_Products_GetAllPaging]
@PageIndex int, @PageSize int, @TotalRecords int OUTPUT
AS
BEGIN
DECLARE @PageLowerBound int;
DECLARE @PageUpperBound int;
SELECT @PageLowerBound = @PageSize * @PageIndex;
SELECT @PageUpperBound = @PageSize - 1 + @PageLowerBound;
DECLARE @Products TABLE
(
IndexId int IDENTITY (0, 1) NOT NULL,
ProductId int
)
INSERT INTO @Products ([ProductId])
SELECT [ProductId] FROM [product_Products] ORDER BY [ProductId] DESC;
SELECT @TotalRecords = @@ROWCOUNT;
SELECT p.ProductId, pName, [pDescription]
FROM product_Products AS p, @Products t
WHERE ((p.ProductId = t.ProductId)
AND (t.IndexId >= @PageLowerBound AND t.IndexId <= @PageUpperBound))
ORDER BY [ProductId] DESC;
END
public class Paging
{
public static string GetPagingHtml(int pageIndex, int pageSize, int itemsCount, string pagingUrl)
{
int pagesCount = 0;
string paging = "";
if (itemsCount > 0)
pagesCount = ((itemsCount - 1) / pageSize) + 1;
if (pagesCount == 1)
{
paging = "";
}
else if (pagesCount <= 11) // فقط 11 تا شماره صفحه نشان بده، 5 تا راست و 5 تا چپ
{
for (int p = 1; p <= pagesCount; p++)
{
if (p == pageIndex + 1)
paging += string.Format("<span class=\"x1\">{0}</span> ", p);
else
{
string href = pagingUrl + p;
paging += string.Format("<span class=\"x2\"><a href=\"{0}\">{1}</a></span> ", href, p);
}
}
}
else
{
int idx1 = pageIndex - 4;
int idx2 = pageIndex + 6;
if (idx1 < 1)
{
idx1 = 1;
idx2 = 10;
}
if (idx2 > pagesCount)
{
idx1 = pagesCount - 9;
idx2 = pagesCount;
}
for (int p = idx1; p <= idx2; p++)
{
if (p == pageIndex + 1)
paging += string.Format("<span class=\"x1\">{0}</span> ", p);
else
{
string href = pagingUrl + p;
paging += string.Format("<span class=\"x2\"><a href=\"{0}\">{1}</a></span> ", href, p);
}
}
string info = string.Format("<span>صفحه {0} از {1}</span> ", pageIndex + 1, pagesCount);
string first = "";
string prev = "";
string next = "";
string last = "";
if (pageIndex > 5)
first = string.Format("<a href=\"{0}\">اول</a> ", pagingUrl + "1");
if (pageIndex != 0)
prev = string.Format("<a href=\"{0}\">قبلی</a> ", pagingUrl + pageIndex);
if (pageIndex != pagesCount - 1)
next = string.Format("<a href=\"{0}\">بعدی</a> ", pagingUrl + pageIndex + 2);
if (pageIndex < pagesCount - 1 - 5)
last = string.Format("<a href=\"{0}\">آخر</a>", pagingUrl + pagesCount);
paging = info + first + prev + paging + next + last;
}
return paging;
}
}