XinYu_RZMES/.svn/pristine/09/094587d03511c08e2e05950011023628c56c1413.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="">

	<query id="SELECT.DEPT" desc="" fetchSize="10">
		<![CDATA[
			SELECT
				LEVEL,
				DEPT_CD,	/* 部门代码 */
				DEPT_NM		/* 部门名称 */
			FROM TBZ01_DEPT
			START WITH DEPT_CD = ?
			CONNECT BY PRIOR DEPT_CD = P_DEPT_CD
		]]>
	</query> 
    
	<query id="SELECT.FCNRS" desc="" fetchSize="10">
		<![CDATA[
			SELECT
				FCNRS_ID,	-- 功能权限ID
				FCNRS_NM,	-- 功能权限名
				FCNRS_TP	-- 功能权限区分
			FROM TBZ01_FCNRS
			ORDER BY FCNRS_TP, DSP_SEQ
		]]>
	</query> 

	<query id="SELECT.MENU" desc="" fetchSize="10">
		<![CDATA[
			SELECT LEVEL,
				MNSCR_ID,	-- 菜单/画面 ID
				MNSCR_NM	-- 菜单/画面名
			FROM (
				SELECT DISTINCT MNSCR_ID, MNSCR_NM, P_MNSCR_ID, MNSCR_DSP_SEQ
				FROM TBZ01_MNSCR
				WHERE UPCHECK_YN = 'Y'														-- 菜单必须有效
				START WITH MNSCR_ID IN (
					SELECT COLUMN_VALUE FROM TABLE(XB_PACKAGE.GF_MNSCR_BYUSER2ROLE(?))		-- 参数：用户代码
					WHERE 'Y' = ? OR COLUMN_VALUE IN (										-- 参数：最高管理
						SELECT COLUMN_VALUE FROM TABLE(XB_PACKAGE.GF_MNSCR_BYUSER2DEPT(?)))	-- 参数：用户代码
					UNION
					SELECT COLUMN_VALUE FROM TABLE(XB_PACKAGE.GF_MNSCR_BYUSER(?)))			-- 参数：用户代码
				CONNECT BY PRIOR P_MNSCR_ID = MNSCR_ID)
			START WITH MNSCR_ID = '*'
			CONNECT BY PRIOR MNSCR_ID = P_MNSCR_ID											-- 使菜单正常显示
			ORDER SIBLINGS BY MNSCR_DSP_SEQ
		]]>
	</query> 

</queryMap>