1       16:51:43  Log started for: 门诊医生工作站分系统
2       16:51:43  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

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

4       16:51:43  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.9.154','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','81','50430' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual

5       16:51:43  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.9.154','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','81','50430' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual

6       16:51:43  SQL Data In: ORACLE - Rows affected = 1
7       16:51:43  SQL Prepare: ORACLE - Commit

8       16:51:43  SQL Execute: ORACLE - Commit

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

11      16:51:43  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

12      16:51:43  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

13      16:51:43  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

14      16:51:43  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

15      16:51:43  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

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

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

18      16:51:43  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.9.154','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','141','22139' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual

19      16:51:43  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.9.154','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','141','22139' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual

20      16:51:43  SQL Data In: ORACLE - Rows affected = 1
21      16:51:43  SQL Prepare: ORACLE - Commit

22      16:51:43  SQL Execute: ORACLE - Commit

23      16:51:43  SQL Data In: ORACLE - Rows affected = 0
24      16:51:43  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8'

25      16:51:43  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8'

26      16:51:43  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

27      16:51:43  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

28      16:51:43  SQL Prepare: ORACLE - Select SYSDATE from Dual

29      16:51:43  SQL Execute: ORACLE - Select SYSDATE from Dual

30      16:51:43  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

31      16:51:43  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

32      16:51:43  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

33      16:51:43  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

34      16:51:43  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8'

35      16:51:43  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8'

36      16:51:43  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

37      16:51:43  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

38      16:51:43  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

39      16:51:43  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

40      16:51:43  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('0','1','5','9','c')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 order by b.PLXH00,a.BH0000

41      16:51:43  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('0','1','5','9','c')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 order by b.PLXH00,a.BH0000

42      16:51:44  SQL Prepare: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 

43      16:51:44  SQL Execute: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 

44      16:51:44  SQL Prepare: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and 
sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS')
 and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or 
(GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS')
 and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1))
 and  TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where 
 CZBZ00='1' and Upper(XKH000)='343')
 and rownum=1 

45      16:51:44  SQL Execute: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and 
sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS')
 and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or 
(GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS')
 and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1))
 and  TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where 
 CZBZ00='1' and Upper(XKH000)='343')
 and rownum=1 

46      16:51:44  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'343'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'8' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 

47      16:51:44  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'343'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'8' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 

48      16:51:45  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143

49      16:51:45  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143

50      16:51:45  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

51      16:51:45  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

52      16:51:45  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

53      16:51:45  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

54      16:51:45  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

55      16:51:45  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

56      16:51:45  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

57      16:51:45  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

58      16:51:45  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'))

59      16:51:45  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'))

60      16:51:45  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3949114,1143,'wlzx-1','8',nvl('226956367',' '),'192.168.9.154#141:22139@appYS_YSGZZ.exe+门诊医生工作站分系统',20)

61      16:51:45  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3949114,1143,'wlzx-1','8',nvl('226956367',' '),'192.168.9.154#141:22139@appYS_YSGZZ.exe+门诊医生工作站分系统',20)

62      16:51:45  SQL Data In: ORACLE - Rows affected = 1
63      16:51:45  SQL Prepare: ORACLE - Commit

64      16:51:45  SQL Execute: ORACLE - Commit

65      16:51:45  SQL Data In: ORACLE - Rows affected = 0
66      16:51:45  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20

67      16:51:45  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20

68      16:51:45  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

69      16:51:45  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

70      16:51:45  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

71      16:51:45  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

72      16:51:45  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.154'

73      16:51:45  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.154'

74      16:51:45  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

75      16:51:45  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

76      16:51:45  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
20 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

77      16:51:45  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
20 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

78      16:51:45  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

79      16:51:45  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

80      16:51:45  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 

81      16:51:45  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 

82      16:51:47  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN'

83      16:51:47  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN'

84      16:51:47  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

85      16:51:47  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

86      16:51:47  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20140116'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='8')

87      16:51:47  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20140116'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='8')

88      16:51:47  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

89      16:51:47  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

90      16:51:47  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

91      16:51:47  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

92      16:51:48  SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '1'

93      16:51:48  SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '1'

94      16:51:48  SQL Prepare: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 

95      16:51:48  SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 

96      16:51:48  SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '3'

97      16:51:48  SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '3'

98      16:51:48  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID')

99      16:51:48  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID')

100     16:51:48  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS','YS_YYCXZNCXBYS','YS_JCJYJGDZ')

101     16:51:48  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS','YS_YYCXZNCXBYS','YS_JCJYJGDZ')

102     16:51:48  SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心'

103     16:51:48  SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心'

104     16:51:48  SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 

105     16:51:48  SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 

106     16:51:48  SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 

107     16:51:48  SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 

108     16:51:48  SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 

109     16:51:48  SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 

110     16:51:48  SQL Prepare: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 

111     16:51:48  SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 

112     16:51:48  SQL Prepare: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='居民健康档案提示的相关参数' AND YXBZ00='1'  order by XSXH00 

113     16:51:48  SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='居民健康档案提示的相关参数' AND YXBZ00='1'  order by XSXH00 

114     16:51:48  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter')
 and YGBH00 = 1143

115     16:51:48  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter')
 and YGBH00 = 1143

116     16:51:48  SQL Prepare: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=:1)

117     16:51:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
118     16:51:48  SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?)

119     16:51:48  SQL Prepare: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y'

120     16:51:48  SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y'

121     16:51:48  SQL Prepare: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=:1
 and GHYSBH=:2 and GHMZSJ=to_char(sysdate,'yyyymmdd')
 and GHQSSJ<=to_char(sysdate,'hh24:mi:ss')
 and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 

122     16:51:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
123     16:51:48  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
124     16:51:48  SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=?
 and GHYSBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd')
 and GHQSSJ<=to_char(sysdate,'hh24:mi:ss')
 and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 

125     16:51:48  SQL Prepare: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=:1

126     16:51:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
127     16:51:48  SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=?

128     16:51:48  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

129     16:51:48  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

130     16:51:48  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='8'))) 

131     16:51:48  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='8'))) 

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

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

134     16:51:48  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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 

135     16:51:48  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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 

136     16:51:48  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

137     16:51:48  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

138     16:51:48  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 

139     16:51:48  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 

140     16:51:51  SQL Prepare: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=:1 and a.YSLB00=b.YSLB00(+) 

141     16:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
142     16:51:51  SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 

143     16:51:51  SQL Prepare: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1

144     16:51:51  SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1

145     16:51:51  SQL Prepare: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00
 where YGBH00=:1

146     16:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
147     16:51:51  SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00
 where YGBH00=?

148     16:51:51  SQL Prepare: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=:1 and  GZDJ00 <=:2 and  MZDJ00 <=:3 and  DPDJ00 <=:4 and KSSDJ0<=:5  and  ((SJDJ00 >=:6 and :7 >'0')  or SJDJ00='0') and Rownum=1

149     16:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
150     16:51:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
151     16:51:51  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
152     16:51:51  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
153     16:51:51  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
154     16:51:51  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
155     16:51:51  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
156     16:51:51  SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and  GZDJ00 <=? and  MZDJ00 <=? and  DPDJ00 <=? and KSSDJ0<=?  and  ((SJDJ00 >=? and ? >'0')  or SJDJ00='0') and Rownum=1

157     16:51:51  SQL Prepare: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=:1

158     16:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
159     16:51:51  SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=?

160     16:51:51  SQL Prepare: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=:1

161     16:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
162     16:51:51  SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=?

163     16:51:51  SQL Prepare: ORACLE -  Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000

164     16:51:51  SQL Execute: ORACLE -  Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000

165     16:51:51  SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000

166     16:51:51  SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000

167     16:51:51  SQL Prepare: ORACLE - select count(*) CD0000 from BM_ZDMS00

168     16:51:51  SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00

169     16:51:51  SQL Prepare: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00

170     16:51:51  SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00

171     16:51:51  SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

172     16:51:51  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

173     16:51:51  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

174     16:51:51  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

175     16:51:51  SQL Prepare: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb

176     16:51:51  SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb

177     16:51:51  SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX
 where SLBMBH=20  and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

178     16:51:51  SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX
 where SLBMBH=20  and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

179     16:51:51  SQL Prepare: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX
 where SLBMBH=20  and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

180     16:51:51  SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX
 where SLBMBH=20  and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

181     16:51:51  SQL Prepare: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX)
 where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

182     16:51:51  SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX)
 where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

183     16:51:51  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

184     16:51:51  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

185     16:51:51  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

186     16:51:51  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

187     16:51:51  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

188     16:51:51  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

189     16:51:51  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

190     16:51:51  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

191     16:51:51  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

192     16:51:51  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

193     16:51:51  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

194     16:51:51  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

195     16:51:51  SQL Prepare: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=:1 and ghksbh=:2

196     16:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
197     16:51:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
198     16:51:51  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

199     16:51:51  SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=:1 and jzks00=:2

200     16:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
201     16:51:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
202     16:51:51  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?

203     16:51:51  SQL Prepare: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00'
 and value0 = '0' and YGBH00 = 1143

204     16:51:51  SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00'
 and value0 = '0' and YGBH00 = 1143

205     16:51:51  SQL Prepare: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科'

206     16:51:51  SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科'

207     16:51:51  SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0'

208     16:51:51  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0'

209     16:51:51  SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0'

210     16:51:51  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0'

211     16:51:51  SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0'

212     16:51:51  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0'

213     16:51:51  SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0'

214     16:51:51  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0'

215     16:51:51  SQL Prepare: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=1143 

216     16:51:51  SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=1143 

217     16:52:19  SQL Prepare: ORACLE - select BBMC00,BBID00 from BM_BBZD00

218     16:52:19  SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00

219     16:52:19  SQL Prepare: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD
 where YXBZ00='Y'

220     16:52:19  SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD
 where YXBZ00='Y'

221     16:52:19  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=12345
 and DLXTMC='检验结果查询' and CTMC00='FormQuery'

222     16:52:19  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=12345
 and DLXTMC='检验结果查询' and CTMC00='FormQuery'

223     16:52:19  SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

224     16:52:19  SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

225     16:52:19  SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ')

226     16:52:19  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ')

227     16:52:19  SQL Prepare: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW')

228     16:52:19  SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW')

229     16:52:19  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 

230     16:52:19  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 

231     16:52:19  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 

232     16:52:19  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 

233     16:52:19  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 

234     16:52:19  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 

235     16:52:19  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 

236     16:52:19  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 

237     16:52:19  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 

238     16:52:19  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 

239     16:52:19  SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 

240     16:52:19  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 

241     16:52:19  SQL Prepare: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='20'

242     16:52:19  SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='20'

243     16:52:19  SQL Prepare: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT'

244     16:52:19  SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT'

245     16:52:19  SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='20'

246     16:52:19  SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='20'

247     16:52:19  SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='20'

248     16:52:19  SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='20'

249     16:52:19  SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='20'

250     16:52:19  SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='20'

251     16:52:19  SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='20'

252     16:52:19  SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='20'

253     16:52:19  SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='20'

254     16:52:19  SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='20'

255     16:52:19  SQL Prepare: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='1143' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( 
 select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8')  and A.PYRQ00 between '20140116' and '20140116' and (  ( A.SQKS00+0 = '20' or A.SQBQ00+0 = '20') )) t1 )
 order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc

256     16:52:19  SQL Execute: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='1143' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( 
 select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8')  and A.PYRQ00 between '20140116' and '20140116' and (  ( A.SQKS00+0 = '20' or A.SQBQ00+0 = '20') )) t1 )
 order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc

257     16:52:19  SQL Prepare: ORACLE - select  BGVIEW from JY_JYYQZD  where YQDH00='AC'

258     16:52:19  SQL Execute: ORACLE - select  BGVIEW from JY_JYYQZD  where YQDH00='AC'

259     16:52:19  SQL Prepare: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='AC0008' and pyrq00='20140116' and rownum=1

260     16:52:19  SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='AC0008' and pyrq00='20140116' and rownum=1

261     16:52:19  SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AC0008' and PYRQ00 = '20140116'

262     16:52:19  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AC0008' and PYRQ00 = '20140116'

263     16:52:20  SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,17170,17173)

264     16:52:20  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,17170,17173)

265     16:52:20  SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='AC0008' and pyrq00='20140116'
 ORDER BY DYSX00

266     16:52:20  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='AC0008' and pyrq00='20140116'
 ORDER BY DYSX00

267     16:53:24  SQL Prepare: ORACLE - select count(*) vcount from  bm_ckbm00 where bmbh00=:1 and PBLX00='1' and flag00='4' 

268     16:53:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
269     16:53:24  SQL Execute: ORACLE - select count(*) vcount from  bm_ckbm00 where bmbh00=? and PBLX00='1' and flag00='4' 

270     16:53:50  SQL Prepare: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=:1 and ghksbh=:2

271     16:53:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
272     16:53:50  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
273     16:53:50  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

274     16:53:50  SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=:1 and jzks00=:2

275     16:53:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1143
276     16:53:50  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
277     16:53:50  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?