1 14:13:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 2 14:13:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 20180352 3 14:13:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51123344.000000 4 14:13:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3292223.000000 5 14:13:30 SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0)HJJE00, nvl(sum(NVL(ZFJE00,0)),0)ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0)GFJE00,min(djh000) qsdjh0,max(djh000) zzdjh0 from zy_brfy00 where JZDH00+0 = 0 and JFLBID = ? and zyh000= ? and ZYID00 = ? and BRID00 = ? 6 14:13:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 7 14:13:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3292223.000000 8 14:13:30 SQL Execute: ORACLE - select * from zy_brzhxx where 1 = 1 and JFLBID = ? and BRID00 = ? 9 14:13:30 SQL Data In: ORACLE - Param = 1, Name = AS_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30224661.000000 10 14:13:30 SQL Data In: ORACLE - Param = 2, Name = AS_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30443890.000000 11 14:13:30 SQL Data In: ORACLE - Param = 3, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 12 14:13:30 SQL Data In: ORACLE - Param = 4, Name = AS_ZYH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180352 13 14:13:30 SQL Data In: ORACLE - Param = 5, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51123344.000000 14 14:13:30 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3292223.000000 15 14:13:30 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 16 14:13:30 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 施丽卿 17 14:13:30 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 18 14:13:30 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 19 14:13:30 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24597.710000 20 14:13:30 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 21 14:13:30 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 22 14:13:30 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24597.710000 23 14:13:30 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 24 14:13:30 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 25 14:13:30 SQL Data In: ORACLE - Param = 17, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 26 14:13:30 SQL Data In: ORACLE - Param = 18, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 27 14:13:30 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24597.710000 28 14:13:30 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2057.000000 29 14:13:30 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林淑新 30 14:13:30 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 674.000000 31 14:13:30 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 32 14:13:30 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00500776 33 14:13:30 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 34 14:13:30 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 35 14:13:30 SQL Data In: ORACLE - Param = 27, Name = AS_JFDJHS, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 0,30222830,0 36 14:13:30 SQL Data In: ORACLE - Param = 28, Name = AS_JSZZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20010709 37 14:13:30 SQL Data In: ORACLE - Param = 29, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 38 14:13:30 SQL Data In: ORACLE - Param = 30, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 39 14:13:30 SQL Data In: ORACLE - Param = 31, Name = AD_GZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 14:13:30 SQL Data In: ORACLE - Param = 32, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 41 14:13:30 SQL Data In: ORACLE - Param = 33, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 42 14:13:30 SQL Data In: ORACLE - Param = 34, Name = AD_XJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 43 14:13:30 SQL Data In: ORACLE - Param = 35, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 44 14:13:30 SQL Data In: ORACLE - Param = 36, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 14:13:30 SQL Data In: ORACLE - Param = 37, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 46 14:13:30 SQL Data In: ORACLE - Param = 38, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 47 14:13:30 SQL Data In: ORACLE - Param = 39, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 14:13:30 SQL Data In: ORACLE - Param = 40, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 49 14:13:30 SQL Data In: ORACLE - Param = 41, Name = AD_SBDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 50 14:13:30 SQL Data In: ORACLE - Param = 42, Name = AD_BJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 51 14:13:30 SQL Data In: ORACLE - Param = 43, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 52 14:13:30 SQL Data In: ORACLE - Param = 44, Name = ad_YYZFDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 53 14:13:30 SQL Data In: ORACLE - Param = 45, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 54 14:13:30 SQL Data In: ORACLE - Param = 46, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 55 14:13:30 SQL Data In: ORACLE - Param = 47, Name = ad_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部 56 14:13:30 SQL Data In: ORACLE - Param = 48, Name = ad_DBZBM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 57 14:13:30 SQL Data In: ORACLE - Param = 49, Name = ad_XFBXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 58 14:13:30 SQL Data In: ORACLE - Param = 50, Name = ad_XFBXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 59 14:13:30 SQL Data In: ORACLE - Param = 51, Name = ad_YBJKLX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 60 14:13:30 SQL Execute: ORACLE - BEGIN "SP_ZY_BRFY00_JS0000" (AS_QSDJH0 => :AS_QSDJH0,AS_ZZDJH0 => :AS_ZZDJH0,AS_YBDJH0 => :AS_YBDJH0,AS_ZYH000 => :AS_ZYH000,AD_ZYID00 => :AD_ZYID00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_JFDJHS => :AS_JFDJHS,AS_JSZZRQ => :AS_JSZZRQ,AS_TSBZBH => :AS_TSBZBH,AD_TJDJH0 => :AD_TJDJH0,AD_GZDJH0 => :AD_GZDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_XJDJH0 => :AD_XJDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AD_SBDJH0 => :AD_SBDJH0,AD_BJDJH0 => :AD_BJDJH0,AD_GWYDJH => :AD_GWYDJH,ad_YYZFDH => :ad_YYZFDH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_YEXM00 => :ad_YEXM00,ad_DBZBM0 => :ad_DBZBM0,ad_XFBXJE => :ad_XFBXJE,ad_XFBXID => :ad_XFBXID,ad_YBJKLX => :ad_YBJKLX); END; 61 14:13:35 SQL Execute: ORACLE - update bm_ybjs00 set jszt00='2' where brid00=3292223 and jszt00='1' and mzzybz='1' and trim(CZLBMC)='住院结算_住院收费_住院收费' 62 14:13:35 SQL Data In: ORACLE - Rows affected = 0 63 14:13:35 SQL Execute: ORACLE - COMMIT 64 14:13:35 SQL Data In: ORACLE - Rows affected = 0 65 14:13:35 SQL Data In: ORACLE - Param = 1, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2057.000000 66 14:13:35 SQL Data In: ORACLE - Param = 2, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林淑新 67 14:13:35 SQL Data In: ORACLE - Param = 3, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3292223.000000 68 14:13:35 SQL Data In: ORACLE - Param = 4, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 69 14:13:35 SQL Data In: ORACLE - Param = 5, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51123344.000000 70 14:13:35 SQL Data In: ORACLE - Param = 6, Name = AS_BRZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 71 14:13:35 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 72 14:13:35 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 73 14:13:35 SQL Execute: ORACLE - BEGIN "SP_ZY_YBCYDJ" (AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AD_ZYID00 => :AD_ZYID00,AS_BRZT00 => :AS_BRZT00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 74 14:13:55 Log started for: SQL Navigator for Oracle 75 14:14:17 Log started for: 住院收费管理系统 76 14:18:08 SQL Execute: ORACLE - COMMIT 77 14:18:08 SQL Data In: ORACLE - Rows affected = 0 78 14:18:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3292223.000000 79 14:18:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 80 14:18:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 81 14:18:08 SQL Execute: ORACLE - select SF_ZY_CHECKTTBR(?,?,?) FSLX00 from dual 82 14:18:08 SQL Execute: ORACLE - select * from zy_pjsyqk where pjh000=0 83 14:18:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 982605.000000 84 14:18:08 SQL Execute: ORACLE - select min(jzksrq) KSRQ,max(jzjsrq) JSRQ from VW_ZY_JZXX00 where jzdh00 =? 85 14:18:08 SQL Execute: ORACLE - select SUM(XMJE00) HSHJJE,jzdh00 from ZY_JZMX00 where JZDH00=982605 AND SFYLXM='N' group by jzdh00 86 14:18:08 SQL Execute: ORACLE - select FBBH00,BRID00 from ZY_JZB000 where JZDH00 =982605 87 14:18:08 SQL Execute: ORACLE - select * from VW_ZY_FP0000 where JZDH00 =982605 88 14:18:08 SQL Execute: ORACLE - select SF_ZY_YBFPJE(982605,1) XSNR00 from dual 89 14:18:08 SQL Execute: ORACLE - select SF_ZY_YBFPJE(982605,2) XSNR00 from dual 90 14:18:08 SQL Execute: ORACLE - select SF_ZY_YBFPJE(982605,7) XSNR00 from dual 91 14:18:08 SQL Execute: ORACLE - select sum(xmje00) hjje00 from ZY_JZMX00 where JZDH00=982605 AND SFYLXM='Y' 92 14:18:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51123344.000000 93 14:18:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 982605.000000 94 14:18:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 95 14:18:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24597.710000 96 14:18:08 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24597.710000 97 14:18:08 SQL Execute: ORACLE - select SF_ZY_FPHJJE(?,?,?,?,?)FHJG00 from dual 98 14:18:08 SQL Execute: ORACLE - select * from ZY_JZMX00 where SFYLXM='Y' AND JZDH00=982605 order by XMBH00 99 14:18:08 SQL Execute: ORACLE - select SF_ZY_YBFPJE(982605,4) XSNR00 from dual