20200622 16:57:34 select * from vw_ys_BQCW where bqh000 = ? and ch0000 = ? /* parameters: [<483>^] */ 20200622 16:57:34 select distinct a.ZYSQID,a.BRID00,b.BRXM00,b.BRLXDH,a.SQKS00,a.YSGZH0,a.zdm000,a.zdmc00,c.ksmc00,d.bmmc00 bqmc00, a.SQRQ00,a.SQSJ00,decode(a.JSBZ00,'1','已接收','未接收') JSBZ00,a.BQH000,a.KSH000,a.CH0000,a.zymd00,a.rybq00,a.ryfs00 from YS_BRZYSQ a,BM_BRXXB0 b,VW_BQ_KSXX_MZDZBL C,bm_bmbm00 d where rownum <= 2000 and a.BRID00=b.BRID00 and c.ksh000 = a.KSH000 and d.bmbh00 = a.bqh000 and a.SQKS00 = ? and a.YSGZH0 = ? and a.JSBZ00='0' order by a.SQRQ00 DESC,a.SQSJ00 DESC /* parameters: [<474>^<1252>] */ 20200622 16:57:30 insert into ys_brzysq(zysqid,brid00,sqks00,ysgzh0,sqrq00,sqsj00,jsbz00,bqh000,ksh000,ch0000,zdmc00,zdm000,zymd00,rybq00,ryfs00) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) /* parameters: [<2187>^<4264893>^<474>^<1252>^<20200622>^<16:38:49>^<0>^<483>^<661>^<>^<胃炎>^^<治疗>^<一般>^<门诊>] */ 20200622 16:57:30 select SQ_YS_BRZYSQ_ZYSQID.nextval from dual /* */ 20200622 16:57:30 update BM_BRXXB0 set brid00 = ? , brzjbh = ? , brjtdz = ? , brlxxm = ? , brlxdh = ? where brid00 = ? /* parameters: [<4264893>^<350322198307293022>^<福建省福州市鼓楼区>^<>^<15060319119>^<4264893>] */ 20200622 16:57:30 select a.BRXM00,b.SQRQ00,c.ZWXM00,d.BMMC00,b.JSBZ00,b.ZYSQID from BM_BRXXB0 a,YS_BRZYSQ b,BM_YGBM00 c,BM_BMBM00 d where rownum <= 2000 and a.brid00=b.brid00 and b.ysgzh0=c.YGBH00 and b.ksh000=d.BMBH00(+) and (b.zt0000 is null or (b.zt0000<>'6' and b.zt0000<>'7')) and b.BRID00=? and b.SQRQ00=? /* parameters: [<4264893>^<20200622>] */ 20200622 16:57:30 select * from BM_BRXXB0 where rownum <= 2000 and 1=1 and trim(brblh0) = ? /* parameters: [] */ 20200622 16:54:19 select * from VW_YS_BQCW where rownum <= 2000 and 1=1 and bqh000 = ? and CWXZ00<>'1' order by bqmc00,cwdjmc /* parameters: [<483>] */ 20200622 16:54:19 select ksmc00 displayname, to_char(ksh000) cmbvalue from VW_BQ_KSXX_MZDZBL where bqh000 = 483 /* */