1 14:47:42 SQL Execute: ORACLE - select sf_ys_ghxz00(14,160,95641) from dual 2 14:47:42 SQL Data In: ORACLE - Param = 1, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 05568 3 14:47:42 SQL Data In: ORACLE - Param = 2, Name = AS_YBGHH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 4 14:47:42 SQL Data In: ORACLE - Param = 3, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 主任医师 5 14:47:42 SQL Data In: ORACLE - Param = 4, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 95641.000000 6 14:47:42 SQL Data In: ORACLE - Param = 5, Name = AS_SFCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 7 14:47:42 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈涵婧 8 14:47:42 SQL Data In: ORACLE - Param = 7, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 9 14:47:42 SQL Data In: ORACLE - Param = 8, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20020116 10 14:47:42 SQL Data In: ORACLE - Param = 9, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 11 14:47:42 SQL Data In: ORACLE - Param = 10, Name = AS_GFZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 12 14:47:42 SQL Data In: ORACLE - Param = 11, Name = AS_BRDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 13 14:47:42 SQL Data In: ORACLE - Param = 12, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 14 14:47:42 SQL Data In: ORACLE - Param = 13, Name = AD_GHY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 160.000000 15 14:47:42 SQL Data In: ORACLE - Param = 14, Name = AS_GHYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 游曦闽 16 14:47:42 SQL Data In: ORACLE - Param = 15, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 17 14:47:42 SQL Data In: ORACLE - Param = 16, Name = AD_GHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 18 14:47:42 SQL Data In: ORACLE - Param = 17, Name = AD_JZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 160.000000 19 14:47:42 SQL Data In: ORACLE - Param = 18, Name = AS_JZYSXM, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 游曦闽 20 14:47:42 SQL Data In: ORACLE - Param = 19, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 21 14:47:42 SQL Data In: ORACLE - Param = 20, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 22 14:47:42 SQL Data In: ORACLE - Param = 21, Name = AS_FPXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 23 14:47:42 SQL Data In: ORACLE - Param = 22, Name = AD_GHF000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.300000 24 14:47:42 SQL Data In: ORACLE - Param = 23, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 25 14:47:42 SQL Data In: ORACLE - Param = 24, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 26 14:47:42 SQL Data In: ORACLE - Param = 25, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.300000 27 14:47:42 SQL Data In: ORACLE - Param = 26, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 14:47:42 SQL Data In: ORACLE - Param = 27, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 29 14:47:42 SQL Data In: ORACLE - Param = 28, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 30 14:47:42 SQL Data In: ORACLE - Param = 29, Name = AS_GHRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 31 14:47:42 SQL Data In: ORACLE - Param = 30, Name = AS_SFYYGH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 32 14:47:42 SQL Data In: ORACLE - Param = 31, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 33 14:47:42 SQL Data In: ORACLE - Param = 32, Name = AS_SFSBLF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 34 14:47:42 SQL Data In: ORACLE - Param = 33, Name = AS_BRZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 35 14:47:42 SQL Data In: ORACLE - Param = 34, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 36 14:47:42 SQL Data In: ORACLE - Param = 35, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 37 14:47:42 SQL Data In: ORACLE - Param = 36, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 38 14:47:42 SQL Data In: ORACLE - Param = 37, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 39 14:47:42 SQL Data In: ORACLE - Param = 38, Name = AS_SFNLYD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 40 14:47:42 SQL Data In: ORACLE - Param = 39, Name = AS_HZLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 41 14:47:42 SQL Data In: ORACLE - Param = 40, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 42 14:47:42 SQL Data In: ORACLE - Param = 41, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 43 14:47:42 SQL Data In: ORACLE - Param = 42, Name = AD_FJJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 44 14:47:42 SQL Data In: ORACLE - Param = 43, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 14:47:42 SQL Data In: ORACLE - Param = 44, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 46 14:47:42 SQL Data In: ORACLE - Param = 45, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 47 14:47:42 SQL Data In: ORACLE - Param = 46, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 14:47:42 SQL Data In: ORACLE - Param = 47, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 49 14:47:42 SQL Data In: ORACLE - Param = 48, Name = AS_GHH000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 50 14:47:42 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 51 14:47:42 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 52 14:47:42 SQL Data In: ORACLE - Param = 51, Name = AS_JZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 53 14:47:42 SQL Data In: ORACLE - Param = 52, Name = AS_ZSQGFF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 54 14:47:42 SQL Data In: ORACLE - Param = 53, Name = as_SFZJDK, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 55 14:47:42 SQL Data In: ORACLE - Param = 54, Name = as_SFZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 56 14:47:42 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,AS_ZSQGFF => :AS_ZSQGFF,as_SFZJDK => :as_SFZJDK,as_SFZZ00 => :as_SFZZ00); END; 57 14:47:42 SQL Execute: ORACLE - update SF_HZBR00 set HZZT00='3',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='1437019' 58 14:47:42 SQL Data In: ORACLE - Rows affected = 1 59 14:47:42 SQL Execute: ORACLE - commit 60 14:47:42 SQL Data In: ORACLE - Rows affected = 0 61 14:47:42 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 95641.000000 62 14:47:42 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 63 14:47:42 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 64 14:47:42 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 65 14:47:42 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 66 14:47:42 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 67 14:47:42 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 68 14:47:42 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 69 14:47:42 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 70 14:47:42 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 71 14:47:42 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 72 14:47:42 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 73 14:47:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 95641 74 14:47:47 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 75 14:47:47 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 95641.000000 76 14:47:47 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 77 14:47:47 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 78 14:47:47 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 79 14:47:47 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 80 14:47:47 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 81 14:47:47 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 82 14:47:47 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 83 14:47:47 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 84 14:47:47 SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 85 14:47:47 SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 86 14:47:47 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 87 14:47:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 14 88 14:47:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 160 89 14:47:47 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and jzys00=? and dlxh00>0 and HZZT00='0' order by dlxh00 90 14:47:47 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1611034.000000 91 14:47:47 SQL Data In: ORACLE - Param = 2, Name = PJZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 160.000000 92 14:47:47 SQL Data In: ORACLE - Param = 3, Name = PJZKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 93 14:47:47 SQL Data In: ORACLE - Param = 4, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 94 14:47:47 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 160.000000 95 14:47:47 SQL Data In: ORACLE - Param = 6, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 96 14:47:47 SQL Data In: ORACLE - Param = 7, Name = PZXBZ00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 97 14:47:47 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 98 14:47:47 SQL Data In: ORACLE - Param = 9, Name = PGHHZCK, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 99 14:47:47 SQL Execute: ORACLE - BEGIN "SP_YS_CZJZCL" (PID0000 => :PID0000,PJZYS00 => :PJZYS00,PJZKS00 => :PJZKS00,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT,PGHHZCK => :PGHHZCK); END; 100 14:48:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 160 101 14:48:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 14 102 14:48:04 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 103 14:48:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 160 104 14:48:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 14 105 14:48:04 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 106 14:59:15 Log started for: 门诊护士工作站