1       10:07:45  Log started for: 住院收费管理系统
2       10:19:58  Log started for: 门诊护士工作站
3       10:19:58  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','D','Mzhsfz.exe'||'+'||'门诊护士工作站','1146','16922' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@111:CAC1D6D538208D45806F8F1A8DAB1690' from dual

4       10:19:58  SQL Data In: ORACLE - Rows affected = 1
5       10:19:58  SQL Execute: ORACLE - Commit

6       10:19:58  SQL Data In: ORACLE - Rows affected = 0
7       10:19:58  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

8       10:19:58  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

9       10:19:58  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='111' and CZBZ00 in ('1') 

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

11      10:19:58  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','D','Mzhsfz.exe'||'+'||'门诊护士工作站','777','7603' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@111:6188101FBDA32589DA4CF66E89954F37' from dual

12      10:19:58  SQL Data In: ORACLE - Rows affected = 1
13      10:19:58  SQL Execute: ORACLE - Commit

14      10:19:58  SQL Data In: ORACLE - Rows affected = 0
15      10:19:58  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='D'

16      10:19:58  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='111' and CZBZ00 in ('1') 

17      10:19:58  SQL Execute: ORACLE - Select SYSDATE from Dual

18      10:19:58  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

19      10:19:58  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

20      10:19:58  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='D'

21      10:19:58  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

22      10:19:58  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

23      10:19:58  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='D'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='111')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('1')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='D'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='111'))
 order by b.PLXH00,a.BH0000

24      10:19:58  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'111'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'D' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='111'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='D' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='111') 

25      10:19:58  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1203

26      10:19:58  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

27      10:19:58  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

28      10:19:58  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

29      10:19:58  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

30      10:19:58  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'))

31      10:20:00  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(4698790,1203,'wlzx-3','D',nvl('231397777',' '),'192.168.5.33#777:7603@Mzhsfz.exe+门诊护士工作站',363)

32      10:20:00  SQL Data In: ORACLE - Rows affected = 1
33      10:20:00  SQL Execute: ORACLE - Commit

34      10:20:00  SQL Data In: ORACLE - Rows affected = 0
35      10:20:00  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 363

36      10:20:00  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

37      10:20:00  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

38      10:20:00  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33'

39      10:20:00  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

40      10:20:00  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
363 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

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

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

43      10:20:02  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1203' and name00='SYSTEMSKIN'

44      10:20:02  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

45      10:20:02  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20150713'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',363,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='D')

46      10:20:02  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

47      10:20:02  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

48      10:20:02  SQL Execute: ORACLE -  select * from xt_yyxx00 where rownum=1

49      10:20:02  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YF_ZYCF_SFSH','SF_SFSYICK','XT_SGLRKH','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEWIDTH','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','XT_CFYS','YS_CF_SAVE_YPKCSL','XT_JYDSFBXZDBB','XT_MZJYJK','YS_YPBZSFTSJXBC','YS_JZLGMFH','YS_HSZYGH','YS_YSSFXZGHLB','YS_HSZSFDYHZD','YS_HSZSFDYKSHZD','YS_CFDRKGMFH','YS_SFANKSXZYS','YS_FZJMXSYGSJD','YS_HSGHXZHZXH','YS_HSZJJCL','YS_ZFBRZFBLYBLB','YS_YGHSFZZSGH','YS_MZCFDRXSFS','YS_MZYSMFGHLB','MZHS_DRXTSFYXZJTJXM','MZHS_HZBRPLSX','YK_YYGXH','MZHS_SFYXSCWSFZLXMDCCF','YJ_RHXMLYKSZX','MZHS_HZBRJHFA','MZHS_JZBRJHCS','MZHS_HZBRJHCS','MZHS_HZBRJHJGSJ','YF_SFABYFFYDWFY','MZHS_SFXSKSZLLBXM','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YJ_CXDCXMCXCF','YJ_XMCXZJTF','YJ_SYBLHCZ','MZHS_XMZXQXCXGHH','YS_QTYSYGHSFTS','YS_SFYXSYKYGHH','MZHS_YSPBHYSHBSFGLXTGN','MZPY_NPYYPYTSCL','YF_MZCFBLTS','YS_JRZJPH','MZHS_QYYF','YS_KJYGQXZB','MZHS_SFQYYYGHXT','YY_YYSFXMID','NZHS_YYHZDDYID','YY_YYTQTS','MZHS_GHCFZCLFS','MZHS_BRHZSFZDYS','YY_ZJBHSFBT','YY_SFYXDTYY','HS_ZDYDY_SYK','YS_HZJMTSCL','SF_GYZHPDBZ','SF_GHDLX0','MZHS_GHKS','SF_GFBRSFKAZFGH','SF_GYBRDTGHXDCS','MZHS_YSBH_GZ','MZHS_CMPYYJLPBJSSJJG',' YS_SRZDYZD')

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

51      10:20:02  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_INPUTBMDIRECT')
 and YGBH00 = 1203

52      10:20:05  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='D' and (( 
1203= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1203 and XTDM00='D'))) 

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

54      10:20:05  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 ((1203= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1203 and XTDM00='0 '))) 

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

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

57      10:20:09  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20150713'
 and GHMZSJ <= '20150713'
 AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0' 
  order by  GHMZSJ,YSXM00,GHQSSJ 

58      10:20:18  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20150714'
 and GHMZSJ <= '20150714'
 AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0' 
  order by  GHMZSJ,YSXM00,GHQSSJ 

59      10:21:04  SQL Execute: ORACLE -  select  *  from  BM_CKBM00  where  FLAG00 = '4' and BMBH00 =20

60      10:21:06  SQL Data In: ORACLE - Param = 1, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24603.000000
61      10:21:06  SQL Data In: ORACLE - Param = 2, Name = AD_GHKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000
62      10:21:06  SQL Data In: ORACLE - Param = 3, Name = AD_GHZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
63      10:21:06  SQL Data In: ORACLE - Param = 4, Name = AD_GHYSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000
64      10:21:06  SQL Data In: ORACLE - Param = 5, Name = AS_CKMC00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 内科2
65      10:21:06  SQL Data In: ORACLE - Param = 6, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 副主任医师
66      10:21:06  SQL Data In: ORACLE - Param = 7, Name = AS_GHMZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150714
67      10:21:06  SQL Data In: ORACLE - Param = 8, Name = AS_GHQSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 07:20:00
68      10:21:06  SQL Data In: ORACLE - Param = 9, Name = AS_GHJSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12:00:00
69      10:21:06  SQL Data In: ORACLE - Param = 10, Name = AD_GHXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 150.000000
70      10:21:06  SQL Data In: ORACLE - Param = 11, Name = AD_YYXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000
71      10:21:06  SQL Data In: ORACLE - Param = 12, Name = AD_GHYGHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
72      10:21:06  SQL Data In: ORACLE - Param = 13, Name = AD_GHYYHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
73      10:21:06  SQL Data In: ORACLE - Param = 14, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
74      10:21:06  SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
75      10:21:06  SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
76      10:21:06  SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
77      10:21:06  SQL Data In: ORACLE - Param = 18, Name = AS_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
78      10:21:06  SQL Data In: ORACLE - Param = 19, Name = AS_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
79      10:21:06  SQL Data In: ORACLE - Param = 20, Name = AS_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
80      10:21:06  SQL Data In: ORACLE - Param = 21, Name = AS_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
81      10:21:06  SQL Data In: ORACLE - Param = 22, Name = AS_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
82      10:21:06  SQL Data In: ORACLE - Param = 23, Name = AS_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
83      10:21:06  SQL Data In: ORACLE - Param = 24, Name = AS_PJZZSJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
84      10:21:06  SQL Data In: ORACLE - Param = 25, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
85      10:21:06  SQL Data In: ORACLE - Param = 26, Name = as_DHMX02, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = NULL
86      10:21:06  SQL Data In: ORACLE - Param = 27, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
87      10:21:06  SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB_EDIT00" (AD_GHHBID => :AD_GHHBID,AD_GHKSBH => :AD_GHKSBH,AD_GHZKBH => :AD_GHZKBH,AD_GHYSBH => :AD_GHYSBH,AS_CKMC00 => :AS_CKMC00,AS_GHLBMC => :AS_GHLBMC,AS_GHMZSJ => :AS_GHMZSJ,AS_GHQSSJ => :AS_GHQSSJ,AS_GHJSSJ => :AS_GHJSSJ,AD_GHXHS0 => :AD_GHXHS0,AD_YYXHS0 => :AD_YYXHS0,AD_GHYGHS => :AD_GHYGHS,AD_GHYYHS => :AD_GHYYHS,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_FZYYS0 => :AS_FZYYS0,AS_FZYYMX => :AS_FZYYMX,AS_DHYYS0 => :AS_DHYYS0,AS_DHYYMX => :AS_DHYYMX,AS_WLYYS0 => :AS_WLYYS0,AS_WLYYMX => :AS_WLYYMX,AS_PJZZSJ => :AS_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END;
88      10:21:06  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20150714'
 and GHMZSJ <= '20150714'
 AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0' 
  order by  GHMZSJ,YSXM00,GHQSSJ 

89      10:21:18  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 2


90      10:21:19  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 3


91      10:21:19  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'



92      10:21:20  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 4


93      10:21:21  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 3


94      10:21:38  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150714
95      10:21:38  SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150714
96      10:21:38  SQL Data In: ORACLE - Param = 3, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
97      10:21:38  SQL Data In: ORACLE - Param = 4, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
98      10:21:38  SQL Data In: ORACLE - Param = 5, Name = AS_YSYGBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
99      10:21:38  SQL Data In: ORACLE - Param = 6, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
100     10:21:38  SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_YSYGBH => :AS_YSYGBH,AS_YYID00 => :AS_YYID00); END;
101     10:22:03  SQL Execute: ORACLE -  select *  from  VW_SF_YSXX00  where 1=1  

102     10:22:04  SQL Execute: ORACLE -  select *  from  VW_SF_YSXX00  where 1=1  
 and   PYSM00    like '%L%'

103     10:22:05  SQL Execute: ORACLE -  select *  from  VW_SF_YSXX00  where 1=1  
 and   PYSM00    like '%LS%'

104     10:22:05  SQL Execute: ORACLE -  select *  from  VW_SF_YSXX00  where 1=1  
 and   PYSM00    like '%L%'

105     10:22:06  SQL Execute: ORACLE -  select *  from  VW_SF_YSXX00  where 1=1  

106     10:22:07  SQL Execute: ORACLE -  select *  from  VW_SF_YSXX00  where 1=1  
 and   PYSM00    like '%l%'

107     10:22:07  SQL Execute: ORACLE -  select *  from  VW_SF_YSXX00  where 1=1  
 and   PYSM00    like '%ls%'

108     10:22:11  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
  and  YSXM00 = '林生'
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 3


109     10:22:14  SQL Execute: ORACLE - update SF_YSPBB0 set tzbz00='0' where YSPBID=504

110     10:22:14  SQL Data In: ORACLE - Rows affected = 1
111     10:22:14  SQL Execute: ORACLE - commit

112     10:22:14  SQL Data In: ORACLE - Rows affected = 0
113     10:22:14  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
  and  YSXM00 = '林生'
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 3


114     10:22:17  SQL Execute: ORACLE -  select  *  from  vw_bm_ghlbb0  

115     10:22:17  SQL Execute: ORACLE -  select  *  from    VW_BM_MZSJB0 

116     10:22:17  SQL Execute: ORACLE -  select  *  from  BM_CKBM00  where  FLAG00 = '4' and BMBH00 =20

117     10:22:31  SQL Data In: ORACLE - Param = 1, Name = AD_YSPBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 504.000000
118     10:22:31  SQL Data In: ORACLE - Param = 2, Name = AD_YSKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000
119     10:22:31  SQL Data In: ORACLE - Param = 3, Name = AD_YSZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
120     10:22:31  SQL Data In: ORACLE - Param = 4, Name = AD_YSYGBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 786.000000
121     10:22:31  SQL Data In: ORACLE - Param = 5, Name = AS_YSZC00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 内科8
122     10:22:31  SQL Data In: ORACLE - Param = 6, Name = AS_YSMZLB, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 主治医师
123     10:22:31  SQL Data In: ORACLE - Param = 7, Name = AD_YSPBXQ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
124     10:22:31  SQL Data In: ORACLE - Param = 8, Name = AS_YSPBSJ, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 下午
125     10:22:31  SQL Data In: ORACLE - Param = 9, Name = AD_YSPBXH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000
126     10:22:31  SQL Data In: ORACLE - Param = 10, Name = AD_YSYYH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000
127     10:22:31  SQL Data In: ORACLE - Param = 11, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
128     10:22:31  SQL Data In: ORACLE - Param = 12, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
129     10:22:31  SQL Data In: ORACLE - Param = 13, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
130     10:22:31  SQL Data In: ORACLE - Param = 14, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
131     10:22:31  SQL Data In: ORACLE - Param = 15, Name = as_HZQSXH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
132     10:22:31  SQL Data In: ORACLE - Param = 16, Name = as_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
133     10:22:31  SQL Data In: ORACLE - Param = 17, Name = as_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
134     10:22:31  SQL Data In: ORACLE - Param = 18, Name = as_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
135     10:22:31  SQL Data In: ORACLE - Param = 19, Name = as_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
136     10:22:31  SQL Data In: ORACLE - Param = 20, Name = as_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
137     10:22:31  SQL Data In: ORACLE - Param = 21, Name = as_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
138     10:22:31  SQL Data In: ORACLE - Param = 22, Name = as_PJZZSJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
139     10:22:31  SQL Data In: ORACLE - Param = 23, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
140     10:22:31  SQL Data In: ORACLE - Param = 24, Name = as_DHMX02, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 12,16,26,
141     10:22:31  SQL Data In: ORACLE - Param = 25, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
142     10:22:31  SQL Execute: ORACLE - BEGIN "SP_SF_YSPBB0" (AD_YSPBID => :AD_YSPBID,AD_YSKSBH => :AD_YSKSBH,AD_YSZKBH => :AD_YSZKBH,AD_YSYGBH => :AD_YSYGBH,AS_YSZC00 => :AS_YSZC00,AS_YSMZLB => :AS_YSMZLB,AD_YSPBXQ => :AD_YSPBXQ,AS_YSPBSJ => :AS_YSPBSJ,AD_YSPBXH => :AD_YSPBXH,AD_YSYYH0 => :AD_YSYYH0,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_HZQSXH => :as_HZQSXH,as_FZYYS0 => :as_FZYYS0,as_FZYYMX => :as_FZYYMX,as_DHYYS0 => :as_DHYYS0,as_DHYYMX => :as_DHYYMX,as_WLYYS0 => :as_WLYYS0,as_WLYYMX => :as_WLYYMX,as_PJZZSJ => :as_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END;
143     10:22:31  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
  and  YSXM00 = '林生'
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 3


144     10:22:41  SQL Execute: ORACLE -  select  *  from  vw_bm_ghlbb0  

145     10:22:41  SQL Execute: ORACLE -  select  *  from    VW_BM_MZSJB0 

146     10:22:41  SQL Execute: ORACLE -  select  *  from  BM_CKBM00  where  FLAG00 = '4' and BMBH00 =20

147     10:23:38  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
  and  YSXM00 = '林生'
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 3


148     10:23:49  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150714
149     10:23:49  SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150714
150     10:23:49  SQL Data In: ORACLE - Param = 3, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
151     10:23:49  SQL Data In: ORACLE - Param = 4, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
152     10:23:49  SQL Data In: ORACLE - Param = 5, Name = AS_YSYGBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 786.000000
153     10:23:49  SQL Data In: ORACLE - Param = 6, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
154     10:23:49  SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_YSYGBH => :AS_YSYGBH,AS_YYID00 => :AS_YYID00); END;
155     10:25:55  SQL Execute: ORACLE - update SF_YSPBB0 set tzbz00='1' where YSPBID=504

156     10:25:55  SQL Data In: ORACLE - Rows affected = 1
157     10:25:55  SQL Execute: ORACLE - commit

158     10:25:55  SQL Data In: ORACLE - Rows affected = 0
159     10:25:55  SQL Execute: ORACLE -  select * from vw_sf_yspbb0  where  1 = 1 
  and  YSXM00 = '林生'
 AND CKBH00 IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=82)
 and PBLX00='0'
 and  YSPBXQ = 3