.NET翻页控件
//取总记录数
CREATE PROCEDURE dbo.YourCompany_ywkj_PageGetCount
@TabName nvarchar(50),
@ColName nvarchar(50),
@ID int
AS
exec('SELECT COUNT(*) as Num FROM '+@TabName+' where '+ @ColName+' =' +@ID)
GO
//翻页
//取总记录数
CREATE PROCEDURE dbo.YourCompany_ywkj_PageGetCount
@TabName nvarchar(50),
@ColName nvarchar(50),
@ID int
AS
exec('SELECT COUNT(*) as Num FROM '+@TabName+' where '+ @ColName+' =' +@ID)
GO
//翻页
CREATE PROCEDURE YourCompany_ywkj_MeaageReplyForTopicID
@TopicID int,
@Indent int,
@startIndex int,
@endIndex int
AS
if(@Indent=1)
BEGIN
set nocount on
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) select MessageID from Message where TopicID = @TopicID order by MessageID
select m.MessageID,m.TopicID,u.Username,m.MessageContent,m.MessageCreateTime
from Message m,Users u,@indextable t where m.TopicID = @TopicID and m.messageuserid = u.userid
and m.MessageID=t.nid
and t.id between @startIndex and @endIndex order by t.id
set nocount off
end
else --取这个TOPIC的msgid
begin
select messageID
from Message
where TopicID = @TopicID and Indent=0
end
GO
