1       16:44:35  Log started for: Gysystem
2       16:44:35  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.10.202','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20100506','16:44:36','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

3       16:44:35  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.10.202','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20100506','16:44:36','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       16:44:35  SQL Prepare: ORACLE - Commit

5       16:44:35  SQL Execute: ORACLE - Commit

6       16:44:35  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

7       16:44:35  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

8       16:44:35  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

9       16:44:35  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

10      16:44:35  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

11      16:44:35  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

12      16:44:35  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.10.202','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20100506','16:44:36','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

13      16:44:35  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.10.202','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20100506','16:44:36','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

14      16:44:35  SQL Prepare: ORACLE - Commit

15      16:44:35  SQL Execute: ORACLE - Commit

16      16:44:35  SQL Prepare: ORACLE -  delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 

17      16:44:35  SQL Execute: ORACLE -  delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 

18      16:44:35  SQL Prepare: ORACLE - Commit

19      16:44:35  SQL Execute: ORACLE - Commit

20      16:44:35  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F'

21      16:44:35  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F'

22      16:44:35  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

23      16:44:35  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

24      16:44:35  SQL Prepare: ORACLE - Select SYSDATE from Dual

25      16:44:35  SQL Execute: ORACLE - Select SYSDATE from Dual

26      16:44:35  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

27      16:44:35  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

28      16:44:35  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

29      16:44:35  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

30      16:44:35  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F'

31      16:44:35  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F'

32      16:44:35  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

33      16:44:35  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

34      16:44:35  SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

35      16:44:35  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

36      16:44:35  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('a','0','1','2','3','4','5','6','8','9')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by BH0000

37      16:44:35  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('a','0','1','2','3','4','5','6','8','9')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))
 order by BH0000

38      16:45:10  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'F' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))

39      16:45:10  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'F' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998'))

40      16:45:10  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

41      16:45:10  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

42      16:45:10  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

43      16:45:10  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

44      16:45:10  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

45      16:45:10  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

46      16:45:10  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

47      16:45:10  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

48      16:45:10  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

49      16:45:10  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

50      16:45:10  SQL Prepare: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

51      16:45:10  SQL Execute: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

52      16:45:10  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2142512,476,'供应室-2','F',nvl('2031799',' '),'192.168.10.202#702:1015@GYSystem.exe+供应室管理子系统',150)

53      16:45:10  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2142512,476,'供应室-2','F',nvl('2031799',' '),'192.168.10.202#702:1015@GYSystem.exe+供应室管理子系统',150)

54      16:45:10  SQL Prepare: ORACLE - Commit

55      16:45:10  SQL Execute: ORACLE - Commit

56      16:45:10  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150

57      16:45:10  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150

58      16:45:10  SQL Prepare: ORACLE -  Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 

59      16:45:10  SQL Execute: ORACLE -  Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 

60      16:45:10  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.10.202'

61      16:45:10  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.10.202'

62      16:45:10  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y'

63      16:45:10  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y'

64      16:45:10  SQL Prepare: ORACLE -  update XT_SQIPDZ set ZT0000='1' where JQBH00=0

65      16:45:10  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='1' where JQBH00=0

66      16:45:10  SQL Prepare: ORACLE - Commit

67      16:45:10  SQL Execute: ORACLE - Commit

68      16:45:10  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
150 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

69      16:45:10  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
150 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

70      16:45:10  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

71      16:45:10  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

72      16:45:10  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',150,')> 0) and YXQ000>='20100506'

73      16:45:10  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',150,')> 0) and YXQ000>='20100506'

74      16:45:10  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

75      16:45:10  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

76      16:45:10  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

77      16:45:10  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

78      16:45:10  SQL Prepare: ORACLE - select sysdate from dual

79      16:45:10  SQL Execute: ORACLE - select sysdate from dual

80      16:45:10  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID'

81      16:45:10  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID'

82      16:45:10  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID'

83      16:45:10  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID'

84      16:45:10  SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED'

85      16:45:10  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED'

86      16:45:10  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

87      16:45:10  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

88      16:45:10  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

89      16:45:10  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

90      16:45:10  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0' ORDER BY B.F_TEMPTYPE,A.MKDM00

91      16:45:10  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0' ORDER BY B.F_TEMPTYPE,A.MKDM00

92      16:45:10  SQL Prepare: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476))))  

93      16:45:10  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476))))  

94      16:45:10  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

95      16:45:10  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

96      16:45:10  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

97      16:45:10  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

98      16:45:10  SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

99      16:45:10  SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

100     16:45:10  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 476

101     16:45:10  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 476

102     16:45:10  SQL Prepare: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ') 

103     16:45:10  SQL Execute: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ') 

104     16:45:10  SQL Prepare: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY'

105     16:45:10  SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY'

106     16:45:10  SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY'

107     16:45:10  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY'

108     16:45:10  SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB'

109     16:45:10  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB'

110     16:45:10  SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID'

111     16:45:10  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID'

112     16:45:10  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB'

113     16:45:10  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB'

114     16:45:10  SQL Prepare: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A  Where gyksbh=:1 and yxq000<:2 

115     16:45:10  SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A  Where gyksbh=? and yxq000<? 

116     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_kswply
where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) 
AND QLRQ00 BETWEEN :1 AND :2 AND FFKSBH=:3


117     16:45:15  SQL Execute: ORACLE - select * from vw_gy_kswply
where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) 
AND QLRQ00 BETWEEN ? AND ? AND FFKSBH=?


118     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

119     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

120     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

121     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

122     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

123     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

124     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

125     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

126     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

127     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

128     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

129     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

130     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

131     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

132     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

133     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

134     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

135     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

136     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

137     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

138     16:45:15  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

139     16:45:15  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

140     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

141     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

142     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

143     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

144     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

145     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

146     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

147     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

148     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

149     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

150     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

151     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

152     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

153     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

154     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

155     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

156     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

157     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

158     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

159     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

160     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

161     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

162     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

163     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

164     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

165     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

166     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

167     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

168     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

169     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

170     16:45:16  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

171     16:45:16  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

172     16:45:17  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

173     16:45:17  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

174     16:45:17  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

175     16:45:17  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

176     16:45:17  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

177     16:45:17  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

178     16:45:17  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

179     16:45:17  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

180     16:45:26  SQL Prepare: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks

181     16:45:26  SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks

182     16:45:26  SQL Prepare: ORACLE - select a.*,'0' flag00 from vw_gy_kswply a where ZT0000=1 and ffksbh=:1 

183     16:45:26  SQL Execute: ORACLE - select a.*,'0' flag00 from vw_gy_kswply a where ZT0000=1 and ffksbh=? 

184     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_kswply
where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) 
AND QLRQ00 BETWEEN :1 AND :2 AND FFKSBH=:3


185     16:45:28  SQL Execute: ORACLE - select * from vw_gy_kswply
where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) 
AND QLRQ00 BETWEEN ? AND ? AND FFKSBH=?


186     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

187     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

188     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

189     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

190     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

191     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

192     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

193     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

194     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

195     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

196     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

197     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

198     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

199     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

200     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

201     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

202     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

203     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

204     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

205     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

206     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

207     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

208     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

209     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

210     16:45:28  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

211     16:45:28  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

212     16:45:29  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

213     16:45:29  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

214     16:45:29  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

215     16:45:29  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

216     16:45:29  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

217     16:45:29  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

218     16:45:29  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

219     16:45:29  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

220     16:45:32  SQL Prepare: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks

221     16:45:32  SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks

222     16:45:34  SQL Prepare: ORACLE - select a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,qlsj00,a.qlksmc,sum(b.sfsl00) sfsl00,wpmc00,wpgg00,
  wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,a.zt0000,a.ffrq00,a.ffsj00
 from vw_gy_kswply a,vw_gy_wplymx b
 where a.qldh00=b.qldh00 
  and a.qlrq00 between :1 and :2
  and wpxz00 like :3
  and a.ZT0000 LIKE :4
  and a.FFKSBH = :5
 group by a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,a.qlsj00,a.qlksmc,wpmc00,wpgg00,wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,
 a.zt0000,a.ffrq00,a.ffsj00 
 order by a.qldh00

223     16:45:34  SQL Execute: ORACLE - select a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,qlsj00,a.qlksmc,sum(b.sfsl00) sfsl00,wpmc00,wpgg00,
  wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,a.zt0000,a.ffrq00,a.ffsj00
 from vw_gy_kswply a,vw_gy_wplymx b
 where a.qldh00=b.qldh00 
  and a.qlrq00 between ? and ?
  and wpxz00 like ?
  and a.ZT0000 LIKE ?
  and a.FFKSBH = ?
 group by a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,a.qlsj00,a.qlksmc,wpmc00,wpgg00,wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,
 a.zt0000,a.ffrq00,a.ffsj00 
 order by a.qldh00

224     16:46:59  SQL Prepare: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

225     16:46:59  SQL Execute: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

226     16:47:00  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

227     16:47:00  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

228     16:47:00  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

229     16:47:00  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

230     16:47:00  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

231     16:47:00  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

232     16:47:00  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

233     16:47:00  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

234     16:47:00  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

235     16:47:00  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

236     16:47:00  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

237     16:47:00  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

238     16:47:00  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

239     16:47:00  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

240     16:47:00  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

241     16:47:00  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

242     16:47:00  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

243     16:47:00  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

244     16:47:00  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

245     16:47:00  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

246     16:47:00  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

247     16:47:00  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

248     16:47:00  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

249     16:47:00  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

250     16:48:59  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

251     16:48:59  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

252     16:49:01  SQL Prepare: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

253     16:49:01  SQL Execute: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

254     16:49:01  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

255     16:49:01  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

256     16:49:02  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

257     16:49:02  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

258     16:49:02  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

259     16:49:02  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

260     16:49:02  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

261     16:49:02  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

262     16:49:02  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

263     16:49:02  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

264     16:49:02  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

265     16:49:02  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

266     16:49:02  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

267     16:49:02  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

268     16:49:02  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

269     16:49:02  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

270     16:49:02  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

271     16:49:02  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

272     16:49:02  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

273     16:49:02  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

274     16:49:02  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

275     16:49:02  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

276     16:49:02  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

277     16:49:02  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

278     16:49:02  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

279     16:49:02  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

280     16:50:41  SQL Prepare: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

281     16:50:41  SQL Execute: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

282     16:50:41  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

283     16:50:41  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

284     16:50:41  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

285     16:50:41  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

286     16:50:41  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

287     16:50:41  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

288     16:50:41  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

289     16:50:41  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

290     16:50:41  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

291     16:50:41  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

292     16:50:41  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

293     16:50:41  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

294     16:50:41  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

295     16:50:41  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

296     16:50:41  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

297     16:50:41  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

298     16:50:41  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

299     16:50:41  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

300     16:50:41  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

301     16:50:41  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

302     16:50:41  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

303     16:50:41  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

304     16:50:41  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

305     16:50:41  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

306     16:50:41  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

307     16:50:41  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

308     16:54:56  SQL Prepare: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

309     16:54:56  SQL Execute: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

310     16:54:56  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

311     16:54:56  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

312     16:54:56  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

313     16:54:56  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

314     16:54:56  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

315     16:54:56  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

316     16:54:56  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

317     16:54:56  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

318     16:54:56  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

319     16:54:56  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

320     16:54:56  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

321     16:54:56  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

322     16:54:56  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

323     16:54:56  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

324     16:54:56  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

325     16:54:56  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

326     16:54:56  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

327     16:54:56  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

328     16:54:56  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

329     16:54:56  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

330     16:54:56  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

331     16:54:56  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

332     16:54:56  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

333     16:54:56  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

334     16:54:56  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

335     16:54:56  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

336     16:56:30  SQL Prepare: ORACLE - select '二病区' QLKSMC, '2010-05-06' RQ0000,'黄榕铃' QLRMC0, '陈伊月' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39736' 

337     16:56:30  SQL Execute: ORACLE - select '二病区' QLKSMC, '2010-05-06' RQ0000,'黄榕铃' QLRMC0, '陈伊月' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39736' 

338     16:56:30  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

339     16:56:30  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

340     16:56:30  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

341     16:56:30  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

342     16:56:30  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

343     16:56:30  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

344     16:56:30  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

345     16:56:30  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

346     16:56:30  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

347     16:56:30  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

348     16:56:30  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

349     16:56:30  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

350     16:56:30  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

351     16:56:30  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

352     16:56:30  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

353     16:56:30  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

354     16:56:30  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

355     16:56:30  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

356     16:56:30  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

357     16:56:30  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

358     16:56:30  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

359     16:56:30  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

360     16:56:30  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

361     16:56:30  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

362     16:56:30  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39736'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈伊月' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'黄榕铃' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

363     16:56:30  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39736'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈伊月' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'黄榕铃' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

364     16:57:15  SQL Prepare: ORACLE - select '二病区' QLKSMC, '2010-05-06' RQ0000,'黄榕铃' QLRMC0, '陈伊月' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39736' 

365     16:57:15  SQL Execute: ORACLE - select '二病区' QLKSMC, '2010-05-06' RQ0000,'黄榕铃' QLRMC0, '陈伊月' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39736' 

366     16:57:15  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

367     16:57:15  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

368     16:57:15  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

369     16:57:15  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

370     16:57:15  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

371     16:57:15  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

372     16:57:15  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

373     16:57:15  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

374     16:57:15  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

375     16:57:15  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

376     16:57:15  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

377     16:57:15  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

378     16:57:15  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

379     16:57:15  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

380     16:57:15  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

381     16:57:15  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

382     16:57:15  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

383     16:57:15  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

384     16:57:15  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

385     16:57:15  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

386     16:57:15  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

387     16:57:15  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

388     16:57:15  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

389     16:57:15  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

390     16:57:16  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39736'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈伊月' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'黄榕铃' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

391     16:57:16  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39736'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈伊月' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'黄榕铃' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

392     16:58:01  SQL Prepare: ORACLE - select '二病区' QLKSMC, '2010-05-06' RQ0000,'黄榕铃' QLRMC0, '陈伊月' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39736' 

393     16:58:01  SQL Execute: ORACLE - select '二病区' QLKSMC, '2010-05-06' RQ0000,'黄榕铃' QLRMC0, '陈伊月' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39736' 

394     16:58:01  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

395     16:58:01  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

396     16:58:01  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

397     16:58:01  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

398     16:58:01  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

399     16:58:01  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

400     16:58:01  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

401     16:58:01  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

402     16:58:01  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

403     16:58:01  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

404     16:58:01  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

405     16:58:01  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

406     16:58:01  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

407     16:58:01  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

408     16:58:01  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

409     16:58:01  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

410     16:58:01  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

411     16:58:01  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

412     16:58:01  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

413     16:58:01  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

414     16:58:01  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

415     16:58:01  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

416     16:58:01  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

417     16:58:01  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

418     16:58:01  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39736'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈伊月' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'黄榕铃' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

419     16:58:01  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39736'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈伊月' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'黄榕铃' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

420     16:58:58  SQL Prepare: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

421     16:58:58  SQL Execute: ORACLE - select '六病区' QLKSMC, '2010-05-06' RQ0000,'李玲' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39755' 

422     16:58:58  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

423     16:58:58  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

424     16:58:58  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

425     16:58:58  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

426     16:58:58  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

427     16:58:58  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

428     16:58:58  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

429     16:58:58  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

430     16:58:58  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

431     16:58:58  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

432     16:58:58  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

433     16:58:58  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

434     16:58:58  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

435     16:58:58  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

436     16:58:58  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

437     16:58:58  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

438     16:58:59  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

439     16:58:59  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

440     16:58:59  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

441     16:58:59  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

442     16:58:59  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

443     16:58:59  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

444     16:58:59  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

445     16:58:59  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

446     16:58:59  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

447     16:58:59  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39755'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'李玲' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

448     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_kswply
where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) 
AND QLRQ00 BETWEEN :1 AND :2 AND FFKSBH=:3


449     16:59:32  SQL Execute: ORACLE - select * from vw_gy_kswply
where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) 
AND QLRQ00 BETWEEN ? AND ? AND FFKSBH=?


450     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

451     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

452     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

453     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

454     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

455     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

456     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

457     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

458     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

459     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

460     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

461     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

462     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

463     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

464     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

465     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

466     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

467     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

468     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

469     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

470     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

471     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

472     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

473     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

474     16:59:32  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

475     16:59:32  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

476     16:59:33  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

477     16:59:33  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

478     16:59:33  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

479     16:59:33  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

480     16:59:33  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

481     16:59:33  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

482     16:59:33  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

483     16:59:33  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

484     16:59:33  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

485     16:59:33  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

486     16:59:34  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

487     16:59:34  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

488     16:59:34  SQL Prepare: ORACLE - select * from vw_gy_wplymx where qldh00=:1
order by wpxz00

489     16:59:34  SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=?
order by wpxz00

490     16:59:40  SQL Prepare: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks

491     16:59:40  SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks

492     16:59:42  SQL Prepare: ORACLE - select a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,qlsj00,a.qlksmc,sum(b.sfsl00) sfsl00,wpmc00,wpgg00,
  wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,a.zt0000,a.ffrq00,a.ffsj00
 from vw_gy_kswply a,vw_gy_wplymx b
 where a.qldh00=b.qldh00 
  and a.qlrq00 between :1 and :2
  and wpxz00 like :3
  and a.ZT0000 LIKE :4
  and a.FFKSBH = :5
 group by a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,a.qlsj00,a.qlksmc,wpmc00,wpgg00,wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,
 a.zt0000,a.ffrq00,a.ffsj00 
 order by a.qldh00

493     16:59:42  SQL Execute: ORACLE - select a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,qlsj00,a.qlksmc,sum(b.sfsl00) sfsl00,wpmc00,wpgg00,
  wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,a.zt0000,a.ffrq00,a.ffsj00
 from vw_gy_kswply a,vw_gy_wplymx b
 where a.qldh00=b.qldh00 
  and a.qlrq00 between ? and ?
  and wpxz00 like ?
  and a.ZT0000 LIKE ?
  and a.FFKSBH = ?
 group by a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,a.qlsj00,a.qlksmc,wpmc00,wpgg00,wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0,
 a.zt0000,a.ffrq00,a.ffsj00 
 order by a.qldh00

494     17:01:33  SQL Prepare: ORACLE - select '四病区' QLKSMC, '2010-05-06' RQ0000,'王晶晶' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39507' 

495     17:01:33  SQL Execute: ORACLE - select '四病区' QLKSMC, '2010-05-06' RQ0000,'王晶晶' QLRMC0, '陈玉如' FFRMC0,ZYH000,BRXM00,FFSJ00,QLDH00  FROM vw_gy_kswply where QLDH00='39507' 

496     17:01:33  SQL Prepare: ORACLE - select * from t_ctltemp    where f_sysid=:1 and f_tempid=:2

497     17:01:33  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

498     17:01:33  SQL Prepare: ORACLE - select * from t_CtlTemp1   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

499     17:01:33  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

500     17:01:33  SQL Prepare: ORACLE - select * from t_CtlLabel   where f_sysid=:1 and f_tempid=:2 order by F_Sequence

501     17:01:33  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

502     17:01:33  SQL Prepare: ORACLE - select * from t_CtlEdit     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

503     17:01:33  SQL Execute: ORACLE - select * from t_CtlEdit     where f_sysid=? and f_tempid=? order by F_Sequence

504     17:01:33  SQL Prepare: ORACLE - select * from t_CtlDate     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

505     17:01:33  SQL Execute: ORACLE - select * from t_CtlDate     where f_sysid=? and f_tempid=? order by F_Sequence

506     17:01:33  SQL Prepare: ORACLE - select * from t_CtlLine     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

507     17:01:33  SQL Execute: ORACLE - select * from t_CtlLine     where f_sysid=? and f_tempid=? order by F_Sequence

508     17:01:33  SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence

509     17:01:33  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

510     17:01:33  SQL Prepare: ORACLE - select * from t_CtlGrid     where f_sysid=:1 and f_tempid=:2 order by F_Sequence

511     17:01:33  SQL Execute: ORACLE - select * from t_CtlGrid     where f_sysid=? and f_tempid=? order by F_Sequence

512     17:01:33  SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence

513     17:01:33  SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence

514     17:01:33  SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

515     17:01:33  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

516     17:01:33  SQL Prepare: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

517     17:01:33  SQL Execute: ORACLE - select 'a' QLKSMC, 'B' RQ0000 FROM DUAL

518     17:01:33  SQL Prepare: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

519     17:01:33  SQL Execute: ORACLE - select WPBH00,wpgg00,TO_CHAR(SFSL00) SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,TO_CHAR(JE0000) JE0000,SCQYPP,WSXKZH,SCPH00,MJPH00,YXQ000  from vw_gy_wplymx  where ZT0000='3' and QLDH00='1006'  UNION all select '___________' WPBH00,'_________________'wpgg00,'_________________' SFSL00,'____________' WPMC00,'____________' WPDW00,'_________________' WPDJ00,'______' JE0000,'_________' SCQYPP,'_______' WSXKZH,'__________' SCPH00,'___________' MJPH00,'____________' YXQ000  from DUAL UNION all select '' WPBH00,'' SFSL00,'发放人:'||'实达龙' WPMC00,''wpgg00,'' WPDW00,'申请人:' WPDJ00,'dfff' JE0000,'' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' MJPH00,'' YXQ000  from DUAL

520     17:01:33  SQL Prepare: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39507'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'王晶晶' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00 

521     17:01:33  SQL Execute: ORACLE - select ZYH000,BRXM00,WPBH00,WPMC00,TO_CHAR(SUM(SFSL00)) SFSL00,WPDW00,WPDJ00,TO_CHAR(SUM(JE0000)) JE0000 ,SCQYPP,WSXKZH,SCPH00, SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000) GCH000  from (
select ZYH000,BRXM00,WPBH00,SFSL00,WPMC00,WPDW00,TO_CHAR(WPDJ00) WPDJ00,JE0000,SCQYPP,WSXKZH,SCPH00,trim(SCCJZW) SCCJZW,MJPH00,YXQ000,WPGG00,GBH000,to_char(GCH000) GCH000
 from vw_gy_wplypcmx
 where ZT0000='3' and QLDH00='39507'
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'' WPMC00,'' WPDW00,'' WPDJ00,0 JE0000,'' SCQYPP,'' WSXKZH,'' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,'' GCH000
 from DUAL
UNION all
select '' ZYH000,'' BRXM00,'' WPBH00,0 SFSL00,'   发放人:'||'陈玉如' WPMC00,'' WPDW00,'  申请人:' WPDJ00,0 JE0000,'王晶晶' SCQYPP,'' WSXKZH,'领用科室签名:' SCPH00,'' SCCJZW ,'' MJPH00,'' YXQ000, '' WPGG00,'' GBH000,''GCH000 
 from DUAL
) GROUP BY ZYH000,BRXM00,WPBH00,WPMC00,WPDW00,WPDJ00,SCQYPP,WSXKZH,SCPH00,SCCJZW,MJPH00,YXQ000,WPGG00,
 GBH000,to_char(GCH000)
 order by ZYH000,BRXM00,WPBH00