1       10:00:22  SQL Prepare: ORACLE - select * from BM_YBLB00 where YBLB00 IN ('4','5','6','8')

2       10:00:22  SQL Execute: ORACLE - select * from BM_YBLB00 where YBLB00 IN ('4','5','6','8')

3       10:00:24  SQL Execute: ORACLE - update BM_YBSFXM
set
  FLAG00 = ?,
  XMBH00= ?,
  ZYFPXM = ?,
  MZFPXM = ?,
  XMMC00 = ?,
  YPJX00 = ?,
  XMDW00 = ?,
  ZFBL00 = ?,
  SFYX00 = ?,
  SFYBXM = ?,
  YBLB00 = ?,
  PYSM00 = ?,
  WBSM00 = ?,
  YBBRLB = ?,
  SFSX00 = ?,
  SCCJ00 = ?,
  YPGG00 = ?,
  BZ0000 = ?,
  GXXLH0 = 0
where
  XMBH00 = ? and
  YBZXLB = ? and
  FBBH00 = ?

4       10:00:24  SQL Prepare: ORACLE - COMMIT WORK
5       10:00:24  SQL Execute: ORACLE - COMMIT WORK
6       10:00:24  SQL Prepare: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' 
and ybzxlb=:1 and FBBH00=:2

7       10:00:24  SQL Execute: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' 
and ybzxlb=? and FBBH00=?

8       10:01:02  SQL Prepare: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0,
sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd,
YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb,
SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00,
decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000
from  VW_BM_YBSFFPXMGL a
where (FBBH00=:1) and (ybzxlb=:2) and (xmbh00 like :3) and (sfybxm like :4) 
and  (sfyx00 like :5)
 and MZMC00 like '%药费' 
order by xmbh00

9       10:01:02  SQL Execute: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0,
sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd,
YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb,
SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00,
decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000
from  VW_BM_YBSFFPXMGL a
where (FBBH00=?) and (ybzxlb=?) and (xmbh00 like ?) and (sfybxm like ?) 
and  (sfyx00 like ?)
 and MZMC00 like '%药费' 
order by xmbh00

10      10:01:02  SQL Prepare: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' 
and ybzxlb=:1 and FBBH00=:2

11      10:01:02  SQL Execute: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' 
and ybzxlb=? and FBBH00=?

12      10:01:04  SQL Prepare: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0,
sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd,
YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb,
SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00,
decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000
from  VW_BM_YBSFFPXMGL a
where (FBBH00=:1) and (ybzxlb=:2) and (xmbh00 like :3) and (sfybxm like :4) 
and  (sfyx00 like :5)
 and MZMC00 like '%药费' 
order by xmbh00

13      10:01:04  SQL Execute: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0,
sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd,
YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb,
SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00,
decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000
from  VW_BM_YBSFFPXMGL a
where (FBBH00=?) and (ybzxlb=?) and (xmbh00 like ?) and (sfybxm like ?) 
and  (sfyx00 like ?)
 and MZMC00 like '%药费' 
order by xmbh00

14      10:01:04  SQL Prepare: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' 
and ybzxlb=:1 and FBBH00=:2

15      10:01:04  SQL Execute: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' 
and ybzxlb=? and FBBH00=?