XinYu_RZMES/.svn/pristine/d4/d448f02435793e5a6f5542b5366b3f43f50a267f.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="客户要求录入">
    <query id="UIB010250_01.INITSELECT" desc="客户公司代码，初始化页面" fetchSize="10">  
        <![CDATA[
    	  SELECT A.CUST_CD VALUE , A.CUST_NM LABEL      FROM   TBZ00_CUSTOMER          A ,  
		  (
          SELECT SUBSTR(T1.CUST_SPEC_NO ,0 ,6 ) CUSTCD  FROM    TBB01_CUST_INGR    T1
          UNION 
          SELECT SUBSTR(T2.CUST_SPEC_NO ,0 ,6 )         FROM    TBB01_CUST_QLTY    T2
          UNION
          SELECT SUBSTR(T3.CUST_SPEC_NO ,0 ,6 )         FROM    TBB01_CUST_REQ     T3
          )  B
          WHERE       A.CUST_CD    =   B.CUSTCD
          ORDER BY    A.CUST_NM
        ]]>   
    </query> 
	
	<query id="UIB010250_02.INITSELECT" desc="">
		SELECT   DISTINCT  CUST_SPEC_NO      VALUE1  
		                  ,T.SPEC_STL_GRD    VALUE2			
		FROM     TBB01_CUST_INGR      T      WHERE      SUBSTR(T.CUST_SPEC_NO ,1,6)  =  SUBSTR(? , 1,6) 
	</query>
	
	<query id="UIB010250_03.INITSELECT" desc="">
		SELECT   DISTINCT  CUST_SPEC_NO       VALUE1  
		                  ,T.SPEC_STL_GRD     VALUE2
        FROM     TBB01_CUST_QLTY      T       WHERE     SUBSTR(T.CUST_SPEC_NO ,1,6)   =  SUBSTR(? , 1,6) 
	</query>
	
	<query id="UIB010250_04.INITSELECT" desc="">
		SELECT   DISTINCT   CUST_SPEC_NO      VALUE1  
		                   ,T.SPEC_STL_GRD    VALUE2 
	    FROM     TBB01_CUST_DEL       T       WHERE     SUBSTR(T.CUST_SPEC_NO ,1,6)   =  SUBSTR(? , 1,6) 
	</query>
	
	<query id="UIB010250_01.SELECT" desc="用于判断厂内钢号是否存在">
		SELECT DISTINCT FAC_STL_GRD from TBB01_FAC_INGR WHERE FAC_STL_GRD = ?
	</query>
	
	<query id="UIB010250_02.SELECT" desc="用于判断炼钢生产规范编码是否存在">
		SELECT DISTINCT SMS_STD_NO FROM TBB01_SMS_PROD WHERE  SMS_STD_NO = ?
	</query>
		
	<query id="UIB010250_03.SELECT" desc="用于判断轧钢生产规范编码是否存在">
		SELECT DISTINCT MILL_STD_NO FROM TBB01_MILL_PROD WHERE MILL_STD_NO = ?
	</query>
	
	<query id="UIB010250_04.SELECT" desc="多条件可选查询">
		 SELECT  
          'N'           CHK  
         ,CR.*
         ,CUST_SPEC_NO     CUST_SPEC_NO1   --客户参数号  
         ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , ORD_USE_TP)          ORD_USE
         ,PKG_QUALITY_COMM.FIB010204(CR.CUST_SPEC_NO)                INGR_REQ
         ,PKG_QUALITY_COMM.FIB010205(CR.CUST_SPEC_NO)                QLTY_REQ
         ,PKG_QUALITY_COMM.FIB020202(SUBSTR(CR.CUST_SPEC_NO , 1,6))  CUST_NM
          FROM        TBB01_CUST_REQ      CR
          WHERE       CUST_CD             =    DECODE(? , NULL , CUST_CD , ?)
          ORDER BY    CUST_SPEC_NO
	</query>
	
	<query id="UIB010250_01.INSERT" desc="插入新的记录">
		  INSERT        INTO      TBB01_CUST_REQ(
		  CUST_SPEC_NO    --客户参数号
		, CUST_SPEC_NO_INGR
		, CUST_SPEC_NO_QLTY
		, CUST_SPEC_NO_DEL  
		, CUST_CD         --客户公司代码 
		, SPEC_ABBSYM     --标准号
		, SPEC_STL_GRD    --标准钢号
		, THK_MIN         --厚度min
		, THK_MAX         --厚度max
		, WTH_MIN         --宽度min
		, WTH_MAX         --宽度max
		, ORD_USE_TP      --订单用途
		, FAC_STL_GRD     --厂内钢号
		, SMS_STD_NO      --炼钢生产规范
		, MILL_STD_NO     --轧钢生产规范
		, COLD_STD_NO     --冷轧生产规范
		, DEV_SPEC_CD     --交付条件
		, DEV_DGR_CD      --等级代码
		, SIZE_SPEC_CD    --尺寸对应码
		, REG_ID
		, REG_DTIME
		)
		VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'))
	</query>
	
	<query id="UIB010250_01.DELETE" desc="删除">
		DELETE FROM TBB01_CUST_REQ WHERE  CUST_SPEC_NO = ?
	</query>
	
	<query id="UIB010250_01.UPDATE" desc="更新">
		UPDATE     TBB01_CUST_REQ SET 
		  CUST_SPEC_NO          =  ?     --客户参数号
		, CUST_SPEC_NO_INGR     =  ?
		, CUST_SPEC_NO_QLTY     =  ?
		, CUST_SPEC_NO_DEL      =  ?
		, CUST_CD               =  ?     --客户公司代码
		, SPEC_ABBSYM           =  ?     --标准号
		, SPEC_STL_GRD          =  ?     --标准钢号
		, THK_MIN               =  ?      --厚度min
		, THK_MAX               =  ?      --厚度max
		, WTH_MIN               =  ?      --宽度min
		, WTH_MAX               =  ?      --宽度max
		, ORD_USE_TP            =  ?      --订单用途
		, FAC_STL_GRD           =  ?      --厂内钢号
		, SMS_STD_NO            =  ?      --炼钢生产规范
		, MILL_STD_NO           =  ?      --轧钢生产规范
		, COLD_STD_NO           =  ?
		, DEV_SPEC_CD           =  ?      --交付条件
		, DEV_DGR_CD            =  ?
		, SIZE_SPEC_CD          =  ?
		, MOD_ID                =  ?
		, MOD_DTIME             =  TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
		WHERE     CUST_SPEC_NO  =  ?
	</query>
	
	<query id="UIB010250_02.SPEC_ABBSYM" desc="标准号">
			SELECT SM_CD VALUE,SM_CD LABEL FROM tbz00_commcd WHERE lg_cd = 'B01001'  AND UPPER(USED_YN) = 'Y'	ORDER BY SM_CD
	</query>	
	
	<query id="UIB010250_02.SPEC_STL_GRD" desc="标准钢号">
			SELECT DISTINCT SPEC_STL_GRD VALUE,SPEC_STL_GRD LABEL  FROM TBB01_SPEC_INGR  ORDER BY SPEC_STL_GRD
	</query>	
	
	<query id="UIB010250_02.ORD_USE_TP" 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="UIB010250_02.FAC_STL_GRD" desc="厂内钢号">
		   SELECT '*' VALUE,'*' LABEL FROM DUAL
		   UNION ALL
	       SELECT * FROM (
	       SELECT DISTINCT FAC_STL_GRD VALUE,FAC_STL_GRD LABEL FROM TBB01_FAC_INGR ORDER BY FAC_STL_GRD)
	</query>		
	
	<query id="UIB010250_02.MILL_STD_NO" desc="轧钢规范">
		   SELECT '*' VALUE,'*' LABEL FROM DUAL
		   UNION ALL
		   SELECT * FROM(
	       SELECT MILL_STD_NO VALUE,MILL_STD_NO LABEL FROM TBB01_MILL_PROD ORDER BY MILL_STD_NO)
	</query>
	
	<query id="UIB010250_02.SMS_STD_NO" desc="炼钢规范">
		   SELECT '*' VALUE,'*' LABEL FROM DUAL
		   UNION ALL
		   SELECT * FROM(
	       SELECT SMS_STD_NO VALUE,SMS_STD_NO LABEL FROM TBB01_SMS_PROD ORDER BY SMS_STD_NO)
	</query>
	
	<query id="UIB010250_02.DEL_TOL_CD" desc="交付条件">
	       SELECT DISTINCT Dev_Spec_Cd LABEL,Dev_Spec_Cd VALUE FROM TBB01_SPEC_DEL ORDER BY Dev_Spec_Cd
	</query>
	
	<query id="UIB010250_02.DEV_DGR_CD" 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>				
				
</queryMap>