XinYu_RZMES/.svn/pristine/c5/c5e1e11d2b29fb0d7773167cc2f8e6f36e89e1ad.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="品质设计结果之生产规范查询">
	<query id="UIB015060_01.SELECT" desc="" fetchSize="10">  
        <![CDATA[
			SELECT  T2.PROD_CD
                 ,T1.PROD_CD_CFNM
                 ,T2.DSN_KIND
                 ,T2.PROD_TYPE
                 ,T2.DCS_SYM
                 ,T2.PROD_VAL
                 ,T2.MEMO
                 ,T2.PROD_VAL_EXP1
                 ,T2.PROD_VAL_EXP2
                 ,T2.PROD_VAL_EXP3
	        FROM   TBB01_SEQ_PROD   T1 , TBB01_DSN_TECH  T2 
	        WHERE  T1.PROD_CD = T2.PROD_CD AND ORD_NO = ? AND ORD_SEQ = ?	
			ORDER BY   DECODE(T2.PROD_TYPE, NULL , 1 , 0) , T1.DISPLAY_SEQ
		]]>
	</query>
	<query id="UIB015060_02.SELECT" desc="" fetchSize="10">  
        <![CDATA[
			SELECT  T2.PROD_CD
                 ,T1.PROD_CD_CFNM
                 ,T2.DSN_KIND
                 ,T2.PROD_TYPE
                 ,T2.DCS_SYM
                 ,T2.PROD_VAL
                 ,T2.MEMO
                 ,T2.PROD_VAL_EXP1
                 ,T2.PROD_VAL_EXP2
                 ,T2.PROD_VAL_EXP3
	        FROM   TBB01_SEQ_PROD   T1 , TBB01_ORD_TECH  T2  
	        WHERE  T1.PROD_CD = T2.PROD_CD AND ORD_NO = ? AND ORD_SEQ = ?	
			ORDER BY   DECODE(T2.PROD_TYPE, NULL , 1 , 0) , T1.DISPLAY_SEQ
		]]>
	</query>

	<query id="UIB015060_01.UPDATE" desc="" fetchSize="10">
		update TBB01_DSN_DEL set
		DEL_TOL_THK_MIN = ?,DEL_TOL_THK_MAX =?,
		DEL_TOL_WTH_MIN =?,DEL_TOL_WTH_MAX =?,
		DEL_TOL_EVEN_MAX =?,DEL_TOL_ANGLE_MAX =?,DEL_TOL_CAMBER_MAX =?
		where ORD_NO =? and ORD_SEQ=? and DSN_KIND = '1'  
	</query>

	<query id="UIB015060_02.UPDATE" desc="" fetchSize="10">
		update TBB01_ORD_DEL set
		DEL_TOL_THK_MIN = ?,DEL_TOL_THK_MAX =?,
		DEL_TOL_WTH_MIN =?,DEL_TOL_WTH_MAX =?,
		DEL_TOL_EVEN_MAX =?,DEL_TOL_ANGLE_MAX =?,DEL_TOL_CAMBER_MAX =?
		where ORD_NO =? and ORD_SEQ=? and DSN_KIND = '1'
	</query>
</queryMap>