XinYu_RZMES/.svn/pristine/5a/5a5f593f2a7b85feb9a682ab822dfdce2a99a2ab.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Sampling代码录入">
    <query id="UIB010180_01.SELECT" desc="查询试片LOT代码 LotResult" fetchSize="10">  
        <![CDATA[
        SELECT 
		 'N' CHK
		, SMP_LOT_CD     --试样代码
		, SMP_LOT_WGT    --按重量计算
		, SMP_LOT_CNT    --按块数计算
		, SMP_LOT_DETAIL --代码说明
		, SMP_LOT_CD SMP_LOT_CD1	
		FROM 
		TBB02_SMP_CODE
        ]]>   
    </query> 
	
	<query id="UIB010180_02.SELECT" desc="按长度方向位置查询 ChangResult">
		SELECT 
		 'N' CHK
		, SM_CD C_SMCD      --代码
		, SM_CFNM C_SMCFNM  --说明
		, SM_CD C_SMCD1     --代码
		FROM TBZ00_COMMCD
		WHERE  LG_CD = 'B01102'
	</query>
	
	<query id="UIB010180_03.SELECT" desc="按宽度方向位置查询 KuanResult">
		SELECT 
		 'N' CHK
		, SM_CD K_SMCD      --代码
		, SM_CFNM K_SMCFNM  --说明
		, SM_CD K_SMCD1     --代码
		FROM TBZ00_COMMCD
		WHERE  LG_CD = 'B01103'
	</query>
	<!--
	<query id="UIB010180_04.SELECT" desc="按取样试验方向代码查询 FangResult">
		SELECT 
		 'N' CHK
		, SM_CD   F_SMCD
		, SM_CFNM F_SMCFNM
		, SM_CD   F_SMCD1
		FROM TBZ00_COMMCD
		WHERE  LG_CD = 'B01104'
	</query>
	
	<query id="UIB010180_05.SELECT" desc="按试样规格代码查询 GuiResult">
		SELECT 
		 'N' CHK
		, SM_CD   G_SMCD     -#-代码
		, SM_CFNM G_SMCFNM
		, SM_CD   G_SMCD1    -#-代码
		FROM TBZ00_COMMCD
		WHERE  LG_CD = 'B01105'
	</query>-->
	
	<query id="UIB010180_01.UPDATE" desc="试片LOT代码更新">
		UPDATE TBB02_SMP_CODE
		SET 
		 SMP_LOT_CD = ? --代码
		,SMP_LOT_WGT=?  --按重量计算
		,SMP_LOT_CNT=?  --按块计算
		,SMP_LOT_DETAIL=? --说明
		WHERE
		SMP_LOT_CD=?    --代码 
	</query>
	<query id="UIB010180_02.UPDATE" desc="按长度方向位置更新">
		UPDATE TBZ00_COMMCD
		SET 
		 SM_CD  =?
		,SM_CFNM=?
		WHERE
		     SM_CD = ?
		AND  LG_CD = 'B01102'  
	</query>
	<query id="UIB010180_03.UPDATE" desc="按宽度方向位置更新">
		UPDATE TBZ00_COMMCD
		SET 
		 SM_CD  =?
		,SM_CFNM=?
		WHERE
		 SM_CD = ?
		AND   LG_CD = 'B01103' 
	</query>
	<!--<query id="UIB010180_04.UPDATE" desc="按取样试验方向代码更新">
		UPDATE TBZ00_COMMCD
		SET 
		 SM_CD  =?
		,SM_CFNM=?
		WHERE
		 SM_CD = ?
		,LG_CD = 'B01104'
	</query>
	<query id="UIB010180_05.UPDATE" desc="按试样规格代码更新">
		UPDATE TBZ00_COMMCD
		SET 
		 SM_CD  =?
		,SM_CFNM=?
		WHERE
		 SM_CD = ?
		,LG_CD = 'B01105'
	</query>-->
	<query id="UIB010180_01.INSERT" desc="插入试片LOT代码">
		INSERT INTO TBB02_SMP_CODE(SMP_LOT_CD , SMP_LOT_WGT ,SMP_LOT_CNT,SMP_LOT_DETAIL ) VALUES(?,?,?,?)
	</query>
	<query id="UIB010180_02.INSERT" desc="试样长度方向位置">
		INSERT INTO TBZ00_COMMCD(LG_CD , SM_CD , LG_NM , SM_CFNM) VALUES('B01102' , ? ,'试样长度方向位置' ,?)
	</query>
	<query id="UIB010180_03.INSERT" desc="试样宽度方向位置">
		INSERT INTO TBZ00_COMMCD(LG_CD , SM_CD , LG_NM , SM_CFNM) VALUES('B01103' , ? ,'试样宽度方向位置' ,?)
	</query>
	<!--<query id="UIB010180_04.INSERT" desc="按取样试验方向代码更新">
		INSERT INTO TBZ00_COMMCD(LG_CD , SM_CD , LG_NM , SM_CFNM) VALUES('B01104' , ? ,'按取样试验方向代码更新' ,?)
	</query>
	<query id="UIB010180_05.INSERT" desc="按试样规格代码更新">
		INSERT INTO TBZ00_COMMCD(LG_CD , SM_CD , LG_NM , SM_CFNM) VALUES('B01105' , ? ,'按试样规格代码更新' ,?)
	</query>-->
	<query id="UIB010180_01.DELETE" desc="试片LOT代码">
		DELETE FROM TBB02_SMP_CODE WHERE SMP_LOT_CD=?
	</query>
	<query id="UIB010180_02.DELETE" desc="试样长度方向位置">
		DELETE FROM TBZ00_COMMCD WHERE LG_CD='B01102' AND SM_CD=?
	</query>
	<query id="UIB010180_03.DELETE" desc="试样宽度方向位置">
		DELETE FROM TBZ00_COMMCD WHERE LG_CD='B01103' AND SM_CD=?
	</query>
	<!--<query id="UIB010180_04.DELETE" desc="按取样试验方向代码更新">
		DELETE FROM TBZ00_COMMCD WHERE LG_CD='B01104' AND SM_CD=?
	</query>
	<query id="UIB010180_05.DELETE" desc="按试样规格代码更新">
		DELETE FROM TBZ00_COMMCD WHERE LG_CD='B01105' AND SM_CD=?
	</query>-->
	
	
	
</queryMap>