XinYu_RZMES/.svn/pristine/bf/bf809925f3eee26d362e953d079b13d70819498e.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="成分现状">
	
    <query id="UIB.COMMON.SELECT" desc="公用项目" fetchSize="">  
        <![CDATA[
			SELECT  '' SM_CD  , '' SM_CFNM  FROM   DUAL 
			UNION    ALL
			SELECT     SM_CD  ,    SM_CFNM  FROM   TBZ00_COMMCD   WHERE   LG_CD  =  ?
        ]]>   
    </query> 
    <query id="UIB.COMMON.SELECT.01" desc="公用项目" fetchSize="">  
        <![CDATA[
			
			select '' SM_CD,'-- 全部 --' SM_CFNM from dual union all
			SELECT SM_CD,SM_CFNM FROM tbz00_commcd WHERE lg_cd = ?
        ]]>   
    </query> 
    <query id="UIB.COMMON.SELECT.02" desc="公用项目" fetchSize="">  
        <![CDATA[
			
			SELECT SM_CD,SM_CFNM FROM tbz00_commcd WHERE lg_cd = ?
        ]]>   
    </query> 		
	
	<query id="UIB.COMMON_01.INSERT" desc="">
		INSERT INTO TBB01_HIS_SPEC(INTFE_ID , ACT_TP , ACT_SQL , WHERE_PARAM , REG_PGM_ID , REG_ID , REG_DTIME )
		VALUES(? , ? ,? , ? , ? , ?  , TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
	</query>
	
	<query id="UIB016000_01.SELECT" desc="标准修改历史记录查询">
		SELECT * FROM TBB01_HIS_SPEC  T  WHERE T.INTFE_ID LIKE ?||'%' AND SUBSTR(T.REG_DTIME ,1,8) BETWEEN  ?  AND ?  ORDER BY T.REG_DTIME
	</query>
	
	<query id="UIB016000_01.INITSELECT" desc="">
		
		SELECT     T.MNSCR_ID   VALUE  , T.MNSCR_NM LABEL 
		FROM       TBZ01_MNSCR             T 
		WHERE      T.MNSCR_ID LIKE 'UIB01%'  
		AND        T.MNSCR_ID NOT IN('UIB016000' , 'UIB016000' , 'UIB010120' , 'UIB010020' , 'UIB010340' , 'UIB015100' , 'UIB010060' , 'UIB015110' , 'UIB015020')
		AND        T.UPCHECK_YN             =       'Y' 
		ORDER BY   T.MNSCR_ID
	</query>
</queryMap>