1 11:28:44 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227582.000000 2 11:28:44 SQL Data In: ORACLE - Param = 2, Name = AD_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12718028.000000 3 11:28:44 SQL Data In: ORACLE - Param = 3, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 00000013 4 11:28:44 SQL Data In: ORACLE - Param = 4, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5 11:28:44 SQL Data In: ORACLE - Param = 5, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 6 11:28:44 SQL Execute: ORACLE - BEGIN "SP_SF_TSBZ00_REG000" (AD_BRID00 => :AD_BRID00,AD_GHID00 => :AD_GHID00,AS_TSBZBH => :AS_TSBZBH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 7 11:28:44 SQL Execute: ORACLE - select * from bm_brjflb where jflbmc = '现金结算' 8 11:28:44 SQL Data In: ORACLE - Param = 1, Name = AD_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12718028.000000 9 11:28:44 SQL Data In: ORACLE - Param = 2, Name = AD_CZBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 10 11:28:44 SQL Data In: ORACLE - Param = 3, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 11 11:28:44 SQL Data In: ORACLE - Param = 4, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 12 11:28:44 SQL Data In: ORACLE - Param = 5, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 13 11:28:44 SQL Execute: ORACLE - BEGIN "SP_SF_YJJGHZXJ_EDIT00" (AD_GHID00 => :AD_GHID00,AD_CZBZ00 => :AD_CZBZ00,AD_DJH000 => :AD_DJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 14 11:28:44 SQL Execute: ORACLE - select e.bh0000 fpbh00,e.xmmc00 fpxmmc,c.qzfje0,c.gfje00,c.xmbh00, c.xmmc00,c.xmgg00,c.xmdw00,c.xmsl00,c.xmdj00,C.HJJE00,C.KDKS00, B.BMMC00 KDKSMC,C.KDYS00,F.ZWXM00 KDYSXM from SF_BRFY00 A,BM_BMBM00 B,SF_FYMX00 C,BM_YYSFXM D,BM_FPXM00 E,BM_YGBM00 F where A.DJH000 = C.DJH000 and C.KDKS00 = B.BMBH00 and C.xmbh00 = D.SFXMID and D.MZFPID = E.FPXMID and c.kdys00=f.ygbh00 and c.djh000=36663162 15 11:28:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20007.000000 16 11:28:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 17 11:28:44 SQL Execute: ORACLE - select * from VW_SF_YBSFDY where SFXMID =? and YBZXLB=? and SFYP00 ='N' 18 11:28:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20014.000000 19 11:28:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 20 11:28:44 SQL Execute: ORACLE - select * from VW_SF_YBSFDY where SFXMID =? and YBZXLB=? and SFYP00 ='N' 21 11:28:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 22 11:28:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227582.000000 23 11:28:44 SQL Execute: ORACLE - select A.ZYE000,A.YXQFJE,A.JFLBID,A.YBZHYE from SF_BRZHXX A where A.JFLBID=? and A.BRID00 =? 24 11:28:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227582.000000 25 11:28:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7040621 26 11:28:44 SQL Execute: ORACLE - select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ? and cfyjbz = '0' and A.GHH000 = ? 27 11:28:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227582.000000 28 11:28:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7040621 29 11:28:45 SQL Execute: ORACLE - select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ? and cfyjbz = '1' and A.GHH000 = ? 30 11:28:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 31 11:28:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227582.000000 32 11:28:45 SQL Execute: ORACLE - select B.JFLBMC,A.* from sf_brzhxx A,BM_BRJFLB B where A.JFLBID = B.JFLBID and A.JFLBID = ? and BRID00 = ? 33 11:28:45 SQL Execute: ORACLE - select * from bm_brjflb where jflbmc = '现金结算' 34 11:28:45 SQL Data In: ORACLE - Param = 1, Name = AD_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12718028.000000 35 11:28:45 SQL Data In: ORACLE - Param = 2, Name = AD_CZBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 36 11:28:45 SQL Data In: ORACLE - Param = 3, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 37 11:28:45 SQL Data In: ORACLE - Param = 4, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 38 11:28:45 SQL Data In: ORACLE - Param = 5, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 11:28:45 SQL Execute: ORACLE - BEGIN "SP_SF_YJJGHZXJ_EDIT00" (AD_GHID00 => :AD_GHID00,AD_CZBZ00 => :AD_CZBZ00,AD_DJH000 => :AD_DJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 40 11:28:45 SQL Execute: ORACLE - select e.bh0000 fpbh00,e.xmmc00 fpxmmc,c.qzfje0,c.gfje00,c.xmbh00, c.xmmc00,c.xmgg00,c.xmdw00,c.xmsl00,c.xmdj00,C.HJJE00,C.KDKS00, B.BMMC00 KDKSMC,C.KDYS00,F.ZWXM00 KDYSXM from SF_BRFY00 A,BM_BMBM00 B,SF_FYMX00 C,BM_YYSFXM D,BM_FPXM00 E,BM_YGBM00 F where A.DJH000 = C.DJH000 and C.KDKS00 = B.BMBH00 and C.xmbh00 = D.SFXMID and D.MZFPID = E.FPXMID and c.kdys00=f.ygbh00 and c.djh000=36663162 41 11:28:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20007.000000 42 11:28:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 43 11:28:45 SQL Execute: ORACLE - select * from VW_SF_YBSFDY where SFXMID =? and YBZXLB=? and SFYP00 ='N' 44 11:28:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20014.000000 45 11:28:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 46 11:28:45 SQL Execute: ORACLE - select * from VW_SF_YBSFDY where SFXMID =? and YBZXLB=? and SFYP00 ='N' 47 11:28:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 48 11:28:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227582.000000 49 11:28:45 SQL Execute: ORACLE - select A.ZYE000,A.YXQFJE,A.JFLBID,A.YBZHYE from SF_BRZHXX A where A.JFLBID=? and A.BRID00 =? 50 11:28:45 SQL Data In: ORACLE - Param = 1, Name = AD_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12718028.000000 51 11:28:45 SQL Data In: ORACLE - Param = 2, Name = AD_CZBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 52 11:28:45 SQL Data In: ORACLE - Param = 3, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 53 11:28:45 SQL Data In: ORACLE - Param = 4, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 54 11:28:45 SQL Data In: ORACLE - Param = 5, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 55 11:28:45 SQL Execute: ORACLE - BEGIN "SP_SF_YJJGHZXJ_EDIT00" (AD_GHID00 => :AD_GHID00,AD_CZBZ00 => :AD_CZBZ00,AD_DJH000 => :AD_DJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 56 11:28:45 SQL Execute: ORACLE - select e.bh0000 fpbh00,e.xmmc00 fpxmmc,c.qzfje0,c.gfje00,c.xmbh00, c.xmmc00,c.xmgg00,c.xmdw00,c.xmsl00,c.xmdj00,C.HJJE00,C.KDKS00, B.BMMC00 KDKSMC,C.KDYS00,F.ZWXM00 KDYSXM from SF_BRFY00 A,BM_BMBM00 B,SF_FYMX00 C,BM_YYSFXM D,BM_FPXM00 E,BM_YGBM00 F where A.DJH000 = C.DJH000 and C.KDKS00 = B.BMBH00 and C.xmbh00 = D.SFXMID and D.MZFPID = E.FPXMID and c.kdys00=f.ygbh00 and c.djh000=36663162 57 11:28:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20007.000000 58 11:28:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 59 11:28:45 SQL Execute: ORACLE - select * from VW_SF_YBSFDY where SFXMID =? and YBZXLB=? and SFYP00 ='N' 60 11:28:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20014.000000 61 11:28:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 62 11:28:45 SQL Execute: ORACLE - select * from VW_SF_YBSFDY where SFXMID =? and YBZXLB=? and SFYP00 ='N' 63 11:28:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227582.000000 64 11:28:45 SQL Execute: ORACLE - select YBSBK0 from VW_SF_BRZHXX where brid00= ? 65 11:28:45 SQL Execute: ORACLE - select a.*,(select FBMC00 from BM_BRFBB0 where FBBH00=a.FBBH00 ) FBMC00 from bm_ybbrlb a,SF_BRXXB0 b where instr(',N,',','||to_char(a.FBBH00)||',')>0 and MZZFSX>0 and b.GHID00=12718028 and a.FBBH00=b.FBBH00