1 10:13:51 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=20 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 2 10:13:51 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=20 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 3 10:13:51 SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,20,59733,0,'20180705') TS0000 from dual 4 10:13:51 SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,20,59733,0,'20180705') TS0000 from dual 5 10:14:01 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=20 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 6 10:14:01 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=20 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 7 10:14:01 SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,20,59733,0,'20180705') TS0000 from dual 8 10:14:01 SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,20,59733,0,'20180705') TS0000 from dual 9 10:14:06 SQL Prepare: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(b.YYID00,0) YYID00, (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,' ' color0,b.SFBLJC,b.SFMZJC, b.DQLJID,b.BRXM01 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00 in('6') ) and SL0000>0 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') and (nvl(b.YYID00,0)=0 or YYZT00='2') and b.mzzybz='1' and nvl(c.JCZID0,0)=22 and XMZT00 in('0','1','2') and (YJKSBH=:1 or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=:2)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=:3) )) and ( (',550,186,'=',0,') or (instr(',550,186,',:4 )>0) ) ) ) and kdrq00 between :5 and :6 order by kdrq00,KDSJ00,brid00) g 10 10:14:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 11 10:14:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 12 10:14:06 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 13 10:14:06 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ,94, 14 10:14:06 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180702 15 10:14:06 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20180704 17:00:00 16 10:14:06 SQL Execute: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(b.YYID00,0) YYID00, (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,' ' color0,b.SFBLJC,b.SFMZJC, b.DQLJID,b.BRXM01 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00 in('6') ) and SL0000>0 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') and (nvl(b.YYID00,0)=0 or YYZT00='2') and b.mzzybz='1' and nvl(c.JCZID0,0)=22 and XMZT00 in('0','1','2') and (YJKSBH=? or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',550,186,'=',0,') or (instr(',550,186,',? )>0) ) ) ) and kdrq00 between ? and ? order by kdrq00,KDSJ00,brid00) g 17 10:14:09 SQL Prepare: ORACLE - select SDMC00,SDID00 from YJ_YYSD00 where SDMC00 in (select KSPBSJ from VW_YJ_KSPBBSJ where YJKSBH=94 and XMWHID=22 ) 18 10:14:10 SQL Execute: ORACLE - select SDMC00,SDID00 from YJ_YYSD00 where SDMC00 in (select KSPBSJ from VW_YJ_KSPBBSJ where YJKSBH=94 and XMWHID=22 ) 19 10:14:10 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 20 10:14:10 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 21 10:14:10 SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 22 10:14:10 SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 23 10:14:11 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 24 10:14:11 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 25 10:14:11 SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 26 10:14:11 SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 27 10:14:12 SQL Prepare: ORACLE - select nvl(sum(cfzje0),0) vzje001 from yf_zycf00 where zyid00=1915886 and ((cflsh0='') or Instr(','||''||',',','||trim(cflsh0)||',')>0) and SFKSLY='Y' and cfzt00 in ('0','4') 28 10:14:12 SQL Execute: ORACLE - select nvl(sum(cfzje0),0) vzje001 from yf_zycf00 where zyid00=1915886 and ((cflsh0='') or Instr(','||''||',',','||trim(cflsh0)||',')>0) and SFKSLY='Y' and cfzt00 in ('0','4') 29 10:14:12 SQL Prepare: ORACLE - select nvl(sum(cfzje0),0) vzje001 from yf_zycf00 where zyid00=1915886 and ((cflsh0='') or Instr(','||''||',',','||trim(cflsh0)||',')>0) and SFKSLY='Y' and cfzt00 in ('0','4') 30 10:14:13 SQL Execute: ORACLE - select nvl(sum(cfzje0),0) vzje001 from yf_zycf00 where zyid00=1915886 and ((cflsh0='') or Instr(','||''||',',','||trim(cflsh0)||',')>0) and SFKSLY='Y' and cfzt00 in ('0','4') 31 10:14:13 SQL Prepare: ORACLE - select a.DAXXID,a.SBMC00 from VW_SB_SYKS00_YJ a,BM_ZLZD00 b,XT_KSZXXM c where b.ZLXMID=c.ZLXMID and a.DAXXID=c.DAXXID and c.ZXKSBH= 94 and c.ZLXMID= 7129 32 10:14:13 SQL Execute: ORACLE - select a.DAXXID,a.SBMC00 from VW_SB_SYKS00_YJ a,BM_ZLZD00 b,XT_KSZXXM c where b.ZLXMID=c.ZLXMID and a.DAXXID=c.DAXXID and c.ZXKSBH= 94 and c.ZLXMID= 7129 33 10:14:16 SQL Prepare: ORACLE - update YJ_JCHBXH set BRXM00='丁晓霞',YJDJH0=113804889 where HBXHID=2947964 34 10:14:16 SQL Execute: ORACLE - update YJ_JCHBXH set BRXM00='丁晓霞',YJDJH0=113804889 where HBXHID=2947964 35 10:14:16 SQL Data In: ORACLE - Rows affected = 1 36 10:14:16 SQL Prepare: ORACLE - update YJ_YW0000 set HBXHID='2947964',SFBLJC='N',SFMZJC='N' where YJDJH0=113804888 37 10:14:16 SQL Execute: ORACLE - update YJ_YW0000 set HBXHID='2947964',SFBLJC='N',SFMZJC='N' where YJDJH0=113804888 38 10:14:17 SQL Data In: ORACLE - Rows affected = 1 39 10:14:17 SQL Prepare: ORACLE - update YJ_YW0000 set HBXHID='2947964',SFBLJC='N',SFMZJC='N' where YJDJH0=113804889 40 10:14:17 SQL Execute: ORACLE - update YJ_YW0000 set HBXHID='2947964',SFBLJC='N',SFMZJC='N' where YJDJH0=113804889 41 10:14:18 SQL Data In: ORACLE - Rows affected = 1 42 10:14:18 SQL Prepare: ORACLE - commit 43 10:14:18 SQL Execute: ORACLE - commit 44 10:14:18 SQL Data In: ORACLE - Rows affected = 0 45 10:14:18 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 46 10:14:18 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 47 10:14:20 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113740027) MSG000 from dual 48 10:14:20 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113740027) MSG000 from dual 49 10:14:21 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113772865) MSG000 from dual 50 10:14:21 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113772865) MSG000 from dual 51 10:14:24 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113773535) MSG000 from dual 52 10:14:24 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113773535) MSG000 from dual 53 10:14:24 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113773534) MSG000 from dual 54 10:14:24 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113773534) MSG000 from dual 55 10:14:25 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113773522) MSG000 from dual 56 10:14:25 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113773522) MSG000 from dual 57 10:14:27 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113773536) MSG000 from dual 58 10:14:27 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113773536) MSG000 from dual 59 10:14:28 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113773623) MSG000 from dual 60 10:14:28 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113773623) MSG000 from dual 61 10:14:29 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113776892) MSG000 from dual 62 10:14:29 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113776892) MSG000 from dual 63 10:14:30 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113777323) MSG000 from dual 64 10:14:30 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113777323) MSG000 from dual 65 10:14:32 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113777324) MSG000 from dual 66 10:14:32 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113777324) MSG000 from dual 67 10:14:33 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113777910) MSG000 from dual 68 10:14:33 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113777910) MSG000 from dual 69 10:14:34 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113778627) MSG000 from dual 70 10:14:34 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113778627) MSG000 from dual 71 10:14:35 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113778626) MSG000 from dual 72 10:14:35 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113778626) MSG000 from dual 73 10:14:36 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113789752) MSG000 from dual 74 10:14:36 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113789752) MSG000 from dual 75 10:14:38 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113789900) MSG000 from dual 76 10:14:38 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113789900) MSG000 from dual 77 10:14:39 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113789899) MSG000 from dual 78 10:14:39 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113789899) MSG000 from dual 79 10:14:40 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113790376) MSG000 from dual 80 10:14:40 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113790376) MSG000 from dual 81 10:14:41 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113790612) MSG000 from dual 82 10:14:41 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113790612) MSG000 from dual 83 10:14:43 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113804736) MSG000 from dual 84 10:14:43 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113804736) MSG000 from dual 85 10:14:44 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113804737) MSG000 from dual 86 10:14:44 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113804737) MSG000 from dual 87 10:14:45 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 88 10:14:45 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113804888.000000 89 10:14:45 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 90 10:14:45 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 91 10:14:45 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 92 10:14:45 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8315 93 10:14:45 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 94 10:14:45 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 95 10:14:45 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 96 10:14:51 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 97 10:14:51 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113804889.000000 98 10:14:51 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 99 10:14:51 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 100 10:14:51 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 101 10:14:51 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 8315 102 10:14:51 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 103 10:14:51 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 104 10:14:51 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 105 10:14:59 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113804888) MSG000 from dual 106 10:14:59 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113804888) MSG000 from dual 107 10:15:00 SQL Prepare: ORACLE - update YJ_YW0000 set HBDJH0=113804888 where YJDJH0 in (113804888,113804889) 108 10:15:00 SQL Execute: ORACLE - update YJ_YW0000 set HBDJH0=113804888 where YJDJH0 in (113804888,113804889) 109 10:15:02 SQL Data In: ORACLE - Rows affected = 2 110 10:15:02 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where HBXHID=2947964 and BRXM00='丁晓霞' 111 10:15:02 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where HBXHID=2947964 and BRXM00='丁晓霞' 112 10:15:03 SQL Prepare: ORACLE - select count(*) COU from YJ_YW0000 where YJDJH0 in (113804888,113804889) and (nvl(SFDJH0,0)=0 or nvl(CXDJH0,0)>0) 113 10:15:03 SQL Execute: ORACLE - select count(*) COU from YJ_YW0000 where YJDJH0 in (113804888,113804889) and (nvl(SFDJH0,0)=0 or nvl(CXDJH0,0)>0) 114 10:15:03 SQL Prepare: ORACLE - select SF_YJ_GETJCYYDLQZ(0,'113804888,113804889','N',59735,2947964) QZ0000 from dual 115 10:15:03 SQL Execute: ORACLE - select SF_YJ_GETJCYYDLQZ(0,'113804888,113804889','N',59735,2947964) QZ0000 from dual 116 10:15:03 SQL Prepare: ORACLE - BEGIN "P_PACS_SCHEDULE" (PAPPLYNO => :PAPPLYNO,PEXAMSUBCLASS => :PEXAMSUBCLASS,PEXAMORGAN => :PEXAMORGAN,PEXAMGROUP => :PEXAMGROUP,PEXAMDEVICE => :PEXAMDEVICE,PSCHEDULEDDATE => :PSCHEDULEDDATE,PSCHEDULEDAPM => :PSCHEDULEDAPM,PQUEUECLASS => :PQUEUECLASS,PSUCC => :PSUCC,PPATLOCALID => :PPATLOCALID,PQUEUEDATE => :PQUEUEDATE,PQUEUEAPM => :PQUEUEAPM,PQUEUENO => :PQUEUENO,PDOCTORNAME => :PDOCTORNAME,PDOCTORID => :PDOCTORID,pExamQueue => :pExamQueue); END; 117 10:15:03 SQL Data In: ORACLE - Param = 1, Name = PAPPLYNO, Type = fldZSTRING, Precision = 19, Scale = 0, Data = 113804888,113804889 118 10:15:03 SQL Data In: ORACLE - Param = 2, Name = PEXAMSUBCLASS, Type = fldZSTRING, Precision = 2, Scale = 0, Data = CT 119 10:15:03 SQL Data In: ORACLE - Param = 3, Name = PEXAMORGAN, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 120 10:15:03 SQL Data In: ORACLE - Param = 4, Name = PEXAMGROUP, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 121 10:15:03 SQL Data In: ORACLE - Param = 5, Name = PEXAMDEVICE, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 122 10:15:03 SQL Data In: ORACLE - Param = 6, Name = PSCHEDULEDDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180704 123 10:15:03 SQL Data In: ORACLE - Param = 7, Name = PSCHEDULEDAPM, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 08:00-08:30 124 10:15:03 SQL Data In: ORACLE - Param = 8, Name = PQUEUECLASS, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 125 10:15:03 SQL Data In: ORACLE - Param = 9, Name = PSUCC, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 126 10:15:03 SQL Data In: ORACLE - Param = 10, Name = PPATLOCALID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 127 10:15:03 SQL Data In: ORACLE - Param = 11, Name = PQUEUEDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180705 128 10:15:03 SQL Data In: ORACLE - Param = 12, Name = PQUEUEAPM, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 08:00-08:30 129 10:15:03 SQL Data In: ORACLE - Param = 13, Name = PQUEUENO, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 002 130 10:15:03 SQL Data In: ORACLE - Param = 14, Name = PDOCTORNAME, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 10:15:03 SQL Data In: ORACLE - Param = 15, Name = PDOCTORID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 132 10:15:03 SQL Data In: ORACLE - Param = 16, Name = pExamQueue, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 133 10:15:03 SQL Execute: ORACLE - BEGIN "P_PACS_SCHEDULE" (PAPPLYNO => :PAPPLYNO,PEXAMSUBCLASS => :PEXAMSUBCLASS,PEXAMORGAN => :PEXAMORGAN,PEXAMGROUP => :PEXAMGROUP,PEXAMDEVICE => :PEXAMDEVICE,PSCHEDULEDDATE => :PSCHEDULEDDATE,PSCHEDULEDAPM => :PSCHEDULEDAPM,PQUEUECLASS => :PQUEUECLASS,PSUCC => :PSUCC,PPATLOCALID => :PPATLOCALID,PQUEUEDATE => :PQUEUEDATE,PQUEUEAPM => :PQUEUEAPM,PQUEUENO => :PQUEUENO,PDOCTORNAME => :PDOCTORNAME,PDOCTORID => :PDOCTORID,pExamQueue => :pExamQueue); END; 134 10:15:03 SQL Prepare: ORACLE - BEGIN "SP_YJ_JCYYDJ" (PYYID00 => :PYYID00,PYJDJH0 => :PYJDJH0,PBZ0000 => :PBZ0000,PYYRQ00 => :PYYRQ00,PYYSJ00 => :PYYSJ00,PYYXH00 => :PYYXH00,PCZRXM0 => :PCZRXM0,PCZBZ00 => :PCZBZ00,PJCSQDH => :PJCSQDH,PRESULT => :PRESULT,PERROR0 => :PERROR0,PTZBH00 => :PTZBH00,PYYSD00 => :PYYSD00,PXSYYXH => :PXSYYXH,PPBHBID => :PPBHBID,PJZBZ00 => :PJZBZ00,PCZZT00 => :PCZZT00,PSFBLJC => :PSFBLJC,PSFMZJC => :PSFMZJC); END; 135 10:15:03 SQL Data In: ORACLE - Param = 1, Name = PYYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 136 10:15:03 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 19, Scale = 0, Data = 113804888,113804889 137 10:15:03 SQL Data In: ORACLE - Param = 3, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 138 10:15:03 SQL Data In: ORACLE - Param = 4, Name = PYYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180705 139 10:15:03 SQL Data In: ORACLE - Param = 5, Name = PYYSJ00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 08:04 140 10:15:03 SQL Data In: ORACLE - Param = 6, Name = PYYXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 141 10:15:03 SQL Data In: ORACLE - Param = 7, Name = PCZRXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 阮晓青 142 10:15:03 SQL Data In: ORACLE - Param = 8, Name = PCZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 143 10:15:03 SQL Data In: ORACLE - Param = 9, Name = PJCSQDH, Type = fldZSTRING, Precision = 11, Scale = 0, Data = CT201713006 144 10:15:03 SQL Data In: ORACLE - Param = 10, Name = PRESULT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 145 10:15:03 SQL Data In: ORACLE - Param = 11, Name = PERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 146 10:15:03 SQL Data In: ORACLE - Param = 12, Name = PTZBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 147 10:15:03 SQL Data In: ORACLE - Param = 13, Name = PYYSD00, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 08:00-08:30 148 10:15:03 SQL Data In: ORACLE - Param = 14, Name = PXSYYXH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 002 149 10:15:03 SQL Data In: ORACLE - Param = 15, Name = PPBHBID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 59735 150 10:15:03 SQL Data In: ORACLE - Param = 16, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 151 10:15:03 SQL Data In: ORACLE - Param = 17, Name = PCZZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 152 10:15:03 SQL Data In: ORACLE - Param = 18, Name = PSFBLJC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 153 10:15:03 SQL Data In: ORACLE - Param = 19, Name = PSFMZJC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 154 10:15:03 SQL Execute: ORACLE - BEGIN "SP_YJ_JCYYDJ" (PYYID00 => :PYYID00,PYJDJH0 => :PYJDJH0,PBZ0000 => :PBZ0000,PYYRQ00 => :PYYRQ00,PYYSJ00 => :PYYSJ00,PYYXH00 => :PYYXH00,PCZRXM0 => :PCZRXM0,PCZBZ00 => :PCZBZ00,PJCSQDH => :PJCSQDH,PRESULT => :PRESULT,PERROR0 => :PERROR0,PTZBH00 => :PTZBH00,PYYSD00 => :PYYSD00,PXSYYXH => :PXSYYXH,PPBHBID => :PPBHBID,PJZBZ00 => :PJZBZ00,PCZZT00 => :PCZZT00,PSFBLJC => :PSFBLJC,PSFMZJC => :PSFMZJC); END; 155 10:15:05 SQL Prepare: ORACLE - commit 156 10:15:05 SQL Execute: ORACLE - commit 157 10:15:05 SQL Data In: ORACLE - Rows affected = 0 158 10:15:05 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113804889) MSG000 from dual 159 10:15:05 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113804889) MSG000 from dual 160 10:15:06 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113805969) MSG000 from dual 161 10:15:06 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113805969) MSG000 from dual 162 10:15:07 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113805970) MSG000 from dual 163 10:15:07 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113805970) MSG000 from dual 164 10:15:08 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113806900) MSG000 from dual 165 10:15:08 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113806900) MSG000 from dual 166 10:15:09 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113809512) MSG000 from dual 167 10:15:09 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113809512) MSG000 from dual 168 10:15:11 SQL Prepare: ORACLE - select SF_YJ_CheckedLocked(113809513) MSG000 from dual 169 10:15:11 SQL Execute: ORACLE - select SF_YJ_CheckedLocked(113809513) MSG000 from dual 170 10:15:12 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 171 10:15:12 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 172 10:15:12 SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 173 10:15:12 SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 174 10:15:22 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 175 10:15:22 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 176 10:15:22 SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 177 10:15:22 SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 178 10:15:32 SQL Prepare: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 179 10:15:32 SQL Execute: ORACLE - select a.* from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') and XMWHID=22 and a.YYRQ00='20180705' and a.PBSXW0='上午' order by a.KSPBSJ,a.XH0000 180 10:15:32 SQL Prepare: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual 181 10:15:32 SQL Execute: ORACLE - select SF_YJ_YYYRSXS(94,22,59735,0,'20180705') TS0000 from dual