XinYu_RZMES/.svn/pristine/27/2739b37b4ea78104aee8bddc83af3f3afda11d84.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH020080_01.select" desc=" SPM作业对象查询 " fetchSize="10">
		<![CDATA[
			SELECT '' CHK,
			   OLD_SAMPL_NO,
               COIL_NO,
			   ORD_NO||ORD_SEQ  ORD_NO,
			   PRODNM_CD, 
			   ACT_WGT,
			   COIL_OUTDIA,
			   DEVLMT_DTIME,
			   STL_GRD,
			   SPEC_ABBSYM,
			   ORD_FL,
			   ORD_USE_CD,
     		   EXTSHAPE_DEC_GRD,
			   CRK_CD1,
			   CRK_CD2,
			   CRK_CD3,
			   CRK_CD4,
			   TOT_DEC_GRD  
					FROM TBH02_COIL_COMM 
						where 
						  OLD_SAMPL_NO LIKE ?||'%'
						  AND SPM_YN LIKE  ?||'%' 
						  AND COIL_STAT = '2' 
						  AND CUR_LOAD_LOC IS NOT NULL
		]]>
	</query>
	<query id="UIH020080_02.select" desc="SPM作业实绩 登录 COIL NO  " fetchSize="10">
		<![CDATA[
			SELECT  
			    OLD_SAMPL_NO,
				COIL_NO, 
				'' CUT_NO,
				COIL_THK, 
				COIL_WTH,  
				COIL_OUTDIA, 
				ACT_WGT, 
				'' SAMPL_PICK_YN,
				'' CRK_CD1,
				'' CRK_CD2,
				'' CRK_CD3,
				'' CRK_CD4, 
				ORD_FL,
				'' CUR_LOAD_LOC    
            FROM TBH02_COIL_COMM  
            where  OLD_SAMPL_NO = ?  
		]]>
	</query>
	
	<query id="UIH020080_03.select" desc=" SPM作业实绩 查询	 " fetchSize="10">
		<![CDATA[
			SELECT  COIL_NO,
			        OLD_SAMPL_NO,
       				ORD_NO||ORD_SEQ ORD_NO,
					PRODNM_CD,
					ACT_WGT,
					  COIL_OUTDIA,
					  DEVLMT_DTIME,
					  STL_GRD,
					  SPEC_ABBSYM,
					  ORD_FL,
					  ORD_USE_CD,
					  EXTSHAPE_DEC_GRD,
					  SPM_CRK_CD1,
					  SPM_CRK_CD2,
					  SPM_CRK_CD3,
					  SPM_CRK_CD4,
					  SAMPL_PICK_YN 
            FROM TBH02_COIL_COMM  
            where SPM_YN = '2' 
              AND COIL_STAT = '2'  
              AND CUR_LOAD_LOC IS NOT NULL  
		]]>
	</query>
		<query id="UIH020080_04.select" desc="瑕疵代码的查询  " fetchSize="10">
		<![CDATA[
			select SM_CD||SM_CFNM LABEL ,SM_CFNM VALUE from tbz00_commcd where lg_cd = 'H02001'
		]]>
	</query>
	 
    <query id="UIH020080_01.update" desc="更新" fetchSize="10">
		<![CDATA[
		  UPDATE TBH02_COIL_COMM SET
			 
			COIL_THK = ?,
			COIL_WTH = ?,
			COIL_OUTDIA =?,
			ACT_WGT =?,
			SAMPL_PICK_YN =?,
			SPM_CRK_CD1 = ? ,
			SPM_CRK_CD2 = ? ,
			SPM_CRK_CD3 = ? ,
			SPM_CRK_CD4 = ? ,
			ORD_FL = ?  ,
			SPM_SHIFT = ?,
			SPM_GROUP = ?,
			SPM_EMP_ID = ?,
			SPM_YN  = '2',
			COIL_STAT = '3' 
			where COIL_NO =? and OLD_SAMPL_NO = ? 
		]]>
	</query>
	   <query id="UIH020080_01.insert" desc="新增" fetchSize="10">
		<![CDATA[
		  insert into TBH02_COIL_COMM 
			(
			COIL_NO, 
			COIL_THK,
			COIL_WTH,
			COIL_OUTDIA,
			ACT_WGT,
			SAMPL_PICK_YN,
			SPM_CRK_CD1,
			SPM_CRK_CD2,
			SPM_CRK_CD3,
			SPM_CRK_CD4,
			ORD_FL,
			SPM_SHIFT,
			SPM_GROUP,
			SPM_EMP_ID,
			CUR_LOAD_LOC,
			OLD_SAMPL_NO,
			SPM_YN,
			COIL_STAT     
			)
			values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'2','2')
		]]>
	</query>
	 
</queryMap>