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

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

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

4       10:18:38  SQL Execute: ORACLE -  select * from  VW_ZY_BRXX00 a  where  1 = 1 

5       10:18:38  SQL Execute: ORACLE -  select * from  VW_ZY_BRXX00 a  where  1 = 1 
 and  a.BRXM00  like '陈金兰%'
 order by CZRQ00 

6       10:18:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 102854.000000
7       10:18:41  SQL Execute: ORACLE -  select  *  from  zy_brxxb0  where  brid00=?  and  cyrq00 is null 

8       10:18:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 102854.000000
9       10:18:41  SQL Execute: ORACLE - select  max(ZYID00) ZYID00  from  ZY_BRXXB0  where  BRID00 = ?

10      10:18:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 102854.000000
11      10:18:41  SQL Execute: ORACLE -  select B.BMMC00 BQMC00,C.BMMC00 KSMC00,A.CH0000,A.ZDMC00,a.ysgzh0,d.zwxm00,A.ZDM000  from  ys_brzysq A, bm_bmbm00 B,bm_bmbm00 C,bm_ygbm00 d 
 where A.BQH000 = B.BMBH00(+)  and A.KSH000 = C.BMBH00(+) and a.YSGZH0=d.ygbh00(+)  and A.BRID00 =? 
   and  jsbz00 = '0'

12      10:18:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
13      10:18:41  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 102854.000000
14      10:18:41  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
15      10:18:41  SQL Execute: ORACLE -  select SF_ZY_ZRZYFY(?,?,?)FHXX00 from dual

16      10:18:41  SQL Execute: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 8  and  PJSYR0 =14
 and  SYBZ00 = 'Y'

17      10:18:41  SQL Execute: ORACLE -   select  *   from    VW_BM_BRFBB0 

18      10:18:41  SQL Execute: ORACLE -  select MC0000 from BM_TYZD00 WHERE ZDMC00='入院途径' AND YXBZ00='1' order by BH0000 

19      10:18:41  SQL Execute: ORACLE -  select MC0000 from BM_TYZD00 WHERE ZDMC00='治疗类别' AND YXBZ00='1' order by XSXH00 

20      10:18:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000
21      10:18:41  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
22      10:18:41  SQL Execute: ORACLE -  select SF_ZY_YGXZZF(?,?)FHXX00 from dual

23      10:18:41  SQL Execute: ORACLE - select  *  from  VW_ZY_BQMC00  where BMXZ00 = '9' AND CZBZ00 <> '2'
 order  by  bh0000  

24      10:18:41  SQL Execute: ORACLE -  select  *  from  vw_zy_brjflb  where JFLBID <> 0 

25      10:18:41  SQL Execute: ORACLE -  select * from  vw_bm_brzffs  

26      10:18:41  SQL Execute: ORACLE - select *  from  BM_TYZD00 where   ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00)

27      10:18:41  SQL Execute: ORACLE -  select * from  VW_ZY_BRXX00  where  brid00 = 102854

28      10:18:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 352623195011275125
29      10:18:41  SQL Execute: ORACLE -  select SP_SF_CHECKSFZH(?)idcard from dual

30      10:18:41  SQL Execute: ORACLE -  select  max(ZYID00) ZYID00  from  ZY_BRXXB0 A where  brid00 =102854

31      10:18:41  SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = MRN000
32      10:18:41  SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
33      10:18:41  SQL Execute: ORACLE - BEGIN "SP_XT_SEQ000" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0); END;
34      10:18:41  SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000
35      10:18:41  SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
36      10:18:41  SQL Execute: ORACLE - BEGIN "SP_XT_SEQ000" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0); END;
37      10:18:41  SQL Execute: ORACLE - select * from  ZY_BRZHXX A,BM_BRJFLB B  where  A.JFLBID = B.JFLBID   and A.BRID00 =102854
  and  JFLBMC = '住院预交金'

38      10:18:41  SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000
39      10:18:41  SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 160107
40      10:18:41  SQL Data In: ORACLE - Param = 3, Name = P_FLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
41      10:18:41  SQL Execute: ORACLE - BEGIN "SP_XT_CANSEQ" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0,P_FLAG00 => :P_FLAG00); END;