1 15:27:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031567 2 15:27:24 SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00 from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID and G.SFXMID=? 3 15:27:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031567 4 15:27:24 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ? 5 15:27:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031567 6 15:27:24 SQL Execute: ORACLE - select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb order by c.YYJC00 7 15:27:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031567 8 15:27:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031567 9 15:27:24 SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? union select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? 10 15:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879 11 15:27:26 SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00 from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID and G.SFXMID=? 12 15:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879 13 15:27:26 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ? 14 15:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879 15 15:27:26 SQL Execute: ORACLE - select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb order by c.YYJC00 16 15:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879 17 15:27:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027879 18 15:27:26 SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? union select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? 19 15:27:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 20 15:27:27 SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00 from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID and G.SFXMID=? 21 15:27:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 22 15:27:27 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ? 23 15:27:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 24 15:27:27 SQL Execute: ORACLE - select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb order by c.YYJC00 25 15:27:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 26 15:27:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 27 15:27:27 SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? union select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? 28 15:27:27 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='门诊发票' and YXBZ00='1' 29 15:27:27 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='住院发票' and YXBZ00='1' 30 15:27:27 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='核算项目' and YXBZ00='1' 31 15:27:27 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='病案项目' and YXBZ00='1' 32 15:27:27 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='会计核算' and YXBZ00='1' 33 15:27:27 SQL Execute: ORACLE - select xmmc00 from BM_YYSFXM where bmgzid=1 and flag00='0' and TREEBH like '910006%' 34 15:27:27 SQL Execute: ORACLE - select zjbz00 from bm_yysfxm where TREEBH='910006000003' and BMGZID=1 35 15:27:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 910006000003 36 15:27:27 SQL Execute: ORACLE - select sfxmid from bm_yysfxm where BMGZID=1 and bh0000=? 37 15:27:27 SQL Execute: ORACLE - insert into BM_YBSFDY(SFXMID,SFYP00,YBZXLB,FBBH00,ZFBL00,ZYZFBL,YBLB00,SFYBXM,CJR000) select 8000031814,'N',a.YBZXLB,a.FBBH00,decode(a.FBBH00,1,1,3,1,MRZFBL),decode(a.FBBH00,1,1,3,1,ZYZFBL),decode(a.FBBH00,1,'2',3,'2',decode(MRZFBL,1,'2','0')),decode(a.FBBH00,1,'N',3,'N',decode(MRZFBL,1,'N','Y')),1913 from IC_YBBRLB a where a.YBLB00=a.YBZXLB and not exists (select 1 from BM_YBSFDY where SFXMID=8000031814 and FBBH00=a.FBBH00 and YBZXLB=a.YBZXLB and SFYP00='N') 38 15:27:27 SQL Data In: ORACLE - Rows affected = 0 39 15:27:27 SQL Execute: ORACLE - Commit 40 15:27:27 SQL Data In: ORACLE - Rows affected = 0 41 15:27:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 42 15:27:27 SQL Execute: ORACLE - select 'Y' SFXZ00,b.ybmc00,a.FBBH00,a.SFXMID,a.SFYP00,a.YBZXLB,a.YBXMBH,a.YBXMMC XMMC00, a.ZFBL00,a.ZYZFBL,a.YBLB00,a.SFYBXM,a.ZYFPXM ZYFPMC,a.MZFPXM MZFPMC, DECODE(a.YBLB00,'0','医保项目','1','部分医保','2','非医保','3','非医保','非医保') YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,a.YBBRLB,a.TZBZ00,a.PYSM00 YBPYSM,a.WBSM00 YBWBSM, a.YBMZFP,a.YBZYFP,a.XGRXM0,a.XGRQSJ,0 XGBZ00 from VW_BM_YBSFDYXMMCFP a,IC_YBBRLB b where a.sfxmid=? and a.sfyp00='N' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb and nvl(b.SFYX00,'1')='1' order by decode(a.fbbh00,3,0,a.fbbh00),b.YBMC00 43 15:27:27 SQL Execute: ORACLE - insert into BM_SFDJBZ(SFBZID, SFXMID, SFYP00, SFBZDJ) select SQ_BM_SFDJBZ_SFBZID.nextval, 8000031814, 'N', b.SFBZDJ from (select distinct SFBZDJ from XT_YYXX00) b where b.SFBZDJ <> '0' and not exists (select 1 from BM_SFDJBZ where SFXMID=8000031814 ) 44 15:27:27 SQL Data In: ORACLE - Rows affected = 0 45 15:27:27 SQL Execute: ORACLE - Commit 46 15:27:27 SQL Data In: ORACLE - Rows affected = 0 47 15:27:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 48 15:27:27 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00 from BM_SFDJBZ a where a.SFBZDJ <> '0' and a.SFXMID = ? 49 15:27:27 SQL Execute: ORACLE - insert into BM_YBDJSX(DJSXID, SFXMID, SFYP00, SFBZDJ, YBZXLB) select SQ_BM_YBDJSX_DJSXID.nextval, 8000031814, 'N', c.SFBZDJ, b.YBZXLB from IC_YBBRLB b, (select distinct SFBZDJ from XT_YYXX00) c where b.YBLB00=b.YBZXLB and c.SFBZDJ <> '0' and not exists (select 1 from BM_YBDJSX where SFXMID=8000031814 ) 50 15:27:27 SQL Data In: ORACLE - Rows affected = 0 51 15:27:27 SQL Execute: ORACLE - Commit 52 15:27:27 SQL Data In: ORACLE - Rows affected = 0 53 15:27:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 54 15:27:27 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFSX, b.YBMC00, a.YBZXLB from BM_YBDJSX a,IC_YBBRLB b where a.SFYP00='N' and a.YBZXLB=b.YBZXLB and b.YBLB00=b.YBZXLB and a.SFBZDJ <> '0' and a.SFXMID = ? order by a.SFBZDJ 55 15:27:27 SQL Execute: ORACLE - select a.sfxmid,a.bmbh00,b.xmmc00,c.bmmc00,a.CZY000 from BM_CLSYKS a ,BM_YYSFXM b,BM_BMBM00 c where a.SFXMID = 8000031814 and a.BMBH00 = c.BMBH00 and a.sfxmid = b.sfxmid 56 15:28:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 穿刺器B5LT 57 15:28:50 SQL Execute: ORACLE - select SF_XT_GETPYSM(?) SM from dual 58 15:28:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 穿刺器B5LT 59 15:28:50 SQL Execute: ORACLE - select SF_XT_GETWBSM(?) SM from dual 60 15:36:23 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 61 15:36:23 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464.000000 62 15:36:23 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16993776.000000 63 15:36:23 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 64 15:36:23 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 16993776.00) 65 15:46:23 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 66 15:46:23 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464.000000 67 15:46:23 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16993777.000000 68 15:46:23 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 69 15:46:23 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 16993777.00) 70 15:50:52 SQL Execute: ORACLE - select bh0000 from bm_yysfxm where ltrim(rtrim(bh0000))='910006000003' and bmgzid=1 71 15:50:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = U 72 15:50:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = L 73 15:50:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000031814.000000 74 15:50:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 75 15:50:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 910006000003 76 15:50:52 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 穿刺器B5LT 77 15:50:52 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = ccqb5lt 78 15:50:52 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = pgkb5lt 79 15:50:52 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 80 15:50:52 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 81 15:50:52 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = B5LT 82 15:50:52 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 83 15:50:52 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 84 15:50:52 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 85 15:50:52 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 个 86 15:50:52 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 87 15:50:52 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 88 15:50:52 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 89 15:50:52 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 90 15:50:52 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 91 15:50:52 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21 92 15:50:52 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21 93 15:50:52 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20190201 94 15:50:52 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:29:16 95 15:50:52 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 96 15:50:52 SQL Data In: ORACLE - Param = 26, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 130.000000 97 15:50:52 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 122 98 15:50:52 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 99 15:50:52 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 100 15:50:52 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 910006 101 15:50:52 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 102 15:50:52 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 103 15:50:52 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 104 15:50:52 SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 105 15:50:52 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 910006000003 106 15:50:52 SQL Data In: ORACLE - Param = 36, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 107 15:50:52 SQL Data In: ORACLE - Param = 37, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121 108 15:50:52 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 109 15:50:52 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 110 15:50:52 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 111 15:50:52 SQL Data In: ORACLE - Param = 41, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 112 15:50:52 SQL Data In: ORACLE - Param = 42, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 113 15:50:52 SQL Data In: ORACLE - Param = 43, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 114 15:50:52 SQL Data In: ORACLE - Param = 44, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 115 15:50:52 SQL Data In: ORACLE - Param = 45, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 116 15:50:52 SQL Data In: ORACLE - Param = 46, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = C1604010260000509098 117 15:50:52 SQL Data In: ORACLE - Param = 47, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 118 15:50:52 SQL Execute: ORACLE - BEGIN "SP_XM_YYWHADD" (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); END; 119 15:50:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 120 15:50:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 121 15:50:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 122 15:50:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 123 15:50:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 124 15:50:52 SQL Execute: ORACLE - select a.TREEBH,a.sfxmid,a.yydj00 yydj00, f.yydj00 yydjmc, a.bmgzid,a.bh0000,a.flag00,a.xmmc00,decode(a.FLAG00,'0',null,substr(trim(a.xmnh00),1,100)) xmnh00,decode(a.FLAG00,'0',null,substr(trim(a.cwnr00),1,100)) cwnr00, a.dw0000,a.bzje00,a.sfje00,a.fdbl00,a.sfxx00,a.sfsx00,b.xmmc00 as mzxmmc,c.xmmc00 as zyxmmc,a.qyrq00,a.qysj00,a.tzrq00,a.pysm00,a.wbsm00,a.zjbz00,d.hsxmmc AS HSMC00,d.bh0000 as yyhsbh,a.hsxmid as hsxmid,a.ZHXMBZ as zhxmbz, decode(a.flag00,'1','项目','0','类别')wflag,decode(a.zjbz00,'0','总部','1','医院','2','分部','3','不能增加')zjqx,a.MZZYBZ,decode(a.MZZYBZ,'0','限门诊','1','限住院','不限制') as MZZYMC, decode(a.SFGZ00,'Y',a.SFGZ00,'N') as SFGZ00,decode(a.SFGZ00,'Y','是','否') as SFGZMC, decode(greatest(to_char(sysdate,'YYYYMMDD'),a.Tzrq00),to_char(Sysdate,'YYYYMMDD'),'停用',a.Tzrq00, '使用')Effflag,a.BAXMID,e.BAXMMC,a.GG0000,a.SCCJ00,a.PZWH00,decode(a.FLAG00,'0',null,substr(trim(a.BZ0000),1,100)) BZ0000, a.GJBM00,a.JSXM00,substr(trim(a.LSCL00),1,100) LSCL00,trim(substrb(a.LSCL00,1,100)) LSCL01,a.RSFSX0,a.JMJE00,a.MZFPID,a.ZYFPID,a.KJXMID,g.KJXMMC,a.TXM000,a.YWBH00,a.YWMC00,a.SFZXBS,a.GJYLBM,a.BKEH83,a.GJBZMC from bm_yysfxm a,bm_fpxm00 b,bm_fpxm00 c,bm_yyhsxm d,BM_BAXM00 e,bm_yydj00 f,BM_YYKJXM g where a.yydj00=f.yydjxh and a.hsxmid=d.hsxmid(+) and b.fpxmid(+)=a.mzfpid and c.fpxmid(+)=a.zyfpid and a.KJXMID=g.KJXMID(+) and a.sfxmid<9000000000 and a.TREEBH like ? and a.bmgzid=? and a.baxmid=e.baxmid(+) and a.bmgzid=1 and a.BH0000 like '9%' and ((1=1 and '0'=?) or (a.TZRQ00 is null and '1'=?) or (a.TZRQ00 is not null and '2'=?) ) and a.flag00 = '1' order by a.TREEBH,a.bh0000 125 15:50:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 126 15:50:56 SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00 from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID and G.SFXMID=? 127 15:50:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 128 15:50:56 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ? 129 15:50:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 130 15:50:56 SQL Execute: ORACLE - select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb order by c.YYJC00 131 15:50:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 132 15:50:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031814 133 15:50:56 SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? union select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00 from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? 134 15:51:03 SQL Execute: ORACLE - RollBack 135 15:51:03 SQL Data In: ORACLE - Rows affected = 0 136 15:51:03 SQL Execute: ORACLE - Commit 137 15:51:03 SQL Data In: ORACLE - Rows affected = 0 138 15:51:03 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000= 3952234 139 15:51:03 SQL Data In: ORACLE - Rows affected = 1 140 15:51:03 SQL Execute: ORACLE - Commit 141 15:51:03 SQL Data In: ORACLE - Rows affected = 0 142 15:51:03 Log started for: SQL Navigator for Oracle 143 15:51:09 SQL Execute: SELECT bm_yysfxm.*,ROWID FROM bm_yysfxm where sfxmid='8000031814' 144 15:55:52 Log started for: 易联众医院信息综合管理平台 145 15:55:52 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 146 15:55:52 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '10.11.11.159','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 147 15:55:52 SQL Data In: ORACLE - Rows affected = 1 148 15:55:52 SQL Execute: ORACLE - Commit 149 15:55:52 SQL Data In: ORACLE - Rows affected = 0 150 15:55:52 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 151 15:55:52 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='STAR' and CZBZ00 in ('0','1') 152 15:55:52 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = 'star' and YCLBBZ ='0' and CLBZ00 = '0' 153 15:55:52 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 154 15:55:52 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=1913 and XTDM00 not in ('OE','MC') order by XTDM00 155 15:55:53 SQL Execute: ORACLE - Select SYSDATE from Dual 156 15:55:53 SQL Execute: ORACLE - Select SYSDATE from Dual 157 15:55:53 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 1913 158 15:55:53 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 1913 159 15:55:53 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 160 15:55:53 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 161 15:55:53 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 162 15:55:53 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 163 15:55:53 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 164 15:55:53 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 1913 165 15:55:53 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 1913 166 15:55:53 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '10.11.11.159' 167 15:55:53 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 168 15:55:53 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 1913 and RowNum <= 10 order by DLRQSJ DESC 169 15:55:53 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='1' order by BMPLXH,BMBH00 170 15:55:54 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='4' order by BMPLXH,BMBH00 171 15:55:55 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='5' order by BMPLXH,BMBH00 172 15:55:55 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='5' and KJLB00 ='3' 173 15:55:55 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = '5' and KJLB00 < '3' order by XH0000 174 15:55:55 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'5'||',')>0 175 15:55:56 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1913 and XTDM00 = '5' 176 15:55:56 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '5' 177 15:55:56 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 494 and FLAG00 like '0' order by decode(CKBH00,21,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 178 15:55:56 SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 179 15:55:56 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '10.11.11.159','5',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 180 15:55:56 SQL Data In: ORACLE - Rows affected = 1 181 15:55:56 SQL Execute: ORACLE - Commit 182 15:55:56 SQL Data In: ORACLE - Rows affected = 0 183 15:55:56 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 184 15:55:56 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(SERIAL#) from V$session where AUDSID= userenv('SESSIONID')) 185 15:55:56 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(3998814,1913,'FJLNYYVIEW-060','5',nvl('14375414',' '),'10.11.11.159#2703:55737@appYLZHis.exe',494,'10.11.11.159') 186 15:55:56 SQL Data In: ORACLE - Rows affected = 1 187 15:55:56 SQL Execute: ORACLE - Commit 188 15:55:56 SQL Data In: ORACLE - Rows affected = 0 189 15:55:56 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=1913 and XTDM00='5' 190 15:55:56 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '10.11.11.159' and NAME00 = 'QDXTJZ' 191 15:55:56 SQL Execute: ORACLE - select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0 from ( select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0 from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = '5' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0 from VW_PT_YHCDMK_JG a where YGBH00 = 1913 and XTDM00 = '5') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 192 15:55:56 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1913 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 193 15:55:56 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=1913 and XTDM00='5' order by XH0000 194 15:55:56 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 195 15:55:56 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000 196 15:55:56 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 197 15:55:56 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 198 15:55:56 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 199 15:55:56 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000 200 15:55:56 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18360890.000000 201 15:55:56 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 202 15:55:56 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 18360890.00) 203 15:55:56 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 204 15:55:56 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='5' 205 15:55:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 206 15:55:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 207 15:55:56 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=494 208 15:55:56 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=494 209 15:55:56 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035' 210 15:55:56 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 211 15:55:56 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 212 15:55:56 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(494) as SFBZDJ from dual 213 15:55:56 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_ZYSF_CXTJ.dll' and YGBH00 = 1913 214 15:55:57 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('YF_AutoMatch','XT_JEQZ00','ZY_RQDGSCS','ZY_FPTHBJXX') 215 15:55:57 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '福建预交金统一平台' and BH0000 = 'Open_ZY' 216 15:55:57 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 217 15:55:57 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 218 15:55:57 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 219 15:55:57 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 220 15:55:57 SQL Execute: ORACLE - select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBYL' and YBYLZD>='YBYL01' order by YBYLZD 221 15:55:57 SQL Execute: ORACLE - select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBSM' and YBYLZD>='YBSM01' order by YBYLZD 222 15:55:57 SQL Execute: ORACLE - select SF_ZY_GETZYXHLYBYBMBH(494) as ZYXHLY from dual 223 15:55:57 SQL Execute: ORACLE - select SF_ZY_GETZYXHQZBYBMBH(494) as ZYXHQZ from dual 224 15:55:57 SQL Execute: ORACLE - select JKLXBM,JKLXMC from VW_ZY_KSJSJKLX order by JKLXBM 225 15:55:57 SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'Open_MZ'), 'N') VALUE0 from dual 226 15:55:57 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 227 15:55:57 SQL Execute: ORACLE - select * from VW_ZY_YJJPJ0_JZY where CZY000= -1 and JKDID0 = 0 and JFRQ00 <= '' and JFRQ00||JFSJ00 <= '' order by PXH000,PJXH00 228 15:55:57 SQL Execute: ORACLE - select YGBH00,ZWXM00||'\'||XKH000 MC0000 from VW_ZY_SFY000 229 15:55:57 SQL Execute: ORACLE - select * from VW_BM_PJLYQK where PJLXBM in (3,6,4,8,10,20) and PJZT00 in ('未用','在用' ) and PJSYR0 = 1913 order by PJZT00 desc,PJLXBM,PJFFRQ 230 15:55:57 SQL Execute: ORACLE - select * from VW_ZY_PJSYQK_NEW where PLBH00 in (3,6,4,8,10,20) and CZY000 = 1913 and DYRQ00>= '20211125' and DYRQ00<= '20211125' and DYRQ00||DYSJ00>='2021112500:00:00' and DYRQ00||DYSJ00<='2021112523:59:59' order by PLBH00,PJXH00 231 15:55:57 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1913,'易联众ss','10.11.11.159','00-50-56-90-72-EF','5','ACT_ZYSF_SFZHCX','14375414') 232 15:55:57 SQL Data In: ORACLE - Rows affected = 1 233 15:55:57 SQL Execute: ORACLE - Commit 234 15:55:57 SQL Data In: ORACLE - Rows affected = 0 235 15:56:05 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 236 15:56:05 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='5' 237 15:56:05 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 238 15:56:05 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 239 15:56:05 SQL Execute: ORACLE - select JKLXBM,JKLXMC from VW_ZY_KSJSJKLX order by JKLXBM 240 15:56:05 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 241 15:56:05 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'Open_ZY' 242 15:56:05 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'Open_MZ' 243 15:56:05 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'JKQYSQM' 244 15:56:05 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'SFJYSZFW' 245 15:56:05 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'CYJSZFYM' 246 15:56:05 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'ZYYJJSTDJDYZFFS' 247 15:56:05 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='博思预交金电子凭证平台接口' 248 15:56:05 SQL Execute: ORACLE - select a.BMBH00, a.BMMC00, a.BH0000, a.PYSM00, a.WBSM00 from VW_BM_BQKSDZ a where PRBMBH = -1 order by a.BH0000 249 15:56:06 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1913,'易联众ss','10.11.11.159','00-50-56-90-72-EF','5','ACT_ZYSF_CX_BRZHCX','14375414') 250 15:56:06 SQL Data In: ORACLE - Rows affected = 1 251 15:56:06 SQL Execute: ORACLE - Commit 252 15:56:06 SQL Data In: ORACLE - Rows affected = 0 253 15:56:09 SQL Execute: ORACLE - select a.PRBMBH, a.BMBH00, a.BH0000, a.BMMC00, a.BMXZ00, a.PYSM00, a.WBSM00 from VW_BM_BQKSDZ a connect by a.PRBMBH = Prior a.BMBH00 start with a.BMBH00 in (-1) order by a.PRBMBH,a.BH0000 254 15:56:09 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_PUB a where 1=1 and CYRQ00 >= '20211125' and CYRQ00 <= '20211125' and a.BRZT00 in ('4','5') and Rownum <=999 order by DQBQ00,PXCWH0,ZYH000 255 16:00:30 SQL Execute: ORACLE - select a.PRBMBH, a.BMBH00, a.BH0000, a.BMMC00, a.BMXZ00, a.PYSM00, a.WBSM00 from VW_BM_BQKSDZ a connect by a.PRBMBH = Prior a.BMBH00 start with a.BMBH00 in (-1) order by a.PRBMBH,a.BH0000 256 16:00:30 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_PUB a where 1=1 and (a.BRZT00 >= '1' and a.BRZT00 <= '3') and Rownum <=999 order by DQBQ00,PXCWH0,ZYH000 257 16:00:36 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 899430.00 258 16:00:37 SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 899430.00 259 16:00:37 SQL Execute: ORACLE - select * from VW_BM_BRXXB3 where BRID00 = 2905892.00 260 16:00:37 SQL Execute: ORACLE - select * from XT_YWSHQX where SHLB00 = 8 and SHQXRY = 1913 and SFYX00 = '1' 261 16:00:37 SQL Execute: ORACLE - select nvl(PBZDYS,0) PBZDYS from ZY_BRXXB0 where ZYID00='899430' 262 16:00:37 SQL Execute: ORACLE - select nvl(WDDYCS,0) WDDYCS from ZY_BRXXB0 where ZYID00='899430'