1       10:41:50  Log started for: 门诊医生工作站分系统
2       10:41:51  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','480','6024' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@0806:EF006C93B1A7678757DA3EC138CDECB4' from dual

3       10:41:51  SQL Execute: ORACLE - Commit

4       10:41:51  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

5       10:41:51  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

6       10:41:51  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='0806' and CZBZ00 in ('1') 

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

8       10:41:51  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','629','16809' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@0806:9FA6B8EF4FFA93CC5498E515793CD875' from dual

9       10:41:51  SQL Execute: ORACLE - Commit

10      10:41:51  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8'

11      10:41:51  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='0806' and CZBZ00 in ('1') 

12      10:41:51  SQL Execute: ORACLE - Select SYSDATE from Dual

13      10:41:51  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

14      10:41:51  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

15      10:41:51  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8'

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

17      10:41:51  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

18      10:41:51  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)='0806')) 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)='0806'))
 order by b.PLXH00,a.BH0000

19      10:41:51  SQL Execute: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 

20      10:41:51  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)='0806')
 and rownum=1 

21      10:41:51  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'0806'='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)='0806'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806') 

22      10:41:51  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=444

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

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

25      10:41:51  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

26      10:41:51  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

27      10:41:51  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'))

28      10:41:52  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(4223317,444,'wlzx-3','8',nvl('228297511',' '),'192.168.5.33#629:16809@appYS_YSGZZ.exe+门诊医生工作站分系统',37)

29      10:41:52  SQL Execute: ORACLE - Commit

30      10:41:52  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 37

31      10:41:52  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

32      10:41:52  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

33      10:41:52  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33'

34      10:41:52  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

35      10:41:52  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
37 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

36      10:41:52  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

37      10:41:52  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 

38      10:41:54  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='444' and name00='SYSTEMSKIN'

39      10:41:54  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

40      10:41:54  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20140801'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',37,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='8')

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

42      10:41:54  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

43      10:41:54  SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '1'

44      10:41:54  SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 

45      10:41:54  SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '3'

46      10:41:54  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID')

47      10:41:54  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')

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

49      10:41:54  SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 

50      10:41:54  SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 

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

52      10:41:54  SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 

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

54      10:41:54  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 = 444

55      10:41:54  SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?)

56      10:41:54  SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y'

57      10:41:54  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' 

58      10:41:54  SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=?

59      10:41:54  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

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

61      10:41:55  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

62      10:41:55  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 ((444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='0 '))) 

63      10:41:55  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

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

65      10:41:55  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(+) 

66      10:41:55  SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1

67      10:41:55  SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00
 where YGBH00=?

68      10:41:55  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

69      10:41:55  SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=?

70      10:41:55  SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=?

71      10:41:55  SQL Execute: ORACLE -  Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000

72      10:41:55  SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000

73      10:41:56  SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00

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

75      10:41:56  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

76      10:41:56  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

77      10:41:56  SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb

78      10:41:56  SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX
 where SLBMBH=37  and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

79      10:41:56  SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX
 where SLBMBH=37  and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

80      10:41:56  SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX)
 where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc

81      10:41:56  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

82      10:41:56  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

83      10:41:56  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

84      10:41:56  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

85      10:41:56  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

86      10:41:56  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

87      10:41:56  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

88      10:41:56  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?

89      10:41:56  SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00'
 and value0 = '0' and YGBH00 = 444

90      10:41:56  SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科'

91      10:41:56  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0'

92      10:41:56  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0'

93      10:41:56  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0'

94      10:41:56  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0'

95      10:41:56  SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=444 

96      10:42:08  SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00

97      10:42:08  SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD
 where YXBZ00='Y'

98      10:42:08  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=444 and BMBH00=12345
 and DLXTMC='检验结果查询' and CTMC00='FormQuery'

99      10:42:08  SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=444 and BMBH00=12345
 and DLXTMC='检验结果查询' and CTMC00='FormQuery' and DBGRIN='DBGridEh2' order by LS0000

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

101     10:42:08  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ')

102     10:42:08  SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW')

103     10:42:08  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 

104     10:42:08  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 

105     10:42:08  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 

106     10:42:08  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 

107     10:42:09  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 

108     10:42:09  SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 

109     10:42:09  SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='37'

110     10:42:09  SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT'

111     10:42:09  SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='37'

112     10:42:09  SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='37'

113     10:42:09  SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='37'

114     10:42:09  SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='37'

115     10:42:09  SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='37'

116     10:42:09  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='444' 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 '20140801' and '20140801' and (  ( A.SQKS00+0 = '37' or A.SQBQ00+0 = '37') )) t1 )
 order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc

117     10:42:09  SQL Execute: ORACLE - select  BGVIEW from JY_JYYQZD  where YQDH00='BC'

118     10:42:09  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='BC0051' and pyrq00='20140801' and rownum=1

119     10:42:09  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'BC0051' and PYRQ00 = '20140801'

120     10:42:09  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,22767)

121     10:42:09  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='BC0051' and pyrq00='20140801'
 ORDER BY DYSX00

122     10:43:55  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

123     10:43:55  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?

124     10:44:10  SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=37

125     10:44:10  SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID  from VW_YS_JCJYD0 where LBBH00=3
 and BRID00=-1 and MZZYBZ='0' 
 order by ZYGHID desc

126     10:44:10  SQL Execute: ORACLE - select * from BM_JCLB00 where SFJK00='1'

127     10:44:10  SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000='0806'

128     10:44:10  SQL Execute: ORACLE - select BMBH00,BMXZ00 from BM_BMBM00 where JKBH01='37'

129     10:45:55  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

130     10:45:55  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?

131     10:46:15  SQL Execute: ORACLE - select JKBH01 from BM_BMBM00 where BMBH00=37

132     10:46:15  SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID  from VW_YS_JCJYD0 where LBBH00=3
 and BRID00=-1 and MZZYBZ='0' 
 order by ZYGHID desc

133     10:46:15  SQL Execute: ORACLE - select * from BM_JCLB00 where SFJK00='1'

134     10:46:15  SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000='0806'

135     10:46:15  SQL Execute: ORACLE - select BMBH00,BMXZ00 from BM_BMBM00 where JKBH01='37'

136     10:46:16  SQL Execute: ORACLE - Select a.*,'图像' TX0000 from VW_PACS_BGCX00 a where KDKSBH in (37) and KDRQ00 between ? and ? 
 and a.KDYS00444
 order by ZYGHID desc,YJDJH0 desc

137     10:46:43  SQL Execute: ORACLE - Select a.*,'图像' TX0000 from VW_PACS_BGCX00 a where KDKSBH in (37) and KDRQ00 between ? and ? 
 and a.KDYS00444
 order by ZYGHID desc,YJDJH0 desc

138     10:47:55  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

139     10:47:55  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?