1 09:03:35 SQL Execute: ORACLE - SELECT substr(BRZT00,1,1) as BRZT00 FROM ZY_BRXXB0 WHERE ZYID00= 977919 2 09:03:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2219.000000 3 09:03:35 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(?) SFBZDJ from dual 4 09:03:35 SQL Execute: ORACLE - select dqks00,SXYS00,SXYSXM,b.bmmc00 from zy_brxxb0 a,bm_bmbm00 b where a.dqks00=b.bmbh00(+) and zyid00=977919 5 09:03:35 SQL Execute: ORACLE - select yexm00 from bq_jsxx00 where zyid00=977919 6 09:03:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 977919.000000 7 09:03:35 SQL Execute: ORACLE - select * from (select bqh000,bmmc00,max(qsrq00||qssj00) qsrqsj from bq_brldxx q,bm_bmbm00 m where zyid00=? and q.bqh000=m.bmbh00 group by bqh000,bmmc00) order by qsrqsj desc 8 09:03:35 SQL Execute: ORACLE - select sysdate from dual 9 09:03:35 SQL Execute: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,ZXKSMC,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=4647465 and ((YJKSBH=179) or (KDKSBH=179) or (LRXM00='管理员')) and YJLRBZ='Y' and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20230217' order by YJdjh0 desc 10 09:03:35 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.ybbz00,S.XMMC00,S.BKEH83,S.GJBZMC,j.jzje00, J.sfxx00, J.sfsx00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=0 11 09:03:35 SQL Execute: ORACLE - select BBID00,BBMC00 from VW_BM_BBZD00 order by BBID00 12 09:03:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 13 09:03:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 14 09:03:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 15 09:03:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 16 09:03:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 17 09:03:36 SQL Execute: ORACLE - select 'N' NX, a.YJKSMC, A.XMZT00, A.ZLXMID, A.MZZYBZ, A.YZCFID, A.DCBZ00, A.BRID00,A.ZT0000, A.YJDJH0, A.YJFZH0, A.ZYHGHH, A.BRXM00, A.YEXM00, A.ZLXMJC, A.XB0000, A.CSRQ00, A.BRNL00, A.LRXM00, A.KDSJ00, A.ZYGHID, B.LBBH00, B.ZYZBID, A.KDYSXM, A.KDKSMC, A.KDRQ00, A.JZBZ00, A.BWMC00, A.BZ0000, A.ZDMC00, A.SL0000, A.ZXSL00, A.ZJE000, A.YJLRBZ, A.KDBQ00, nvl(A.CXDJH0,0) CXDJH0, A.ZXRXM0, A.ZXRQ00, A.ZXSJ00, A.BRYBMC, A.SM0000, A.ZLDCCF, A.CXSL00, A.TXM000, A.FBBH00, A.CH0000, A.YJKSBH, A.KDRQSJ, A.ZXRQSJ, A.YPNM00, A.BBZT00, A.JYTXM0,A.SFDJH0, decode(sign(A.SL0000),1,NULL,decode(A.SFDJH0,0,0,1)) SFGZ00, A.BBID00, (select BBMC00 from BM_BBZD00 where BBID00 = A.BBID00) BBMC00,b.SFQZX0, A.JCZID0, A.YYID00, A.HBXHID, A.YYZT00, A.HBDJH0,A.YYBZ00,A.JCSQDH,A.KDKSBH, A.KDYS00,A.JCLBID,A.SFZTMC,decode(A.HBZYXM,'2','是','否') HBZYXM,A.DW0000,A.SFZF00, decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC, a.TFSHR0,a.TFSHXM,a.TFSHRQ,a.TFSHSJ,a.KYJCJG from VW_YJ_YW0000 A, BM_ZLZD00 B where B.ZLXMID = A.ZLXMID and ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID=b.ZLXMID and b.SFQZX0='Y' and A.MZZYBZ='0' ) and instr(',117,1779,105,320,1939,',',179,')>0))and (1=1 and ( A.MZZYBZ = '0' or A.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(A.CXDJH0,0) = 0 and (A.SL0000-A.CXSL00)>0 and KDRQ00 between '20221119' and '20230217' order by XMZT00,YJDJH0 Desc 18 09:03:36 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 19 09:03:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 20 09:03:36 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 21 09:03:36 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 22 09:03:36 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 23 09:03:36 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 24 09:03:36 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 25 09:03:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 26 09:03:36 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 27 09:03:36 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 28 09:03:36 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 29 09:03:36 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 30 09:03:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 31 09:03:36 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 32 09:03:36 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 33 09:03:36 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 34 09:03:37 SQL Execute: ORACLE - SELECT substr(BRZT00,1,1) as BRZT00 FROM ZY_BRXXB0 WHERE ZYID00= 977919 35 09:03:37 SQL Execute: ORACLE - Select * from xt_yzmblb where (symbys=4 and mbgs00='0') or (symbks=179 and mbgs00='1') or (symbys=0 and symbks=0 and mbgs00='2') 36 09:03:37 SQL Execute: ORACLE - select b.* from xt_yzmblb a,vw_xt_yzmb00 b where a.mblbid=b.mblbid and ((a.symbys=4 and a.mbgs00='0') or (a.symbks=179 and a.mbgs00='1') or (a.symbys=0 and a.symbks=0 and a.mbgs00='2')) 37 09:03:38 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='01'and ((symbys=4) or (symbks=179) or (symbys=0 and symbks=0))) order by mbmc00 38 09:03:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 39 09:03:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 183282 40 09:03:38 SQL Execute: ORACLE - select m.mxid00,m.zb0000,y.ypmc00,y.ypgg00,m.jl0000,y.jldw00, f.ypyfmc,p.pcmc00,m.yysj00,m.yysjdw, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, m.zldw00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000 y,vw_bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and (y.lbbh00 like ?) and mbid00=? and yplb00='0' order by zbbh00,znxh00 41 09:03:38 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mbid00=183282 order by xsxh00 42 09:03:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 183282.000000 43 09:03:38 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000 y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 44 09:03:39 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='01000'and ((symbys=4) or (symbks=179) or (symbys=0 and symbks=0))) order by mbmc00 45 09:03:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 46 09:03:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 158360 47 09:03:39 SQL Execute: ORACLE - select m.mxid00,m.zb0000,y.ypmc00,y.ypgg00,m.jl0000,y.jldw00, f.ypyfmc,p.pcmc00,m.yysj00,m.yysjdw, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, m.zldw00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000 y,vw_bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and (y.lbbh00 like ?) and mbid00=? and yplb00='0' order by zbbh00,znxh00 48 09:03:39 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mbid00=158360 order by xsxh00 49 09:03:39 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 50 09:03:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 158360.000000 51 09:03:39 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000 y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 52 09:03:41 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 53 09:03:41 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 54 09:03:41 SQL Data In: ORACLE - Param = 1, Name = PMBID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 55 09:03:41 SQL Data In: ORACLE - Param = 2, Name = PCS0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 56 09:03:41 SQL Data In: ORACLE - Param = 3, Name = PKDYSBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 57 09:03:41 SQL Data In: ORACLE - Param = 4, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 58 09:03:41 SQL Data In: ORACLE - Param = 5, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 59 09:03:41 SQL Data In: ORACLE - Param = 6, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 977919.000000 60 09:03:41 SQL Data In: ORACLE - Param = 7, Name = PMXID00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 100027514 61 09:03:41 SQL Data In: ORACLE - Param = 8, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 62 09:03:41 SQL Data In: ORACLE - Param = 9, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 63 09:03:41 SQL Data In: ORACLE - Param = 10, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 64 09:03:41 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 65 09:03:41 SQL Data In: ORACLE - Param = 12, Name = pzxksbh, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 179.000000 66 09:03:41 SQL Data In: ORACLE - Param = 13, Name = Pczyks0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 179.000000 67 09:03:41 SQL Execute: ORACLE - BEGIN "SP_YJ_ZLMBYY_SINGLE" (PMBID00 => :PMBID00,PCS0000 => :PCS0000,PKDYSBH => :PKDYSBH,PKDKSBH => :PKDKSBH,PMZZYBZ => :PMZZYBZ,PZYGHID => :PZYGHID,PMXID00 => :PMXID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT,pzxksbh => :pzxksbh,Pczyks0 => :Pczyks0); END; 68 09:03:41 SQL Error: ORACLE - ORA-20010: 找不到该病人信息！*SP_YJ_ZLMBYY_SINGLE(100027514,4,977919,179,4,pzxjg00,pzxbz00,'N') ORA-06512: 在 "SD_HOSPITAL.SP_YJ_ZLMBYY_SINGLE", line 151 ORA-06512: 在 line 1 69 09:03:41 SQL Error: ORACLE - Unmapped SQL Error Code: 20010 70 09:03:41 SQL Execute: ORACLE - Rollback 71 09:03:41 SQL Data In: ORACLE - Rows affected = 0 72 09:04:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 73 09:04:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 74 09:04:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 75 09:04:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 76 09:04:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 77 09:04:20 SQL Execute: ORACLE - select 'N' NX, a.YJKSMC, A.XMZT00, A.ZLXMID, A.MZZYBZ, A.YZCFID, A.DCBZ00, A.BRID00,A.ZT0000, A.YJDJH0, A.YJFZH0, A.ZYHGHH, A.BRXM00, A.YEXM00, A.ZLXMJC, A.XB0000, A.CSRQ00, A.BRNL00, A.LRXM00, A.KDSJ00, A.ZYGHID, B.LBBH00, B.ZYZBID, A.KDYSXM, A.KDKSMC, A.KDRQ00, A.JZBZ00, A.BWMC00, A.BZ0000, A.ZDMC00, A.SL0000, A.ZXSL00, A.ZJE000, A.YJLRBZ, A.KDBQ00, nvl(A.CXDJH0,0) CXDJH0, A.ZXRXM0, A.ZXRQ00, A.ZXSJ00, A.BRYBMC, A.SM0000, A.ZLDCCF, A.CXSL00, A.TXM000, A.FBBH00, A.CH0000, A.YJKSBH, A.KDRQSJ, A.ZXRQSJ, A.YPNM00, A.BBZT00, A.JYTXM0,A.SFDJH0, decode(sign(A.SL0000),1,NULL,decode(A.SFDJH0,0,0,1)) SFGZ00, A.BBID00, (select BBMC00 from BM_BBZD00 where BBID00 = A.BBID00) BBMC00,b.SFQZX0, A.JCZID0, A.YYID00, A.HBXHID, A.YYZT00, A.HBDJH0,A.YYBZ00,A.JCSQDH,A.KDKSBH, A.KDYS00,A.JCLBID,A.SFZTMC,decode(A.HBZYXM,'2','是','否') HBZYXM,A.DW0000,A.SFZF00, decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC, a.TFSHR0,a.TFSHXM,a.TFSHRQ,a.TFSHSJ,a.KYJCJG from VW_YJ_YW0000 A, BM_ZLZD00 B where B.ZLXMID = A.ZLXMID and ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID=b.ZLXMID and b.SFQZX0='Y' and A.MZZYBZ='0' ) and instr(',117,1779,105,320,1939,',',179,')>0))and (1=1 and ( A.MZZYBZ = '0' or A.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(A.CXDJH0,0) = 0 and (A.SL0000-A.CXSL00)>0 and KDRQ00 between '20221119' and '20230217' order by XMZT00,YJDJH0 Desc 78 09:04:21 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 79 09:04:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 80 09:04:21 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 81 09:04:21 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 82 09:04:21 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 83 09:04:21 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 84 09:04:21 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 85 09:04:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 86 09:04:21 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 87 09:04:21 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 88 09:04:21 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 89 09:04:21 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 90 09:04:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 91 09:04:21 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 92 09:04:21 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 93 09:04:21 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 94 09:04:22 SQL Execute: ORACLE - SELECT substr(BRZT00,1,1) as BRZT00 FROM ZY_BRXXB0 WHERE ZYID00= 977919 95 09:04:22 SQL Execute: ORACLE - Select * from xt_yzmblb where (symbys=4 and mbgs00='0') or (symbks=179 and mbgs00='1') or (symbys=0 and symbks=0 and mbgs00='2') 96 09:04:22 SQL Execute: ORACLE - select b.* from xt_yzmblb a,vw_xt_yzmb00 b where a.mblbid=b.mblbid and ((a.symbys=4 and a.mbgs00='0') or (a.symbks=179 and a.mbgs00='1') or (a.symbys=0 and a.symbks=0 and a.mbgs00='2')) 97 09:04:24 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='01'and ((symbys=4) or (symbks=179) or (symbys=0 and symbks=0))) order by mbmc00 98 09:04:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 99 09:04:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 183282 100 09:04:24 SQL Execute: ORACLE - select m.mxid00,m.zb0000,y.ypmc00,y.ypgg00,m.jl0000,y.jldw00, f.ypyfmc,p.pcmc00,m.yysj00,m.yysjdw, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, m.zldw00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000 y,vw_bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and (y.lbbh00 like ?) and mbid00=? and yplb00='0' order by zbbh00,znxh00 101 09:04:24 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mbid00=183282 order by xsxh00 102 09:04:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 183282.000000 103 09:04:24 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000 y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 104 09:04:25 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='01000'and ((symbys=4) or (symbks=179) or (symbys=0 and symbks=0))) order by mbmc00 105 09:04:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 106 09:04:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 158360 107 09:04:25 SQL Execute: ORACLE - select m.mxid00,m.zb0000,y.ypmc00,y.ypgg00,m.jl0000,y.jldw00, f.ypyfmc,p.pcmc00,m.yysj00,m.yysjdw, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, m.zldw00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000 y,vw_bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and (y.lbbh00 like ?) and mbid00=? and yplb00='0' order by zbbh00,znxh00 108 09:04:25 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mbid00=158360 order by xsxh00 109 09:04:25 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 110 09:04:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 158360.000000 111 09:04:25 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000 y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 112 09:04:26 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 113 09:04:26 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 114 09:04:26 SQL Data In: ORACLE - Param = 1, Name = PMBID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 115 09:04:26 SQL Data In: ORACLE - Param = 2, Name = PCS0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 116 09:04:26 SQL Data In: ORACLE - Param = 3, Name = PKDYSBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 117 09:04:26 SQL Data In: ORACLE - Param = 4, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 118 09:04:26 SQL Data In: ORACLE - Param = 5, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 119 09:04:26 SQL Data In: ORACLE - Param = 6, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 977919.000000 120 09:04:26 SQL Data In: ORACLE - Param = 7, Name = PMXID00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 100027514 121 09:04:26 SQL Data In: ORACLE - Param = 8, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 122 09:04:26 SQL Data In: ORACLE - Param = 9, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 123 09:04:26 SQL Data In: ORACLE - Param = 10, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 124 09:04:26 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 125 09:04:26 SQL Data In: ORACLE - Param = 12, Name = pzxksbh, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 179.000000 126 09:04:26 SQL Data In: ORACLE - Param = 13, Name = Pczyks0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 179.000000 127 09:04:26 SQL Execute: ORACLE - BEGIN "SP_YJ_ZLMBYY_SINGLE" (PMBID00 => :PMBID00,PCS0000 => :PCS0000,PKDYSBH => :PKDYSBH,PKDKSBH => :PKDKSBH,PMZZYBZ => :PMZZYBZ,PZYGHID => :PZYGHID,PMXID00 => :PMXID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT,pzxksbh => :pzxksbh,Pczyks0 => :Pczyks0); END; 128 09:04:26 SQL Execute: ORACLE - commit 129 09:04:26 SQL Data In: ORACLE - Rows affected = 0 130 09:04:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 131 09:04:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 132 09:04:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 133 09:04:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 134 09:04:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 135 09:04:26 SQL Execute: ORACLE - select 'N' NX, a.YJKSMC, A.XMZT00, A.ZLXMID, A.MZZYBZ, A.YZCFID, A.DCBZ00, A.BRID00,A.ZT0000, A.YJDJH0, A.YJFZH0, A.ZYHGHH, A.BRXM00, A.YEXM00, A.ZLXMJC, A.XB0000, A.CSRQ00, A.BRNL00, A.LRXM00, A.KDSJ00, A.ZYGHID, B.LBBH00, B.ZYZBID, A.KDYSXM, A.KDKSMC, A.KDRQ00, A.JZBZ00, A.BWMC00, A.BZ0000, A.ZDMC00, A.SL0000, A.ZXSL00, A.ZJE000, A.YJLRBZ, A.KDBQ00, nvl(A.CXDJH0,0) CXDJH0, A.ZXRXM0, A.ZXRQ00, A.ZXSJ00, A.BRYBMC, A.SM0000, A.ZLDCCF, A.CXSL00, A.TXM000, A.FBBH00, A.CH0000, A.YJKSBH, A.KDRQSJ, A.ZXRQSJ, A.YPNM00, A.BBZT00, A.JYTXM0,A.SFDJH0, decode(sign(A.SL0000),1,NULL,decode(A.SFDJH0,0,0,1)) SFGZ00, A.BBID00, (select BBMC00 from BM_BBZD00 where BBID00 = A.BBID00) BBMC00,b.SFQZX0, A.JCZID0, A.YYID00, A.HBXHID, A.YYZT00, A.HBDJH0,A.YYBZ00,A.JCSQDH,A.KDKSBH, A.KDYS00,A.JCLBID,A.SFZTMC,decode(A.HBZYXM,'2','是','否') HBZYXM,A.DW0000,A.SFZF00, decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC, a.TFSHR0,a.TFSHXM,a.TFSHRQ,a.TFSHSJ,a.KYJCJG from VW_YJ_YW0000 A, BM_ZLZD00 B where B.ZLXMID = A.ZLXMID and ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID=b.ZLXMID and b.SFQZX0='Y' and A.MZZYBZ='0' ) and instr(',117,1779,105,320,1939,',',179,')>0))and (1=1 and ( A.MZZYBZ = '0' or A.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(A.CXDJH0,0) = 0 and (A.SL0000-A.CXSL00)>0 and KDRQ00 between '20221119' and '20230217' order by XMZT00,YJDJH0 Desc 136 09:04:26 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71321532 order by C.NBID00,A.ID0000 137 09:04:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 138 09:04:26 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 139 09:04:26 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 140 09:04:26 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 141 09:04:26 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 142 09:04:26 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 143 09:04:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 144 09:04:26 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 145 09:04:26 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 146 09:04:26 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 147 09:04:26 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 148 09:04:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 149 09:04:26 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 150 09:04:26 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 151 09:04:26 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 152 09:04:28 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71321532 order by C.NBID00,A.ID0000 153 09:04:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 154 09:04:28 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 155 09:04:28 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 156 09:04:28 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 157 09:04:28 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71321532 order by C.NBID00,A.ID0000 158 09:04:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 159 09:04:28 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 160 09:04:28 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 161 09:04:28 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 162 09:04:30 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71321532 order by C.NBID00,A.ID0000 163 09:04:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 164 09:04:30 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 165 09:04:31 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 166 09:04:31 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 167 09:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 71321532 168 09:04:31 SQL Execute: ORACLE - select count(1) from YJ_YW0000 where YJDJH0=? and XMZT00 in ('0', '1') 169 09:04:31 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 170 09:04:31 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 71321532 171 09:04:31 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 172 09:04:31 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 173 09:04:31 SQL Data In: ORACLE - Param = 5, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 70680 174 09:04:31 SQL Data In: ORACLE - Param = 6, Name = PZXMID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 175 09:04:31 SQL Data In: ORACLE - Param = 7, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 176 09:04:31 SQL Data In: ORACLE - Param = 8, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 177 09:04:31 SQL Data In: ORACLE - Param = 9, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 178 09:04:31 SQL Data In: ORACLE - Param = 10, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 179 09:04:31 SQL Data In: ORACLE - Param = 11, Name = PYJLRBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 180 09:04:31 SQL Data In: ORACLE - Param = 12, Name = PJZBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 181 09:04:31 SQL Data In: ORACLE - Param = 13, Name = PKDYS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 182 09:04:31 SQL Data In: ORACLE - Param = 14, Name = PKDKSBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 183 09:04:31 SQL Data In: ORACLE - Param = 15, Name = PKDBQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 184 09:04:31 SQL Data In: ORACLE - Param = 16, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 185 09:04:31 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 186 09:04:31 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 187 09:04:31 SQL Data In: ORACLE - Param = 19, Name = PFJDJBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 188 09:04:31 SQL Data In: ORACLE - Param = 20, Name = PCZY000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 189 09:04:31 SQL Data In: ORACLE - Param = 21, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 190 09:04:31 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 191 09:04:31 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 192 09:04:31 SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 193 09:04:31 SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 194 09:04:31 SQL Data In: ORACLE - Param = 26, Name = PYWMXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 195 09:04:31 SQL Data In: ORACLE - Param = 27, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 196 09:04:31 SQL Data In: ORACLE - Param = 28, Name = PFYJDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 197 09:04:31 SQL Data In: ORACLE - Param = 29, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 198 09:04:31 SQL Data In: ORACLE - Param = 30, Name = PYZCFID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 199 09:04:31 SQL Data In: ORACLE - Param = 31, Name = PSSDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 200 09:04:31 SQL Data In: ORACLE - Param = 32, Name = PTXM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 201 09:04:31 SQL Data In: ORACLE - Param = 33, Name = PWZBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 202 09:04:31 SQL Data In: ORACLE - Param = 34, Name = PSSBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 203 09:04:31 SQL Data In: ORACLE - Param = 35, Name = PSSMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 204 09:04:31 SQL Data In: ORACLE - Param = 36, Name = PSSYJDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 205 09:04:31 SQL Data In: ORACLE - Param = 37, Name = PWZBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 206 09:04:31 SQL Data In: ORACLE - Param = 38, Name = PTQPC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 207 09:04:31 SQL Data In: ORACLE - Param = 39, Name = PXMZK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 208 09:04:31 SQL Data In: ORACLE - Param = 40, Name = PYJZHJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 209 09:04:31 SQL Data In: ORACLE - Param = 41, Name = PTCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 210 09:04:31 SQL Data In: ORACLE - Param = 42, Name = PMBMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 211 09:04:31 SQL Data In: ORACLE - Param = 43, Name = PSFTJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 212 09:04:31 SQL Data In: ORACLE - Param = 44, Name = PSFZF00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 213 09:04:31 SQL Data In: ORACLE - Param = 45, Name = PYYGXJG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 214 09:04:31 SQL Data In: ORACLE - Param = 46, Name = PBWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 215 09:04:31 SQL Data In: ORACLE - Param = 47, Name = PZLXMJC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 216 09:04:31 SQL Data In: ORACLE - Param = 48, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 217 09:04:31 SQL Data In: ORACLE - Param = 49, Name = PSFFR00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 218 09:04:31 SQL Data In: ORACLE - Param = 50, Name = PDCNYJ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 219 09:04:31 SQL Data In: ORACLE - Param = 51, Name = PXMLSTR, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 220 09:04:31 SQL Execute: ORACLE - BEGIN "SP_YJ_YJSQWH" (POPFLAG => :POPFLAG,PYJDJH0 => :PYJDJH0,PZYGHID => :PZYGHID,PMZZYBZ => :PMZZYBZ,PZLXMID => :PZLXMID,PZXMID0 => :PZXMID0,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PBBID00 => :PBBID00,PBH0000 => :PBH0000,PYJLRBZ => :PYJLRBZ,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PKDBQ00 => :PKDBQ00,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PFJDJBZ => :PFJDJBZ,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PYWMXID => :PYWMXID,PBWMC00 => :PBWMC00,PFYJDJH => :PFYJDJH,PCXJJ00 => :PCXJJ00,PYZCFID => :PYZCFID,PSSDH00 => :PSSDH00,PTXM000 => :PTXM000,PWZBM00 => :PWZBM00,PSSBM00 => :PSSBM00,PSSMC00 => :PSSMC00,PSSYJDH => :PSSYJDH,PWZBH00 => :PWZBH00,PTQPC00 => :PTQPC00,PXMZK00 => :PXMZK00,PYJZHJE => :PYJZHJE,PTCID00 => :PTCID00,PMBMXID => :PMBMXID,PSFTJ00 => :PSFTJ00,PSFZF00 => :PSFZF00,PYYGXJG => :PYYGXJG,PBWID00 => :PBWID00,PZLXMJC => :PZLXMJC,PYEXM00 => :PYEXM00,PSFFR00 => :PSFFR00,PDCNYJ0 => :PDCNYJ0,PXMLSTR => :PXMLSTR); END; 221 09:04:31 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ' 222 09:04:31 SQL Execute: ORACLE - commit 223 09:04:31 SQL Data In: ORACLE - Rows affected = 0 224 09:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 225 09:04:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 226 09:04:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 227 09:04:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 228 09:04:31 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 229 09:04:31 SQL Execute: ORACLE - select 'N' NX, a.YJKSMC, A.XMZT00, A.ZLXMID, A.MZZYBZ, A.YZCFID, A.DCBZ00, A.BRID00,A.ZT0000, A.YJDJH0, A.YJFZH0, A.ZYHGHH, A.BRXM00, A.YEXM00, A.ZLXMJC, A.XB0000, A.CSRQ00, A.BRNL00, A.LRXM00, A.KDSJ00, A.ZYGHID, B.LBBH00, B.ZYZBID, A.KDYSXM, A.KDKSMC, A.KDRQ00, A.JZBZ00, A.BWMC00, A.BZ0000, A.ZDMC00, A.SL0000, A.ZXSL00, A.ZJE000, A.YJLRBZ, A.KDBQ00, nvl(A.CXDJH0,0) CXDJH0, A.ZXRXM0, A.ZXRQ00, A.ZXSJ00, A.BRYBMC, A.SM0000, A.ZLDCCF, A.CXSL00, A.TXM000, A.FBBH00, A.CH0000, A.YJKSBH, A.KDRQSJ, A.ZXRQSJ, A.YPNM00, A.BBZT00, A.JYTXM0,A.SFDJH0, decode(sign(A.SL0000),1,NULL,decode(A.SFDJH0,0,0,1)) SFGZ00, A.BBID00, (select BBMC00 from BM_BBZD00 where BBID00 = A.BBID00) BBMC00,b.SFQZX0, A.JCZID0, A.YYID00, A.HBXHID, A.YYZT00, A.HBDJH0,A.YYBZ00,A.JCSQDH,A.KDKSBH, A.KDYS00,A.JCLBID,A.SFZTMC,decode(A.HBZYXM,'2','是','否') HBZYXM,A.DW0000,A.SFZF00, decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC, a.TFSHR0,a.TFSHXM,a.TFSHRQ,a.TFSHSJ,a.KYJCJG from VW_YJ_YW0000 A, BM_ZLZD00 B where B.ZLXMID = A.ZLXMID and ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID=b.ZLXMID and b.SFQZX0='Y' and A.MZZYBZ='0' ) and instr(',117,1779,105,320,1939,',',179,')>0))and (1=1 and ( A.MZZYBZ = '0' or A.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(A.CXDJH0,0) = 0 and (A.SL0000-A.CXSL00)>0 and KDRQ00 between '20221119' and '20230217' order by XMZT00,YJDJH0 Desc 230 09:04:31 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 231 09:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 232 09:04:31 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 233 09:04:31 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 234 09:04:31 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 235 09:04:31 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 236 09:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 237 09:04:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 238 09:04:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 239 09:04:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 240 09:04:31 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 241 09:04:31 SQL Execute: ORACLE - select 'N' NX, a.YJKSMC, A.XMZT00, A.ZLXMID, A.MZZYBZ, A.YZCFID, A.DCBZ00, A.BRID00,A.ZT0000, A.YJDJH0, A.YJFZH0, A.ZYHGHH, A.BRXM00, A.YEXM00, A.ZLXMJC, A.XB0000, A.CSRQ00, A.BRNL00, A.LRXM00, A.KDSJ00, A.ZYGHID, B.LBBH00, B.ZYZBID, A.KDYSXM, A.KDKSMC, A.KDRQ00, A.JZBZ00, A.BWMC00, A.BZ0000, A.ZDMC00, A.SL0000, A.ZXSL00, A.ZJE000, A.YJLRBZ, A.KDBQ00, nvl(A.CXDJH0,0) CXDJH0, A.ZXRXM0, A.ZXRQ00, A.ZXSJ00, A.BRYBMC, A.SM0000, A.ZLDCCF, A.CXSL00, A.TXM000, A.FBBH00, A.CH0000, A.YJKSBH, A.KDRQSJ, A.ZXRQSJ, A.YPNM00, A.BBZT00, A.JYTXM0,A.SFDJH0, decode(sign(A.SL0000),1,NULL,decode(A.SFDJH0,0,0,1)) SFGZ00, A.BBID00, (select BBMC00 from BM_BBZD00 where BBID00 = A.BBID00) BBMC00,b.SFQZX0, A.JCZID0, A.YYID00, A.HBXHID, A.YYZT00, A.HBDJH0,A.YYBZ00,A.JCSQDH,A.KDKSBH, A.KDYS00,A.JCLBID,A.SFZTMC,decode(A.HBZYXM,'2','是','否') HBZYXM,A.DW0000,A.SFZF00, decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC, a.TFSHR0,a.TFSHXM,a.TFSHRQ,a.TFSHSJ,a.KYJCJG from VW_YJ_YW0000 A, BM_ZLZD00 B where B.ZLXMID = A.ZLXMID and ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID=b.ZLXMID and b.SFQZX0='Y' and A.MZZYBZ='0' ) and instr(',117,1779,105,320,1939,',',179,')>0))and (1=1 and ( A.MZZYBZ = '0' or A.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(A.CXDJH0,0) = 0 and (A.SL0000-A.CXSL00)>0 and KDRQ00 between '20221119' and '20230217' order by XMZT00,YJDJH0 Desc 242 09:04:31 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 243 09:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 244 09:04:31 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 245 09:04:31 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 246 09:04:31 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 247 09:04:37 SQL Execute: ORACLE - SELECT substr(BRZT00,1,1) as BRZT00 FROM ZY_BRXXB0 WHERE ZYID00= 977919 248 09:04:37 SQL Execute: ORACLE - Select * from xt_yzmblb where (symbys=4 and mbgs00='0') or (symbks=179 and mbgs00='1') or (symbys=0 and symbks=0 and mbgs00='2') 249 09:04:37 SQL Execute: ORACLE - select b.* from xt_yzmblb a,vw_xt_yzmb00 b where a.mblbid=b.mblbid and ((a.symbys=4 and a.mbgs00='0') or (a.symbks=179 and a.mbgs00='1') or (a.symbys=0 and a.symbks=0 and a.mbgs00='2')) 250 09:04:38 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='01'and ((symbys=4) or (symbks=179) or (symbys=0 and symbks=0))) order by mbmc00 251 09:04:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 252 09:04:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 183282 253 09:04:38 SQL Execute: ORACLE - select m.mxid00,m.zb0000,y.ypmc00,y.ypgg00,m.jl0000,y.jldw00, f.ypyfmc,p.pcmc00,m.yysj00,m.yysjdw, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, m.zldw00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000 y,vw_bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and (y.lbbh00 like ?) and mbid00=? and yplb00='0' order by zbbh00,znxh00 254 09:04:38 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mbid00=183282 order by xsxh00 255 09:04:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 183282.000000 256 09:04:39 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000 y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 257 09:04:39 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='01000'and ((symbys=4) or (symbks=179) or (symbys=0 and symbks=0))) order by mbmc00 258 09:04:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 259 09:04:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 158360 260 09:04:39 SQL Execute: ORACLE - select m.mxid00,m.zb0000,y.ypmc00,y.ypgg00,m.jl0000,y.jldw00, f.ypyfmc,p.pcmc00,m.yysj00,m.yysjdw, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, m.zldw00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000 y,vw_bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and (y.lbbh00 like ?) and mbid00=? and yplb00='0' order by zbbh00,znxh00 261 09:04:39 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mbid00=158360 order by xsxh00 262 09:04:39 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 263 09:04:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 158360.000000 264 09:04:39 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000 y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 265 09:04:41 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 266 09:04:41 SQL Execute: ORACLE - select c.XMMC00,c.DW0000,c.SFJE00,a.SFCS00,c.GJBM00,c.GG0000,substr(c.BZ0000,1,200),c.BKEH83,c.GJBZMC from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.ZLXMID=b.ZLXMID and a.SFXMID=c.SFXMID and B.ZLXMID=70680and c.SFBZDJ='0' order by XMMC00 267 09:04:41 SQL Data In: ORACLE - Param = 1, Name = PMBID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 268 09:04:41 SQL Data In: ORACLE - Param = 2, Name = PCS0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 269 09:04:41 SQL Data In: ORACLE - Param = 3, Name = PKDYSBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 270 09:04:41 SQL Data In: ORACLE - Param = 4, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 271 09:04:41 SQL Data In: ORACLE - Param = 5, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 272 09:04:41 SQL Data In: ORACLE - Param = 6, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 977919.000000 273 09:04:41 SQL Data In: ORACLE - Param = 7, Name = PMXID00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 100027514 274 09:04:41 SQL Data In: ORACLE - Param = 8, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 275 09:04:41 SQL Data In: ORACLE - Param = 9, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 276 09:04:41 SQL Data In: ORACLE - Param = 10, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 277 09:04:41 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 278 09:04:41 SQL Data In: ORACLE - Param = 12, Name = pzxksbh, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 179.000000 279 09:04:41 SQL Data In: ORACLE - Param = 13, Name = Pczyks0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 179.000000 280 09:04:41 SQL Execute: ORACLE - BEGIN "SP_YJ_ZLMBYY_SINGLE" (PMBID00 => :PMBID00,PCS0000 => :PCS0000,PKDYSBH => :PKDYSBH,PKDKSBH => :PKDKSBH,PMZZYBZ => :PMZZYBZ,PZYGHID => :PZYGHID,PMXID00 => :PMXID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT,pzxksbh => :pzxksbh,Pczyks0 => :Pczyks0); END; 281 09:04:41 SQL Error: ORACLE - ORA-20010: 找不到该病人信息！*SP_YJ_ZLMBYY_SINGLE(100027514,4,977919,179,4,pzxjg00,pzxbz00,'N') ORA-06512: 在 "SD_HOSPITAL.SP_YJ_ZLMBYY_SINGLE", line 151 ORA-06512: 在 line 1 282 09:04:41 SQL Error: ORACLE - Unmapped SQL Error Code: 20010 283 09:04:41 SQL Execute: ORACLE - Rollback 284 09:04:41 SQL Data In: ORACLE - Rows affected = 0 285 09:07:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 286 09:07:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 287 09:07:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 288 09:07:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 289 09:07:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 179 290 09:07:19 SQL Execute: ORACLE - select 'N' NX, a.YJKSMC, A.XMZT00, A.ZLXMID, A.MZZYBZ, A.YZCFID, A.DCBZ00, A.BRID00,A.ZT0000, A.YJDJH0, A.YJFZH0, A.ZYHGHH, A.BRXM00, A.YEXM00, A.ZLXMJC, A.XB0000, A.CSRQ00, A.BRNL00, A.LRXM00, A.KDSJ00, A.ZYGHID, B.LBBH00, B.ZYZBID, A.KDYSXM, A.KDKSMC, A.KDRQ00, A.JZBZ00, A.BWMC00, A.BZ0000, A.ZDMC00, A.SL0000, A.ZXSL00, A.ZJE000, A.YJLRBZ, A.KDBQ00, nvl(A.CXDJH0,0) CXDJH0, A.ZXRXM0, A.ZXRQ00, A.ZXSJ00, A.BRYBMC, A.SM0000, A.ZLDCCF, A.CXSL00, A.TXM000, A.FBBH00, A.CH0000, A.YJKSBH, A.KDRQSJ, A.ZXRQSJ, A.YPNM00, A.BBZT00, A.JYTXM0,A.SFDJH0, decode(sign(A.SL0000),1,NULL,decode(A.SFDJH0,0,0,1)) SFGZ00, A.BBID00, (select BBMC00 from BM_BBZD00 where BBID00 = A.BBID00) BBMC00,b.SFQZX0, A.JCZID0, A.YYID00, A.HBXHID, A.YYZT00, A.HBDJH0,A.YYBZ00,A.JCSQDH,A.KDKSBH, A.KDYS00,A.JCLBID,A.SFZTMC,decode(A.HBZYXM,'2','是','否') HBZYXM,A.DW0000,A.SFZF00, decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC, a.TFSHR0,a.TFSHXM,a.TFSHRQ,a.TFSHSJ,a.KYJCJG from VW_YJ_YW0000 A, BM_ZLZD00 B where B.ZLXMID = A.ZLXMID and ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID=b.ZLXMID and b.SFQZX0='Y' and A.MZZYBZ='0' ) and instr(',117,1779,105,320,1939,',',179,')>0))and (1=1 and ( A.MZZYBZ = '0' or A.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(A.CXDJH0,0) = 0 and (A.SL0000-A.CXSL00)>0 and KDRQ00 between '20221119' and '20230217' order by XMZT00,YJDJH0 Desc 291 09:07:19 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 292 09:07:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 293 09:07:19 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 294 09:07:19 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 295 09:07:19 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 296 09:07:19 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 297 09:07:19 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 298 09:07:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 299 09:07:20 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 300 09:07:20 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 301 09:07:20 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 302 09:07:20 SQL Execute: ORACLE - select A.ID0000, A.YJDJH0, A.SFXMID, A.SFXX00, A.SFCS00, A.GDBZ00, A.FJFYBZ, A.JJJE00, A.GFJE00, A.ZFJE00, A.SFSX00, A.YBBZ00, TRIM(B.XMMC00) XMMC00, A.JZJE00, B.SFJE00, A.SL0000, A.MXID00, A.GJBM00, A.SFLB00, A.ZFBL00, A.YJFZH0,A.CXSL00,0 BCCXSL,B.DW0000,C.ZTM000,C.CTM000, B.BKEH83, B.GJBZMC from YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C where A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = 71315450 order by C.NBID00,A.ID0000 303 09:07:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977919 304 09:07:20 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 305 09:07:20 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4647465,'1',977919) from dual 306 09:07:20 SQL Execute: ORACLE - select '4647465' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18850259375' BRLXDH,'830808' ZYHGHH, '江晓芳' BRXM00, '女' BRXB00, '29岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4647465') FBMC00 , '626' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2239) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4647465' ) JZFPBZ from dual 307 09:09:01 SQL Execute: ORACLE - select SQ_XT_BBBDRZ_LSH000.NextVal as LSH000 from Dual 308 09:09:01 SQL Execute: ORACLE - insert into XT_BBBDXX(LSH000,YGBH00,CZYKS0,CZXTDM,CZIP00,DBBB00,BZ0000) values(11130.00,4,179,'7','192.168.124.5','09.00.230216','') 309 09:09:02 SQL Data In: ORACLE - Rows affected = 1 310 09:09:02 SQL Execute: ORACLE - Commit 311 09:09:02 SQL Data In: ORACLE - Rows affected = 0 312 09:09:02 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00 = '7' 313 09:09:02 SQL Execute: ORACLE - insert into XT_BBBDMX(LSH000,WJDLL0,WJBBXX,WJDBXX,XTDM00,XTBB00) values(11130.00,'DLL_YJ_ZHYW.dll','11.00.230216.000','09.00.230216;11.00.230216','7','11.00.230216') 314 09:09:02 SQL Data In: ORACLE - Rows affected = 1 315 09:09:02 SQL Execute: ORACLE - Commit 316 09:09:02 SQL Data In: ORACLE - Rows affected = 0 317 09:09:02 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00 = 'E' 318 09:09:02 SQL Execute: ORACLE - insert into XT_BBBDMX(LSH000,WJDLL0,WJBBXX,WJDBXX,XTDM00,XTBB00) values(11130.00,'DLL_SS_ZHYW.dll','11.00.220416.000','09.00.220416;11.00.220416','E','11.00.220416') 319 09:09:02 SQL Data In: ORACLE - Rows affected = 1 320 09:09:02 SQL Execute: ORACLE - Commit 321 09:09:02 SQL Data In: ORACLE - Rows affected = 0 322 09:09:02 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00 = '5' 323 09:09:02 SQL Execute: ORACLE - insert into XT_BBBDMX(LSH000,WJDLL0,WJBBXX,WJDBXX,XTDM00,XTBB00) values(11130.00,'DLL_ZYSF_ZHYW.dll','11.00.230116.001','09.00.230116;11.00.230116','5','11.00.230116') 324 09:09:02 SQL Data In: ORACLE - Rows affected = 1 325 09:09:02 SQL Execute: ORACLE - Commit 326 09:09:02 SQL Data In: ORACLE - Rows affected = 0 327 09:09:02 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00 = '7' 328 09:09:02 SQL Execute: ORACLE - insert into XT_BBBDMX(LSH000,WJDLL0,WJBBXX,WJDBXX,XTDM00,XTBB00) values(11130.00,'DLL_YJ_ZDWH.dll','11.00.230216.000','09.00.230216;11.00.230216','7','11.00.230216') 329 09:09:02 SQL Data In: ORACLE - Rows affected = 1 330 09:09:02 SQL Execute: ORACLE - Commit 331 09:09:02 SQL Data In: ORACLE - Rows affected = 0 332 09:09:02 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00 = 'C' 333 09:09:02 SQL Execute: ORACLE - insert into XT_BBBDMX(LSH000,WJDLL0,WJBBXX,WJDBXX,XTDM00,XTBB00) values(11130.00,'DLL_XMGL_ZHYW.dll','11.00.230216.000','09.00.230216;11.00.230216','C','11.00.230216') 334 09:09:02 SQL Data In: ORACLE - Rows affected = 1 335 09:09:02 SQL Execute: ORACLE - Commit 336 09:09:02 SQL Data In: ORACLE - Rows affected = 0 337 09:09:02 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00 = '7' 338 09:09:02 SQL Execute: ORACLE - insert into XT_BBBDMX(LSH000,WJDLL0,WJBBXX,WJDBXX,XTDM00,XTBB00) values(11130.00,'DLL_YJ_CXTJ.dll','11.00.230216.000','09.00.230216;11.00.230216','7','11.00.230216') 339 09:09:02 SQL Data In: ORACLE - Rows affected = 1 340 09:09:02 SQL Execute: ORACLE - Commit 341 09:09:02 SQL Data In: ORACLE - Rows affected = 0 342 09:09:02 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00 = '4' 343 09:09:02 SQL Execute: ORACLE - insert into XT_BBBDMX(LSH000,WJDLL0,WJBBXX,WJDBXX,XTDM00,XTBB00) values(11130.00,'DLL_MZSF_CXTJ.dll','11.00.230116.000','09.00.230116;11.00.230116','4','11.00.230116') 344 09:09:02 SQL Data In: ORACLE - Rows affected = 1 345 09:09:02 SQL Execute: ORACLE - Commit 346 09:09:02 SQL Data In: ORACLE - Rows affected = 0 347 09:09:02 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00 = '' 348 09:09:02 SQL Execute: ORACLE - insert into XT_BBBDMX(LSH000,WJDLL0,WJBBXX,WJDBXX,XTDM00,XTBB00) values(11130.00,'DLL_GGMK_ZHYW.dll','','','','') 349 09:09:02 SQL Data In: ORACLE - Rows affected = 1 350 09:09:02 SQL Execute: ORACLE - Commit 351 09:09:02 SQL Data In: ORACLE - Rows affected = 0 352 09:09:02 SQL Execute: ORACLE - select * from VW_XT_BBBDMX where LSH000 = 11130.00 order by XTDM00,WJDLL0