1 11:12:43 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 1410 and RowNum <= 10 order by DLRQSJ DESC
2 11:12:44 SQL Execute: ORACLE - RollBack
3 11:12:44 SQL Data In: ORACLE - Rows affected = 0
4 11:12:44 SQL Execute: ORACLE - Commit
5 11:12:44 SQL Data In: ORACLE - Rows affected = 0
6 11:12:44 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000= 4068027
7 11:12:44 SQL Data In: ORACLE - Rows affected = 1
8 11:12:44 SQL Execute: ORACLE - Commit
9 11:12:44 SQL Data In: ORACLE - Rows affected = 0
10 11:12:44 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='4' and KJLB00 ='3'
11 11:12:44 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = '4' and KJLB00 < '3' order by XH0000
12 11:12:44 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'4'||',')>0
13 11:12:44 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1410 and XTDM00 = '4'
14 11:12:44 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '4'
15 11:12:44 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
493 and FLAG00 like '0'
order by decode(CKBH00,862,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00
16 11:12:44 SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1))
17 11:12:44 SQL Execute: ORACLE - update XT_XTLJ00 set XTDM00='4' where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1))
18 11:12:45 SQL Data In: ORACLE - Rows affected = 1
19 11:12:45 SQL Execute: ORACLE - Commit
20 11:12:45 SQL Data In: ORACLE - Rows affected = 0
21 11:12:45 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual
22 11:12:45 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(SERIAL#) from V$session where AUDSID= userenv('SESSIONID'))
23 11:12:45 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(4068100,1410,'YR200619-WRBZ','4',nvl('17658875',' '),'192.168.202.164#2987:38065@appYLZHis.exe',493,'192.168.202.164')
24 11:12:45 SQL Data In: ORACLE - Rows affected = 1
25 11:12:45 SQL Execute: ORACLE - Commit
26 11:12:45 SQL Data In: ORACLE - Rows affected = 0
27 11:12:45 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '192.168.202.164' and NAME00 = 'QDXTJZ'
28 11:12:45 SQL Execute: ORACLE - select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0 from ( select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0 from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = '4' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0 from VW_PT_YHCDMK_JG a where YGBH00 = 1410 and XTDM00 = '4') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00
29 11:12:45 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1410 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll')
30 11:12:45 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=1410 and XTDM00='4' order by XH0000
31 11:12:45 SQL Misc: ORACLE - Set stored procedure on or off
32 11:12:45 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1410.000000
33 11:12:45 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000
34 11:12:45 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20472763.000000
35 11:12:45 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
36 11:12:45 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1410 and CZXH00 = 20472763.00)
37 11:12:45 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'
38 11:12:45 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='4'
39 11:12:45 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00
40 11:12:45 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = ''
41 11:12:45 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=493
42 11:12:45 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=493
43 11:12:45 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035'
44 11:12:45 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL
45 11:12:45 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual
46 11:12:45 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(493) as SFBZDJ from dual
47 11:12:45 SQL Execute: ORACLE - select MC0000 from bm_tyzd00 where ZDMC00='民生通系统参数' and BH0000='pMstTxXe'
48 11:12:45 SQL Execute: ORACLE - select MC0000 from bm_tyzd00 where ZDMC00='民生通系统参数' and BH0000='pMstYBJSFHCZ'
49 11:12:45 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=0
50 11:12:45 SQL Execute: ORACLE - select name00,bz0000,value0 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','XT_JEQZ00', 'XT_YBJEQZ','SF_NNGHDTL','XT_BRBYKFB','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','MZ_FPGS00','SF_XMYBZLFID')
51 11:12:45 SQL Execute: ORACLE - select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBYL' and YBYLZD>='YBYL01' order by YBYLZD
52 11:12:45 SQL Execute: ORACLE - select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBSM' and YBYLZD>='YBSM01' order by YBYLZD
53 11:12:45 SQL Execute: ORACLE - select VALUE0,BZ0000,sysdate as DTRQ00 from XT_XTCS00 where NAME00='SF_XNHFK'
54 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数
55 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT
56 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
57 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
58 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen
59 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
60 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 民生通系统参数
61 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = PmstOpen
62 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
63 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
64 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ
65 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
66 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台
67 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ
68 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
69 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台
70 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = JSHSFHC
71 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
72 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
73 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = JKQYSQM
74 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
75 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
76 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = SFJYSZFW
77 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
78 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
79 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ
80 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
81 11:12:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
82 11:12:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = YBXJKSQM
83 11:12:45 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
84 11:12:45 SQL Execute: ORACLE - select MZHTBZ from XT_YYXX00 where YYID00='220035'
85 11:12:45 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')
86 11:12:45 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1
87 11:12:45 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1
88 11:12:45 SQL Execute: ORACLE - select ZWXM00||'['||XKH000||']' from VW_SF_SFY000 order by ZWXM00
89 11:12:46 SQL Execute: ORACLE - Select YGBH00 from BM_YGBM00 where XKH000='100666'
90 11:12:46 SQL Execute: ORACLE - select * from VW_BM_PJLYQK where PJLXBM in (select PLBH00 from BM_PJLXB0 where XTDM00='4' and SFYX00='Y') and PJZT00 in ('未用','在用' ) and PJSYR0 = 1410 order by PJZT00 desc,PJLXBM,PJFFRQ
91 11:12:46 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1410,'值班公用','192.168.202.164','00-23-24-AD-2D-4B','4','ACT_SF_SFZHCX','17658875')
92 11:12:46 SQL Data In: ORACLE - Rows affected = 1
93 11:12:46 SQL Execute: ORACLE - Commit
94 11:12:46 SQL Data In: ORACLE - Rows affected = 0
95 11:12:47 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'
96 11:12:47 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='4'
97 11:12:47 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00
98 11:12:47 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = ''
99 11:12:48 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=493
100 11:12:48 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=493
101 11:12:48 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035'
102 11:12:48 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL
103 11:12:48 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual
104 11:12:48 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(493) as SFBZDJ from dual
105 11:12:48 SQL Execute: ORACLE - select MC0000 from bm_tyzd00 where ZDMC00='民生通系统参数' and BH0000='pMstTxXe'
106 11:12:48 SQL Execute: ORACLE - select MC0000 from bm_tyzd00 where ZDMC00='民生通系统参数' and BH0000='pMstYBJSFHCZ'
107 11:12:48 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=0
108 11:12:48 SQL Execute: ORACLE - select name00,bz0000,value0 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','XT_JEQZ00', 'XT_YBJEQZ','SF_NNGHDTL','XT_BRBYKFB','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','MZ_FPGS00','SF_XMYBZLFID')
109 11:12:48 SQL Execute: ORACLE - select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBYL' and YBYLZD>='YBYL01' order by YBYLZD
110 11:12:48 SQL Execute: ORACLE - select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBSM' and YBYLZD>='YBSM01' order by YBYLZD
111 11:12:48 SQL Execute: ORACLE - select VALUE0,BZ0000,sysdate as DTRQ00 from XT_XTCS00 where NAME00='SF_XNHFK'
112 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数
113 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT
114 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
115 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
116 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen
117 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
118 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 民生通系统参数
119 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = PmstOpen
120 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
121 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
122 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ
123 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
124 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台
125 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ
126 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
127 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台
128 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = JSHSFHC
129 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
130 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
131 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = JKQYSQM
132 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
133 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
134 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = SFJYSZFW
135 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
136 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
137 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ
138 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
139 11:12:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
140 11:12:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = YBXJKSQM
141 11:12:48 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
142 11:12:48 SQL Execute: ORACLE - select MZHTBZ from XT_YYXX00 where YYID00='220035'
143 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'Open_MZ'
144 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Open_ZY'
145 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBJYDZ_ZY'
146 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Start_ZY'
147 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Open_MZ'
148 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBJYDZ_MZ'
149 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Start_MZ'
150 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBXJKSQM'
151 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Update_MZ'
152 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBOneLogin'
153 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'DJCXTBMXZF'
154 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'NoCardSettlement'
155 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'ZGCXSFXYZDK'
156 11:12:48 SQL Execute: ORACLE - select SF_XT_XYBJKSFXYDL('') SFXYDL from dual
157 11:12:48 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM'
158 11:12:48 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='第三方电子发票平台接口'
159 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '通用平台病人主索引接口设置' and BH0000 = 'OPEN_MZ'
160 11:12:48 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='通用平台病人主索引接口设置' and YXBZ00='1'
161 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_MZ'
162 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'PACS接口字典' and BH0000 = 'PACSYYJK_Open'
163 11:12:48 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
164 11:12:48 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1410,'值班公用','192.168.202.164','00-23-24-AD-2D-4B','4','ACT_MZSF_MZKCZ0','17658875')
165 11:12:48 SQL Data In: ORACLE - Rows affected = 1
166 11:12:48 SQL Execute: ORACLE - Commit
167 11:12:48 SQL Data In: ORACLE - Rows affected = 0
168 11:12:50 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
169 11:12:50 SQL Execute: ORACLE - Select SYSDATE from Dual
170 11:12:50 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
171 11:12:50 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FJYB'
and KLDH00 not in ('CK','JMCK')
172 11:12:50 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
173 11:12:52 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FZYB'
and KLDH00 not in ('CK','JMCK')
174 11:12:52 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-MTYB'
and KLDH00 not in ('CK','JMCK')
175 11:12:52 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'CK_BC'
and KLDH00 not in ('CK','JMCK')
176 11:12:52 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
177 11:12:52 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
178 11:12:52 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'Face_Open'
179 11:12:52 SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'EWMCTTCMS'), '1') VALUE0 from dual
180 11:12:52 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL
181 11:12:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡
182 11:12:52 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
183 11:12:52 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual
184 11:12:52 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,YHSKXX)values ('YHPZ06100002227559','HIS请求参数','9.010000医保电子凭证信息查询N01410值班公用4930Y')
185 11:12:52 SQL Data In: ORACLE - Rows affected = 1
186 11:12:52 SQL Misc: ORACLE - Set stored procedure on or off
187 11:12:52 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
188 11:12:52 SQL Data In: ORACLE - Param = 2, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10000.000000
189 11:12:52 SQL Data In: ORACLE - Param = 3, Name = PDDLSH0, Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
190 11:12:52 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1410.000000
191 11:12:52 SQL Data In: ORACLE - Param = 5, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 值班公用
192 11:12:52 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
193 11:12:52 SQL Data In: ORACLE - Param = 7, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
194 11:12:52 SQL Data In: ORACLE - Param = 8, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
195 11:12:52 SQL Data In: ORACLE - Param = 9, Name = PINDATA, Type = fldZSTRING, Precision = 17, Scale = 0, Data =
196 11:12:52 SQL Data In: ORACLE - Param = 10, Name = PSMFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
197 11:12:52 SQL Data In: ORACLE - Param = 11, Name = PJKLXBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
198 11:12:52 SQL Execute: ORACLE - BEGIN "SP_SF_DZXNJKKRZ" (PBRID00 => :PBRID00,PJKLXBH => :PJKLXBH,PDDLSH0 => :PDDLSH0,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG,PINDATA => :PINDATA,PSMFS00 => :PSMFS00,PJKLXBZ => :PJKLXBZ); END;
199 11:12:52 SQL Execute: ORACLE - COMMIT
200 11:12:52 SQL Data In: ORACLE - Rows affected = 0
201 11:12:52 SQL Execute: ORACLE - COMMIT
202 11:12:52 SQL Data In: ORACLE - Rows affected = 0
203 11:12:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
204 11:12:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = biz_content参数集合
205 11:12:52 SQL Execute: ORACLE - Select * from VW_SF_DZXNJKKRZ where DDLSH0=? and MKLXMC=? and CZLX00 in ('1','3')
206 11:12:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
207 11:12:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
208 11:12:52 SQL Execute: ORACLE - Select * from VW_SF_DZXNJKKRZ where DDLSH0=? and MKLXMC=? and CZLX00 in ('1','3')
order by ZDBH00
209 11:12:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
210 11:12:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
211 11:12:52 SQL Execute: ORACLE - Select * from VW_SF_DZXNJKKRZ where DDLSH0=? and MKLXMC=? and CZLX00 in ('1','3')
order by ZDBH00
212 11:12:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
213 11:12:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
214 11:12:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = sign
215 11:12:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
216 11:12:52 SQL Execute: ORACLE - update BM_ZFPTCS set YHSKXX=?,CZLX00=1 where DDLSH0=? and ZDBH00=? and MKLXMC=?
217 11:12:52 SQL Data In: ORACLE - Rows affected = 1
218 11:12:52 SQL Execute: ORACLE - COMMIT
219 11:12:52 SQL Data In: ORACLE - Rows affected = 0
220 11:12:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
221 11:12:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
222 11:12:52 SQL Execute: ORACLE - Select * from VW_SF_DZXNJKKRZ where DDLSH0=? and MKLXMC=? and CZLX00 in ('1','3')
order by ZDBH00
223 11:12:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
224 11:12:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
225 11:12:54 SQL Execute: ORACLE - Select * from VW_SF_DZXNJKKRZ where DDLSH0=? and MKLXMC=? and CZLX00 in ('2','3')
226 11:12:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 100013
227 11:12:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
228 11:12:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = respCode
229 11:12:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
230 11:12:54 SQL Execute: ORACLE - update BM_ZFPTCS set JKQQCS=? where DDLSH0=? and ZDBH00=? and MKLXMC=?
231 11:12:54 SQL Data In: ORACLE - Rows affected = 1
232 11:12:54 SQL Execute: ORACLE - COMMIT
233 11:12:54 SQL Data In: ORACLE - Rows affected = 0
234 11:12:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 用户取消交易
235 11:12:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
236 11:12:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = respMsg
237 11:12:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
238 11:12:54 SQL Execute: ORACLE - update BM_ZFPTCS set JKQQCS=? where DDLSH0=? and ZDBH00=? and MKLXMC=?
239 11:12:54 SQL Data In: ORACLE - Rows affected = 1
240 11:12:54 SQL Execute: ORACLE - COMMIT
241 11:12:54 SQL Data In: ORACLE - Rows affected = 0
242 11:12:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
243 11:12:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = HIS请求参数
244 11:12:54 SQL Execute: ORACLE - update BM_ZFPTCS set JKQQCS=? where DDLSH0=? and MKLXMC=?
245 11:12:54 SQL Data In: ORACLE - Rows affected = 1
246 11:12:54 SQL Execute: ORACLE - COMMIT
247 11:12:54 SQL Data In: ORACLE - Rows affected = 0
248 11:12:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 100013
249 11:12:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
250 11:12:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = respCode
251 11:12:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
252 11:12:54 SQL Execute: ORACLE - update BM_ZFPTCS set JKQQCS=? where DDLSH0=? and ZDBH00=? and MKLXMC=?
253 11:12:54 SQL Data In: ORACLE - Rows affected = 1
254 11:12:54 SQL Execute: ORACLE - COMMIT
255 11:12:54 SQL Data In: ORACLE - Rows affected = 0
256 11:12:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 用户取消交易
257 11:12:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = YHPZ06100002227559
258 11:12:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = respMsg
259 11:12:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 接口请求参数
260 11:12:54 SQL Execute: ORACLE - update BM_ZFPTCS set JKQQCS=? where DDLSH0=? and ZDBH00=? and MKLXMC=?
261 11:12:54 SQL Data In: ORACLE - Rows affected = 1
262 11:12:54 SQL Execute: ORACLE - COMMIT
263 11:12:54 SQL Data In: ORACLE - Rows affected = 0
264 11:12:54 SQL Execute: ORACLE - COMMIT
265 11:12:54 SQL Data In: ORACLE - Rows affected = 0
266 11:12:54 SQL Execute: ORACLE - RollBack
267 11:12:54 SQL Data In: ORACLE - Rows affected = 0
268 11:12:55 SQL Execute: ORACLE - COMMIT
269 11:12:55 SQL Data In: ORACLE - Rows affected = 0
270 11:12:57 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
271 11:12:57 SQL Execute: ORACLE - Select SYSDATE from Dual
272 11:12:57 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
273 11:12:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FJYB'
and KLDH00 not in ('CK','JMCK')
274 11:12:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
275 11:12:59 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYB210102194501276319'
and ICKNBH = 'FZYBA11177170'
276 11:12:59 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 where ICKH00 = 'FZYB210102194501276319'
277 11:12:59 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00 = 4622066.00
278 11:12:59 SQL Execute: ORACLE - select a.* from VW_IC_YHXXB0 a where 1 = 1
and a.BRID00 = 4622066
279 11:12:59 SQL Execute: ORACLE - select * from VW_SF_ICYWLS where ICKNBH = '0220035600097773' order by YWID00 desc
280 11:13:14 SQL Execute: ORACLE - select * from VW_SF_ICYWLS where ICKNBH = 'FZYBA11177170' order by YWID00 desc
281 11:13:17 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'
282 11:13:17 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='4'
283 11:13:17 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00
284 11:13:17 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = ''
285 11:13:17 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '通用平台病人主索引接口设置' and BH0000 = 'OPEN_MZ'
286 11:13:17 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_MZ'
287 11:13:17 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'PACS接口字典' and BH0000 = 'PACSYYJK_Open'
288 11:13:17 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')
289 11:13:17 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1
290 11:13:17 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1
291 11:13:17 SQL Execute: ORACLE - select * from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLLB00 = '1'
292 11:13:17 SQL Execute: ORACLE - select * from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLLB00 = '1'
293 11:13:17 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1410,'值班公用','192.168.202.164','00-23-24-AD-2D-4B','4','ACT_CARD_YWKRK','17658875')
294 11:13:17 SQL Data In: ORACLE - Rows affected = 1
295 11:13:17 SQL Execute: ORACLE - Commit
296 11:13:17 SQL Data In: ORACLE - Rows affected = 0
297 11:13:18 SQL Execute: ORACLE - Select SYSDATE from Dual
298 11:13:18 SQL Execute: ORACLE - select KHQZBH from IC_KLDM00
where KLDH00 = 'YB-FJYB'
299 11:13:18 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
300 11:13:18 SQL Execute: ORACLE - Select SYSDATE from Dual
301 11:13:18 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
302 11:13:18 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FJYB'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
303 11:13:18 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
304 11:13:20 SQL Execute: ORACLE - select * from IC_YHXX00
where ICKNBH = 'FZYBA11177170'
305 11:13:31 SQL Execute: ORACLE - Select SYSDATE from Dual
306 11:13:31 SQL Execute: ORACLE - select KHQZBH from IC_KLDM00
where KLDH00 = 'YB-FJYB'
307 11:13:31 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
308 11:13:31 SQL Execute: ORACLE - Select SYSDATE from Dual
309 11:13:31 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
310 11:13:31 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FJYB'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
311 11:13:31 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
312 11:13:33 SQL Execute: ORACLE - select * from IC_YHXX00
where ICKNBH = 'FZYBAD616118X'
313 11:13:35 SQL Execute: ORACLE - select * from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLLB00 = '1'
314 11:13:35 SQL Misc: ORACLE - Set stored procedure on or off
315 11:13:35 SQL Data In: ORACLE - Param = 1, Name = P_ICKNBH, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBAD616118X
316 11:13:35 SQL Data In: ORACLE - Param = 2, Name = P_ICKH00, Type = fldZSTRING, Precision = 22, Scale = 0, Data = FZYB210102194501276319
317 11:13:35 SQL Data In: ORACLE - Param = 3, Name = P_YWCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 8
318 11:13:35 SQL Data In: ORACLE - Param = 4, Name = P_ICKMM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
319 11:13:35 SQL Data In: ORACLE - Param = 5, Name = P_KLDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = YB-FJYB
320 11:13:35 SQL Data In: ORACLE - Param = 6, Name = P_KMH000, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2101021945012763
321 11:13:35 SQL Data In: ORACLE - Param = 7, Name = P_SFDM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
322 11:13:35 SQL Data In: ORACLE - Param = 8, Name = P_YGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1410.000000
323 11:13:35 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
324 11:13:35 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
325 11:13:35 SQL Data In: ORACLE - Param = 11, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
326 11:13:35 SQL Data In: ORACLE - Param = 12, Name = P_XZQH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
327 11:13:35 SQL Data In: ORACLE - Param = 13, Name = P_KSBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
328 11:13:35 SQL Execute: ORACLE - BEGIN "SP_SF_ICKRK0_REG000" (P_ICKNBH => :P_ICKNBH,P_ICKH00 => :P_ICKH00,P_YWCZ00 => :P_YWCZ00,P_ICKMM0 => :P_ICKMM0,P_KLDH00 => :P_KLDH00,P_KMH000 => :P_KMH000,P_SFDM00 => :P_SFDM00,P_YGBH00 => :P_YGBH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,PCZYKS0 => :PCZYKS0,P_XZQH00 => :P_XZQH00,P_KSBM00 => :P_KSBM00); END;
329 11:14:22 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'
330 11:14:22 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='4'
331 11:14:22 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00
332 11:14:22 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = ''
333 11:14:22 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '通用平台病人主索引接口设置' and BH0000 = 'OPEN_MZ'
334 11:14:22 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_MZ'
335 11:14:22 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'PACS接口字典' and BH0000 = 'PACSYYJK_Open'
336 11:14:22 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')
337 11:14:22 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1
338 11:14:22 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1
339 11:14:22 SQL Execute: ORACLE - select * from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLLB00 = '1'
340 11:14:22 SQL Execute: ORACLE - select * from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLLB00 = '1'
341 11:14:22 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1410,'值班公用','192.168.202.164','00-23-24-AD-2D-4B','4','ACT_CARD_YWKRK','17658875')
342 11:14:22 SQL Data In: ORACLE - Rows affected = 1
343 11:14:22 SQL Execute: ORACLE - Commit
344 11:14:22 SQL Data In: ORACLE - Rows affected = 0
345 11:14:23 SQL Execute: ORACLE - Select SYSDATE from Dual
346 11:14:23 SQL Execute: ORACLE - select KHQZBH from IC_KLDM00
where KLDH00 = 'YB-FJYB'
347 11:14:23 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
348 11:14:23 SQL Execute: ORACLE - Select SYSDATE from Dual
349 11:14:23 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
350 11:14:23 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FJYB'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
351 11:14:23 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
352 11:14:24 SQL Execute: ORACLE - select * from IC_YHXX00
where ICKNBH = 'FZYBAD616118X'
353 11:14:26 SQL Execute: ORACLE - select * from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLLB00 = '1'
354 11:14:26 SQL Misc: ORACLE - Set stored procedure on or off
355 11:14:26 SQL Data In: ORACLE - Param = 1, Name = P_ICKNBH, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBAD616118X
356 11:14:26 SQL Data In: ORACLE - Param = 2, Name = P_ICKH00, Type = fldZSTRING, Precision = 22, Scale = 0, Data = FZYB210102194501276319
357 11:14:26 SQL Data In: ORACLE - Param = 3, Name = P_YWCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 8
358 11:14:26 SQL Data In: ORACLE - Param = 4, Name = P_ICKMM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
359 11:14:26 SQL Data In: ORACLE - Param = 5, Name = P_KLDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = YB-FJYB
360 11:14:26 SQL Data In: ORACLE - Param = 6, Name = P_KMH000, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2101021945012763
361 11:14:26 SQL Data In: ORACLE - Param = 7, Name = P_SFDM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
362 11:14:26 SQL Data In: ORACLE - Param = 8, Name = P_YGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1410.000000
363 11:14:26 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
364 11:14:26 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
365 11:14:26 SQL Data In: ORACLE - Param = 11, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
366 11:14:26 SQL Data In: ORACLE - Param = 12, Name = P_XZQH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
367 11:14:26 SQL Data In: ORACLE - Param = 13, Name = P_KSBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
368 11:14:26 SQL Execute: ORACLE - BEGIN "SP_SF_ICKRK0_REG000" (P_ICKNBH => :P_ICKNBH,P_ICKH00 => :P_ICKH00,P_YWCZ00 => :P_YWCZ00,P_ICKMM0 => :P_ICKMM0,P_KLDH00 => :P_KLDH00,P_KMH000 => :P_KMH000,P_SFDM00 => :P_SFDM00,P_YGBH00 => :P_YGBH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,PCZYKS0 => :PCZYKS0,P_XZQH00 => :P_XZQH00,P_KSBM00 => :P_KSBM00); END;
369 11:14:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4622066.000000
370 11:14:35 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where brid00 =?
371 11:14:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4622066.000000
372 11:14:35 SQL Execute: ORACLE - select count(*) SFZF from ic_yhxx00 where brid00=? and zt0000='3'
373 11:14:35 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')
374 11:14:35 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1
375 11:14:35 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1
376 11:14:37 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
377 11:14:37 SQL Execute: ORACLE - Select SYSDATE from Dual
378 11:14:37 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
379 11:14:37 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FJYB'
and KLDH00 not in ('CK','JMCK')
380 11:14:37 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
381 11:14:39 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYB210102194501276319'
and ICKNBH = 'FZYBAD616118X'