XinYu_RZMES/.svn/pristine/be/be1eae0021b380156c3699d90f082783710b1a29.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
     <query id="UIG020200_01.select" desc=" " fetchSize="10">
        <![CDATA[
                select PRD_DD ,
                      PRD_HOT_COIL_CH_CNT  ,          
	                  PRD_HOT_COIL_CH_QTY  ,          
	                  PRD_PLAT_CH_CNT    ,            
	                  PRD_PLAT_CH_QTY    ,            
	                  PRD_COLD_COIL_CH_CNT    ,       
	                  PRD_COLD_COIL_CH_QTY    ,       
	                  PRD_OUT_SLAB_CH_CNT    ,        
	                  PRD_OUT_SLAB_CH_QTY    ,        
                      PRD_HOT_COIL_SLAB_QTY  ,        
	                  PRD_PLAT_SLAB_QTY  ,            
	                  PRD_COLD_COIL_SLAB_QTY  ,       
	                  PRD_OUT_SLAB_SLAB_QTY  , 
	                  PRD_HOT_COIL_QTY    , 
	                  PRD_COIL_COIL_QTY   ,  
                 from TBG02_PLAN_DAILY_PROD 
                 where PRD_YYYYMM = ? order by PRD_DD
        ]]>
    </query> 
	<query id="UIG020200_01.update" desc="" fetchSize="10">
		<![CDATA[	
			update TBG02_PLAN_DAILY_PROD set 
				PRD_HOT_COIL_CH_CNT = ?,
				PRD_HOT_COIL_CH_QTY = ?,
				PRD_PLAT_CH_CNT = ?,
				PRD_PLAT_CH_QTY = ?,
				PRD_COLD_COIL_CH_CNT = ?,
				PRD_COLD_COIL_CH_QTY = ?,
				PRD_OUT_SLAB_CH_CNT = ?,
				PRD_OUT_SLAB_CH_QTY = ?,
			    PRD_HOT_COIL_SLAB_QTY = ?,
				PRD_PLAT_SLAB_QTY = ?,
				PRD_COLD_COIL_SLAB_QTY = ?
				PRD_OUT_SLAB_SLAB_QTY = ?	
				PRD_HOT_COIL_QTY = ?
				PRD_COIL_COIL_QTY = ?
			where PRD_DD = ? and PRD_YYYYMM = ? 
		]]>
	</query> 
	<query id="UIG020200_01.insert" desc="" fetchSize="10">
		<![CDATA[	
			insert into TBG02_PLAN_DAILY_PROD       
            (                                       
	          PRD_YYYYMM,	                
	          PRD_DD,                         
	          PRD_HOT_COIL_CH_CNT  ,          
	          PRD_HOT_COIL_CH_QTY  ,          
	          PRD_PLAT_CH_CNT    ,            
	          PRD_PLAT_CH_QTY    ,            
	          PRD_COLD_COIL_CH_CNT    ,       
	          PRD_COLD_COIL_CH_QTY    ,       
	          PRD_OUT_SLAB_CH_CNT    ,        
	          PRD_OUT_SLAB_CH_QTY    ,        
              PRD_HOT_COIL_SLAB_QTY  ,        
	          PRD_PLAT_SLAB_QTY  ,            
	          PRD_COLD_COIL_SLAB_QTY  ,       
	          PRD_OUT_SLAB_SLAB_QTY   ,
	          PRD_HOT_COIL_QTY ,
	          PRD_COIL_COIL_QTY	        
            )values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)	

		]]>
	</query> 
</queryMap>