XinYu_RZMES/.svn/pristine/9a/9ad92ca7c2e840e1e926bada13bd7fa9f27499a5.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="SampLing_Lot录入（暂废）">
	
    <query id="UIB010191_01.INITSELECT" desc="标准号，初始化页面" fetchSize="10">  
        <![CDATA[
			SELECT   DISTINCT 
			         DECODE(DC.SPEC_ABBSYM , NULL ,'---'||SQ.SPEC_ABBSYM , '(有)'||SQ.SPEC_ABBSYM)  LABEL
			       , SQ.SPEC_ABBSYM       VALUE
            FROM     TBB01_SPEC_QLTY SQ , TBB02_DEF_CONV  DC  
            WHERE    SQ.SPEC_ABBSYM    =  DC.SPEC_ABBSYM(+) 
        ]]>   
    </query> 
	
	<query id="UIB010191_02.INITSELECT" desc="查询试片LOT代码">
		 SELECT 
		 'N' CHK
		, SMP_LOT_CD 
		, SMP_LOT_WGT 
		, SMP_LOT_CNT 
		, SMP_LOT_DETAIL     
		  FROM 
		  TBB02_SMP_CODE
	</query>
	
	<query id="UIB010191_01.SELECT" desc="">
		SELECT        DISTINCT
					  SQ.QLTY_CD
					, SQY.QLTY_CD_CFNM
		FROM          TBB01_SPEC_QLTY SQ    , TBB01_SEQ_QLTY  SQY
		WHERE         SQ.QLTY_CD      =   SQY.QLTY_CD
		AND           SQ.PRDNM_CD     =   'AR'
		AND           SQ.SPEC_ABBSYM  like  ?
	</query>
	
	<query id="UIB010191_02.SELECT" desc=" 获得各标准号的材质的取样方式">
		SELECT          'N' CHK , PRDNM_CD   ,  SPEC_ABBSYM  {1}
		FROM            TBB02_DEF_CONV
		WHERE           SPEC_ABBSYM   LIKE    ?
		GROUP  BY       PRDNM_CD , SPEC_ABBSYM
	</query>
	
	<query id="UIB010191_02.LOOP" desc="循环中调用">
		, max(decode(QLTY_CD , '{1}' , SMP_LOT_CD))  {2}
	</query>
	
	<query id="UIB010191_03.SELECT"  desc="无话可说">
		SELECT        DISTINCT
					  SQ.QLTY_CD
					, SQY.QLTY_CD_CFNM
		FROM          TBB01_SPEC_QLTY SQ    , TBB01_SEQ_QLTY  SQY
		WHERE         SQ.QLTY_CD      =   SQY.QLTY_CD
		AND           SQ.PRDNM_CD     =   'AR'
		AND           SQ.SPEC_ABBSYM  like  ?
	</query>
	
	<query id="UIB010191_04.SELECT" desc="同上">
			SELECT     
		    SQ.SPEC_STL_GRD 
          , SQ.ORD_USE_TP 
          , SQ.THK_MIN
          , SQ.THK_MAX
		    {1} 
          , MAX(decode(SQ.QLTY_CD , 'SAMP' , SQ.SMP_LOT_CD||SQ.SMP_LEN_LOC||SQ.SMP_WTH_LOC ))       SAMP 
			 FROM         TBB01_SPEC_QLTY SQ   , TBB02_DEF_CONV DC
			 WHERE        SQ.SPEC_ABBSYM  =   DC.SPEC_ABBSYM(+)
		     AND          SQ.PRDNM_CD     =   DC.PRDNM_CD(+)
		     AND          SQ.QLTY_CD      =   DC.QLTY_CD(+)
		     AND          SQ.SPEC_ABBSYM  LIKE    ?
			 AND          SQ.PRDNM_CD     =   'AR'
		     GROUP  BY    SQ.SPEC_STL_GRD 
          				, SQ.ORD_USE_TP 
						, SQ.THK_MIN
						, SQ.THK_MAX
		</query>
	
	<query id="UIB010191_04.LOOP" desc="循环调用">
		, max(decode(DC.QLTY_CD , '{1}' , DC.SMP_LOT_CD))  LOTCD{2}
	</query>
	
	<query id="UIB010191_05.SELECT" desc="">
		SELECT 1 FROM TBB02_DEF_CONV WHERE  PRDNM_CD = ? AND  SPEC_ABBSYM = ? AND  QLTY_CD = ?
	</query>
	
	<query id="UIB010191_01.INSERT" desc="">
		INSERT INTO TBB02_DEF_CONV(PRDNM_CD , SPEC_ABBSYM , QLTY_CD , SMP_LOT_CD)  VALUES(?,?,?,?)
	</query>
	
	<query id="UIB010191_01.UPDATE" desc="">
		UPDATE     TBB02_DEF_CONV
		SET        SMP_LOT_CD      =  ?
		WHERE      PRDNM_CD        =  ?
		AND        SPEC_ABBSYM     =  ?
		AND        QLTY_CD         =  ?
	</query>
	
	<query id="UIB010191_01.DELETE" desc="">
		DELETE FROM   TBB02_DEF_CONV       
		WHERE         PRDNM_CD       =  ?
		AND           SPEC_ABBSYM    =  ?
		AND           QLTY_CD        =  ?
	</query>
	
</queryMap>