1 10:51:38 SQL Execute: ORACLE - Select SYSDATE from Dual 2 10:51:38 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 3 10:51: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') 4 10:51: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 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 5 10:51: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 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 6 10:51:39 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='FZYBA10866919' and ICKNBH ='FZYBA10866919' 7 10:51:39 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =3820657 8 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 588.000000 9 10:51:39 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = ? and SYBZ00 = 'Y' 10 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 11 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 12 10:51:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 13 10:51:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 14 10:51:39 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5199806 15 10:51:39 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( MZH000 = ? or MZH000 = '0') 16 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 17 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5199806 18 10:51:39 SQL Execute: ORACLE - select sum(ZFJE00) ZFJE00,sum(JZJE00) JZJE00 FROM SF_BRFY00 WHERE BRID00=? and JZDH00+0=0 AND CXPJR0='999999' and ( MZH000 =?) 19 10:51:39 SQL Execute: ORACLE - update SF_BRFY00 SET CZRQ00='20160414' WHERE BRID00=3820657 and JZDH00+0=0 AND CZRQ00='19990101' and ( MZH000 = '5199806') 20 10:51:39 SQL Data In: ORACLE - Rows affected = 0 21 10:51:39 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YF_MZCFBLTS' 22 10:51:39 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_XMYXTS' 23 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 24 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 25 10:51:39 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= ?) and d.srrq00>=to_char(sysdate-?,'YYYYMMDD') 26 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 27 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 28 10:51:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 29 10:51:39 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 30 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 31 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 32 10:51:39 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= ? and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-?,'YYYYMMDD') and A.YPDLBH=D.LBBH00 33 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 34 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 35 10:51:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 36 10:51:39 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 37 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 38 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 39 10:51:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 40 10:51:39 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 41 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 42 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 43 10:51:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 44 10:51:39 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 and b.SFKSLY<>'Y' group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 45 10:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 46 10:51:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 47 10:51:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 48 10:51:39 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= ? and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 49 10:51:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 50 10:51:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5199806 51 10:51:43 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 52 10:51:43 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 53 10:51:43 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?)SFZRZY from dual 54 10:51:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 55 10:51:43 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 56 10:51:43 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(3820657,5199806,0) YYKSBM from dual 57 10:51:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 58 10:51:43 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 59 10:51:43 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(3820657,5199806,1) YYKSBM from dual 60 10:51:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 61 10:51:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 62 10:51:43 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000001000001 63 10:51:43 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5199806 64 10:51:43 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 65 10:51:43 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 66 10:51:43 SQL Execute: ORACLE - select SF_SF_TSBZJM(?,?,?,?,?,?) FSDYLX from dual 67 10:51:43 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 68 10:51:43 SQL Data In: ORACLE - Param = 2, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 69 10:51:43 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 70 10:51:43 SQL Data In: ORACLE - Param = 4, Name = AS_GHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5199806 71 10:51:43 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA10866919 72 10:51:43 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 73 10:51:43 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 74 10:51:43 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林剑青 75 10:51:43 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 76 10:51:43 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 77 10:51:43 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 335.600000 78 10:51:43 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 79 10:51:43 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 80 10:51:43 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 335.600000 81 10:51:43 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 82 10:51:43 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 83 10:51:43 SQL Data In: ORACLE - Param = 17, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 84 10:51:43 SQL Data In: ORACLE - Param = 18, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 85 10:51:43 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 335.600000 86 10:51:43 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 588.000000 87 10:51:43 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林玲梅 88 10:51:43 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 89 10:51:43 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 90 10:51:43 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7754991 91 10:51:43 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 92 10:51:43 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 93 10:51:43 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000001000001 94 10:51:43 SQL Data In: ORACLE - Param = 28, Name = AS_BZJSLX, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 95 10:51:43 SQL Data In: ORACLE - Param = 29, Name = as_SFDYFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 96 10:51:43 SQL Data In: ORACLE - Param = 30, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 97 10:51:43 SQL Data In: ORACLE - Param = 31, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 98 10:51:43 SQL Data In: ORACLE - Param = 32, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 99 10:51:43 SQL Data In: ORACLE - Param = 33, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 100 10:51:43 SQL Data In: ORACLE - Param = 34, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 101 10:51:43 SQL Data In: ORACLE - Param = 35, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 102 10:51:43 SQL Data In: ORACLE - Param = 36, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 103 10:51:43 SQL Data In: ORACLE - Param = 37, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 104 10:51:43 SQL Data In: ORACLE - Param = 38, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 105 10:51:43 SQL Data In: ORACLE - Param = 39, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 106 10:51:43 SQL Data In: ORACLE - Param = 40, Name = AD_SBDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 107 10:51:43 SQL Data In: ORACLE - Param = 41, Name = AD_BJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 108 10:51:43 SQL Data In: ORACLE - Param = 42, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 109 10:51:43 SQL Data In: ORACLE - Param = 43, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 110 10:51:43 SQL Data In: ORACLE - Param = 44, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 111 10:51:43 SQL Data In: ORACLE - Param = 45, Name = AD_HJJE01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 112 10:51:43 SQL Data In: ORACLE - Param = 46, Name = ad_MSTID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 113 10:51:43 SQL Data In: ORACLE - Param = 47, Name = ad_MSTYE0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 114 10:51:43 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_GHH000 => :AS_GHH000,AS_ICKH00 => :AS_ICKH00,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_TSBZBH => :AS_TSBZBH,AS_BZJSLX => :AS_BZJSLX,as_SFDYFP => :as_SFDYFP,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_ZFDJH0 => :AD_ZFDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AD_SBDJH0 => :AD_SBDJH0,AD_BJDJH0 => :AD_BJDJH0,AD_GWYDJH => :AD_GWYDJH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_HJJE01 => :AD_HJJE01,ad_MSTID0 => :ad_MSTID0,ad_MSTYE0 => :ad_MSTYE0); END; 115 10:51:46 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 116 10:51:46 SQL Data In: ORACLE - Param = 2, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 117 10:51:46 SQL Data In: ORACLE - Param = 3, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5199806 118 10:51:46 SQL Data In: ORACLE - Param = 4, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1316987.000000 119 10:51:46 SQL Data In: ORACLE - Param = 5, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 120 10:51:46 SQL Data In: ORACLE - Param = 6, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 121 10:51:46 SQL Execute: ORACLE - BEGIN "SP_SF_WSPYPTS" (PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 122 10:51:46 SQL Data In: ORACLE - Param = 1, Name = PTSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000001000001 123 10:51:46 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 124 10:51:46 SQL Data In: ORACLE - Param = 3, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 125 10:51:46 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5199806 126 10:51:46 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1316987.000000 127 10:51:46 SQL Data In: ORACLE - Param = 6, Name = PYPMCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 128 10:51:46 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 129 10:51:46 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 130 10:51:46 SQL Execute: ORACLE - BEGIN "SP_SF_TSBZWMLTS" (PTSBZBH => :PTSBZBH,PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,PYPMCS0 => :PYPMCS0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 131 10:51:46 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 132 10:51:46 SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 133 10:51:46 SQL Data In: ORACLE - Param = 3, Name = AS_GHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5199806 134 10:51:46 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 闽侯分中心 135 10:51:46 SQL Data In: ORACLE - Param = 5, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1316987.000000 136 10:51:46 SQL Data In: ORACLE - Param = 6, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 137 10:51:46 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 138 10:51:46 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 139 10:51:46 SQL Data In: ORACLE - Param = 9, Name = as_TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000001000001 140 10:51:46 SQL Execute: ORACLE - BEGIN "SP_SF_MZSF00_YBJK00" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_TSBZBH => :as_TSBZBH); END; 141 10:51:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5199806 142 10:51:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 143 10:51:46 SQL Execute: ORACLE - select max(A.GHRQ00) GHRQ00,to_char(sysdate,'YYYYMMDD') DTDATE from SF_BRXXB0 A,SF_BRFY00 b,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.BRID00 = B.BRID00 and A.LBBH00 = B.JFLBID and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and TRIM(A.YBGHH0)<>'0' and a.ghh000=? and A.BRID00 = ? 144 10:51:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 145 10:51:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5199806 146 10:51:46 SQL Execute: ORACLE - select bxlb00 from sf_brxxb0 where brid00= ? and ghh000= ? order by ghid00 desc 147 10:51:50 SQL Execute: ORACLE - select SF_SF_GETFZXMC('本地','闽侯县','闽侯分中心','成年居民') FZXMC0 from dual 148 10:51:50 SQL Execute: ORACLE - select YBLB00 from IC_YBBRLB where YBMC00 = '闽侯分中心' 149 10:51:50 SQL Data In: ORACLE - Param = 1, Name = V_YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 150 10:51:50 SQL Data In: ORACLE - Param = 2, Name = V_YBKH00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = A10866919 151 10:51:50 SQL Data In: ORACLE - Param = 3, Name = V_YBID00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350121194409181229 152 10:51:50 SQL Data In: ORACLE - Param = 4, Name = V_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林剑青 153 10:51:50 SQL Data In: ORACLE - Param = 5, Name = V_ZT0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 有效 154 10:51:50 SQL Execute: ORACLE - BEGIN "SP_IC_YBHMD0_COMMIT" (V_YBZXLB => :V_YBZXLB,V_YBKH00 => :V_YBKH00,V_YBID00 => :V_YBID00,V_XM0000 => :V_XM0000,V_ZT0000 => :V_ZT0000); END; 155 10:51:50 SQL Execute: ORACLE - Update sf_brxxb0 set ybghh0 = '163704367',SYGHH0='0',bxlb00='普通',dblb00='',dblbmc='',GWZHYE=0 where 1 = 1 and ghh000='5199806 ' and brid00 = 3820657 156 10:51:50 SQL Data In: ORACLE - Rows affected = 1 157 10:51:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2760519.000000 158 10:51:50 SQL Execute: ORACLE - select COUNT(*) NUM, NVL(SUM(XMJE00),0) AMOUNT,max(YSXM00) YSXM00 from BM_SFCFMX_TEMP00 where ID0000 = ? 159 10:51:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3820657.000000 160 10:51:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 161 10:51:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160414 162 10:51:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1316987.000000 163 10:51:50 SQL Execute: ORACLE - select count(*) ZJL,nvl(sum(decode(sign(HJJE00),-1,1,0)),0) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 =? and jzrq00>=? and jzrq00<=? and mzid00 in (select mzid00 from sf_jzb000 where jzdh00=? ) 164 10:51:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2760519.000000 165 10:51:50 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'Y' 166 10:51:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2760519.000000 167 10:51:50 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'N' 168 10:51:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2760519.000000 169 10:51:50 SQL Execute: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = ? 170 10:51:50 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 171 10:51:50 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 172 10:51:50 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 173 10:51:50 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 174 10:51:50 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 175 10:51:50 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 176 10:52:14 SQL Execute: ORACLE - rollback 177 10:52:14 SQL Data In: ORACLE - Rows affected = 0