XinYu_RZMES/.svn/pristine/54/54cc714894bb6aa1eccc3286ec672009aef5d753.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="交付条件（外形尺寸标准号）录入">
	
    <query id="UIB010271_01.INITSELECT" desc="交付条件标准号，初始化页面" fetchSize="10">   
        <![CDATA[
    	  /*SELECT      DISTINCT 
					SIR.SPEC_STL_GRD    LABEL
				  , SIR.SPEC_STL_GRD    VALUE
		FROM        TBB01_SPEC_INGR     SIR
		ORDER BY    SIR.SPEC_STL_GRD*/
			select T.SM_CD LABEL, T.SM_CFNM VALUE
  				from tbz00_commcd t
 			where t.LG_CD = 'A02001'
 			ORDER BY T.SM_CD			
        ]]>   
    </query> 
	
	<query id="UIB010270_02.INITSELECT" desc="获得公差名及公差代码">
		SELECT 
		SM_CFNM     LABEL  --公差名
		, SM_CD     VALUE  --公差代码
		FROM        TBZ00_COMMCD   WHERE   LG_CD = 'B01012'
	</query>
	
	<query id="UIB010270_03.INITSELECT" desc="等级代码 DengJi">
		SELECT 
		SM_CD       LABEL
		, SM_CD     VALUE
	    FROM        TBZ00_COMMCD    WHERE   LG_CD='B01119'
	</query>
	
	<query id="UIB010270_04.INITSELECT" desc="在基本信息中有，但在标准表中没有">
		SELECT        T1.SM_CD         LABEL
                     ,T1.SM_CD         VALUE
         FROM         TBZ00_COMMCD     T1
         WHERE        T1.LG_CD         =    'B01120'
         AND          T1.USED_YN       =     'Y'
		 MINUS
		 SELECT       T2.DEV_SPEC_CD 
		             ,T2.DEV_SPEC_CD 
		 FROM         TBB01_SPEC_DEL   T2
	</query>
	
	<query id="UIB010271_01.SELECT" desc="按 牌号获取原有数据">
		   SELECT DISTINCT SPEC_STL_GRD DEV_SPEC_CD
   		   FROM TBB01_SPEC_CUT
  		   WHERE SPEC_STL_GRD LIKE ? || '%'
           ORDER BY SPEC_STL_GRD
	</query>
	
	<query id="UIB010271_02.SELECT" desc="双击datagrid1中某条记录时，按交付条件号及名进行查询">
		 SELECT 'N' CHK, t.wth_min, t.wth_max,  t.thk_min, t.thk_max,t.EMEC_TP,t.add_wth,t.mark
  			from tbb01_spec_cut t
 		where t.SPEC_STL_GRD = ? 
	</query>
	<query id="UIB010271_01.INSERT" desc="插入新的公差">
		INSERT INTO TBB01_SPEC_CUT(
		  SPEC_STL_GRD      --交付条件标准号	
		, EMEC_TP	
		, WTH_MIN          --宽度min
		, WTH_MAX          --宽度max
		, THK_MIN          --厚度min
		, THK_MAX          --厚度max
		, ADD_WTH	
		, MOD_ID           --操作人
		, MOD_DTIME        --操作时间
		, MARK
		)
		VALUES(?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),(SELECT NVL(MAX(MARK),0) + 1 FROM TBB01_SPEC_CUT))
	</query>
	
	<query id="UIB010271_01.UPDATE" desc="datagrid2更新公差等信息">
		UPDATE    TBB01_SPEC_CUT
		SET     EMEC_TP  		=  ?
				,WTH_MIN       	=  ?     --宽度min
				, WTH_MAX       =  ?     --宽度max
				, THK_MIN       =  ?     --厚度min
				, THK_MAX       =  ?     --厚度max
				, ADD_WTH       =  ?     --宽度min			
				, MOD_ID        =  ?
		        , MOD_DTIME     =  TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
		WHERE     SPEC_STL_GRD   =  ?   --交付条件标准号
		AND       MARK	= ?
	</query>
		<query id="UIB010271_01.DELETE" desc="datagrid2删除记录">
		 DELETE   FROM            TBB01_SPEC_CUT 
		 WHERE    SPEC_STL_GRD=?
	</query>
	<query id="UIB010271_02.DELETE" desc="datagrid2删除具体的一条记录">
		 DELETE   FROM            TBB01_SPEC_NOQLTY 
		 WHERE    MARK=?
	</query>
	<query id="UIB010271_03.DELETE" desc="datagrid2删除具体的一条记录">
		 DELETE   FROM            TBB01_SPEC_CUT 
		 WHERE    MARK=?
	</query>
	<query id="UIB010275_01.SELECT" desc="按 牌号获取原有数据">
		   SELECT DISTINCT SPEC_STL_GRD DEV_SPEC_CD
   		   FROM TBB01_SPEC_SPM
  		   WHERE SPEC_STL_GRD LIKE ? || '%'
           ORDER BY SPEC_STL_GRD
	</query>
	
	<query id="UIB010275_02.SELECT" desc="双击datagrid1中某条记录时，按交付条件号及名进行查询">
		 SELECT 'N' CHK, t.wth_min, t.wth_max,  t.thk_min, t.thk_max,t.EMEC_TP,t.add_wth,t.mark
  			from TBB01_SPEC_SPM t
 		where t.SPEC_STL_GRD = ? 
	</query>
	<query id="UIB010275_01.UPDATE" desc="datagrid2更新公差等信息">
		UPDATE    TBB01_SPEC_SPM
		SET     EMEC_TP  		=  ?
				,WTH_MIN       	=  ?     --宽度min
				, WTH_MAX       =  ?     --宽度max
				, THK_MIN       =  ?     --厚度min
				, THK_MAX       =  ?     --厚度max
				, ADD_WTH       =  ?     --宽度min			
				, MOD_ID        =  ?
		        , MOD_DTIME     =  TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
		WHERE     SPEC_STL_GRD   =  ?   --牌号
		AND       MARK	= ?
	</query>
	<query id="UIB010275_01.INSERT" desc="插入新的公差">
		INSERT INTO TBB01_SPEC_SPM(
		  SPEC_STL_GRD      --交付条件标准号	
		, EMEC_TP	
		, WTH_MIN          --宽度min
		, WTH_MAX          --宽度max
		, THK_MIN          --厚度min
		, THK_MAX          --厚度max
		, ADD_WTH	
		, MOD_ID           --操作人
		, MOD_DTIME        --操作时间
		, MARK
		)
		VALUES(?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),(SELECT NVL(MAX(MARK),0) + 1 FROM TBB01_SPEC_SPM))
	</query>
	<query id="UIB010275_03.DELETE" desc="datagrid2删除具体的一条记录">
		 DELETE   FROM            TBB01_SPEC_SPM 
		 WHERE    MARK=?
	</query>
	<query id="UIB010275_01.DELETE" desc="datagrid2删除记录">
		 DELETE   FROM            TBB01_SPEC_SPM 
		 WHERE    SPEC_STL_GRD=?
	</query>
	<query id="UIB010276_01.SELECT" desc="按 牌号获取原有数据">
		   SELECT DISTINCT SPEC_STL_GRD DEV_SPEC_CD
   		   FROM tbb01_spec_cooltime
  		   WHERE SPEC_STL_GRD LIKE ? || '%'
           ORDER BY SPEC_STL_GRD
	</query>
	
	<query id="UIB010276_02.SELECT" desc="双击datagrid1中某条记录时，按交付条件号及名进行查询">
	   SELECT 'N' CHK, t.btime, t.etime,  t.descmak, t.mark,t.cooltime,t.thk_min,t.thk_max
  			from tbb01_spec_cooltime t
 		where t.SPEC_STL_GRD = ? 
	</query>
	<query id="UIB010276_01.UPDATE" desc="datagrid2更新公差等信息">
		UPDATE    tbb01_spec_cooltime
		SET     BTIME  		=  ?
				,ETIME       	=  ?     --宽度min
				, DESCMAK       =  ?     --宽度max
				, COOLTIME       =  ?     --厚度min
				, THK_MIN       =  ?     --宽度max
				, THK_MAX       =  ?     --厚度min
				, MOD_ID        =  ?
		        , MOD_DTIME     =  TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
		WHERE     SPEC_STL_GRD   =  ?   --牌号
		AND       MARK	= ?
	</query>
	<query id="UIB010276_01.INSERT" desc="插入新的公差">
		INSERT INTO tbb01_spec_cooltime(
		  SPEC_STL_GRD      --交付条件标准号	
		, btime	
		, etime          --宽度min
		, descmak          --宽度max
		, cooltime          --厚度min
		, THK_MIN          --宽度max
		, THK_MAX          --厚度min
		, MOD_ID           --操作人
		, MOD_DTIME        --操作时间
		, MARK
		)
		VALUES(?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),(SELECT NVL(MAX(MARK),0) + 1 FROM tbb01_spec_cooltime))
	</query>
	<query id="UIB010276_03.DELETE" desc="datagrid2删除具体的一条记录">
		 DELETE   FROM            tbb01_spec_cooltime 
		 WHERE    MARK=?
	</query>
	<query id="UIB010276_01.DELETE" desc="datagrid2删除记录">
		 DELETE   FROM            tbb01_spec_cooltime 
		 WHERE    SPEC_STL_GRD=?
	</query>
	<query id="UIB010273_01.SELECT" desc="按 牌号获取原有数据">
		   SELECT  SPEC_STL_GRD DEV_SPEC_CD,MOD_DTIME
   		   FROM TBB01_SPEC_NOQLTY
  		   WHERE SPEC_STL_GRD LIKE ? || '%'
           ORDER BY SPEC_STL_GRD
	</query>
	<query id="UIB010273_01.INSERT" desc="插入新的公差">
		INSERT INTO TBB01_SPEC_NOQLTY(
		  SPEC_STL_GRD      --交付条件标准号		
		, MOD_ID           --操作人
		, MOD_DTIME        --操作时间
		)
		VALUES(?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') )
	</query>
	
	<query id="UIB010273_01.DELETE" desc="datagrid1删除交付条件信息">
		DELETE   FROM   TBB01_SPEC_NOQLTY 
		WHERE    SPEC_STL_GRD   =  ? --交付条件标准号
	</query>

	<query id="UIB010270_01.CALL" desc="复制">
		{call ZL_NORM_MANAGE.COPY_SPEC_DELE(?,?,?,?,?,?)}
	</query>
</queryMap>