1 16:24:30 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=3205854 2 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3205854 3 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00402208 4 16:24:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1225088000581088 5 16:24:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 吴伟艺 6 16:24:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1199898 7 16:24:30 SQL Execute: ORACLE - Update SF_YYBRB0 set BRID00=?,KMH000=?,ICKH00=?,BRXM00=? where YYID00=? 8 16:24:30 SQL Data In: ORACLE - Rows affected = 1 9 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3205854 10 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 吴伟艺 11 16:24:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1199898 12 16:24:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 618612 13 16:24:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 50 14 16:24:30 SQL Execute: ORACLE - Update YS_HBHZXH set BRID00=?,BRXM00=?,YYID00=? where GHHBID=? and HZXH00=? 15 16:24:30 SQL Data In: ORACLE - Rows affected = 1 16 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350583199209083177 17 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3205854 18 16:24:30 SQL Execute: ORACLE - Update BM_BRXXB0 set BRZJBH=? where BRID00=? 19 16:24:30 SQL Data In: ORACLE - Rows affected = 1 20 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 15375813081 21 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 16:24:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3205854 23 16:24:30 SQL Execute: ORACLE - Update BM_BRXXB0 set BRDH00=?,BRLXDH=? where BRID00=? 24 16:24:30 SQL Data In: ORACLE - Rows affected = 1 25 16:24:30 SQL Execute: ORACLE - Commit 26 16:24:30 SQL Data In: ORACLE - Rows affected = 0 27 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台 28 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen 29 16:24:30 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 30 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1225088000581088 31 16:24:30 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 32 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3205854.000000 33 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 34 16:24:30 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 35 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1225088000581088 36 16:24:30 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 37 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3205854.000000 38 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 39 16:24:30 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 40 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1225088000581088 41 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000 42 16:24:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 43 16:24:30 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual 44 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1225088000581088 45 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001 46 16:24:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 47 16:24:30 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual 48 16:24:30 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=3205854 49 16:24:30 SQL Execute: ORACLE - Select To_date('19920922','YYYY.MM.DD') from dual 50 16:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3205854 51 16:24:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 吴伟艺 52 16:24:30 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 ,'0' DQDYBZ from vw_yy_bryyxxcx a where 1=1 and (a.BRID00=? or (a.BRXM00=? and a.BRID00=0)) and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and ((a.YYJSSJ>'12:00:00' and to_char(sysdate, 'HH24:MI:SS')>'12:00:00' ) or (a.YYJSSJ<='12:00:00' and to_char(sysdate, 'HH24:MI:SS')<='12:00:00' ) ) and a.YYZT00 in ('0','1') and a.DPFYID='225088' 53 16:24:30 SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHHBID=618612 54 16:24:30 SQL Data In: ORACLE - Param = 1, Name = P_BRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3205854 55 16:24:30 SQL Data In: ORACLE - Param = 2, Name = P_YYID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1199898 56 16:24:30 SQL Data In: ORACLE - Param = 3, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 57 16:24:30 SQL Data In: ORACLE - Param = 4, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 58 16:24:30 SQL Data In: ORACLE - Param = 5, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 59 16:24:30 SQL Data In: ORACLE - Param = 6, Name = P_DYLY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 60 16:24:30 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; 61 16:24:31 SQL Execute: ORACLE - Update SF_YYBRB0 set HZDYCS=NVL(HZDYCS,0)+1 where YYID00=1199898 62 16:24:31 SQL Data In: ORACLE - Rows affected = 1 63 16:24:31 SQL Execute: ORACLE - select a.*,decode(nvl(a.HZDYCS,0),0,' ','(补打)' ) BDBZ00 from VW_MZHS_YYHZDDY a where YYID00=1199898 64 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 65 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 66 16:24:31 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 67 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 68 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 69 16:24:31 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 70 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 71 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 72 16:24:31 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 73 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 74 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 75 16:24:31 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 76 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 77 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 78 16:24:31 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 79 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 80 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 81 16:24:31 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 82 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 83 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 84 16:24:31 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 85 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 86 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 87 16:24:31 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 88 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 89 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 90 16:24:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 91 16:24:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 92 16:24:31 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 93 16:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 94 16:24:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 95 16:24:31 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 96 16:24:33 SQL Execute: ORACLE - Commit 97 16:24:33 SQL Data In: ORACLE - Rows affected = 0