1       10:23:42  SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# 
from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

2       10:23:42  SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# 
from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

3       10:23:42  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.218','8',trim(PROGRAM)||'+'||'门诊医生工作站分系统',SID,serial# ,'20100315','10:23:44','scott@9999:7A51236899C4BBB44A2418BB0F71B012' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       10:23:42  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.218','8',trim(PROGRAM)||'+'||'门诊医生工作站分系统',SID,serial# ,'20100315','10:23:44','scott@9999:7A51236899C4BBB44A2418BB0F71B012' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

5       10:23:42  SQL Data In: ORACLE - Rows affected = 1
6       10:23:42  SQL Prepare: ORACLE - Commit

7       10:23:42  SQL Execute: ORACLE - Commit

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

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

11      10:23:42  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='223583'

12      10:23:42  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='223583'

13      10:23:42  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

14      10:23:42  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

15      10:23:42  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.218','8',trim(PROGRAM)||'+'||'门诊医生工作站分系统',SID,serial# ,'20100315','10:23:44','sd_hospital@9999:BC3F203D8A7EBCB3BFDFDF3DED68D348' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

16      10:23:42  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.218','8',trim(PROGRAM)||'+'||'门诊医生工作站分系统',SID,serial# ,'20100315','10:23:44','sd_hospital@9999:BC3F203D8A7EBCB3BFDFDF3DED68D348' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

17      10:23:42  SQL Data In: ORACLE - Rows affected = 1
18      10:23:42  SQL Prepare: ORACLE - Commit

19      10:23:42  SQL Execute: ORACLE - Commit

20      10:23:42  SQL Data In: ORACLE - Rows affected = 0
21      10:23:42  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8'

22      10:23:42  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8'

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

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

25      10:23:42  SQL Prepare: ORACLE - Select SYSDATE from Dual

26      10:23:42  SQL Execute: ORACLE - Select SYSDATE from Dual

27      10:23:42  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

28      10:23:42  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

29      10:23:42  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8'

30      10:23:42  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8'

31      10:23:42  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

32      10:23:42  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

33      10:23:42  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

34      10:23:42  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

35      10:23:42  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('0','1')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 order by BH0000

36      10:23:42  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('0','1')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 order by BH0000

37      10:23:42  SQL Prepare: ORACLE - select GHKSBH 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,'YYMMDDHH24: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 GHYSBH=(select YGBH00 from BM_YGBM00 where 
 CZBZ00='1' and Upper(XKH000)='9999')
 and rownum=1 

38      10:23:42  SQL Execute: ORACLE - select GHKSBH 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,'YYMMDDHH24: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 GHYSBH=(select YGBH00 from BM_YGBM00 where 
 CZBZ00='1' and Upper(XKH000)='9999')
 and rownum=1 

39      10:23:43  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9999'='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)='9999'))

40      10:23:43  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9999'='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)='9999'))

41      10:23:43  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=2484

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

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

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

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

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

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

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

49      10:23:43  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

50      10:23:43  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

51      10:23:43  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'))

52      10:23:43  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'))

53      10:23:43  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(562507,2484,'慧慧','8',nvl('455807',' '),'192.168.1.218#97:3282@appYS_YSGZZ.exe+门诊医生工作站分系统',517)

54      10:23:43  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(562507,2484,'慧慧','8',nvl('455807',' '),'192.168.1.218#97:3282@appYS_YSGZZ.exe+门诊医生工作站分系统',517)

55      10:23:43  SQL Data In: ORACLE - Rows affected = 1
56      10:23:43  SQL Prepare: ORACLE - Commit

57      10:23:43  SQL Execute: ORACLE - Commit

58      10:23:43  SQL Data In: ORACLE - Rows affected = 0
59      10:23:43  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 517

60      10:23:43  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 517

61      10:23:43  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '223583'

62      10:23:43  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '223583'

63      10:23:43  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.218'

64      10:23:43  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.218'

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

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

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

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

69      10:23:43  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='2484' and name00='SYSTEMSKIN'

70      10:23:43  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='2484' and name00='SYSTEMSKIN'

71      10:23:43  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20100315'

72      10:23:43  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20100315'

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

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

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

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

77      10:23:43  SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '1'

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

79      10:23:43  SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '3'

80      10:23:43  SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD'
 and value0 = '3'

81      10:23:43  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID')

82      10:23:43  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID')

83      10:23:43  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_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','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_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' )

84      10:23:43  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_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','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_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' )

85      10:23:43  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 = 2484

86      10:23:43  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 = 2484

87      10:23:43  SQL Prepare: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=:1)

88      10:23:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
89      10:23:43  SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?)

90      10:23:43  SQL Prepare: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=5 and lbmc00 like '%急%' and SFYX00='Y'

91      10:23:43  SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=5 and lbmc00 like '%急%' and SFYX00='Y'

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

93      10:23:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
94      10:23:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
95      10:23:43  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' 

96      10:23:43  SQL Prepare: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=:1

97      10:23:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
98      10:23:43  SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=?

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

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

101     10:23:43  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='8' and (( 
2484= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='8' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=2484))))

102     10:23:43  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='8' and (( 
2484= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='8' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=2484))))

103     10:23:43  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

104     10:23:43  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

105     10:23:43  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 ((2484= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=2484))))  

106     10:23:43  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 ((2484= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=2484))))  

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

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

109     10:23:43  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
2484= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=2484))))

110     10:23:43  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
2484= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=2484))))

111     10:23:45  SQL Prepare: ORACLE - select YSLB00 from BM_YGBM00 where YGBH00=:1 

112     10:23:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
113     10:23:45  SQL Execute: ORACLE - select YSLB00 from BM_YGBM00 where YGBH00=? 

114     10:23:45  SQL Prepare: ORACLE - select b.SCKBH0 from BM_CKBM00 a,BM_CKDY00 b  where a.BMBH00=:1 and a.FLAG00='4' and a.CKBH00=b.DCKBH0 and rownum=1  

115     10:23:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
116     10:23:45  SQL Execute: ORACLE - select b.SCKBH0 from BM_CKBM00 a,BM_CKDY00 b  where a.BMBH00=? and a.FLAG00='4' and a.CKBH00=b.DCKBH0 and rownum=1  

117     10:23:45  SQL Prepare: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1

118     10:23:45  SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1

119     10:23:45  SQL Prepare: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00 from BM_YGBM00
 where YGBH00=:1

120     10:23:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
121     10:23:45  SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00 from BM_YGBM00
 where YGBH00=?

122     10:23:45  SQL Prepare: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=:1 and  GZDJ00 <=:2 and  MZDJ00 <=:3 and  DPDJ00 <=:4 and  ((SJDJ00 >=:5 and :6 >'0')  or SJDJ00='0') and Rownum=1

123     10:23:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
124     10:23:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
125     10:23:45  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
126     10:23:45  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
127     10:23:45  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
128     10:23:45  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
129     10:23:45  SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and  GZDJ00 <=? and  MZDJ00 <=? and  DPDJ00 <=? and  ((SJDJ00 >=? and ? >'0')  or SJDJ00='0') and Rownum=1

130     10:23:45  SQL Prepare: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=:1

131     10:23:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
132     10:23:45  SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=?

133     10:23:45  SQL Prepare: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=:1

134     10:23:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
135     10:23:45  SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=?

136     10:23:45  SQL Prepare: ORACLE -  Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000

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

138     10:23:45  SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000

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

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

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

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

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

144     10:23:45  SQL Prepare: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb

145     10:23:45  SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb

146     10:23:45  SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX
 where SLBMBH=517 order by mrbz00 desc

147     10:23:45  SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX
 where SLBMBH=517 order by mrbz00 desc

148     10:23:45  SQL Prepare: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX
 where SLBMBH=517 order by mrbz00 desc

149     10:23:45  SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX
 where SLBMBH=517 order by mrbz00 desc

150     10:23:45  SQL Prepare: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX)
 where SLBMBH=517 order by mrbz00 desc

151     10:23:45  SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX)
 where SLBMBH=517 order by mrbz00 desc

152     10:23:45  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

153     10:23:45  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

154     10:23:45  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

155     10:23:45  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

156     10:23:45  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

157     10:23:45  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

158     10:23:45  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

159     10:23:45  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='SZ0000'

160     10:23:45  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

161     10:23:45  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='ST0000'

162     10:23:45  SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

163     10:23:45  SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000
 where zdbm00='MX0000'

164     10:23:45  SQL Prepare: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=:1 and ghksbh=:2

165     10:23:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
166     10:23:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
167     10:23:45  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

168     10:23:45  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

169     10:23:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
170     10:23:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
171     10:23:45  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?

172     10:23:45  SQL Prepare: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00'
 and value0 = '0' and YGBH00 = 2484

173     10:23:45  SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00'
 and value0 = '0' and YGBH00 = 2484

174     10:23:45  SQL Prepare: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科'

175     10:23:45  SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科'

176     10:23:45  SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0'

177     10:23:45  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0'

178     10:23:45  SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0'

179     10:23:45  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0'

180     10:23:45  SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0'

181     10:23:45  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0'

182     10:23:45  SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0'

183     10:23:45  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0'

184     10:24:00  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

185     10:24:00  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

186     10:24:00  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

187     10:24:00  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

188     10:24:01  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

189     10:24:01  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

190     10:24:01  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

191     10:24:01  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

192     10:24:07  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

193     10:24:07  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

194     10:24:07  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

195     10:24:07  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

196     10:24:08  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

197     10:24:08  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

198     10:24:08  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

199     10:24:08  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

200     10:24:08  SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
 where ICKH00 = '0223583600031947'
 and ICKNBH = '0223583600031947'
 and ZT0000 = '1'

201     10:24:08  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
 where ICKH00 = '0223583600031947'
 and ICKNBH = '0223583600031947'
 and ZT0000 = '1'

202     10:24:08  SQL Prepare: ORACLE - select * from vw_ys_brxxb0 where BRID00=:1

203     10:24:08  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 183209
204     10:24:08  SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=?

205     10:24:08  SQL Prepare: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=:1

206     10:24:08  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 183209
207     10:24:08  SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=?

208     10:24:08  SQL Prepare: ORACLE - select * from VW_YS_YXGH00 a
 where (BRID00=:1)

209     10:24:08  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 183209
210     10:24:08  SQL Execute: ORACLE - select * from VW_YS_YXGH00 a
 where (BRID00=?)

211     10:24:13  SQL Prepare: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS 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')

212     10:24:13  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
213     10:24:13  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
214     10:24:13  SQL Execute: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS 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')

215     10:24:13  SQL Prepare: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC,
       a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0
from   YS_BRZDXX a, XT_ICD900 b 
where  a.ICD900=b.ICD900(+) and a.SFXYZD='1'and a.GHID00=:1 


216     10:24:13  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
217     10:24:13  SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC,
       a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0
from   YS_BRZDXX a, XT_ICD900 b 
where  a.ICD900=b.ICD900(+) and a.SFXYZD='1'and a.GHID00=? 


218     10:24:13  SQL Prepare: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC,
       JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD 
from   YS_BRZDXX 
where  SFXYZD='0'and GHID00=:1 


219     10:24:13  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
220     10:24:13  SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC,
       JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD 
from   YS_BRZDXX 
where  SFXYZD='0'and GHID00=? 


221     10:24:13  SQL Prepare: ORACLE - select sf_ys_ghxz00(517,2484,183209) from dual

222     10:24:13  SQL Execute: ORACLE - select sf_ys_ghxz00(517,2484,183209) from dual

223     10:24:13  SQL Prepare: ORACLE - select LBMC00,LBBH00 from VW_BM_GHLBB0
 where  lbbh00 in (6,1,5,2,8,4,7,3,28,9,29,30,31,32) 

224     10:24:13  SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_BM_GHLBB0
 where  lbbh00 in (6,1,5,2,8,4,7,3,28,9,29,30,31,32) 

225     10:24:13  SQL Prepare: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00

226     10:24:13  SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00

227     10:24:13  SQL Prepare: ORACLE - select SFYD00 from BM_BRXXB0 where BRID00=183209

228     10:24:13  SQL Execute: ORACLE - select SFYD00 from BM_BRXXB0 where BRID00=183209

229     10:24:13  SQL Prepare: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=183209)  and rownum=1

230     10:24:13  SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=183209)  and rownum=1

231     10:24:13  SQL Prepare: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1

232     10:24:13  SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1

233     10:24:13  SQL Prepare: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END;
234     10:24:13  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 183209.000000
235     10:24:13  SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
236     10:24:13  SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 517.000000
237     10:24:13  SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
238     10:24:13  SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
239     10:24:13  SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
240     10:24:13  SQL Data In: ORACLE - Param = 7, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
241     10:24:13  SQL Data In: ORACLE - Param = 8, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
242     10:24:13  SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END;
243     10:24:13  SQL Prepare: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END;
244     10:24:13  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 183209.000000
245     10:24:13  SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
246     10:24:13  SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 517.000000
247     10:24:13  SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
248     10:24:13  SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
249     10:24:13  SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
250     10:24:13  SQL Data In: ORACLE - Param = 7, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
251     10:24:13  SQL Data In: ORACLE - Param = 8, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
252     10:24:13  SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END;
253     10:24:19  SQL Prepare: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END;
254     10:24:19  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 183209.000000
255     10:24:19  SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28
256     10:24:19  SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 517.000000
257     10:24:19  SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
258     10:24:19  SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
259     10:24:19  SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
260     10:24:19  SQL Data In: ORACLE - Param = 7, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
261     10:24:19  SQL Data In: ORACLE - Param = 8, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
262     10:24:19  SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END;
263     10:24:26  SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

264     10:24:26  SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

265     10:24:26  SQL Prepare: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like :1 or ICD900 Like :2) Order By PXH000,ICD900,PYSM00) where Rownum<=300

266     10:24:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %%
267     10:24:26  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %%
268     10:24:26  SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ? or ICD900 Like ?) Order By PXH000,ICD900,PYSM00) where Rownum<=300

269     10:24:26  SQL Prepare: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like :1) Order By PXH000,PYSM00) where Rownum<=300

270     10:24:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %g%
271     10:24:26  SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) Order By PXH000,PYSM00) where Rownum<=300

272     10:24:27  SQL Prepare: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like :1) Order By PXH000,PYSM00) where Rownum<=300

273     10:24:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %gm%
274     10:24:27  SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) Order By PXH000,PYSM00) where Rownum<=300

275     10:24:29  SQL Prepare: ORACLE - select 1 NUM from YS_CRBDJ0 where  brid00 =  '183209'
 and trim(jbmc00)= '感冒'
 and czrq00>to_char(sysdate-365,'YYYYMMDD')

276     10:24:29  SQL Execute: ORACLE - select 1 NUM from YS_CRBDJ0 where  brid00 =  '183209'
 and trim(jbmc00)= '感冒'
 and czrq00>to_char(sysdate-365,'YYYYMMDD')

277     10:24:37  SQL Prepare: ORACLE - select SQ_SF_BRXXB0_GHH000.nextval from dual where rownum=1

278     10:24:37  SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHH000.nextval from dual where rownum=1

279     10:24:37  SQL Prepare: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1

280     10:24:37  SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1

281     10:24:37  SQL Prepare: ORACLE - commit

282     10:24:37  SQL Execute: ORACLE - commit

283     10:24:37  SQL Data In: ORACLE - Rows affected = 0
284     10:24:37  SQL Prepare: ORACLE - insert into YS_BRZDXX (ZDXXID, GHID00, GHH000,ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM,JZKS00,ZDMC00, SFYZ00, SFXYZD,ZDRQ00,ZDSJ00)Values (SQ_YS_BRZDXX_ZDXXID.nextval, 565972,'563005','3','J00  03','','2484','管理员','517','感冒','0','1',to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'))

285     10:24:37  SQL Execute: ORACLE - insert into YS_BRZDXX (ZDXXID, GHID00, GHH000,ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM,JZKS00,ZDMC00, SFYZ00, SFXYZD,ZDRQ00,ZDSJ00)Values (SQ_YS_BRZDXX_ZDXXID.nextval, 565972,'563005','3','J00  03','','2484','管理员','517','感冒','0','1',to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'))

286     10:24:37  SQL Data In: ORACLE - Rows affected = 1
287     10:24:37  SQL Prepare: ORACLE - insert into YS_BRBQB0 (ZS0000,GHID00,BRBQID,GHH000,JZYS00,SJYS00,JZRQSJ,CZRQ00,CZSJ00,JZYSXM,FBRQ00)Values('',565972,SQ_YS_BRBQB0_BRBQID.Nextval,'563005',2484,0,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),'管理员','20100315')

288     10:24:37  SQL Execute: ORACLE - insert into YS_BRBQB0 (ZS0000,GHID00,BRBQID,GHH000,JZYS00,SJYS00,JZRQSJ,CZRQ00,CZSJ00,JZYSXM,FBRQ00)Values('',565972,SQ_YS_BRBQB0_BRBQID.Nextval,'563005',2484,0,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),'管理员','20100315')

289     10:24:37  SQL Data In: ORACLE - Rows affected = 1
290     10:24:37  SQL Prepare: ORACLE - commit

291     10:24:37  SQL Execute: ORACLE - commit

292     10:24:37  SQL Data In: ORACLE - Rows affected = 0
293     10:24:38  SQL Prepare: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=:1
 and GHYSBH=:2 and PBLX00='0'   
 and GHLBBH=:3
 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj

294     10:24:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
295     10:24:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
296     10:24:38  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28
297     10:24:38  SQL Execute: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=?
 and GHYSBH=? and PBLX00='0'   
 and GHLBBH=?
 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj

298     10:24:38  SQL Prepare: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=:1
 and PBLX00='1' 
 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj

299     10:24:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
300     10:24:38  SQL Execute: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=?
 and PBLX00='1' 
 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj

301     10:24:38  SQL Prepare: ORACLE - BEGIN "SP_SF_BRGHXX" (AS_BRBLH0 => :AS_BRBLH0,AS_YBGHH0 => :AS_YBGHH0,AS_GHLBMC => :AS_GHLBMC,AD_BRID00 => :AD_BRID00,AS_SFCZ00 => :AS_SFCZ00,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AS_FBMC00 => :AS_FBMC00,AS_GFZH00 => :AS_GFZH00,AS_BRDH00 => :AS_BRDH00,AS_BRHYZK => :AS_BRHYZK,AD_GHY000 => :AD_GHY000,AS_GHYXM0 => :AS_GHYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_GHKS00 => :AD_GHKS00,AD_JZYS00 => :AD_JZYS00,AS_JZYSXM => :AS_JZYSXM,AD_GHHBID => :AD_GHHBID,AS_YJJXH0 => :AS_YJJXH0,AS_FPXH00 => :AS_FPXH00,AD_GHF000 => :AD_GHF000,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBID00 => :AS_YBID00,AS_YBKH00 => :AS_YBKH00,AS_GHRQ00 => :AS_GHRQ00,AS_SFYYGH => :AS_SFYYGH,AS_CZBZ00 => :AS_CZBZ00,AS_SFSBLF => :AS_SFSBLF,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_TYDWMC => :AS_TYDWMC,AS_SFNLYD => :AS_SFNLYD,AS_HZLB00 => :AS_HZLB00,AS_ICKH00 => :AS_ICKH00,AS_BRJTDZ => :AS_BRJTDZ,AD_FJJZDH => :AD_FJJZDH,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AS_GHH000 => :AS_GHH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JZSJ00 => :AS_JZSJ00); END;
302     10:24:38  SQL Data In: ORACLE - Param = 1, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 793
303     10:24:38  SQL Data In: ORACLE - Param = 2, Name = AS_YBGHH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
304     10:24:38  SQL Data In: ORACLE - Param = 3, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 免费挂号
305     10:24:38  SQL Data In: ORACLE - Param = 4, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 183209.000000
306     10:24:38  SQL Data In: ORACLE - Param = 5, Name = AS_SFCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
307     10:24:38  SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈庆兰
308     10:24:38  SQL Data In: ORACLE - Param = 7, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女
309     10:24:38  SQL Data In: ORACLE - Param = 8, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19630412
310     10:24:38  SQL Data In: ORACLE - Param = 9, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费
311     10:24:38  SQL Data In: ORACLE - Param = 10, Name = AS_GFZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data =  
312     10:24:38  SQL Data In: ORACLE - Param = 11, Name = AS_BRDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
313     10:24:38  SQL Data In: ORACLE - Param = 12, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
314     10:24:38  SQL Data In: ORACLE - Param = 13, Name = AD_GHY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000
315     10:24:38  SQL Data In: ORACLE - Param = 14, Name = AS_GHYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员
316     10:24:38  SQL Data In: ORACLE - Param = 15, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
317     10:24:38  SQL Data In: ORACLE - Param = 16, Name = AD_GHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 517.000000
318     10:24:38  SQL Data In: ORACLE - Param = 17, Name = AD_JZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2484.000000
319     10:24:38  SQL Data In: ORACLE - Param = 18, Name = AS_JZYSXM, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员
320     10:24:38  SQL Data In: ORACLE - Param = 19, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
321     10:24:38  SQL Data In: ORACLE - Param = 20, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
322     10:24:38  SQL Data In: ORACLE - Param = 21, Name = AS_FPXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
323     10:24:38  SQL Data In: ORACLE - Param = 22, Name = AD_GHF000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
324     10:24:38  SQL Data In: ORACLE - Param = 23, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
325     10:24:38  SQL Data In: ORACLE - Param = 24, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
326     10:24:38  SQL Data In: ORACLE - Param = 25, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
327     10:24:38  SQL Data In: ORACLE - Param = 26, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
328     10:24:38  SQL Data In: ORACLE - Param = 27, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
329     10:24:38  SQL Data In: ORACLE - Param = 28, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
330     10:24:38  SQL Data In: ORACLE - Param = 29, Name = AS_GHRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
331     10:24:38  SQL Data In: ORACLE - Param = 30, Name = AS_SFYYGH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
332     10:24:38  SQL Data In: ORACLE - Param = 31, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
333     10:24:38  SQL Data In: ORACLE - Param = 32, Name = AS_SFSBLF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
334     10:24:38  SQL Data In: ORACLE - Param = 33, Name = AS_BRZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
335     10:24:38  SQL Data In: ORACLE - Param = 34, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
336     10:24:38  SQL Data In: ORACLE - Param = 35, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证
337     10:24:38  SQL Data In: ORACLE - Param = 36, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
338     10:24:38  SQL Data In: ORACLE - Param = 37, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
339     10:24:38  SQL Data In: ORACLE - Param = 38, Name = AS_SFNLYD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
340     10:24:38  SQL Data In: ORACLE - Param = 39, Name = AS_HZLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通
341     10:24:38  SQL Data In: ORACLE - Param = 40, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
342     10:24:38  SQL Data In: ORACLE - Param = 41, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
343     10:24:38  SQL Data In: ORACLE - Param = 42, Name = AD_FJJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
344     10:24:38  SQL Data In: ORACLE - Param = 43, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
345     10:24:38  SQL Data In: ORACLE - Param = 44, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
346     10:24:38  SQL Data In: ORACLE - Param = 45, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
347     10:24:38  SQL Data In: ORACLE - Param = 46, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
348     10:24:38  SQL Data In: ORACLE - Param = 47, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
349     10:24:38  SQL Data In: ORACLE - Param = 48, Name = AS_GHH000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 563005
350     10:24:38  SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
351     10:24:38  SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
352     10:24:38  SQL Data In: ORACLE - Param = 51, Name = AS_JZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
353     10:24:38  SQL Execute: ORACLE - BEGIN "SP_SF_BRGHXX" (AS_BRBLH0 => :AS_BRBLH0,AS_YBGHH0 => :AS_YBGHH0,AS_GHLBMC => :AS_GHLBMC,AD_BRID00 => :AD_BRID00,AS_SFCZ00 => :AS_SFCZ00,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AS_FBMC00 => :AS_FBMC00,AS_GFZH00 => :AS_GFZH00,AS_BRDH00 => :AS_BRDH00,AS_BRHYZK => :AS_BRHYZK,AD_GHY000 => :AD_GHY000,AS_GHYXM0 => :AS_GHYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_GHKS00 => :AD_GHKS00,AD_JZYS00 => :AD_JZYS00,AS_JZYSXM => :AS_JZYSXM,AD_GHHBID => :AD_GHHBID,AS_YJJXH0 => :AS_YJJXH0,AS_FPXH00 => :AS_FPXH00,AD_GHF000 => :AD_GHF000,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBID00 => :AS_YBID00,AS_YBKH00 => :AS_YBKH00,AS_GHRQ00 => :AS_GHRQ00,AS_SFYYGH => :AS_SFYYGH,AS_CZBZ00 => :AS_CZBZ00,AS_SFSBLF => :AS_SFSBLF,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_TYDWMC => :AS_TYDWMC,AS_SFNLYD => :AS_SFNLYD,AS_HZLB00 => :AS_HZLB00,AS_ICKH00 => :AS_ICKH00,AS_BRJTDZ => :AS_BRJTDZ,AD_FJJZDH => :AD_FJJZDH,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AS_GHH000 => :AS_GHH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JZSJ00 => :AS_JZSJ00); END;
354     10:24:38  SQL Prepare: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='563005' and HZZT00 in ('0','2','4')

355     10:24:38  SQL Execute: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='563005' and HZZT00 in ('0','2','4')

356     10:24:38  SQL Data In: ORACLE - Rows affected = 1
357     10:24:38  SQL Prepare: ORACLE - select ghid00,LBBH00,ZDFF00,ZLFA00 from SF_BRXXB0 where ghh000=:1

358     10:24:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 563005      
359     10:24:38  SQL Execute: ORACLE - select ghid00,LBBH00,ZDFF00,ZLFA00 from SF_BRXXB0 where ghh000=?

360     10:24:38  SQL Prepare: ORACLE - update YS_BRZDXX set GHID00=565973 WHERE GHID00=565972

361     10:24:38  SQL Execute: ORACLE - update YS_BRZDXX set GHID00=565973 WHERE GHID00=565972

362     10:24:38  SQL Data In: ORACLE - Rows affected = 1
363     10:24:38  SQL Prepare: ORACLE - update YS_BRBQB0 set GHID00=565973 WHERE GHID00=565972

364     10:24:38  SQL Execute: ORACLE - update YS_BRBQB0 set GHID00=565973 WHERE GHID00=565972

365     10:24:38  SQL Data In: ORACLE - Rows affected = 1
366     10:24:38  SQL Prepare: ORACLE - COMMIT

367     10:24:38  SQL Execute: ORACLE - COMMIT

368     10:24:38  SQL Data In: ORACLE - Rows affected = 0
369     10:24:38  SQL Prepare: ORACLE - Update sf_brxxb0 set THBZ00='2' where GHH000='563005'

370     10:24:38  SQL Execute: ORACLE - Update sf_brxxb0 set THBZ00='2' where GHH000='563005'

371     10:24:38  SQL Data In: ORACLE - Rows affected = 1
372     10:24:38  SQL Prepare: ORACLE - commit

373     10:24:38  SQL Execute: ORACLE - commit

374     10:24:38  SQL Data In: ORACLE - Rows affected = 0
375     10:24:38  SQL Prepare: ORACLE - commit

376     10:24:38  SQL Execute: ORACLE - commit

377     10:24:38  SQL Data In: ORACLE - Rows affected = 0
378     10:24:38  SQL Prepare: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC,
       a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0
from   YS_BRZDXX a, XT_ICD900 b 
where  a.ICD900=b.ICD900(+) and a.SFXYZD='1'
and a.GHID00=:1  order by zzdbz0


379     10:24:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 565973.000000
380     10:24:38  SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC,
       a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0
from   YS_BRZDXX a, XT_ICD900 b 
where  a.ICD900=b.ICD900(+) and a.SFXYZD='1'
and a.GHID00=?  order by zzdbz0


381     10:24:38  SQL Prepare: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC,
       JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD 
from   YS_BRZDXX 
where  SFXYZD='0'and GHID00=:1 order by zzdbz0


382     10:24:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 565973.000000
383     10:24:38  SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC,
       JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD 
from   YS_BRZDXX 
where  SFXYZD='0'and GHID00=? order by zzdbz0


384     10:24:38  SQL Prepare: ORACLE - SELECT BRBQID,  GHID00,  GHH000,  BRZS00,  SFCZ00,  SFHC00,  BS0000,
  TGJC00,  SYSJC0,  SZ0000,  ST0000,  MX0000,  TW0000,  XTCS00,
  HXCS00,  SZY000,  SSY000,  JZYS00,  SJYS00,  CZRQ00,  CZSJ00,
  JZYSXM,  ZS0000,  JZRQSJ,  ZDCLNR,  FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01
 FROM YS_BRBQB0 WHERE GHID00=:1
 

385     10:24:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 565973.000000
386     10:24:38  SQL Execute: ORACLE - SELECT BRBQID,  GHID00,  GHH000,  BRZS00,  SFCZ00,  SFHC00,  BS0000,
  TGJC00,  SYSJC0,  SZ0000,  ST0000,  MX0000,  TW0000,  XTCS00,
  HXCS00,  SZY000,  SSY000,  JZYS00,  SJYS00,  CZRQ00,  CZSJ00,
  JZYSXM,  ZS0000,  JZRQSJ,  ZDCLNR,  FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01
 FROM YS_BRBQB0 WHERE GHID00=?
 

387     10:24:38  SQL Prepare: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=183209)and GHID00<565973 and rownum=1
 Union all 
select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=183209)and GHID00>565973 and rownum=1

388     10:24:38  SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=183209)and GHID00<565973 and rownum=1
 Union all 
select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=183209)and GHID00>565973 and rownum=1

389     10:24:53  SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

390     10:24:53  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

391     10:24:53  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

392     10:24:53  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

393     10:24:58  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

394     10:24:58  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

395     10:24:58  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

396     10:24:58  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

397     10:24:59  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

398     10:24:59  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

399     10:24:59  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

400     10:24:59  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

401     10:25:01  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

402     10:25:01  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

403     10:25:01  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

404     10:25:01  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

405     10:25:01  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

406     10:25:01  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

407     10:25:01  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

408     10:25:01  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

409     10:25:02  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

410     10:25:02  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

411     10:25:02  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

412     10:25:02  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

413     10:25:03  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

414     10:25:03  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

415     10:25:03  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

416     10:25:03  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

417     10:25:04  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

418     10:25:04  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

419     10:25:04  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

420     10:25:04  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

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

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

423     10:25:10  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

424     10:25:10  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

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

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

427     10:25:10  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

428     10:25:10  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

429     10:25:11  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

430     10:25:11  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

431     10:25:11  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

432     10:25:11  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

433     10:25:12  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

434     10:25:12  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

435     10:25:12  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

436     10:25:12  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

437     10:25:13  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

438     10:25:13  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

439     10:25:13  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

440     10:25:13  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

441     10:25:18  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

442     10:25:18  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

443     10:25:18  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

444     10:25:18  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

445     10:25:19  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

446     10:25:19  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

447     10:25:19  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

448     10:25:19  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

449     10:25:20  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

450     10:25:20  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

451     10:25:20  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

452     10:25:20  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

453     10:25:21  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

454     10:25:21  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

455     10:25:21  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

456     10:25:21  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

457     10:25:21  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

458     10:25:21  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

459     10:25:21  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

460     10:25:21  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1

461     10:25:21  SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
 where ICKH00 = '0223583600031947'
 and ICKNBH = '0223583600031947'
 and ZT0000 = '1'

462     10:25:21  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
 where ICKH00 = '0223583600031947'
 and ICKNBH = '0223583600031947'
 and ZT0000 = '1'

463     10:25:21  SQL Prepare: ORACLE - SELECT a.*,b.bmmc00 "GHKSMC",lbmc00 GHLBMC FROM sf_brxxb0 a,bm_bmbm00 b ,bm_ghlbb0 c where a.ghks00=b.bmbh00 and a.ghlb00=c.lbbh00 and 
 BRID00='183209'
 and ghrq00 between '20100315' and '20100315'
 and  JzYs00=2484
 and THBZ00='2'

464     10:25:21  SQL Execute: ORACLE - SELECT a.*,b.bmmc00 "GHKSMC",lbmc00 GHLBMC FROM sf_brxxb0 a,bm_bmbm00 b ,bm_ghlbb0 c where a.ghks00=b.bmbh00 and a.ghlb00=c.lbbh00 and 
 BRID00='183209'
 and ghrq00 between '20100315' and '20100315'
 and  JzYs00=2484
 and THBZ00='2'

465     10:25:27  SQL Prepare: ORACLE - select count(1) from yf_mzcf00 a,yf_mzcfmx b where a.cflsh0=b.cflsh0 and GHH000='563005' and ((ypzsl0>0 and cfzt00 not in ('0','3','4')) or (ypzsl0<0 and cfzt00 not in ('3')) ) group by ypnm00 having sum(ypzsl0)>0

466     10:25:27  SQL Execute: ORACLE - select count(1) from yf_mzcf00 a,yf_mzcfmx b where a.cflsh0=b.cflsh0 and GHH000='563005' and ((ypzsl0>0 and cfzt00 not in ('0','3','4')) or (ypzsl0<0 and cfzt00 not in ('3')) ) group by ypnm00 having sum(ypzsl0)>0

467     10:25:27  SQL Prepare: ORACLE - select count(1) from yj_yw0000 where mzzybz='0' and ZYHGHH='563005' and ((sl0000>0 and xmzt00 not in ('0','1','6')) or (sl0000<0 and xmzt00 not in ('6')) ) group by zlxmid having sum(sl0000)>0

468     10:25:27  SQL Execute: ORACLE - select count(1) from yj_yw0000 where mzzybz='0' and ZYHGHH='563005' and ((sl0000>0 and xmzt00 not in ('0','1','6')) or (sl0000<0 and xmzt00 not in ('6')) ) group by zlxmid having sum(sl0000)>0

469     10:25:27  SQL Prepare: ORACLE - select count(*) from yj_yw0000 where mzzybz='0' and ZYHGHH='563005' and sl0000>0 and xmzt00 in ('0','1')

470     10:25:27  SQL Execute: ORACLE - select count(*) from yj_yw0000 where mzzybz='0' and ZYHGHH='563005' and sl0000>0 and xmzt00 in ('0','1')

471     10:25:27  SQL Prepare: ORACLE - select count(*) from yf_mzcf00 where GHH000='563005' and cfzje0>0 and cfzt00 in ('0','4')

472     10:25:27  SQL Execute: ORACLE - select count(*) from yf_mzcf00 where GHH000='563005' and cfzje0>0 and cfzt00 in ('0','4')

473     10:25:27  SQL Prepare: ORACLE - Update yj_yw0000 set xmzt00='6' where ZYHGHH='563005' and mzzybz='0' and sl0000>0 and xmzt00 in ('0','1') 

474     10:25:27  SQL Execute: ORACLE - Update yj_yw0000 set xmzt00='6' where ZYHGHH='563005' and mzzybz='0' and sl0000>0 and xmzt00 in ('0','1') 

475     10:25:27  SQL Data In: ORACLE - Rows affected = 0
476     10:25:27  SQL Prepare: ORACLE - Update yf_mzcf00 set cfzt00='3' where GHH000='563005' and cfzje0>0 and cfzt00 in ('0','4')

477     10:25:27  SQL Execute: ORACLE - Update yf_mzcf00 set cfzt00='3' where GHH000='563005' and cfzje0>0 and cfzt00 in ('0','4')

478     10:25:27  SQL Data In: ORACLE - Rows affected = 0
479     10:25:27  SQL Prepare: ORACLE - Update sf_brxxb0 set thBZ00='1' where GHH000='563005'

480     10:25:27  SQL Execute: ORACLE - Update sf_brxxb0 set thBZ00='1' where GHH000='563005'

481     10:25:27  SQL Data In: ORACLE - Rows affected = 1
482     10:25:27  SQL Prepare: ORACLE - Commit

483     10:25:27  SQL Execute: ORACLE - Commit

484     10:25:27  SQL Data In: ORACLE - Rows affected = 0
485     10:25:28  SQL Prepare: ORACLE - SELECT a.*,b.bmmc00 "GHKSMC",lbmc00 GHLBMC FROM sf_brxxb0 a,bm_bmbm00 b ,bm_ghlbb0 c where a.ghks00=b.bmbh00 and a.ghlb00=c.lbbh00 and 
 BRID00='183209'
 and ghrq00 between '20100315' and '20100315'
 and  JzYs00=2484
 and THBZ00='2'

486     10:25:28  SQL Execute: ORACLE - SELECT a.*,b.bmmc00 "GHKSMC",lbmc00 GHLBMC FROM sf_brxxb0 a,bm_bmbm00 b ,bm_ghlbb0 c where a.ghks00=b.bmbh00 and a.ghlb00=c.lbbh00 and 
 BRID00='183209'
 and ghrq00 between '20100315' and '20100315'
 and  JzYs00=2484
 and THBZ00='2'

487     10:25:45  SQL Prepare: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=:1 and ghksbh=:2

488     10:25:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
489     10:25:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
490     10:25:45  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

491     10:25:45  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

492     10:25:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2484
493     10:25:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 517
494     10:25:45  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?