| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG020010_krResult.select" desc=" 查询预处理实绩 " fetchSize="10">
- <![CDATA[
- /* SELECT KR_CHARGE_NO
- ,IRON_RECV_WGT
- ,OCR_DTIME
- ,LD_NO
- ,LD_ARRIV_DTIME
- ,STA_DTIME
- ,END_DTIME
- ,LD_DEP_DTIME
- ,KR_NO,WKSHIFT
- ,WKGROUP,REG_ID
- ,TREAT_AFT_S_WGT
- ,TREAT_AFT_P_WGT
- ,TREAT_AFT_C_WGT
- ,TREAT_AFT_MN_WGT
- ,TREAT_AFT_SI_WGT
- ,TREAT_AFT_TI_WGT
- ,END_TEMP
- ,BEF_SLAG_REMOVE_YN
- ,AFT_SLAG_REMOVE_YN
- ,MGO_CAL_WGT
- ,CAO_CAL_WGT
- ,MGO_WKER_INPUT_WGT
- ,CAO_WKER_INPUT_WGT
- ,MIX_TREAT_HOUR
- ,MIX_STA_DTIME
- ,MIX_END_DTIME
- ,BEF_SLAG_REMOVE_WGT
- ,BEF_SLAG_REMOVE_HOUR
- ,BEF_SLAG_REMOVE_STA_DTIME
- ,BEF_SLAG_REMOVE_END_DTIME
- ,AFT_SLAG_REMOVE_WGT
- ,AFT_SLAG_REMOVE_HOUR
- ,AFT_SLAG_REMOVE_STA_DTIME
- ,AFT_SLAG_REMOVE_END_DTIME
- FROM
-
- (
- SELECT KR_CHARGE_NO
- ,IRON_RECV_WGT
- ,OCR_DTIME
- ,LD_NO
- ,LD_ARRIV_DTIME
- ,STA_DTIME
- ,END_DTIME
- ,LD_DEP_DTIME
- ,KR_NO,WKSHIFT
- ,WKGROUP,REG_ID
- ,TREAT_AFT_S_WGT
- ,TREAT_AFT_P_WGT
- ,TREAT_AFT_C_WGT
- ,TREAT_AFT_MN_WGT
- ,TREAT_AFT_SI_WGT
- ,TREAT_AFT_TI_WGT
- ,END_TEMP
- ,BEF_SLAG_REMOVE_YN
- ,AFT_SLAG_REMOVE_YN
- ,MGO_CAL_WGT
- ,CAO_CAL_WGT
- ,MGO_WKER_INPUT_WGT
- ,CAO_WKER_INPUT_WGT
- ,MIX_TREAT_HOUR
- ,MIX_STA_DTIME
- ,MIX_END_DTIME
- ,BEF_SLAG_REMOVE_WGT
- ,BEF_SLAG_REMOVE_HOUR
- ,BEF_SLAG_REMOVE_STA_DTIME
- ,BEF_SLAG_REMOVE_END_DTIME
- ,AFT_SLAG_REMOVE_WGT
- ,AFT_SLAG_REMOVE_HOUR
- ,AFT_SLAG_REMOVE_STA_DTIME
- ,AFT_SLAG_REMOVE_END_DTIME
- FROM
-
- (
- SELECT KR_CHARGE_NO
- ,IRON_RECV_WGT
- ,OCR_DTIME
- ,LD_NO
- ,LD_ARRIV_DTIME
- ,STA_DTIME
- ,END_DTIME
- ,LD_DEP_DTIME
- ,KR_NO,WKSHIFT
- ,WKGROUP,REG_ID
- ,TREAT_AFT_S_WGT
- ,TREAT_AFT_P_WGT
- ,TREAT_AFT_C_WGT
- ,TREAT_AFT_MN_WGT
- ,TREAT_AFT_SI_WGT
- ,TREAT_AFT_TI_WGT
- ,END_TEMP
- ,BEF_SLAG_REMOVE_YN
- ,AFT_SLAG_REMOVE_YN
- ,MGO_CAL_WGT
- ,CAO_CAL_WGT
- ,MGO_WKER_INPUT_WGT
- ,CAO_WKER_INPUT_WGT
- ,MIX_TREAT_HOUR
- ,MIX_STA_DTIME
- ,MIX_END_DTIME
- ,BEF_SLAG_REMOVE_WGT
- ,BEF_SLAG_REMOVE_HOUR
- ,BEF_SLAG_REMOVE_STA_DTIME
- ,BEF_SLAG_REMOVE_END_DTIME
- ,AFT_SLAG_REMOVE_WGT
- ,AFT_SLAG_REMOVE_HOUR
- ,AFT_SLAG_REMOVE_STA_DTIME
- ,AFT_SLAG_REMOVE_END_DTIME
- FROM TBG02_KR_RESULT
- WHERE TREAT_DATE <= ?
- AND TREAT_STEPNO <= ?
- order by TREAT_DATE desc,TREAT_STEPNO desc
- )
- WHERE ROWNUM = 1
- UNION ALL
- SELECT ? TREAT_DATE
- ,'01' TREAT_STEPNO
- , null IRON_RECV_WGT
- ,'' OCR_DTIME
- ,'' LD_NO
- ,'' LD_ARRIV_DTIME
- ,'' STA_DTIME
- ,'' END_DTIME
- ,'' LD_DEP_DTIME
- ,'' KR_NO
- ,'' WKSHIFT
- ,'' WKGROUP
- ,'' REG_ID
- ,null TREAT_AFT_S_WGT
- ,null TREAT_AFT_P_WGT
- ,null TREAT_AFT_C_WGT
- ,null TREAT_AFT_MN_WGT
- ,null TREAT_AFT_SI_WGT
- ,null TREAT_AFT_TI_WGT
- ,null END_TEMP
- ,'' BEF_SLAG_REMOVE_YN
- ,'' AFT_SLAG_REMOVE_YN
- ,null MGO_CAL_WGT
- ,null CAO_CAL_WGT
- ,null MGO_WKER_INPUT_WGT
- ,null CAO_WKER_INPUT_WGT
- ,null MIX_TREAT_HOUR
- ,'' MIX_STA_DTIME
- ,'' MIX_END_DTIME
- ,null BEF_SLAG_REMOVE_WGT
- ,null BEF_SLAG_REMOVE_HOUR
- ,'' BEF_SLAG_REMOVE_STA_DTIME
- ,'' BEF_SLAG_REMOVE_END_DTIME
- ,null AFT_SLAG_REMOVE_WGT
- ,null AFT_SLAG_REMOVE_HOUR
- ,'' AFT_SLAG_REMOVE_STA_DTIME
- ,'' AFT_SLAG_REMOVE_END_DTIME
- FROM DUAL
- WHERE ROWNUM = 1
-
- order by TREAT_DATE desc,TREAT_STEPNO desc
- )
- where ROWNUM = 1 */
-
- SELECT KR_CHARGE_NO
- ,IRON_RECV_WGT
- ,OCR_DTIME
- ,LD_NO
- ,LD_ARRIV_DTIME
- ,STA_DTIME
- ,END_DTIME
- ,LD_DEP_DTIME
- ,KR_NO,WKSHIFT
- ,WKGROUP,REG_ID
- ,TREAT_AFT_S_WGT
- ,TREAT_AFT_P_WGT
- ,TREAT_AFT_C_WGT
- ,TREAT_AFT_MN_WGT
- ,TREAT_AFT_SI_WGT
- ,TREAT_AFT_TI_WGT
- ,END_TEMP
- ,BEF_SLAG_REMOVE_YN
- ,AFT_SLAG_REMOVE_YN
- ,MGO_CAL_WGT
- ,CAO_CAL_WGT
- ,MGO_WKER_INPUT_WGT
- ,CAO_WKER_INPUT_WGT
- ,MIX_TREAT_HOUR
- ,MIX_STA_DTIME
- ,MIX_END_DTIME
- ,BEF_SLAG_REMOVE_WGT
- ,BEF_SLAG_REMOVE_HOUR
- ,BEF_SLAG_REMOVE_STA_DTIME
- ,BEF_SLAG_REMOVE_END_DTIME
- ,AFT_SLAG_REMOVE_WGT
- ,AFT_SLAG_REMOVE_HOUR
- ,AFT_SLAG_REMOVE_STA_DTIME
- ,AFT_SLAG_REMOVE_END_DTIME
- FROM TBG02_KR_RESULT
- where KR_CHARGE_NO = ?
- ]]>
- </query>
- <query id="UIG020010_krResult.update" desc=" 预处理实绩修改 " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_KR_RESULT SET
- IRON_RECV_WGT = ?
- ,LD_NO = ?
- ,LD_ARRIV_DTIME = ?
- ,STA_DTIME = ?
- ,END_DTIME = ?
- ,LD_DEP_DTIME = ?
- ,KR_NO = ?
- ,WKSHIFT = ?
- ,WKGROUP = ?
- ,REG_ID = ?
- ,END_TEMP = ?
- ,MGO_WKER_INPUT_WGT = ?
- ,CAO_WKER_INPUT_WGT = ?
- WHERE KR_CHARGE_NO = ?
- ]]>
- </query>
- <query id="UIG020010_krResult.insert" desc=" 预处理实绩插入 " fetchSize="10">
- <![CDATA[
- INSERT INTO TBG02_KR_RESULT
- ( KR_CHARGE_NO
- ,IRON_RECV_WGT
- ,LD_NO
- ,LD_ARRIV_DTIME
- ,STA_DTIME
- ,END_DTIME
- ,LD_DEP_DTIME
- ,KR_NO
- ,WKSHIFT
- ,WKGROUP
-
- ,REG_ID
- ,END_TEMP
- ,MGO_WKER_INPUT_WGT
- ,CAO_WKER_INPUT_WGT
- ,KR_STAT
- )
- VALUES
- (
- ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
- , ?
-
- , ?
- , ?
- , ?
- , ?
- , ?
- )
- ]]>
- </query>
- <query id="UIG020010_status.select" desc=" 判断预处理插入或修改操作的查询语句 " fetchSize="10">
- <![CDATA[
- SELECT KR_CHARGE_NO
- FROM TBG02_KR_RESULT
- WHERE KR_CHARGE_NO = ?
- ]]>
- </query>
- <query id="UIG020010_LD_NO.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT LD_NO label,LD_NO value
- FROM TBG03_LADLE_PROG
- WHERE LD_NO LIKE 'S%'
- ]]>
- </query>
- </queryMap>
|
