XinYu_RZMES/.svn/pristine/e7/e79ddc3e21ef4f09a1408322cc174cee6a18c40a.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="标准规范参数录入">
	
	<query id="UIB010302_01.INITSELECT" desc="标准钢号初始化，从标准成分处带来" fetchSize="10">
		SELECT      DISTINCT 
					SIR.SPEC_STL_GRD    LABEL
				  , SIR.SPEC_STL_GRD    VALUE
		FROM        TBB01_SPEC_INGR     SIR
		ORDER BY    SIR.SPEC_STL_GRD
	</query>
	<query id="UIB010302_02.INITSELECT" desc="标准号初始化" fetchSize="10">
		SELECT     DISTINCT
                   A.SM_CD           LABEL    --标准名称 
                  ,A.SM_CD           VALUE
        FROM       TBZ00_COMMCD   A
        WHERE      LG_CD          =  'B01001'
        ORDER BY   A.SM_CD
	</query>

    <query id="UIB010302_01.SELECT" desc="标准号查询" fetchSize="10">   
        <![CDATA[
        SELECT 
         T.SM_CD        LABEL
        ,T.SM_CD        VALUE 
        FROM            TBZ00_COMMCD   T 
        WHERE           T.LG_CD        =    'B01001'
        ORDER  BY       T.SM_CD 	
        ]]>   
    </query> 
	<query id="UIB010302_02.SELECT" desc="" fetchSize="10">   
        <![CDATA[
		  SELECT            DISTINCT
	      T.PRDNM_CD,       --交货状态
      	  T.SPEC_ABBSYM,    --标准号
		  T.SPEC_STL_GRD   --规格钢号
		  FROM              TBB01_SPEC_TECH     T
		  WHERE             T.SPEC_ABBSYM       =   DECODE(? , NULL , T.SPEC_ABBSYM   , ?)
		  AND               T.SPEC_STL_GRD      =   DECODE(? , NULL , T.SPEC_STL_GRD  , ?)
		  ORDER BY          T.SPEC_STL_GRD 
        ]]>    
    </query> 
	
	<query id="UIB010302_04.SELECT" fetchSize="" desc="">
		SELECT * FROM TBB01_SEQ_PROD T ORDER BY T.DISPLAY_SEQ
	</query>
	
	<query id="UIB010302_11.SELECT" fetchSize="" desc="该项目是否存在">
		SELECT   SPEC_ABBSYM
        FROM     TBB01_SPEC_TECH
        WHERE    PRDNM_CD         =   ? 
		AND      SPEC_ABBSYM      =   ? 
		AND      SPEC_STL_GRD     =   ? 
		AND      PROD_CD          =   ? 
	</query>
	<query id="UIB010302_12.SELECT" fetchSize="" desc="">
    	SELECT      T1.PROD_CD
                   ,T1.PROD_CD_CFNM
                   ,T1.PROD_TYPE
                   ,T1.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_SPEC_TECH  T2
        WHERE      T1.PROD_CD             =    T2.PROD_CD(+)
        AND        T2.PRDNM_CD(+)         =    ?
        AND        T2.SPEC_ABBSYM(+)      =    ?
        AND        T2.SPEC_STL_GRD(+)     =    ?
		ORDER BY   DECODE(T2.PROD_VAL, NULL , 1 , 0) , T1.DISPLAY_SEQ
	</query>
	
	<query id="UIB010302_01.INSERT" fetchSize="" desc="">
		INSERT   INTO   TBB01_SPEC_TECH(  --规范代码录入
    	                PRDNM_CD,
		                SPEC_ABBSYM,
						SPEC_STL_GRD,
						PROD_CD,
						PROD_TYPE,
						DCS_SYM,
						PROD_VAL,
						MEMO,
						REG_ID,
						REG_DTIME  
		) VALUES(?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'))
	</query>
	
	<query id="UIB010302_02.UPDATE" fetchSize="" desc="">
		UPDATE    TBB01_SPEC_TECH 
		SET       PROD_VAL      =   ?,
		          MEMO      =   ?,
		          MOD_ID        =   ?,         
		          MOD_DTIME     =   TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')  --修改日期
		WHERE     PRDNM_CD      =   ? 
		AND       SPEC_ABBSYM   =   ? 
		AND       SPEC_STL_GRD  =   ? 
		AND       PROD_CD       =   ? 
	</query>
	
	<query id="UIB010302_01.DELETE" fetchSize="" desc="删除某标准信息">
		DELETE FROM TBB01_SPEC_TECH WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD=? 
	</query>
	
	<query id="UIB010302_02.DELETE" fetchSize="" desc="删除某项目">
		DELETE FROM TBB01_SPEC_TECH WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD= ?  AND  PROD_CD = ? 
	 </query>
</queryMap>