根据数据库输出XML菜单
发布时间:2016-01-19 10:01:02
USE [test_YTHH]GO/****** Object: StoredProcedure [dbo].[usp_Print_SCC_Menu] Script Date: 04/08/2013 11:21:23 * ...
- USE [test_YTHH]
- GO
- /****** Object: StoredProcedure [dbo].[usp_Print_SCC_Menu] Script Date: 04/08/2013 11:21:23 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
-
-
- ——————————–
- –简易输出Sys菜单
- —BY HXL
- —20136–04–08
- ——————————–
- CREATE PROC [dbo].[usp_Print_Sys_Menu]
- AS
- BEGIN
-
- DECLARE @parentID INT
- DECLARE @text NVARCHAR(20)
- DECLARE @value CHAR(7)
- DECLARE @text2 NVARCHAR(20)
- DECLARE @value2 CHAR(7)
- DECLARE p_cur CURSOR FOR SELECT FunctionName,FunctionCode,FunctionID FROM dbo.[Function] WHERE ParentID = 6001 AND FunctionType = 1
- OPEN p_cur
-
- FETCH NEXT FROM p_cur INTO @text,@value ,@parentID
- WHILE @@FETCH_STATUS = 0
- BEGIN
-
- –父菜单
- PRINT ‘ <Menu id=”‘+@value+‘” text=”‘+@text+‘” iconCls=”Frame_Main_icon11″>’
-
- –子菜单
- DECLARE sub_cur CURSOR FOR SELECT FunctionName,CAST(FunctionCode AS NVARCHAR(20)) FROM dbo.[Function] WHERE ParentID = @parentID AND FunctionType = 2
- OPEN sub_cur
- FETCH NEXT FROM sub_cur INTO @text2,@value2
- WHILE @@FETCH_STATUS = 0
- BEGIN
- PRINT ‘ <Menu id=”‘+@value2+‘” pid=”‘+@value+‘” text=”‘+@text2+‘” url=”../DBM/”></Menu> ‘
- FETCH NEXT FROM sub_cur INTO @text2,@value2
- END
-
- CLOSE sub_cur
- DEALLOCATE sub_cur
-
- PRINT ‘</Menu>’
- FETCH NEXT FROM p_cur INTO @text,@value,@parentID
-
- END
- –关闭游标
- CLOSE p_cur
- –释放资源
- DEALLOCATE p_cur
-
- END
- 转载自:http://www.aspnetjia.com/Cont-49.html
海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理:https://www.xlkjsw.com
原标题:根据数据库输出XML菜单
关键词:数据库
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。
医疗保健:https://www.goluckyvip.com/tag/11229.html
BigBasket:https://www.goluckyvip.com/tag/1123.html
印度客户:https://www.goluckyvip.com/tag/11230.html
美国二审:https://www.goluckyvip.com/tag/11232.html
彩妆用品:https://www.goluckyvip.com/tag/11233.html
1688国际站:https://www.goluckyvip.com/tag/11234.html
湘西游轮六 湘江游轮夜游:https://www.vstour.cn/a/411226.html
携程旅游网折扣优惠最新攻略(携程旅游网更佳折扣优惠):https://www.vstour.cn/a/411227.html