1       09:28:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 24, Scale = 0, Data = 莆田市医管中心涵江管理部
2       09:28:02  SQL Execute: ORACLE -   select  *  from  ic_ybbrlb  where  YBMC00 = ?

3       09:28:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
4       09:28:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证
5       09:28:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35030320030828003X
6       09:28:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 13859858623
7       09:28:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 13859858623
8       09:28:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
9       09:28:02  SQL Execute: ORACLE -  select SF_SF_BRSFZJY(?,?,?,?,?,?) BRZJBH from dual

10      09:28:02  SQL Execute: ORACLE - select count(*) from ZY_BRXXB0 where BRID00=808382 and CYRQ00 is null 

11      09:28:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 35
12      09:28:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3503
13      09:28:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
14      09:28:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
15      09:28:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 35,3503,0,0
16      09:28:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
17      09:28:02  SQL Execute: ORACLE - select SF_SF_BRDZBM(?,?,?,?,?,?) FSDYLX from dual 

18      09:28:02  SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
19      09:28:02  SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
20      09:28:02  SQL Data In: ORACLE - Param = 3, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = *838666
21      09:28:02  SQL Data In: ORACLE - Param = 4, Name = AS_BRGFZH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
22      09:28:02  SQL Data In: ORACLE - Param = 5, Name = AS_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 李盘庚
23      09:28:02  SQL Data In: ORACLE - Param = 6, Name = AS_BRXB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
24      09:28:02  SQL Data In: ORACLE - Param = 7, Name = AS_BRXX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
25      09:28:02  SQL Data In: ORACLE - Param = 8, Name = AS_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20030828
26      09:28:02  SQL Data In: ORACLE - Param = 9, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
27      09:28:02  SQL Data In: ORACLE - Param = 10, Name = AS_BRZY00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 个体
28      09:28:02  SQL Data In: ORACLE - Param = 11, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 汉族
29      09:28:02  SQL Data In: ORACLE - Param = 12, Name = AS_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 中国
30      09:28:02  SQL Data In: ORACLE - Param = 13, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证
31      09:28:02  SQL Data In: ORACLE - Param = 14, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35030320030828003X
32      09:28:02  SQL Data In: ORACLE - Param = 15, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 医保
33      09:28:02  SQL Data In: ORACLE - Param = 16, Name = AS_BRDYFW, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 涵江区(居民)
34      09:28:02  SQL Data In: ORACLE - Param = 17, Name = AS_BRDH00, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 13859858623
35      09:28:02  SQL Data In: ORACLE - Param = 18, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 福建省莆田市涵江区涵东街道
36      09:28:02  SQL Data In: ORACLE - Param = 19, Name = AS_BRYB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
37      09:28:02  SQL Data In: ORACLE - Param = 20, Name = AS_BRYB01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
38      09:28:02  SQL Data In: ORACLE - Param = 21, Name = AD_TYDWID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
39      09:28:02  SQL Data In: ORACLE - Param = 22, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 涵江区残联
40      09:28:02  SQL Data In: ORACLE - Param = 23, Name = AS_BRLXGX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
41      09:28:02  SQL Data In: ORACLE - Param = 24, Name = AS_BRLXXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
42      09:28:02  SQL Data In: ORACLE - Param = 25, Name = AS_BRLXDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
43      09:28:02  SQL Data In: ORACLE - Param = 26, Name = AS_BRLXDH, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 13859858623
44      09:28:02  SQL Data In: ORACLE - Param = 27, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 城乡居民
45      09:28:02  SQL Data In: ORACLE - Param = 28, Name = AS_BRJKQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
46      09:28:02  SQL Data In: ORACLE - Param = 29, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
47      09:28:02  SQL Data In: ORACLE - Param = 30, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
48      09:28:02  SQL Data In: ORACLE - Param = 31, Name = AS_BRLX00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 复诊
49      09:28:02  SQL Data In: ORACLE - Param = 32, Name = AS_YBICKH, Type = fldZSTRING, Precision = 9, Scale = 0, Data = B42465340
50      09:28:02  SQL Data In: ORACLE - Param = 33, Name = AS_YBID00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35030320030828003X
51      09:28:02  SQL Data In: ORACLE - Param = 34, Name = AS_YBLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 12
52      09:28:02  SQL Data In: ORACLE - Param = 35, Name = AS_SFMZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
53      09:28:02  SQL Data In: ORACLE - Param = 36, Name = AD_SFYD00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
54      09:28:02  SQL Data In: ORACLE - Param = 37, Name = AS_SFYXJB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
55      09:28:02  SQL Data In: ORACLE - Param = 38, Name = AS_BRSZSF, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 福建省
56      09:28:02  SQL Data In: ORACLE - Param = 39, Name = AS_BRSZS0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 莆田市
57      09:28:02  SQL Data In: ORACLE - Param = 40, Name = AS_BRSZZ0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 涵江区
58      09:28:02  SQL Data In: ORACLE - Param = 41, Name = AS_BRSZC0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 涵东街道
59      09:28:02  SQL Data In: ORACLE - Param = 42, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
60      09:28:02  SQL Data In: ORACLE - Param = 43, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
61      09:28:02  SQL Data In: ORACLE - Param = 44, Name = AS_TSSXMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通
62      09:28:02  SQL Data In: ORACLE - Param = 45, Name = as_SFSY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
63      09:28:02  SQL Data In: ORACLE - Param = 46, Name = as_JG0000, Type = fldZSTRING, Precision = 13, Scale = 0, Data = 1433110181450
64      09:28:02  SQL Data In: ORACLE - Param = 47, Name = as_SFBJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
65      09:28:02  SQL Data In: ORACLE - Param = 48, Name = as_SFBYZG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
66      09:28:02  SQL Data In: ORACLE - Param = 49, Name = as_HZDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
67      09:28:02  SQL Data In: ORACLE - Param = 50, Name = as_BRDZBM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
68      09:28:02  SQL Data In: ORACLE - Param = 51, Name = as_SFGHXZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
69      09:28:02  SQL Data In: ORACLE - Param = 52, Name = as_SFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
70      09:28:02  SQL Data In: ORACLE - Param = 53, Name = as_ZYFL00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 7其他人群
71      09:28:02  SQL Data In: ORACLE - Param = 54, Name = as_ZYZFL0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
72      09:28:02  SQL Data In: ORACLE - Param = 55, Name = as_SFYLJZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
73      09:28:02  SQL Execute: ORACLE - BEGIN "SP_SF_BRXXB0_EDIT00" (AD_BRID00 => :AD_BRID00,AS_MRN000 => :AS_MRN000,AS_BRBLH0 => :AS_BRBLH0,AS_BRGFZH => :AS_BRGFZH,AS_BRXM00 => :AS_BRXM00,AS_BRXB00 => :AS_BRXB00,AS_BRXX00 => :AS_BRXX00,AS_BRCSRQ => :AS_BRCSRQ,AS_BRHYZK => :AS_BRHYZK,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRGJ00 => :AS_BRGJ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_FBMC00 => :AS_FBMC00,AS_BRDYFW => :AS_BRDYFW,AS_BRDH00 => :AS_BRDH00,AS_BRJTDZ => :AS_BRJTDZ,AS_BRYB00 => :AS_BRYB00,AS_BRYB01 => :AS_BRYB01,AD_TYDWID => :AD_TYDWID,AS_TYDWMC => :AS_TYDWMC,AS_BRLXGX => :AS_BRLXGX,AS_BRLXXM => :AS_BRLXXM,AS_BRLXDZ => :AS_BRLXDZ,AS_BRLXDH => :AS_BRLXDH,AS_BRZTQK => :AS_BRZTQK,AS_BRJKQK => :AS_BRJKQK,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_BRLX00 => :AS_BRLX00,AS_YBICKH => :AS_YBICKH,AS_YBID00 => :AS_YBID00,AS_YBLB00 => :AS_YBLB00,AS_SFMZ00 => :AS_SFMZ00,AD_SFYD00 => :AD_SFYD00,AS_SFYXJB => :AS_SFYXJB,AS_BRSZSF => :AS_BRSZSF,AS_BRSZS0 => :AS_BRSZS0,AS_BRSZZ0 => :AS_BRSZZ0,AS_BRSZC0 => :AS_BRSZC0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_TSSXMC => :AS_TSSXMC,as_SFSY00 => :as_SFSY00,as_JG0000 => :as_JG0000,as_SFBJ00 => :as_SFBJ00,as_SFBYZG => :as_SFBYZG,as_HZDWMC => :as_HZDWMC,as_BRDZBM => :as_BRDZBM,as_SFGHXZ => :as_SFGHXZ,as_SFJZFP => :as_SFJZFP,as_ZYFL00 => :as_ZYFL00,as_ZYZFL0 => :as_ZYZFL0,as_SFYLJZ => :as_SFYLJZ); END;
74      09:28:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
75      09:28:02  SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00= ? and ZT0000='1'

76      09:28:02  SQL Execute: ORACLE - select ICKH00,BRID00 from VW_IC_SMBTDJ where ICKH00='PTYBB42465340'

77      09:28:02  SQL Execute: ORACLE - select * from VW_IC_SMBTDJ where BRID00=808382

78      09:29:12  SQL Execute: ORACLE - update IC_YHXX00 set SCBZ00='4' where ICKH00='PTYBB42465340'

79      09:29:12  SQL Data In: ORACLE - Rows affected = 1
80      09:29:12  SQL Execute: ORACLE - Commit

81      09:29:12  SQL Data In: ORACLE - Rows affected = 0
82      09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
83      09:29:12  SQL Execute: ORACLE -  select SF_SF_ICKH00(?)FHJG00 from dual

84      09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB42465340
85      09:29:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2002
86      09:29:12  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
87      09:29:12  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual

88      09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
89      09:29:12  SQL Execute: ORACLE -  select SF_SF_ICKH00(?)FHJG00 from dual

90      09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB42465340
91      09:29:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5001
92      09:29:12  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
93      09:29:12  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual

94      09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
95      09:29:12  SQL Execute: ORACLE -  select SF_SF_ICKH00(?)FHJG00 from dual

96      09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
97      09:29:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen
98      09:29:12  SQL Execute: ORACLE -  select SF_SF_TYZD00(?,?)FHJG00 from dual

99      09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB42465340
100     09:29:12  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

101     09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
102     09:29:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
103     09:29:12  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

104     09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB42465340
105     09:29:12  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

106     09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
107     09:29:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
108     09:29:12  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

109     09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB42465340
110     09:29:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000
111     09:29:12  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
112     09:29:12  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual

113     09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB42465340
114     09:29:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001
115     09:29:12  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
116     09:29:12  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual

117     09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
118     09:29:12  SQL Execute: ORACLE -  select *  from BM_BRZPXX where brid00 = ?

119     09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 808382.000000
120     09:29:12  SQL Execute: ORACLE -  select SF_SF_ICKH00(?)FHJG00 from dual

121     09:29:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数
122     09:29:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT
123     09:29:12  SQL Execute: ORACLE -  select SF_SF_TYZD00(?,?)FHJG00 from dual

124     09:29:12  SQL Execute: ORACLE - Commit

125     09:29:12  SQL Data In: ORACLE - Rows affected = 0
126     09:29:12  SQL Execute: ORACLE -  select TXNR00 from BM_HMDML0 where SFZH00='35030320030828003X'