1       15:25:06  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
2       15:25:06  SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=?

3       15:25:06  SQL Execute: ORACLE - select SF_SF_GetYYKSBM(29882,6491196,0) YYKSBM from dual

4       15:25:06  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
5       15:25:06  SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=?

6       15:25:06  SQL Execute: ORACLE - select SF_SF_GetYYKSBM(29882,6491196,1) YYKSBM from dual

7       15:25:06  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
8       15:25:06  SQL Execute: ORACLE -  select tyje01 from VW_SF_BRZHXX where brid00= ?

9       15:25:06  SQL Execute: ORACLE -  select  *  from  sf_brzhxx  where  1 = 1 
 and  JFLBID = 1
 and  BRID00 = 29882

10      15:25:06  SQL Execute: ORACLE - select * from  VW_SF_YJYW00 where   CXDJH0  is  null  and  SFDJH0+0 = 0 and XMZT00 = '1'
 and  BRID00 = 29882
 and  YJDJH0  not in ( 0 , 26041649 ) 
 and  GHH000 = '6491196'

11      15:25:06  SQL Execute: ORACLE -  select  SQ_SF_BRJFB0_DJH000.nextval  DJH000   from dual 

12      15:25:06  SQL Data In: ORACLE - Param = 1, Name = ad_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
13      15:25:06  SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41277492.000000
14      15:25:06  SQL Data In: ORACLE - Param = 3, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.800000
15      15:25:06  SQL Data In: ORACLE - Param = 4, Name = ad_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
16      15:25:06  SQL Data In: ORACLE - Param = 5, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
17      15:25:06  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
18      15:25:06  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
19      15:25:06  SQL Execute: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (ad_BRID00 => :ad_BRID00,AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,ad_JZJE00 => :ad_JZJE00,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
20      15:25:06  SQL Data In: ORACLE - Param = 1, Name = ad_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
21      15:25:06  SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41277493.000000
22      15:25:06  SQL Data In: ORACLE - Param = 3, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000
23      15:25:06  SQL Data In: ORACLE - Param = 4, Name = ad_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
24      15:25:06  SQL Data In: ORACLE - Param = 5, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
25      15:25:06  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
26      15:25:06  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
27      15:25:06  SQL Execute: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (ad_BRID00 => :ad_BRID00,AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,ad_JZJE00 => :ad_JZJE00,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
28      15:25:06  SQL Data In: ORACLE - Param = 1, Name = ad_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
29      15:25:06  SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41277494.000000
30      15:25:06  SQL Data In: ORACLE - Param = 3, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.750000
31      15:25:06  SQL Data In: ORACLE - Param = 4, Name = ad_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
32      15:25:06  SQL Data In: ORACLE - Param = 5, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
33      15:25:06  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
34      15:25:06  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
35      15:25:06  SQL Execute: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (ad_BRID00 => :ad_BRID00,AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,ad_JZJE00 => :ad_JZJE00,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
36      15:25:06  SQL Data In: ORACLE - Param = 1, Name = ad_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
37      15:25:06  SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41277495.000000
38      15:25:06  SQL Data In: ORACLE - Param = 3, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.320000
39      15:25:06  SQL Data In: ORACLE - Param = 4, Name = ad_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
40      15:25:06  SQL Data In: ORACLE - Param = 5, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
41      15:25:06  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
42      15:25:06  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
43      15:25:06  SQL Execute: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (ad_BRID00 => :ad_BRID00,AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,ad_JZJE00 => :ad_JZJE00,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
44      15:25:06  SQL Data In: ORACLE - Param = 1, Name = AD_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26041649.000000
45      15:25:06  SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 38227742.000000
46      15:25:06  SQL Data In: ORACLE - Param = 3, Name = AD_ZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
47      15:25:06  SQL Data In: ORACLE - Param = 4, Name = AD_ZXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 682.000000
48      15:25:06  SQL Data In: ORACLE - Param = 5, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
49      15:25:06  SQL Data In: ORACLE - Param = 6, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
50      15:25:06  SQL Execute: ORACLE - BEGIN "SP_SF_YJDJ00" (AD_YJDJH0 => :AD_YJDJH0,AD_DJH000 => :AD_DJH000,AD_ZXKS00 => :AD_ZXKS00,AD_ZXYS00 => :AD_ZXYS00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
51      15:25:06  SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
52      15:25:06  SQL Data In: ORACLE - Param = 2, Name = AS_MZH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6491196
53      15:25:06  SQL Data In: ORACLE - Param = 3, Name = AD_MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15640622.000000
54      15:25:06  SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金
55      15:25:06  SQL Data In: ORACLE - Param = 5, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
56      15:25:06  SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈建琳
57      15:25:06  SQL Data In: ORACLE - Param = 7, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
58      15:25:06  SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 676.000000
59      15:25:06  SQL Data In: ORACLE - Param = 9, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 吴克菲
60      15:25:06  SQL Data In: ORACLE - Param = 10, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51.000000
61      15:25:06  SQL Data In: ORACLE - Param = 11, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 38227742.000000
62      15:25:06  SQL Data In: ORACLE - Param = 12, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
63      15:25:06  SQL Data In: ORACLE - Param = 13, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
64      15:25:06  SQL Data In: ORACLE - Param = 14, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
65      15:25:06  SQL Data In: ORACLE - Param = 15, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
66      15:25:06  SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
67      15:25:06  SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
68      15:25:06  SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
69      15:25:06  SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where brid00=29882 and ZT0000='1' 

70      15:25:06  SQL Execute: ORACLE -  commit  

71      15:25:06  SQL Data In: ORACLE - Rows affected = 0
72      15:25:06  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29882.000000
73      15:25:06  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6491196     
74      15:25:06  SQL Execute: ORACLE -  select * from vw_sf_wjzcf a where a.BRID00 = ?
  and  A.GHH000 = ?