XinYu_RZMES/.svn/pristine/a3/a36e9c0e02cec7b16c60c38e0ff1505db304ae4d.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="内控成分录入">
	
	<query id="UIB010052_01.INITSELECT" desc="查询所有炼浇钢种组中的牌号" fetchSize="10">
        <![CDATA[
		SELECT     DISTINCT
                   FAC_STL_GRD     LABEL
                  ,FAC_STL_GRD     VALUE
         FROM      TBD00_STLGRD
         UNION     ALL
         SELECT    'ALL'   LABEL
                   ,''     VALUE
         FROM      DUAL
         ORDER BY  VALUE DESC
        ]]>
    </query>
	
	<query id="UIB010052_02.INITSELECT" desc="无成分的牌号">
		SELECT A.FAC_STL_GRD LABEL , A.FAC_STL_GRD  VALUE FROM TBD00_STLGRD  A
        MINUS 
        SELECT DISTINCT  B.FAC_STL_GRD LABEL , B.FAC_STL_GRD VALUE FROM TBB01_FAC_INGR B
	</query>
	
	<query id="UIB010052_01.SELECT" desc="查询到grid1中">
		SELECT          DISTINCT 
                        T.FAC_STL_GRD  
                       ,T.FAC_CODE    
        FROM            TBB01_FAC_INGR T
		WHERE           T.FAC_STL_GRD        LIKE        ?||'%'
		AND             T.FAC_CODE           LIKE        ?||'%'
        ORDER    BY     T.FAC_STL_GRD
	</query>
	
	<query id="UIB010052_02.SELECT" desc="查询非符合元素">
	  SELECT  
      a.CHEM_CD
    , ''        COMP_YN 
    , b.CHEM_AIM
    , b.CHEM_MAX 
    , b.CHEM_MIN 
      FROM  TBB01_SEQ_INGR   A  ,  TBB01_FAC_INGR b 
      WHERE  a.CHEM_CD            =   b.CHEM_CD(+)  
      AND    A.COMP_YN            =   'N'
      AND    b.FAC_STL_GRD(+)     =   ?        --按隐藏的客户公司代码查询（界面UIB010052的表1中的）
      AND    FAC_CODE(+)          =   ?
      ORDER BY decode(b.CHEM_AIM||b.CHEM_MAX || b.CHEM_MIN, null, 1, 0), a.DISPLAY_SEQ
	</query>
	
	<query id="UIB010052_03.SELECT" desc="查询复合元素">
	  SELECT  
      a.CHEM_CD
    , A.COMP_DETAIL
    , A.COMP_CAL	
    , 'Y'            COMP_YN
    , b.CHEM_AIM
    , b.CHEM_MAX 
    , b.CHEM_MIN 
      FROM  TBB01_SEQ_INGR   A  ,  TBB01_FAC_INGR b 
      WHERE  a.CHEM_CD              =    b.CHEM_CD(+)  
      AND    A.COMP_YN              =    'Y'
      AND    b.FAC_STL_GRD(+)       =    ?        
	  AND    b.FAC_CODE(+)          =    ?
      ORDER BY decode(b.CHEM_AIM||b.CHEM_MAX || b.CHEM_MIN, null, 1, 0), a.DISPLAY_SEQ
	</query>
	
	<query id="UIB010052_04.SELECT" desc="说明">
	  SELECT       T.FAC_DETAIL 
	  FROM         TBB01_FAC_INGR T 
	  WHERE        T.FAC_STL_GRD        =     ? 
	  AND          T.FAC_CODE           =     ?   
	  AND          T.CHEM_CD            =     'XYZ'	
	</query>
	
	<query id="UIB010052_05.SELECT" desc="判断某元素是否存在，存在则UPDATE，否则INSERT">
		SELECT T.FAC_STL_GRD FROM TBB01_FAC_INGR  T   WHERE T.FAC_STL_GRD = ? AND T.FAC_CODE  = ? AND T.CHEM_CD = ?
	</query>
	
	<query id="UIB010052_01.INSERT" desc="插入新的元素">
		INSERT      INTO      TBB01_FAC_INGR(
		                      FAC_STL_GRD 
		                    , FAC_CODE 
		                    , CHEM_CD 
		                    , COMP_YN 
		                    , CHEM_AIM 
		                    , CHEM_MIN 
		                    , CHEM_MAX 
		                    , REG_ID 
		                    , REG_DTIME)
        VALUES(?,? ,? , ? , ? , ? ,?, ? , TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') )
	</query>
	
	<query id="UIB010052_01.UPDATE" desc="更新元素的值">
		UPDATE          TBB01_FAC_INGR           T
        SET             T.CHEM_AIM               = ?
                       ,T.CHEM_MIN               = ?
                       ,T.CHEM_MAX               = ?
		               ,T.MOD_ID                 = ?
                       ,T.MOD_DTIME              = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
        WHERE           T.FAC_STL_GRD            = ?
        AND             T.FAC_CODE               = ?   
		AND             T.CHEM_CD                = ? 
	</query>
	
	<query id="UIB010052_02.UPDATE" desc="备注">
		UPDATE     TBB01_FAC_INGR    T
        SET        T.FAC_DETAIL      =    ? 
        WHERE      T.FAC_STL_GRD     =    ?
        AND        T.FAC_CODE        =    ?
	</query>
	
	<query id="UIB010052_01.DELETE" desc="删除某元素">
		DELETE   FROM   TBB01_FAC_INGR  T  WHERE T.FAC_STL_GRD   =  ?  AND T.FAC_CODE   =   ?  AND T.CHEM_CD = ?
	</query>
	
	<query id="UIB010052_02.DELETE" desc="删除牌号">
		DELETE   FROM   TBB01_FAC_INGR  T  WHERE T.FAC_STL_GRD   =  ?  AND T.FAC_CODE   =   ? 
	</query>
	
	<query id="UIB010052_01.CALL" desc="复制内控或者炼钢放行成分">
		{call ZL_NORM_MANAGE.COPY_FAC_STLGRD(?,?,?,?,?,?)}
	</query>
	
	<query id="UIB010052_02.CALL" desc="厂内牌号发生变动时，发送信息到L2表格中">
		   {call NIB015051(?,?,?,?)}
	</query>
	
	<query id="UIB010052_03.CALL" desc="增加牌号备注信息">
		   {call ZL_NORM_MANAGE.SAVE_FACS_REMK(?,?,?,?,?)}
	</query>
</queryMap>