XinYu_RZMES/.svn/pristine/d4/d4baee45e152189db760ac930a627552377f31f9.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="主窗体界面">

	<query id="main.Button.Select" desc="获取界面按键" fetchSize="10">
		<![CDATA[
			SELECT FCNRS_ID FC_ID FROM TBZ01_FCNRS
			WHERE FCNRS_TP = 'F'
		]]>
	</query> 
	<query id="main.ScrFn.Select" desc="获取界面按键" fetchSize="10">
		<![CDATA[
			SELECT FC_ID, FC_NM, FN_IMG_URL, JS_FUNC_NM FROM (
				SELECT C.FC_ID, A.FCNRS_NM FC_NM,
					DECODE(A.FN_IMG_YN, 'Y', A.FN_IMG_URL, '') FN_IMG_URL,
					NVL(C.JS_FUNC_NM, A.JS_FUNC_NM) JS_FUNC_NM, C.DSP_SEQ, A.DSP_SEQ DSP_SEQ2
				FROM TBZ01_FCNRS A INNER JOIN (
					SELECT DISTINCT NVL(R.FC_ID, P.FCNRS_ID) FC_ID
					FROM (
						SELECT MNSCR_ID FROM TBZ01_MNSCR
						START WITH MNSCR_ID = ?		-- 参数：界面代码
						CONNECT BY PRIOR P_MNSCR_ID = MNSCR_ID) M
						INNER JOIN (
						SELECT X.MNSCR_ID, X.FCNRS_ID
						FROM TBZ01_USERPRIV X
							INNER JOIN TBZ01_FCNRS Y ON (X.FCNRS_ID = Y.FCNRS_ID)
						WHERE X.USER_CD IN (?, ?)	-- 参数：用户代码、角色代码
						  AND NVL(Y.LOCKED_YN, 'N') = 'N') P ON (P.MNSCR_ID = M.MNSCR_ID)
						LEFT JOIN TBZ01_RSDTL R ON (R.RS_ID = P.FCNRS_ID)
					) B ON (B.FC_ID = A.FCNRS_ID)
					INNER JOIN TBZ01_SCRFN C ON (C.SCR_ID = ? AND C.FC_ID = B.FC_ID)	-- 参数：界面代码
				WHERE NVL(LOCKED_YN, 'N') = 'N'
				UNION
				SELECT B.FC_ID, A.FCNRS_NM, DECODE(A.FN_IMG_YN, 'Y', A.FN_IMG_URL, ''),
					NVL(B.JS_FUNC_NM, A.JS_FUNC_NM), B.DSP_SEQ, A.DSP_SEQ
				FROM TBZ01_FCNRS A, TBZ01_SCRFN B
				WHERE B.SCR_ID = ?
				  AND B.FC_ID IN (SELECT FC_ID FROM TBZ01_RSDTL WHERE RS_ID = 'R000')
				  AND A.FCNRS_ID = B.FC_ID) T
			ORDER BY NVL(T.DSP_SEQ, T.DSP_SEQ2)
		]]>
	</query> 

</queryMap>