1 17:44:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 测试092901 2 17:44:26 SQL Execute: ORACLE - select * from zy_brxxb0 A,bm_brxxb0 B where A.BRID00=B.BRID00 and A.XM0000=? 3 17:44:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 4 17:44:36 SQL Execute: ORACLE - Select * from (select MC0000,BH0000,PYSM00,WBSM00 from BM_TYZD00 where (PYSM00 Like ?) and( ZDMC00 like '%病人职业信息维护%' ) Order By PYSM00) where Rownum<=30 5 17:51:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 妇产科病区 6 17:51:25 SQL Execute: ORACLE - select C.BMMC00 from BM_BMBM00 A, BM_BQKS00 B,BM_BMBM00 C where A.BMBH00 = B.BQH000 and B.KSH000 = C.BMBH00 and B.YXBZ00 = '1' and C.CZBZ00 <> '2' and A.BMMC00 = ? 7 17:51:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 8 17:51:27 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00,YGBH00 from VW_ZY_YSXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=30 9 17:51:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = c% 10 17:51:28 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00,YGBH00 from VW_ZY_YSXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=30 11 17:51:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = cy% 12 17:51:30 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00,YGBH00 from VW_ZY_YSXX00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=30 13 17:53:06 SQL Execute: ORACLE - select Count(*) sl from ZY_BRXXB0 WHERE ZYH000='00109883' and BRID00<>0 14 17:53:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 15 17:53:06 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 16 17:53:06 SQL Execute: ORACLE - select to_char(sysdate,'yyyymmdd') datestr from dual 17 17:53:06 SQL Execute: ORACLE - SELECT Count(*) sl FROM VW_BM_FWBJ00 WHERE qtlbmc='本市' 18 17:53:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 19 17:53:06 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 8 and PJSYR0 = ? and SYBZ00 = 'Y' 20 17:53:06 SQL Execute: ORACLE - select SF_ZY_TSBRXXTS('','','0') MSG000 from dual 21 17:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 22 17:53:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 23 17:53:10 SQL Execute: ORACLE - select A.SFJSDW from ic_ybbrlb A,bm_brfbb0 B where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? and A.YBMC00 = ? 24 17:53:10 SQL Data In: ORACLE - Param = 1, Name = AS_ICKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 25 17:53:10 SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00109883 26 17:53:10 SQL Data In: ORACLE - Param = 3, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 27 17:53:10 SQL Data In: ORACLE - Param = 4, Name = AS_BRXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 测试092901 28 17:53:10 SQL Data In: ORACLE - Param = 5, Name = AS_BRXB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 29 17:53:10 SQL Data In: ORACLE - Param = 6, Name = AS_BRXX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 30 17:53:10 SQL Data In: ORACLE - Param = 7, Name = AS_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20000201 31 17:53:10 SQL Data In: ORACLE - Param = 8, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 未婚 32 17:53:10 SQL Data In: ORACLE - Param = 9, Name = AS_BRZY00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 个体经营者 33 17:53:10 SQL Data In: ORACLE - Param = 10, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 汉族 34 17:53:10 SQL Data In: ORACLE - Param = 11, Name = AS_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 国籍 35 17:53:10 SQL Data In: ORACLE - Param = 12, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 36 17:53:10 SQL Data In: ORACLE - Param = 13, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 37 17:53:10 SQL Data In: ORACLE - Param = 14, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 38 17:53:10 SQL Data In: ORACLE - Param = 15, Name = AS_BRDYFW, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 测试出生地 39 17:53:10 SQL Data In: ORACLE - Param = 16, Name = AS_BRDH00, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 家庭电话123 40 17:53:10 SQL Data In: ORACLE - Param = 17, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 家庭地址省家庭地址市家庭地址区家庭地址镇家庭地址村 41 17:53:10 SQL Data In: ORACLE - Param = 18, Name = AS_BRYB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 42 17:53:10 SQL Data In: ORACLE - Param = 19, Name = AS_BRYB01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 43 17:53:10 SQL Data In: ORACLE - Param = 20, Name = AS_BRGFZH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 44 17:53:10 SQL Data In: ORACLE - Param = 21, Name = AD_TYDWID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 17:53:10 SQL Data In: ORACLE - Param = 22, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 46 17:53:10 SQL Data In: ORACLE - Param = 23, Name = AS_BRLXGX, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 父母 47 17:53:10 SQL Data In: ORACLE - Param = 24, Name = AS_BRLXXM, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 联系人 48 17:53:10 SQL Data In: ORACLE - Param = 25, Name = AS_BRLXDZ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 联系人住址 49 17:53:10 SQL Data In: ORACLE - Param = 26, Name = AS_BRLXDH, Type = fldZSTRING, Precision = 13, Scale = 0, Data = 联系人电话654 50 17:53:10 SQL Data In: ORACLE - Param = 27, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 51 17:53:10 SQL Data In: ORACLE - Param = 28, Name = AS_BRJKQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 52 17:53:10 SQL Data In: ORACLE - Param = 29, Name = AS_BRLX00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 初诊 53 17:53:10 SQL Data In: ORACLE - Param = 30, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 住院预交金 54 17:53:10 SQL Data In: ORACLE - Param = 31, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 55 17:53:10 SQL Data In: ORACLE - Param = 32, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 56 17:53:10 SQL Data In: ORACLE - Param = 33, Name = AD_BJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 57 17:53:10 SQL Data In: ORACLE - Param = 34, Name = AD_TYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 58 17:53:10 SQL Data In: ORACLE - Param = 35, Name = AD_YXQFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 59 17:53:10 SQL Data In: ORACLE - Param = 36, Name = AS_KL0000, Type = fldZSTRING, Precision = 14, Scale = 0, Data = hplZOq6iScaqyo 60 17:53:10 SQL Data In: ORACLE - Param = 37, Name = AS_ZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 61 17:53:10 SQL Data In: ORACLE - Param = 38, Name = AS_ZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 62 17:53:10 SQL Data In: ORACLE - Param = 39, Name = AS_ZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 63 17:53:10 SQL Data In: ORACLE - Param = 40, Name = AS_ZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 64 17:53:10 SQL Data In: ORACLE - Param = 41, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 65 17:53:10 SQL Data In: ORACLE - Param = 42, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄代民 66 17:53:10 SQL Data In: ORACLE - Param = 43, Name = AD_CZYKSH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477.000000 67 17:53:10 SQL Data In: ORACLE - Param = 44, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 68 17:53:10 SQL Data In: ORACLE - Param = 45, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 69 17:53:10 SQL Data In: ORACLE - Param = 46, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 70 17:53:10 SQL Data In: ORACLE - Param = 47, Name = AS_YBLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 71 17:53:10 SQL Data In: ORACLE - Param = 48, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 72 17:53:10 SQL Data In: ORACLE - Param = 49, Name = AD_YZCS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 73 17:53:10 SQL Data In: ORACLE - Param = 50, Name = AD_YZYBJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 74 17:53:10 SQL Data In: ORACLE - Param = 51, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 75 17:53:10 SQL Data In: ORACLE - Param = 52, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 76 17:53:10 SQL Data In: ORACLE - Param = 53, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 77 17:53:10 SQL Data In: ORACLE - Param = 54, Name = AS_BJJBIE, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 78 17:53:10 SQL Data In: ORACLE - Param = 55, Name = as_FWBJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本市 79 17:53:10 SQL Data In: ORACLE - Param = 56, Name = as_XZQH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 80 17:53:10 SQL Data In: ORACLE - Param = 57, Name = as_JG0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 籍贯 81 17:53:10 SQL Data In: ORACLE - Param = 58, Name = as_SFSY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 82 17:53:10 SQL Data In: ORACLE - Param = 59, Name = as_SFBJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 83 17:53:10 SQL Data In: ORACLE - Param = 60, Name = AS_TSSXMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 84 17:53:10 SQL Data In: ORACLE - Param = 61, Name = as_GZDWDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 85 17:53:10 SQL Data In: ORACLE - Param = 62, Name = as_BRGRDH, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 本人电话321 86 17:53:10 SQL Data In: ORACLE - Param = 63, Name = as_HZDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 87 17:53:10 SQL Data In: ORACLE - Param = 64, Name = as_BRCSSJ, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 00:00 88 17:53:10 SQL Data In: ORACLE - Param = 65, Name = as_JDCZFL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 89 17:53:10 SQL Data In: ORACLE - Param = 66, Name = as_YBJKID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 90 17:53:10 SQL Data In: ORACLE - Param = 67, Name = as_ZYFL00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 91 17:53:10 SQL Data In: ORACLE - Param = 68, Name = as_ZYZFL0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 92 17:53:10 SQL Execute: ORACLE - BEGIN "SP_ZY_BRXX00_REG000" (AS_ICKH00 => :AS_ICKH00,AS_MRN000 => :AS_MRN000,AS_BRBLH0 => :AS_BRBLH0,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,AS_BRGFZH => :AS_BRGFZH,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,AS_BRLX00 => :AS_BRLX00,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_BJJE00 => :AD_BJJE00,AD_TYJE00 => :AD_TYJE00,AD_YXQFJE => :AD_YXQFJE,AS_KL0000 => :AS_KL0000,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKSH => :AD_CZYKSH,AS_YJJXH0 => :AS_YJJXH0,AS_YBKH00 => :AS_YBKH00,AS_YBID00 => :AS_YBID00,AS_YBLB00 => :AS_YBLB00,AS_SFYB00 => :AS_SFYB00,AD_YZCS00 => :AD_YZCS00,AD_YZYBJE => :AD_YZYBJE,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_BJJBIE => :AS_BJJBIE,as_FWBJ00 => :as_FWBJ00,as_XZQH00 => :as_XZQH00,as_JG0000 => :as_JG0000,as_SFSY00 => :as_SFSY00,as_SFBJ00 => :as_SFBJ00,AS_TSSXMC => :AS_TSSXMC,as_GZDWDH => :as_GZDWDH,as_BRGRDH => :as_BRGRDH,as_HZDWMC => :as_HZDWMC,as_BRCSSJ => :as_BRCSSJ,as_JDCZFL => :as_JDCZFL,as_YBJKID => :as_YBJKID,as_ZYFL00 => :as_ZYFL00,as_ZYZFL0 => :as_ZYZFL0); END; 93 17:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 00109883 94 17:53:10 SQL Execute: ORACLE - select * from bm_brxxb0 where MRN000 = ? 95 17:53:10 SQL Execute: ORACLE - update BM_BRXXB0 set TYDWMC='',BRLXXM='联系人',BRJTDZ='家庭地址省家庭地址市家庭地址区家庭地址镇家庭地址村',BRXZDZ='现住址省现住址市现住址区现住址镇现住址村',BRLXDH='联系人电话654',BRSZSF='家庭地址省',BRSZS0='家庭地址市',BRSZX0='家庭地址区',BRSZZ0='家庭地址镇',BRSZC0='家庭地址村',BRXZSF='现住址省',BRXZS0='现住址市',BRXZX0='现住址区',BRXZZ0='现住址镇',BRXZC0='现住址村' where BRID00=1897129 96 17:53:11 SQL Data In: ORACLE - Rows affected = 1 97 17:53:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 98 17:53:11 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 99 17:53:11 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1897129.000000 100 17:53:11 SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00109883 101 17:53:11 SQL Data In: ORACLE - Param = 3, Name = AS_ZYH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00109883 102 17:53:11 SQL Data In: ORACLE - Param = 4, Name = AS_YBZYH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 103 17:53:11 SQL Data In: ORACLE - Param = 5, Name = AS_XM0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 测试092901 104 17:53:11 SQL Data In: ORACLE - Param = 6, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 105 17:53:11 SQL Data In: ORACLE - Param = 7, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20000201 106 17:53:11 SQL Data In: ORACLE - Param = 8, Name = AD_FBBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 107 17:53:11 SQL Data In: ORACLE - Param = 9, Name = AS_RYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 108 17:53:11 SQL Data In: ORACLE - Param = 10, Name = AS_RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:44:04 109 17:53:11 SQL Data In: ORACLE - Param = 11, Name = AD_RYCZY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 110 17:53:11 SQL Data In: ORACLE - Param = 12, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄代民 111 17:53:11 SQL Data In: ORACLE - Param = 13, Name = AS_RYZD00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 112 17:53:11 SQL Data In: ORACLE - Param = 14, Name = AS_RYSQK0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 一般 113 17:53:11 SQL Data In: ORACLE - Param = 15, Name = AS_RYLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 114 17:53:11 SQL Data In: ORACLE - Param = 16, Name = AS_RYBQMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 妇产科病区 115 17:53:11 SQL Data In: ORACLE - Param = 17, Name = AS_RZKSMC, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 妇产科 116 17:53:11 SQL Data In: ORACLE - Param = 18, Name = AS_RYCWH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 117 17:53:11 SQL Data In: ORACLE - Param = 19, Name = AS_BRZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 118 17:53:11 SQL Data In: ORACLE - Param = 20, Name = AD_ZZYS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 119 17:53:11 SQL Data In: ORACLE - Param = 21, Name = AS_ZZYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 120 17:53:11 SQL Data In: ORACLE - Param = 22, Name = AD_ZRYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 121 17:53:11 SQL Data In: ORACLE - Param = 23, Name = AS_ZRYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 122 17:53:11 SQL Data In: ORACLE - Param = 24, Name = AD_SXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 123 17:53:11 SQL Data In: ORACLE - Param = 25, Name = AS_SXYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 124 17:53:11 SQL Data In: ORACLE - Param = 26, Name = AS_JFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 125 17:53:11 SQL Data In: ORACLE - Param = 27, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 住院预交金 126 17:53:11 SQL Data In: ORACLE - Param = 28, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 127 17:53:11 SQL Data In: ORACLE - Param = 29, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 128 17:53:11 SQL Data In: ORACLE - Param = 30, Name = AS_ZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 129 17:53:11 SQL Data In: ORACLE - Param = 31, Name = AS_ZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 130 17:53:11 SQL Data In: ORACLE - Param = 32, Name = AS_ZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 17:53:11 SQL Data In: ORACLE - Param = 33, Name = AS_ZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 132 17:53:11 SQL Data In: ORACLE - Param = 34, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 133 17:53:11 SQL Data In: ORACLE - Param = 35, Name = AS_BRRYCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 134 17:53:11 SQL Data In: ORACLE - Param = 36, Name = AD_YZCS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 135 17:53:11 SQL Data In: ORACLE - Param = 37, Name = AD_YZYBJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 136 17:53:11 SQL Data In: ORACLE - Param = 38, Name = AD_SZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1209.000000 137 17:53:11 SQL Data In: ORACLE - Param = 39, Name = AS_RYZDMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 138 17:53:11 SQL Data In: ORACLE - Param = 40, Name = AS_YBZFRY, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 139 17:53:11 SQL Data In: ORACLE - Param = 41, Name = AD_BRMZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 汉族 140 17:53:11 SQL Data In: ORACLE - Param = 42, Name = AD_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 国籍 141 17:53:11 SQL Data In: ORACLE - Param = 43, Name = AD_TBZX00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 142 17:53:11 SQL Data In: ORACLE - Param = 44, Name = AD_ZJHM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 143 17:53:11 SQL Data In: ORACLE - Param = 45, Name = AD_DWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 144 17:53:11 SQL Data In: ORACLE - Param = 46, Name = AD_LXR000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 联系人 145 17:53:11 SQL Data In: ORACLE - Param = 47, Name = AD_BRLXDH, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 家庭电话123 146 17:53:11 SQL Data In: ORACLE - Param = 48, Name = AD_BRJTDZ, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 家庭地址省家庭地址市家庭地址区家庭地址镇家庭地址村 147 17:53:11 SQL Data In: ORACLE - Param = 49, Name = AS_GSDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 148 17:53:11 SQL Data In: ORACLE - Param = 50, Name = as_BRZTQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 149 17:53:11 SQL Data In: ORACLE - Param = 51, Name = ad_DBLB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 150 17:53:11 SQL Data In: ORACLE - Param = 52, Name = ad_DBLBMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 151 17:53:11 SQL Data In: ORACLE - Param = 53, Name = as_YBLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 152 17:53:11 SQL Data In: ORACLE - Param = 54, Name = as_BRRYTJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 直接入院 153 17:53:11 SQL Data In: ORACLE - Param = 55, Name = as_BRZLLB, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 中西医 154 17:53:11 SQL Data In: ORACLE - Param = 56, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 155 17:53:11 SQL Data In: ORACLE - Param = 57, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 156 17:53:11 SQL Data In: ORACLE - Param = 58, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 157 17:53:11 SQL Data In: ORACLE - Param = 59, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 158 17:53:11 SQL Data In: ORACLE - Param = 60, Name = ad_ZJXXLY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 159 17:53:11 SQL Data In: ORACLE - Param = 61, Name = as_GZDWDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 160 17:53:11 SQL Data In: ORACLE - Param = 62, Name = as_BRGRDH, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 本人电话321 161 17:53:11 SQL Data In: ORACLE - Param = 63, Name = as_SFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 162 17:53:11 SQL Data In: ORACLE - Param = 64, Name = as_RYDJRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 163 17:53:11 SQL Data In: ORACLE - Param = 65, Name = as_RYDJSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 164 17:53:11 SQL Data In: ORACLE - Param = 66, Name = as_JDCZFL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 165 17:53:11 SQL Data In: ORACLE - Param = 67, Name = ad_BRSJHM, Type = fldZSTRING, Precision = 13, Scale = 0, Data = 联系人电话654 166 17:53:11 SQL Data In: ORACLE - Param = 68, Name = as_ZYFL00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 167 17:53:11 SQL Data In: ORACLE - Param = 69, Name = as_ZYZFL0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 168 17:53:11 SQL Execute: ORACLE - BEGIN "SP_ZY_BRRYDJ" (AD_BRID00 => :AD_BRID00,AS_MRN000 => :AS_MRN000,AS_ZYH000 => :AS_ZYH000,AS_YBZYH0 => :AS_YBZYH0,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AD_FBBH00 => :AD_FBBH00,AS_RYRQ00 => :AS_RYRQ00,AS_RYSJ00 => :AS_RYSJ00,AD_RYCZY0 => :AD_RYCZY0,AS_CZYXM0 => :AS_CZYXM0,AS_RYZD00 => :AS_RYZD00,AS_RYSQK0 => :AS_RYSQK0,AS_RYLB00 => :AS_RYLB00,AS_RYBQMC => :AS_RYBQMC,AS_RZKSMC => :AS_RZKSMC,AS_RYCWH0 => :AS_RYCWH0,AS_BRZT00 => :AS_BRZT00,AD_ZZYS00 => :AD_ZZYS00,AS_ZZYSXM => :AS_ZZYSXM,AD_ZRYS00 => :AD_ZRYS00,AS_ZRYSXM => :AS_ZRYSXM,AD_SXYS00 => :AD_SXYS00,AS_SXYSXM => :AS_SXYSXM,AS_JFBZ00 => :AS_JFBZ00,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AS_YJJXH0 => :AS_YJJXH0,AS_BRRYCS => :AS_BRRYCS,AD_YZCS00 => :AD_YZCS00,AD_YZYBJE => :AD_YZYBJE,AD_SZYS00 => :AD_SZYS00,AS_RYZDMC => :AS_RYZDMC,AS_YBZFRY => :AS_YBZFRY,AD_BRMZ00 => :AD_BRMZ00,AD_BRGJ00 => :AD_BRGJ00,AD_TBZX00 => :AD_TBZX00,AD_ZJHM00 => :AD_ZJHM00,AD_DWMC00 => :AD_DWMC00,AD_LXR000 => :AD_LXR000,AD_BRLXDH => :AD_BRLXDH,AD_BRJTDZ => :AD_BRJTDZ,AS_GSDJH0 => :AS_GSDJH0,as_BRZTQK => :as_BRZTQK,ad_DBLB00 => :ad_DBLB00,ad_DBLBMC => :ad_DBLBMC,as_YBLB00 => :as_YBLB00,as_BRRYTJ => :as_BRRYTJ,as_BRZLLB => :as_BRZLLB,AD_ZYID00 => :AD_ZYID00,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_ZJXXLY => :ad_ZJXXLY,as_GZDWDH => :as_GZDWDH,as_BRGRDH => :as_BRGRDH,as_SFJZFP => :as_SFJZFP,as_RYDJRQ => :as_RYDJRQ,as_RYDJSJ => :as_RYDJSJ,as_JDCZFL => :as_JDCZFL,ad_BRSJHM => :ad_BRSJHM,as_ZYFL00 => :as_ZYFL00,as_ZYZFL0 => :as_ZYZFL0); END; 169 17:53:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 596139.000000 170 17:53:11 SQL Execute: ORACLE - select * from zy_brxxb0 where zyid00 =? 171 17:53:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 172 17:53:11 SQL Execute: ORACLE - select count(1) num from BM_MZJZBR where BRSFZH = ? 173 17:53:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 174 17:53:11 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 175 17:53:11 SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000 176 17:53:11 SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00109883 177 17:53:11 SQL Data In: ORACLE - Param = 3, Name = P_FLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 178 17:53:11 SQL Data In: ORACLE - Param = 4, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 179 17:53:11 SQL Execute: ORACLE - BEGIN "SP_XT_CANSEQ" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0,P_FLAG00 => :P_FLAG00,P_COMMIT => :P_COMMIT); END; 180 17:53:11 SQL Execute: ORACLE - Commit 181 17:53:11 SQL Data In: ORACLE - Rows affected = 0 182 17:53:11 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='福建预交金统一平台' and BH0000='Open_ZY' 183 17:53:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 184 17:53:11 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 185 17:53:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 186 17:53:11 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 187 17:53:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1897129.000000 188 17:53:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 189 17:53:11 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0 from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 190 17:53:11 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1002.000000 191 17:53:11 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1897129.000000 192 17:53:11 SQL Data In: ORACLE - Param = 3, Name = PCARDNO, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00109883 193 17:53:11 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 194 17:53:11 SQL Data In: ORACLE - Param = 5, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄代民 195 17:53:11 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 196 17:53:11 SQL Data In: ORACLE - Param = 7, Name = PINCS00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 入院登记余额下载 197 17:53:11 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 198 17:53:11 SQL Data In: ORACLE - Param = 9, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 199 17:53:11 SQL Data In: ORACLE - Param = 10, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 200 17:53:11 SQL Data In: ORACLE - Param = 11, Name = PRECODE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 201 17:53:11 SQL Data In: ORACLE - Param = 12, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 202 17:53:11 SQL Execute: ORACLE - BEGIN "SP_ONEPAY_YJJPTJK" (PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PCARDNO => :PCARDNO,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PRECODE => :PRECODE,PERRMSG => :PERRMSG); END; 203 17:53:11 SQL Execute: ORACLE - Rollback 204 17:53:11 SQL Data In: ORACLE - Rows affected = 0 205 17:53:11 SQL Execute: ORACLE - select C.BMMC00 DQBQMC,G.BMMC00 RYKSMC,A.*,B.*,D.YBMC00,E.FBMC00 RYFBMC,F.YZCS00,F.YZYBJE from VW_SF_BRXX00 A, ZY_BRXXB0 B,bm_bmbm00 C,IC_YBBRLB D,BM_BRFBB0 E,ZY_BRZHXX F,bm_bmbm00 G where A.BRID00 = B.BRID00 and B.RYBQ00 = C.BMBH00 and B.RZKS00 = G.BMBH00 and A.YBLB00 = D.YBLB00 and A.FBBH00 = D.FBBH00 and A.FBBH00 = E.FBBH00 AND A.BRID00 = F.BRID00 and B.ZYID00=596139 206 17:53:12 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL