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

    
        
 

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!