1 16:29:47 SQL Prepare: MSSQL - Select LSH000,ZYCS00 from BA_BRZYXX where BAH000=:1 and ZYCS00 in (select MAX(ZYCS00) from BA_BRZYXX where BAH000=:2) 2 16:29:47 SQL Data In: MSSQL - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 263334 3 16:29:47 SQL Data In: MSSQL - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 263334 4 16:29:47 SQL Execute: MSSQL - Select LSH000,ZYCS00 from BA_BRZYXX where BAH000=? and ZYCS00 in (select MAX(ZYCS00) from BA_BRZYXX where BAH000=?) 5 16:29:49 SQL Prepare: MSSQL - select LSH000 from BA_BRZYXX where BAH000='263334' and ZYCS00='1' 6 16:29:49 SQL Execute: MSSQL - select LSH000 from BA_BRZYXX where BAH000='263334' and ZYCS00='1' 7 16:29:49 SQL Prepare: MSSQL - SELECT LSH000,BAH000,ZYCS00,ZYH000,BRXM00,BRXB00,BRCSRQ,BRNL00,HYZK00,ZY0000,BRLY00,CSSF00, CSXS00,MZ0000,GJ0000,SFZH00,GZDW00,GZDH00,GZYB00,JTDZ00,JTDH00,JTYB00,LXRXM0,LXRDZ0, LXRDH0,LXRGX0,ZDFS00,RYQK00,RYRQ00,RYSJ00,RYKB00,RYKBMC,RYBF00,ZKKB00,ZKKBMC,CYRQ00, CYSJ00,CYKB00,CYKBMC,CYBF00,ZYTS00,QZRQ00,XX0000,BAZT00,SRRK00,LRRY00,LRRYMC,LRRQ00, CARDNO,ZYLSH0,EJKS00,EJKSMC,JKDAH0,BRNLY0,BRNLR0,CSDS00,JGSF00,JGXS00,YECSTZ,YERYTZ, XZZ000,XZZDH0,XZZYB0,RYTJ00 FROM BA_BRZYXX WHERE LSH000=:1 8 16:29:49 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 231850 9 16:29:49 SQL Execute: MSSQL - SELECT LSH000,BAH000,ZYCS00,ZYH000,BRXM00,BRXB00,BRCSRQ,BRNL00,HYZK00,ZY0000,BRLY00,CSSF00, CSXS00,MZ0000,GJ0000,SFZH00,GZDW00,GZDH00,GZYB00,JTDZ00,JTDH00,JTYB00,LXRXM0,LXRDZ0, LXRDH0,LXRGX0,ZDFS00,RYQK00,RYRQ00,RYSJ00,RYKB00,RYKBMC,RYBF00,ZKKB00,ZKKBMC,CYRQ00, CYSJ00,CYKB00,CYKBMC,CYBF00,ZYTS00,QZRQ00,XX0000,BAZT00,SRRK00,LRRY00,LRRYMC,LRRQ00, CARDNO,ZYLSH0,EJKS00,EJKSMC,JKDAH0,BRNLY0,BRNLR0,CSDS00,JGSF00,JGXS00,YECSTZ,YERYTZ, XZZ000,XZZDH0,XZZYB0,RYTJ00 FROM BA_BRZYXX WHERE LSH000=? 10 16:30:23 Log started for: 住院医生工作站系统 11 16:30:26 SQL Prepare: ORACLE - SELECT C.FBMC00,A.LSH000,A.BAH000,A.ZYCS00,A.ZYH000,A.YBKH00,A.JKDAH0,' ' QTYBKH,A.MZYS00,A.BRXM00,A.BRXB00, to_date(A.BRCSRQ,'YYYYMMDD') BRCSRQ,A.YECSTZ,A.YERYTZ, A.BRNL00,A.HYZK00,A.ZY0000,A.BRLY00,NVL(A.CSSF00,'福建') CSSF00,A.CSDS00,A.CSXS00,A.JGSF00,A.JGXS00, A.MZ0000,A.GJ0000,A.SFZH00,A.XZZSF0,A.XZZDQ0,A.XZZXS0,A.XZZXC0,A.XZZDH0,A.XZZYB0,A.JTDZSF,A.JTDZDQ,A.JTDZXS,A.JTDZ01, A.GZDW00,A.GZDH00,A.GZYB00,A.JTDZ00,A.JTDH00,A.JTYB00,A.LXRXM0,A.LXRDZ0,A.LXRDH0,A.LXRGX0, A.ZDFS00,A.RYQK00,to_date(A.RYRQ00,'YYYYMMDD') RYRQ00,A.RYSJ00,A.RYKB00,A.RYKBMC,A.RYBF00, A.RYTJ00,A.RYTJ01,A.RYQZL0,A.RYQZL1, to_date(decode(A.CYRQ00,null,decode(b.cyrq00,'20991231',null,b.cyrq00),A.CYRQ00),'YYYYMMDD') CYRQ00, A.CYSJ00,A.CYKB00,A.CYKBMC,A.CYBF00,A.CYFS00,A.CYFS01,A.ZLLB00,A.ZLLB01,A.ZKKB00,A.ZKKBMC,A.ZKBF00, A.ZZZYZJ,A.ZZZYZ1,A.ZYTS00,to_date(A.QZRQ00,'YYYYMMDD') QZRQ00, A.SRRK00,A.LRRY00,A.LRRYMC,to_date(A.LRRQ00,'YYYYMMDD') LRRQ00,A.CARDNO,A.ZYLSH0,A.EJKS00,A.EJKSMC, A.BLZD00,A.BLH000,A.SSZDWY,A.SFYWGM,A.GMYW00,A.ZYMZCY,A.ZYRYCY,A.HBSAG0,A.HCVAB0,A.HIVAB0, A.MZCYFH,A.RYCYFH,A.SQSHFH,A.LCBLFH,A.FSBLFH, A.QJCS00,A.CGCS00,A.QJFF00,A.QJFF01,A.SFWZ00,A.SFWZ01,A.SFJZ00,A.SFJZ01,A.SFYNQK,A.YNQK01, A.KZR000,A.KZRMC0,A.FZR000,A.FZRMC0,A.ZZYS00,A.ZZYSMC,A.ZYYS00,A.ZYYSMC, A.ZRHS00,A.ZRHSMC,A.JXYS00,A.JXYSMC,A.YJSYS0,A.YJSMC0,A.SXYS00,A.SXYSMC,A.ZKYS00,A.ZKYSMC,A.ZKHS00,A.ZKHSMC,A.BAZT00,A.BAZL00, A.XX0000,A.LXRDZ1,A.RH0000,A.SFSJ00,A.BLZDBM,to_date(A.ZKRQ00,'YYYYMMDD') ZKRQ00, nvl(A.YLFKFS,'-1') YLFKFS, nvl(A.FKFSMC,C.FBMC00) FKFSMC FROM BA_BRZYXX A, ZY_BRXXB0 B,BM_BRFBB0 C WHERE A.LSH000=B.ZYID00 AND A.LSH000=:1 and B.FBBH00=C.FBBH00 12 16:30:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 750475.000000 13 16:30:26 SQL Execute: ORACLE - SELECT C.FBMC00,A.LSH000,A.BAH000,A.ZYCS00,A.ZYH000,A.YBKH00,A.JKDAH0,' ' QTYBKH,A.MZYS00,A.BRXM00,A.BRXB00, to_date(A.BRCSRQ,'YYYYMMDD') BRCSRQ,A.YECSTZ,A.YERYTZ, A.BRNL00,A.HYZK00,A.ZY0000,A.BRLY00,NVL(A.CSSF00,'福建') CSSF00,A.CSDS00,A.CSXS00,A.JGSF00,A.JGXS00, A.MZ0000,A.GJ0000,A.SFZH00,A.XZZSF0,A.XZZDQ0,A.XZZXS0,A.XZZXC0,A.XZZDH0,A.XZZYB0,A.JTDZSF,A.JTDZDQ,A.JTDZXS,A.JTDZ01, A.GZDW00,A.GZDH00,A.GZYB00,A.JTDZ00,A.JTDH00,A.JTYB00,A.LXRXM0,A.LXRDZ0,A.LXRDH0,A.LXRGX0, A.ZDFS00,A.RYQK00,to_date(A.RYRQ00,'YYYYMMDD') RYRQ00,A.RYSJ00,A.RYKB00,A.RYKBMC,A.RYBF00, A.RYTJ00,A.RYTJ01,A.RYQZL0,A.RYQZL1, to_date(decode(A.CYRQ00,null,decode(b.cyrq00,'20991231',null,b.cyrq00),A.CYRQ00),'YYYYMMDD') CYRQ00, A.CYSJ00,A.CYKB00,A.CYKBMC,A.CYBF00,A.CYFS00,A.CYFS01,A.ZLLB00,A.ZLLB01,A.ZKKB00,A.ZKKBMC,A.ZKBF00, A.ZZZYZJ,A.ZZZYZ1,A.ZYTS00,to_date(A.QZRQ00,'YYYYMMDD') QZRQ00, A.SRRK00,A.LRRY00,A.LRRYMC,to_date(A.LRRQ00,'YYYYMMDD') LRRQ00,A.CARDNO,A.ZYLSH0,A.EJKS00,A.EJKSMC, A.BLZD00,A.BLH000,A.SSZDWY,A.SFYWGM,A.GMYW00,A.ZYMZCY,A.ZYRYCY,A.HBSAG0,A.HCVAB0,A.HIVAB0, A.MZCYFH,A.RYCYFH,A.SQSHFH,A.LCBLFH,A.FSBLFH, A.QJCS00,A.CGCS00,A.QJFF00,A.QJFF01,A.SFWZ00,A.SFWZ01,A.SFJZ00,A.SFJZ01,A.SFYNQK,A.YNQK01, A.KZR000,A.KZRMC0,A.FZR000,A.FZRMC0,A.ZZYS00,A.ZZYSMC,A.ZYYS00,A.ZYYSMC, A.ZRHS00,A.ZRHSMC,A.JXYS00,A.JXYSMC,A.YJSYS0,A.YJSMC0,A.SXYS00,A.SXYSMC,A.ZKYS00,A.ZKYSMC,A.ZKHS00,A.ZKHSMC,A.BAZT00,A.BAZL00, A.XX0000,A.LXRDZ1,A.RH0000,A.SFSJ00,A.BLZDBM,to_date(A.ZKRQ00,'YYYYMMDD') ZKRQ00, nvl(A.YLFKFS,'-1') YLFKFS, nvl(A.FKFSMC,C.FBMC00) FKFSMC FROM BA_BRZYXX A, ZY_BRXXB0 B,BM_BRFBB0 C WHERE A.LSH000=B.ZYID00 AND A.LSH000=? and B.FBBH00=C.FBBH00 14 16:30:26 SQL Prepare: ORACLE - SELECT A.ID0000, A.ZYID00 LSH000,0 ZDXH00, A.ZDLB00,B.VALUE0 AS ZDLBMC, A.ZDM000 JBBM00,' ' XHBM00,A.ZDMC00 JBMC00,A.FZBM00,A.FZMC00, to_date(decode(A.ZDRQ00,'00000000','',A.ZDRQ00),'YYYYMMDD') ZDRQ00, A.ZLXG00 ZLXGID,D.MC0000 ZLXG00, A.SFYZ00 SFYZID, E.MC0000 SFYZ00, A.BRID00, A.LRR000, a.M16800 ,a.RYBQ00 FROM BQ_BRZDXX A ,XT_ZD0000 B, XT_ZLXG00 D, XT_SFYZ00 E WHERE A.zyid00=:1 AND A.ZDLB00=B.DM0000 AND B.ZDBM00='ZDLB00' AND A.ZLXG00=D.DM0000(+) and A.SFYZ00=E.DM0000(+) and A.ZDFS00='1' order by B.PLXH00,A.ID0000 15 16:30:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 750475.000000 16 16:30:26 SQL Execute: ORACLE - SELECT A.ID0000, A.ZYID00 LSH000,0 ZDXH00, A.ZDLB00,B.VALUE0 AS ZDLBMC, A.ZDM000 JBBM00,' ' XHBM00,A.ZDMC00 JBMC00,A.FZBM00,A.FZMC00, to_date(decode(A.ZDRQ00,'00000000','',A.ZDRQ00),'YYYYMMDD') ZDRQ00, A.ZLXG00 ZLXGID,D.MC0000 ZLXG00, A.SFYZ00 SFYZID, E.MC0000 SFYZ00, A.BRID00, A.LRR000, a.M16800 ,a.RYBQ00 FROM BQ_BRZDXX A ,XT_ZD0000 B, XT_ZLXG00 D, XT_SFYZ00 E WHERE A.zyid00=? AND A.ZDLB00=B.DM0000 AND B.ZDBM00='ZDLB00' AND A.ZLXG00=D.DM0000(+) and A.SFYZ00=E.DM0000(+) and A.ZDFS00='1' order by B.PLXH00,A.ID0000 17 16:30:26 SQL Prepare: ORACLE - select a.dpkjmc,b.DPKJLX,a.dpbz00 from BA_BASYDP a,BA_BADPDX b where a.LSH000=:1 and a.DPLB00='0' and a.DPKJMC=b.DPKJMC and a.DPLB00=b.DPLB00 order by b.dpdxlb,b.pxxh00 18 16:30:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 750475.000000 19 16:30:26 SQL Execute: ORACLE - select a.dpkjmc,b.DPKJLX,a.dpbz00 from BA_BASYDP a,BA_BADPDX b where a.LSH000=? and a.DPLB00='0' and a.DPKJMC=b.DPKJMC and a.DPLB00=b.DPLB00 order by b.dpdxlb,b.pxxh00