XinYu_RZMES/.svn/pristine/3a/3a6497a20e89f07dd657d7cc306582c48eee93c9.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="钢卷改判">
	<query  id="UIB020250_01.SELECT" desc="">
				
				SELECT
				OLD_SAMPL_NO,	
				COIL_NO,            --钢卷号
				COIL_THK,           --厚度
				COIL_WTH,           --宽度
			    ACT_WGT,            --重量
				PRODNM_CD,          --交货状态
			    SPEC_ABBSYM,        --标准号
			    SPEC_STL_GRD,       --规格钢号
			    SAMPL_NO,           --试样编号
			    TOT_DEC_DTIME,      --判定日期
				ORD_FL,             --余材区分  
				INGR_DEC_GRD,       --成分
			    MATLQLTY_DEC_GRD,   --材质
			    EXTSHAPE_DEC_GRD,   --外观
			    TOT_DEC_GRD,        --综合等级
			    BEF_SPEC_ABBSYM,    --原标准号
			    BEF_SPEC_STL_GRD,   --原规格钢号
				DCS_THK,            --判定规格
		        ORG_SAMPL_NO,       --原试样编号
		        ORD_USE_CD,         --订单用途
		        CHANGE_SPEC_DTIME,
		        CHANGE_SPEC_ID,
		        SMP_STATS            
			    FROM          TBH02_COIL_COMM  T
		        WHERE         T.ORD_FL      =  '2'
                AND           T.COIL_STAT   =  '2'
		        AND          (T.SMP_STATS  = '0' OR T.SMP_STATS  =  '1')
				ORDER  BY     OLD_SAMPL_NO
			    
	</query>
	<query  id="UIB020250_02.SELECT" desc="标准号(DESIGN_KEY 中)">
				SELECT DISTINCT T.SPEC_ABBSYM LABEL,T.SPEC_ABBSYM VALUE 
				FROM TBB01_KEY_PROD T
	</query>
	<query  id="UIB020250_03.SELECT" desc="标准钢号(DESIGN_KEY 中)">
      			SELECT DISTINCT T.SPEC_STL_GRD LABEL,T.SPEC_STL_GRD VALUE 
				FROM TBB01_KEY_PROD T
	</query>
	
	<query id="UIB020250_04.SELECT" desc="替换前">
		SELECT       WQ.* 
		            ,WQ.QLTY_CD  QLTYCD 
                    ,IQ.QLTY_MIN
                    ,IQ.QLTY_MAX
                    ,SQ.QLTY_CD_CFNM 
        FROM         TBB02_WORK_QLTY WQ  , TBB01_SEQ_QLTY  SQ  ,  TBB02_INS_QLTY IQ
        WHERE        WQ.SMP_NO           =    ?
        AND          WQ.QLTY_CD          =    SQ.QLTY_CD
        AND          WQ.SMP_NO           =    IQ.SMP_NO
        AND          WQ.QLTY_CD          =    IQ.QLTY_CD
        ORDER  BY    SQ.DISPLAY_SEQ
	</query>
	
	<query id="UIB020250_05.SELECT" desc="替换后">
		SELECT SPE.* , SEQ.QLTY_CD_CFNM FROM TBB01_SPEC_QLTY  SPE , TBB01_SEQ_QLTY  SEQ
		WHERE    SPE.QLTY_CD           =   SEQ.QLTY_CD
		AND      SPE.PRDNM_CD          =   ?
		AND      SPE.SPEC_ABBSYM       =   ?
		AND      SPE.SPEC_STL_GRD      =   ?
		AND      ?                     >=  SPE.THK_MIN  
		AND      SPE.THK_MAX           >=  ?
		AND      SPE.QLTY_CD           != 'SAMP'
		ORDER  BY  SEQ.DISPLAY_SEQ
	</query>
	
	<query id="UIB020250_06.SELECT"  desc="">
		SELECT    DISTINCT
                  SPE.SPEC_ABBSYM    LABEL
				 ,SPE.SPEC_ABBSYM    VALUE
		FROM      TBB01_SPEC_QLTY  SPE 
		WHERE     SPE.PRDNM_CD          =     ?
		AND       SPE.SPEC_STL_GRD      =     ?
		AND       ?                     >=    SPE.THK_MIN 
		AND       SPE.THK_MAX           >=    ?
	</query>
	
	<query id="UIB020250_07.SELECT" desc="">
		SELECT    DISTINCT
		          SPE.PRDNM_CD
				 ,SPE.SPEC_ABBSYM
			     ,SPE.SPEC_STL_GRD
			   	 ,SPE.ORD_USE_TP
		FROM      TBB01_SPEC_QLTY  SPE 
		WHERE     ?                     >=  SPE.THK_MIN 
		AND       SPE.THK_MAX           >=  ?
		ORDER BY  SPE.SPEC_STL_GRD
	</query>
	
	
	
	<query id="UIB020250_02.UPDATE" desc="">
		UPDATE   TBB02_INS_QLTY   T
		SET      T.QLTY_CD        =   ?
		WHERE    T.QLTY_CD        =   ?
		AND      T.SMP_NO         =   ?
	</query>
	
	<query id="UIB020250_03.UPDATE" desc="">
		UPDATE    TBB02_WORK_QLTY T
		SET       T.QLTY_VAL_WK    =    ?
		WHERE     T.SMP_NO         =    ?
		AND       T.QLTY_CD        =    ?
	</query>
	
	<query  id="NIB020251.CALL" desc="">
                {call NIB020251(?,?,?)}
	</query>
	
	<query id="NIB020251_01.CALL" desc="生成改判检验项目">
		{call ZL_HOST_DCS02.COIL_MODY_NORM(?,?,?)}
	</query>
	<query id="NIB020251_02.CALL" desc="发送指示">
		{call ZL_HOST_DCS02.COIL_SEND_L2INS(?)}
	</query>
	
	<query id="NIB020251_03.CALL" desc="判断是否进入判定待机状态">
		{call ZL_HOST_DCS02.COIL_DCSSMP_STATS(?)}
	</query>
	
	<query id="NIB020251_04.CALL" desc="检验项目替换">
		{call ZL_HOST_DCS02.COIL_MODY_NORMSP02(? , ?, ? , ?)}
	</query>
</queryMap>