1 18:39:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3582293 2 18:39:21 SQL Execute: ORACLE - select * from VW_PY_MZCFMX where CFLSH0 = ? order by CFID00 3 18:39:21 SQL Execute: ORACLE - select ZWXM00 from VW_PY_BMCKRY where RYZT00=1 and bmbh00=225 4 18:39:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=225 and PYCKBH = 47 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 5 18:39:24 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=225 and PYCKBH = 47 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 6 18:39:26 SQL Execute: ORACLE - select YGBH00 from VW_PY_BMCKRY where RYZT00=1 and bmbh00=225 and ZWXM00='潘林奇' 7 18:39:26 SQL Execute: ORACLE - update YF_MZCF00 set PFR000=206 where CFLSH0 in ( select CFLSH0 from YF_CFDL00 where brid00=1092 and yfbmbh = 225 and pyckbh = 47 and fyckbh = 48 and FYDLXH = '2100') and fyrq00 = to_char(sysdate,'YYYYMMDD') 8 18:39:26 SQL Data In: ORACLE - Rows affected = 0 9 18:39:26 SQL Execute: ORACLE - Commit 10 18:39:26 SQL Data In: ORACLE - Rows affected = 0 11 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 12 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 13 18:39:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18:39:26 14 18:39:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20221108' and '20221108' and FYCKBH = 48 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 15 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 16 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 17 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 18 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 19 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 20 18:39:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20221108' and '20221108' and FYCKBH = 48 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 21 18:39:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20221108' and '20221108' and FYCKBH = 48 and ZT0000 = '3' order by FYDLXH desc ) A 22 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 23 18:39:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6012 24 18:39:26 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000 = ? 25 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 26 18:39:26 SQL Misc: ORACLE - Set stored procedure on or off 27 18:39:26 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 28 18:39:26 SQL Data In: ORACLE - Param = 2, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3582293 29 18:39:26 SQL Data In: ORACLE - Param = 3, Name = PFHRBH0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 206 30 18:39:26 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 206 31 18:39:26 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 225 32 18:39:26 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 33 18:39:26 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 34 18:39:26 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 35 18:39:26 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 36 18:39:26 SQL Data In: ORACLE - Param = 10, Name = PDKFYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 37 18:39:26 SQL Execute: ORACLE - BEGIN "SP_PY_MZPFYCZ" (POPFLAG => :POPFLAG,PCFLSH0 => :PCFLSH0,PFHRBH0 => :PFHRBH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PDKFYBZ => :PDKFYBZ); END; 38 18:39:26 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_YFBMBH' 39 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 40 18:39:26 SQL Execute: ORACLE - commit 41 18:39:26 SQL Data In: ORACLE - Rows affected = 0 42 18:39:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 1092 and rownum = 1 order by GHID00 desc 43 18:39:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18:39:26 44 18:39:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20221108' and '20221108' and FYCKBH = 48 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 45 18:39:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20221108' and '20221108' and FYCKBH = 48 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 46 18:39:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6012 47 18:39:29 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000 = ? 48 18:39:29 SQL Misc: ORACLE - Set stored procedure on or off 49 18:39:29 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 50 18:39:29 SQL Data In: ORACLE - Param = 2, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3582293 51 18:39:29 SQL Data In: ORACLE - Param = 3, Name = PFHRBH0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 206 52 18:39:29 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 206 53 18:39:29 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 225 54 18:39:29 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 55 18:39:29 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 56 18:39:29 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 57 18:39:29 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 58 18:39:29 SQL Data In: ORACLE - Param = 10, Name = PDKFYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 59 18:39:29 SQL Execute: ORACLE - BEGIN "SP_PY_MZPFYCZ" (POPFLAG => :POPFLAG,PCFLSH0 => :PCFLSH0,PFHRBH0 => :PFHRBH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PDKFYBZ => :PDKFYBZ); END; 60 18:39:29 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_YFBMBH' 61 18:39:29 SQL Execute: ORACLE - commit 62 18:39:29 SQL Data In: ORACLE - Rows affected = 0 63 18:39:29 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20221108' and '20221108' and FYCKBH = 48 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 64 18:39:29 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20221108' and '20221108' and FYCKBH = 48 and ZT0000 = '3' order by FYDLXH desc ) A 65 18:39:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3582293 66 18:39:29 SQL Execute: ORACLE - select * from VW_PY_MZCFMX where CFLSH0 = ? order by CFID00 67 18:39:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=225 and PYCKBH = 47 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 68 18:39:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=225 and PYCKBH = 47 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00