1       16:16:55  Log started for: 病案首页信息管理系统
2       16:16:55  SQL Prepare: MSSQL - SELECT DISTINCT ZDBM00,VALUE0 FROM XT_ZD0000 WHERE MRBZ00='1'

3       16:16:55  SQL Execute: MSSQL - SELECT DISTINCT ZDBM00,VALUE0 FROM XT_ZD0000 WHERE MRBZ00='1'

4       16:16:58  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)='063'))

5       16:16:58  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)='063'))

6       16:16:58  SQL Prepare: MSSQL -  Select * from XT_YGBM00 where UPPER(XKH000)='063'

7       16:16:58  SQL Execute: MSSQL -  Select * from XT_YGBM00 where UPPER(XKH000)='063'

8       16:16:58  SQL Prepare: MSSQL -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

9       16:16:58  SQL Execute: MSSQL -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

10      16:16:58  SQL Prepare: MSSQL -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='0' and (( 
151= 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=151))))

11      16:16:58  SQL Execute: MSSQL -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='0' and (( 
151= 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=151))))

12      16:16:59  SQL Prepare: MSSQL - exec SP_GET000_LSH000 -2,0

13      16:16:59  SQL Execute: MSSQL - exec SP_GET000_LSH000 -2,0

14      16:16: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
 
 

15      16:16: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=?
 
 

16      16:17:00  SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=:1

17      16:17:00  SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=?

18      16:17:00  SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=:1

19      16:17:00  SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=?

20      16:17:00  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
 
 

21      16:17:00  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=?
 
 

22      16:17:02  SQL Prepare: MSSQL -  Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=:1

23      16:17:02  SQL Execute: MSSQL -  Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=?

24      16:17:02  SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=:1

25      16:17:02  SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=?

26      16:17: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

27      16:17: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

28      16:17:02  SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=:1

29      16:17:02  SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=?

30      16:17:02  SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=:1

31      16:17:02  SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=?

32      16:17:02  SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=:1

33      16:17:02  SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=?

34      16:36:13  SQL Prepare: MSSQL -  Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=:1

35      16:36:13  SQL Execute: MSSQL -  Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=?

36      16:36:13  SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=:1

37      16:36:13  SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=?

38      16:36:13  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
 
 

39      16:36:13  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      16:36:13  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
 
 

41      16:36:13  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=?
 
 

42      16:37:37  SQL Prepare: MSSQL -  Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=:1

43      16:37:37  SQL Execute: MSSQL -  Select MAX(ZDXH00) ZDXH00 from BA_BRZDXX where LSH000=?

44      16:37:37  SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=:1

45      16:37:37  SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=?

46      16:37:37  SQL Prepare: MSSQL - SELECT FYDM00,FYMC00,BZFH00,XSSX00,SYBZ00,FYLB00,FYLBMC,HZBZ00
FROM XT_FYDM00
WHERE SYBZ00='1' AND FYLB00<>-1
ORDER BY FYDM00

47      16:37:37  SQL Execute: MSSQL - SELECT FYDM00,FYMC00,BZFH00,XSSX00,SYBZ00,FYLB00,FYLBMC,HZBZ00
FROM XT_FYDM00
WHERE SYBZ00='1' AND FYLB00<>-1
ORDER BY FYDM00

48      16:37:37  SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=:1

49      16:37:37  SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=?

50      16:37:37  SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=:1

51      16:37:37  SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=?

52      16:37:37  SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=:1

53      16:37:37  SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=?

54      16:38:26  SQL Prepare: MSSQL -  Select LSH000,ZYCS00 from BA_BRZYXX where BAH000=:1 and ZYCS00 in (select MAX(ZYCS00) from BA_BRZYXX where BAH000=:2)

55      16:38:26  SQL Execute: MSSQL -  Select LSH000,ZYCS00 from BA_BRZYXX where BAH000=? and ZYCS00 in (select MAX(ZYCS00) from BA_BRZYXX where BAH000=?)

56      16:38:27  SQL Prepare: MSSQL -  select LSH000 from BA_BRZYXX where BAH000='262408' and ZYCS00='1'

57      16:38:27  SQL Execute: MSSQL -  select LSH000 from BA_BRZYXX where BAH000='262408' and ZYCS00='1'

58      16:38:27  SQL Prepare: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=:1

59      16:38:27  SQL Execute: MSSQL - SELECT LSH000,FYDM00,FYMC00,JE0000,JFFS00
FROM BA_BRFYXX
WHERE LSH000=?

60      16:38:27  SQL Prepare: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=:1

61      16:38:27  SQL Execute: MSSQL - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,RYRQ00,CYRQ00,QZRQ00,BRXB00,BAZT00,LSH000
FROM BA_BRZYXX
WHERE LSH000=?