1 15:16:49 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
2 15:16:49 SQL Execute: ORACLE - Select SYSDATE from Dual
3 15:16:50 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
4 15:16:50 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYBK59453675'
and ICKNBH = 'FZYBK59453675'
5 15:16:50 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(480) as SFBZDJ from dual
6 15:16:50 SQL Execute: ORACLE - select a.YBZXLB from IC_YBBRLB a ,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 =328872
7 15:16:50 SQL Execute: ORACLE - select GHKS00,JZYS00,JZYSXM from sf_brxxb0 where ghid00=9804533
8 15:16:50 SQL Execute: ORACLE - select sysdate from dual
9 15:16:50 SQL Execute: ORACLE - select * from vw_yj_yw0000_wzx b
where xmzt00 in('0','1') and brid00=328872
and kdrq00 = '20231227'
and ((YJKSBH = 480) or (KDKSBH = 480) 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))
order by YJDJH0 desc
10 15:16:54 SQL Execute: ORACLE - Select distinct zlxmbh,zlxmjc from BM_ZLZD00 where lbbz00='0' AND SFYXSQ='Y' and zlxmbh Like '%' and QYRQ00 IS NOT NULL AND ((TZRQ00 IS NULL) OR (TZRQ00>TO_CHAR(SYSDATE,'YYYYMMDD'))) order by zlxmbh
11 15:16:54 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%Y%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='0' or MZZYBZ='2') and ((ybbrlb='03' and YBZXLB='1' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'1'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
12 15:16:55 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 24911 and a.SFBZDJ = 0 order by xmmc00
13 15:16:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000028980
14 15:16:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
15 15:16:55 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
16 15:16:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000028980
17 15:16:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
18 15:16:55 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
19 15:16:55 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%YC%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='0' or MZZYBZ='2') and ((ybbrlb='03' and YBZXLB='1' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'1'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
20 15:16:56 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 19186 and a.SFBZDJ = 0 order by xmmc00
21 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027582
22 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
23 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
24 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027582
25 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
26 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
27 15:16:56 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%YCX%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='0' or MZZYBZ='2') and ((ybbrlb='03' and YBZXLB='1' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'1'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
28 15:16:56 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 24924 and a.SFBZDJ = 0 order by xmmc00
29 15:16:56 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%YCXS%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='0' or MZZYBZ='2') and ((ybbrlb='03' and YBZXLB='1' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'1'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
30 15:16:56 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 19186 and a.SFBZDJ = 0 order by xmmc00
31 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027582
32 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
33 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
34 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027582
35 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
36 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
37 15:16:56 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%YCXSY%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='0' or MZZYBZ='2') and ((ybbrlb='03' and YBZXLB='1' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'1'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
38 15:16:56 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 19186 and a.SFBZDJ = 0 order by xmmc00
39 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027582
40 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
41 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
42 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000027582
43 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
44 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
45 15:16:56 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%YCXSYX%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='0' or MZZYBZ='2') and ((ybbrlb='03' and YBZXLB='1' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'1'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
46 15:16:56 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 25781 and a.SFBZDJ = 0 order by xmmc00
47 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031783
48 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
49 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
50 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031783
51 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
52 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
53 15:16:56 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%YCXSYXT%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='0' or MZZYBZ='2') and ((ybbrlb='03' and YBZXLB='1' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'1'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
54 15:16:56 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 25781 and a.SFBZDJ = 0 order by xmmc00
55 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031783
56 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
57 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
58 15:16:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000031783
59 15:16:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
60 15:16:56 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
61 15:16:58 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 26543 and a.SFBZDJ = 0 order by xmmc00
62 15:16:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000033843
63 15:16:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
64 15:16:58 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
65 15:16:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000033843
66 15:16:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
67 15:16:58 SQL Execute: ORACLE - select SF_KS_SFXMGETKC( ?,?,0,2) from dual
68 15:16:59 SQL Execute: ORACLE - select zlxmjc,zxmid0 zlxmid,gdxmbz,''jgms00,jgdw00,ckz000,bbid00,zyzbid,zxmbh0 zlxmbh from VW_YS_YWMXXM WHERE SJXMID=26543 order by zxmbh0
69 15:16:59 SQL Execute: ORACLE - select * from BM_JYXMBB where ZLXMID=26543
70 15:17:03 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='9804533'
and LBBH00='0'
71 15:17:03 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='328872'
and ZT0000='1'
72 15:17:03 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='328872'
and ZT0000='1'
73 15:17:03 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
74 15:17:03 SQL Execute: ORACLE - Select SYSDATE from Dual
75 15:17:04 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
76 15:17:04 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYBK59453675'
and ICKNBH = 'FZYBK59453675'
77 15:17:04 SQL Execute: ORACLE - select a.GHQXBZ from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 AND b.GHH000='9804533'
78 15:17:04 SQL Execute: ORACLE - select a.LBMC00,b.GHLB00 from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 and b.GHH000='9804533'
79 15:17:04 SQL Execute: ORACLE - select ZDMC00,BH0000,MC0000,BZ0000,YXBZ00 from BM_TYZD00 where ZDMC00='特定挂号类别项目' and BH0000='26'
80 15:17:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 急诊科
81 15:17:04 SQL Execute: ORACLE - select BMBH00 from vw_yj_kdks00 where bmmc00=?
82 15:17:04 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
83 15:17:04 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data =
84 15:17:04 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 9804533
85 15:17:04 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
86 15:17:04 SQL Data In: ORACLE - Param = 5, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26543
87 15:17:04 SQL Data In: ORACLE - Param = 6, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26543
88 15:17:04 SQL Data In: ORACLE - Param = 7, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
89 15:17:04 SQL Data In: ORACLE - Param = 8, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
90 15:17:04 SQL Data In: ORACLE - Param = 9, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
91 15:17:04 SQL Data In: ORACLE - Param = 10, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
92 15:17:04 SQL Data In: ORACLE - Param = 11, Name = PYJLRBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
93 15:17:04 SQL Data In: ORACLE - Param = 12, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
94 15:17:04 SQL Data In: ORACLE - Param = 13, Name = PKDYS00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057
95 15:17:04 SQL Data In: ORACLE - Param = 14, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
96 15:17:04 SQL Data In: ORACLE - Param = 15, Name = PKDBQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
97 15:17:04 SQL Data In: ORACLE - Param = 16, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
98 15:17:04 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6
99 15:17:04 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
100 15:17:04 SQL Data In: ORACLE - Param = 19, Name = PFJDJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
101 15:17:04 SQL Data In: ORACLE - Param = 20, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057
102 15:17:04 SQL Data In: ORACLE - Param = 21, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
103 15:17:04 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
104 15:17:04 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
105 15:17:04 SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
106 15:17:04 SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
107 15:17:04 SQL Data In: ORACLE - Param = 26, Name = PYWMXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
108 15:17:04 SQL Data In: ORACLE - Param = 27, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
109 15:17:04 SQL Data In: ORACLE - Param = 28, Name = PFYJDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
110 15:17:04 SQL Data In: ORACLE - Param = 29, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
111 15:17:04 SQL Data In: ORACLE - Param = 30, Name = PYZCFID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
112 15:17:04 SQL Data In: ORACLE - Param = 31, Name = PSSDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
113 15:17:04 SQL Data In: ORACLE - Param = 32, Name = PTXM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
114 15:17:04 SQL Data In: ORACLE - Param = 33, Name = PWZBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
115 15:17:04 SQL Data In: ORACLE - Param = 34, Name = PSSBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
116 15:17:04 SQL Data In: ORACLE - Param = 35, Name = PSSMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
117 15:17:04 SQL Data In: ORACLE - Param = 36, Name = PSSYJDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
118 15:17:04 SQL Data In: ORACLE - Param = 37, Name = PWZBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
119 15:17:04 SQL Data In: ORACLE - Param = 38, Name = PTQPC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
120 15:17:04 SQL Data In: ORACLE - Param = 39, Name = PXMZK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
121 15:17:04 SQL Data In: ORACLE - Param = 40, Name = PYJZHJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
122 15:17:04 SQL Data In: ORACLE - Param = 41, Name = PTCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
123 15:17:04 SQL Data In: ORACLE - Param = 42, Name = PMBMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
124 15:17:04 SQL Data In: ORACLE - Param = 43, Name = PSFTJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
125 15:17:04 SQL Data In: ORACLE - Param = 44, Name = PSFZF00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
126 15:17:04 SQL Data In: ORACLE - Param = 45, Name = PYYGXJG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
127 15:17:04 SQL Data In: ORACLE - Param = 46, Name = PBWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
128 15:17:04 SQL Data In: ORACLE - Param = 47, Name = PZLXMJC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
129 15:17:04 SQL Data In: ORACLE - Param = 48, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
130 15:17:04 SQL Data In: ORACLE - Param = 49, Name = PSFFR00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
131 15:17:04 SQL Data In: ORACLE - Param = 50, Name = PDCNYJ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
132 15:17:04 SQL Data In: ORACLE - Param = 51, Name = PXMLSTR, Type = fldZSTRING, Precision = 53, Scale = 0, Data = 00
133 15:17:04 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;
134 15:17:04 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医疗费用智慧管控系统外部接口' and BH0000 = 'SFTCXSJKHHXX'
135 15:17:04 SQL Execute: ORACLE - select nvl(MC0000,'0') MC0000,BH0000 from BM_TYZD00 where ZDMC00='医疗费用智慧管控系统外部接口' and YXBZ00 = '1'
136 15:17:04 SQL Execute: ORACLE - commit
137 15:17:04 SQL Data In: ORACLE - Rows affected = 0
138 15:17:04 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ'
139 15:17:04 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB'
140 15:17:05 SQL Execute: ORACLE - select sysdate from dual
141 15:17:05 SQL Execute: ORACLE - select * from vw_yj_yw0000_wzx b
where xmzt00 in('0','1') and brid00=328872
and kdrq00 = '20231227'
and ((YJKSBH = 480) or (KDKSBH = 480) 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))
order by YJDJH0 desc
142 15:17:05 SQL Execute: ORACLE - select * from VW_YJ_YWJJ00 where YJDJH0 = 50588142 order by ID0000
143 15:17:05 SQL Execute: ORACLE - select * from VW_YJ_YWMX00 where YJDJH0 = 50588142 order by ID0000
144 15:17:05 SQL Execute: ORACLE - select * from VW_YJ_YWJJ00 where YJDJH0 = 50588142 order by ID0000
145 15:17:05 SQL Execute: ORACLE - select * from VW_YJ_YWMX00 where YJDJH0 = 50588142 order by ID0000
146 15:17:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 328872
147 15:17:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
148 15:17:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
149 15:17:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
150 15:17:05 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
151 15:17:05 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and BRID00 = ? 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+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',553,819,914,931,480,816,1051,561,978,477,936,729,675,',',480,')>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.SJSL00 > 0 and ZYHGHH = '9804533' and KDRQ00 between '20231220' and '20231227' order by XMZT00,YJDJH0 Desc
152 15:17:06 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588142
153 15:17:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
154 15:17:06 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 50588142 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000
155 15:17:06 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=328872
156 15:17:06 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(328872,'0',9804533) from dual
157 15:17:06 SQL Execute: ORACLE - select '328872' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '15959192373' BRLXDH,'9804533' ZYHGHH, '郑力' BRXM00, '男' BRXB00, '39岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '328872') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='328872' ) JZFPBZ from dual
158 15:17:06 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(328872,'0',9804533) from dual
159 15:17:06 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588142
160 15:17:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
161 15:17:06 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 50588142 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000
162 15:17:06 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=328872
163 15:17:06 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(328872,'0',9804533) from dual
164 15:17:06 SQL Execute: ORACLE - select '328872' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '15959192373' BRLXDH,'9804533' ZYHGHH, '郑力' BRXM00, '男' BRXB00, '39岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '328872') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='328872' ) JZFPBZ from dual
165 15:17:08 SQL Execute: ORACLE - select A.*,A.kcje00-A.GJJE00 as JXCJ00,decode(sign(nvl(A.GYRY00,0)),-1,'系统',1,(select ZWXM00 from BM_YGBM00 where YGBH00=A.GYRY00),'') GYRYXM from
( select KCLSH0,YPNM00,YPBM00,YPMC00,YPGG00,CZFLMC,SCPH00,GJJ000,YKKCXX,SJKCXX,KCJE00,SCCJZW,KCDW00,JLDW00,
ZYFYDW,MZFYDW,K2ZJJL,ZJJL2J,M2J000,KCXX00,KCSX00,HGH000,PYSM00,WBSM00,SFZTPD,YKRKPC,
YPMLBZ,LSJ000,YKKCSL,SJKCSL,GJJE00,YFBMBH,LBBH00,YLBH00,JXBH00,TYMBH0,SFYX00,0 PXXH00,
0 JXCJ00_HJ,0 GJJE00_HJ,0 KCJE00_HJ,0 JLS000,YPSXRQ,GYRY00,GYRQSJ,TXM000,GHDWMC,YKBMBH,SFBZMC,null BYKSLL,TZRQ00
from VW_KS_PCKCXX union all
select KCLSH0,YPNM00,YPBM00,YPMC00,YPGG00,CZFLMC,SCPH00,GJJ000,YKKCXX,SJKCXX,KCJE00,SCCJZW,KCDW00,JLDW00,
ZYFYDW,MZFYDW,K2ZJJL,ZJJL2J,M2J000,KCXX00,KCSX00,HGH000,PYSM00,WBSM00,SFZTPD,YKRKPC,
YPMLBZ,LSJ000,YKKCSL,SJKCSL,GJJE00,YFBMBH,LBBH00,YLBH00,JXBH00,TYMBH0,SFYX00,1 PXXH00,
KCJE00-GJJE00 as JXCJ00_HJ, GJJE00 GJJE00_HJ,KCJE00 KCJE00_HJ,1 JLS000,YPSXRQ,GYRY00,GYRQSJ,null,null,YKBMBH,SFBZMC,BYKSLL,TZRQ00
from VW_KS_PCKCHZ V) A
where ( (A.YLBH00 like '%' ) or ('9'='-1') )
and ((A.TYMBH0='ALL' or 'ALL'='ALL') or ('9'='-1') )
and ((YKBMBH+0=0) or (0=0))
and TZRQ00 is null
and A.YPNM00=7000246102
and A.YFBMBH=480
order by YLBH00,YPBM00,PXXH00,YKRKPC
166 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
167 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
168 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
169 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
170 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
171 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
172 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
173 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
174 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
175 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
176 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
177 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
178 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
179 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
180 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
181 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
182 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
183 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
184 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
185 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
186 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
187 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
188 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
189 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
190 15:17:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
191 15:17:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
192 15:17:08 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
193 15:17:15 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'
194 15:17:15 SQL Execute: ORACLE - Select SYSDATE from Dual
195 15:17:16 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')
196 15:17:16 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYBK59453675'
and ICKNBH = 'FZYBK59453675'
197 15:17:16 SQL Execute: ORACLE - select * from VW_YJ_YW0000_WZX where xmzt00 in ('0','1','5') and yjdjh0=50588142
198 15:17:16 SQL Execute: ORACLE - select zlxmbh,LBBH00 from bm_zlzd00 where zlxmid=26543
199 15:17:16 SQL Execute: ORACLE - select a.YBZXLB from IC_YBBRLB a ,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 =328872
200 15:17:16 SQL Execute: ORACLE - select zlxmbh from bm_zlzd00 where zlxmid=26543
201 15:17:16 SQL Execute: ORACLE - select zlxmjc,zxmid0 zlxmid,gdxmbz,''jgms00,jgdw00,ckz000,bbid00,zyzbid,zxmbh0 zlxmbh from VW_YS_YWMXXM WHERE SJXMID=26543 order by zxmbh0
202 15:17:16 SQL Execute: ORACLE - select b.zlxmid zlxmid,a.sl0000 sl0000 from yj_ywmx00 a,bm_zlzd00 b where b.zlxmbh in( select decode(length(d.zlxmbh),13,substr(d.zlxmbh,1,10),d.zlxmbh) from yj_ywmx00 c,bm_zlzd00 d where c.yjdjh0=50588142 and c.zlxmid=d.zlxmid) and a.yjdjh0=50588142 and a.zlxmid=b.zlxmid
203 15:17:16 SQL Execute: ORACLE - select BMMC00,BMBH00 from VW_YS_YJZXKS where ZLXMID=26543
204 15:17:16 SQL Execute: ORACLE - SELECT KDBQ00 FROM YJ_YW0000 WHERE YJDJH0=50588142
205 15:17:16 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328872.000000
206 15:17:16 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
207 15:17:16 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
208 15:17:16 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
209 15:17:16 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
210 15:17:16 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
211 15:17:16 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
212 15:17:16 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
213 15:17:16 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
214 15:17:16 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
215 15:17:16 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
216 15:17:16 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
217 15:17:16 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
218 15:17:16 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
219 15:17:16 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
220 15:17:16 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
221 15:17:16 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
222 15:17:16 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END;
223 15:17:21 SQL Execute: ORACLE - select DLKSZX,b.BMBH00,b.BMMC00 from bm_zlzd00 A,bm_bmbm00 b where ZLXMID = 26543 and a.ZXKS00=b.Bmbh00(+)
224 15:17:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
225 15:17:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26543.000000
226 15:17:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
227 15:17:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035
228 15:17:21 SQL Execute: ORACLE - select BMBH00,BMMC00 from VW_YS_YJJSKS
where SQXMKS=? and ZLXMID=? order by decode(bmbh00,?,0,1),decode(yyid00,?,0,1),nvl(ksxmid,99999)
229 15:17:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26543.000000
230 15:17:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
231 15:17:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035
232 15:17:21 SQL Execute: ORACLE - select BMBH00,BMMC00 from VW_YS_YJZXKS where ZLXMID=? order by decode(bmbh00,?,0,1),decode(yyid00,?,0,1),nvl(ksxmid,99999)
233 15:17:21 SQL Execute: ORACLE - select * from BM_JYXMBB where ZLXMID=26543
234 15:17:21 SQL Execute: ORACLE - select * from BM_BBZD00 where SFYX00='1' and (LBBH00=2 or LBBH00 is null) and BBID00=''
235 15:17:21 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
236 15:17:21 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 50588142
237 15:17:21 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 9804533
238 15:17:21 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
239 15:17:21 SQL Data In: ORACLE - Param = 5, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26543
240 15:17:21 SQL Data In: ORACLE - Param = 6, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26543
241 15:17:21 SQL Data In: ORACLE - Param = 7, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
242 15:17:21 SQL Data In: ORACLE - Param = 8, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
243 15:17:21 SQL Data In: ORACLE - Param = 9, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
244 15:17:21 SQL Data In: ORACLE - Param = 10, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
245 15:17:21 SQL Data In: ORACLE - Param = 11, Name = PYJLRBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
246 15:17:21 SQL Data In: ORACLE - Param = 12, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
247 15:17:21 SQL Data In: ORACLE - Param = 13, Name = PKDYS00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057
248 15:17:21 SQL Data In: ORACLE - Param = 14, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
249 15:17:21 SQL Data In: ORACLE - Param = 15, Name = PKDBQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
250 15:17:21 SQL Data In: ORACLE - Param = 16, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
251 15:17:21 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9
252 15:17:21 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
253 15:17:21 SQL Data In: ORACLE - Param = 19, Name = PFJDJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
254 15:17:21 SQL Data In: ORACLE - Param = 20, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057
255 15:17:21 SQL Data In: ORACLE - Param = 21, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
256 15:17:21 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
257 15:17:21 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
258 15:17:21 SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
259 15:17:21 SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
260 15:17:21 SQL Data In: ORACLE - Param = 26, Name = PYWMXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
261 15:17:21 SQL Data In: ORACLE - Param = 27, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
262 15:17:21 SQL Data In: ORACLE - Param = 28, Name = PFYJDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
263 15:17:21 SQL Data In: ORACLE - Param = 29, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
264 15:17:21 SQL Data In: ORACLE - Param = 30, Name = PYZCFID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
265 15:17:21 SQL Data In: ORACLE - Param = 31, Name = PSSDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
266 15:17:21 SQL Data In: ORACLE - Param = 32, Name = PTXM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
267 15:17:21 SQL Data In: ORACLE - Param = 33, Name = PWZBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
268 15:17:21 SQL Data In: ORACLE - Param = 34, Name = PSSBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
269 15:17:21 SQL Data In: ORACLE - Param = 35, Name = PSSMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
270 15:17:21 SQL Data In: ORACLE - Param = 36, Name = PSSYJDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
271 15:17:21 SQL Data In: ORACLE - Param = 37, Name = PWZBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
272 15:17:21 SQL Data In: ORACLE - Param = 38, Name = PTQPC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
273 15:17:21 SQL Data In: ORACLE - Param = 39, Name = PXMZK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
274 15:17:21 SQL Data In: ORACLE - Param = 40, Name = PYJZHJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
275 15:17:21 SQL Data In: ORACLE - Param = 41, Name = PTCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
276 15:17:21 SQL Data In: ORACLE - Param = 42, Name = PMBMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
277 15:17:21 SQL Data In: ORACLE - Param = 43, Name = PSFTJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
278 15:17:21 SQL Data In: ORACLE - Param = 44, Name = PSFZF00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
279 15:17:21 SQL Data In: ORACLE - Param = 45, Name = PYYGXJG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
280 15:17:21 SQL Data In: ORACLE - Param = 46, Name = PBWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
281 15:17:21 SQL Data In: ORACLE - Param = 47, Name = PZLXMJC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
282 15:17:21 SQL Data In: ORACLE - Param = 48, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
283 15:17:21 SQL Data In: ORACLE - Param = 49, Name = PSFFR00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
284 15:17:21 SQL Data In: ORACLE - Param = 50, Name = PDCNYJ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
285 15:17:21 SQL Data In: ORACLE - Param = 51, Name = PXMLSTR, Type = fldZSTRING, Precision = 36, Scale = 0, Data = 00
286 15:17:21 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;
287 15:17:21 SQL Execute: ORACLE - update YJ_YW0000 set BH0000='', MC0000='' where YJDJH0=50588142
288 15:17:21 SQL Data In: ORACLE - Rows affected = 1
289 15:17:21 SQL Execute: ORACLE - Commit
290 15:17:21 SQL Data In: ORACLE - Rows affected = 0
291 15:17:22 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ'
292 15:17:22 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB'
293 15:17:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 328872
294 15:17:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
295 15:17:22 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
296 15:17:22 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
297 15:17:22 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
298 15:17:22 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and BRID00 = ? 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+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',553,819,914,931,480,816,1051,561,978,477,936,729,675,',',480,')>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.SJSL00 > 0 and ZYHGHH = '9804533' and KDRQ00 between '20231220' and '20231227' order by XMZT00,YJDJH0 Desc
299 15:17:22 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588142
300 15:17:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
301 15:17:22 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 50588142 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000
302 15:17:22 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=328872
303 15:17:22 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(328872,'0',9804533) from dual
304 15:17:22 SQL Execute: ORACLE - select '328872' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '15959192373' BRLXDH,'9804533' ZYHGHH, '郑力' BRXM00, '男' BRXB00, '39岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '328872') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='328872' ) JZFPBZ from dual
305 15:17:22 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(328872,'0',9804533) from dual
306 15:17:22 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588142
307 15:17:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
308 15:17:22 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 50588142 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000
309 15:17:22 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=328872
310 15:17:22 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(328872,'0',9804533) from dual
311 15:17:22 SQL Execute: ORACLE - select '328872' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '15959192373' BRLXDH,'9804533' ZYHGHH, '郑力' BRXM00, '男' BRXB00, '39岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '328872') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='328872' ) JZFPBZ from dual
312 15:17:22 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588142
313 15:17:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
314 15:17:22 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 50588142 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000
315 15:17:22 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=328872
316 15:17:22 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(328872,'0',9804533) from dual
317 15:17:22 SQL Execute: ORACLE - select '328872' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '15959192373' BRLXDH,'9804533' ZYHGHH, '郑力' BRXM00, '男' BRXB00, '39岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '328872') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='328872' ) JZFPBZ from dual
318 15:17:24 SQL Execute: ORACLE - select A.*,A.kcje00-A.GJJE00 as JXCJ00,decode(sign(nvl(A.GYRY00,0)),-1,'系统',1,(select ZWXM00 from BM_YGBM00 where YGBH00=A.GYRY00),'') GYRYXM from
( select KCLSH0,YPNM00,YPBM00,YPMC00,YPGG00,CZFLMC,SCPH00,GJJ000,YKKCXX,SJKCXX,KCJE00,SCCJZW,KCDW00,JLDW00,
ZYFYDW,MZFYDW,K2ZJJL,ZJJL2J,M2J000,KCXX00,KCSX00,HGH000,PYSM00,WBSM00,SFZTPD,YKRKPC,
YPMLBZ,LSJ000,YKKCSL,SJKCSL,GJJE00,YFBMBH,LBBH00,YLBH00,JXBH00,TYMBH0,SFYX00,0 PXXH00,
0 JXCJ00_HJ,0 GJJE00_HJ,0 KCJE00_HJ,0 JLS000,YPSXRQ,GYRY00,GYRQSJ,TXM000,GHDWMC,YKBMBH,SFBZMC,null BYKSLL,TZRQ00
from VW_KS_PCKCXX union all
select KCLSH0,YPNM00,YPBM00,YPMC00,YPGG00,CZFLMC,SCPH00,GJJ000,YKKCXX,SJKCXX,KCJE00,SCCJZW,KCDW00,JLDW00,
ZYFYDW,MZFYDW,K2ZJJL,ZJJL2J,M2J000,KCXX00,KCSX00,HGH000,PYSM00,WBSM00,SFZTPD,YKRKPC,
YPMLBZ,LSJ000,YKKCSL,SJKCSL,GJJE00,YFBMBH,LBBH00,YLBH00,JXBH00,TYMBH0,SFYX00,1 PXXH00,
KCJE00-GJJE00 as JXCJ00_HJ, GJJE00 GJJE00_HJ,KCJE00 KCJE00_HJ,1 JLS000,YPSXRQ,GYRY00,GYRQSJ,null,null,YKBMBH,SFBZMC,BYKSLL,TZRQ00
from VW_KS_PCKCHZ V) A
where ( (A.YLBH00 like '%' ) or ('9'='-1') )
and ((A.TYMBH0='ALL' or 'ALL'='ALL') or ('9'='-1') )
and ((YKBMBH+0=0) or (0=0))
and TZRQ00 is null
and A.YPNM00=7000246102
and A.YFBMBH=480
order by YLBH00,YPBM00,PXXH00,YKRKPC
319 15:17:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
320 15:17:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
321 15:17:24 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
322 15:17:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
323 15:17:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
324 15:17:24 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
325 15:17:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
326 15:17:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
327 15:17:25 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
328 15:17:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
329 15:17:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
330 15:17:25 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
331 15:17:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
332 15:17:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
333 15:17:25 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
334 15:17:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
335 15:17:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
336 15:17:25 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
337 15:17:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
338 15:17:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
339 15:17:25 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
340 15:17:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
341 15:17:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
342 15:17:25 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000
343 15:17:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
344 15:17:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000246102.000000
345 15:17:25 SQL Execute: ORACLE - select * from VW_KS_KCYKMX A
WHERE A.YFBMBH=?
and A.YPNM00=?
ORDER BY ID0000