XinYu_RZMES/.svn/pristine/f7/f7f21e4a58425bf085c0776908c04edf7e292556.svn-base

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

   <query id="NIG020230_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="NIG020230_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  = 'JB'
            AND  MAINRAW_CD  =?
        ]]>
    </query>
    
    <query id="NIG020230_01.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 修改铁合金副原料实绩表 TBG03_MAINRAW */
         update TBG03_MAINRAW set
              MAINRAW_WGT=? 
            where CHARGE_NO=?
             and  PROC_CD='JB'
             and  MAINRAW_CD = ? 
        ]]>
    </query>
    
    <query id="NIG020230_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
          ) 
          values
          (
            ?,'JB',?,?
          )
        ]]>
    </query>
</queryMap>