| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING PROGRESS ">
-
- <query id="NIG020620_01.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT CHARGE_NO
-
- FROM TBG02_CC_RESULT
- WHERE CHARGE_NO = ?
- ]]>
- </query>
- <query id="NIG020620_02.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT CHARGE_NO
-
- FROM TBG02_CC_RESULT
- WHERE CHARGE_NO = ?
- ]]>
- </query>
- <query id="NIG020620_CHARGE_COMM.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_CHARGE_COMM SET
- CHARGE_STAT = '3'
- , ACT_CCM_RT = ?
- , MATRL_END_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- , CASTING_STA_DTIME = ?
- , CASTING_END_DTIME = ?
- WHERE CHARGE_NO = ?
- ]]>
- </query>
-
- <query id="NIG020620_CCM.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_CC_RESULT SET
- PLAN_CHARGE_NO = ?
- ,XIN_DATE = ?
- ,CAST_NO = ?
- ,CAST_EDT_CHARGE_CNT = ?
- ,CAST_CHARGE_SEQ = ?
- ,CAST_END_YN = ?
- ,CC_DEVNO = ?
- ,STLMELT_WGT = ?
- ,STLMELT_TEMP = ?
- ,CC_END_STLMELT_USE_WGT = ?
- ,REM_WGT_IN_LD = ?
- ,REM_WGT_IN_TD = ?
- ,CC_YIELD = ?
- ,CC_SPEED_AVG1 = ?
- ,CC_SPEED_MIN1 = ?
- ,CC_SPEED_MAX1 = ?
- ,CC_SPEED_AVG2 = ?
- ,CC_SPEED_MIN2 = ?
- ,CC_SPEED_MAX2 = ?
- ,TD_TEMP_AVG = ?
- ,TD_TEMP_MIN = ?
- ,TD_TEMP_MAX = ?
- ,LD_OPEN_YN = ?
- ,MD_LVL1 = ?
- ,MD_UPPER_WTH1 = ?
- ,MD_LOWER_WTH1 = ?
- ,MD_VIBRATE_CNT1 = ?
- ,MD_VIBRATE_WTH1 = ?
- ,MD_LVL2 = ?
- ,MD_UPPER_WTH2 = ?
- ,MD_LOWER_WTH2 = ?
- ,MD_VIBRATE_CNT2 = ?
- ,MD_VIBRATE_WTH2 = ?
- ,COOLWAT_WGT = ?
- ,LD_ARRV_DTIME = ?
- ,CC_STA_DTIME = ?
- ,LD_OPEN_DTIME = ?
- ,LD_CLOSE_DTIME = ?
- ,CC_END_DTIME = ?
- ,CC_HOUR = ?
- ,SLAB_TOTLEN = ?
- ,SLAB_PROD_CNT = ?
- ,SLAB_TOTWGT = ?
- ,REG_PGM_ID = 'XinSaveCcmResult'
- ,REG_DTIME = to_char(sysdate,'yyyymmddhh24miss')
- ,WKSHIFT = ?
- ,WKGROUP = ?
- WHERE CHARGE_NO = ?
- ]]>
- </query>
- <query id="NIG020620_REPORTCCM.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_CC_RESULT_REPORT SET
- PLAN_CHARGE_NO = ?
- ,XIN_DATE = ?
- ,CAST_NO = ?
- ,CAST_EDT_CHARGE_CNT = ?
- ,CAST_CHARGE_SEQ = ?
- ,CAST_END_YN = ?
- ,CC_DEVNO = ?
- ,STLMELT_WGT = ?
- ,STLMELT_TEMP = ?
- ,CC_END_STLMELT_USE_WGT = ?
- ,REM_WGT_IN_LD = ?
- ,REM_WGT_IN_TD = ?
- ,CC_YIELD = ?
- ,CC_SPEED_AVG1 = ?
- ,CC_SPEED_MIN1 = ?
- ,CC_SPEED_MAX1 = ?
- ,CC_SPEED_AVG2 = ?
- ,CC_SPEED_MIN2 = ?
- ,CC_SPEED_MAX2 = ?
- ,TD_TEMP_AVG = ?
- ,TD_TEMP_MIN = ?
- ,TD_TEMP_MAX = ?
- ,LD_OPEN_YN = ?
- ,MD_LVL1 = ?
- ,MD_UPPER_WTH1 = ?
- ,MD_LOWER_WTH1 = ?
- ,MD_VIBRATE_CNT1 = ?
- ,MD_VIBRATE_WTH1 = ?
- ,MD_LVL2 = ?
- ,MD_UPPER_WTH2 = ?
- ,MD_LOWER_WTH2 = ?
- ,MD_VIBRATE_CNT2 = ?
- ,MD_VIBRATE_WTH2 = ?
- ,COOLWAT_WGT = ?
- ,LD_ARRV_DTIME = ?
- ,CC_STA_DTIME = ?
- ,LD_OPEN_DTIME = ?
- ,LD_CLOSE_DTIME = ?
- ,CC_END_DTIME = ?
- ,CC_HOUR = ?
- ,SLAB_TOTLEN = ?
- ,SLAB_PROD_CNT = ?
- ,SLAB_TOTWGT = ?
- ,REG_PGM_ID = 'XinSaveCcmResult'
- ,REG_DTIME = to_char(sysdate,'yyyymmddhh24miss')
- ,WKSHIFT = ?
- ,WKGROUP = ?
- WHERE CHARGE_NO = ?
- ]]>
- </query>
-
- <query id="NIG020620_CCM.insert" desc=" " fetchSize="10">
- <![CDATA[
- insert into TBG02_CC_RESULT
- (
- CHARGE_NO
- ,PLAN_CHARGE_NO
- ,XIN_DATE
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,CAST_END_YN
- ,CC_DEVNO
- ,STLMELT_WGT
- ,STLMELT_TEMP
- ,CC_END_STLMELT_USE_WGT
- ,REM_WGT_IN_LD
- ,REM_WGT_IN_TD
- ,CC_YIELD
- ,CC_SPEED_AVG1
- ,CC_SPEED_MIN1
- ,CC_SPEED_MAX1
- ,CC_SPEED_AVG2
- ,CC_SPEED_MIN2
- ,CC_SPEED_MAX2
- ,TD_TEMP_AVG
- ,TD_TEMP_MIN
- ,TD_TEMP_MAX
- ,LD_OPEN_YN
- ,MD_LVL1
- ,MD_UPPER_WTH1
- ,MD_LOWER_WTH1
- ,MD_VIBRATE_CNT1
- ,MD_VIBRATE_WTH1
- ,MD_LVL2
- ,MD_UPPER_WTH2
- ,MD_LOWER_WTH2
- ,MD_VIBRATE_CNT2
- ,MD_VIBRATE_WTH2
- ,COOLWAT_WGT
- ,LD_ARRV_DTIME
- ,CC_STA_DTIME
- ,LD_OPEN_DTIME
- ,LD_CLOSE_DTIME
- ,CC_END_DTIME
- ,CC_HOUR
- ,SLAB_TOTLEN
- ,SLAB_PROD_CNT
- ,SLAB_TOTWGT
- ,REG_PGM_ID
- ,REG_DTIME
- ,WKSHIFT
- ,WKGROUP
- )
- values
- (
- ?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,'XinSaveCcmResult'
- ,to_char(sysdate,'yyyymmddhh24miss')
- ,?
- ,?
- )
- ]]>
- </query>
- <query id="NIG020620_REPORTCCM.insert" desc=" " fetchSize="10">
- <![CDATA[
- insert into TBG02_CC_RESULT_REPORT
- (
- CHARGE_NO
- ,PLAN_CHARGE_NO
- ,XIN_DATE
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,CAST_END_YN
- ,CC_DEVNO
- ,STLMELT_WGT
- ,STLMELT_TEMP
- ,CC_END_STLMELT_USE_WGT
- ,REM_WGT_IN_LD
- ,REM_WGT_IN_TD
- ,CC_YIELD
- ,CC_SPEED_AVG1
- ,CC_SPEED_MIN1
- ,CC_SPEED_MAX1
- ,CC_SPEED_AVG2
- ,CC_SPEED_MIN2
- ,CC_SPEED_MAX2
- ,TD_TEMP_AVG
- ,TD_TEMP_MIN
- ,TD_TEMP_MAX
- ,LD_OPEN_YN
- ,MD_LVL1
- ,MD_UPPER_WTH1
- ,MD_LOWER_WTH1
- ,MD_VIBRATE_CNT1
- ,MD_VIBRATE_WTH1
- ,MD_LVL2
- ,MD_UPPER_WTH2
- ,MD_LOWER_WTH2
- ,MD_VIBRATE_CNT2
- ,MD_VIBRATE_WTH2
- ,COOLWAT_WGT
- ,LD_ARRV_DTIME
- ,CC_STA_DTIME
- ,LD_OPEN_DTIME
- ,LD_CLOSE_DTIME
- ,CC_END_DTIME
- ,CC_HOUR
- ,SLAB_TOTLEN
- ,SLAB_PROD_CNT
- ,SLAB_TOTWGT
- ,REG_PGM_ID
- ,REG_DTIME
- ,WKSHIFT
- ,WKGROUP
- )
- values
- (
- ?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,'XinSaveCcmResult'
- ,to_char(sysdate,'yyyymmddhh24miss')
- ,?
- ,?
- )
- ]]>
- </query>
- </queryMap>
|
