1 16:59:56 SQL Prepare: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 2 16:59:56 SQL Execute: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 3 16:59:56 SQL Prepare: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 4 16:59:56 SQL Execute: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 5 16:59:56 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 6 16:59:56 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5498256 7 16:59:56 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 8 16:59:56 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 9 16:59:56 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 10 16:59:56 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 030 11 16:59:56 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 236.000000 12 16:59:56 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 13 16:59:56 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 14 16:59:56 SQL Prepare: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 15 16:59:56 SQL Execute: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 16 16:59:56 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 17 16:59:56 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 18 16:59:56 SQL Prepare: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 19 16:59:56 SQL Execute: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 20 16:59:56 SQL Prepare: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 21 16:59:56 SQL Execute: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 22 16:59:56 SQL Data In: ORACLE - Rows affected = 1 23 16:59:56 SQL Prepare: ORACLE - commit 24 16:59:56 SQL Execute: ORACLE - commit 25 16:59:56 SQL Data In: ORACLE - Rows affected = 0 26 16:59:58 SQL Prepare: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 27 16:59:58 SQL Execute: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 28 16:59:58 SQL Prepare: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='1567836' and rownum=1 29 16:59:58 SQL Execute: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='1567836' and rownum=1 30 16:59:58 SQL Prepare: ORACLE - update JY_YW0000 set QDXH00='1189' where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 31 16:59:58 SQL Execute: ORACLE - update JY_YW0000 set QDXH00='1189' where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 32 16:59:58 SQL Data In: ORACLE - Rows affected = 1 33 16:59:58 SQL Prepare: ORACLE - commit 34 16:59:58 SQL Execute: ORACLE - commit 35 16:59:58 SQL Data In: ORACLE - Rows affected = 0 36 16:59:58 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 16:59:58 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 16:59:58 SQL Prepare: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 39 16:59:58 SQL Execute: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 40 16:59:58 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '' 41 16:59:58 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '' 42 16:59:58 SQL Prepare: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='0' order by SQRQ00 DESC,TXM000 43 16:59:58 SQL Execute: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='0' order by SQRQ00 DESC,TXM000 44 16:59:59 SQL Prepare: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='1' order by SQRQ00 DESC,TXM000 45 16:59:59 SQL Execute: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='1' order by SQRQ00 DESC,TXM000 46 17:00:16 SQL Prepare: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 47 17:00:16 SQL Execute: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 48 17:00:16 SQL Prepare: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 49 17:00:16 SQL Execute: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 50 17:00:16 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 51 17:00:16 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5498256 52 17:00:16 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 53 17:00:16 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 54 17:00:16 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 55 17:00:16 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 030 56 17:00:16 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 236.000000 57 17:00:16 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 58 17:00:16 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 59 17:00:16 SQL Prepare: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 60 17:00:16 SQL Execute: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 61 17:00:16 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 62 17:00:16 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 63 17:00:16 SQL Prepare: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 64 17:00:16 SQL Execute: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 65 17:00:16 SQL Prepare: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 66 17:00:16 SQL Execute: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 67 17:00:16 SQL Data In: ORACLE - Rows affected = 0 68 17:00:16 SQL Prepare: ORACLE - commit 69 17:00:16 SQL Execute: ORACLE - commit 70 17:00:16 SQL Data In: ORACLE - Rows affected = 0 71 17:00:17 SQL Prepare: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 72 17:00:17 SQL Execute: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 73 17:00:17 SQL Prepare: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='1567836' and rownum=1 74 17:00:17 SQL Execute: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='1567836' and rownum=1 75 17:00:17 SQL Prepare: ORACLE - update JY_YW0000 set QDXH00='1190' where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 76 17:00:17 SQL Execute: ORACLE - update JY_YW0000 set QDXH00='1190' where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 77 17:00:17 SQL Data In: ORACLE - Rows affected = 1 78 17:00:17 SQL Prepare: ORACLE - commit 79 17:00:17 SQL Execute: ORACLE - commit 80 17:00:17 SQL Data In: ORACLE - Rows affected = 0 81 17:00:17 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 82 17:00:17 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 83 17:00:17 SQL Prepare: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 84 17:00:17 SQL Execute: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 85 17:00:17 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '' 86 17:00:17 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '' 87 17:00:17 SQL Prepare: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='1' order by SQRQ00 DESC,TXM000 88 17:00:17 SQL Execute: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='1' order by SQRQ00 DESC,TXM000 89 17:00:19 SQL Prepare: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 90 17:00:19 SQL Execute: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 91 17:00:19 SQL Prepare: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 92 17:00:19 SQL Execute: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 93 17:00:19 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 94 17:00:19 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5498256 95 17:00:19 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 96 17:00:19 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 97 17:00:19 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 98 17:00:19 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 030 99 17:00:19 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 236.000000 100 17:00:19 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 101 17:00:19 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 102 17:00:19 SQL Prepare: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 103 17:00:19 SQL Execute: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 104 17:00:19 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 105 17:00:19 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 106 17:00:19 SQL Prepare: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 107 17:00:19 SQL Execute: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 108 17:00:19 SQL Prepare: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 109 17:00:19 SQL Execute: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 110 17:00:19 SQL Data In: ORACLE - Rows affected = 0 111 17:00:19 SQL Prepare: ORACLE - commit 112 17:00:19 SQL Execute: ORACLE - commit 113 17:00:19 SQL Data In: ORACLE - Rows affected = 0 114 17:00:20 SQL Prepare: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 115 17:00:20 SQL Execute: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 116 17:00:20 SQL Prepare: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='1567836' and rownum=1 117 17:00:20 SQL Execute: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='1567836' and rownum=1 118 17:00:20 SQL Prepare: ORACLE - update JY_YW0000 set QDXH00='1191' where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 119 17:00:20 SQL Execute: ORACLE - update JY_YW0000 set QDXH00='1191' where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 120 17:00:20 SQL Data In: ORACLE - Rows affected = 1 121 17:00:20 SQL Prepare: ORACLE - commit 122 17:00:20 SQL Execute: ORACLE - commit 123 17:00:20 SQL Data In: ORACLE - Rows affected = 0 124 17:00:20 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 125 17:00:20 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 126 17:00:20 SQL Prepare: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 127 17:00:20 SQL Execute: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 128 17:00:20 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '' 129 17:00:20 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '' 130 17:00:20 SQL Prepare: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='1' order by SQRQ00 DESC,TXM000 131 17:00:20 SQL Execute: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='1' order by SQRQ00 DESC,TXM000 132 17:00:21 SQL Prepare: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 133 17:00:21 SQL Execute: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 134 17:00:21 SQL Prepare: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 135 17:00:21 SQL Execute: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 136 17:00:21 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 137 17:00:21 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5498256 138 17:00:21 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 139 17:00:21 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 140 17:00:21 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 141 17:00:21 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 030 142 17:00:21 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 236.000000 143 17:00:21 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 144 17:00:21 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 145 17:00:21 SQL Prepare: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 146 17:00:21 SQL Execute: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 147 17:00:21 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 148 17:00:21 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 149 17:00:21 SQL Prepare: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 150 17:00:21 SQL Execute: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 151 17:00:21 SQL Prepare: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 152 17:00:21 SQL Execute: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 153 17:00:21 SQL Data In: ORACLE - Rows affected = 0 154 17:00:21 SQL Prepare: ORACLE - commit 155 17:00:21 SQL Execute: ORACLE - commit 156 17:00:21 SQL Data In: ORACLE - Rows affected = 0 157 17:00:22 SQL Prepare: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 158 17:00:22 SQL Execute: ORACLE - select SEQ_JY_YW0000_QDXH00.NEXTVAL QDXH00 from dual 159 17:00:22 SQL Prepare: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='1567836' and rownum=1 160 17:00:22 SQL Execute: ORACLE - select BRID00 from jy_yw0000 where MZZYBZ='0' and ZYHGHH='1567836' and rownum=1 161 17:00:22 SQL Prepare: ORACLE - update JY_YW0000 set QDXH00='1192' where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 162 17:00:22 SQL Execute: ORACLE - update JY_YW0000 set QDXH00='1192' where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 163 17:00:22 SQL Data In: ORACLE - Rows affected = 1 164 17:00:22 SQL Prepare: ORACLE - commit 165 17:00:22 SQL Execute: ORACLE - commit 166 17:00:22 SQL Data In: ORACLE - Rows affected = 0 167 17:00:22 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 168 17:00:22 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 169 17:00:22 SQL Prepare: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 170 17:00:22 SQL Execute: ORACLE - select DISTINCT MZZYBZ,ZYHGHH from JY_YW0000 where MZZYBZ='0' and jgzt00='1' and BRID00='317273' and YJDJH0 in ('0','5498256') 171 17:00:22 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '' 172 17:00:22 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '' 173 17:00:22 SQL Prepare: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='1' order by SQRQ00 DESC,TXM000 174 17:00:22 SQL Execute: ORACLE - select ZLXMID,ZLXMJC,TXMQZ0,TXMYSZ,TXM000,BBMC00,BBCJL0,BBSM00,ZJE000,BBID00,0 KDYS00,SQRQ00 KDRQ00,SQSJ00 KDSJ00,SQYSXM,YJFZH0,YJDJH0,JGZT00,THYY00,SQYS00 from VW_JY_BBCJXX b where BRID00= '317273' and MZZYBZ='0' and SQRQ00 between '20110518' and '20110522' and JGZT00='1' order by SQRQ00 DESC,TXM000 175 17:00:23 SQL Prepare: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 176 17:00:23 SQL Execute: ORACLE - select SF_SF_HQQFXX('317273',' ','5498256',' ',0,0,0) from dual 177 17:00:23 SQL Prepare: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 178 17:00:23 SQL Execute: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=5498256 179 17:00:23 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 180 17:00:23 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5498256 181 17:00:23 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 182 17:00:23 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 183 17:00:23 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 184 17:00:23 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 030 185 17:00:23 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 236.000000 186 17:00:23 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 187 17:00:23 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 188 17:00:23 SQL Prepare: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 189 17:00:23 SQL Execute: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=5498256 190 17:00:23 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 191 17:00:23 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT') and YGBH00 = 610 192 17:00:23 SQL Prepare: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 193 17:00:23 SQL Execute: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,'0' qdsj00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,JZBZ00,YBSM00,TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI') CYRQSJ,BBMC00, CH0000,txm000,trim(XMMC00) XMMC00,YBTJ00,BRLB00,trim(BMMC00) BMMC00,ZYHGHH,sqys00,sqysxm from VW_JY_TXMCJD a where YJDJH0 in('0','5498256') 194 17:00:23 SQL Prepare: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 195 17:00:23 SQL Execute: ORACLE - update JY_YW0000 A set BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',BBCJR0='610' where txm000 in (select txm000 from jy_yw0000 where YJDJH0 in ('0','5498256')) and BBCYRQ IS NULL AND JGZT00='0' 196 17:00:23 SQL Data In: ORACLE - Rows affected = 0 197 17:00:23 SQL Prepare: ORACLE - commit 198 17:00:23 SQL Execute: ORACLE - commit 199 17:00:23 SQL Data In: ORACLE - Rows affected = 0