1 08:54:06 Log started for: 病案首页信息管理系统 2 08:54:06 SQL Prepare: MSSQL - SELECT DISTINCT ZDBM00,VALUE0 FROM XT_ZD0000 WHERE MRBZ00='1' 3 08:54:06 SQL Execute: MSSQL - SELECT DISTINCT ZDBM00,VALUE0 FROM XT_ZD0000 WHERE MRBZ00='1' 4 08:54:11 SQL Prepare: MSSQL - Select XTDM00 from XT_ZBQX00 where XTDM00= '0' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from XT_YGBM00 where Upper(XKH000)='ADMIN')) 5 08:54:11 SQL Execute: MSSQL - Select XTDM00 from XT_ZBQX00 where XTDM00= '0' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from XT_YGBM00 where Upper(XKH000)='ADMIN')) 6 08:54:11 SQL Prepare: MSSQL - Select * from XT_YGBM00 where UPPER(XKH000)='ADMIN' 7 08:54:11 SQL Execute: MSSQL - Select * from XT_YGBM00 where UPPER(XKH000)='ADMIN' 8 08:54:11 SQL Prepare: MSSQL - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 9 08:54:11 SQL Execute: MSSQL - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 10 08:54:11 SQL Prepare: MSSQL - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='0' and (( 249= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=249)))) 11 08:54:11 SQL Execute: MSSQL - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='0' and (( 249= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=249)))) 12 08:54:14 SQL Prepare: MSSQL - select @@spid as spid 13 08:54:14 SQL Execute: MSSQL - select @@spid as spid 14 08:54:14 SQL Prepare: MSSQL - SELECT * FROM BA_FIELDS order by table0,FID000 15 08:54:14 SQL Execute: MSSQL - SELECT * FROM BA_FIELDS order by table0,FID000 16 08:54:16 SQL Prepare: MSSQL - select * FROM BA_FIELDS ORDER BY FID000 17 08:54:16 SQL Execute: MSSQL - select * FROM BA_FIELDS ORDER BY FID000 18 09:14:21 Log started for: 病案首页信息管理系统 19 09:14:21 SQL Prepare: MSSQL - SELECT DISTINCT ZDBM00,VALUE0 FROM XT_ZD0000 WHERE MRBZ00='1' 20 09:14:21 SQL Execute: MSSQL - SELECT DISTINCT ZDBM00,VALUE0 FROM XT_ZD0000 WHERE MRBZ00='1' 21 09:14:33 SQL Prepare: MSSQL - Select XTDM00 from XT_ZBQX00 where XTDM00= '0' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from XT_YGBM00 where Upper(XKH000)='ADMIN')) 22 09:14:33 SQL Execute: MSSQL - Select XTDM00 from XT_ZBQX00 where XTDM00= '0' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from XT_YGBM00 where Upper(XKH000)='ADMIN')) 23 09:14:33 SQL Prepare: MSSQL - Select * from XT_YGBM00 where UPPER(XKH000)='ADMIN' 24 09:14:33 SQL Execute: MSSQL - Select * from XT_YGBM00 where UPPER(XKH000)='ADMIN' 25 09:14:33 SQL Prepare: MSSQL - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 26 09:14:33 SQL Execute: MSSQL - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 27 09:14:33 SQL Prepare: MSSQL - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='0' and (( 249= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=249)))) 28 09:14:33 SQL Execute: MSSQL - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='0' and (( 249= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=249)))) 29 09:14:37 SQL Prepare: MSSQL - select * from ba_fields order by fid000 30 09:14:37 SQL Execute: MSSQL - select * from ba_fields order by fid000 31 09:14:54 SQL Prepare: MSSQL - select @@spid as spid 32 09:14:54 SQL Execute: MSSQL - select @@spid as spid 33 09:14:54 SQL Prepare: MSSQL - SELECT * FROM BA_FIELDS order by table0,FID000 34 09:14:54 SQL Execute: MSSQL - SELECT * FROM BA_FIELDS order by table0,FID000 35 09:14:58 SQL Prepare: MSSQL - exec SP_GET000_LSH000 -2,0 36 09:14:58 SQL Execute: MSSQL - exec SP_GET000_LSH000 -2,0 37 09:14:58 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 38 09:14:58 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 39 09:14:58 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=? 40 09:14:59 SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=:1 41 09:14:59 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 42 09:14:59 SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=? 43 09:14:59 SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=:1 44 09:14:59 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 45 09:14:59 SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=? 46 09:14:59 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 47 09:14:59 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 48 09:14:59 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=? 49 09:15:01 SQL Prepare: MSSQL - Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=:1 50 09:15:01 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 51 09:15:01 SQL Execute: MSSQL - Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=? 52 09:15:01 SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=:1 53 09:15:01 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 54 09:15:01 SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=? 55 09:15:01 SQL Prepare: MSSQL - SELECT LSH000,BRXM00,BAH000,ZYCS00,ZYH000,BLZD00,GMYW00,HBSAG0,HCVAB0,HIVAB0,MZCYFH,RYCYFH, SQSHFH,LCBLFH,FSBLFH,QJCS00,CGCS00,BAZL00,SFSJ00,DYBL00,SFSZ00,SZQX00,SJBL00,RH0000, SXFY00,HXB000,XXB000,XJ0000,QX0000,SXQT00,XX0000,ZKRQ00,BLZDBM,BLH000,SFYWGM,LYFS00, ZYYLJG,ZZYJH0,ZZYMD0,HMRYQD,HMRYQH,HMRYQM,HMRYHD,HMRYHH,HMRYHM,SSZDYY,SSZDBM FROM BA_BRZYXX WHERE LSH000=:1 56 09:15:01 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 57 09:15:01 SQL Execute: MSSQL - SELECT LSH000,BRXM00,BAH000,ZYCS00,ZYH000,BLZD00,GMYW00,HBSAG0,HCVAB0,HIVAB0,MZCYFH,RYCYFH, SQSHFH,LCBLFH,FSBLFH,QJCS00,CGCS00,BAZL00,SFSJ00,DYBL00,SFSZ00,SZQX00,SJBL00,RH0000, SXFY00,HXB000,XXB000,XJ0000,QX0000,SXQT00,XX0000,ZKRQ00,BLZDBM,BLH000,SFYWGM,LYFS00, ZYYLJG,ZZYJH0,ZZYMD0,HMRYQD,HMRYQH,HMRYQM,HMRYHD,HMRYHH,HMRYHM,SSZDYY,SSZDBM FROM BA_BRZYXX WHERE LSH000=? 58 09:15:01 SQL Prepare: MSSQL - SELECT LSH000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0, YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,JSYS00,JSYSMC,ZRHS00,ZRHSMC FROM BA_YSXX00 WHERE LSH000=:1 59 09:15:01 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 60 09:15:01 SQL Execute: MSSQL - SELECT LSH000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0, YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,JSYS00,JSYSMC,ZRHS00,ZRHSMC FROM BA_YSXX00 WHERE LSH000=? 61 09:15:01 SQL Prepare: MSSQL - SELECT LSH000,BRXM00,BAH000,ZYCS00,ZYH000,BLZD00,GMYW00,HBSAG0,HCVAB0,HIVAB0,MZCYFH,RYCYFH, SQSHFH,LCBLFH,FSBLFH,QJCS00,CGCS00,BAZL00,SFSJ00,DYBL00,SFSZ00,SZQX00,SJBL00,RH0000, SXFY00,HXB000,XXB000,XJ0000,QX0000,SXQT00,XX0000,ZKRQ00,BLZDBM,BLH000,SFYWGM,LYFS00, ZYYLJG,ZZYJH0,ZZYMD0,HMRYQD,HMRYQH,HMRYQM,HMRYHD,HMRYHH,HMRYHM,SSZDYY,SSZDBM FROM BA_BRZYXX WHERE LSH000=:1 62 09:15:01 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 63 09:15:01 SQL Execute: MSSQL - SELECT LSH000,BRXM00,BAH000,ZYCS00,ZYH000,BLZD00,GMYW00,HBSAG0,HCVAB0,HIVAB0,MZCYFH,RYCYFH, SQSHFH,LCBLFH,FSBLFH,QJCS00,CGCS00,BAZL00,SFSJ00,DYBL00,SFSZ00,SZQX00,SJBL00,RH0000, SXFY00,HXB000,XXB000,XJ0000,QX0000,SXQT00,XX0000,ZKRQ00,BLZDBM,BLH000,SFYWGM,LYFS00, ZYYLJG,ZZYJH0,ZZYMD0,HMRYQD,HMRYQH,HMRYQM,HMRYHD,HMRYHH,HMRYHM,SSZDYY,SSZDBM FROM BA_BRZYXX WHERE LSH000=? 64 09:15:01 SQL Prepare: MSSQL - SELECT LSH000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0, YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,JSYS00,JSYSMC,ZRHS00,ZRHSMC FROM BA_YSXX00 WHERE LSH000=:1 65 09:15:01 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 66 09:15:01 SQL Execute: MSSQL - SELECT LSH000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0, YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,JSYS00,JSYSMC,ZRHS00,ZRHSMC FROM BA_YSXX00 WHERE LSH000=? 67 09:15:02 SQL Prepare: MSSQL - Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=:1 68 09:15:02 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 69 09:15:02 SQL Execute: MSSQL - Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=? 70 09:15:02 SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=:1 71 09:15:02 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 72 09:15:02 SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=? 73 09:15:02 SQL Prepare: MSSQL - SELECT FYDM00,FYMC00,BZFH00,XSSX00,SYBZ00,FYLB00,FYLBMC,HZBZ00 FROM XT_FYDM00 WHERE SYBZ00='1' AND FYLB00<>-1 ORDER BY FYDM00 74 09:15:02 SQL Execute: MSSQL - SELECT FYDM00,FYMC00,BZFH00,XSSX00,SYBZ00,FYLB00,FYLBMC,HZBZ00 FROM XT_FYDM00 WHERE SYBZ00='1' AND FYLB00<>-1 ORDER BY FYDM00 75 09:15:02 SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00 FROM BA_BRFYXX WHERE LSH000=:1 76 09:15:02 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 77 09:15:02 SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00 FROM BA_BRFYXX WHERE LSH000=? 78 09:15:02 SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00 FROM BA_BRFYXX WHERE LSH000=:1 79 09:15:02 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 80 09:15:02 SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00 FROM BA_BRFYXX WHERE LSH000=? 81 09:15:02 SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00 FROM BA_BRFYXX WHERE LSH000=:1 82 09:15:02 SQL Data In: MSSQL - Param = 1, Name = , Type = fldINT32, Precision = 0, Scale = 0, Data = 208556 83 09:15:02 SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00 FROM BA_BRFYXX WHERE LSH000=? 84 09:16:11 SQL Prepare: MSSQL - select @@spid as spid 85 09:16:11 SQL Execute: MSSQL - select @@spid as spid 86 09:16:11 SQL Prepare: MSSQL - SELECT * FROM BA_FIELDS order by table0,FID000 87 09:16:11 SQL Execute: MSSQL - SELECT * FROM BA_FIELDS order by table0,FID000 88 09:16:21 SQL Prepare: MSSQL - select * FROM BA_FIELDS ORDER BY FID000 89 09:16:21 SQL Execute: MSSQL - select * FROM BA_FIELDS ORDER BY FID000