1 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 2 11:50:30 SQL Execute: ORACLE - select SF_ZY_SFQYDBZJK(?)SFQYBZ FROM dual 3 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 4 11:50:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = BZFZ00160 5 11:50:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 6 11:50:30 SQL Execute: ORACLE - select SF_ZY_DBZJE00(?,?,?) DBZJE0 FROM dual 7 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 8 11:50:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 9 11:50:30 SQL Execute: ORACLE - select SF_ZY_FSDYLX(?,?) FHLX00 from dual 10 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 11 11:50:30 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 3 and PJSYR0 = ? and SYBZ00 = 'Y' 12 11:50:30 SQL Execute: ORACLE - select SF_ZY_SFXYYBSP(1619823) from dual 13 11:50:30 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual 14 11:50:30 SQL Execute: ORACLE - select (select VALUE0 from XT_XTCS00 where NAME00='ZY_DBZJKQYSQM') VALUE0,SF_BM_SQXQTSXX('ZY_DBZJKQYSQM','0',1143,'326849430') TSXX00 from dual 15 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 16 11:50:30 SQL Execute: ORACLE - select count(*) NUM from zy_brxxb0 where ZYID00=? and BRZT00 = '3' 17 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 18 11:50:30 SQL Execute: ORACLE - select count(*) NUM from yf_zycf00 where BCCFH0 is null and ZYID00=? and CFZT00 = '0' 19 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 20 11:50:30 SQL Execute: ORACLE - select count(*) NUM from yf_zycf00 where ZYID00=? and CFZT00='1' and SFKSLY='N' 21 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 22 11:50:30 SQL Execute: ORACLE - select count(*) NUM from VW_ZY_YJYW00 where cxdjh0 is null and ZYID00=? and ZJE000<>0 23 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 24 11:50:30 SQL Execute: ORACLE - select count(*) NUM from YF_YZYPSQ where ZYID00 =? and QLZT00='0' and CXBZ00 = 'Z' 25 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 26 11:50:30 SQL Execute: ORACLE - select sum(hjje00) NUM from zy_brfy00 where ZYID00=? 27 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 28 11:50:30 SQL Execute: ORACLE - select count(*) NUM from ZY_BRZHXX where BRID00 =? and SFDJ00 <> '2' and JFLBID <> 0 29 11:50:30 SQL Execute: ORACLE - select SF_ZY_BRRYLBXX('2','1619823') RYLB00 from dual 30 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 出院结算 31 11:50:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 32 11:50:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 33 11:50:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 40595501 34 11:50:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20010709 35 11:50:30 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 36 11:50:30 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 37 11:50:30 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部 38 11:50:30 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = BZFZ00160 39 11:50:30 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 40 11:50:30 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 41 11:50:30 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3800.000000 42 11:50:30 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2440.660000 43 11:50:30 SQL Execute: ORACLE - select SF_ZY_CHECK_CYJSDATA(?,?,?,?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 44 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 40595501 45 11:50:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 46 11:50:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 47 11:50:30 SQL Execute: ORACLE - select SF_ZY_ZRZYFY(?,?,?)FHXX00 from dual 48 11:50:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 49 11:50:30 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 50 11:50:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 51 11:50:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 40595501 52 11:50:33 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 53 11:50:33 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 54 11:50:33 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 = ? 55 11:50:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 56 11:50:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 57 11:50:33 SQL Execute: ORACLE - select * from zy_brzhxx where 1 = 1 and JFLBID = ? and BRID00 = ? 58 11:50:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 59 11:50:33 SQL Execute: ORACLE - select * from ZY_BRJFB0 A where A.JZDH00+0 = 0 and JFLBID = 2 and A.BRID00 =? and A.JFBZ00 <> '2' 60 11:50:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 61 11:50:33 SQL Execute: ORACLE - select A.*, B.PJXH00 from ZY_BRJFB0 A, ZY_PJSYQK B where A.PJH000 = B.PJH000 and B.PLBH00 in (4,8) and A.JZDH00+0 = 0 and JFLBID = 2 and A.BRID00 =? and A.JFBZ00 <> '2' 62 11:50:34 SQL Misc: ORACLE - Set stored procedure on or off 63 11:50:34 SQL Data In: ORACLE - Param = 1, Name = AS_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31276173.000000 64 11:50:34 SQL Data In: ORACLE - Param = 2, Name = AS_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31276190.000000 65 11:50:34 SQL Data In: ORACLE - Param = 3, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 66 11:50:34 SQL Data In: ORACLE - Param = 4, Name = AS_ZYH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 40595501 67 11:50:34 SQL Data In: ORACLE - Param = 5, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 68 11:50:34 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 69 11:50:34 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 70 11:50:34 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 0320测试 71 11:50:34 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 72 11:50:34 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 73 11:50:34 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2440.660000 74 11:50:34 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 75 11:50:34 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 76 11:50:34 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2440.660000 77 11:50:34 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 78 11:50:34 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 79 11:50:34 SQL Data In: ORACLE - Param = 17, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 80 11:50:34 SQL Data In: ORACLE - Param = 18, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 81 11:50:34 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2440.660000 82 11:50:34 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 83 11:50:34 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 陈强 84 11:50:34 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 85 11:50:34 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 86 11:50:34 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 87 11:50:34 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 88 11:50:34 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 89 11:50:34 SQL Data In: ORACLE - Param = 27, Name = AS_JFDJHS, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 0,31276171,0 90 11:50:34 SQL Data In: ORACLE - Param = 28, Name = AS_JSZZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20010709 91 11:50:34 SQL Data In: ORACLE - Param = 29, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 92 11:50:34 SQL Data In: ORACLE - Param = 30, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 93 11:50:34 SQL Data In: ORACLE - Param = 31, Name = AD_GZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 94 11:50:34 SQL Data In: ORACLE - Param = 32, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 95 11:50:34 SQL Data In: ORACLE - Param = 33, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 96 11:50:34 SQL Data In: ORACLE - Param = 34, Name = AD_XJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 97 11:50:34 SQL Data In: ORACLE - Param = 35, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 98 11:50:34 SQL Data In: ORACLE - Param = 36, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 99 11:50:34 SQL Data In: ORACLE - Param = 37, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 100 11:50:34 SQL Data In: ORACLE - Param = 38, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 101 11:50:34 SQL Data In: ORACLE - Param = 39, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 102 11:50:34 SQL Data In: ORACLE - Param = 40, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 103 11:50:34 SQL Data In: ORACLE - Param = 41, Name = AD_SBDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 104 11:50:34 SQL Data In: ORACLE - Param = 42, Name = AD_BJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 105 11:50:34 SQL Data In: ORACLE - Param = 43, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 106 11:50:34 SQL Data In: ORACLE - Param = 44, Name = ad_YYZFDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 107 11:50:34 SQL Data In: ORACLE - Param = 45, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 108 11:50:34 SQL Data In: ORACLE - Param = 46, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 109 11:50:34 SQL Data In: ORACLE - Param = 47, Name = ad_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部 110 11:50:34 SQL Data In: ORACLE - Param = 48, Name = ad_DBZBM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 111 11:50:34 SQL Data In: ORACLE - Param = 49, Name = ad_XFBXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 112 11:50:34 SQL Data In: ORACLE - Param = 50, Name = ad_XFBXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 113 11:50:34 SQL Data In: ORACLE - Param = 51, Name = ad_YBJKLX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 114 11:50:34 SQL Data In: ORACLE - Param = 52, Name = ad_DDLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 115 11:50:34 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,ad_DDLSH0 => :ad_DDLSH0); END; 116 11:50:34 SQL Execute: ORACLE - COMMIT 117 11:50:34 SQL Data In: ORACLE - Rows affected = 0 118 11:50:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 119 11:50:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 120 11:50:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1449292.000000 121 11:50:34 SQL Execute: ORACLE - select SF_ZY_YHKTKJE(?,?,?) JFJE00 from dual 122 11:50:34 SQL Execute: ORACLE - update bm_ybjs00 set jszt00='2' where brid00=4872546 and jszt00='1' and mzzybz='1' and trim(CZLBMC)='住院结算_住院收费_住院收费' 123 11:50:34 SQL Data In: ORACLE - Rows affected = 0 124 11:50:34 SQL Execute: ORACLE - COMMIT 125 11:50:34 SQL Data In: ORACLE - Rows affected = 0 126 11:50:34 SQL Misc: ORACLE - Set stored procedure on or off 127 11:50:34 SQL Data In: ORACLE - Param = 1, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 128 11:50:34 SQL Data In: ORACLE - Param = 2, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 陈强 129 11:50:34 SQL Data In: ORACLE - Param = 3, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 130 11:50:34 SQL Data In: ORACLE - Param = 4, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 131 11:50:34 SQL Data In: ORACLE - Param = 5, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 132 11:50:34 SQL Data In: ORACLE - Param = 6, Name = AS_BRZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 133 11:50:34 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 134 11:50:34 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 135 11:50:34 SQL Data In: ORACLE - Param = 9, Name = AS_CYJSRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 136 11:50:34 SQL Data In: ORACLE - Param = 10, Name = AS_CYJSSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 137 11:50:34 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,AS_CYJSRQ => :AS_CYJSRQ,AS_CYJSSJ => :AS_CYJSSJ); END; 138 11:50:34 SQL Execute: ORACLE - update bm_ybjs00 set jszt00='2' where brid00=4872546 and jszt00='1' and mzzybz='1' and trim(CZLBMC)='住院结算_出院登记_出院登记' 139 11:50:34 SQL Data In: ORACLE - Rows affected = 0 140 11:50:34 SQL Execute: ORACLE - COMMIT 141 11:50:34 SQL Data In: ORACLE - Rows affected = 0 142 11:50:34 SQL Execute: ORACLE - COMMIT 143 11:50:34 SQL Data In: ORACLE - Rows affected = 0 144 11:50:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1449292.000000 145 11:50:34 SQL Execute: ORACLE - select * from VW_ZY_FP0000 where JZDH00 = ? 146 11:50:34 SQL Execute: ORACLE - select sum(yszje0) jfje from zy_jzb000 where jzdh00=1449292 147 11:50:34 SQL Execute: ORACLE - select sum(zzzje0) jfje from zy_jzb000 where jzdh00=1449292 148 11:50:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 149 11:50:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 150 11:50:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 151 11:50:34 SQL Execute: ORACLE - select SF_ZY_CHECKTTBR(?,?,?) FSLX00 from dual 152 11:50:34 SQL Execute: ORACLE - select * from zy_pjsyqk where pjh000=0 153 11:50:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1449292.000000 154 11:50:34 SQL Execute: ORACLE - select min(jzksrq) KSRQ,max(jzjsrq) JSRQ from VW_ZY_JZXX00 where jzdh00 =? 155 11:50:34 SQL Execute: ORACLE - select SUM(XMJE00) HSHJJE,jzdh00 from ZY_JZMX00 where JZDH00=1449292 AND SFYLXM='N' group by jzdh00 156 11:50:34 SQL Execute: ORACLE - select FBBH00,BRID00 from ZY_JZB000 where JZDH00 =1449292 157 11:50:34 SQL Execute: ORACLE - select * from VW_ZY_FP0000 where JZDH00 =1449292 158 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,1) XSNR00 from dual 159 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,2) XSNR00 from dual 160 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,7) XSNR00 from dual 161 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,8) XSNR00 from dual 162 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,9) XSNR00 from dual 163 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,8) XSNR00 from dual 164 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,9) XSNR00 from dual 165 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,8) XSNR00 from dual 166 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,9) XSNR00 from dual 167 11:50:35 SQL Execute: ORACLE - select sum(xmje00) hjje00,sum(ZFJE00) ZFJE00 from ZY_JZMX00 where JZDH00=1449292 AND SFYLXM='Y' 168 11:50:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 169 11:50:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1449292.000000 170 11:50:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 171 11:50:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2440.660000 172 11:50:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5067.500000 173 11:50:35 SQL Execute: ORACLE - select SF_ZY_FPHJJE(?,?,?,?,?)FHJG00 from dual 174 11:50:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1449292.000000 175 11:50:35 SQL Execute: ORACLE - select * from ZY_BZFPMX where JZDH00=? order by XMBH00 176 11:50:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1449292.000000 177 11:50:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 178 11:50:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3800.000000 179 11:50:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 180 11:50:35 SQL Execute: ORACLE - select SF_ZY_GFZFJE00(?,?,?,?) FHJG00 from dual 181 11:50:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1449292.000000 182 11:50:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 183 11:50:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 184 11:50:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 185 11:50:35 SQL Execute: ORACLE - select SF_ZY_GFZFJE00(?,?,?,?) FHJG00 from dual 186 11:50:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1449292.000000 187 11:50:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 188 11:50:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1267.500000 189 11:50:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 190 11:50:35 SQL Execute: ORACLE - select SF_ZY_GFZFJE00(?,?,?,?) FHJG00 from dual 191 11:50:35 SQL Execute: ORACLE - select SF_ZY_YBFPJE(1449292,4) XSNR00 from dual 192 11:50:35 SQL Execute: ORACLE - select * from ZY_JZMX00 where SFYLXM='N' AND JZDH00=1449292 193 11:50:35 SQL Execute: ORACLE - COMMIT 194 11:50:35 SQL Data In: ORACLE - Rows affected = 0 195 11:50:35 SQL Execute: ORACLE - COMMIT 196 11:50:35 SQL Data In: ORACLE - Rows affected = 0 197 11:50:35 SQL Execute: ORACLE - select * from ZY_BRXXB0 where ZYID00=1619823 198 11:50:35 SQL Execute: ORACLE - select BRXM00,BRGFZH,FBBH00 from BM_BRXXB0 where BRID00=4872546 199 11:50:35 SQL Execute: ORACLE - COMMIT 200 11:50:35 SQL Data In: ORACLE - Rows affected = 0