sqlserver实现对TreeView节点上下移动的排序功能

我们平常对TreeView节点的添加，发现位置不对，这样就需要移动，移动就得修改序号，通过传参写sql点击打开链接语句，程序可方便执行

 转载请注明出处：飞哥的专栏

--@TempId为零时变量，@Id为节点的Id,@ParentId为节点的父节点Id,@Flag为移动标志0代表节点上移、1代表下移
declare @TempId int,@Id int,@ParentId int,@Flag int
begin
	set @Id=29
	set @ParentId=26
	set @Flag=1
	if @Flag=0
	begin
		set @TempId=(select top 1 Id from (select Id,Sort from KnowledgeInfo where ParentId=@ParentId) a where Sort<(select Sort from KnowledgeInfo where Id=@Id) order by Sort desc)
		update KnowledgeInfo set Sort=(select Sort - 1 from KnowledgeInfo where Id=@Id) where Id=@Id
		update KnowledgeInfo set Sort=(select Sort + 1 from KnowledgeInfo where Id=@TempId) where Id=@TempId
	end
	else if @Flag=1
	begin
		set @TempId=(select top 1 Id from (select Id,Sort from KnowledgeInfo where ParentId=@ParentId) a where Sort>(select Sort from KnowledgeInfo where Id=@Id) order by Sort)
		update KnowledgeInfo set Sort=(select Sort + 1 from KnowledgeInfo where Id=@Id) where Id=@Id
		update KnowledgeInfo set Sort=(select Sort - 1 from KnowledgeInfo where Id=@TempId) where Id=@TempId
	end
end