1 14:16:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 2 14:16:54 SQL Execute: ORACLE - select * from BM_BRXXB0 Where brid00=? 3 14:16:58 SQL Execute: ORACLE - Select SYSDATE from Dual 4 14:16:58 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 5 14:16:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') and KLLB00='1' 6 14:16:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') and KLLB00='1' 7 14:17:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 8 14:17:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 9 14:17:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 10 14:17:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 11 14:17:05 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 14:17:05 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 13 14:17:05 SQL Execute: ORACLE - select SF_SF_BRSFZJY(?,?,?,?,?,?) BRZJBH from dual 14 14:17:05 SQL Execute: ORACLE - select * from IC_YHXX00 where ICKH00='XMYBB18389519968' 15 14:17:05 SQL Data In: ORACLE - Param = 1, Name = P_ICKNBH, Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389519968 16 14:17:05 SQL Data In: ORACLE - Param = 2, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389519968 17 14:17:05 SQL Data In: ORACLE - Param = 3, Name = P_YWCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = B 18 14:17:05 SQL Data In: ORACLE - Param = 4, Name = P_ICKMM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 19 14:17:05 SQL Data In: ORACLE - Param = 5, Name = P_KLDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = YB-XMJK 20 14:17:05 SQL Data In: ORACLE - Param = 6, Name = P_KMH000, Type = fldZSTRING, Precision = 17, Scale = 0, Data = #XMYBB18389519968 21 14:17:05 SQL Data In: ORACLE - Param = 7, Name = P_SFDM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000001.000000 22 14:17:05 SQL Data In: ORACLE - Param = 8, Name = P_YGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 261.000000 23 14:17:05 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 24 14:17:05 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 25 14:17:05 SQL Execute: ORACLE - BEGIN "SP_SF_ICKRK0_REG000" (P_ICKNBH => :P_ICKNBH,P_ICKH00 => :P_ICKH00,P_YWCZ00 => :P_YWCZ00,P_ICKMM0 => :P_ICKMM0,P_KLDH00 => :P_KLDH00,P_KMH000 => :P_KMH000,P_SFDM00 => :P_SFDM00,P_YGBH00 => :P_YGBH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 26 14:17:07 SQL Execute: ORACLE - select count(*) NUM,NVL(max(ICKJE0),0) ICKJE0 from IC_YHXX00 where ICKH00 = 'XMYBB18389519968' and ZT0000='0' 27 14:17:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 28 14:17:07 SQL Execute: ORACLE - select NVL(ZYE000,0) YE0000 from SF_BRZHXX where brid00 =? and JFLBID = 1 29 14:17:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 30 14:17:07 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00=? 31 14:17:07 SQL Data In: ORACLE - Param = 1, Name = AS_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389519968 32 14:17:07 SQL Data In: ORACLE - Param = 2, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 33 14:17:07 SQL Data In: ORACLE - Param = 3, Name = AS_OLDKH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389518507 34 14:17:07 SQL Data In: ORACLE - Param = 4, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 261.000000 35 14:17:07 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员 36 14:17:07 SQL Data In: ORACLE - Param = 6, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 55.000000 37 14:17:07 SQL Data In: ORACLE - Param = 7, Name = AS_CARDBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 38 14:17:07 SQL Data In: ORACLE - Param = 8, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 39 14:17:07 SQL Data In: ORACLE - Param = 9, Name = AS_SFSQKF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 40 14:17:07 SQL Data In: ORACLE - Param = 10, Name = AS_YBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 41 14:17:07 SQL Data In: ORACLE - Param = 11, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 42 14:17:07 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 14:17:07 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 44 14:17:07 SQL Execute: ORACLE - BEGIN "SP_SF_ICK000_CHANGE" (AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AS_OLDKH0 => :AS_OLDKH0,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AS_CARDBZ => :AS_CARDBZ,AS_CZBZ00 => :AS_CZBZ00,AS_SFSQKF => :AS_SFSQKF,AS_YBZHYE => :AS_YBZHYE,AD_JZDH00 => :AD_JZDH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 45 14:17:08 SQL Execute: ORACLE - Commit 46 14:17:08 SQL Data In: ORACLE - Rows affected = 0 47 14:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 48 14:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389518507 49 14:17:08 SQL Execute: ORACLE - select * from VW_IC_YHXXB0 where BRID00=? and ICKH00=? 50 14:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 51 14:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389518507 52 14:17:08 SQL Execute: ORACLE - select SF_SF_YESORNO_XMJKKH(?,?) FSDYLX from dual 53 14:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 54 14:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389518507 55 14:17:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = XMYB 56 14:17:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 57 14:17:08 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 就诊卡换卡 58 14:17:08 SQL Execute: ORACLE - select SF_SF_XMJKKH(?,?,?,?,?) FSDYLX from dual 59 14:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 60 14:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389519968 61 14:17:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = XMYB 62 14:17:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 63 14:17:08 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 就诊卡换卡 64 14:17:08 SQL Execute: ORACLE - select SF_SF_XMJKKH(?,?,?,?,?) FSDYLX from dual 65 14:17:17 SQL Execute: ORACLE - update IC_YHXX00 SET SCBZ00='1' where ICKH00='XMYBB18389519968' 66 14:17:17 SQL Data In: ORACLE - Rows affected = 1 67 14:17:17 SQL Execute: ORACLE - update BM_BRXXB0 set SFBLWT='1',CARD16='B18389519968' where BRID00='1534897' 68 14:17:17 SQL Data In: ORACLE - Rows affected = 1 69 14:17:17 SQL Execute: ORACLE - COMMIT 70 14:17:17 SQL Data In: ORACLE - Rows affected = 0 71 14:17:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 72 14:17:17 SQL Execute: ORACLE - select * from VW_IC_YHXXB0 where 1 = 1 and ZT0000 in ('1','2' ) and BRBLH0 like ? 73 14:17:22 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 74 14:17:22 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 75 14:17:22 SQL Execute: ORACLE - select * from vw_bm_brfbb0 76 14:17:23 SQL Execute: ORACLE - Select SYSDATE from Dual 77 14:17:23 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 78 14:17:23 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 79 14:17:23 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 80 14:17:23 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='XMYBB18389519968' and ICKNBH ='XMYBB18389519968' 81 14:17:23 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =1534897 82 14:17:24 SQL Execute: ORACLE - select A.* from VW_SF_BRXX00 A where 1=1 and A.brid00 in ( select BRID00 from IC_YHXX00 where ICKH00 = 'XMYBB18389519968' and ZT0000 = '1' ) 83 14:17:32 SQL Execute: ORACLE - select * from BM_YHKDM0 ORDER BY YHKDH0 84 14:17:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 261.000000 85 14:17:32 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 7 and PJSYR0 = ? and SYBZ00 = 'Y' 86 14:17:32 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 87 14:17:32 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 88 14:17:32 SQL Execute: ORACLE - select * from vw_sf_brjflb 89 14:17:32 SQL Execute: ORACLE - select * from VW_BM_BRZFFS where 1=1 and ZFFSBH<>18 order by nvl(XSXH00,0),ZFFSBH 90 14:17:32 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000 91 14:17:32 SQL Execute: ORACLE - Select SYSDATE from Dual 92 14:17:32 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 93 14:17:33 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 94 14:17:33 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 95 14:17:33 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='XMYBB18389519968' and ICKNBH ='XMYBB18389519968' 96 14:17:33 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =1534897 97 14:17:33 SQL Execute: ORACLE - select A.*,B.FBMC00 from BM_BRXXB0 A, BM_BRFBB0 B where A.fbbh00 = B.fbbh00 and BRID00 in ( select BRID00 from IC_YHXX00 where ICKH00 = 'XMYBB18389519968' and ZT0000='1' ) 98 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 99 14:17:33 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =? 100 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 101 14:17:33 SQL Execute: ORACLE - select * from IC_YHXX00 where BRID00 = ? and ZT0000='1' 102 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 103 14:17:33 SQL Execute: ORACLE - select * from SF_BRZHXX where JFLBID = 1 and BRID00 = ? 104 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 105 14:17:33 SQL Execute: ORACLE - select tyje01,YBSBK0,ICKH00 from VW_SF_BRZHXX where brid00= ? 106 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 107 14:17:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 108 14:17:33 SQL Execute: ORACLE - select sum(CFZJE0)+sum(NVL(ZYDJFY,0)) JE0000,sum(NVL(ZYDJFY,0)) ZYDJFY from VW_SF_YFMZCF A where (A.BCCFH0 is null) and A.CFZT00 = '0' and A.BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 109 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 110 14:17:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 111 14:17:33 SQL Execute: ORACLE - select sum(ZJE000) JE0000 from VW_SF_YJYW00 where (CXDJH0 is null) and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 112 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 113 14:17:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 114 14:17:33 SQL Execute: ORACLE - select SUM(ROUND(B.YPZSL0*B.LSDJ00,2)*B.ZFBL00) JE0000 from VW_SF_YFMZCF A,YF_MZCFMX B where A.CFLSH0=B.CFLSH0 AND (A.BCCFH0 is null) and A.CFZT00 = '0' and A.BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 115 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 116 14:17:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 117 14:17:33 SQL Execute: ORACLE - select SUM(ZFJE00) JE0000 from VW_SF_YJYW00 A,YJ_YWJJ00 B where A.YJDJH0=B.YJDJH0 AND (CXDJH0 is null) and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 118 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 119 14:17:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 120 14:17:33 SQL Execute: ORACLE - select sum(CFZJE0)+sum(NVL(ZYDJFY,0)) JE0000 from VW_SF_YFMZCF A where (A.BCCFH0 is null) and A.CFZT00 = '0' and A.BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 121 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 122 14:17:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 123 14:17:33 SQL Execute: ORACLE - select sum(ZJE000) JE0000 from VW_SF_YJYW00 where (CXDJH0 is null) and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate and brid00= ?) 124 14:17:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 125 14:17:33 SQL Execute: ORACLE - select SF_SF_MSZFKQ(?)FHJG00 from dual 126 14:17:38 SQL Execute: ORACLE - Select SYSDATE from Dual 127 14:17:38 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 128 14:17:38 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 129 14:17:39 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 130 14:17:39 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='XMYBB18389518507' and ICKNBH ='XMYBB18389518507' 131 14:17:49 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 7 and PJSYR0 =261 and SYBZ00 = 'Y' 132 14:17:49 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 133 14:17:49 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 134 14:17:49 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 135 14:17:49 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 136 14:17:49 SQL Execute: ORACLE - select * from VW_SF_BRJFLB where JFLBID <> 0 137 14:17:49 SQL Execute: ORACLE - select * from BM_BRZTB0 138 14:17:49 SQL Execute: ORACLE - select FBMC00,FBBH00 from VW_BM_BRFBB0 where FBBH00 not in (3,99) 139 14:17:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 140 14:17:49 SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by A.YBLB00 desc 141 14:17:49 SQL Execute: ORACLE - select MC0000,DM0000 from XT_ZY0000 where 1=1 order by DM0000 142 14:17:49 SQL Execute: ORACLE - select MC0000,DM0000 from XT_MZ0000 where 1=1 order by DM0000 143 14:17:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = B1838952006 144 14:17:54 SQL Execute: ORACLE - select Count(*) num from IC_YHXX00 where ICKH00 =? 145 14:18:37 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 146 14:18:37 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 147 14:18:37 SQL Execute: ORACLE - select * from vw_sf_brjflb 148 14:18:40 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) 149 14:18:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 150 14:18:44 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) and BRBLH0 like ? 151 14:18:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 152 14:18:59 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) and BRBLH0 like ? 153 14:19:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 154 14:19:11 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) and BRBLH0 like ? 155 14:19:29 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 156 14:19:29 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 157 14:19:29 SQL Execute: ORACLE - select * from vw_sf_brjflb 158 14:19:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 159 14:19:33 SQL Execute: ORACLE - select * from VW_IC_YHXXB0 where 1 = 1 and ZT0000 in ('1','2' ) and BRBLH0 like ? 160 14:19:49 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 161 14:19:49 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 162 14:19:49 SQL Execute: ORACLE - select * from vw_sf_brjflb 163 14:19:51 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) 164 14:19:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 165 14:19:56 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) and BRBLH0 like ? 166 14:20:07 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 167 14:20:07 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 168 14:20:07 SQL Execute: ORACLE - select * from vw_sf_brjflb 169 14:20:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 170 14:20:11 SQL Execute: ORACLE - select * from VW_IC_YHXXB0 where 1 = 1 and ZT0000 in ('1','2' ) and BRBLH0 like ? 171 14:20:15 SQL Data In: ORACLE - Param = 1, Name = AS_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389519968 172 14:20:15 SQL Data In: ORACLE - Param = 2, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 261.000000 173 14:20:15 SQL Data In: ORACLE - Param = 3, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 174 14:20:15 SQL Data In: ORACLE - Param = 4, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 175 14:20:15 SQL Data In: ORACLE - Param = 5, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 176 14:20:15 SQL Execute: ORACLE - BEGIN "SP_SF_ICK000_REG000" (AS_ICKH00 => :AS_ICKH00,AD_CZY000 => :AD_CZY000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_CZBZ00 => :AS_CZBZ00); END; 177 14:20:24 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 178 14:20:24 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 179 14:20:24 SQL Execute: ORACLE - select * from vw_sf_brjflb 180 14:20:26 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) 181 14:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 182 14:20:30 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) and BRBLH0 like ? 183 14:20:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 184 14:20:45 SQL Execute: ORACLE - select * from BM_BRXXB0 where brid00 =? 185 14:20:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 186 14:20:45 SQL Execute: ORACLE - select count(*) SFZF from ic_yhxx00 where brid00=? and zt0000='3' 187 14:20:46 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 188 14:20:46 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 189 14:20:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 190 14:20:47 SQL Execute: ORACLE - select * from BM_BRXXB0 Where brid00=? 191 14:20:52 SQL Execute: ORACLE - Select SYSDATE from Dual 192 14:20:52 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 193 14:20:52 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') and KLLB00='1' 194 14:20:52 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') and KLLB00='1' 195 14:20:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 196 14:20:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 197 14:20:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 198 14:20:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 199 14:20:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 200 14:20:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 201 14:20:58 SQL Execute: ORACLE - select SF_SF_BRSFZJY(?,?,?,?,?,?) BRZJBH from dual 202 14:20:58 SQL Execute: ORACLE - select * from IC_YHXX00 where ICKH00='XMYBB18389520337' 203 14:20:58 SQL Data In: ORACLE - Param = 1, Name = P_ICKNBH, Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389520337 204 14:20:58 SQL Data In: ORACLE - Param = 2, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389520337 205 14:20:58 SQL Data In: ORACLE - Param = 3, Name = P_YWCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = B 206 14:20:58 SQL Data In: ORACLE - Param = 4, Name = P_ICKMM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 207 14:20:58 SQL Data In: ORACLE - Param = 5, Name = P_KLDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = YB-XMJK 208 14:20:58 SQL Data In: ORACLE - Param = 6, Name = P_KMH000, Type = fldZSTRING, Precision = 17, Scale = 0, Data = #XMYBB18389520337 209 14:20:58 SQL Data In: ORACLE - Param = 7, Name = P_SFDM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000001.000000 210 14:20:58 SQL Data In: ORACLE - Param = 8, Name = P_YGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 261.000000 211 14:20:58 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 212 14:20:58 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 213 14:20:58 SQL Execute: ORACLE - BEGIN "SP_SF_ICKRK0_REG000" (P_ICKNBH => :P_ICKNBH,P_ICKH00 => :P_ICKH00,P_YWCZ00 => :P_YWCZ00,P_ICKMM0 => :P_ICKMM0,P_KLDH00 => :P_KLDH00,P_KMH000 => :P_KMH000,P_SFDM00 => :P_SFDM00,P_YGBH00 => :P_YGBH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 214 14:20:58 SQL Execute: ORACLE - select count(*) NUM,NVL(max(ICKJE0),0) ICKJE0 from IC_YHXX00 where ICKH00 = 'XMYBB18389520337' and ZT0000='0' 215 14:20:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 216 14:20:58 SQL Execute: ORACLE - select NVL(ZYE000,0) YE0000 from SF_BRZHXX where brid00 =? and JFLBID = 1 217 14:20:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 218 14:20:58 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00=? 219 14:20:58 SQL Data In: ORACLE - Param = 1, Name = AS_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = XMYBB18389520337 220 14:20:58 SQL Data In: ORACLE - Param = 2, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 221 14:20:58 SQL Data In: ORACLE - Param = 3, Name = AS_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 222 14:20:58 SQL Data In: ORACLE - Param = 4, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 261.000000 223 14:20:58 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员 224 14:20:58 SQL Data In: ORACLE - Param = 6, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 55.000000 225 14:20:58 SQL Data In: ORACLE - Param = 7, Name = AS_CARDBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 226 14:20:58 SQL Data In: ORACLE - Param = 8, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 227 14:20:58 SQL Data In: ORACLE - Param = 9, Name = AS_SFSQKF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 228 14:20:58 SQL Data In: ORACLE - Param = 10, Name = AS_YBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 229 14:20:58 SQL Data In: ORACLE - Param = 11, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 230 14:20:58 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 231 14:20:58 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 232 14:20:58 SQL Execute: ORACLE - BEGIN "SP_SF_ICK000_CHANGE" (AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AS_OLDKH0 => :AS_OLDKH0,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AS_CARDBZ => :AS_CARDBZ,AS_CZBZ00 => :AS_CZBZ00,AS_SFSQKF => :AS_SFSQKF,AS_YBZHYE => :AS_YBZHYE,AD_JZDH00 => :AD_JZDH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 233 14:20:59 SQL Execute: ORACLE - Commit 234 14:20:59 SQL Data In: ORACLE - Rows affected = 0 235 14:20:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1534897.000000 236 14:20:59 SQL Execute: ORACLE - select * from VW_IC_YHXXB0 where BRID00=? not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) 237 14:20:59 SQL Error: ORACLE - ORA-00933: SQL 命令未正确结束 238 14:20:59 SQL Error: ORACLE - Unmapped SQL Error Code: 933 239 14:20:59 SQL Data In: ORACLE - Rows affected = 0 240 14:24:13 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 241 14:24:13 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 242 14:24:13 SQL Execute: ORACLE - select * from vw_sf_brjflb 243 14:25:53 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 244 14:25:53 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 245 14:25:53 SQL Execute: ORACLE - select * from vw_sf_brjflb 246 14:26:31 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 247 14:26:31 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 248 14:26:31 SQL Execute: ORACLE - select * from vw_sf_brjflb 249 14:27:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = *623879% 250 14:27:08 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) and BRBLH0 like ?