1       15:06:10  SQL Execute: ORACLE - Select SYSDATE from Dual

2       15:06:10  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'

3       15:06:10  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')

4       15:06:11  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-MMRK'
and KLDH00 not in ('CK','JMCK')

5       15:06:11  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'PTYBPT30100296794'
and ICKNBH = 'PTYBPT30100296794'

6       15:06:11  SQL Execute: ORACLE - select SP_YS_TSBRXXTS(29882) MSG000 from dual

7       15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
8       15:06:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen
9       15:06:11  SQL Execute: ORACLE -  select SF_SF_TYZD00(?,?)FHJG00 from dual

10      15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100296794
11      15:06:11  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

12      15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
13      15:06:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
14      15:06:11  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

15      15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100296794
16      15:06:11  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

17      15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
18      15:06:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
19      15:06:11  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

20      15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100296794
21      15:06:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000
22      15:06:11  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?)FHJG00 from dual

23      15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100296794
24      15:06:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001
25      15:06:11  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?)FHJG00 from dual

26      15:06:11  SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_DK00_0001' and SFQY00='1' 

27      15:06:11  SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_DK00_0002' and SFQY00='1' 

28      15:06:11  SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_DK00_0003' and SFQY00='1' 

29      15:06:11  SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_DK00_0004' and SFQY00='1' 

30      15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
31      15:06:11  SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=?

32      15:06:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
33      15:06:11  SQL Execute: ORACLE - select kmh000,ickh00,nvl((select YKTYE0 from SF_BRZHXX where BRID00=a.BRID00 and JFLBID=1),0) YKTYE0 from ic_yhxx00 a where zt0000='1' and brid00=?

34      15:06:11  SQL Execute: ORACLE - select 1 from BM_BRKDML where FBBH00=3 and YBZXLB='1' and rownum=1

35      15:06:11  SQL Execute: ORACLE - select count(1) Count0 from bm_tsbzb0 where ybzxlb='1' and  instrb(',-1,',',1,')=0

36      15:06:11  SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='科室特殊病种目录' and BH0000='35'

37      15:06:11  SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0
 where YBZXLB='1' and (instr(','||KSBH00||',',',35,')>0 or KSBH00 is null) ORDER BY PXZD00

38      15:06:11  SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0
 where YBZXLB='1' and (instr(','||KSBH00||',',',35,')>0 or KSBH00 is null) ORDER BY PXZD00

39      15:06:12  SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0
 where YBZXLB='1' and (instr(','||KSBH00||',',',35,')>0 or KSBH00 is null) ORDER BY PXZD00

40      15:06:12  SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0
 where YBZXLB='1' and (instr(','||KSBH00||',',',35,')>0 or KSBH00 is null) ORDER BY PXZD00

41      15:06:12  SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0
 where YBZXLB='1' and (instr(','||KSBH00||',',',35,')>0 or KSBH00 is null) ORDER BY PXZD00

42      15:06:12  SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0
 where YBZXLB='1' and (instr(','||KSBH00||',',',35,')>0 or KSBH00 is null) ORDER BY PXZD00

43      15:06:12  SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0
 where YBZXLB='1' and (instr(','||KSBH00||',',',35,')>0 or KSBH00 is null) ORDER BY PXZD00

44      15:06:12  SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0
 where YBZXLB='1' and (instr(','||KSBH00||',',',35,')>0 or KSBH00 is null) ORDER BY PXZD00

45      15:06:12  SQL Execute: ORACLE - select SF_YS_BRJZBSTS(29882) GHCSTS from dual  

46      15:06:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
47      15:06:12  SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS
 where (BRID00=?)  
  and ghlb00=-99999 

48      15:06:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
49      15:06:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 35
50      15:06:16  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 63
51      15:06:16  SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a
 where (BRID00=?)  
  and ghlb00<>-99999 
 and (('N'='N') or ((a.JZYS00=63) or (a.JZYS00=0) ) or  (a.GHKS00=35 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 )   )
 and GHKS00=?
 and ((JZYS00=?) or (JZYS00=0))
 order by ghh000 desc 

52      15:06:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000
53      15:06:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
54      15:06:16  SQL Execute: ORACLE - select SF_YS_YKDWZXXMTS(?,?) TSXX00 from dual

55      15:06:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 35
56      15:06:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 63
57      15:06:16  SQL Execute: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS')

58      15:06:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
59      15:06:16  SQL Execute: ORACLE - select count(*) record_no from sf_brxxb0 where brid00=? and thbz00<>'0' and GHLB00<>-99999 

60      15:06:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
61      15:06:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101
62      15:06:16  SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC,
       a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0,a.FWMC00,a.BWMC00
from   YS_BRZDXX a, XT_ICD900 b 
where  a.ICD900=b.ICD900(+) and a.SFXYZD='1'and a.GHID00=? 
           and exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?)


63      15:06:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
64      15:06:16  SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC,
       JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD ,BWMC00,FWMC00
from   YS_BRZDXX  a
where  SFXYZD='0'and GHID00=?   
            

65      15:06:16  SQL Data In: ORACLE - Param = 1, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000
66      15:06:16  SQL Data In: ORACLE - Param = 2, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 63.000000
67      15:06:16  SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
68      15:06:16  SQL Data In: ORACLE - Param = 4, Name = PRESULT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
69      15:06:16  SQL Data In: ORACLE - Param = 5, Name = PMSG000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
70      15:06:16  SQL Execute: ORACLE - BEGIN "SP_YS_GHXZTS" (PGHKS00 => :PGHKS00,PGHYS00 => :PGHYS00,PBRID00 => :PBRID00,PRESULT => :PRESULT,PMSG000 => :PMSG000); END;
71      15:06:16  SQL Execute: ORACLE - select SF_YS_GETSFJZSJ_GH('1') JZBZ00  from dual

72      15:06:16  SQL Execute: ORACLE - select sf_ys_ghxz00(35,63,29882) from dual

73      15:06:16  SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_BM_GHLBB0
 where  lbbh00 in (3,7 ) 

74      15:06:16  SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00

75      15:06:16  SQL Execute: ORACLE - select SFYD00,GRSFEN,BRDYFW from BM_BRXXB0 where BRID00=29882

76      15:06:16  SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select GHID00 from SF_BRXXB0 b where brid00=29882)  and rownum=1

77      15:06:16  SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1

78      15:06:16  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
79      15:06:16  SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
80      15:06:16  SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000
81      15:06:16  SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
82      15:06:16  SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
83      15:06:16  SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
84      15:06:16  SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
85      15:06:16  SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
86      15:06:16  SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
87      15:06:16  SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
88      15:06:16  SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
89      15:06:16  SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END;
90      15:06:16  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
91      15:06:16  SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
92      15:06:16  SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000
93      15:06:16  SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
94      15:06:16  SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
95      15:06:16  SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
96      15:06:16  SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
97      15:06:16  SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
98      15:06:16  SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
99      15:06:16  SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
100     15:06:16  SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
101     15:06:16  SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END;
102     15:06:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
103     15:06:16  SQL Execute: ORACLE - select nvl(max(GHID00),0) GHID00 from YS_BRBQB0 where GHID00 in (select GHID00 from SF_BRXXB0 b where BRID00=? )

104     15:06:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29882
105     15:06:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14532763
106     15:06:16  SQL Execute: ORACLE - select DM0000,MC0000 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00='4' and SFYX00='Y' and MZBZ00='0'