| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="KR RESULT ">
- <query id="NIG020100_01.select" desc=" 通过处理日期，预处理次数判断从点文中获取的记录在数据库中是否存在 " fetchSize="10">
- <![CDATA[
- /* 通过处理日期，预处理次数判断从电文中获取的记录在数据库中是否存在 */
- select * from tbg02_kr_result
- where KR_CHARGE_NO = ?
- ]]>
- </query>
-
- <query id="NIG020100_01.update" desc=" 从电文中接受的数据在数据库中存在，则用接受的数据修改数据中对应的记录 " fetchSize="10">
- <![CDATA[
- /* 从电文中接受的数据在数据库中存在，则用接受的数据修改数据中对应的记录 */
- update TBG02_KR_RESULT set
- OCR_DTIME = ?
- ,KR_NO = ?
- ,LD_NO = ?
- ,LD_ARRIV_DTIME = ?
- ,STA_DTIME = ?
- ,END_DTIME = ?
- ,LD_DEP_DTIME = ?
- ,IRON_RECV_WGT = ?
- ,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_STA_DTIME = ?
- ,BEF_SLAG_REMOVE_END_DTIME = ?
- ,BEF_SLAG_REMOVE_HOUR = ?
- ,BEF_SLAG_REMOVE_WGT = ?
- ,AFT_SLAG_REMOVE_STA_DTIME = ?
- ,AFT_SLAG_REMOVE_END_DTIME = ?
-
- ,AFT_SLAG_REMOVE_HOUR = ?
- ,AFT_SLAG_REMOVE_WGT = ?
- ,XIN_DATE = ?
- ,WKSHIFT = ?
- ,WKGROUP = ?
- where KR_CHARGE_NO = ?
- ]]>
- </query>
- <query id="NIG020100_01.insert" desc=" 从电文中接收的数据数据库没有，则插入一条新记录 " fetchSize="10">
- <![CDATA[
- /* 从电文中接收的数据数据库没有，则插入一条新记录 */
- insert into TBG02_KR_RESULT
- ( KR_CHARGE_NO
- ,OCR_DTIME
- ,KR_NO
- ,LD_NO
- ,LD_ARRIV_DTIME
- ,STA_DTIME
- ,END_DTIME
- ,LD_DEP_DTIME
- ,IRON_RECV_WGT
- ,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_STA_DTIME
- ,BEF_SLAG_REMOVE_END_DTIME
- ,BEF_SLAG_REMOVE_HOUR
- ,BEF_SLAG_REMOVE_WGT
- ,AFT_SLAG_REMOVE_STA_DTIME
-
- ,AFT_SLAG_REMOVE_END_DTIME
- ,AFT_SLAG_REMOVE_HOUR
- ,AFT_SLAG_REMOVE_WGT
- ,XIN_DATE
- ,WKSHIFT
- ,WKGROUP
- ,KR_STAT
- )values
- ( ?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
-
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
-
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
-
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- )
- ]]>
- </query>
- <query id="NIG020100_TRACK.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG03_SMS_TRACKING SET
- EVENT_CD = ?
- ,TREAT_WGT = ?
- ,TREAT_TEMP = ?
- ,TREAT_DTIME = ?
- ,KR_TREAT_NO = ?
- WHERE TREAT_CD = ?
- ]]>
- </query>
- </queryMap>
|
