1       08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

2       08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

3       08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

4       08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

5       08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

6       08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

7       08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

8       08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

9       08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

10      08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

11      08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

12      08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

13      08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

14      08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

15      08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

16      08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

17      08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

18      08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

19      08:37:28  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

20      08:37:28  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

21      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

22      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

23      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

24      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

25      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

26      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

27      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

28      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

29      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

30      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

31      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

32      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

33      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

34      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

35      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

36      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

37      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

38      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

39      08:37:29  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

40      08:37:29  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

41      08:37:29  SQL Prepare: ORACLE - select b.GHQXBZ from sf_brxxb0 a,BM_GHLBB0 b where a.GHLB00=b.LBBH00 AND GHH000 = :1

42      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 24143296    
43      08:37:29  SQL Execute: ORACLE - select b.GHQXBZ from sf_brxxb0 a,BM_GHLBB0 b where a.GHLB00=b.LBBH00 AND GHH000 = ?

44      08:37:29  SQL Prepare: ORACLE -  select  a.YBID00,a.YBKH00,a.yblb00,b.sfxnh0 from  bm_brxxb0 a,ic_ybbrlb b  where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.BRID00 = :1

45      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
46      08:37:29  SQL Execute: ORACLE -  select  a.YBID00,a.YBKH00,a.yblb00,b.sfxnh0 from  bm_brxxb0 a,ic_ybbrlb b  where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.BRID00 = ?

47      08:37:29  SQL Prepare: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 1
 and  PJSYR0=:1
 and  SYBZ00 = 'Y'

48      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1372.000000
49      08:37:29  SQL Execute: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 1
 and  PJSYR0=?
 and  SYBZ00 = 'Y'

50      08:37:29  SQL Prepare: ORACLE - select a.*  from VW_SF_BRXX00 a where 1=1
 and a.brid00=:1

51      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
52      08:37:29  SQL Execute: ORACLE - select a.*  from VW_SF_BRXX00 a where 1=1
 and a.brid00=?

53      08:37:29  SQL Prepare: ORACLE -  select * from  VW_SF_BRGH00 A where 1=1
 and brid00=:1 
 and GHID00=:2

54      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
55      08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 52882828.000000
56      08:37:29  SQL Execute: ORACLE -  select * from  VW_SF_BRGH00 A where 1=1
 and brid00=? 
 and GHID00=?

57      08:37:29  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

58      08:37:29  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

59      08:37:29  SQL Prepare: ORACLE - select * from VW_SF_BRZHXX where jflbid = 1 and brid00=:1

60      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
61      08:37:29  SQL Execute: ORACLE - select * from VW_SF_BRZHXX where jflbid = 1 and brid00=?

62      08:37:29  SQL Prepare: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = :1
 and cfyjbz = '0' 
  and  A.GHH000 = :2

63      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
64      08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 24143296    
65      08:37:29  SQL Execute: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ?
 and cfyjbz = '0' 
  and  A.GHH000 = ?

66      08:37:29  SQL Prepare: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = :1
 and cfyjbz = '1' 
  and  A.GHH000 = :2

67      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
68      08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 24143296    
69      08:37:29  SQL Execute: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ?
 and cfyjbz = '1' 
  and  A.GHH000 = ?

70      08:37:29  SQL Prepare: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=:1 and  yjdjh0 = 111544182
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=:2 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=:3 and  yjdjh0 = 111544182)

71      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
72      08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
73      08:37:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
74      08:37:29  SQL Execute: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=? and  yjdjh0 = 111544182
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=? 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=? and  yjdjh0 = 111544182)

75      08:37:29  SQL Prepare: ORACLE -  select  *  from  VW_SF_YJYWMX  where yjfzh0 is null and brid00=:1  and  yjdjh0 = 111544182
 union all 
 select  *  from  VW_SF_YJYWMX  where yjfzh0 is not null  and brid00=:2  
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where  brid00=:3  and  yjdjh0 = 111544182)

76      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
77      08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
78      08:37:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
79      08:37:29  SQL Execute: ORACLE -  select  *  from  VW_SF_YJYWMX  where yjfzh0 is null and brid00=?  and  yjdjh0 = 111544182
 union all 
 select  *  from  VW_SF_YJYWMX  where yjfzh0 is not null  and brid00=?  
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where  brid00=?  and  yjdjh0 = 111544182)

80      08:37:29  SQL Prepare: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=:1 and  yjdjh0 = 111544184
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=:2 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=:3 and  yjdjh0 = 111544184)

81      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
82      08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
83      08:37:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
84      08:37:29  SQL Execute: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=? and  yjdjh0 = 111544184
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=? 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=? and  yjdjh0 = 111544184)

85      08:37:29  SQL Prepare: ORACLE -  select  *  from  VW_SF_YJYWMX  where yjfzh0 is null and brid00=:1  and  yjdjh0 = 111544184
 union all 
 select  *  from  VW_SF_YJYWMX  where yjfzh0 is not null  and brid00=:2  
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where  brid00=:3  and  yjdjh0 = 111544184)

86      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
87      08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
88      08:37:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
89      08:37:29  SQL Execute: ORACLE -  select  *  from  VW_SF_YJYWMX  where yjfzh0 is null and brid00=?  and  yjdjh0 = 111544184
 union all 
 select  *  from  VW_SF_YJYWMX  where yjfzh0 is not null  and brid00=?  
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where  brid00=?  and  yjdjh0 = 111544184)

90      08:37:29  SQL Prepare: ORACLE - select  SQ_SF_FYXX00_TEMP00_ID0000.nextval  ID0000  from  dual

91      08:37:29  SQL Execute: ORACLE - select  SQ_SF_FYXX00_TEMP00_ID0000.nextval  ID0000  from  dual

92      08:37:29  SQL Prepare: ORACLE -  select  *  from  bm_ybbrlb  where  YBZXLB =:1  and YBBRLB =:2

93      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
94      08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
95      08:37:29  SQL Execute: ORACLE -  select  *  from  bm_ybbrlb  where  YBZXLB =?  and YBBRLB =?

96      08:37:29  SQL Prepare: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=:1

97      08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 赵与洋
98      08:37:29  SQL Execute: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=?

99      08:37:29  SQL Prepare: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000010','N','治疗费','一次性使用静脉血液采集针','次','次',0.36,1,0.36,'赵与洋',1,8000004166,'1','*','1次','','111544182','1','','*','*','*','1','*','1','*','','10','8000004166','一次性使用静脉血液采集针','0','1372','0.36','0','0','0.36','0','1','0','0','119121721','1','4685199','52882828','24143296','0')

100     08:37:29  SQL Execute: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000010','N','治疗费','一次性使用静脉血液采集针','次','次',0.36,1,0.36,'赵与洋',1,8000004166,'1','*','1次','','111544182','1','','*','*','*','1','*','1','*','','10','8000004166','一次性使用静脉血液采集针','0','1372','0.36','0','0','0.36','0','1','0','0','119121721','1','4685199','52882828','24143296','0')

101     08:37:29  SQL Data In: ORACLE - Rows affected = 1
102     08:37:29  SQL Prepare: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=:1

103     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 赵与洋
104     08:37:29  SQL Execute: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=?

105     08:37:29  SQL Prepare: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000010','N','治疗费','静脉注射','次','次',4,1,4,'赵与洋',1,20172,'1','*','1次','','111544182','1','','*','*','*','1','*','1','*','','10','20172','静脉注射','0','1372','4','0','0','4','0','1','0','0','119121722','1','4685199','52882828','24143296','0')

106     08:37:29  SQL Execute: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000010','N','治疗费','静脉注射','次','次',4,1,4,'赵与洋',1,20172,'1','*','1次','','111544182','1','','*','*','*','1','*','1','*','','10','20172','静脉注射','0','1372','4','0','0','4','0','1','0','0','119121722','1','4685199','52882828','24143296','0')

107     08:37:29  SQL Data In: ORACLE - Rows affected = 1
108     08:37:29  SQL Prepare: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=:1

109     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 赵与洋
110     08:37:29  SQL Execute: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=?

111     08:37:29  SQL Prepare: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000009','N','化验费','血细胞分析','次','次',25,1,25,'赵与洋',1,20855,'1','*','1次','','111544182','1','','*','*','*','1','*','1','*','','09','20855','血细胞分析','0','1372','25','0','0','25','0','1','0','0','119121723','1','4685199','52882828','24143296','0')

112     08:37:29  SQL Execute: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000009','N','化验费','血细胞分析','次','次',25,1,25,'赵与洋',1,20855,'1','*','1次','','111544182','1','','*','*','*','1','*','1','*','','09','20855','血细胞分析','0','1372','25','0','0','25','0','1','0','0','119121723','1','4685199','52882828','24143296','0')

113     08:37:29  SQL Data In: ORACLE - Rows affected = 1
114     08:37:29  SQL Prepare: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=:1

115     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 赵与洋
116     08:37:29  SQL Execute: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=?

117     08:37:29  SQL Prepare: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000010','N','治疗费','一次性使用人体静脉血样采集容器','次','次',1.77,1,1.77,'赵与洋',1,8000003988,'1','*','1次','','111544182','1','','*','*','*','1','*','1','*','','10','8000003988','一次性使用人体静脉血样采集容器','0','1372','1.77','0','0','1.77','0','1','0','0','119121724','1','4685199','52882828','24143296','0')

118     08:37:29  SQL Execute: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000010','N','治疗费','一次性使用人体静脉血样采集容器','次','次',1.77,1,1.77,'赵与洋',1,8000003988,'1','*','1次','','111544182','1','','*','*','*','1','*','1','*','','10','8000003988','一次性使用人体静脉血样采集容器','0','1372','1.77','0','0','1.77','0','1','0','0','119121724','1','4685199','52882828','24143296','0')

119     08:37:29  SQL Data In: ORACLE - Rows affected = 1
120     08:37:29  SQL Prepare: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=:1

121     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 赵与洋
122     08:37:29  SQL Execute: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=?

123     08:37:29  SQL Prepare: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000009','N','化验费','尿常规检查','次','次',1,10,10,'赵与洋',1,20863,'1','*','10次','','111544184','1','','*','*','*','1','*','1','*','','09','20863','尿常规检查','0','1372','10','0','0','10','0','1','0','0','119121725','1','4685199','52882828','24143296','0')

124     08:37:29  SQL Execute: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000009','N','化验费','尿常规检查','次','次',1,10,10,'赵与洋',1,20863,'1','*','10次','','111544184','1','','*','*','*','1','*','1','*','','09','20863','尿常规检查','0','1372','10','0','0','10','0','1','0','0','119121725','1','4685199','52882828','24143296','0')

125     08:37:29  SQL Data In: ORACLE - Rows affected = 1
126     08:37:29  SQL Prepare: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=:1

127     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 赵与洋
128     08:37:29  SQL Execute: ORACLE - select YSZJHM  from bm_ygbm00 where ZWXM00=?

129     08:37:29  SQL Prepare: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000009','N','化验费','尿沉渣定量','次','次',25,1,25,'赵与洋',1,20892,'1','*','1次','','111544184','1','','*','*','*','1','*','1','*','','09','20892','尿沉渣定量','0','1372','25','0','0','25','0','1','0','0','119121726','1','4685199','52882828','24143296','0')

130     08:37:29  SQL Execute: ORACLE - insert into SF_FYXX00_TEMPMX(MXID00,ID0000,YBXMBH,SFYB00,FPXMMC,YBXMMC,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,ZFBL00,SFXMID,YPTS00,YPPL00,YPYL00,CFLSH0,YJDJH0,CFBZ00,YSZJHM,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00,GYTJ00,YPCZFL,FPXMBH, YPNM00,XMMC00,SFYDJ0,CZY000,XJZF00,JZJE00,QTZF00,ZFJE00,GFJE00,FBBH00,YBZXLB,YBLB00,CFID00,XMFL00,BRID00,GHID00,GHH000,JSLX00 ) values(SQ_SF_FYTEMP_MXID00.NextVal,13284,'99000000000009','N','化验费','尿沉渣定量','次','次',25,1,25,'赵与洋',1,20892,'1','*','1次','','111544184','1','','*','*','*','1','*','1','*','','09','20892','尿沉渣定量','0','1372','25','0','0','25','0','1','0','0','119121726','1','4685199','52882828','24143296','0')

131     08:37:29  SQL Data In: ORACLE - Rows affected = 1
132     08:37:29  SQL Prepare: ORACLE - BEGIN "SP_SF_FYXX00_TEMP00" (AD_JSLX00 => :AD_JSLX00,AD_BRID00 => :AD_BRID00,AS_GHID00 => :AS_GHID00,AS_GHH000 => :AS_GHH000,AD_ID0000 => :AD_ID0000,AD_JZDH00 => :AD_JZDH00,AS_TSBZBH => :AS_TSBZBH,AD_CZY000 => :AD_CZY000,AD_NEWID0 => :AD_NEWID0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
133     08:37:29  SQL Data In: ORACLE - Param = 1, Name = AD_JSLX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
134     08:37:29  SQL Data In: ORACLE - Param = 2, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
135     08:37:29  SQL Data In: ORACLE - Param = 3, Name = AS_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 52882828.000000
136     08:37:29  SQL Data In: ORACLE - Param = 4, Name = AS_GHH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24143296
137     08:37:29  SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13284.000000
138     08:37:29  SQL Data In: ORACLE - Param = 6, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
139     08:37:29  SQL Data In: ORACLE - Param = 7, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
140     08:37:29  SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1372.000000
141     08:37:29  SQL Data In: ORACLE - Param = 9, Name = AD_NEWID0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
142     08:37:29  SQL Data In: ORACLE - Param = 10, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
143     08:37:29  SQL Data In: ORACLE - Param = 11, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
144     08:37:29  SQL Execute: ORACLE - BEGIN "SP_SF_FYXX00_TEMP00" (AD_JSLX00 => :AD_JSLX00,AD_BRID00 => :AD_BRID00,AS_GHID00 => :AS_GHID00,AS_GHH000 => :AS_GHH000,AD_ID0000 => :AD_ID0000,AD_JZDH00 => :AD_JZDH00,AS_TSBZBH => :AS_TSBZBH,AD_CZY000 => :AD_CZY000,AD_NEWID0 => :AD_NEWID0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
145     08:37:29  SQL Prepare: ORACLE - select * from VW_SF_FYXX00_TEMPMX where BRID00=:1 and ID0000=:2

146     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
147     08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
148     08:37:29  SQL Execute: ORACLE - select * from VW_SF_FYXX00_TEMPMX where BRID00=? and ID0000=?

149     08:37:29  SQL Prepare: ORACLE - select '00' as FPXMBH,'合计' as  FPXMMC,sum(XMJE00)HJJE00 from VW_SF_FYXX00_TEMPMX 
 where BRID00=:1 and ID0000=:2
 union   all 
select FPXMBH,FPXMMC,sum(XMJE00)HJJE00 from VW_SF_FYXX00_TEMPMX 
 where BRID00=:3 and ID0000=:4
 group by FPXMBH,FPXMMC
 order by FPXMBH

150     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
151     08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
152     08:37:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
153     08:37:29  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
154     08:37:29  SQL Execute: ORACLE - select '00' as FPXMBH,'合计' as  FPXMMC,sum(XMJE00)HJJE00 from VW_SF_FYXX00_TEMPMX 
 where BRID00=? and ID0000=?
 union   all 
select FPXMBH,FPXMMC,sum(XMJE00)HJJE00 from VW_SF_FYXX00_TEMPMX 
 where BRID00=? and ID0000=?
 group by FPXMBH,FPXMMC
 order by FPXMBH

155     08:37:29  SQL Prepare: ORACLE - select * from VW_SF_FYXX00_TEMPMX where BRID00=:1 and ID0000=:2 

156     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
157     08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
158     08:37:29  SQL Execute: ORACLE - select * from VW_SF_FYXX00_TEMPMX where BRID00=? and ID0000=? 

159     08:37:29  SQL Prepare: ORACLE - Select sum(XMJE00)XMJE00,sum(ZFJE00)ZFJE00,sum(JZJE00)JZJE00,sum(GFJE00)GFJE00 from  VW_SF_FYXX00_TEMPMX 
 where BRID00=:1 and ID0000=:2

160     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
161     08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
162     08:37:29  SQL Execute: ORACLE - Select sum(XMJE00)XMJE00,sum(ZFJE00)ZFJE00,sum(JZJE00)JZJE00,sum(GFJE00)GFJE00 from  VW_SF_FYXX00_TEMPMX 
 where BRID00=? and ID0000=?

163     08:37:29  SQL Prepare: ORACLE - Select sum(XMJE00)XMJE00,sum(ZFJE00)ZFJE00,sum(JZJE00)JZJE00,sum(GFJE00)GFJE00 from  VW_SF_FYXX00_TEMPMX 
 where BRID00=:1 and ID0000=:2 and KFZT00=1 

164     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
165     08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
166     08:37:29  SQL Execute: ORACLE - Select sum(XMJE00)XMJE00,sum(ZFJE00)ZFJE00,sum(JZJE00)JZJE00,sum(GFJE00)GFJE00 from  VW_SF_FYXX00_TEMPMX 
 where BRID00=? and ID0000=? and KFZT00=1 

167     08:37:29  SQL Prepare: ORACLE - select sum(XMJE00) XMJE00 from  VW_SF_FYXX00_TEMPMX where BRID00=:1 and ID0000=:2 AND CFBZ00='0' AND KFZT00='0'

168     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
169     08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
170     08:37:29  SQL Execute: ORACLE - select sum(XMJE00) XMJE00 from  VW_SF_FYXX00_TEMPMX where BRID00=? and ID0000=? AND CFBZ00='0' AND KFZT00='0'

171     08:37:29  SQL Prepare: ORACLE - select sum(XMJE00) XMJE00 from  VW_SF_FYXX00_TEMPMX where BRID00=:1 and ID0000=:2 AND CFBZ00='1' AND KFZT00='0'

172     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
173     08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
174     08:37:29  SQL Execute: ORACLE - select sum(XMJE00) XMJE00 from  VW_SF_FYXX00_TEMPMX where BRID00=? and ID0000=? AND CFBZ00='1' AND KFZT00='0'

175     08:37:29  SQL Prepare: ORACLE - select sum(XMJE00) XMJE00 from  VW_SF_FYXX00_TEMPMX where BRID00=:1 and ID0000=:2  AND KFZT00='1'

176     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
177     08:37:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13285.000000
178     08:37:29  SQL Execute: ORACLE - select sum(XMJE00) XMJE00 from  VW_SF_FYXX00_TEMPMX where BRID00=? and ID0000=?  AND KFZT00='1'

179     08:37:29  SQL Prepare: ORACLE -  select SF_SF_MSZFKQ(:1)FHJG00 from dual

180     08:37:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
181     08:37:29  SQL Execute: ORACLE -  select SF_SF_MSZFKQ(?)FHJG00 from dual

