1       13:49:14  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 6036051 and JFRQ00 between '20201006' and '20201013'   and PLBH00 in (4,8) order by DJH000

2       13:49:14  SQL Execute: ORACLE - select 4960 as UserId,'10087' as UserCode,'管理员' as UserName,2112 as UserLogDepId,'收费处' as UserLogDepName, '5' as UserLogSysCode,'住院收费管理系统' as UserLogSysName,'220006' as HospitalCode,'福建中医药大学附属人民医院' as HospitalName, '220006' as UserLogDepYYID,'福建中医药大学附属人民医院' as UserLogDepYYMC  from dual 

3       13:49:15  SQL Execute: ORACLE - select JHLB00,count(DLXH00) DDRS00 from VW_ZY_PDJHXX_WJH   where YJKSBH= 2112 and instrb('ABCDE',JHLB00)>0 group by JHLB00

4       13:49:15  SQL Execute: ORACLE - select JHLB00,DLXH00,NWDLXH,BRXM00 from VW_ZY_PDJHXX_YJH   where YJKSBH=2112 and JHCKBH = 796 and instrb('ABCDE',JHLB00)>0 order by DLXH00 

5       13:49:44  SQL Execute: ORACLE - select JHLB00,count(DLXH00) DDRS00 from VW_ZY_PDJHXX_WJH   where YJKSBH= 2112 and instrb('ABCDE',JHLB00)>0 group by JHLB00

6       13:49:44  SQL Execute: ORACLE - select JHLB00,DLXH00,NWDLXH,BRXM00 from VW_ZY_PDJHXX_YJH   where YJKSBH=2112 and JHCKBH = 796 and instrb('ABCDE',JHLB00)>0 order by DLXH00 

7       13:50:13  SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000
8       13:50:13  SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2112.000000
9       13:50:13  SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23615051.000000
10      13:50:13  SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
11      13:50:13  SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 23615051.00)

12      13:50:14  SQL Execute: ORACLE - select JHLB00,count(DLXH00) DDRS00 from VW_ZY_PDJHXX_WJH   where YJKSBH= 2112 and instrb('ABCDE',JHLB00)>0 group by JHLB00

13      13:50:14  SQL Execute: ORACLE - select JHLB00,DLXH00,NWDLXH,BRXM00 from VW_ZY_PDJHXX_YJH   where YJKSBH=2112 and JHCKBH = 796 and instrb('ABCDE',JHLB00)>0 order by DLXH00