XinYu_RZMES/.svn/pristine/a0/a0f3dca8379cb31432f2c05f2cf8868665bd9d28.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS    ">
              
   <query id="NIG020510_01.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 通过电文中接收的炉次号查询LF炉实绩表 tbg02_LF_result 来判断记录是否存在  */
			select charge_no 
			from tbg02_lf_result 
			where charge_no = ?
        ]]>
    </query>
    <query id="NIG020510_01.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 用电文信息修改转炉实绩表  */
			update tbg02_lf_result set
        			PLAN_CHARGE_NO              =?
					,ARRV_WGT                   =?
					,LF_TREAT_WGT               =?
					,SLAG_THK                   =?
					,SLAG_WGT                   =?
					,LF_ARRV_DTIME              =?
					,LF_STA_DTIME               =?
					,LF_END_DTIME               =?
					,LF_DEP_DTIME               =?
					,ELECFLOW_STA_DTIME         =?
					,LF_TREAT_HOUR              =?
					,AR_GAS_BLOW_HOUR           =?
					,LF_WAIT_HOUR               =?
					,ELECFLOW_HOUR              =?
					,ELECFLOW_WGT               =?
					,LF_ARRV_TEMP               =?
					,LF_STA_TEMP                =?
					,LF_END_TEMP                =?
					,LF_DEP_TEMP                =?
					,TREAT_BEF_O2_WGT           =?
					,TREAT_AFT_O2_WGT           =?
					,O2_USE_WGT                 =?
					,AR_GAS_USE_WGT             =?
					,ELECTROD_CONTACT_QNTY_1    =?
					,ELECTROD_CONTACT_QNTY_2    =?
					,ELECTROD_CONTACT_QNTY_3    =?
					,LF_NO                      =?
					,WKSHIFT                    =?
					,WKGROUP                    =?
					,XIN_DATE                   =?
			where   CHARGE_NO                   =?
        ]]>
    </query>
    <query id="NIG020510_01.insert" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
		  /* 用电文中的信息修改 当前RH炉实绩表 */
         insert into tbg02_lf_result 
		(
				CHARGE_NO                   
				,PLAN_CHARGE_NO             
				,ARRV_WGT                   
				,LF_TREAT_WGT               
				,SLAG_THK                   
				,SLAG_WGT                   
				,LF_ARRV_DTIME              
				,LF_STA_DTIME               
				,LF_END_DTIME               
				,LF_DEP_DTIME               
				,ELECFLOW_STA_DTIME         
				,LF_TREAT_HOUR              
				,AR_GAS_BLOW_HOUR           
				,LF_WAIT_HOUR               
				,ELECFLOW_HOUR              
				,ELECFLOW_WGT               
				,LF_ARRV_TEMP               
				,LF_STA_TEMP                
				,LF_END_TEMP                
				,LF_DEP_TEMP                
				,TREAT_BEF_O2_WGT           
				,TREAT_AFT_O2_WGT           
				,O2_USE_WGT                 
				,AR_GAS_USE_WGT             
				,ELECTROD_CONTACT_QNTY_1    
				,ELECTROD_CONTACT_QNTY_2    
				,ELECTROD_CONTACT_QNTY_3 
			    ,LF_NO   
			    ,WKSHIFT
			    ,WKGROUP            
			 	,XIN_DATE                   
		)values
		(
							?  
							,?
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
							,? 
		) 
        ]]>
    </query>
    
    <query id="NIG020510_02.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 通过电文中接收的炉次号查询炼钢参数表 TBF01_SPEC_CHARGE 取得的数据项 ，修改炼钢公共表 TBG02_CHARGE_COMM */
         select LINE_PROC_CD
			   ,PRODNM_CD
			   ,STL_GRD
			   ,HCR_CLF
			   ,CAST_MANA_NO
			   ,CAST_CHARGE_SEQ
			   ,CAST_EDT_CHARGE_CNT
		from   TBF01_SPEC_CHARGE
		where  CHARGE_MANA_NO = ?
        ]]>
    </query>
    
    <query id="NIG020510_02.update" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 通过电文中接收的炉次号查询炉次参数表 TBF01_SPEC_CHARGE 取得的数据项 ，插入炼钢公共表 TBF02_CHARGE_COM */
          update tbg02_charge_comm set
				   act_lf_rt = ? 
				   ,cur_prog_cd = ?
				   ,cur_prog_cd_reg_pgm = 'NIG020510'
				   ,cur_prog_cd_reg_dtime = to_char(sysdate,'yyyymmddhh24miss')
				   ,bef_prog_cd = ?
				   ,bef_prog_cd_reg_pgm = cur_prog_cd_reg_pgm
				   ,bef_prog_cd_reg_dtime = cur_prog_cd_reg_dtime
				   ,LF_ARRV_WGT = ?
			       ,LF_DEP_WGT  = ?
			       ,CHARGE_WGT  = ?
			       ,CHARGE_STAT = '2' 
			where  charge_no = ?
          
        ]]>
    </query>
    <query id="NIG020510_02.insert" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 转炉实绩发生以后 修改炼钢公共表 工序进程 */
			insert into tbg02_charge_comm
			(      charge_no
				   ,plan_charge_no
				   ,instr_rt
				   ,prodnm_cd
				   ,stl_grd
				   ,hcr_clf
				   ,cast_no
				   ,cast_charge_seq
				   ,cast_edt_charge_cnt 
			       ,CHARGE_STAT
				   ,act_lf_rt
				   ,cur_prog_cd
				   ,cur_prog_cd_reg_pgm
				   ,cur_prog_cd_reg_dtime
				   ,LF_ARRV_WGT
			       ,LF_DEP_WGT 
			       ,CHARGE_WGT
			       ,LF_END_DTIME
			       ,REG_DTIME
			       ,BEF_PROG_CD
                   ,BEF_PROG_CD_REG_DTIME
			)
			values
			(      ?
				   ,?
				   ,?
				   ,?
				   ,?
				   ,?
				   ,?
				   ,?
				   ,? 
			       ,'2'
				   ,?
				   ,'JLF'
				   ,'NIG020510'
				   ,to_char(sysdate,'yyyymmddhh24miss')
				   ,?
			       ,? 
			       ,?
			       ,to_char(sysdate,'yyyymmddhh24miss')
			       ,to_char(sysdate,'yyyymmddhh24miss')
			       ,'JBB'
                   ,to_char(sysdate,'yyyymmddhh24miss')
			)   
        ]]>
    </query>
	<query id="NIG020510_03.select" desc="it's selected query  from TBG03_MAINRAW table   " fetchSize="10">
        <![CDATA[
			/* 判断公共表是否有跟电文信息对应的数据 */
        select *
		from   tbg02_charge_comm
		where  charge_no = ?
        ]]>
    </query>
</queryMap>