| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING PROGRESS ">
-
- <query id="NIG020210_01.select" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 通过电文中接收的炉次号查询转炉实绩表 tbg02_bof_result 来判断记录是否存在 */
- select charge_no
- from tbg02_bof_result
- where charge_no = ?
- ]]>
- </query>
- <query id="NIG020210_01.update" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 用电文信息修改转炉实绩表 */
- update TBG02_BOF_RESULT set
- PLAN_CH_NO = ?
- ,BOF_NO = ?
- ,SPEC_ABBSYM = ?
- ,TAPPING_WGT = ?
- ,PROD_PLAN_WGT = ?
- ,RATEIO = ?
- ,EPT_LD_WGT = ?
- ,TREAT_RT = ?
- ,BOF_WK_HOUR = ?
- ,CHARGE_HOUR = ?
- ,O2BLOW_HOUR = ?
- ,TAPPING_HOUR = ?
- ,O2BLOW_STEPNO = ?
- ,O2BLOW_AFT_TEMP = ?
- ,FST_O2BLOW_STA_DTIME = ?
- ,FST_O2BLOW_END_DTIME = ?
- ,FST_O2BLOW_AFT_TEMP = ?
- ,FST_O2BLOW_AFT_O2_CONSUME = ?
- ,SND_O2BLOW_STA_DTIME = ?
- ,SND_O2BLOW_END_DTIME = ?
- ,SND_O2BLOW_AFT_TEMP = ?
- ,SND_O2BLOW_AFT_O2_CONSUME = ?
- ,TRD_O2BLOW_STA_DTIME = ?
- ,TRD_O2BLOW_END_DTIME = ?
- ,TRD_O2BLOW_AFT_TEMP = ?
- ,TRD_O2BLOW_AFT_O2_CONSUME = ?
- ,FTH_O2BLOW_STA_DTIME = ?
- ,FTH_O2BLOW_END_DTIME = ?
- ,FTH_O2BLOW_AFT_TEMP = ?
- ,FTH_O2BLOW_AFT_O2_CONSUME = ?
- ,CHARGE_TEMP = ?
- ,TAPPING_AFT_TEMP = ?
- ,SCRAP_CHARGE_STA_DTIME = ?
- ,IRON_CHARGE_STA_DTIME = ?
- ,TAPPING_STA_DTIME = ?
- ,TAPPING_END_DTIME = ?
- ,SCRAP_ZINC_CHARGE_WGT = ?
- ,SCRAP_CHARGE_WGT = ?
- ,IRON_CHARGE_WGT = ?
- ,SUBRAW_WGT = ?
- ,O2_LANCE_ID = ?
- ,O2_LANCE_USE_CNT = ?
- ,BOF_USE_STEPNO = ?
- ,TAPPING_GATE_STEPNO = ?
- ,O2_CONSUME = ?
- ,AR_CONSUME = ?
- ,N2_CONSUME = ?
- ,WKSHIFT = ?
- ,WKGROUP = ?
- ,XIN_DATE = ?
- where CHARGE_NO = ?
- ]]>
- </query>
- <query id="NIG020210_01.insert" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 用电文中的信息修改 当前转炉实绩表 */
- insert into TBG02_BOF_RESULT
- (
- CHARGE_NO
- ,PLAN_CH_NO
- ,BOF_NO
- ,SPEC_ABBSYM
- ,TAPPING_WGT
- ,PROD_PLAN_WGT
- ,RATEIO
- ,EPT_LD_WGT
- ,TREAT_RT
- ,BOF_WK_HOUR
- ,CHARGE_HOUR
- ,O2BLOW_HOUR
- ,TAPPING_HOUR
- ,O2BLOW_STEPNO
- ,O2BLOW_AFT_TEMP
- ,FST_O2BLOW_STA_DTIME
- ,FST_O2BLOW_END_DTIME
- ,FST_O2BLOW_AFT_TEMP
- ,FST_O2BLOW_AFT_O2_CONSUME
- ,SND_O2BLOW_STA_DTIME
- ,SND_O2BLOW_END_DTIME
- ,SND_O2BLOW_AFT_TEMP
- ,SND_O2BLOW_AFT_O2_CONSUME
- ,TRD_O2BLOW_STA_DTIME
- ,TRD_O2BLOW_END_DTIME
- ,TRD_O2BLOW_AFT_TEMP
- ,TRD_O2BLOW_AFT_O2_CONSUME
- ,FTH_O2BLOW_STA_DTIME
- ,FTH_O2BLOW_END_DTIME
- ,FTH_O2BLOW_AFT_TEMP
- ,FTH_O2BLOW_AFT_O2_CONSUME
- ,CHARGE_TEMP
- ,TAPPING_AFT_TEMP
- ,SCRAP_CHARGE_STA_DTIME
- ,IRON_CHARGE_STA_DTIME
- ,TAPPING_STA_DTIME
- ,TAPPING_END_DTIME
- ,SCRAP_ZINC_CHARGE_WGT
- ,SCRAP_CHARGE_WGT
- ,IRON_CHARGE_WGT
- ,SUBRAW_WGT
- ,O2_LANCE_ID
- ,O2_LANCE_USE_CNT
- ,BOF_USE_STEPNO
- ,TAPPING_GATE_STEPNO
- ,O2_CONSUME
- ,AR_CONSUME
- ,N2_CONSUME
- ,WKSHIFT
- ,WKGROUP
- ,XIN_DATE
- )
- values
- (
- ?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- )
- ]]>
- </query>
-
- <query id="NIG020210_02.select" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 通过电文中接收的炉次号查询炼钢参数表 TBF01_SPEC_CHARGE 取得的数据项 ，修改炼钢公共表 TBF02_CHARGE_COMM */
- select a.CHARGE_MANA_NO
- , b.CHARGE_MANA_NO
- , a.LINE_PROC_CD
- , a.PRODNM_CD
- , a.STL_GRD
- , a.HCR_CLF
- , a.CAST_MANA_NO
- , a.CAST_CHARGE_SEQ
- , a.CAST_EDT_CHARGE_CNT
- , b.SLAB_RT
- from TBF01_SPEC_CHARGE a,TBF01_SPEC_SLAB b
- where a.CHARGE_MANA_NO = b.CHARGE_MANA_NO
- and a.CHARGE_MANA_NO = ?
- and rownum = 1
- ]]>
- </query>
-
- <query id="NIG020210_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_bof_rt = ?
- ,cur_prog_cd = ?
- ,cur_prog_cd_reg_pgm = 'NIG020210'
- ,cur_prog_cd_reg_dtime = to_char(sysdate,'yyyymmddhh24miss')
- ,bof_tapping_wgt = ?
- ,bof_end_dtime = ?
- ,bef_prog_cd = ?
- ,bef_prog_cd_reg_pgm = cur_prog_cd_reg_pgm
- ,bef_prog_cd_reg_dtime = cur_prog_cd_reg_dtime
- ,charge_wgt = ?
- ,SLAB_RT = ?
- where charge_no = ?
-
- ]]>
- </query>
- <query id="NIG020210_02.insert" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 转炉实绩发生以后 修改炼钢公共表 工序进程 */
- insert into tbg02_charge_comm
- ( charge_no
- ,charge_stat
- ,plan_charge_no
- ,instr_rt
- ,prodnm_cd
- ,stl_grd
- ,hcr_clf
- ,cast_no
- ,cast_charge_seq
- ,cast_edt_charge_cnt
- ,act_bof_rt
- ,cur_prog_cd
- ,cur_prog_cd_reg_pgm
- ,cur_prog_cd_reg_dtime
- ,bof_tapping_wgt
- ,bof_end_dtime
- ,charge_wgt
- ,REG_DTIME
- ,SLAB_RT
- ,BEF_PROG_CD
- ,BEF_PROG_CD_REG_DTIME
- )
- values
- ( ?
- ,'2'
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
-
- ,?
- ,'JBF'
- ,'NIG020210'
- ,to_char(sysdate,'yyyymmddhh24miss')
- ,?
- ,?
- ,?
- ,to_char(sysdate,'yyyymmddhh24miss')
- ,?
- ,'JBB'
- ,to_char(sysdate,'yyyymmddhh24miss')
- )
- ]]>
- </query>
- <query id="NIG020210_03.select" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 判断公共表是否有跟电文信息对应的数据 */
- select *
- from tbg02_charge_comm
- where charge_no = ?
- ]]>
- </query>
- <query id="NIG020210_SPEC_SLAB.select" desc=" " fetchSize="10">
- <![CDATA[
-
- SELECT SLAB_EDT_SEQ
- FROM TBF01_SPEC_SLAB
- where SLAB_MANA_NO like ?||'%'
- ]]>
- </query>
- <query id="NIG020210_SHIFT.select" desc=" " fetchSize="10">
- <![CDATA[
-
- SELECT GR_GROUP_CD
- FROM TBG02_SHIFT_GROUP
- WHERE GR_YYYYMM = ?
- AND GR_DD = ?
- AND GR_SHIFT = ?
- AND PROC_CD = ?
- ]]>
- </query>
- </queryMap>
|
