| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING PROGRESS ">
-
- <query id="NIG020310_01.select" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 通过电文中接收的炉次号查询转炉实绩表 tbg02_rh_result 来判断记录是否存在 */
- select charge_no
- from tbg02_rh_result
- where charge_no = ?
- ]]>
- </query>
- <query id="NIG020310_01.update" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 用电文信息修改转炉实绩表 */
- UPDATE tbg02_rh_result SET
- PLAN_CHARGE_NO =?
- ,RH_NO =?
- ,RH_TREAT_CNT =?
- ,ARRV_WGT =?
- ,RH_TREAT_WGT =?
- ,BB_YN =?
- ,STEAM_USE_WGT =?
- ,AR_WGT =?
- ,O2_WGT =?
- ,N2_WGT =?
- ,TREAT_BEF_O2_WGT =?
- ,TREAT_AFT_O2_WGT =?
- ,TREAT_BEF_N2_WGT =?
- ,TREAT_AFT_N2_WGT =?
- ,TREAT_BEF_H_WGT =?
- ,TREAT_AFT_H_WGT =?
- ,WARMMATL_USE_WGT =?
- ,CHAFF_USE_WGT =?
- ,RH_TREAT_HOUR =?
- ,VACC_TREAT_HOUR =?
- ,AL_PUT_AFT_CIRGAS_HOUR =?
- ,AR_PUT_HOUR =?
- ,N2_PUT_HOUR =?
- ,LD_ARRV_DTIME =?
- ,LD_RISE_STA_DTIME =?
- ,RH_TREAT_STA_DTIME =?
- ,RH_TREAT_END_DTIME =?
- ,LD_DOWN_DTIME =?
- ,LD_DEP_DTIME =?
- ,LST_VACC_DEGRE =?
- ,RH_ARRV_TEMP =?
- ,RH_STA_TEMP =?
- ,RH_END_TEMP =?
- ,RH_DEP_TEMP =?
- ,POWD1_USE_NAME =?
- ,POWD1_USE_WGT =?
- ,POWD2_USE_NAME =?
- ,POWD2_USE_WGT =?
- ,XIN_DATE =?
- ,WKSHIFT =?
- ,WKGROUP =?
- where charge_no = ?
- ]]>
- </query>
- <query id="NIG020310_01.insert" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 用电文中的信息修改 当前RH炉实绩表 */
- insert into tbg02_rh_result
- ( CHARGE_NO
- ,PLAN_CHARGE_NO
- ,RH_NO
- ,RH_TREAT_CNT
- ,ARRV_WGT
- ,RH_TREAT_WGT
- ,BB_YN
- ,STEAM_USE_WGT
- ,AR_WGT
- ,O2_WGT
- ,N2_WGT
- ,TREAT_BEF_O2_WGT
- ,TREAT_AFT_O2_WGT
- ,TREAT_BEF_N2_WGT
- ,TREAT_AFT_N2_WGT
- ,TREAT_BEF_H_WGT
- ,TREAT_AFT_H_WGT
- ,WARMMATL_USE_WGT
- ,CHAFF_USE_WGT
- ,RH_TREAT_HOUR
- ,VACC_TREAT_HOUR
- ,AL_PUT_AFT_CIRGAS_HOUR
- ,AR_PUT_HOUR
- ,N2_PUT_HOUR
- ,LD_ARRV_DTIME
- ,LD_RISE_STA_DTIME
- ,RH_TREAT_STA_DTIME
- ,RH_TREAT_END_DTIME
- ,LD_DOWN_DTIME
- ,LD_DEP_DTIME
- ,LST_VACC_DEGRE
- ,RH_ARRV_TEMP
- ,RH_STA_TEMP
- ,RH_END_TEMP
- ,RH_DEP_TEMP
- ,POWD1_USE_NAME
- ,POWD1_USE_WGT
- ,POWD2_USE_NAME
- ,POWD2_USE_WGT
- ,XIN_DATE
- ,WKSHIFT
- ,WKGROUP
-
- )values
- ( ?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
-
- )
- ]]>
- </query>
-
- <query id="NIG020310_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="NIG020310_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_rh_rt = ?
- ,cur_prog_cd = ?
- ,cur_prog_cd_reg_pgm = 'NIG020310'
- ,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
- ,RH_ARRV_WGT = ?
- ,RH_DEP_WGT = ?
- ,CHARGE_STAT = '2'
- ,CHARGE_WGT = ?
- where charge_no = ?
-
- ]]>
- </query>
- <query id="NIG020310_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_rh_rt
- ,cur_prog_cd
- ,cur_prog_cd_reg_pgm
- ,cur_prog_cd_reg_dtime
- ,RH_ARRV_WGT
- ,RH_DEP_WGT
- ,CUR_PROG_CD
- ,BEF_PROG_CD
- ,CHARGE_WGT
- ,RH_END_DTIME
- ,REG_DTIME
- ,BEF_PROG_CD
- ,BEF_PROG_CD_REG_DTIME
- )
- values
- ( ?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,'2'
- ,?
- ,'JRF'
- ,'NIG020310'
- ,to_char(sysdate,'yyyymmddhh24miss')
- ,?
- ,?
- ,?
- ,to_char(sysdate,'yyyymmddhh24miss')
- ,to_char(sysdate,'yyyymmddhh24miss')
- ,'JBB'
- ,to_char(sysdate,'yyyymmddhh24miss')
- )
- ]]>
- </query>
- <query id="NIG020310_03.select" desc="it's selected query from TBG03_MAINRAW table " fetchSize="10">
- <![CDATA[
- /* 判断公共表是否有跟电文信息对应的数据 */
- select *
- from tbg02_charge_comm
- where charge_no = ?
- ]]>
- </query>
- </queryMap>
|
