1       08:17:42  Log started for: 易联众医院信息综合管理平台
2       08:17:42  SQL Prepare: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

3       08:17:42  SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

4       08:17:42  SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000)  select '10.99.99.52','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where  AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 

5       08:17:42  SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000)  select '10.99.99.52','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where  AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 

6       08:17:42  SQL Data In: ORACLE - Rows affected = 1
7       08:17:42  SQL Prepare: ORACLE -  Commit 

8       08:17:42  SQL Execute: ORACLE -  Commit 

9       08:17:42  SQL Data In: ORACLE - Rows affected = 0
10      08:17:42  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

11      08:17:42  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

12      08:17:42  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='ASTAR' and CZBZ00 in ('0','1') 

13      08:17:42  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='ASTAR' and CZBZ00 in ('0','1') 

14      08:17:42  SQL Prepare: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = 'astar' and YCLBBZ ='0' and CLBZ00 = '0'

15      08:17:42  SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = 'astar' and YCLBBZ ='0' and CLBZ00 = '0'

16      08:17:42  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS'

17      08:17:42  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS'

18      08:17:42  SQL Prepare: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from  VW_XT_YHBMQX_EXT where YGBH00=1913 and XTDM00 not in ('OE','MC') order by XTDM00

19      08:17:42  SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from  VW_XT_YHBMQX_EXT where YGBH00=1913 and XTDM00 not in ('OE','MC') order by XTDM00

20      08:17:42  SQL Prepare: ORACLE - Select SYSDATE from Dual

21      08:17:42  SQL Execute: ORACLE - Select SYSDATE from Dual

22      08:17:42  SQL Prepare: ORACLE -  Select SYSDATE from Dual 

23      08:17:42  SQL Execute: ORACLE -  Select SYSDATE from Dual 

24      08:17:42  SQL Prepare: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 1913

25      08:17:42  SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 1913

26      08:17:42  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 1913

27      08:17:42  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 1913

28      08:17:43  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1')

29      08:17:43  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1')

30      08:17:43  SQL Prepare: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

31      08:17:43  SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

32      08:17:43  SQL Prepare: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

33      08:17:43  SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

34      08:17:43  SQL Prepare: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital')

35      08:17:43  SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital')

36      08:17:43  SQL Prepare: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE

37      08:17:43  SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE

38      08:17:43  SQL Prepare: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 1913

39      08:17:43  SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 1913

40      08:17:43  SQL Prepare: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 1913

41      08:17:43  SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 1913

42      08:17:43  SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '10.99.99.52' 

43      08:17:43  SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '10.99.99.52' 

44      08:17:43  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ'

45      08:17:43  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ'

46      08:17:43  SQL Prepare: ORACLE -  select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ  where YGBH00 = 1913 and RowNum <= 10 order by DLRQSJ DESC 

47      08:17:43  SQL Execute: ORACLE -  select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ  where YGBH00 = 1913 and RowNum <= 10 order by DLRQSJ DESC 

48      08:17:43  SQL Prepare: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='1' order by BMPLXH,BMBH00

49      08:17:43  SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='1' order by BMPLXH,BMBH00

50      08:17:49  SQL Prepare: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='C' order by BMPLXH,BMBH00

51      08:17:49  SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='C' order by BMPLXH,BMBH00

52      08:17:50  SQL Prepare: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='C' and KJLB00 ='3' 

53      08:17:50  SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='C' and KJLB00 ='3' 

54      08:17:50  SQL Prepare: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK  where XTDM00 = 'C' and KJLB00 < '3' order by XH0000

55      08:17:50  SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK  where XTDM00 = 'C' and KJLB00 < '3' order by XH0000

56      08:17:50  SQL Prepare: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'C'||',')>0

57      08:17:50  SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'C'||',')>0

58      08:17:50  SQL Prepare: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1913 and XTDM00 = 'C' 

59      08:17:50  SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1913 and XTDM00 = 'C' 

60      08:17:50  SQL Prepare: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = 'C' 

61      08:17:50  SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = 'C' 

62      08:17:50  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
464 and FLAG00 like '0'
 order by decode(CKBH00,21,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

63      08:17:50  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
464 and FLAG00 like '0'
 order by decode(CKBH00,21,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

64      08:17:50  SQL Prepare: 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))

65      08:17:50  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))

66      08:17:50  SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00)  select '10.99.99.52','C',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where  AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 

67      08:17:50  SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00)  select '10.99.99.52','C',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where  AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 

68      08:17:50  SQL Data In: ORACLE - Rows affected = 1
69      08:17:50  SQL Prepare: ORACLE - Commit

70      08:17:50  SQL Execute: ORACLE - Commit

71      08:17:50  SQL Data In: ORACLE - Rows affected = 0
72      08:17:50  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 

73      08:17:50  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 

74      08:17:50  SQL Prepare: 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'))

75      08:17:50  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'))

76      08:17:50  SQL Prepare: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000)  values(3954027,1913,'FJLNYY-PC','C',nvl('13033647',' '),'10.99.99.52#1715:53889@appYLZHis.exe',464,'10.99.99.52')

77      08:17:50  SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000)  values(3954027,1913,'FJLNYY-PC','C',nvl('13033647',' '),'10.99.99.52#1715:53889@appYLZHis.exe',464,'10.99.99.52')

78      08:17:50  SQL Data In: ORACLE - Rows affected = 1
79      08:17:50  SQL Prepare: ORACLE - Commit

80      08:17:50  SQL Execute: ORACLE - Commit

81      08:17:50  SQL Data In: ORACLE - Rows affected = 0
82      08:17:50  SQL Prepare: ORACLE - select count(*) from VW_XT_YHKJMK  where YGBH00=1913 and XTDM00='C' 

83      08:17:50  SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK  where YGBH00=1913 and XTDM00='C' 

84      08:17:50  SQL Prepare: ORACLE - select * from XT_BJCS00 where IP0000 = '10.99.99.52' and NAME00 = 'QDXTJZ' 

85      08:17:50  SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '10.99.99.52' and NAME00 = 'QDXTJZ' 

86      08:17:50  SQL Prepare: 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 = 'C' 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 = 1913 and XTDM00 = 'C') c  order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00

87      08:17:50  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 = 'C' 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 = 1913 and XTDM00 = 'C') c  order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00

88      08:17:50  SQL Prepare: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1913 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll')

89      08:17:50  SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1913 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll')

90      08:17:50  SQL Prepare: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK  where YGBH00=1913 and XTDM00='C' order by XH0000

91      08:17:50  SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK  where YGBH00=1913 and XTDM00='C' order by XH0000

92      08:17:50  SQL Prepare: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
93      08:17:50  SQL Misc: ORACLE - Set stored procedure on or off
94      08:17:50  SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000
95      08:17:50  SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464.000000
96      08:17:50  SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
97      08:17:50  SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
98      08:17:50  SQL Prepare: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
99      08:17:50  SQL Misc: ORACLE - Set stored procedure on or off
100     08:17:50  SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000
101     08:17:50  SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464.000000
102     08:17:50  SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17001506.000000
103     08:17:50  SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
104     08:17:50  SQL Prepare: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 17001506.00)

105     08:17:50  SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 17001506.00)

106     08:17:54  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'

107     08:17:54  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'

108     08:17:54  SQL Prepare: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='C'

109     08:17:54  SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='C'

110     08:17:54  SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = 'SLE4442'

111     08:17:54  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 = 'SLE4442'

112     08:17:54  SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = ''

113     08:17:54  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 = ''

114     08:17:54  SQL Prepare: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=464 

115     08:17:54  SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=464 

116     08:17:54  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=464 

117     08:17:54  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=464 

118     08:17:54  SQL Prepare: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035'

119     08:17:54  SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035'

120     08:17:54  SQL Prepare: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL

121     08:17:54  SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL

122     08:17:54  SQL Prepare: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual

123     08:17:54  SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual

124     08:17:54  SQL Prepare: ORACLE - select SF_XT_GETSFDJBYBMBH(464) as SFBZDJ from dual

125     08:17:54  SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(464) as SFBZDJ from dual

126     08:17:54  SQL Prepare: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_XMGL_ZHYW.dll' and YGBH00 = 1913 

127     08:17:54  SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_XMGL_ZHYW.dll' and YGBH00 = 1913 

128     08:17:54  SQL Prepare: ORACLE - select * from bm_bmgz00 a where bmgzid=0
 order by BMGZSH

129     08:17:54  SQL Execute: ORACLE - select * from bm_bmgz00 a where bmgzid=0
 order by BMGZSH

130     08:17:54  SQL Prepare: ORACLE - select * from bm_bmgz00 a where 
 exists(select 1 from BM_YYSFXM where bmgzid=a.bmgzid and flag00='0')
 or exists(select 1 from BM_SFXMBZ where bmgzid=a.bmgzid and flag00='0')
 and SFYX00='1' 
 order by BMGZSH

131     08:17:54  SQL Execute: ORACLE - select * from bm_bmgz00 a where 
 exists(select 1 from BM_YYSFXM where bmgzid=a.bmgzid and flag00='0')
 or exists(select 1 from BM_SFXMBZ where bmgzid=a.bmgzid and flag00='0')
 and SFYX00='1' 
 order by BMGZSH

132     08:17:54  SQL Prepare: ORACLE - Select TREEBH,bh0000,xmmc00,flag00,zjbz00,decode(zjbz00,'0','总部','1','医院','2','分部','3','不能增加') zjqx,  decode(greatest(to_char(sysdate,'YYYYMMDD'),Tzrq00),to_char(Sysdate,'YYYYMMDD'),'停用',Tzrq00, '使用') Effflag  from bm_yysfxm where bmgzid=:1  and flag00='0' and sfxmid<9000000000   and bmgzid=1 and BH0000 like '9%'  order by TREEBH,bh0000

133     08:17:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
134     08:17:54  SQL Execute: ORACLE - Select TREEBH,bh0000,xmmc00,flag00,zjbz00,decode(zjbz00,'0','总部','1','医院','2','分部','3','不能增加') zjqx,  decode(greatest(to_char(sysdate,'YYYYMMDD'),Tzrq00),to_char(Sysdate,'YYYYMMDD'),'停用',Tzrq00, '使用') Effflag  from bm_yysfxm where bmgzid=?  and flag00='0' and sfxmid<9000000000   and bmgzid=1 and BH0000 like '9%'  order by TREEBH,bh0000

135     08:17:54  SQL Prepare: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00)  values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1913,'测试库','10.99.99.52','00-50-56-9D-B9-FF','C','ACT_XMGL_CLGL','13033647')

136     08:17:54  SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00)  values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1913,'测试库','10.99.99.52','00-50-56-9D-B9-FF','C','ACT_XMGL_CLGL','13033647')

137     08:17:54  SQL Data In: ORACLE - Rows affected = 1
138     08:17:54  SQL Prepare: ORACLE - Commit

139     08:17:54  SQL Execute: ORACLE - Commit

140     08:17:54  SQL Data In: ORACLE - Rows affected = 0
141     08:18:11  SQL Prepare: ORACLE - select a.TREEBH,a.sfxmid,a.yydj00 yydj00, f.yydj00 yydjmc, a.bmgzid,a.bh0000,a.flag00,a.xmmc00,decode(a.FLAG00,'0',null,substr(trim(a.xmnh00),1,100)) xmnh00,decode(a.FLAG00,'0',null,substr(trim(a.cwnr00),1,100)) cwnr00, a.dw0000,a.bzje00,a.sfje00,a.fdbl00,a.sfxx00,a.sfsx00,b.xmmc00 as mzxmmc,c.xmmc00 as zyxmmc,a.qyrq00,a.qysj00,a.tzrq00,a.pysm00,a.wbsm00,a.zjbz00,d.hsxmmc AS HSMC00,d.bh0000 as yyhsbh,a.hsxmid as hsxmid,a.ZHXMBZ as zhxmbz, decode(a.flag00,'1','项目','0','类别')wflag,decode(a.zjbz00,'0','总部','1','医院','2','分部','3','不能增加')zjqx,a.MZZYBZ,decode(a.MZZYBZ,'0','限门诊','1','限住院','不限制') as MZZYMC, decode(a.SFGZ00,'Y',a.SFGZ00,'N') as SFGZ00,decode(a.SFGZ00,'Y','是','否') as SFGZMC, decode(greatest(to_char(sysdate,'YYYYMMDD'),a.Tzrq00),to_char(Sysdate,'YYYYMMDD'),'停用',a.Tzrq00, '使用')Effflag,a.BAXMID,e.BAXMMC,a.GG0000,a.SCCJ00,a.PZWH00,decode(a.FLAG00,'0',null,substr(trim(a.BZ0000),1,100)) BZ0000, a.GJBM00,a.JSXM00,substr(trim(a.LSCL00),1,100) LSCL00,trim(substrb(a.LSCL00,1,100)) LSCL01,a.RSFSX0,a.JMJE00,a.MZFPID,a.ZYFPID,a.KJXMID,g.KJXMMC,a.TXM000,a.YWBH00,a.YWMC00,a.SFZXBS,a.GJYLBM,a.BKEH83,a.GJBZMC  from bm_yysfxm a,bm_fpxm00 b,bm_fpxm00 c,bm_yyhsxm d,BM_BAXM00 e,bm_yydj00 f,BM_YYKJXM g where a.yydj00=f.yydjxh and a.hsxmid=d.hsxmid(+) and  b.fpxmid(+)=a.mzfpid  and c.fpxmid(+)=a.zyfpid and a.KJXMID=g.KJXMID(+)   and a.sfxmid<9000000000 and a.TREEBH like :1 and  a.bmgzid=:2 and a.baxmid=e.baxmid(+)   and a.bmgzid=1 and a.BH0000 like '9%'  and ((1=1 and '0'=:3) or (a.TZRQ00 is null and '1'=:4) or (a.TZRQ00 is not null and '2'=:5) ) and a.flag00 = '1'  order by a.TREEBH,a.bh0000

142     08:18:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 9%
143     08:18:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
144     08:18:11  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
145     08:18:11  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
146     08:18:11  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
147     08:18:11  SQL Execute: ORACLE - select a.TREEBH,a.sfxmid,a.yydj00 yydj00, f.yydj00 yydjmc, a.bmgzid,a.bh0000,a.flag00,a.xmmc00,decode(a.FLAG00,'0',null,substr(trim(a.xmnh00),1,100)) xmnh00,decode(a.FLAG00,'0',null,substr(trim(a.cwnr00),1,100)) cwnr00, a.dw0000,a.bzje00,a.sfje00,a.fdbl00,a.sfxx00,a.sfsx00,b.xmmc00 as mzxmmc,c.xmmc00 as zyxmmc,a.qyrq00,a.qysj00,a.tzrq00,a.pysm00,a.wbsm00,a.zjbz00,d.hsxmmc AS HSMC00,d.bh0000 as yyhsbh,a.hsxmid as hsxmid,a.ZHXMBZ as zhxmbz, decode(a.flag00,'1','项目','0','类别')wflag,decode(a.zjbz00,'0','总部','1','医院','2','分部','3','不能增加')zjqx,a.MZZYBZ,decode(a.MZZYBZ,'0','限门诊','1','限住院','不限制') as MZZYMC, decode(a.SFGZ00,'Y',a.SFGZ00,'N') as SFGZ00,decode(a.SFGZ00,'Y','是','否') as SFGZMC, decode(greatest(to_char(sysdate,'YYYYMMDD'),a.Tzrq00),to_char(Sysdate,'YYYYMMDD'),'停用',a.Tzrq00, '使用')Effflag,a.BAXMID,e.BAXMMC,a.GG0000,a.SCCJ00,a.PZWH00,decode(a.FLAG00,'0',null,substr(trim(a.BZ0000),1,100)) BZ0000, a.GJBM00,a.JSXM00,substr(trim(a.LSCL00),1,100) LSCL00,trim(substrb(a.LSCL00,1,100)) LSCL01,a.RSFSX0,a.JMJE00,a.MZFPID,a.ZYFPID,a.KJXMID,g.KJXMMC,a.TXM000,a.YWBH00,a.YWMC00,a.SFZXBS,a.GJYLBM,a.BKEH83,a.GJBZMC  from bm_yysfxm a,bm_fpxm00 b,bm_fpxm00 c,bm_yyhsxm d,BM_BAXM00 e,bm_yydj00 f,BM_YYKJXM g where a.yydj00=f.yydjxh and a.hsxmid=d.hsxmid(+) and  b.fpxmid(+)=a.mzfpid  and c.fpxmid(+)=a.zyfpid and a.KJXMID=g.KJXMID(+)   and a.sfxmid<9000000000 and a.TREEBH like ? and  a.bmgzid=? and a.baxmid=e.baxmid(+)   and a.bmgzid=1 and a.BH0000 like '9%'  and ((1=1 and '0'=?) or (a.TZRQ00 is null and '1'=?) or (a.TZRQ00 is not null and '2'=?) ) and a.flag00 = '1'  order by a.TREEBH,a.bh0000

148     08:18:11  SQL Prepare: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00
from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S
where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID
and G.SFXMID=:1

149     08:18:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031750
150     08:18:11  SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00
from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S
where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID
and G.SFXMID=?

151     08:18:11  SQL Prepare: ORACLE -  select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b 
 where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = :1 

152     08:18:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031750
153     08:18:11  SQL Execute: ORACLE -  select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b 
 where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ? 

154     08:18:11  SQL Prepare: ORACLE -  select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c 
 where a.SFBZDJ = c.SFBZDJ and a.sfxmid=:1 and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb 
 order by c.YYJC00 

155     08:18:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031750
156     08:18:11  SQL Execute: ORACLE -  select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c 
 where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb 
 order by c.YYJC00 

157     08:18:11  SQL Prepare: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00,
 LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9'   and a.SFXMID=:1
union
select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00,
 LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9'   and a.SFXMID=:2

158     08:18:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031750
159     08:18:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031750
160     08:18:11  SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00,
 LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9'   and a.SFXMID=?
union
select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00,
 LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9'   and a.SFXMID=?

161     08:18:48  SQL Prepare: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00
from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S
where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID
and G.SFXMID=:1

162     08:18:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879
163     08:18:48  SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00
from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S
where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID
and G.SFXMID=?

164     08:18:48  SQL Prepare: ORACLE -  select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b 
 where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = :1 

165     08:18:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879
166     08:18:48  SQL Execute: ORACLE -  select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b 
 where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ? 

167     08:18:48  SQL Prepare: ORACLE -  select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c 
 where a.SFBZDJ = c.SFBZDJ and a.sfxmid=:1 and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb 
 order by c.YYJC00 

168     08:18:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879
169     08:18:48  SQL Execute: ORACLE -  select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c 
 where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb 
 order by c.YYJC00 

170     08:18:48  SQL Prepare: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00,
 LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9'   and a.SFXMID=:1
union
select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00,
 LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9'   and a.SFXMID=:2

171     08:18:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879
172     08:18:48  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879
173     08:18:48  SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00,
 LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9'   and a.SFXMID=?
union
select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00,
 LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9'   and a.SFXMID=?