XinYu_RZMES/.svn/pristine/1a/1a9a18a6ff3c82e900f2b5c5a6bf3c1332689b00.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="目标成分参数录入">
	<query id="UIB010051_01.INITSELECT" desc="查询所有目标钢号" fetchSize="10">
        <![CDATA[
			SELECT  DISTINCT 
                         TAFAC_STL_GRD     LABEL
                        ,TAFAC_STL_GRD     VALUE
            FROM         TBB01_TAFAC_INGR  
            UNION  ALL
            SELECT       'ALL'             LABEL
                        ,''                VALUE 
			FROM          DUAL 
			ORDER   BY    VALUE    DESC
        ]]>
    </query>
	
	<query id="UIB010051_02.INITSELECT" desc="内控-放行，缺少成分牌号">
		SELECT DISTINCT T1.FAC_STL_GRD LABEL , T1.FAC_STL_GRD VALUE FROM TBB01_FAC_INGR T1
		MINUS
		SELECT DISTINCT T2.TAFAC_STL_GRD , T2.TAFAC_STL_GRD FROM TBB01_TAFAC_INGR T2
	</query>
	
	<query id="UIB010051_01.SELECT" desc="">
		SELECT * FROM TBB01_TAFAC_INGR T WHERE T.TAFAC_STL_GRD = ? AND T.CHEM_CD = ?
	</query>
	
	<query id="UIB010051_02.SELECT" desc="查询厂内钢号，目标钢号" fetchSize="10">
        <![CDATA[
			SELECT   DISTINCT 
					         T.TAFAC_STL_GRD 
			FROM             TBB01_TAFAC_INGR T
			WHERE            T.TAFAC_STL_GRD         LIKE   ?||'%'
			ORDER    BY      T.TAFAC_STL_GRD
			]]>
    </query>

	<query id="UIB010051_03.SELECT" desc="按datagrid1中的目标钢号进行查询--非复合成分">
	     SELECT  
         a.CHEM_CD
        ,''        COMP_YN 
        ,b.CHEM_MAX 
        ,b.CHEM_MIN 
         FROM  TBB01_SEQ_INGR   A  ,  TBB01_TAFAC_INGR b 
         WHERE  a.CHEM_CD             =    b.CHEM_CD(+)  
         AND    A.COMP_YN             =    'N'
         AND    b.TAFAC_STL_GRD(+)    =    ?    
         ORDER BY decode(b.CHEM_MAX || b.CHEM_MIN, null, 1, 0), a.DISPLAY_SEQ
	</query>
	
	<query  id="UIB010051_04.SELECT" desc="按datagrid1中的目标钢号进行查询--复合成分">
		SELECT  
        a.CHEM_CD
       , A.COMP_DETAIL
	   , A.COMP_CAL	
       , 'Y'          COMP_YN
       , b.CHEM_MAX 
       , b.CHEM_MIN 
         FROM  TBB01_SEQ_INGR   A  ,  TBB01_TAFAC_INGR b 
         WHERE  a.CHEM_CD              =    b.CHEM_CD(+)  
         AND    A.COMP_YN              =    'Y'
         AND    b.TAFAC_STL_GRD(+)     =    ?        
        ORDER BY decode(b.CHEM_MAX || b.CHEM_MIN, null, 1, 0), a.DISPLAY_SEQ
	</query>	
	
	<query   id="UIB010051_01.DELETE" desc="删除目标钢号信息">
			DELETE FROM TBB01_TAFAC_INGR WHERE TAFAC_STL_GRD = ?
	</query>	
	
	<query   id="UIB010051_02.DELETE" desc="删除目标成分信息">
			DELETE FROM TBB01_TAFAC_INGR WHERE tafac_stl_grd = ? AND CHEM_CD = ? 
	</query>			
	
	<query   id="UIB010051_01.INSERT" desc="插入新的目标成分元素">
			INSERT INTO TBB01_TAFAC_INGR(
			  TAFAC_STL_GRD    --目标钢号
			, CHEM_CD          --成分
			, COMP_YN          --复合元素区分
			, CHEM_MIN         --成分最小值
			, CHEM_MAX         --成分最大值
		    , REG_ID
		    , REG_DTIME 
			) VALUES(?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
	</query>
	
	<query   id="UIB010051_01.UPDATE" desc="更新成分最大、最小值、目标值信息">
			UPDATE      TBB01_TAFAC_INGR 
		    SET 
		                CHEM_MIN         =   ?    --成分最小值
			           ,CHEM_MAX         =   ?    --成分最大值
					   ,COMP_YN          =   ?    --复合元素区分	
					   ,MOD_ID           =   ?
		               ,MOD_DTIME        =   TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')	
			WHERE       TAFAC_STL_GRD    =   ?    --目标钢号
			AND         CHEM_CD          =   ?    --成分
	</query>	
	
	<query id="UIB010051_01.CALL" desc="牌号复制">
		{call ZL_NORM_MANAGE.COPY_FAC_STLGRDSP1(?,?,?,?)}
	</query>	
</queryMap>