1       15:40:36  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='254057'

2       15:40:36  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='254057'

3       15:40:36  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

4       15:40:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6126
5       15:40:36  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

6       15:40:42  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='255483'

7       15:40:42  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='255483'

8       15:40:42  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

9       15:40:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6448
10      15:40:42  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

11      15:40:54  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

12      15:40:54  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

13      15:40:54  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

14      15:40:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
15      15:40:54  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

16      15:40:54  SQL Prepare: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','急诊','择期') JZBZZW from vw_ss_yw0000 a 
where SSZT00='2' 
 and (ssfybz='0' or ssfybz='1') 
and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20120101' and '20130131'
order by SSDH00) b

17      15:40:54  SQL Execute: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','急诊','择期') JZBZZW from vw_ss_yw0000 a 
where SSZT00='2' 
 and (ssfybz='0' or ssfybz='1') 
and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20120101' and '20130131'
order by SSDH00) b

18      15:41:02  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

19      15:41:02  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

20      15:41:02  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

21      15:41:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
22      15:41:02  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

23      15:41:03  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

24      15:41:03  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

25      15:41:03  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

26      15:41:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
27      15:41:03  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

28      15:41:08  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='251771'

29      15:41:08  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='251771'

30      15:41:08  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

31      15:41:08  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5525
32      15:41:08  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

33      15:41:10  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='251141'

34      15:41:10  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='251141'

35      15:41:10  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

36      15:41:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5390
37      15:41:10  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

38      15:41:11  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='251771'

39      15:41:11  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='251771'

40      15:41:11  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

41      15:41:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5525
42      15:41:11  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

43      15:41:22  SQL Prepare: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00 from vw_ss_hs0000 where (pysm00 Like :1) Order By pysm00) where Rownum<=1000

44      15:41:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
45      15:41:22  SQL Execute: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00 from vw_ss_hs0000 where (pysm00 Like ?) Order By pysm00) where Rownum<=1000

46      15:41:25  SQL Prepare: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00 from vw_ss_hs0000 where (pysm00 Like :1) Order By pysm00) where Rownum<=1000

47      15:41:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
48      15:41:25  SQL Execute: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00 from vw_ss_hs0000 where (pysm00 Like ?) Order By pysm00) where Rownum<=1000

49      15:41:29  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='251771'

50      15:41:29  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='251771'

51      15:41:29  SQL Prepare: ORACLE - update SS_YW0000 set SSZT00='2',SSQSRQ='20121231',SSQSSJ='23:30:00',SSJH00='01',SSTBH0='01',SSTC00='1',GRQK00='阴性',SSJCSJ='',SSDJMC=decode('222137','222504',NULL,'一级'),SSKS00='54',GLDJMC='正常',SSYS00='26',SSYSXM='陈振兴',SSZS00='647',SSZSXM='许伟明',SXYS00='',SXYSXM='',TSHS00='988;235',TSHSXM='林颖;陈碧云',GYHS00='692;744',GYHSXM='陈特容;陈风',XSHS00='',XSHSXM='',SSSD00='上午',SSZB00='' where SSDH00='5525'

52      15:41:29  SQL Execute: ORACLE - update SS_YW0000 set SSZT00='2',SSQSRQ='20121231',SSQSSJ='23:30:00',SSJH00='01',SSTBH0='01',SSTC00='1',GRQK00='阴性',SSJCSJ='',SSDJMC=decode('222137','222504',NULL,'一级'),SSKS00='54',GLDJMC='正常',SSYS00='26',SSYSXM='陈振兴',SSZS00='647',SSZSXM='许伟明',SXYS00='',SXYSXM='',TSHS00='988;235',TSHSXM='林颖;陈碧云',GYHS00='692;744',GYHSXM='陈特容;陈风',XSHS00='',XSHSXM='',SSSD00='上午',SSZB00='' where SSDH00='5525'

53      15:41:29  SQL Data In: ORACLE - Rows affected = 1
54      15:41:29  SQL Prepare: ORACLE - select * from bq_ssmzxx where SSDH00 = '5525'

55      15:41:29  SQL Execute: ORACLE - select * from bq_ssmzxx where SSDH00 = '5525'

56      15:41:29  SQL Prepare: ORACLE - update bq_ssmzxx set SSBH00='0',SSMC00='开颅血肿清除+去骨瓣减压术',MZBH00=nvl('17','0'),MZMC00=nvl('会诊','0'),SSRQ00='20121231',YGBH00='26' where SSDH00='5525'

57      15:41:29  SQL Execute: ORACLE - update bq_ssmzxx set SSBH00='0',SSMC00='开颅血肿清除+去骨瓣减压术',MZBH00=nvl('17','0'),MZMC00=nvl('会诊','0'),SSRQ00='20121231',YGBH00='26' where SSDH00='5525'

58      15:41:29  SQL Data In: ORACLE - Rows affected = 1
59      15:41:29  SQL Prepare: ORACLE - update ss_yw0000 set BZ0000= '-' where SSDH00= '5525'

60      15:41:29  SQL Execute: ORACLE - update ss_yw0000 set BZ0000= '-' where SSDH00= '5525'

61      15:41:29  SQL Data In: ORACLE - Rows affected = 1
62      15:41:29  SQL Prepare: ORACLE - update ss_yw0000 set YYSSRQ= '20121231' where SSDH00= '5525'

63      15:41:29  SQL Execute: ORACLE - update ss_yw0000 set YYSSRQ= '20121231' where SSDH00= '5525'

64      15:41:29  SQL Data In: ORACLE - Rows affected = 1
65      15:41:29  SQL Prepare: ORACLE - update ss_yw0000 set YYSSSJ= '23:30:00' where SSDH00= '5525'

66      15:41:29  SQL Execute: ORACLE - update ss_yw0000 set YYSSSJ= '23:30:00' where SSDH00= '5525'

67      15:41:29  SQL Data In: ORACLE - Rows affected = 1
68      15:41:29  SQL Prepare: ORACLE - Commit

69      15:41:29  SQL Execute: ORACLE - Commit

70      15:41:29  SQL Data In: ORACLE - Rows affected = 0
71      15:41:30  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

72      15:41:30  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

73      15:41:30  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

74      15:41:30  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
75      15:41:30  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

76      15:41:30  SQL Prepare: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','急诊','择期') JZBZZW from vw_ss_yw0000 a 
where SSZT00='2' 
 and (ssfybz='0' or ssfybz='1') 
and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20120101' and '20130131'
order by SSDH00) b

77      15:41:30  SQL Execute: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','急诊','择期') JZBZZW from vw_ss_yw0000 a 
where SSZT00='2' 
 and (ssfybz='0' or ssfybz='1') 
and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20120101' and '20130131'
order by SSDH00) b

78      15:41:39  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

79      15:41:39  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

80      15:41:39  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

81      15:41:39  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
82      15:41:39  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

83      15:41:39  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

84      15:41:39  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

85      15:41:39  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

86      15:41:39  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
87      15:41:39  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

88      15:41:39  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='251771'

89      15:41:39  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='251771'

90      15:41:39  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

91      15:41:39  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5525
92      15:41:39  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

93      15:54:05  Log started for: 药库管理系统
94      15:54:05  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.226','3','appYP_YK.exe'||'+'||'药库管理系统','939','32641' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual

95      15:54:05  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.226','3','appYP_YK.exe'||'+'||'药库管理系统','939','32641' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual

96      15:54:05  SQL Data In: ORACLE - Rows affected = 1
97      15:54:05  SQL Prepare: ORACLE - Commit

98      15:54:05  SQL Execute: ORACLE - Commit

99      15:54:05  SQL Data In: ORACLE - Rows affected = 0
100     15:54:05  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

101     15:54:05  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

102     15:54:05  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

103     15:54:05  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

104     15:54:05  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

105     15:54:05  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

106     15:54:05  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

107     15:54:05  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

108     15:54:05  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.226','3','appYP_YK.exe'||'+'||'药库管理系统','1020','10913' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual

109     15:54:05  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.226','3','appYP_YK.exe'||'+'||'药库管理系统','1020','10913' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual

110     15:54:05  SQL Data In: ORACLE - Rows affected = 1
111     15:54:05  SQL Prepare: ORACLE - Commit

112     15:54:05  SQL Execute: ORACLE - Commit

113     15:54:05  SQL Data In: ORACLE - Rows affected = 0
114     15:54:05  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3'

115     15:54:05  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3'

116     15:54:05  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

117     15:54:05  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

118     15:54:05  SQL Prepare: ORACLE - Select SYSDATE from Dual

119     15:54:05  SQL Execute: ORACLE - Select SYSDATE from Dual

120     15:54:07  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

121     15:54:07  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

122     15:54:07  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

123     15:54:07  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

124     15:54:07  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3'

125     15:54:07  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3'

126     15:54:07  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

127     15:54:07  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

128     15:54:07  SQL Prepare: 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

129     15:54:07  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

130     15:54:07  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('6')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by b.PLXH00,a.BH0000

131     15:54:07  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('6')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by b.PLXH00,a.BH0000

132     15:54:08  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'3' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='3' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 

133     15:54:08  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'3' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='3' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 

134     15:54:08  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

135     15:54:08  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

136     15:54:08  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

137     15:54:08  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

138     15:54:08  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

139     15:54:08  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

140     15:54:08  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

141     15:54:08  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

142     15:54:08  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

143     15:54:08  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

144     15:54:08  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 SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

145     15:54:08  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 SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

146     15:54:08  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3464644,476,'BZ1UQZZXW8GF5WB','3',nvl('74779829',' '),'192.168.14.226#1020:10913@appYP_YK.exe+药库管理系统',12)

147     15:54:08  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3464644,476,'BZ1UQZZXW8GF5WB','3',nvl('74779829',' '),'192.168.14.226#1020:10913@appYP_YK.exe+药库管理系统',12)

148     15:54:08  SQL Data In: ORACLE - Rows affected = 1
149     15:54:08  SQL Prepare: ORACLE - Commit

150     15:54:08  SQL Execute: ORACLE - Commit

151     15:54:08  SQL Data In: ORACLE - Rows affected = 0
152     15:54:08  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12

153     15:54:08  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12

154     15:54:08  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

155     15:54:08  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

156     15:54:08  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

157     15:54:08  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

158     15:54:08  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.226'

159     15:54:08  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.226'

160     15:54:08  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

161     15:54:08  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

162     15:54:08  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
12 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

163     15:54:08  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
12 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

164     15:54:08  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

165     15:54:08  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

166     15:54:08  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'3'||',')>0 

167     15:54:08  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'3'||',')>0 

168     15:54:09  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN'

169     15:54:09  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN'

170     15:54:09  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

171     15:54:09  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

172     15:54:09  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20130327'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 )

173     15:54:09  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20130327'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 )

174     15:54:09  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

175     15:54:09  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

176     15:54:09  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

177     15:54:09  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

178     15:54:09  SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12

179     15:54:09  SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12

180     15:54:09  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID'

181     15:54:09  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID'

182     15:54:09  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID'

183     15:54:09  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID'

184     15:54:09  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID'

185     15:54:09  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID'

186     15:54:09  SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED'

187     15:54:09  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED'

188     15:54:09  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_triggers
 where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED'

189     15:54:09  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_triggers
 where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED'

190     15:54:09  SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%'

191     15:54:09  SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%'

192     15:54:10  SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476

193     15:54:10  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476

194     15:54:10  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 
476= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='3'))) 

195     15:54:10  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 
476= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='3'))) 

196     15:54:10  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

197     15:54:10  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

198     15:54:10  SQL Prepare: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 

199     15:54:10  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 

200     15:54:10  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

201     15:54:10  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

202     15:54:10  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 

203     15:54:10  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 

204     15:54:10  SQL Prepare: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 

205     15:54:10  SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 

206     15:54:10  SQL Prepare: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX 
 WHERE YKBMBH=12
 AND KCSL00<KCXX00 

207     15:54:10  SQL Execute: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX 
 WHERE YKBMBH=12
 AND KCSL00<KCXX00 

208     15:54:13  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

209     15:54:13  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

210     15:54:17  SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00

211     15:54:17  SQL Execute: ORACLE - SELECT * FROM BM_YPLB00

212     15:54:17  SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh)

213     15:54:17  SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh)

214     15:54:17  SQL Prepare: ORACLE -  Select * From BM_YPYL00 where LBBH00 like '0%' order by LBBH00,YLBH00

215     15:54:17  SQL Execute: ORACLE -  Select * From BM_YPYL00 where LBBH00 like '0%' order by LBBH00,YLBH00

216     15:54:17  SQL Prepare: ORACLE -  Select * From BM_YPYL00 where LBBH00 LIKE '0%' order BY LBBH00,YLBH00

217     15:54:17  SQL Execute: ORACLE -  Select * From BM_YPYL00 where LBBH00 LIKE '0%' order BY LBBH00,YLBH00

218     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='01'
 ORDER BY LSH000

219     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='01'
 ORDER BY LSH000

220     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='02'
 ORDER BY LSH000

221     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='02'
 ORDER BY LSH000

222     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='03'
 ORDER BY LSH000

223     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='03'
 ORDER BY LSH000

224     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='04'
 ORDER BY LSH000

225     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='04'
 ORDER BY LSH000

226     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='05'
 ORDER BY LSH000

227     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='05'
 ORDER BY LSH000

228     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='06'
 ORDER BY LSH000

229     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='06'
 ORDER BY LSH000

230     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='07'
 ORDER BY LSH000

231     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='07'
 ORDER BY LSH000

232     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='08'
 ORDER BY LSH000

233     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='08'
 ORDER BY LSH000

234     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='09'
 ORDER BY LSH000

235     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='09'
 ORDER BY LSH000

236     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='10'
 ORDER BY LSH000

237     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='10'
 ORDER BY LSH000

238     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='11'
 ORDER BY LSH000

239     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='11'
 ORDER BY LSH000

240     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='12'
 ORDER BY LSH000

241     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='12'
 ORDER BY LSH000

242     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='13'
 ORDER BY LSH000

243     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='13'
 ORDER BY LSH000

244     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='14'
 ORDER BY LSH000

245     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='14'
 ORDER BY LSH000

246     15:54:17  SQL Prepare: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='15'
 ORDER BY LSH000

247     15:54:17  SQL Execute: ORACLE -  Select * From BM_CJYLBM where LBBH00='0'
 and YLBH00='15'
 ORDER BY LSH000

248     15:54:17  SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00
 WHERE LBBH00 like '%0%'

249     15:54:17  SQL Execute: ORACLE - SELECT * FROM BM_YPJX00
 WHERE LBBH00 like '%0%'

250     15:54:17  SQL Prepare: ORACLE - Select QZFSID,QZFSMC from BQ_YPQZFS

251     15:54:17  SQL Execute: ORACLE - Select QZFSID,QZFSMC from BQ_YPQZFS

252     15:54:17  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH'

253     15:54:17  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH'

254     15:54:17  SQL Prepare: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=476 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH' and DBGRIN='DBGridEh1' order by LS0000

255     15:54:17  SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=476 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH' and DBGRIN='DBGridEh1' order by LS0000

256     15:54:17  SQL Prepare: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=476 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH' and DBGRIN='DBGridEh2' order by LS0000

257     15:54:17  SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=476 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH' and DBGRIN='DBGridEh2' order by LS0000

258     15:54:17  SQL Prepare: ORACLE - select distinct MC0000,BH0000 from BM_TYZD00 where ZDMC00='药品性质' order by BH0000

259     15:54:17  SQL Execute: ORACLE - select distinct MC0000,BH0000 from BM_TYZD00 where ZDMC00='药品性质' order by BH0000

260     15:54:24  SQL Prepare: ORACLE - select C.*,FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,
MZFPMC,ZFBL00,YBLB00,SFYBXM,YBLB,SFXM00,YBBRLB,TZBZ00,JXMC00,YBPYSM,YBWBSM ,
(SELECT YLMC00 from BM_YPYL00 WHERE LBBH00=C.LBBH00 AND YLBH00=C.YLBH00) L_YPYL,
(SELECT JXMC00 from BM_YPJX00 WHERE LBBH00=C.LBBH00 AND JXBH00=C.JXBH00) L_YPJX 
 FROM (select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW 
 from bm_yd0000 A,BM_CJYLBM B where 1=1 and A.CYLLSH=B.LSH000(+)
 and A.LBBH00 like '0%'
 and A.YLBH00 like '08%'
 and A.JXBH00 like '%'
 and A.YKBMBH=12
 and A.TZRQ00 IS NULL
 ) C,
(select FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,MZFPMC,ZFBL00,YBLB00,SFYBXM,JXMC00,
DECODE(YBLB00,'4','甲类药品','5','乙类药品','6','民族药品','7','非医保药品','8','医保药品') YBLB,
DECODE(SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,YBBRLB,TZBZ00,PYSM00 YBPYSM,WBSM00 YBWBSM 
 from  VW_BM_YBSFDYYPMCFP where 1=1 
 and FBBH00='0'
 and YBZXLB=''
 and SFYBXM like '%'
 AND TZBZ00 like '%'
 ) B  where C.YPNM00=B.SFXMID(+) 
 order by C.YPBM00

261     15:54:24  SQL Execute: ORACLE - select C.*,FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,
MZFPMC,ZFBL00,YBLB00,SFYBXM,YBLB,SFXM00,YBBRLB,TZBZ00,JXMC00,YBPYSM,YBWBSM ,
(SELECT YLMC00 from BM_YPYL00 WHERE LBBH00=C.LBBH00 AND YLBH00=C.YLBH00) L_YPYL,
(SELECT JXMC00 from BM_YPJX00 WHERE LBBH00=C.LBBH00 AND JXBH00=C.JXBH00) L_YPJX 
 FROM (select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW 
 from bm_yd0000 A,BM_CJYLBM B where 1=1 and A.CYLLSH=B.LSH000(+)
 and A.LBBH00 like '0%'
 and A.YLBH00 like '08%'
 and A.JXBH00 like '%'
 and A.YKBMBH=12
 and A.TZRQ00 IS NULL
 ) C,
(select FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,MZFPMC,ZFBL00,YBLB00,SFYBXM,JXMC00,
DECODE(YBLB00,'4','甲类药品','5','乙类药品','6','民族药品','7','非医保药品','8','医保药品') YBLB,
DECODE(SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,YBBRLB,TZBZ00,PYSM00 YBPYSM,WBSM00 YBWBSM 
 from  VW_BM_YBSFDYYPMCFP where 1=1 
 and FBBH00='0'
 and YBZXLB=''
 and SFYBXM like '%'
 AND TZBZ00 like '%'
 ) B  where C.YPNM00=B.SFXMID(+) 
 order by C.YPBM00

262     15:54:24  SQL Prepare: ORACLE - select * from BM_YPLB00

263     15:54:24  SQL Execute: ORACLE - select * from BM_YPLB00

264     15:54:24  SQL Prepare: ORACLE - select * from BM_YPYL00
where lbbh00=:1

265     15:54:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
266     15:54:24  SQL Execute: ORACLE - select * from BM_YPYL00
where lbbh00=?

267     15:54:24  SQL Prepare: ORACLE - select * from BM_YPJX00
where lbbh00=:1

268     15:54:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
269     15:54:24  SQL Execute: ORACLE - select * from BM_YPJX00
where lbbh00=?

270     15:54:24  SQL Prepare: ORACLE - select count(1) count0 from bm_yd0000
 where LBBH00 like '0%'
 and YLBH00 like '08%'
 and JXBH00 like '%'
 and YKBMBH=12
 and TZRQ00 IS NULL
 order by YPBM00 

271     15:54:24  SQL Execute: ORACLE - select count(1) count0 from bm_yd0000
 where LBBH00 like '0%'
 and YLBH00 like '08%'
 and JXBH00 like '%'
 and YKBMBH=12
 and TZRQ00 IS NULL
 order by YPBM00 

272     15:54:24  SQL Prepare: ORACLE - select * from BM_YPJX00
where lbbh00=:1

273     15:54:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
274     15:54:24  SQL Execute: ORACLE - select * from BM_YPJX00
where lbbh00=?

275     15:54:24  SQL Prepare: ORACLE - select * from BM_YPYL00
where lbbh00=:1

276     15:54:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
277     15:54:24  SQL Execute: ORACLE - select * from BM_YPYL00
where lbbh00=?

278     15:54:27  SQL Prepare: ORACLE - select C.*,FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,
MZFPMC,ZFBL00,YBLB00,SFYBXM,YBLB,SFXM00,YBBRLB,TZBZ00,JXMC00,YBPYSM,YBWBSM ,
(SELECT YLMC00 from BM_YPYL00 WHERE LBBH00=C.LBBH00 AND YLBH00=C.YLBH00) L_YPYL,
(SELECT JXMC00 from BM_YPJX00 WHERE LBBH00=C.LBBH00 AND JXBH00=C.JXBH00) L_YPJX 
 FROM (select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW 
 from bm_yd0000 A,BM_CJYLBM B where 1=1 and A.CYLLSH=B.LSH000(+)
 and A.LBBH00 like '0%'
 and A.YLBH00 like '%'
 and A.JXBH00 like '%'
 and A.YKBMBH=12
 and A.TZRQ00 IS NULL
 ) C,
(select FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,MZFPMC,ZFBL00,YBLB00,SFYBXM,JXMC00,
DECODE(YBLB00,'4','甲类药品','5','乙类药品','6','民族药品','7','非医保药品','8','医保药品') YBLB,
DECODE(SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,YBBRLB,TZBZ00,PYSM00 YBPYSM,WBSM00 YBWBSM 
 from  VW_BM_YBSFDYYPMCFP where 1=1 
 and FBBH00='0'
 and YBZXLB=''
 and SFYBXM like '%'
 AND TZBZ00 like '%'
 ) B  where C.YPNM00=B.SFXMID(+) 
 order by C.YPBM00

279     15:54:27  SQL Execute: ORACLE - select C.*,FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,
MZFPMC,ZFBL00,YBLB00,SFYBXM,YBLB,SFXM00,YBBRLB,TZBZ00,JXMC00,YBPYSM,YBWBSM ,
(SELECT YLMC00 from BM_YPYL00 WHERE LBBH00=C.LBBH00 AND YLBH00=C.YLBH00) L_YPYL,
(SELECT JXMC00 from BM_YPJX00 WHERE LBBH00=C.LBBH00 AND JXBH00=C.JXBH00) L_YPJX 
 FROM (select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW 
 from bm_yd0000 A,BM_CJYLBM B where 1=1 and A.CYLLSH=B.LSH000(+)
 and A.LBBH00 like '0%'
 and A.YLBH00 like '%'
 and A.JXBH00 like '%'
 and A.YKBMBH=12
 and A.TZRQ00 IS NULL
 ) C,
(select FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,MZFPMC,ZFBL00,YBLB00,SFYBXM,JXMC00,
DECODE(YBLB00,'4','甲类药品','5','乙类药品','6','民族药品','7','非医保药品','8','医保药品') YBLB,
DECODE(SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,YBBRLB,TZBZ00,PYSM00 YBPYSM,WBSM00 YBWBSM 
 from  VW_BM_YBSFDYYPMCFP where 1=1 
 and FBBH00='0'
 and YBZXLB=''
 and SFYBXM like '%'
 AND TZBZ00 like '%'
 ) B  where C.YPNM00=B.SFXMID(+) 
 order by C.YPBM00

280     15:54:28  SQL Prepare: ORACLE - select count(1) count0 from bm_yd0000
 where LBBH00 like '0%'
 and YLBH00 like '%'
 and JXBH00 like '%'
 and YKBMBH=12
 and TZRQ00 IS NULL
 order by YPBM00 

281     15:54:28  SQL Execute: ORACLE - select count(1) count0 from bm_yd0000
 where LBBH00 like '0%'
 and YLBH00 like '%'
 and JXBH00 like '%'
 and YKBMBH=12
 and TZRQ00 IS NULL
 order by YPBM00 

282     15:54:28  SQL Prepare: ORACLE - select * from BM_YPJX00
where lbbh00=:1

283     15:54:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
284     15:54:28  SQL Execute: ORACLE - select * from BM_YPJX00
where lbbh00=?

285     15:54:28  SQL Prepare: ORACLE - select * from BM_YPYL00
where lbbh00=:1

286     15:54:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
287     15:54:28  SQL Execute: ORACLE - select * from BM_YPYL00
where lbbh00=?

288     15:55:32  SQL Prepare: ORACLE - update bm_yd0000
set
  YPNM00 = :1,
  YKBMBH = :2,
  YPBM00 = :3,
  PYSM00 = :4,
  WBSM00 = :5,
  YPMC00 = :6,
  YPGG00 = :7,
  YPJCL0 = :8,
  KCDW00 = :9,
  JLDW00 = :10,
  ZYFYDW = :11,
  MZFYDW = :12,
  MZKFDW = nvl(:13 ,:14),
  K2J000 = :15,
  Z2J000 = :16,
  M2J000 = :17,
  F2J000 = nvl(:18,1),
  PFJ000 = :19,
  LSJ000 = :20,
  ZBJ000 = :21,
  GJJ000 = :22,
  CYJL00 = :23,
  PDXH00 = :24,
  SFKYYY = :25,
  SFZBYP = :26,
  QZFS00 = :27,
  MZQZFS = :28,
  LBBH00 = :29,
  YLBH00 = :30,
  JXBH00 = :31,
  SFPSYY = :32,
  DXSYBZ = :33,
  ZJBZ00 = :34,
  SFXY00 = :35,
  BZ0000 = :36,
  NSBL00 = :37,
  JKBH00 = :38,
  BZGG00 = :39,
  ZDXL00 = :40,
  NDJCTS = :41,
  TPWJMC= :42,
  YYDW00= nvl(:43,JLDW00),
  YYZHL0= nvl(:44,1),
  YPXZ00=:45,
  SFOTC0=:46,
  SFJCYY=:47,
  YPMLBZ=:48,
  YPPZBH=:49,
  YPCZFL=nvl(:50,'0')
where
  YPNM00 = :51

289     15:55:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11560.000000
290     15:55:32  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000
291     15:55:32  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 601021070
292     15:55:32  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = etkwjnegd
293     15:55:32  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = lfhfeglap
294     15:55:32  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 21, Scale = 0, Data = 恩替卡韦胶囊(恩甘定）
295     15:55:32  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 0.5mg*7
296     15:55:32  SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.150000
297     15:55:32  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒
298     15:55:32  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg
299     15:55:32  SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒
300     15:55:32  SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒
301     15:55:32  SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg
302     15:55:32  SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg
303     15:55:32  SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.500000
304     15:55:32  SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.500000
305     15:55:32  SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.500000
306     15:55:32  SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
307     15:55:32  SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
308     15:55:32  SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 138.000000
309     15:55:32  SQL Data In: ORACLE - Param = 21, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
310     15:55:32  SQL Data In: ORACLE - Param = 22, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 120.000000
311     15:55:32  SQL Data In: ORACLE - Param = 23, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
312     15:55:32  SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
313     15:55:32  SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
314     15:55:32  SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
315     15:55:32  SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
316     15:55:32  SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
317     15:55:32  SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
318     15:55:32  SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02
319     15:55:32  SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02
320     15:55:32  SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
321     15:55:32  SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
322     15:55:32  SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
323     15:55:32  SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
324     15:55:32  SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
325     15:55:32  SQL Data In: ORACLE - Param = 37, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
326     15:55:32  SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
327     15:55:32  SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
328     15:55:32  SQL Data In: ORACLE - Param = 40, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
329     15:55:32  SQL Data In: ORACLE - Param = 41, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
330     15:55:32  SQL Data In: ORACLE - Param = 42, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
331     15:55:32  SQL Data In: ORACLE - Param = 43, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = mg    
332     15:55:32  SQL Data In: ORACLE - Param = 44, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
333     15:55:32  SQL Data In: ORACLE - Param = 45, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
334     15:55:32  SQL Data In: ORACLE - Param = 46, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
335     15:55:32  SQL Data In: ORACLE - Param = 47, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
336     15:55:32  SQL Data In: ORACLE - Param = 48, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
337     15:55:32  SQL Data In: ORACLE - Param = 49, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
338     15:55:32  SQL Data In: ORACLE - Param = 50, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
339     15:55:32  SQL Data In: ORACLE - Param = 51, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11560.000000
340     15:55:32  SQL Execute: ORACLE - update bm_yd0000
set
  YPNM00 = ?,
  YKBMBH = ?,
  YPBM00 = ?,
  PYSM00 = ?,
  WBSM00 = ?,
  YPMC00 = ?,
  YPGG00 = ?,
  YPJCL0 = ?,
  KCDW00 = ?,
  JLDW00 = ?,
  ZYFYDW = ?,
  MZFYDW = ?,
  MZKFDW = nvl(? ,?),
  K2J000 = ?,
  Z2J000 = ?,
  M2J000 = ?,
  F2J000 = nvl(?,1),
  PFJ000 = ?,
  LSJ000 = ?,
  ZBJ000 = ?,
  GJJ000 = ?,
  CYJL00 = ?,
  PDXH00 = ?,
  SFKYYY = ?,
  SFZBYP = ?,
  QZFS00 = ?,
  MZQZFS = ?,
  LBBH00 = ?,
  YLBH00 = ?,
  JXBH00 = ?,
  SFPSYY = ?,
  DXSYBZ = ?,
  ZJBZ00 = ?,
  SFXY00 = ?,
  BZ0000 = ?,
  NSBL00 = ?,
  JKBH00 = ?,
  BZGG00 = ?,
  ZDXL00 = ?,
  NDJCTS = ?,
  TPWJMC= ?,
  YYDW00= nvl(?,JLDW00),
  YYZHL0= nvl(?,1),
  YPXZ00=?,
  SFOTC0=?,
  SFJCYY=?,
  YPMLBZ=?,
  YPPZBH=?,
  YPCZFL=nvl(?,'0')
where
  YPNM00 = ?

341     15:55:32  SQL Data In: ORACLE - Rows affected = 1
342     15:55:32  SQL Prepare: ORACLE - commit

343     15:55:32  SQL Execute: ORACLE - commit

344     15:55:32  SQL Data In: ORACLE - Rows affected = 0
345     08:53:04  SQL Prepare: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=3464644

346     08:53:04  SQL Execute: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=3464644

347     08:53:04  SQL Data In: ORACLE - Rows affected = 1
348     08:53:04  SQL Prepare: ORACLE - Commit

349     08:53:04  SQL Execute: ORACLE - Commit

350     08:53:04  SQL Data In: ORACLE - Rows affected = 0
351     08:53:04  SQL Prepare: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

352     08:53:04  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

353     08:53:04  SQL Data In: ORACLE - Rows affected = 0
354     08:53:04  SQL Prepare: ORACLE - Commit

355     08:53:04  SQL Execute: ORACLE - Commit

356     08:53:04  SQL Data In: ORACLE - Rows affected = 0
357     08:53:04  SQL Data In: ORACLE - Rows affected = 1
358     08:53:04  Log started for: 手术麻醉管理系统
359     08:53:10  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

360     08:53:10  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

361     08:53:12  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='247718'

362     08:53:12  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='247718'

363     08:53:12  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

364     08:53:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 4259
365     08:53:12  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

366     08:53:13  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

367     08:53:13  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

368     08:53:13  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

369     08:53:13  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3591
370     08:53:13  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

371     08:53:21  SQL Prepare: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00 from vw_ss_hs0000 where (pysm00 Like :1) Order By pysm00) where Rownum<=1000

372     08:53:21  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
373     08:53:21  SQL Execute: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00 from vw_ss_hs0000 where (pysm00 Like ?) Order By pysm00) where Rownum<=1000

374     08:53:25  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

375     08:53:25  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

376     08:53:25  SQL Prepare: ORACLE - update SS_YW0000 set SSZT00='2',SSQSRQ='20121011',SSQSSJ='07:30:00',SSJH00='01',SSTBH0='01',SSTC00='2',GRQK00='阴性',SSJCSJ='',SSDJMC=decode('222137','222504',NULL,'二级'),SSKS00='54',GLDJMC='正常',SSYS00='46',SSYSXM='陈敬安',SSZS00='899',SSZSXM='林振兴',SXYS00='',SXYSXM='',TSHS00='510;718',TSHSXM='陈炳莺;陈婵娟',GYHS00='500;1059;718',GYHSXM='方威;陈冬晴;陈婵娟',XSHS00='',XSHSXM='',SSSD00='上午',SSZB00='' where SSDH00='3591'

377     08:53:25  SQL Execute: ORACLE - update SS_YW0000 set SSZT00='2',SSQSRQ='20121011',SSQSSJ='07:30:00',SSJH00='01',SSTBH0='01',SSTC00='2',GRQK00='阴性',SSJCSJ='',SSDJMC=decode('222137','222504',NULL,'二级'),SSKS00='54',GLDJMC='正常',SSYS00='46',SSYSXM='陈敬安',SSZS00='899',SSZSXM='林振兴',SXYS00='',SXYSXM='',TSHS00='510;718',TSHSXM='陈炳莺;陈婵娟',GYHS00='500;1059;718',GYHSXM='方威;陈冬晴;陈婵娟',XSHS00='',XSHSXM='',SSSD00='上午',SSZB00='' where SSDH00='3591'

378     08:53:25  SQL Data In: ORACLE - Rows affected = 1
379     08:53:25  SQL Prepare: ORACLE - select * from bq_ssmzxx where SSDH00 = '3591'

380     08:53:25  SQL Execute: ORACLE - select * from bq_ssmzxx where SSDH00 = '3591'

381     08:53:25  SQL Prepare: ORACLE - update bq_ssmzxx set SSBH00='0',SSMC00='切开复位+中空钉内固定术',MZBH00=nvl('17','0'),MZMC00=nvl('会诊','0'),SSRQ00='20121011',YGBH00='46' where SSDH00='3591'

382     08:53:25  SQL Execute: ORACLE - update bq_ssmzxx set SSBH00='0',SSMC00='切开复位+中空钉内固定术',MZBH00=nvl('17','0'),MZMC00=nvl('会诊','0'),SSRQ00='20121011',YGBH00='46' where SSDH00='3591'

383     08:53:25  SQL Data In: ORACLE - Rows affected = 1
384     08:53:25  SQL Prepare: ORACLE - update ss_yw0000 set BZ0000= '透视！' where SSDH00= '3591'

385     08:53:25  SQL Execute: ORACLE - update ss_yw0000 set BZ0000= '透视！' where SSDH00= '3591'

386     08:53:25  SQL Data In: ORACLE - Rows affected = 1
387     08:53:25  SQL Prepare: ORACLE - update ss_yw0000 set YYSSRQ= '20121011' where SSDH00= '3591'

388     08:53:25  SQL Execute: ORACLE - update ss_yw0000 set YYSSRQ= '20121011' where SSDH00= '3591'

389     08:53:25  SQL Data In: ORACLE - Rows affected = 1
390     08:53:25  SQL Prepare: ORACLE - update ss_yw0000 set YYSSSJ= '07:30:00' where SSDH00= '3591'

391     08:53:25  SQL Execute: ORACLE - update ss_yw0000 set YYSSSJ= '07:30:00' where SSDH00= '3591'

392     08:53:25  SQL Data In: ORACLE - Rows affected = 1
393     08:53:25  SQL Prepare: ORACLE - Commit

394     08:53:25  SQL Execute: ORACLE - Commit

395     08:53:25  SQL Data In: ORACLE - Rows affected = 0
396     08:53:26  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

397     08:53:26  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

398     08:53:26  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

399     08:53:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
400     08:53:26  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

401     08:53:26  SQL Prepare: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','急诊','择期') JZBZZW from vw_ss_yw0000 a 
where SSZT00='2' 
 and (ssfybz='0' or ssfybz='1') 
and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20120101' and '20130131'
order by SSDH00) b

402     08:53:26  SQL Execute: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','急诊','择期') JZBZZW from vw_ss_yw0000 a 
where SSZT00='2' 
 and (ssfybz='0' or ssfybz='1') 
and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20120101' and '20130131'
order by SSDH00) b

403     08:53:35  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

404     08:53:35  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

405     08:53:35  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

406     08:53:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
407     08:53:35  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

408     08:53:35  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

409     08:53:35  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

410     08:53:35  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

411     08:53:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
412     08:53:35  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

413     08:53:35  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

414     08:53:35  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

415     08:53:35  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

416     08:53:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3591
417     08:53:35  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

418     08:53:37  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='247718'

419     08:53:37  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='247718'

420     08:53:37  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

421     08:53:37  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 4259
422     08:53:37  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

423     08:53:43  SQL Prepare: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00 from vw_ss_hs0000 where (pysm00 Like :1) Order By pysm00) where Rownum<=1000

424     08:53:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
425     08:53:43  SQL Execute: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00 from vw_ss_hs0000 where (pysm00 Like ?) Order By pysm00) where Rownum<=1000

426     08:53:46  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='247718'

427     08:53:46  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='247718'

428     08:53:46  SQL Prepare: ORACLE - update SS_YW0000 set SSZT00='2',SSQSRQ='20121102',SSQSSJ='23:40:00',SSJH00='01',SSTBH0='01',SSTC00='1',GRQK00='阴性',SSJCSJ='',SSDJMC=decode('222137','222504',NULL,'一级'),SSKS00='54',GLDJMC='',SSYS00='104',SSYSXM='唐维克',SSZS00='647',SSZSXM='许伟明',SXYS00='',SXYSXM='',TSHS00='240;211',TSHSXM='郭小军;陈婵娟',GYHS00='1045;718',GYHSXM='王宇;陈婵娟',XSHS00='',XSHSXM='',SSSD00='',SSZB00='' where SSDH00='4259'

429     08:53:46  SQL Execute: ORACLE - update SS_YW0000 set SSZT00='2',SSQSRQ='20121102',SSQSSJ='23:40:00',SSJH00='01',SSTBH0='01',SSTC00='1',GRQK00='阴性',SSJCSJ='',SSDJMC=decode('222137','222504',NULL,'一级'),SSKS00='54',GLDJMC='',SSYS00='104',SSYSXM='唐维克',SSZS00='647',SSZSXM='许伟明',SXYS00='',SXYSXM='',TSHS00='240;211',TSHSXM='郭小军;陈婵娟',GYHS00='1045;718',GYHSXM='王宇;陈婵娟',XSHS00='',XSHSXM='',SSSD00='',SSZB00='' where SSDH00='4259'

430     08:53:46  SQL Data In: ORACLE - Rows affected = 1
431     08:53:46  SQL Prepare: ORACLE - select * from bq_ssmzxx where SSDH00 = '4259'

432     08:53:46  SQL Execute: ORACLE - select * from bq_ssmzxx where SSDH00 = '4259'

433     08:53:46  SQL Prepare: ORACLE - update bq_ssmzxx set SSBH00='20715',SSMC00='去颅骨骨瓣减压术',MZBH00=nvl('17','0'),MZMC00=nvl('会诊','0'),SSRQ00='20121102',YGBH00='104' where SSDH00='4259'

434     08:53:46  SQL Execute: ORACLE - update bq_ssmzxx set SSBH00='20715',SSMC00='去颅骨骨瓣减压术',MZBH00=nvl('17','0'),MZMC00=nvl('会诊','0'),SSRQ00='20121102',YGBH00='104' where SSDH00='4259'

435     08:53:46  SQL Data In: ORACLE - Rows affected = 1
436     08:53:46  SQL Prepare: ORACLE - update ss_yw0000 set BZ0000= '' where SSDH00= '4259'

437     08:53:46  SQL Execute: ORACLE - update ss_yw0000 set BZ0000= '' where SSDH00= '4259'

438     08:53:46  SQL Data In: ORACLE - Rows affected = 1
439     08:53:46  SQL Prepare: ORACLE - update ss_yw0000 set YYSSRQ= '20121102' where SSDH00= '4259'

440     08:53:46  SQL Execute: ORACLE - update ss_yw0000 set YYSSRQ= '20121102' where SSDH00= '4259'

441     08:53:46  SQL Data In: ORACLE - Rows affected = 1
442     08:53:46  SQL Prepare: ORACLE - update ss_yw0000 set YYSSSJ= '23:40:00' where SSDH00= '4259'

443     08:53:46  SQL Execute: ORACLE - update ss_yw0000 set YYSSSJ= '23:40:00' where SSDH00= '4259'

444     08:53:46  SQL Data In: ORACLE - Rows affected = 1
445     08:53:46  SQL Prepare: ORACLE - Commit

446     08:53:46  SQL Execute: ORACLE - Commit

447     08:53:46  SQL Data In: ORACLE - Rows affected = 0
448     08:53:47  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

449     08:53:47  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

450     08:53:47  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

451     08:53:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
452     08:53:47  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

453     08:53:47  SQL Prepare: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','急诊','择期') JZBZZW from vw_ss_yw0000 a 
where SSZT00='2' 
 and (ssfybz='0' or ssfybz='1') 
and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20120101' and '20130131'
order by SSDH00) b

454     08:53:47  SQL Execute: ORACLE - select (rownum-1) XH0000,b.* from (select a.*,
a.XX0000 XKXX00, 
 decode(a.jzbz00,'Y','急诊','择期') JZBZZW from vw_ss_yw0000 a 
where SSZT00='2' 
 and (ssfybz='0' or ssfybz='1') 
and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) 
and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) 
and sqrq00 between'20120101' and '20130131'
order by SSDH00) b

455     08:53:56  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

456     08:53:56  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

457     08:53:56  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

458     08:53:56  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
459     08:53:56  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

460     08:53:56  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

461     08:53:56  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='244509'

462     08:53:56  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

463     08:53:56  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3157
464     08:53:56  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

465     08:53:56  SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='247718'

466     08:53:56  SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='247718'

467     08:53:56  SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0

468     08:53:56  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 4259
469     08:53:56  SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c
where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00
order by SFZSS0