1 09:21:09 SQL Execute: ORACLE - Select SYSDATE from Dual 2 09:21:09 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') 3 09:21:09 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 4 09:21:10 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT82620023432' and ICKNBH = 'PTYBPT82620023432' 5 09:21:10 SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00,a.BRLXDH,a.BRZJBH SFZH00,nvl(a.BRLXDH,a.BRDH00) DH0000 from vw_ys_brxxb0 a where a.brid00=16579089 6 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16579089 7 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PT82620023432 8 09:21:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 9 09:21:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林晚棠 10 09:21:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 47438 11 09:21:10 SQL Execute: ORACLE - Update SF_YYBRB0 set BRID00=?,KMH000=?,ICKH00=?,BRXM00=? where YYID00=? 12 09:21:10 SQL Data In: ORACLE - Rows affected = 1 13 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16579089 14 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林晚棠 15 09:21:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 47438 16 09:21:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 77639 17 09:21:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 25 18 09:21:10 SQL Execute: ORACLE - Update YS_HBHZXH set BRID00=?,BRXM00=?,YYID00=? where GHHBID=? and HZXH00=? 19 09:21:10 SQL Data In: ORACLE - Rows affected = 1 20 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 666 21 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 666 22 09:21:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16579089 23 09:21:10 SQL Execute: ORACLE - Update BM_BRXXB0 set BRDH00=?,BRLXDH=? where BRID00=? 24 09:21:10 SQL Data In: ORACLE - Rows affected = 1 25 09:21:10 SQL Execute: ORACLE - Commit 26 09:21:10 SQL Data In: ORACLE - Rows affected = 0 27 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台 28 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen 29 09:21:10 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 30 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 31 09:21:10 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 32 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16579089.000000 33 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 34 09:21:10 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 35 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 36 09:21:10 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 37 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16579089.000000 38 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 39 09:21:10 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 40 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 41 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000 42 09:21:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 43 09:21:10 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual 44 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 45 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001 46 09:21:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 47 09:21:10 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual 48 09:21:10 SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00,a.BRZJBH,a.BRLXDH from vw_ys_brxxb0 a where a.brid00=16579089 49 09:21:10 SQL Execute: ORACLE - Select To_date('19960505','YYYY.MM.DD') from dual 50 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16579089 51 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林晚棠 52 09:21:10 SQL Execute: ORACLE - select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00, (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1) FZCKBH ,ceil((to_date(TO_char(sysdate, 'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')-to_date(YYRQ00||YYJSSJ,'YYYYMMDD HH24:MI:SS'))* 24 * 60) YYCDSJ , nvl((select TZBZ00 from SF_YSGHHB where GHHBID=a.GHHBID and rownum=1),'0') TZBZ00,YYQYZM,YYQH01,a.YYYGBH,nvl(a.BRLXDH,a.BRDH00) DH0000 from vw_yy_bryyxxcx a where 1=1 and (a.BRID00=? or a.BRXM00=?) and a.YYRQ00=to_char(sysdate, 'YYYYMMDD')and a.YYJSSJ between '00:00:01' and '23:59:59' and a.YYZT00 in ('0','1') and a.DPFYID='223362' 53 09:21:10 SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHHBID=77616 54 09:21:10 SQL Execute: ORACLE - Update SF_YYBRB0 set HZDYCS=NVL(HZDYCS,0)+1 where YYID00=47421 55 09:21:10 SQL Data In: ORACLE - Rows affected = 1 56 09:21:10 SQL Execute: ORACLE - select a.*,decode(nvl(a.HZDYCS,0),0,' ','(补打)' ) BDBZ00 from VW_MZHS_YYHZDDY a where YYID00=47421 57 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 58 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 59 09:21:10 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 60 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 61 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 62 09:21:10 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 63 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 64 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 65 09:21:10 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 66 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 67 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 68 09:21:10 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 69 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 70 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 71 09:21:10 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 72 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 73 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 74 09:21:10 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 75 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 76 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 77 09:21:10 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 78 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 79 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 80 09:21:10 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 81 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 82 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 83 09:21:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 84 09:21:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 85 09:21:10 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 86 09:21:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 87 09:21:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 88 09:21:10 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 89 09:21:11 SQL Execute: ORACLE - Commit 90 09:21:11 SQL Data In: ORACLE - Rows affected = 0 91 09:21:11 SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHHBID=77633 92 09:21:11 SQL Execute: ORACLE - Update SF_YYBRB0 set HZDYCS=NVL(HZDYCS,0)+1 where YYID00=47425 93 09:21:11 SQL Data In: ORACLE - Rows affected = 1 94 09:21:11 SQL Execute: ORACLE - select a.*,decode(nvl(a.HZDYCS,0),0,' ','(补打)' ) BDBZ00 from VW_MZHS_YYHZDDY a where YYID00=47425 95 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 96 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 97 09:21:11 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 98 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 99 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 100 09:21:11 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 101 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 102 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 103 09:21:11 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 104 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 105 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 106 09:21:11 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 107 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 108 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 109 09:21:11 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 110 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 111 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 112 09:21:11 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 113 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 114 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 115 09:21:11 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 116 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 117 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 118 09:21:11 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 119 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 120 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 121 09:21:11 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 122 09:21:11 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 123 09:21:11 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 124 09:21:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 125 09:21:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 126 09:21:11 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 127 09:21:11 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=223 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 128 09:21:12 SQL Execute: ORACLE - Commit 129 09:21:12 SQL Data In: ORACLE - Rows affected = 0 130 09:21:12 SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHHBID=77655 131 09:21:12 SQL Execute: ORACLE - Update SF_YYBRB0 set HZDYCS=NVL(HZDYCS,0)+1 where YYID00=47437 132 09:21:12 SQL Data In: ORACLE - Rows affected = 1 133 09:21:12 SQL Execute: ORACLE - select a.*,decode(nvl(a.HZDYCS,0),0,' ','(补打)' ) BDBZ00 from VW_MZHS_YYHZDDY a where YYID00=47437 134 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 135 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 136 09:21:12 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 137 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 138 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 139 09:21:12 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 140 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 141 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 142 09:21:12 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 143 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 144 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 145 09:21:12 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 146 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 147 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 148 09:21:12 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 149 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 150 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 151 09:21:12 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 152 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 153 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 154 09:21:12 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 155 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 156 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 157 09:21:12 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 158 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 159 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 160 09:21:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 161 09:21:12 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 162 09:21:12 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 163 09:21:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 164 09:21:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 165 09:21:12 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 166 09:21:14 SQL Execute: ORACLE - Commit 167 09:21:14 SQL Data In: ORACLE - Rows affected = 0 168 09:21:14 SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHHBID=77639 169 09:21:14 SQL Data In: ORACLE - Param = 1, Name = P_BRID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16579089 170 09:21:14 SQL Data In: ORACLE - Param = 2, Name = P_YYID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 47438 171 09:21:14 SQL Data In: ORACLE - Param = 3, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 172 09:21:14 SQL Data In: ORACLE - Param = 4, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 173 09:21:14 SQL Data In: ORACLE - Param = 5, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 174 09:21:14 SQL Data In: ORACLE - Param = 6, Name = P_DYLY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 175 09:21:14 SQL Execute: ORACLE - BEGIN "SP_YY_YYZYGH_DGBR" (P_BRID00 => :P_BRID00,P_YYID00 => :P_YYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG,P_COMMIT => :P_COMMIT,P_DYLY00 => :P_DYLY00); END; 176 09:21:14 SQL Execute: ORACLE - Update SF_YYBRB0 set HZDYCS=NVL(HZDYCS,0)+1 where YYID00=47438 177 09:21:14 SQL Data In: ORACLE - Rows affected = 1 178 09:21:14 SQL Execute: ORACLE - select a.*,decode(nvl(a.HZDYCS,0),0,' ','(补打)' ) BDBZ00 from VW_MZHS_YYHZDDY a where YYID00=47438 179 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 180 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 181 09:21:14 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 182 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 183 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 184 09:21:14 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 185 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 186 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 187 09:21:14 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 188 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 189 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 190 09:21:14 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 191 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 192 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 193 09:21:14 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 194 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 195 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 196 09:21:14 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 197 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 198 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 199 09:21:14 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 200 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 201 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 202 09:21:14 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 203 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 204 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 205 09:21:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 206 09:21:14 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 207 09:21:14 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 208 09:21:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 209 09:21:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 210 09:21:14 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 211 09:21:16 SQL Execute: ORACLE - Commit 212 09:21:16 SQL Data In: ORACLE - Rows affected = 0 213 09:21:16 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=223 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 214 09:21:19 SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00,a.BRZJBH from vw_ys_brxxb0 a where a.brid00=16579089 215 09:21:19 SQL Execute: ORACLE - Select To_date('19960505','YYYY.MM.DD') from dual 216 09:21:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16579089 217 09:21:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林晚棠 218 09:21:19 SQL Execute: ORACLE - select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00, (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1) FZCKBH ,ceil((to_date(TO_char(sysdate, 'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')-to_date(YYRQ00||YYJSSJ,'YYYYMMDD HH24:MI:SS'))* 24 * 60) YYCDSJ,nvl(a.BRLXDH,a.BRDH00) DH0000 from vw_yy_bryyxxcx a where 1=1 and (a.BRID00=? or a.BRXM00=?) and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and a.YYJSSJ between '00:00:01' and '23:59:59' and a.YYZT00 in ('0','1') 219 09:21:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台 220 09:21:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen 221 09:21:19 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 222 09:21:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 223 09:21:19 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 224 09:21:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16579089.000000 225 09:21:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 226 09:21:19 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 227 09:21:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 228 09:21:19 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 229 09:21:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16579089.000000 230 09:21:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 231 09:21:19 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 232 09:21:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 233 09:21:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000 234 09:21:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 235 09:21:19 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual 236 09:21:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT82620023432 237 09:21:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001 238 09:21:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 239 09:21:19 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual 240 09:21:19 SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00,a.BRZJBH,a.BRLXDH from vw_ys_brxxb0 a where a.brid00=0000 241 09:21:20 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=223 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0'