XinYu_RZMES/.svn/pristine/ff/ff4389b017282e9d16979ae4859a83366d637860.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Design-key">
	
	<query id="UIB010320_01.INITSELECT" desc="交货状态">
			SELECT T.SM_CD VALUE , T.SM_CFNM LABEL FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01118' 
	</query>	
	
	<query id="UIB010320_02.INITSELECT" desc="标准号">
			SELECT SM_CD VALUE,SM_CD LABEL FROM tbz00_commcd WHERE lg_cd = 'B01001'   ORDER BY SM_CD	
	</query>	
	<query id="UIB010320_03.INITSELECT" desc="标准钢号">
			SELECT DISTINCT SPEC_STL_GRD VALUE,SPEC_STL_GRD LABEL  FROM TBB01_SPEC_INGR ORDER BY SPEC_STL_GRD 
	</query>	
	<query id="UIB010320_04.INITSELECT" desc="产品名称">
		   SELECT SM_CD VALUE,SM_CFNM LABEL FROM TBZ00_COMMCD WHERE LG_CD = 'A01007'  AND UPPER(USED_YN) = 'Y' ORDER BY SM_CFNM
	</query>	
	<query id="UIB010320_05.INITSELECT" desc="厂内钢号">
		 
		   SELECT DISTINCT FAC_STL_GRD VALUE,FAC_STL_GRD LABEL FROM TBB01_FAC_INGR ORDER BY FAC_STL_GRD
	</query>		
	<query id="UIB010320_06.INITSELECT" desc="轧钢规范">
		   SELECT MILL_STD_NO VALUE,MILL_STD_NO LABEL FROM TBB01_MILL_PROD ORDER BY MILL_STD_NO
	</query>
	<query id="UIB010320_07.INITSELECT" desc="炼钢规范">
		   SELECT SMS_STD_NO VALUE,SMS_STD_NO LABEL FROM TBB01_SMS_PROD ORDER BY SMS_STD_NO
	</query>
	
	<query id="UIB010320_08.INITSELECT" desc="交付条件标准号">
			SELECT DISTINCT DEV_SPEC_CD LABEL,DEV_SPEC_CD VALUE FROM TBB01_SPEC_DEL WHERE CUST_TP='1' ORDER BY DEV_SPEC_CD
	</query>
	
	<query id="UIB010320_09.INITSELECT" desc="">
			SELECT SM_CD VALUE,SM_CFNM LABEL FROM TBZ00_COMMCD WHERE LG_CD = 'B01119' AND UPPER(USED_YN) = 'Y' ORDER BY SM_CD
	</query>
	
	<query id="UIB010320_10.INITSELECT" desc="规格对应码">
			SELECT DISTINCT T.SIZE_SPEC_CD LABEL  , T.SIZE_SPEC_CD VALUE FROM TBB01_HCMAP_SIZE T
	</query>
	
	<query id="UIB010320_01.SELECT" desc="Design-key现状查询">
		<![CDATA[
			   SELECT 
			   'N'           CHK	
			,  PROD_LINE
			,  PROD_LINE     PROD_LINE1      --产线   
			,  PRDNM_CD                      --品名
			,  PRDNM_CD      PRDNM_CD1    
			,  SPEC_ABBSYM                   --标准号
			,  SPEC_ABBSYM   SPEC_ABBSYM1
			,  THK_MIN                       --厚度最小值 
			,  THK_MIN       THK_MIN1                             
			,  THK_MAX                       --厚度最大值
			,  THK_MAX       THK_MAX1
			,  WTH_MIN                       --宽度最小值
			,  WTH_MIN       WTH_MIN1
			,  WTH_MAX                       --宽度最大值
			,  WTH_MAX       WTH_MAX1  
			,  ORD_USE_TP                    --订单用途
			,  ORD_USE_TP    ORD_USE_TP1
			,  PKG_QUALITY_COMM.FZ00_COMM('A01007' , ORD_USE_TP)  ORD_USE
			,  SPEC_STL_GRD                  --标准牌号   
			,  SPEC_STL_GRD  SPEC_STL_GRD1      
			,  FAC_STL_GRD                   --厂内钢号
			,  SMS_STD_NO                    --炼钢生产编码规范
			,  MILL_STD_NO                   --轧钢生产编码规范
			,  C_PRDNM_CD
			,  C_SPEC_ABBSYM
			,  C_SPEC_STL_GRD
			,  C_ORD_USE_TP
			,  PKG_QUALITY_COMM.FZ00_COMM('A01007' , C_ORD_USE_TP)  C_ORD_USE
			,  COLD_STD_NO
			,  SIZE_SPEC_CD
			,  REG_ID
			,  REG_DTIME
			,  MOD_ID
			,  MOD_DTIME
			   FROM        TBB01_KEY_PROD  
			   WHERE       SPEC_ABBSYM       =     DECODE(? , NULL , SPEC_ABBSYM  , ?)
               AND         SPEC_STL_GRD      =     DECODE(? , NULL , SPEC_STL_GRD , ?)
			   ORDER BY    SPEC_ABBSYM  , ORD_USE_TP ,SPEC_STL_GRD
		 ]]>
	</query>
	
	<query id="UIB010320_03.SELECT" desc="判断要插入的钢号是否存在">
		SELECT FAC_STL_GRD  FROM TBB01_FAC_INGR WHERE FAC_STL_GRD = ?
	</query>
	<query id="UIB010320_04.SELECT" desc="判断要插入的炼钢生产规范编码是否存在">
		SELECT SMS_STD_NO FROM TBB01_SMS_PROD WHERE SMS_STD_NO = ?
	</query>
	<query id="UIB010320_05.SELECT" desc="判断要插入的轧钢生产规范编码是否存在">
		SELECT MILL_STD_NO FROM TBB01_MILL_PROD WHERE MILL_STD_NO = ?
	</query>
	<query id="UIB010320_01.UPDATE" desc="更新">
		<![CDATA[
		    UPDATE  TBB01_KEY_PROD 
			SET 
			PROD_LINE	    = ?
		   ,PRDNM_CD        = ?
		   ,SPEC_ABBSYM     = ?
		   ,THK_MIN         = ?
		   ,THK_MAX         = ?
		   ,WTH_MIN         = ?
		   ,WTH_MAX         = ?
		   ,ORD_USE_TP      = ?
		   ,SPEC_STL_GRD    = ?
		   ,FAC_STL_GRD     = ?
		   ,SMS_STD_NO      = ?
		   ,MILL_STD_NO     = ? 
		   ,MOD_ID          = ?
		   ,MOD_DTIME       = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')	
		   ,C_PRDNM_CD      = ?
		   ,C_SPEC_ABBSYM   = ?
		   ,C_SPEC_STL_GRD  = ?
		   ,C_ORD_USE_TP	= ?	
		   ,COLD_STD_NO	    = ?
		   ,SIZE_SPEC_CD    = ?
			WHERE
			    PROD_LINE   = ?  
			AND PRDNM_CD    = ?
			AND SPEC_ABBSYM = ?
			AND THK_MIN     = ?
			AND THK_MAX     = ?
			AND WTH_MIN     = ?
			AND WTH_MAX     = ?
			AND ORD_USE_TP  = ?
			AND SPEC_STL_GRD= ?
		 ]]>
	</query>
	<query id="UIB010320_01.INSERT" desc="插入">
		 INSERT INTO TBB01_KEY_PROD(
		 PROD_LINE
		,PRDNM_CD
		,SPEC_ABBSYM
		,THK_MIN
		,THK_MAX
		,WTH_MIN
		,WTH_MAX
		,ORD_USE_TP
		,SPEC_STL_GRD
		,FAC_STL_GRD 
	    ,SMS_STD_NO  
	    ,MILL_STD_NO  
		,REG_ID
		,REG_DTIME
		,C_PRDNM_CD
		,C_SPEC_ABBSYM
		,C_SPEC_STL_GRD
		,C_ORD_USE_TP
		,COLD_STD_NO
		,SIZE_SPEC_CD
		)VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?,?,?,?,?,?)
	</query>
	<query id="UIB010320_01.DELETE" desc="删除">
			DELETE FROM TBB01_KEY_PROD WHERE 
			PRDNM_CD         = ?
			AND SPEC_ABBSYM  = ?
			AND THK_MIN      = ?
			AND THK_MAX      = ?
			AND WTH_MIN      = ?
			AND WTH_MAX      = ?
			AND ORD_USE_TP   = ?
			AND SPEC_STL_GRD = ?
			AND PROD_LINE    = ?
	</query>
</queryMap>