1 10:28:39 Log started for: 门诊挂号收费管理系统 2 10:28:41 SQL Execute: ORACLE - rollback 3 10:28:41 SQL Data In: ORACLE - Rows affected = 0 4 10:28:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 5 10:28:41 SQL Execute: ORACLE - select * from ic_ybbrlb where YBMC00 = ? 6 10:28:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 7 10:28:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 学生证 8 10:28:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121 9 10:28:41 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 123111112221 10 10:28:41 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 11 10:28:41 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 12 10:28:41 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 13 10:28:41 SQL Execute: ORACLE - select SF_SF_BRSFZJY(?,?,?,?,?,?,?) BRZJBH from dual 14 10:28:41 SQL Execute: ORACLE - select count(*) from ZY_BRXXB0 where BRID00=1673769 and CYRQ00 is null 15 10:28:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1989 16 10:28:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 17 10:28:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 18 10:28:41 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 19 10:28:41 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 1989,0,0,0 20 10:28:41 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 21 10:28:41 SQL Execute: ORACLE - select SF_SF_BRDZBM(?,?,?,?,?,?) FSDYLX from dual 22 10:28:41 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1673769.000000 23 10:28:41 SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 24 10:28:41 SQL Data In: ORACLE - Param = 3, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = *285631 25 10:28:41 SQL Data In: ORACLE - Param = 4, Name = AS_BRGFZH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 26 10:28:41 SQL Data In: ORACLE - Param = 5, Name = AS_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试12 27 10:28:41 SQL Data In: ORACLE - Param = 6, Name = AS_BRXB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 28 10:28:41 SQL Data In: ORACLE - Param = 7, Name = AS_BRXX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 29 10:28:41 SQL Data In: ORACLE - Param = 8, Name = AS_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19980329 30 10:28:41 SQL Data In: ORACLE - Param = 9, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 31 10:28:41 SQL Data In: ORACLE - Param = 10, Name = AS_BRZY00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 国家公务员 32 10:28:41 SQL Data In: ORACLE - Param = 11, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 汉族 33 10:28:41 SQL Data In: ORACLE - Param = 12, Name = AS_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 中国 34 10:28:41 SQL Data In: ORACLE - Param = 13, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 学生证 35 10:28:41 SQL Data In: ORACLE - Param = 14, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121 36 10:28:41 SQL Data In: ORACLE - Param = 15, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 37 10:28:41 SQL Data In: ORACLE - Param = 16, Name = AS_BRDYFW, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本市 38 10:28:41 SQL Data In: ORACLE - Param = 17, Name = AS_BRDH00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 123111112221 39 10:28:41 SQL Data In: ORACLE - Param = 18, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 福建省 40 10:28:41 SQL Data In: ORACLE - Param = 19, Name = AS_BRYB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 41 10:28:41 SQL Data In: ORACLE - Param = 20, Name = AS_BRYB01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 42 10:28:41 SQL Data In: ORACLE - Param = 21, Name = AD_TYDWID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 43 10:28:41 SQL Data In: ORACLE - Param = 22, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 44 10:28:41 SQL Data In: ORACLE - Param = 23, Name = AS_BRLXGX, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本人 45 10:28:41 SQL Data In: ORACLE - Param = 24, Name = AS_BRLXXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 46 10:28:41 SQL Data In: ORACLE - Param = 25, Name = AS_BRLXDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 47 10:28:41 SQL Data In: ORACLE - Param = 26, Name = AS_BRLXDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 48 10:28:41 SQL Data In: ORACLE - Param = 27, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 在职 49 10:28:41 SQL Data In: ORACLE - Param = 28, Name = AS_BRJKQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 50 10:28:41 SQL Data In: ORACLE - Param = 29, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000 51 10:28:41 SQL Data In: ORACLE - Param = 30, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 52 10:28:41 SQL Data In: ORACLE - Param = 31, Name = AS_BRLX00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 复诊 53 10:28:41 SQL Data In: ORACLE - Param = 32, Name = AS_YBICKH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 54 10:28:41 SQL Data In: ORACLE - Param = 33, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 55 10:28:41 SQL Data In: ORACLE - Param = 34, Name = AS_YBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 56 10:28:41 SQL Data In: ORACLE - Param = 35, Name = AS_SFMZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 57 10:28:41 SQL Data In: ORACLE - Param = 36, Name = AD_SFYD00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 58 10:28:41 SQL Data In: ORACLE - Param = 37, Name = AS_SFYXJB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 59 10:28:41 SQL Data In: ORACLE - Param = 38, Name = AS_BRSZSF, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 福建省 60 10:28:41 SQL Data In: ORACLE - Param = 39, Name = AS_BRSZS0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 61 10:28:41 SQL Data In: ORACLE - Param = 40, Name = AS_BRSZZ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 62 10:28:41 SQL Data In: ORACLE - Param = 41, Name = AS_BRSZC0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 63 10:28:41 SQL Data In: ORACLE - Param = 42, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 64 10:28:41 SQL Data In: ORACLE - Param = 43, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 65 10:28:41 SQL Data In: ORACLE - Param = 44, Name = AS_TSSXMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 66 10:28:41 SQL Data In: ORACLE - Param = 45, Name = as_SFSY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 67 10:28:41 SQL Data In: ORACLE - Param = 46, Name = as_JG0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 68 10:28:41 SQL Data In: ORACLE - Param = 47, Name = as_SFBJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 69 10:28:41 SQL Data In: ORACLE - Param = 48, Name = as_SFBYZG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 70 10:28:41 SQL Data In: ORACLE - Param = 49, Name = as_HZDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 71 10:28:41 SQL Data In: ORACLE - Param = 50, Name = as_BRDZBM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 72 10:28:41 SQL Data In: ORACLE - Param = 51, Name = as_SFGHXZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 73 10:28:41 SQL Data In: ORACLE - Param = 52, Name = as_SFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 74 10:28:41 SQL Data In: ORACLE - Param = 53, Name = as_ZYFL00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 75 10:28:41 SQL Data In: ORACLE - Param = 54, Name = as_ZYZFL0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 76 10:28:41 SQL Data In: ORACLE - Param = 55, Name = as_SFYLJZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 77 10:28:41 SQL Data In: ORACLE - Param = 56, Name = as_BRSZX0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 78 10:28:41 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,as_BRSZX0 => :as_BRSZX0); END; 79 10:28:43 SQL Execute: ORACLE - rollback 80 10:28:43 SQL Data In: ORACLE - Rows affected = 0