XinYu_LZMES/.svn/pristine/0f/0fd2d7695eea41c6df9af933ed871f1ea79a3abc.svn-base

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="新产品信息管理">

<query id="UIB010350_01.INITSELECT"  desc="查询满足进程状态的合同号">
	SELECT  T.SM_CD , T.SM_CFNM   FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01007' AND UPPER(USED_YN) = 'Y' ORDER BY SM_CFNM
</query>

<query id="UIB010350_02.INITSELECT">
SELECT DISTINCT  T.SPEC_ABBSYM , T.SPEC_ABBSYM   SPEC_ABBSYM_   FROM TBB01_KEY_PROD T  ORDER BY T.SPEC_ABBSYM
</query>

<query id="UIB010350_03.INITSELECT">
SELECT DISTINCT  T.SPEC_STL_GRD , T.SPEC_STL_GRD   SPEC_STL_GRD_   FROM TBB01_KEY_PROD T  ORDER BY T.SPEC_STL_GRD
</query>

<query id="UIB010350_01.SELECT" desc="查询满足条件的新产品">
	SELECT          PROD_LINE
	               ,PRDNM_CD
	               ,SPEC_ABBSYM
	               ,SPEC_STL_GRD
	               ,ORD_USE_TP
	               ,THK_MIN
	               ,THK_MAX
	               ,WTH_MIN
	               ,WTH_MAX
	               ,PROD_LINE	        PROD_LINE_1
	               ,PRDNM_CD		 	PRDNM_CD_1
	               ,SPEC_ABBSYM	      	SPEC_ABBSYM_1
	               ,SPEC_STL_GRD      	SPEC_STL_GRD_1
	               ,ORD_USE_TP			ORD_USE_TP_1
	               ,THK_MIN				THK_MIN_1
	               ,THK_MAX				THK_MAX_1
	               ,WTH_MIN				WTH_MIN_1
	               ,WTH_MAX				WTH_MAX_1
	               ,NEW_PROC_TYPE
	               ,NEW_PROC_DESC
	               ,REG_ID
	               ,REG_DTIME
	               ,MOD_ID
	               ,MOD_DTIME   
	FROM           TBB01_NEW_PROD          T
	WHERE          T.SPEC_STL_GRD          LIKE          ?||'%'
</query>

<query id="UIB010350_01.INSERT">
	  INSERT  
	  INTO            TBB01_NEW_PROD
	                 (
	                  PROD_LINE
	                 ,PRDNM_CD
	                 ,SPEC_ABBSYM
	                 ,SPEC_STL_GRD
	                 ,ORD_USE_TP
	                 ,THK_MIN
	                 ,THK_MAX
	                 ,WTH_MIN
	                 ,WTH_MAX
	                 ,NEW_PROC_TYPE
	                 ,NEW_PROC_DESC
	                 ,REG_ID
	                 ,REG_DTIME
	                 )
	  VALUES(?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))  
</query>

<query  id="UIB010350_01.UPDATE">
	  UPDATE          TBB01_NEW_PROD          T
	  SET             PROD_LINE               =            ?
	                 ,PRDNM_CD                =            ?
	                 ,SPEC_ABBSYM             =            ?
	                 ,SPEC_STL_GRD            =            ?
	                 ,ORD_USE_TP              =            ?
	                 ,THK_MIN                 =            ?
	                 ,THK_MAX                 =            ?
	                 ,WTH_MIN                 =            ?
	                 ,WTH_MAX                 =            ?
	                 ,NEW_PROC_TYPE           =            ?
	                 ,NEW_PROC_DESC           =            ?
	                 ,MOD_ID                  =            ?
	                 ,MOD_DTIME               =            TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
	  WHERE           PROD_LINE               =            ?
	  AND             PRDNM_CD                =            ?
	  AND             SPEC_ABBSYM             =            ?
	  AND             SPEC_STL_GRD            =            ?
	  AND             ORD_USE_TP              =            ?
	  AND             THK_MIN                 =            ?
	  AND             THK_MAX                 =            ?
	  AND             WTH_MIN                 =            ?
	  AND             WTH_MAX                 =            ? 
</query>

<query id="UIB010350_01.DELETE">
	  DELETE      
	  FROM            TBB01_NEW_PROD          T
	  WHERE           PROD_LINE               =            ?
	  AND             PRDNM_CD                =            ?
	  AND             SPEC_ABBSYM             =            ?
	  AND             SPEC_STL_GRD            =            ?
	  AND             ORD_USE_TP              =            ?
	  AND             THK_MIN                 =            ?
	  AND             THK_MAX                 =            ?
	  AND             WTH_MIN                 =            ?
	  AND             WTH_MAX                 =            ?   
</query>

</queryMap>