1 14:56:59 SQL Execute: ORACLE - RollBack 2 14:56:59 SQL Data In: ORACLE - Rows affected = 0 3 14:57:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5331 4 14:57:00 SQL Execute: ORACLE - select ZDXL00 FROM BM_YD0000 WHERE YPNM00=? 5 14:57:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495 6 14:57:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5331 7 14:57:00 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=? and YPNM00=? and SJKCSL>0 8 14:57:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5331 9 14:57:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495 10 14:57:00 SQL Execute: ORACLE - select LBBH00 from vw_ys_ypkcxx where ypnm00=? and yfbmbh=? 11 14:57:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5331 12 14:57:00 SQL Execute: ORACLE - select LBBH00 from bm_yd0000 where ypnm00=? 13 14:57:00 SQL Execute: ORACLE - Delete from ys_cfmx00 where cflsh0='2660320' and cfid00 not in (-1) 14 14:57:00 SQL Data In: ORACLE - Rows affected = 0 15 14:57:00 SQL Execute: ORACLE - insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, YYSJ00, YYSJDW, YYZF00 , ZB0000, PSLBID, SFZBY0,YPZSL0, CFDW00, ZHL000, ZQCS00, ZFBL00, YBLB00, THBZ00,ZXCS00,TSYS00,CQLY00,F2J000)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '2660320','5331','小牛血清去蛋白注射液(奥德金）','10ml:0.4g','124.53','005','1','0.4','g','1','天','','','','N','1','支','0.4','1','0.2','5','0','1','','','1') 16 14:57:00 SQL Data In: ORACLE - Rows affected = 1 17 14:57:00 SQL Execute: ORACLE - Insert into ys_cfxxb0 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,DJH000,BRLB00,YSGZH0,SSKS00,GHKS00,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,BZID00,CFZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFMBMC,CFZJE0,BRDZ00,TSBZBH) Values ('2660320','495','2243452','1798258','328872','郑力','男',0,'3','1057','464','474','0','0',1,0,0,'1',0,'1057',to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),null,124.53,null,'') 18 14:57:00 SQL Data In: ORACLE - Rows affected = 1 19 14:57:00 SQL Execute: ORACLE - insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,DJH000,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZYMRCS,BCCFH0,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS)select CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,'19841114',DJH000,YSGZH0,'管理员',SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,a.BZID00,BZMC00,'0','N','0',FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,null,'0',ZYDJS0,ZYMRCS,'',TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS from YS_CFXXB0 a,BM_DMZD00 b where a.bzid00=b.bzid00(+) and CFLSH0='2660320' 20 14:57:00 SQL Data In: ORACLE - Rows affected = 1 21 14:57:00 SQL Execute: ORACLE - insert into YF_MZCFMX(CFID00,CFLSH0,YPNM00,YPMC00,YPGG00,LSDJ00,YPYFMC,PCMC00,CSL000,JLDW00,YYSJ00,YYSJDW,YFSMMC,ZB0000,ZJYFMC,XMYFMC,YPZSL0,CFDW00,ZHL000,CXBZ00,SFXS00,SFZBY0,THBZ00,PSLBID,ZFBL00,YBLB00,BZ0000,ZXCS00, CQLY00,F2J000)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00),b.YPYFMC,c.PCMC00,(DECODE(A.CSL000,NULL,NULL,(ROUND((a.CSL000/d.NSBL00),4)))),a.JLDW00,a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,(ROUND((a.YPZSL0/d.NSBL00),3)),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,ZXCS00, a.CQLY00, a.F2J000 from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.YPNM00=d.YPNM00 AND a.CFLSH0='2660320' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+) 22 14:57:00 SQL Data In: ORACLE - Rows affected = 1 23 14:57:00 SQL Data In: ORACLE - Param = 1, Name = AS_YZCFID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2660320 24 14:57:00 SQL Data In: ORACLE - Param = 2, Name = AD_ZYGHID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1798258 25 14:57:00 SQL Data In: ORACLE - Param = 3, Name = AS_LRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员 26 14:57:00 SQL Data In: ORACLE - Param = 4, Name = AS_JZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 27 14:57:00 SQL Data In: ORACLE - Param = 5, Name = AS_ZYCFPD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 14:57:00 SQL Execute: ORACLE - BEGIN "SP_YS_YJXMZDDC" (AS_YZCFID => :AS_YZCFID,AD_ZYGHID => :AD_ZYGHID,AS_LRXM00 => :AS_LRXM00,AS_JZBZ00 => :AS_JZBZ00,AS_ZYCFPD => :AS_ZYCFPD); END; 29 14:57:00 SQL Data In: ORACLE - Param = 1, Name = V_FLAG00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 30 14:57:00 SQL Data In: ORACLE - Param = 2, Name = V_GHZYID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2243452.000000 31 14:57:00 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 32 14:57:00 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 14:57:00 SQL Execute: ORACLE - BEGIN "SP_XT_TSXZ00" (V_FLAG00 => :V_FLAG00,V_GHZYID => :V_GHZYID,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 34 14:58:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057 35 14:58:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 36 14:58:00 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 37 14:58:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057 38 14:58:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 39 14:58:00 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=?