XinYu_RZMES/.svn/pristine/f3/f351948aeeac8f63c875fd4f7947e69bc4b59472.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
  <query id="UIG040060_01.select" desc=" ">
	   <![CDATA[
	 SELECT SLAB_NO,SLAB_WTH,SLAB_LEN,SLAB_WGT,ORD_FL,CRK_CD1,
	        CRK_CD1_LOC, CRK_CD2,CRK_CD2_LOC,CRK_CD3,CRK_CD3_LOC,
	        CRK_CD4,CRK_CD4_LOC,
       FROM TBG02_SLAB_COMM
      WHERE CUR_LOAD_LOC LIKE 'L%' 
       AND  CORRECT_RSLT_CD = '1'  
       AND  CORRECT_YN IS NULL 
        ]]> 
  </query>
  
   
  <query id="UIG040060_01.update" desc=" " fetchSize="10">
		<![CDATA[	
		  UPDATE TBG02_SLAB_COMM SET
		    CORRECT_DTIME =  TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
		   ,CORRECT_XIN_DATE = ? 
		   ,CORRECT_WKSHIFT  = ?
		   ,CORRECT_WKGROUP  = ?
		   ,CORRECT_EMPNO    = ?
		   ,CORRECT_RSLT_CD  = ?
		  WHERE SLAB_NO = ?	 
		]]>
 </query>
  
	 
	 
</queryMap>