| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG020050_01.select" desc="LF炉实绩查询 ">
- <![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.LF_No
- ,b.WKSHIFT
- ,b.WKGROUP
- ,decode(b.MOD_ID,null,b.REG_ID,b.MOD_ID) EMP_ID
- ,b.LD_NO
- ,b.LF_TREAT_CNT
- ,d.LF_TGT_TEMP
- ,d.LF_WK_HOUR_MIN
- ,d.LF_WK_HOUR_MAX
- ,b.ARRV_WGT
- ,b.LF_TREAT_WGT
- ,b.LF_TREAT_CNT
- ,b.SLAG_WGT
- ,b.TREAT_BEF_O2_WGT
- ,b.TREAT_AFT_O2_WGT
- ,b.AR_GAS_USE_WGT
- ,b.ELECPWR_USE_WGT
- ,b.O2_USE_WGT
- ,b.LF_ARRV_TEMP
- ,b.LF_STA_TEMP
- ,b.LF_END_TEMP
- ,b.LF_DEP_TEMP
- ,b.LF_ARRV_DTIME
- ,b.LF_STA_DTIME
- ,b.LF_END_DTIME
- ,b.LF_DEP_DTIME
- ,b.ELECFLOW_STA_DTIME
- ,b.LF_TREAT_HOUR
- ,b.AR_GAS_BLOW_HOUR
- ,b.ELECFLOW_HOUR
- ,b.ELECTROD_CONTACT_QNTY_1
- ,b.ELECTROD_CONTACT_QNTY_2
- ,b.ELECTROD_CONTACT_QNTY_3
-
- FROM tbg02_charge_comm a,
- tbg02_lf_result b,
- TBG03_LADLE_PROG c,
- TBG01_OPRN_STD d
- where a.LD_NO = c.LD_NO(+)
- and a.STL_GRD = d.STL_GRD(+)
- and a.Charge_No = b.CHARGE_NO(+)
- and a.CHARGE_NO = ?
- ]]>
- </query>
-
- <query id="UIG020050_01.insert" desc="无某炉次号时的插入LF实绩信息的操作">
- <![CDATA[
- insert into TBG02_LF_RESULT
- (
- CHARGE_NO
- ,XIN_DATE
- ,LF_NO
- ,WKSHIFT
- ,WKGROUP
- ,REG_ID
- ,ARRV_WGT
- ,LF_TREAT_WGT
- ,TREAT_BEF_O2_WGT
- ,TREAT_AFT_O2_WGT
- ,AR_GAS_USE_WGT
- ,ELECPWR_USE_WGT
- ,O2_USE_WGT
- ,LF_ARRV_DTIME
- ,LF_STA_DTIME
- ,LF_END_DTIME
- ,LF_DEP_DTIME
- ,ELECFLOW_STA_DTIME
- ,LF_TREAT_HOUR
- ,AR_GAS_BLOW_HOUR
- ,ELECFLOW_HOUR
- ,ELECTROD_CONTACT_QNTY_1
- ,ELECTROD_CONTACT_QNTY_2
- ,ELECTROD_CONTACT_QNTY_3
- ,PLAN_CHARGE_NO
- )
- values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
- ]]>
- </query>
-
- <query id="UIG020050_01.update" desc="更新LF实绩信息的某炉次号的信息">
- <![CDATA[
- update TBG02_LF_RESULT set
- XIN_DATE = ?
- ,LF_NO = ?
- ,WKSHIFT=?
- ,WKGROUP =?
- ,MOD_ID=?
-
- ,ARRV_WGT=?
- ,LF_TREAT_WGT = ?
- ,TREAT_BEF_O2_WGT = ?
- ,TREAT_AFT_O2_WGT = ?
- ,AR_GAS_USE_WGT = ?
- ,ELECPWR_USE_WGT = ?
- ,O2_USE_WGT = ?
-
- ,LF_ARRV_DTIME = ?
- ,LF_STA_DTIME = ?
- ,LF_END_DTIME = ?
- ,LF_DEP_DTIME = ?
- ,ELECFLOW_STA_DTIME = ?
- ,LF_TREAT_HOUR = ?
- ,AR_GAS_BLOW_HOUR = ?
- ,ELECFLOW_HOUR = ?
- ,ELECTROD_CONTACT_QNTY_1 = ?
- ,ELECTROD_CONTACT_QNTY_2 = ?
- ,ELECTROD_CONTACT_QNTY_3 = ?
- ,PLAN_CHARGE_NO = ?
- WHERE CHARGE_NO=?
- ]]>
- </query>
- <query id="UIG020050_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 = ?
- ,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_LF_RT = ?
- WHERE CHARGE_NO = ?
- ]]>
- </query>
- <query id="UIG020050_EMP.select" desc="查询LF作业人信息，这里PROC_CD为JJR " fetchSize="10">
- <![CDATA[
- SELECT EMP_NM label
- ,EMP_NM value
- FROM TBZ01_FAC_EMP_GROUP
- WHERE GROUP_CD = ?
- AND PROC_CD = 'JL'
- AND FAC_CD = 'J'
- ]]>
- </query>
- </queryMap>
|
