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

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

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

--@TempId为零时变量，@Id为节点的Id,@ParentId为节点的父节点Id,@Flag为移动标志0代表节点上移、1代表下移declare @TempId int,@Id int,@ParentId int,@Flag intbeginset @Id=29set @ParentId=26set @Flag=1if @Flag=0beginset @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=@Idupdate KnowledgeInfo set Sort=(select Sort + 1 from KnowledgeInfo where Id=@TempId) where Id=@TempIdendelse if @Flag=1beginset @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=@Idupdate KnowledgeInfo set Sort=(select Sort - 1 from KnowledgeInfo where Id=@TempId) where Id=@TempIdendend