SELECT PKID, ParentID, Name
FROM SubjectWordLibrary
ORDER BY PKID
--
if(@Row>(select count(PKID) from SubjectWordLibrary)+1)
set @Row=(select count(PKID) from SubjectWordLibrary)+1
if(@Row<0)
set @Row=0
if(@Direct=0)
begin
if(@Rows>@Row-1)
set @Rows=@Row-1
end
else
begin
if (@Rows>(select count(PKID) from SubjectWordLibrary)-@Row)
set @Rows=(select count(PKID) from SubjectWordLibrary)-@Row
end
--
set @rowCount=1
OPEN Trade_Cursor
While @rowCount<=@ROWS
BEGIN
if (@direct=0)
set @Row=@Row-1
else
set @Row=@Row+1
Begin
FETCH ABSOLUTE @Row FROM Trade_Cursor
INTO @TID,@CID,@Cnt
While @@Fetch_Status<>0
break
Insert into @tmpTable values(@TID,@CID,@Cnt)
set @rowCount=@rowCount+1
End
END
CLOSE Trade_Cursor
DEALLOCATE Trade_Cursor
SELECT * FROM @tmpTable ORDER BY PKID
RETURN
GO
页面:
private void DataBoundTrademarkList(string cmmd)
{