XinYu_RZMES/.svn/pristine/1a/1ad5200b1121d5cd0f85cd6ed3e2081f7dad73c0.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Sampling代码录入（暂废）">

   	<query id="UIB010190.QLTYCD" desc="">
		select qlty_cd,         --材质代码
		qlty_cd_cfnm            --材质代码名称
        from TBB01_SEQ_QLTY order by display_seq
	</query>
   	
	<query id="UIB010190.DEFINFO" desc="">
		select t1.PRDNM_CD,      --品名代码
		t1.PRDNM_CD BEF_PRDNM_CD,
		t1.QLTY_CD,              --材质代码
		t1.QLTY_CD QLTY_CD_CFNM, --材质代码
        t1.QLTY_CD BEF_QLTY_CD,
		t1.SPEC_ABBSYM,          --标准号
        t1.SPEC_ABBSYM BEF_SPEC_ABBSYM,
		t1.SMP_LOT_CD,           --试样LOT代码
        t1.DEF_QLTY_TP           --指定区分
        from  TBB02_DEF_CONV t1,TBB01_SEQ_QLTY t2 where t1.qlty_cd = t2.qlty_cd(+) 
        and SPEC_ABBSYM like :1 and t1.QLTY_CD like :2 order by t1.SPEC_ABBSYM
	</query>
	
	<query id="UIB010190.LOTCD" desc="">
		select 
		SMP_LOT_CD,       --试样LOT代码
		SMP_LOT_DETAIL    --试样LOT说明
		from TBB02_SMP_CODE ORDER BY SMP_LOT_CD
	</query>
	
	<query id="UIB010190.LOTINSERT" desc="">
		insert into TBB02_DEF_CONV
		(PRDNM_CD,SPEC_ABBSYM,QLTY_CD,SMP_LOT_CD,DEF_QLTY_TP)
		values(?,?,?,?,?)
	</query>
	
	<query id="UIB010190.LOTUPDATE" desc="">
		UPDATE TBB02_DEF_CONV
		set PRDNM_CD = ?,SPEC_ABBSYM = ? ,QLTY_CD = ?,SMP_LOT_CD = ?,DEF_QLTY_TP = ?
		WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND QLTY_CD = ?
	</query>
	
	<query id="UIB010190.LOTDELETE" desc="">
		DELETE  FROM TBB02_DEF_CONV
		WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND QLTY_CD = ?
	</query>

	<query id="UIB010190.ORDUSETP" fetchSize="" desc="订单用途">
		SELECT SM_CD        --订单用途代码
			   ,SM_CFNM     --订单用途名称
				FROM TBZ00_COMMCD WHERE LG_CD = 'A01007'  AND UPPER(USED_YN) = 'Y' ORDER BY SM_CFNM
	</query>
	
   	<query id="UIB010190.SYMQLTYCD" desc="标准号对应材质代码">
		SELECT DISTINCT T2.QLTY_CD,   --材质代码
		T2.QLTY_CD_CFNM               --材质代码名称
		FROM TBB01_SPEC_QLTY T1,TBB01_SEQ_QLTY T2
		WHERE T1.QLTY_CD = T2.QLTY_CD AND T1.SPEC_ABBSYM = ?
	</query>
</queryMap>