XinYu_RZMES/.svn/pristine/75/75a2b00c735d48c24de32f476bdcaf625ee16740.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="客户材质参数录入">

	
	<query id="UIB010130_01.INITSELECT">
		SELECT SMP_LOT_CD SM_CD, SMP_LOT_DETAIL SM_CFNM FROM TBB02_SMP_CODE ORDER BY SM_CFNM
		--试样LOT重量	
	</query>
	
	<query id="UIB010130_02.INITSELECT">
		SELECT SM_CD,SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'B01102'
		UNION ALL 
		SELECT '' , '' FROM DUAL
			--试样长度方向位置	
	</query>
	
	<query id="UIB010130_03.INITSELECT">
		SELECT SM_CD,SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'B01103'
		UNION ALL 
		SELECT '' , '' FROM DUAL
			--试样宽度方向位置		
	</query>
	
    <query id="UIB010130_01.SELECT" desc="" fetchSize="10">   
        <![CDATA[
			SELECT DISTINCT 
			'N' CHK                                   --防止被选择后再次查询后没有去掉选择
		  , SUBSTR(CUST_SPEC_NO , 1 , 6) CUST_CD      --客户公司代码
		  , SUBSTR(CUST_SPEC_NO , 7 , 2) PRDNM_CD     --品名
		  , SUBSTR(CUST_SPEC_NO , 9 , 2) SEQ          --序号
		  , SUBSTR(CUST_SPEC_NO , 11)	 PROD_LINE    --产线
		  , SPEC_STL_GRD                              --对应的标准号
		  ,PKG_QUALITY_COMM.FIB020202(SUBSTR(CUST_SPEC_NO , 1 , 6))   CUST_NM	
			FROM                  TBB01_CUST_QLTY
			WHERE                 CUST_SPEC_NO        LIKE     ?||'%'
			ORDER BY  CUST_CD , PRDNM_CD , SEQ
        ]]>   
    </query> 
	<query id="UIB010130_02.SELECT" desc="" fetchSize="">
		  SELECT    
		  T1.QLTY_CD 
         ,T1.QLTY_CD_CFNM
         ,T1.QLTY_MIN_TP
         ,T1.QLTY_MAX_TP
         ,T1.QLTY_UNIT_TP
         ,T1.QLTY_TYPE
         ,T2.QLTY_MIN
         ,T2.QLTY_MAX
         ,T2.QLTY_UNIT
		 ,T2.QLTY_DETAIL 
		 ,T2.QLTY_DEC_CD
		  FROM          TBB01_SEQ_QLTY    T1   ,    TBB01_CUST_QLTY   T2
		  WHERE         T1.QLTY_CD            =     T2.QLTY_CD(+)
		  AND           T2.CUST_SPEC_NO(+)    =     NVL(?||?||?||? , 'X')
		  ORDER BY      DECODE(T2.QLTY_MIN||T2.QLTY_MAX||T2.QLTY_UNIT , NULL , 1 , 0) , T1.DISPLAY_SEQ
	</query>
	
	<query id="UIB010130_03.SELECT"  fetchSize="判断某项目是否存在" >
	      SELECT * FROM TBB01_CUST_QLTY T WHERE  T.QLTY_CD = ?  AND T.CUST_SPEC_NO = ?
	</query>
	
	<query id="UIB010130_04.SELECT" desc="取样信息查询">
		  SELECT SMP_LOT_CD , SMP_LEN_LOC , SMP_WTH_LOC FROM TBB01_CUST_QLTY T WHERE  T.QLTY_CD = 'SAMP'  AND T.CUST_SPEC_NO = NVL(?||?||?||? , 'X')
	</query>
		
	<query id="UIB010130_01.INSERT" desc="" fetchSize="">
		 INSERT      INTO    TBB01_CUST_QLTY(
   	     CUST_SPEC_NO
		,QLTY_CD
		,QLTY_MIN
		,QLTY_MAX
		,QLTY_DEC_CD
		,QLTY_UNIT
		,QLTY_TYPE
		,QLTY_DETAIL
		,SPEC_STL_GRD
		,REG_ID
		,REG_DTIME
		) VALUES(?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
	</query>
		
	<query id="UIB010130_02.INSERT" desc="取样方法">
		INSERT      INTO    TBB01_CUST_QLTY(
   	     CUST_SPEC_NO
		,QLTY_CD
		,SMP_LOT_CD
		,SMP_LEN_LOC
		,SMP_WTH_LOC
		,REG_ID
		,REG_DTIME)
		VALUES(?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
	</query>
	
	<query id="UIB010130_01.UPDATE" desc="" fetchSize="">
		 UPDATE    TBB01_CUST_QLTY   T
      	 SET       T.QLTY_MIN        =       ?
				  ,T.QLTY_MAX        =       ?
				  ,T.QLTY_UNIT       =       ?
				  ,T.QLTY_TYPE       =       ?
		          ,T.QLTY_DEC_CD     =       ? 
				  ,T.QLTY_DETAIL     =       ?
				  ,T.MOD_ID          =       ?
				  ,T.MOD_DTIME       =       TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
		  WHERE    T.CUST_SPEC_NO    =       ?
		  AND      T.QLTY_CD         =       ? 
	</query>
	
	<query id="UIB010130_02.UPDATE"  desc="取样方法">
		 UPDATE    TBB01_CUST_QLTY   T
      	 SET       T.SMP_LOT_CD      =       ?
				  ,T.SMP_LEN_LOC     =       ?
				  ,T.SMP_WTH_LOC     =       ?
				  ,T.MOD_ID          =       ?
				  ,T.MOD_DTIME       =       TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
		  WHERE    T.CUST_SPEC_NO    =       ?
		  AND      T.QLTY_CD         =       'SAMP'   
	</query>
	
	<query id="UIB010130_01.DELETE" desc="" fetchSize="">
		DELETE FROM TBB01_CUST_QLTY WHERE CUST_SPEC_NO = ?
	</query>

	<query id="UIB010130_02.DELETE" desc="" fetchSize="">
		 DELETE  FROM TBB01_CUST_QLTY  WHERE  CUST_SPEC_NO = ?  AND  QLTY_CD = ?
	</query>
	
	
</queryMap>