| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG020040_01.select" desc="RH炉实绩查询 " fetchSize="10">
- <![CDATA[
- select
- a.CHARGE_NO
- ,a.PLAN_CHARGE_NO
- ,a.STL_GRD
- ,a.CAST_EDT_CHARGE_CNT ||'-'||a.CAST_CHARGE_SEQ CAST_SEQ
- ,b.XIN_DATE
- ,b.RH_NO
- ,b.WKSHIFT
- ,b.WKGROUP
- ,decode(b.MOD_ID,null,b.REG_ID,b.MOD_ID) EMP_ID
- ,b.LD_NO
- ,c.LD_CYCLIC_CNT
- ,d.RH_TGT_TEMP
- ,d.RH_WK_HOUR_MIN
- ,d.RH_WK_HOUR_MAX
- ,b.ARRV_WGT
- ,b.RH_TREAT_WGT
- ,b.RH_TREAT_CNT
- ,b.STEAM_USE_WGT
- ,b.AR_WGT
- ,b.O2_WGT
- ,b.N2_WGT
- ,b.TREAT_BEF_O2_WGT
- ,b.TREAT_AFT_O2_WGT
- ,b.TREAT_BEF_N2_WGT
- ,b.TREAT_AFT_N2_WGT
- ,b.TREAT_BEF_H_WGT
- ,b.TREAT_AFT_H_WGT
- ,b.RH_ARRV_TEMP
- ,b.RH_STA_TEMP
- ,b.RH_END_TEMP
- ,b.RH_DEP_TEMP
- ,b.WARMMATL_USE_WGT
- ,b.CHAFF_USE_WGT
- ,b.POWD1_USE_NAME
- ,b.POWD1_USE_WGT
- ,b.POWD2_USE_NAME
- ,b.POWD2_USE_WGT
- ,b.LST_VACC_DEGRE
- ,b.LD_ARRV_DTIME
- ,b.LD_RISE_STA_DTIME
- ,b.RH_TREAT_STA_DTIME
- ,b.RH_TREAT_END_DTIME
- ,b.LD_DOWN_DTIME
- ,b.LD_DEP_DTIME
- ,b.RH_TREAT_HOUR
- ,b.VACC_TREAT_HOUR
- ,b.AL_PUT_AFT_CIRGAS_HOUR
- from TBG02_CHARGE_COMM a,
- TBG02_RH_RESULT b,
- TBG03_LADLE_PROG c,
- TBG01_OPRN_STD d
- where c.LD_NO(+) = a.LD_NO
- and a.STL_GRD = d.STL_GRD(+)
- and a.CHARGE_NO = b.CHARGE_NO(+)
- and a.CHARGE_NO =?
-
- ]]>
- </query>
-
- <query id="UIG020040_01.insert" desc="无某炉次号时的插入操作">
- <![CDATA[
- insert into TBG02_RH_RESULT
- (
- CHARGE_NO
- ,XIN_DATE
- ,RH_NO
- ,WKSHIFT
- ,WKGROUP
- ,REG_ID
- ,ARRV_WGT
- ,RH_TREAT_WGT
- ,STEAM_USE_WGT
- ,AR_WGT
- ,O2_WGT
- ,N2_WGT
- ,RH_DEP_TEMP
- ,PLAN_CHARGE_NO
- )
- values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)
- ]]>
- </query>
-
- <query id="UIG020040_01.update" desc="更新某炉次号的信息">
- <![CDATA[
- update TBG02_RH_RESULT set
- XIN_DATE = ?
- ,RH_NO = ?
- ,WKSHIFT=?
- ,WKGROUP =?
- ,MOD_ID=?
- ,ARRV_WGT=?
- ,RH_TREAT_WGT=?
- ,STEAM_USE_WGT=?
- ,AR_WGT=?
- ,O2_WGT=?
- ,N2_WGT=?
- ,RH_DEP_TEMP=?
- ,PLAN_CHARGE_NO=?
- WHERE CHARGE_NO=?
- ]]>
- </query>
- <query id="UIG020040_CH_COM.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_CHARGE_COMM SET
- CUR_PROG_CD = ?
- ,CUR_PROG_CD_REG_PGM = ?
- ,CUR_PROG_CD_REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,BEF_PROG_CD = CUR_PROG_CD
- ,BEF_PROG_CD_REG_PGM = CUR_PROG_CD_REG_PGM
- ,BEF_PROG_CD_REG_DTIME = CUR_PROG_CD_REG_DTIME
- ,BOF_TAPPING_WGT = ?
- ,CHARGE_WGT = ?
- ,ACT_RH_RT = ?
- WHERE CHARGE_NO = ?
- ]]>
- </query>
-
- <query id="UIG020040_EMP.select" desc="查询RH作业人信息，这里PROC_CD为JJR " fetchSize="10">
- <![CDATA[
- SELECT EMP_NM label
- ,EMP_NM value
- FROM TBZ01_FAC_EMP_GROUP
- WHERE GROUP_CD = ?
- AND PROC_CD = 'JR'
- AND FAC_CD = 'J'
- ]]>
- </query>
- </queryMap>
|
