XinYu_RZMES/.svn/pristine/c0/c052195ec4b475d8aa0249439a62eb0447002abd.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
    <query id="TBG03_STLMAKE_PROG.delete" desc="CHARGE단위 제강공정진행정보삭제">
        <![CDATA[
            delete from TBG03_STLMAKE_PROG
            where CHARGE_NO=?
        ]]>
    </query>    
    <query id="TBG03_STLMAKE_PROG.insert" desc="CHARGE단위 제강공정진행정보추가">
        <![CDATA[
            insert into  TBG03_STLMAKE_PROG
             (  CHARGE_NO ,PLAN_CHARGE_NO,PROC_CD,TREAT_CD,
                TREAT_CD_DESC,TREAT_TSTAMP,REGISTER,REGTSTAMP
              )
            values(?,?,?,?,?,?,?,?)
        ]]>
    </query>
    <query id="TBG03_STLMAKE_PROG.select" desc="it's selected query  from TBG03_STLMAKE_PROG table   " fetchSize="10">
        <![CDATA[
      select 
        CHARGE_NO
       ,PLAN_CHARGE_NO 
       ,STLKIND
       ,PROC_CD      
       ,TREAT_CD     
       ,TREAT_CD_DESC
       ,TREAT_TSTAMP 
       ,TREAT_TEMP   
       ,TREAT_WGT    
      from  TBG03_STLMAKE_PROG a,
            TBG02_CHARGE_COMM  b
      where  a.PROC_CD = ? 
        and  a.CHARGE_NO = b.CHARGE_NO  
        and  a.CHARGE_NO =?
        ]]>
    </query> 
</queryMap>