1 10:20:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 2 10:20:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 3 10:20:37 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 4 10:20:37 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 5 10:20:37 SQL Execute: ORACLE - select A.FBBH00,A.SFXMID,B.XMMC00 as YYXMMC,A.SFYP00,A.YBZXLB,A.YBXMBH,C.XMMC00 as YBXMMC,A.YBZYFP,A.YBMZFP,A.ZFBL00,A.ZFJE00,A.SFYBXM,A.YBLB00,B.BH0000 as YYXMBH,A.YBBRLB,A.JMBL00,A.JMJE00,A.SFSX00,B.BH0000,trim(substrb(B.BZ0000,1,100)) as BZ0000,decode(B.TZRQ00,null,'0','1') as TZBZ00, B.PYSM00,B.WBSM00,A.BZ0000 as DYBZ00,B.SCCJ00,C.SCCJ00,rpad(nvl(B.FYID00,'0'),6,' ') FYID00,A.BZ0000 as YBBZ00,B.GG0000, decode((Select count(1) as num from BM_GZHCMX aa where aa.SFXMID=a.SFXMID and aa.GZHCID=?),0,'否','是')SFYDB0, DECODE(A.SFYBXM,'Y','医保项目','N','非医保项目') AS SFXM00,SF_GETXMJE('N',A.SFXMID,F.YYDJXH,0,'0','0') AS XMJE00 FROM BM_YBSFDY A,BM_YYSFXM B,BM_YBSFXM C ,BM_YYDJ00 F WHERE 1=1 and A.SFYP00='N' AND A.SFXMID=B.SFXMID AND A.FBBH00=C.FBBH00(+) and A.YBZXLB=C.YBZXLB(+) AND A.YBXMBH=C.XMBH00(+) AND A.YYDJ00=F.YYDJXH(+) and A.FBBH00=? AND A.YBZXLB=? and B.TZRQ00 is null and A.SFXMID not in (Select SFXMID from BM_GZHCMX bb where bb.GZHCID=?) 6 10:20:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 803791.000000 7 10:20:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22321.000000 8 10:20:51 SQL Execute: ORACLE - select * from BM_GHKSTJ where ID0000=? and DYID00=? 9 10:20:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 803791.000000 10 10:20:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22321.000000 11 10:20:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 12 10:20:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 喉上神经封闭术 13 10:20:51 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 031040301500 14 10:20:51 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 031040301500 15 10:20:51 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 喉上神经封闭术 16 10:20:51 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25.000000 17 10:20:51 SQL Execute: ORACLE - insert into BM_GHKSTJ(ID0000,DYID00,GHRQ00,BEIZHU,BEIZH1,BEIZH2,BEIZH3,XMHJ00) values(?,?,?,?,?,?,?,?) 18 10:20:51 SQL Data In: ORACLE - Rows affected = 1 19 10:20:51 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'BM_GHKSTJ' order by 1 ASC, 2 ASC 20 10:20:51 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'BM_GHKSTJ' order by owner ASC, index_name ASC 21 10:20:51 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'INDEX_BM_GHKSTJ_ID0000' order by column_position ASC 22 10:20:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 803791.000000 23 10:20:51 SQL Execute: ORACLE - SELECT "ID0000", "GHRQ00", "XMHJ00", "GHKS01", "GHKS02", "GHKS03", "GHKS04", "GHKS05", "GHKS06", "GHKS07", "GHKS08", "GHKS09", "GHKS10", "GHKS11", "GHKS12", "GHKS13", "GHKS14", "GHKS15", "GHKS16", "GHKS17", "GHKS18", "GHKS19", "GHKS20", "GHKS21", "GHKS22", "GHKS23", "GHKS24", "GHKS25", "GHKS26", "GHKS27", "GHKS28", "GHKS29", "GHKS30", "GHKS31", "GHKS32", "GHKS33", "GHKS34", "GHKS35", "GHKS36", "GHKS37", "GHKS38", "GHKS39", "GHKS40", "GHKS41", "GHKS42", "GHKS43", "GHKS44", "GHKS45", "GHKS46", "GHKS47", "GHKS48", "GHKS49", "GHKS50", "GHKS51", "GHKS52", "GHKS53", "GHKS54", "GHKS55", "GHKS56", "GHKS57", "GHKS58", "GHKS59", "GHKS60", "GHKS61", "GHKS62", "GHKS63", "GHKS64", "GHKS65", "GHKS66", "GHKS67", "GHKS68", "GHKS69", "GHKS70", "GHKS71", "GHKS72", "GHKS73", "GHKS74", "GHKS75", "GHKS76", "GHKS77", "GHKS78", "GHKS79", "GHKS80", "BEIZHU", "DYID00", "GHKS81", "GHKS82", "GHKS83", "GHKS84", "GHKS85", "GHKS86", "GHKS87", "GHKS88", "GHKS89", "GHKS90", "GHKS91", "GHKS92", "GHKS93", "GHKS94", "GHKS95", "GHKS96", "GHKS97", "GHKS98", "GHKS99", "BEIZH1", "BEIZH2", "BEIZH3", "BEIZH4", "BEIZH5", "GHKS100", "GHKS101", "GHKS102", "GHKS103", "GHKS104", "GHKS105", "GHKS106", "GHKS107", "GHKS108", "GHKS109", "GHKS110", "GHKS111", "GHKS112", "GHKS113", "GHKS114", "GHKS115", "GHKS116", "GHKS117", "GHKS118", "GHKS119", "GHKS120", "GHKS121", "GHKS122", "GHKS123", "GHKS124", "GHKS125", "GHKS126", "GHKS127", "GHKS128", "GHKS129", "GHKS130", "GHKS131", "GHKS132", "GHKS133", "GHKS134", "GHKS135", "GHKS136", "GHKS137", "GHKS138", "GHKS139", "GHKS140", "GHKS141", "GHKS142", "GHKS143", "GHKS144", "GHKS145", "GHKS146", "GHKS147", "GHKS148", "GHKS149", "GHKS150", "GHKS151", "GHKS152", "GHKS153", "GHKS154", "GHKS155", "GHKS156", "GHKS157", "GHKS158", "GHKS159", "GHKS160", "GHKS161", "GHKS162", "GHKS163", "GHKS164", "GHKS165", "GHKS166", "GHKS167", "GHKS168", "GHKS169", "GHKS170", "GHKS171", "GHKS172", "GHKS173", "GHKS174", "GHKS175", "GHKS176", "GHKS177", "GHKS178", "GHKS179", "GHKS180", "GHKS181", "GHKS182", "GHKS183", "GHKS184", "GHKS185", "GHKS186", "GHKS187", "GHKS188", "GHKS189", "GHKS190", "GHKS191", "GHKS192", "GHKS193", "GHKS194", "GHKS195", "GHKS196", "GHKS197", "GHKS198", "GHKS199", "GHKS200", "DJH000", "BEIZH6", "BEIZH7", "BEIZH8", "BEIZH9", "BEIZH10" FROM "BM_GHKSTJ" WHERE ("ID0000") = (?) 24 10:21:31 SQL Execute: ORACLE - select * from BM_GZHCFL order by GZHCID 25 10:21:31 SQL Execute: ORACLE - select * from BM_GZHCMX where GZHCID = 1 26 10:21:31 SQL Execute: ORACLE - select * from BM_GZHCBZ where GZHCID = 1 27 10:21:31 SQL Execute: ORACLE - select * from BM_GZHCMX where GZHCID = 21 28 10:21:31 SQL Execute: ORACLE - select * from BM_GZHCBZ where GZHCID = 21 29 10:22:23 SQL Execute: ORACLE - select * from bm_bmgz00 a where exists(select 1 from BM_YYSFXM where bmgzid=a.bmgzid and flag00='0') or exists(select 1 from BM_SFXMBZ where bmgzid=a.bmgzid and flag00='0') order by BMGZSH 30 10:22:23 SQL Execute: ORACLE - select * from bm_bmgz00 a where bmgzid=1 order by BMGZSH 31 10:22:23 SQL Execute: ORACLE - select FBBH00,FBMC00 from bm_BRFBB0 where FBBH00>=3 order by FBBH00 32 10:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 33 10:22:23 SQL Execute: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw from ic_ybbrlb where FBBH00=? AND yblb00=ybzxlb 34 10:22:23 SQL Execute: ORACLE - select FBBH00,FBMC00 from bm_BRFBB0 where FBBH00>=3 order by FBBH00 35 10:22:23 SQL Execute: ORACLE - Select SQ_BM_YYSFTJ_ID0000.nextval as ID0000 from dual 36 10:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 37 10:22:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 38 10:22:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 39 10:22:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 40 10:22:23 SQL Execute: ORACLE - Select bh0000,xmmc00,flag00,zjbz00 from bm_yysfxm where bmgzid=? and flag00='0' and sfxmid<9000000000 and ((? = 0) or (? = 1 and not(bmgzid=1 and BH0000 like '9%')) or (? = 2 and bmgzid=1 and BH0000 like '9%')) order by bh0000 41 10:22:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 42 10:22:26 SQL Execute: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw from ic_ybbrlb where FBBH00=? AND yblb00=ybzxlb 43 10:22:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 44 10:22:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 45 10:22:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 46 10:22:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 47 10:22:26 SQL Execute: ORACLE - select A.FBBH00,A.SFXMID,B.XMMC00 as YYXMMC,A.SFYP00,A.YBZXLB,A.YBXMBH,C.XMMC00 as YBXMMC,A.YBZYFP,A.YBMZFP,A.ZFBL00,A.ZFJE00,A.SFYBXM,A.YBLB00,B.BH0000 as YYXMBH,A.YBBRLB,A.JMBL00,A.JMJE00,A.SFSX00,B.BH0000,trim(substrb(B.BZ0000,1,100)) as BZ0000,decode(B.TZRQ00,null,'0','1') as TZBZ00, B.PYSM00,B.WBSM00,A.BZ0000 as DYBZ00,B.SCCJ00,C.SCCJ00,rpad(nvl(B.FYID00,'0'),6,' ') FYID00,A.BZ0000 as YBBZ00,B.GG0000, decode((Select count(1) as num from BM_GZHCMX aa where aa.SFXMID=a.SFXMID and aa.GZHCID=?),0,'否','是')SFYDB0, DECODE(A.SFYBXM,'Y','医保项目','N','非医保项目') AS SFXM00,SF_GETXMJE('N',A.SFXMID,F.YYDJXH,0,'0','0') AS XMJE00 FROM BM_YBSFDY A,BM_YYSFXM B,BM_YBSFXM C ,BM_YYDJ00 F WHERE 1=1 and A.SFYP00='N' AND A.SFXMID=B.SFXMID AND A.FBBH00=C.FBBH00(+) and A.YBZXLB=C.YBZXLB(+) AND A.YBXMBH=C.XMBH00(+) AND A.YYDJ00=F.YYDJXH(+) and A.FBBH00=? AND A.YBZXLB=? and B.TZRQ00 is null and A.SFXMID not in (Select SFXMID from BM_GZHCMX bb where bb.GZHCID=?) 48 10:22:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 49 10:22:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 50 10:22:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 51 10:22:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 52 10:22:35 SQL Execute: ORACLE - select A.FBBH00,A.SFXMID,B.XMMC00 as YYXMMC,A.SFYP00,A.YBZXLB,A.YBXMBH,C.XMMC00 as YBXMMC,A.YBZYFP,A.YBMZFP,A.ZFBL00,A.ZFJE00,A.SFYBXM,A.YBLB00,B.BH0000 as YYXMBH,A.YBBRLB,A.JMBL00,A.JMJE00,A.SFSX00,B.BH0000,trim(substrb(B.BZ0000,1,100)) as BZ0000,decode(B.TZRQ00,null,'0','1') as TZBZ00, B.PYSM00,B.WBSM00,A.BZ0000 as DYBZ00,B.SCCJ00,C.SCCJ00,rpad(nvl(B.FYID00,'0'),6,' ') FYID00,A.BZ0000 as YBBZ00,B.GG0000, decode((Select count(1) as num from BM_GZHCMX aa where aa.SFXMID=a.SFXMID and aa.GZHCID=?),0,'否','是')SFYDB0, DECODE(A.SFYBXM,'Y','医保项目','N','非医保项目') AS SFXM00,SF_GETXMJE('N',A.SFXMID,F.YYDJXH,0,'0','0') AS XMJE00 FROM BM_YBSFDY A,BM_YYSFXM B,BM_YBSFXM C ,BM_YYDJ00 F WHERE 1=1 and A.SFYP00='N' AND A.SFXMID=B.SFXMID AND A.FBBH00=C.FBBH00(+) and A.YBZXLB=C.YBZXLB(+) AND A.YBXMBH=C.XMBH00(+) AND A.YYDJ00=F.YYDJXH(+) and A.FBBH00=? AND A.YBZXLB=? and B.TZRQ00 is null and A.SFXMID in (Select SFXMID from BM_GZHCMX bb where bb.GZHCID=?) 53 10:22:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 54 10:22:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 55 10:22:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 56 10:22:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 57 10:22:49 SQL Execute: ORACLE - select A.FBBH00,A.SFXMID,B.XMMC00 as YYXMMC,A.SFYP00,A.YBZXLB,A.YBXMBH,C.XMMC00 as YBXMMC,A.YBZYFP,A.YBMZFP,A.ZFBL00,A.ZFJE00,A.SFYBXM,A.YBLB00,B.BH0000 as YYXMBH,A.YBBRLB,A.JMBL00,A.JMJE00,A.SFSX00,B.BH0000,trim(substrb(B.BZ0000,1,100)) as BZ0000,decode(B.TZRQ00,null,'0','1') as TZBZ00, B.PYSM00,B.WBSM00,A.BZ0000 as DYBZ00,B.SCCJ00,C.SCCJ00,rpad(nvl(B.FYID00,'0'),6,' ') FYID00,A.BZ0000 as YBBZ00,B.GG0000, decode((Select count(1) as num from BM_GZHCMX aa where aa.SFXMID=a.SFXMID and aa.GZHCID=?),0,'否','是')SFYDB0, DECODE(A.SFYBXM,'Y','医保项目','N','非医保项目') AS SFXM00,SF_GETXMJE('N',A.SFXMID,F.YYDJXH,0,'0','0') AS XMJE00 FROM BM_YBSFDY A,BM_YYSFXM B,BM_YBSFXM C ,BM_YYDJ00 F WHERE 1=1 and A.SFYP00='N' AND A.SFXMID=B.SFXMID AND A.FBBH00=C.FBBH00(+) and A.YBZXLB=C.YBZXLB(+) AND A.YBXMBH=C.XMBH00(+) AND A.YYDJ00=F.YYDJXH(+) and A.FBBH00=? AND A.YBZXLB=? and B.TZRQ00 is null and A.SFXMID not in (Select SFXMID from BM_GZHCMX bb where bb.GZHCID=?) 58 10:23:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 803793.000000 59 10:23:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22321.000000 60 10:23:02 SQL Execute: ORACLE - select * from BM_GHKSTJ where ID0000=? and DYID00=? 61 10:23:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 803793.000000 62 10:23:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22321.000000 63 10:23:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 64 10:23:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 喉上神经封闭术 65 10:23:02 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 031040301500 66 10:23:02 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 031040301500 67 10:23:02 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 喉上神经封闭术 68 10:23:02 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25.000000 69 10:23:02 SQL Execute: ORACLE - insert into BM_GHKSTJ(ID0000,DYID00,GHRQ00,BEIZHU,BEIZH1,BEIZH2,BEIZH3,XMHJ00) values(?,?,?,?,?,?,?,?) 70 10:23:02 SQL Data In: ORACLE - Rows affected = 1 71 10:23:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 803793.000000 72 10:23:02 SQL Execute: ORACLE - SELECT "ID0000", "GHRQ00", "XMHJ00", "GHKS01", "GHKS02", "GHKS03", "GHKS04", "GHKS05", "GHKS06", "GHKS07", "GHKS08", "GHKS09", "GHKS10", "GHKS11", "GHKS12", "GHKS13", "GHKS14", "GHKS15", "GHKS16", "GHKS17", "GHKS18", "GHKS19", "GHKS20", "GHKS21", "GHKS22", "GHKS23", "GHKS24", "GHKS25", "GHKS26", "GHKS27", "GHKS28", "GHKS29", "GHKS30", "GHKS31", "GHKS32", "GHKS33", "GHKS34", "GHKS35", "GHKS36", "GHKS37", "GHKS38", "GHKS39", "GHKS40", "GHKS41", "GHKS42", "GHKS43", "GHKS44", "GHKS45", "GHKS46", "GHKS47", "GHKS48", "GHKS49", "GHKS50", "GHKS51", "GHKS52", "GHKS53", "GHKS54", "GHKS55", "GHKS56", "GHKS57", "GHKS58", "GHKS59", "GHKS60", "GHKS61", "GHKS62", "GHKS63", "GHKS64", "GHKS65", "GHKS66", "GHKS67", "GHKS68", "GHKS69", "GHKS70", "GHKS71", "GHKS72", "GHKS73", "GHKS74", "GHKS75", "GHKS76", "GHKS77", "GHKS78", "GHKS79", "GHKS80", "BEIZHU", "DYID00", "GHKS81", "GHKS82", "GHKS83", "GHKS84", "GHKS85", "GHKS86", "GHKS87", "GHKS88", "GHKS89", "GHKS90", "GHKS91", "GHKS92", "GHKS93", "GHKS94", "GHKS95", "GHKS96", "GHKS97", "GHKS98", "GHKS99", "BEIZH1", "BEIZH2", "BEIZH3", "BEIZH4", "BEIZH5", "GHKS100", "GHKS101", "GHKS102", "GHKS103", "GHKS104", "GHKS105", "GHKS106", "GHKS107", "GHKS108", "GHKS109", "GHKS110", "GHKS111", "GHKS112", "GHKS113", "GHKS114", "GHKS115", "GHKS116", "GHKS117", "GHKS118", "GHKS119", "GHKS120", "GHKS121", "GHKS122", "GHKS123", "GHKS124", "GHKS125", "GHKS126", "GHKS127", "GHKS128", "GHKS129", "GHKS130", "GHKS131", "GHKS132", "GHKS133", "GHKS134", "GHKS135", "GHKS136", "GHKS137", "GHKS138", "GHKS139", "GHKS140", "GHKS141", "GHKS142", "GHKS143", "GHKS144", "GHKS145", "GHKS146", "GHKS147", "GHKS148", "GHKS149", "GHKS150", "GHKS151", "GHKS152", "GHKS153", "GHKS154", "GHKS155", "GHKS156", "GHKS157", "GHKS158", "GHKS159", "GHKS160", "GHKS161", "GHKS162", "GHKS163", "GHKS164", "GHKS165", "GHKS166", "GHKS167", "GHKS168", "GHKS169", "GHKS170", "GHKS171", "GHKS172", "GHKS173", "GHKS174", "GHKS175", "GHKS176", "GHKS177", "GHKS178", "GHKS179", "GHKS180", "GHKS181", "GHKS182", "GHKS183", "GHKS184", "GHKS185", "GHKS186", "GHKS187", "GHKS188", "GHKS189", "GHKS190", "GHKS191", "GHKS192", "GHKS193", "GHKS194", "GHKS195", "GHKS196", "GHKS197", "GHKS198", "GHKS199", "GHKS200", "DJH000", "BEIZH6", "BEIZH7", "BEIZH8", "BEIZH9", "BEIZH10" FROM "BM_GHKSTJ" WHERE ("ID0000") = (?) 73 10:23:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 74 10:23:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 803793.000000 75 10:23:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 76 10:23:12 SQL Execute: ORACLE - insert into BM_GZHCMX(HCMXID,GZHCID,SFXMID,SFXMBH,SFXMMC,YBXMBH,YBXMMC,DJ0000,SFFSYB) select SQ_BM_GZHCMX_HCMXID.nextval,?,DYID00,substrb(BEIZH1,1,40),substrb(BEIZHU,1,40),substrb(BEIZH2,1,40),substrb(BEIZH3,1,40),0,1 from BM_GHKSTJ a where a.ID0000=? and a.DYID00 not in (select SFXMID from BM_GZHCMX aa where aa.GZHCID=? ) 77 10:23:12 SQL Data In: ORACLE - Rows affected = 1 78 10:23:12 SQL Execute: ORACLE - commit 79 10:23:12 SQL Data In: ORACLE - Rows affected = 0 80 10:23:14 SQL Execute: ORACLE - select * from BM_GZHCFL order by GZHCID 81 10:23:14 SQL Execute: ORACLE - select * from BM_GZHCMX where GZHCID = 1 82 10:23:14 SQL Execute: ORACLE - select * from BM_GZHCBZ where GZHCID = 1 83 10:23:14 SQL Execute: ORACLE - select * from BM_GZHCMX where GZHCID = 21 84 10:23:14 SQL Execute: ORACLE - select * from BM_GZHCBZ where GZHCID = 21