XinYu_RZMES/.svn/pristine/0d/0d3dc5f96d3ad7c207e5ff86c8fd5174a8307065.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="品质设计结果之生产规范（分）">
    <query id="UIB015050_01.SELECT" desc="炼钢制造标准" fetchSize="10">   
        <![CDATA[
		select CAS_DEF,LF_DEF,RH_DEF,SF_DEF
		,SQ_QD_COMMON.COMMCD_CDTOCFNM('G03005',SF_METHOD) SF_METHOD
		,SMS_HCR_DEF,SMS_7_DEF 
		from TBB01_DSN_PROD
		WHERE ord_no = ? and ord_seq = ?
		]]>   
    </query>
	<query id="UIB015050_02.SELECT" desc="轧钢制造标准" fetchSize="10">   
        <![CDATA[
		select SQ_QD_COMMON.COMMCD_CDTOCFNM('B01118',MET_DEF) MET_DEF,UST_DEF,SPM_DEF,OIL_DEF,SPECIALMGMT_MSG1,SPECIALMGMT_MSG2 
		from TBB01_DSN_PROD
		WHERE ord_no = ? and ord_seq = ?
		]]>   
    </query>
	<query id="UIB015050_03.SELECT" desc="轧钢制造标准" fetchSize="10">   
        <![CDATA[
			select THK_AIM,HOT_THK_AIM,HOT_THK_MIN,HOT_THK_MAX,WTH_AIM,WTH_MIN,WTH_MAX from TBB01_DSN_PROD 
			where ord_no = ? and ord_seq = ?
		]]>   
    </query> 
	<query id="UIB015050_04.SELECT" desc="" fetchSize="10">   
        <![CDATA[
		select CAS_DEF,LF_DEF,RH_DEF,SF_DEF
		,SQ_QD_COMMON.COMMCD_CDTOCFNM('G03005',SF_METHOD) SF_METHOD
		,SMS_HCR_DEF,SMS_7_DEF 
		from TBB01_ORD_PROD
		WHERE ord_no = ? and ord_seq = ?
		]]>   
    </query> 
	<query id="UIB015050_05.SELECT" desc="" fetchSize="10">   
        <![CDATA[
		select SQ_QD_COMMON.COMMCD_CDTOCFNM('B01118',MET_DEF) MET_DEF,UST_DEF,SPM_DEF,OIL_DEF,SPECIALMGMT_MSG1,SPECIALMGMT_MSG2 
		from TBB01_ORD_PROD
		WHERE ord_no = ? and ord_seq = ?
		]]>   
    </query> 
	<query id="UIB015050_06.SELECT" desc="" fetchSize="10">   
        <![CDATA[
			select THK_AIM,HOT_THK_AIM,HOT_THK_MIN,HOT_THK_MAX,WTH_AIM,WTH_MIN,WTH_MAX from TBB01_ORD_PROD 
			where ord_no = ? and ord_seq = ?
		]]>   
    </query>
    
    <query id="UIB015050_07.SELECT" desc="冷轧工序">
    	SELECT      ONLY_WASH
		           ,PICK_TP
		           ,ANNE_TP
		           ,GALV_TP
		           ,COAT_TP
		           ,REWG_TP
		           ,ACID_PROD_PATH
		           --,C_SPM_TP
		FROM       TBB01_DSN_PROD   T 
		WHERE      T.ORD_NO         =   ?
		AND        T.ORD_SEQ        =   ?	
    </query>
    
    <query id="UIB015050_08.SELECT" desc="冷轧工序">
    	SELECT      ONLY_WASH
		           ,PICK_TP
		           ,ANNE_TP
		           ,GALV_TP
		           ,COAT_TP
		           ,REWG_TP
		           ,ACID_PROD_PATH
		     --      ,C_SPM_TP
		FROM       TBB01_ORD_PROD   T 
		WHERE      T.ORD_NO         =   ?
		AND        T.ORD_SEQ        =   ?	
    </query>
    
	<query id="UIB015050_01.UPDATE" desc="" fetchSize="10">   
        <![CDATA[
			update TBB01_DSN_PROD set LF_DEF = ? ,RH_DEF = ? ,SF_DEF=?,SF_METHOD = ?,SMS_HCR_DEF = ?
			where ord_no = ? and ord_seq = ? 
		]]>   
    </query>  
   <query id="UIB015050_02.UPDATE" desc="" fetchSize="10">   
        <![CDATA[
			update TBB01_DSN_PROD set UST_DEF =?,SPM_DEF =?,OIL_DEF =?,SPECIALMGMT_MSG1 =?,SPECIALMGMT_MSG2 =?  
			where ord_no = ? and ord_seq = ? 
		]]>   
    </query>  
   <query id="UIB015050_03.UPDATE" desc="" fetchSize="10">   
        <![CDATA[
			update TBB01_DSN_PROD set THK_AIM =?,HOT_THK_AIM =?,HOT_THK_MIN =?,HOT_THK_MAX =?,WTH_AIM =?,WTH_MIN =?,WTH_MAX =?
			where ord_no = ? and ord_seq = ?  
		]]>   
    </query>  
   <query id="UIB015050_04.UPDATE" desc="" fetchSize="10">   
        <![CDATA[
			update TBB01_ORD_PROD set LF_DEF = ? ,RH_DEF = ? ,SF_DEF=?,SF_METHOD = ?,SMS_HCR_DEF = ?
			where ord_no = ? and ord_seq = ?
		]]>   
    </query>  
   <query id="UIB015050_05.UPDATE" desc="" fetchSize="10">   
        <![CDATA[
			update TBB01_ORD_PROD set UST_DEF =?,SPM_DEF =?,OIL_DEF =?,SPECIALMGMT_MSG1 =?,SPECIALMGMT_MSG2 =?  
			where ord_no = ? and ord_seq = ? 
		]]>   
    </query>  
   <query id="UIB015050_06.UPDATE" desc="" fetchSize="10">   
        <![CDATA[
			update TBB01_ORD_PROD set THK_AIM =?,HOT_THK_AIM =?,HOT_THK_MIN =?,HOT_THK_MAX =?,WTH_AIM =?,WTH_MIN =?,WTH_MAX =?
			where ord_no = ? and ord_seq = ?
		]]>   
    </query>  
</queryMap>