1 09:21:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:21:21 2 09:21:20 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 3 09:21:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 4 09:21:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:21:41 5 09:21:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 6 09:21:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 7 09:22:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:22:01 8 09:22:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 9 09:22:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 10 09:22:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12320651 11 09:22:16 SQL Execute: ORACLE - select a.*,a.CFDW00 as QLDW00 from YF_MZCFMX a where a.CFLSH0=? 12 09:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:22:21 13 09:22:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 14 09:22:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 15 09:22:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 63566768 16 09:22:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 17 09:22:28 SQL Execute: ORACLE - select a.*,round(a.LSDJ00*a.YPZSL0,2) as HJJE00 from YF_YZYPSQ a where a.YZID00=? and a.YYRQ00=? 18 09:22:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:22:41 19 09:22:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 20 09:22:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 21 09:22:54 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '172.23.11.100' and NAME00 = 'QDXTJZ' 22 09:23:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:23:01 23 09:23:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 24 09:23:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 25 09:23:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:23:21 26 09:23:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 27 09:23:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 28 09:23:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:23:41 29 09:23:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 30 09:23:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 31 09:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:24:01 32 09:24:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 33 09:24:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 34 09:24:10 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '中药代煎_需要全送病区部门' and BH0000 = '2272' 35 09:24:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000 36 09:24:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 37 09:24:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 38 09:24:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 39 09:24:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 40 09:24:10 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 41 09:24:10 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 42 09:24:10 SQL Execute: ORACLE - select decode(SYCZY0,NULL,'N','Y') SYBZ00,'N' SFXZ00,0 ID0000,a.* from VW_YF_JYXXB0 a where 1=1 and A.YFBMBH = ? and a.KDJFRQ between ? and ? and a.KDJFRQ||a.KDJFSJ between ? || ? and ? || ? and (a.MZZYBZ = '0' or a.MZZYBZ = '1' and a.SFCYDY='1') and nvl(a.SYDJID,'0')='0' and nvl(a.TYBZ00,'0')<>'1' order by a.MZZYBZ,a.MZFYXH,a.BQBMBH,a.CH0000 43 09:24:10 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '代煎当天不送药原因' and LBBZ00='0' order by XSXH00 44 09:24:12 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '中药代煎_需要全送病区部门' and BH0000 = '2272' 45 09:24:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000 46 09:24:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 47 09:24:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 48 09:24:12 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 49 09:24:12 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 50 09:24:12 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 51 09:24:12 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 52 09:24:12 SQL Execute: ORACLE - select decode(SYCZY0,NULL,'N','Y') SYBZ00,'N' SFXZ00,0 ID0000,a.* from VW_YF_JYXXB0 a where 1=1 and A.YFBMBH = ? and a.KDJFRQ between ? and ? and a.KDJFRQ||a.KDJFSJ between ? || ? and ? || ? and (a.MZZYBZ = '0' or a.MZZYBZ = '1' and a.SFCYDY='1') and nvl(a.DYCS00,0)=0 and nvl(a.SYDJID,'0')='0' and nvl(a.TYBZ00,'0')<>'1' order by a.MZZYBZ,a.MZFYXH,a.BQBMBH,a.CH0000 53 09:24:12 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '代煎当天不送药原因' and LBBZ00='0' order by XSXH00 54 09:24:16 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 55 09:24:16 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527224,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352952) 56 09:24:16 SQL Data In: ORACLE - Rows affected = 1 57 09:24:16 SQL Misc: ORACLE - Set stored procedure on or off 58 09:24:16 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527224 59 09:24:16 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 60 09:24:16 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 61 09:24:16 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 62 09:24:16 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 63 09:24:16 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 64 09:24:16 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 65 09:24:16 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 66 09:24:16 SQL Execute: ORACLE - COMMIT 67 09:24:16 SQL Data In: ORACLE - Rows affected = 0 68 09:24:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527224 69 09:24:16 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 70 09:24:16 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 71 09:24:17 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527224) 72 09:24:17 SQL Data In: ORACLE - Rows affected = 1 73 09:24:17 SQL Execute: ORACLE - commit 74 09:24:17 SQL Data In: ORACLE - Rows affected = 0 75 09:24:18 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 76 09:24:18 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527226,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352951) 77 09:24:18 SQL Data In: ORACLE - Rows affected = 1 78 09:24:18 SQL Misc: ORACLE - Set stored procedure on or off 79 09:24:18 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527226 80 09:24:18 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 81 09:24:18 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 82 09:24:18 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 83 09:24:18 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 84 09:24:18 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 85 09:24:18 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 86 09:24:18 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 87 09:24:18 SQL Execute: ORACLE - COMMIT 88 09:24:18 SQL Data In: ORACLE - Rows affected = 0 89 09:24:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527226 90 09:24:19 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 91 09:24:19 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 92 09:24:19 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527226) 93 09:24:19 SQL Data In: ORACLE - Rows affected = 1 94 09:24:19 SQL Execute: ORACLE - commit 95 09:24:19 SQL Data In: ORACLE - Rows affected = 0 96 09:24:20 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 97 09:24:20 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527227,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352950) 98 09:24:20 SQL Data In: ORACLE - Rows affected = 1 99 09:24:20 SQL Misc: ORACLE - Set stored procedure on or off 100 09:24:20 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527227 101 09:24:20 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 102 09:24:20 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 103 09:24:20 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 104 09:24:20 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 105 09:24:20 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 106 09:24:20 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 107 09:24:20 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 108 09:24:20 SQL Execute: ORACLE - COMMIT 109 09:24:20 SQL Data In: ORACLE - Rows affected = 0 110 09:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527227 111 09:24:21 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 112 09:24:21 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 113 09:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:24:21 114 09:24:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 115 09:24:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 116 09:24:21 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527227) 117 09:24:21 SQL Data In: ORACLE - Rows affected = 1 118 09:24:21 SQL Execute: ORACLE - commit 119 09:24:21 SQL Data In: ORACLE - Rows affected = 0 120 09:24:22 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 121 09:24:22 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527228,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352953) 122 09:24:22 SQL Data In: ORACLE - Rows affected = 1 123 09:24:22 SQL Misc: ORACLE - Set stored procedure on or off 124 09:24:22 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527228 125 09:24:22 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 126 09:24:22 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 127 09:24:22 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 128 09:24:22 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 129 09:24:22 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 130 09:24:22 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 131 09:24:22 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 132 09:24:22 SQL Execute: ORACLE - COMMIT 133 09:24:22 SQL Data In: ORACLE - Rows affected = 0 134 09:24:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527228 135 09:24:23 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 136 09:24:23 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 137 09:24:23 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527228) 138 09:24:23 SQL Data In: ORACLE - Rows affected = 1 139 09:24:23 SQL Execute: ORACLE - commit 140 09:24:23 SQL Data In: ORACLE - Rows affected = 0 141 09:24:24 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 142 09:24:24 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527229,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352949) 143 09:24:24 SQL Data In: ORACLE - Rows affected = 1 144 09:24:24 SQL Misc: ORACLE - Set stored procedure on or off 145 09:24:24 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527229 146 09:24:24 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 147 09:24:24 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 148 09:24:24 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 149 09:24:24 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 150 09:24:24 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 151 09:24:24 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 152 09:24:24 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 153 09:24:24 SQL Execute: ORACLE - COMMIT 154 09:24:24 SQL Data In: ORACLE - Rows affected = 0 155 09:24:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527229 156 09:24:25 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 157 09:24:25 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 158 09:24:25 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527229) 159 09:24:25 SQL Data In: ORACLE - Rows affected = 1 160 09:24:25 SQL Execute: ORACLE - commit 161 09:24:25 SQL Data In: ORACLE - Rows affected = 0 162 09:24:37 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 163 09:24:37 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527230,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 164 09:24:37 SQL Data In: ORACLE - Rows affected = 1 165 09:24:37 SQL Misc: ORACLE - Set stored procedure on or off 166 09:24:37 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527230 167 09:24:37 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 168 09:24:37 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 169 09:24:37 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 170 09:24:37 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 171 09:24:37 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 172 09:24:37 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 173 09:24:37 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 174 09:24:37 SQL Execute: ORACLE - COMMIT 175 09:24:37 SQL Data In: ORACLE - Rows affected = 0 176 09:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527230 177 09:24:37 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 178 09:24:37 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 179 09:24:37 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 180 09:24:37 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527231,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 181 09:24:37 SQL Data In: ORACLE - Rows affected = 1 182 09:24:37 SQL Misc: ORACLE - Set stored procedure on or off 183 09:24:37 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527231 184 09:24:37 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 185 09:24:37 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 186 09:24:37 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 187 09:24:37 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 188 09:24:37 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 189 09:24:37 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 190 09:24:37 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 191 09:24:37 SQL Execute: ORACLE - COMMIT 192 09:24:37 SQL Data In: ORACLE - Rows affected = 0 193 09:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527231 194 09:24:37 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 195 09:24:38 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 196 09:24:38 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 197 09:24:38 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527232,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 198 09:24:38 SQL Data In: ORACLE - Rows affected = 1 199 09:24:38 SQL Misc: ORACLE - Set stored procedure on or off 200 09:24:38 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527232 201 09:24:38 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 202 09:24:38 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 203 09:24:38 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 204 09:24:38 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 205 09:24:38 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 206 09:24:38 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 207 09:24:38 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 208 09:24:38 SQL Execute: ORACLE - COMMIT 209 09:24:38 SQL Data In: ORACLE - Rows affected = 0 210 09:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527232 211 09:24:38 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 212 09:24:38 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 213 09:24:38 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 214 09:24:38 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527233,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 215 09:24:38 SQL Data In: ORACLE - Rows affected = 1 216 09:24:38 SQL Misc: ORACLE - Set stored procedure on or off 217 09:24:38 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527233 218 09:24:38 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 219 09:24:38 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 220 09:24:38 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 221 09:24:38 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 222 09:24:38 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 223 09:24:38 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 224 09:24:38 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 225 09:24:38 SQL Execute: ORACLE - COMMIT 226 09:24:38 SQL Data In: ORACLE - Rows affected = 0 227 09:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527233 228 09:24:38 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 229 09:24:38 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 230 09:24:38 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 231 09:24:38 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527234,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 232 09:24:38 SQL Data In: ORACLE - Rows affected = 1 233 09:24:38 SQL Misc: ORACLE - Set stored procedure on or off 234 09:24:38 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527234 235 09:24:38 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 236 09:24:38 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 237 09:24:38 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 238 09:24:38 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 239 09:24:38 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 240 09:24:38 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 241 09:24:38 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 242 09:24:39 SQL Execute: ORACLE - COMMIT 243 09:24:39 SQL Data In: ORACLE - Rows affected = 0 244 09:24:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527234 245 09:24:39 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 246 09:24:39 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 247 09:24:39 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 248 09:24:39 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527235,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 249 09:24:39 SQL Data In: ORACLE - Rows affected = 1 250 09:24:39 SQL Misc: ORACLE - Set stored procedure on or off 251 09:24:39 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527235 252 09:24:39 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 253 09:24:39 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 254 09:24:39 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 255 09:24:39 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 256 09:24:39 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 257 09:24:39 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 258 09:24:39 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 259 09:24:39 SQL Execute: ORACLE - COMMIT 260 09:24:39 SQL Data In: ORACLE - Rows affected = 0 261 09:24:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527235 262 09:24:39 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 263 09:24:39 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 264 09:24:39 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 265 09:24:39 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527236,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 266 09:24:39 SQL Data In: ORACLE - Rows affected = 1 267 09:24:39 SQL Misc: ORACLE - Set stored procedure on or off 268 09:24:39 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527236 269 09:24:39 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 270 09:24:39 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 271 09:24:39 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 272 09:24:39 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 273 09:24:39 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 274 09:24:39 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 275 09:24:39 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 276 09:24:39 SQL Execute: ORACLE - COMMIT 277 09:24:39 SQL Data In: ORACLE - Rows affected = 0 278 09:24:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527236 279 09:24:40 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 280 09:24:40 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 281 09:24:40 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 282 09:24:40 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527237,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 283 09:24:40 SQL Data In: ORACLE - Rows affected = 1 284 09:24:40 SQL Misc: ORACLE - Set stored procedure on or off 285 09:24:40 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527237 286 09:24:40 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 287 09:24:40 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 288 09:24:40 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 289 09:24:40 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 290 09:24:40 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 291 09:24:40 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 292 09:24:40 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 293 09:24:40 SQL Execute: ORACLE - COMMIT 294 09:24:40 SQL Data In: ORACLE - Rows affected = 0 295 09:24:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527237 296 09:24:40 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 297 09:24:40 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 298 09:24:40 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 299 09:24:40 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527238,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 300 09:24:40 SQL Data In: ORACLE - Rows affected = 1 301 09:24:40 SQL Misc: ORACLE - Set stored procedure on or off 302 09:24:40 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527238 303 09:24:40 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 304 09:24:40 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 305 09:24:40 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 306 09:24:40 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 307 09:24:40 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 308 09:24:40 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 309 09:24:40 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 310 09:24:40 SQL Execute: ORACLE - COMMIT 311 09:24:40 SQL Data In: ORACLE - Rows affected = 0 312 09:24:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527238 313 09:24:40 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 314 09:24:41 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 315 09:24:41 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 316 09:24:41 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527239,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 317 09:24:41 SQL Data In: ORACLE - Rows affected = 1 318 09:24:41 SQL Misc: ORACLE - Set stored procedure on or off 319 09:24:41 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527239 320 09:24:41 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 321 09:24:41 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 322 09:24:41 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 323 09:24:41 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 324 09:24:41 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 325 09:24:41 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 326 09:24:41 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 327 09:24:41 SQL Execute: ORACLE - COMMIT 328 09:24:41 SQL Data In: ORACLE - Rows affected = 0 329 09:24:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527239 330 09:24:41 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 331 09:24:41 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 332 09:24:41 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 333 09:24:41 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527240,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 334 09:24:41 SQL Data In: ORACLE - Rows affected = 1 335 09:24:41 SQL Misc: ORACLE - Set stored procedure on or off 336 09:24:41 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527240 337 09:24:41 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 338 09:24:41 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 339 09:24:41 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 340 09:24:41 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 341 09:24:41 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 342 09:24:41 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 343 09:24:41 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 344 09:24:41 SQL Execute: ORACLE - COMMIT 345 09:24:41 SQL Data In: ORACLE - Rows affected = 0 346 09:24:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527240 347 09:24:41 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 348 09:24:41 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 349 09:24:42 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 350 09:24:42 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527241,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 351 09:24:42 SQL Data In: ORACLE - Rows affected = 1 352 09:24:42 SQL Misc: ORACLE - Set stored procedure on or off 353 09:24:42 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527241 354 09:24:42 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 355 09:24:42 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 356 09:24:42 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 357 09:24:42 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 358 09:24:42 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 359 09:24:42 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 360 09:24:42 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 361 09:24:42 SQL Execute: ORACLE - COMMIT 362 09:24:42 SQL Data In: ORACLE - Rows affected = 0 363 09:24:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527241 364 09:24:42 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 365 09:24:42 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 366 09:24:42 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 367 09:24:42 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527242,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 368 09:24:43 SQL Data In: ORACLE - Rows affected = 1 369 09:24:43 SQL Misc: ORACLE - Set stored procedure on or off 370 09:24:43 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527242 371 09:24:43 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 372 09:24:43 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 373 09:24:43 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 374 09:24:43 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 375 09:24:43 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 376 09:24:43 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 377 09:24:43 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 378 09:24:43 SQL Execute: ORACLE - COMMIT 379 09:24:43 SQL Data In: ORACLE - Rows affected = 0 380 09:24:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527242 381 09:24:43 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 382 09:24:43 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 383 09:24:43 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 384 09:24:43 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527243,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 385 09:24:43 SQL Data In: ORACLE - Rows affected = 1 386 09:24:43 SQL Misc: ORACLE - Set stored procedure on or off 387 09:24:43 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527243 388 09:24:43 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 389 09:24:43 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 390 09:24:43 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 391 09:24:43 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 392 09:24:43 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 393 09:24:43 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 394 09:24:43 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 395 09:24:43 SQL Execute: ORACLE - COMMIT 396 09:24:43 SQL Data In: ORACLE - Rows affected = 0 397 09:24:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527243 398 09:24:43 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 399 09:24:43 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 400 09:24:43 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 401 09:24:43 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527244,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352948) 402 09:24:43 SQL Data In: ORACLE - Rows affected = 1 403 09:24:43 SQL Misc: ORACLE - Set stored procedure on or off 404 09:24:43 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527244 405 09:24:43 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 406 09:24:43 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 407 09:24:43 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 408 09:24:43 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 409 09:24:43 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 410 09:24:43 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 411 09:24:43 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 412 09:24:44 SQL Execute: ORACLE - COMMIT 413 09:24:44 SQL Data In: ORACLE - Rows affected = 0 414 09:24:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527244 415 09:24:44 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 416 09:24:44 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 417 09:24:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:24:44 418 09:24:44 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 419 09:24:44 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 420 09:24:44 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527244) 421 09:24:45 SQL Data In: ORACLE - Rows affected = 1 422 09:24:45 SQL Execute: ORACLE - commit 423 09:24:45 SQL Data In: ORACLE - Rows affected = 0 424 09:24:45 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527243) 425 09:24:45 SQL Data In: ORACLE - Rows affected = 1 426 09:24:45 SQL Execute: ORACLE - commit 427 09:24:45 SQL Data In: ORACLE - Rows affected = 0 428 09:24:45 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527242) 429 09:24:45 SQL Data In: ORACLE - Rows affected = 1 430 09:24:45 SQL Execute: ORACLE - commit 431 09:24:45 SQL Data In: ORACLE - Rows affected = 0 432 09:24:46 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527241) 433 09:24:46 SQL Data In: ORACLE - Rows affected = 1 434 09:24:46 SQL Execute: ORACLE - commit 435 09:24:46 SQL Data In: ORACLE - Rows affected = 0 436 09:24:46 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527240) 437 09:24:46 SQL Data In: ORACLE - Rows affected = 1 438 09:24:46 SQL Execute: ORACLE - commit 439 09:24:46 SQL Data In: ORACLE - Rows affected = 0 440 09:24:47 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527239) 441 09:24:47 SQL Data In: ORACLE - Rows affected = 1 442 09:24:47 SQL Execute: ORACLE - commit 443 09:24:47 SQL Data In: ORACLE - Rows affected = 0 444 09:24:47 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527238) 445 09:24:47 SQL Data In: ORACLE - Rows affected = 1 446 09:24:47 SQL Execute: ORACLE - commit 447 09:24:47 SQL Data In: ORACLE - Rows affected = 0 448 09:24:48 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527237) 449 09:24:48 SQL Data In: ORACLE - Rows affected = 1 450 09:24:48 SQL Execute: ORACLE - commit 451 09:24:48 SQL Data In: ORACLE - Rows affected = 0 452 09:24:48 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527236) 453 09:24:48 SQL Data In: ORACLE - Rows affected = 1 454 09:24:48 SQL Execute: ORACLE - commit 455 09:24:48 SQL Data In: ORACLE - Rows affected = 0 456 09:24:49 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527235) 457 09:24:49 SQL Data In: ORACLE - Rows affected = 1 458 09:24:49 SQL Execute: ORACLE - commit 459 09:24:49 SQL Data In: ORACLE - Rows affected = 0 460 09:24:49 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527234) 461 09:24:49 SQL Data In: ORACLE - Rows affected = 1 462 09:24:49 SQL Execute: ORACLE - commit 463 09:24:49 SQL Data In: ORACLE - Rows affected = 0 464 09:24:50 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527233) 465 09:24:50 SQL Data In: ORACLE - Rows affected = 1 466 09:24:50 SQL Execute: ORACLE - commit 467 09:24:50 SQL Data In: ORACLE - Rows affected = 0 468 09:24:50 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527232) 469 09:24:50 SQL Data In: ORACLE - Rows affected = 1 470 09:24:50 SQL Execute: ORACLE - commit 471 09:24:50 SQL Data In: ORACLE - Rows affected = 0 472 09:24:51 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527231) 473 09:24:51 SQL Data In: ORACLE - Rows affected = 1 474 09:24:51 SQL Execute: ORACLE - commit 475 09:24:51 SQL Data In: ORACLE - Rows affected = 0 476 09:24:51 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527230) 477 09:24:51 SQL Data In: ORACLE - Rows affected = 1 478 09:24:51 SQL Execute: ORACLE - commit 479 09:24:51 SQL Data In: ORACLE - Rows affected = 0 480 09:25:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:25:01 481 09:25:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 482 09:25:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 483 09:25:03 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '中药代煎_需要全送病区部门' and BH0000 = '2272' 484 09:25:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000 485 09:25:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 486 09:25:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 487 09:25:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 488 09:25:03 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 489 09:25:03 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 490 09:25:03 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 491 09:25:03 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000 492 09:25:03 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 493 09:25:03 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 494 09:25:03 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 495 09:25:03 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 496 09:25:03 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 497 09:25:03 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 498 09:25:03 SQL Execute: ORACLE - select TSBMBH,SFXZ00,CYDYMC,SFXZ00,FYDLXH,JSRQSJ,MZFYXH, SYBZ00,JYDH00,MZZYBZ,ZYGHID,CFLSH0,GHH000,BRID00,BRXM00, XB0000,SFCRB0,ZYSFJJ,CSRQ00,PHRQ00,PHDYSJ,PHDYCS,PHCZY0, QYRQ00,QYSJ00,FYRQ00,FYSJ00,PFCZY0,PFRQSJ,LYRQ00,LYSJ00, LYCZY0,JPSJ00,JPKSRQ,JPKSSJ,JPJSSJ,JYJLB0,JYJHM0,JYRQ00, JYKSSJ,JYJSSJ,ECJYRQ,ECJYSJ,BZJLB0,BZJHM0,BZ0000,JZHFZ0, JZHBZ0,JSL000,JZSJ00,ZCYL00,BZGG00,BZCLFL,ZYDJS0,JYCLFL, JYCZY0,SHCZY0,SHJG00,BTGYY0,SHRQ00,SYRQ00,SYSJ00,SYCZY0, JSRQ00,JSSJ00,JSCZY0,BRLYRQ,BRLYSJ,FYCZY0,QXDJRQ,QXDJSJ, DYCS00,ECJSL0,ECJZSJ,SYDYCS,SFQS00,YYRQ00,BQBMBH,CH0000, BQMC00,LYRQSJ,JPRQSJ,JYRQSJ,EJRQSJ,SYRQSJ,PFRXM0,LYCZY1, JYCZY1,SYCZY1,TXM000,MZZYMC,SFCYDY,YPYFMC,QCQQBZ,QSMC00, KDJSJ0,ID0000,SYDJID,SYDJSJ,SYDJR0,SYJSSJ,SYJSR0 from ( select '1' TSBMBH,'N' SFXZ00,CYDYMC,FYDLXH,JSRQSJ,MZFYXH, SYBZ00,JYDH00,MZZYBZ,ZYGHID,CFLSH0,GHH000,BRID00,BRXM00, XB0000,SFCRB0,ZYSFJJ,CSRQ00,PHRQ00,PHDYSJ,PHDYCS,PHCZY0, QYRQ00,QYSJ00,FYRQ00,FYSJ00,PFCZY0,PFRQSJ,LYRQ00,LYSJ00, LYCZY0,JPSJ00,JPKSRQ,JPKSSJ,JPJSSJ,JYJLB0,JYJHM0,JYRQ00, JYKSSJ,JYJSSJ,ECJYRQ,ECJYSJ,BZJLB0,BZJHM0,BZ0000,JZHFZ0, JZHBZ0,JSL000,JZSJ00,ZCYL00,BZGG00,BZCLFL,ZYDJS0,JYCLFL, JYCZY0,SHCZY0,SHJG00,BTGYY0,SHRQ00,SYRQ00,SYSJ00,SYCZY0, JSRQ00,JSSJ00,JSCZY0,BRLYRQ,BRLYSJ,FYCZY0,QXDJRQ,QXDJSJ, DYCS00,ECJSL0,ECJZSJ,SYDYCS,SFQS00,YYRQ00,BQBMBH,CH0000, BQMC00,LYRQSJ,JPRQSJ,JYRQSJ,EJRQSJ,SYRQSJ,PFRXM0,LYCZY1, JYCZY1,SYCZY1,TXM000,MZZYMC,SFCYDY,YPYFMC,QCQQBZ,QSMC00, KDJSJ0,ID0000,SYDJID,SYDJSJ,SYDJR0,SYJSSJ,SYJSR0 from VW_YF_JYXXB0_EX a where 1=1 and A.YFBMBH = ? and a.KDJFRQ between ? and ? and a.KDJFRQ||a.KDJFSJ between ? || ? and ? || ? and a.MZZYBZ = '1' and a.SFCYDY<>'1' and nvl(a.DYCS00,0)=0 and nvl(a.SYDJID,'0')='0' and BQBMBH in (1111) and not exists (select 1 from YF_YZYPSQ where YZID00=a.CFLSH0 and ZCXSL0 >0) union all select '0' TSBMBH,'N' SFXZ00,CYDYMC,FYDLXH,JSRQSJ,MZFYXH, SYBZ00,JYDH00,MZZYBZ,ZYGHID,CFLSH0,GHH000,BRID00,BRXM00, XB0000,SFCRB0,ZYSFJJ,CSRQ00,PHRQ00,PHDYSJ,PHDYCS,PHCZY0, QYRQ00,QYSJ00,FYRQ00,FYSJ00,PFCZY0,PFRQSJ,LYRQ00,LYSJ00, LYCZY0,JPSJ00,JPKSRQ,JPKSSJ,JPJSSJ,JYJLB0,JYJHM0,JYRQ00, JYKSSJ,JYJSSJ,ECJYRQ,ECJYSJ,BZJLB0,BZJHM0,BZ0000,JZHFZ0, JZHBZ0,JSL000,JZSJ00,ZCYL00,BZGG00,BZCLFL,ZYDJS0,JYCLFL, JYCZY0,SHCZY0,SHJG00,BTGYY0,SHRQ00,SYRQ00,SYSJ00,SYCZY0, JSRQ00,JSSJ00,JSCZY0,BRLYRQ,BRLYSJ,FYCZY0,QXDJRQ,QXDJSJ, DYCS00,ECJSL0,ECJZSJ,SYDYCS,SFQS00,YYRQ00,BQBMBH,CH0000, BQMC00,LYRQSJ,JPRQSJ,JYRQSJ,EJRQSJ,SYRQSJ,PFRXM0,LYCZY1, JYCZY1,SYCZY1,TXM000,MZZYMC,SFCYDY,YPYFMC,QCQQBZ,QSMC00, KDJSJ0,ID0000,SYDJID,SYDJSJ,SYDJR0,SYJSSJ,SYJSR0 from VW_YF_JYXXB0_EX a where 1=1 and a.YFBMBH = ? and a.KDJFRQ between ? and ? and a.KDJFRQ||a.KDJFSJ between ? || ? and ? || ? and a.MZZYBZ = '1' and a.SFCYDY<>'1' and nvl(a.DYCS00,0)=0 and nvl(a.SYDJID,'0')='0' and BQBMBH not in (1111) and not exists (select 1 from YF_YZYPSQ where YZID00=a.CFLSH0 and ZCXSL0 >0) ) order by TSBMBH ,MZZYBZ,MZFYXH,BQBMBH,CH0000 499 09:25:03 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '代煎当天不送药原因' and LBBZ00='0' order by XSXH00 500 09:25:06 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 501 09:25:06 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527250,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352954) 502 09:25:06 SQL Data In: ORACLE - Rows affected = 1 503 09:25:06 SQL Misc: ORACLE - Set stored procedure on or off 504 09:25:06 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527250 505 09:25:06 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 506 09:25:06 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 507 09:25:06 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 508 09:25:06 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 509 09:25:06 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 510 09:25:06 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 511 09:25:06 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 512 09:25:06 SQL Execute: ORACLE - COMMIT 513 09:25:06 SQL Data In: ORACLE - Rows affected = 0 514 09:25:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527250 515 09:25:06 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 516 09:25:06 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 517 09:25:06 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 518 09:25:06 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527251,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352954) 519 09:25:06 SQL Data In: ORACLE - Rows affected = 1 520 09:25:06 SQL Misc: ORACLE - Set stored procedure on or off 521 09:25:06 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527251 522 09:25:06 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 523 09:25:06 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 524 09:25:06 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 525 09:25:06 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 526 09:25:06 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 527 09:25:06 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 528 09:25:06 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 529 09:25:06 SQL Execute: ORACLE - COMMIT 530 09:25:06 SQL Data In: ORACLE - Rows affected = 0 531 09:25:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527251 532 09:25:06 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 533 09:25:06 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 534 09:25:06 SQL Execute: ORACLE - Select SQ_YF_YZYPSQ_TEMP_ID0000.NextVal Val from Dual 535 09:25:06 SQL Execute: ORACLE - insert into YF_YZYPSQ_TEMP(ID0000,YZID00,YYRQ00) select 24527252,JYDH00,YYRQ00 from YF_JYXXB0 where JYDH00 in (352954) 536 09:25:07 SQL Data In: ORACLE - Rows affected = 1 537 09:25:07 SQL Misc: ORACLE - Set stored procedure on or off 538 09:25:07 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527252 539 09:25:07 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5042 540 09:25:07 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 541 09:25:07 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 542 09:25:07 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 543 09:25:07 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 544 09:25:07 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 545 09:25:07 SQL Execute: ORACLE - BEGIN "SP_YF_ZYDJBQ_PRINT" (PID0000 => :PID0000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 546 09:25:07 SQL Execute: ORACLE - COMMIT 547 09:25:07 SQL Data In: ORACLE - Rows affected = 0 548 09:25:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24527252 549 09:25:07 SQL Execute: ORACLE - select * from VW_YF_ZYDJBQ WHERE ID0000 = ? and nvl(DYCS00,0)=0 550 09:25:07 SQL Execute: ORACLE - select 5042 as UserId,'06299' as UserCode,'黄炳鸿' as UserName,2272 as UserLogDepId,'中药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'820006' as HospitalCode,'福建中医药大学附属第三人民医院' as HospitalName, '820006' as UserLogDepYYID,'福建中医药大学附属第三人民医院' as UserLogDepYYMC from dual 551 09:25:08 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527252) 552 09:25:08 SQL Data In: ORACLE - Rows affected = 1 553 09:25:08 SQL Execute: ORACLE - commit 554 09:25:08 SQL Data In: ORACLE - Rows affected = 0 555 09:25:08 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527251) 556 09:25:08 SQL Data In: ORACLE - Rows affected = 1 557 09:25:08 SQL Execute: ORACLE - commit 558 09:25:08 SQL Data In: ORACLE - Rows affected = 0 559 09:25:08 SQL Execute: ORACLE - Update YF_JYXXB0 set DYCS00=nvl(DYCS00,0)+1 where JYDH00 in (select YZID00 from YF_YZYPSQ_TEMP where ID0000=24527250) 560 09:25:09 SQL Data In: ORACLE - Rows affected = 1 561 09:25:09 SQL Execute: ORACLE - commit 562 09:25:09 SQL Data In: ORACLE - Rows affected = 0 563 09:25:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:25:21 564 09:25:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 565 09:25:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 566 09:25:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:25:41 567 09:25:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 568 09:25:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 569 09:26:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:26:01 570 09:26:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 571 09:26:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 572 09:26:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:26:21 573 09:26:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 574 09:26:21 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 575 09:26:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:26:41 576 09:26:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 577 09:26:41 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 578 09:27:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:27:01 579 09:27:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 580 09:27:01 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20260228' and '20260228' and FYCKBH = 500 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 581 09:27:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 582 09:27:02 SQL Execute: ORACLE - select TO_CHAR(TO_DATE(?,'YYYYMMDD') - 1,'YYYYMMDD') FROM DUAL 583 09:27:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 584 09:27:02 SQL Execute: ORACLE - select TO_CHAR(TO_DATE(?,'YYYYMMDD'),'YYYYMMDD') FROM DUAL 585 09:27:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 586 09:27:02 SQL Execute: ORACLE - select TO_CHAR(TO_DATE(?,'YYYYMMDD'),'YYYYMMDD') FROM DUAL 587 09:27:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000 588 09:27:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260226 589 09:27:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 590 09:27:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 591 09:27:02 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 592 09:27:02 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 593 09:27:02 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 594 09:27:02 SQL Execute: ORACLE - select a.* from VW_YF_DDJZYDJCF a where 1=1 and a.YFBMBH+0=? and a.FYRQ00 between ? and ? and a.KDJFRQ||a.KDJFSJ between ? || ? and ? || ? 595 09:27:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000 596 09:27:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 597 09:27:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 598 09:27:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260227 599 09:27:02 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 600 09:27:02 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 601 09:27:02 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00 602 09:27:02 SQL Execute: ORACLE - select a.* from VW_YF_JYXXB0 a where 1=1 and a.YFBMBH = ? and a.KDJFRQ between ? and ? and a.KDJFRQ||a.KDJFSJ between ? || ? and ? || ? and nvl(a.SYRQ00,'20991231')='20991231' order by a.JYDH00 desc 603 09:27:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 63568273 604 09:27:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260228 605 09:27:03 SQL Execute: ORACLE - select a.*,round(a.LSDJ00*a.YPZSL0,2) as HJJE00 from YF_YZYPSQ a where a.YZID00=? and a.YYRQ00=?