1 15:23:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 2 15:23:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 3 15:23:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 4 15:23:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 5 15:23:44 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 6 15:23:44 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 7 15:23:44 SQL Execute: ORACLE - select tjrq00,decode(sum(tjjg00),0,100,round(sum(tjjg01)*100/sum(tjjg00),2)) tjjg00 from ( select tjrq00,round(sum(nvl(TJJG00,0)),2) TJJG00,0 tjjg01 from zh_tjzb00 where tjbh00 in('0016','0018') and tjrq00 between ? and ? group by tjrq00 union all select tjrq00,0 tjjg00,(tjjg02-tjjg03) tjjg01 from ( select tjrq00,0 tjjg00,round(sum(nvl(TJJG00,0)),2) tjjg02,0 tjjg03 from zh_tjzb00 where tjbh00 in('0017','0019') and tjrq00 between ? and ? group by tjrq00 union all select tjrq00,0 tjjg00,0 tjjg02,round(sum(nvl(TJJG00,0)),2) tjjg03 from zh_tjzb00 where tjbh00 in('0038','0039') and tjrq00 between ? and ? group by tjrq00)) group by tjrq00 order by tjrq00 8 15:23:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1023 9 15:23:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 10 15:23:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 11 15:23:49 SQL Execute: ORACLE - select TJYF00 tjrq00,nvl(TBZZ00,0) tjjg00 from zh_tjzb01 where tjbh00=? and TJYF00 >= substrb(?,1,6) and TJYF00 <= substrb(?,1,6) and flag00='0' order by TJYF00 12 15:23:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1023 13 15:23:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 14 15:23:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 15 15:23:51 SQL Execute: ORACLE - select tjrq00,nvl(TJJG00,0) tjjg00 from zh_tjzb00 where tjbh00=? and tjrq00 between ? and ? order by tjrq00 16 15:23:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1023 17 15:23:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 18 15:23:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 19 15:23:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 20 15:23:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 21 15:23:52 SQL Execute: ORACLE - select tjksrq||'-'||tjjsrq tjrq00,nvl(TJJG00,0) tjjg00 from zh_ztjzb0 where tjbh00=? and tjksrq between ? and ? and tjjsrq between ? and ? order by tjksrq 22 15:23:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1023 23 15:23:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 24 15:23:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 25 15:23:53 SQL Execute: ORACLE - select TJYF00 tjrq00,nvl(TJJG00,0) tjjg00 from zh_tjzb01 where tjbh00=? and TJYF00 >= substrb(?,1,6) and TJYF00 <= substrb(?,1,6) and flag00='0' order by TJYF00 26 15:23:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0091 27 15:23:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 28 15:23:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 29 15:23:56 SQL Execute: ORACLE - select tjrq00,nvl(TJJG00,0) tjjg00 from zh_tjzb00 where tjbh00=? and tjrq00 between ? and ? order by tjrq00 30 15:23:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0091 31 15:23:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 32 15:23:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 33 15:23:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 34 15:23:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 35 15:23:58 SQL Execute: ORACLE - select tjksrq||'-'||tjjsrq tjrq00,nvl(TJJG00,0) tjjg00 from zh_ztjzb0 where tjbh00=? and tjksrq between ? and ? and tjjsrq between ? and ? order by tjksrq 36 15:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0091 37 15:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 38 15:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 39 15:23:59 SQL Execute: ORACLE - select TJYF00 tjrq00,nvl(TJJG00,0) tjjg00 from zh_tjzb01 where tjbh00=? and TJYF00 >= substrb(?,1,6) and TJYF00 <= substrb(?,1,6) and flag00='0' order by TJYF00 40 15:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0091 41 15:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230214 42 15:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230316 43 15:24:00 SQL Execute: ORACLE - select TJYF00 tjrq00,nvl(TBZZ00,0) tjjg00 from zh_tjzb01 where tjbh00=? and TJYF00 >= substrb(?,1,6) and TJYF00 <= substrb(?,1,6) and flag00='0' order by TJYF00