XinYu_RZMES/.svn/pristine/a4/a47078ed9808bb4172991e63a8aa99726b30fe49.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">

   <query id="NIG020430_01.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
		/* 通过电文中的炉次号来判断 炼钢公共表中是否有此条记录 没有则不能进行操作 */
         SELECT CHARGE_NO
           FROM TBG02_CHARGE_COMM
          WHERE CHARGE_NO =? 
        ]]>
    </query>
   
   
   <query id="NIG020430_02.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 判断此条记录是否存在 从而确定插入或删除操作 */
         SELECT MAINRAW_CD,MAINRAW_CD_DESC,MAINRAW_WGT
           FROM TBG03_MAINRAW
          WHERE CHARGE_NO =?
            AND  PROC_CD  = 'JC'
            AND  MAINRAW_CD  =?
        ]]>
    </query>
    
    <query id="NIG020430_01.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 修改铁合金副原料实绩表 TBG03_MAINRAW */
         update TBG03_MAINRAW set
              MAINRAW_WGT=? 
			, MOD_ID      = 'CAS L2'
            , MOD_PGM_ID  = 'NIG020420'
            , MOD_DTIME   = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            where CHARGE_NO=?
             and  PROC_CD='JC'
             and  MAINRAW_CD = ? 
        ]]>
    </query>
    
    <query id="NIG020430_01.insert" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 插入铁合金副原料实绩表 TBG03_MAINRAW */
          insert into TBG03_MAINRAW (
            CHARGE_NO,PROC_CD,MAINRAW_CD,MAINRAW_WGT,REG_ID,REG_PGM_ID,REG_DTIME
          ) 
          values
          (
            ?,'JC',?,?,'CAS L2','NIG020420',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
          )
        ]]>
    </query>
</queryMap>