1       10:43:39  Log started for: Yjsystem
2       10:43:39  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '197.169.1.59','7','YJsystem.exe'||'+'||'医技管理系统','139','4937' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9999:DA0EAE149D09996EA79567577DAFEB94' from dual

3       10:43:39  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '197.169.1.59','7','YJsystem.exe'||'+'||'医技管理系统','139','4937' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9999:DA0EAE149D09996EA79567577DAFEB94' from dual

4       10:43:39  SQL Data In: ORACLE - Rows affected = 1
5       10:43:39  SQL Prepare: ORACLE - Commit

6       10:43:39  SQL Execute: ORACLE - Commit

7       10:43:39  SQL Data In: ORACLE - Rows affected = 0
8       10:43:39  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

9       10:43:39  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

10      10:43:39  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='228766'

11      10:43:39  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='228766'

12      10:43:39  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

13      10:43:39  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

14      10:43:39  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

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

16      10:43:39  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '197.169.1.59','7','YJsystem.exe'||'+'||'医技管理系统','147','7749' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9999:E6FF90CC7B40FDC6BE8E9A76F2A70CBA' from dual

17      10:43:39  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '197.169.1.59','7','YJsystem.exe'||'+'||'医技管理系统','147','7749' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9999:E6FF90CC7B40FDC6BE8E9A76F2A70CBA' from dual

18      10:43:39  SQL Data In: ORACLE - Rows affected = 1
19      10:43:39  SQL Prepare: ORACLE - Commit

20      10:43:39  SQL Execute: ORACLE - Commit

21      10:43:39  SQL Data In: ORACLE - Rows affected = 0
22      10:43:39  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7'

23      10:43:39  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7'

24      10:43:39  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

25      10:43:39  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

26      10:43:39  SQL Prepare: ORACLE - Select SYSDATE from Dual

27      10:43:39  SQL Execute: ORACLE - Select SYSDATE from Dual

28      10:43:39  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

29      10:43:39  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

30      10:43:39  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

31      10:43:39  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

32      10:43:39  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7'

33      10:43:39  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7'

34      10:43:39  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

35      10:43:39  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

36      10:43:39  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

37      10:43:39  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

38      10:43:39  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'

39      10:43:39  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'

40      10:43:39  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 = 'YB-SBK'

41      10:43:39  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 = 'YB-SBK'

42      10:43:39  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='7'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('1','5')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 order by b.PLXH00,a.BH0000

43      10:43:39  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='7'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('1','5')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 order by b.PLXH00,a.BH0000

44      10:43:42  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9999'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'7' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='7' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999') 

45      10:43:42  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9999'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'7' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='7' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999') 

46      10:43:42  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=756

47      10:43:42  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=756

48      10:43:42  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

49      10:43:42  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

50      10:43:42  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

51      10:43:42  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

52      10:43:42  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

53      10:43:42  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

54      10:43:42  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

55      10:43:42  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

56      10:43:42  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'))

57      10:43:42  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'))

58      10:43:42  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(852489,756,'xinxike59','7',nvl('1439',' '),'197.169.1.59#147:7749@YJsystem.exe+医技管理系统',821)

59      10:43:42  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(852489,756,'xinxike59','7',nvl('1439',' '),'197.169.1.59#147:7749@YJsystem.exe+医技管理系统',821)

60      10:43:42  SQL Data In: ORACLE - Rows affected = 1
61      10:43:42  SQL Prepare: ORACLE - Commit

62      10:43:42  SQL Execute: ORACLE - Commit

63      10:43:42  SQL Data In: ORACLE - Rows affected = 0
64      10:43:42  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 821

65      10:43:42  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 821

66      10:43:42  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '228766'

67      10:43:42  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '228766'

68      10:43:42  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

69      10:43:42  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

70      10:43:42  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='197.169.1.59'

71      10:43:42  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='197.169.1.59'

72      10:43:42  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

73      10:43:42  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

74      10:43:42  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
821 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

75      10:43:42  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
821 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

76      10:43:42  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('228766') 

77      10:43:42  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('228766') 

78      10:43:42  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'7'||',')>0 

79      10:43:42  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'7'||',')>0 

80      10:43:43  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='756' and name00='SYSTEMSKIN'

81      10:43:43  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='756' and name00='SYSTEMSKIN'

82      10:43:43  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

83      10:43:43  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

84      10:43:43  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='7') and YXQ000>='20120505'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',821,' )>0 )

85      10:43:43  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='7') and YXQ000>='20120505'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',821,' )>0 )

86      10:43:43  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

87      10:43:43  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

88      10:43:43  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

89      10:43:43  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

90      10:43:43  SQL Prepare: ORACLE - select sysdate from dual

91      10:43:43  SQL Execute: ORACLE - select sysdate from dual

92      10:43:43  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='7' and (( 
756= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=756 and XTDM00='7'))) 

93      10:43:43  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='7' and (( 
756= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=756 and XTDM00='7'))) 

94      10:43:44  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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

95      10:43:44  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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

96      10:43:44  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 ((756= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=756 and XTDM00='0 '))) 

97      10:43:44  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 ((756= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=756 and XTDM00='0 '))) 

98      10:43:44  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

99      10:43:44  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

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

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

102     10:43:44  SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

103     10:43:44  SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

104     10:43:44  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY','YJ_BBCYHZDPrintSet')
 and YGBH00 = 756

105     10:43:44  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY','YJ_BBCYHZDPrintSet')
 and YGBH00 = 756

106     10:43:44  SQL Prepare: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YF_YYGXH','YJ_YXCXTS','YJ_YXCXTS2','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YF_MZCFTDHS','YJ_XMZJYSWSSKS','YJ_XSKDYGS','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW','YF_MZCFSFDYXXYF','YF_CFSFDYTYM','YF_CFTDGSSFZJZD','YF_MZCFJYDJGHS','YF_MZCFSFDYYS','YF_MZCFTDDDHS','YF_CFTDSFDYFB','YF_ZYJYF_SFDM','YF_SFDYCFT','YJ_SFQYMZYDSY')

107     10:43:44  SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YF_YYGXH','YJ_YXCXTS','YJ_YXCXTS2','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YF_MZCFTDHS','YJ_XMZJYSWSSKS','YJ_XSKDYGS','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW','YF_MZCFSFDYXXYF','YF_CFSFDYTYM','YF_CFTDGSSFZJZD','YF_MZCFJYDJGHS','YF_MZCFSFDYYS','YF_MZCFTDDDHS','YF_CFTDSFDYFB','YF_ZYJYF_SFDM','YF_SFDYCFT','YJ_SFQYMZYDSY')

108     10:43:44  SQL Prepare: ORACLE -  select YYID00 from xt_yyxx00 where rownum=1

109     10:43:44  SQL Execute: ORACLE -  select YYID00 from xt_yyxx00 where rownum=1

110     10:43:44  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=756 and name00='YJ_QSBRLB'

111     10:43:44  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=756 and name00='YJ_QSBRLB'

112     10:43:44  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

113     10:43:44  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

114     10:43:45  SQL Prepare: ORACLE - select yyqc00 from xt_yyxx00

115     10:43:45  SQL Execute: ORACLE - select yyqc00 from xt_yyxx00

116     10:43:45  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

117     10:43:45  SQL Prepare: ORACLE - select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,
b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,
b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,
b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,
b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,
b.zxrq00,b.brybmc,b.zxsj00,b.cxsl00,b.txm000,b.SYLSH0
from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and yjdjh0=1
 

118     10:43:45  SQL Execute: ORACLE - select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,
b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,
b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,
b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,
b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,
b.zxrq00,b.brybmc,b.zxsj00,b.cxsl00,b.txm000,b.SYLSH0
from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and yjdjh0=1
 

119     10:43:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
120     10:43:45  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

121     10:43:45  SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL'

122     10:43:45  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL'

123     10:43:45  SQL Prepare: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and  exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y')

124     10:43:45  SQL Execute: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and  exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y')

125     10:43:45  SQL Prepare: ORACLE -  SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ'

126     10:43:45  SQL Execute: ORACLE -  SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ'

127     10:43:45  SQL Prepare: ORACLE - select 1 from dual where 821 in (811)

128     10:43:45  SQL Execute: ORACLE - select 1 from dual where 821 in (811)

129     10:43:45  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD'

130     10:43:45  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD'

131     10:43:45  SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

132     10:43:45  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

133     10:43:45  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

134     10:43:45  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

135     10:43:45  SQL Prepare: ORACLE - select bmbh00,bmmc00 from bm_bmbm00  where bmxz00='9' and flag00='1'

136     10:43:45  SQL Execute: ORACLE - select bmbh00,bmmc00 from bm_bmbm00  where bmxz00='9' and flag00='1'

137     10:43:45  SQL Prepare: ORACLE - select count(*) from xt_zldczl where rownum=1

138     10:43:45  SQL Execute: ORACLE - select count(*) from xt_zldczl where rownum=1

139     10:43:47  SQL Prepare: ORACLE - Select SYSDATE from Dual

140     10:43:47  SQL Execute: ORACLE - Select SYSDATE from Dual

141     10:43:47  SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'

142     10:43:47  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'

143     10:43:47  SQL Prepare: ORACLE - update XT_XTCS00 set VALUE0='55' where NAME00='IC_BBH'

144     10:43:47  SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='55' where NAME00='IC_BBH'

145     10:43:47  SQL Data In: ORACLE - Rows affected = 1
146     10:43:47  SQL Prepare: ORACLE - Commit

147     10:43:47  SQL Execute: ORACLE - Commit

148     10:43:47  SQL Data In: ORACLE - Rows affected = 0
149     10:43:47  SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')

150     10:43:47  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')

151     10:43:47  SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = '0228766600039957'
and ICKNBH = '0228766600039957'

152     10:43:47  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = '0228766600039957'
and ICKNBH = '0228766600039957'

153     10:43:47  SQL Prepare: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END;
154     10:43:47  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1029127.000000
155     10:43:47  SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
156     10:43:47  SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
157     10:43:47  SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
158     10:43:47  SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
159     10:43:47  SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
160     10:43:47  SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
161     10:43:47  SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
162     10:43:47  SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
163     10:43:47  SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
164     10:43:47  SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
165     10:43:47  SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
166     10:43:47  SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
167     10:43:47  SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
168     10:43:47  SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
169     10:43:47  SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
170     10:43:47  SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
171     10:43:47  SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END;
172     10:43:47  SQL Prepare: ORACLE - SELECT A.*,'1' PCMC00 FROM YF_MZCFMX A WHERE CFID00=1

173     10:43:47  SQL Execute: ORACLE - SELECT A.*,'1' PCMC00 FROM YF_MZCFMX A WHERE CFID00=1

174     10:43:47  SQL Prepare: ORACLE - select * from BQ_YPYZMX
where YZID00=:1

175     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
176     10:43:47  SQL Execute: ORACLE - select * from BQ_YPYZMX
where YZID00=?

177     10:43:47  SQL Prepare: ORACLE - select * from BQ_YPYZMX
where YZMXID=:1

178     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 98.000000
179     10:43:47  SQL Execute: ORACLE - select * from BQ_YPYZMX
where YZMXID=?

180     10:43:47  SQL Prepare: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' 
 and xmzt00 in ('0','1','2')
 and b.mzzybz='0'
 and brid00=:1
 and (YJKSBH=:2 or ( (((b.Zlxmid,b.kdksbh) in 
 (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=:3)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=:4) ))   
 and ( (',0,'=',0,') or  (instr(',0,',:5 )>0) ) )
)
 and kdrq00 between :6 and :7 
 and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0
 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid

181     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1029127.000000
182     10:43:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 821.000000
183     10:43:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 821.000000
184     10:43:47  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 821.000000
185     10:43:47  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ,821,
186     10:43:47  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120428
187     10:43:47  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120505
188     10:43:47  SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' 
 and xmzt00 in ('0','1','2')
 and b.mzzybz='0'
 and brid00=?
 and (YJKSBH=? or ( (((b.Zlxmid,b.kdksbh) in 
 (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) ))   
 and ( (',0,'=',0,') or  (instr(',0,',? )>0) ) )
)
 and kdrq00 between ? and ? 
 and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0
 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid

189     10:43:47  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

190     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571612.000000
191     10:43:47  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

192     10:43:47  SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00,
J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and YjFzh0=:1

193     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571612.000000
194     10:43:47  SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00,
J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and YjFzh0=?

195     10:43:47  SQL Prepare: ORACLE - select nvl(SF_YJ_GETWSFXMZJE(821,-1,'20120428','20120505'),'0') WSFZJE from dual

196     10:43:47  SQL Execute: ORACLE - select nvl(SF_YJ_GETWSFXMZJE(821,-1,'20120428','20120505'),'0') WSFZJE from dual

197     10:43:47  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

198     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571612.000000
199     10:43:47  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

200     10:43:47  SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00,
J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and YjFzh0=:1

201     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571612.000000
202     10:43:47  SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00,
J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and YjFzh0=?

203     10:43:47  SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=:1

204     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571612.000000
205     10:43:47  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000
from yj_ywmx00
where yjdjh0=?

206     10:43:47  SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00,
J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and YjFzh0=:1

207     10:43:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571612.000000
208     10:43:47  SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00,
J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 
from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID  
 and YjFzh0=?