1       12:54:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 108387
2       12:54:25  SQL Execute: ORACLE - select GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,decode(YYBZ00,'1','普通号','2','优先号','3','院外预约号','4','院内电话预约号','5','分诊预约号','6','网络预约号','7','当天预约号','8','自助机预约号','9','双向转诊号','保留号') YYBZMC 
 from YS_HBHZXH where GHHBID=? order by HZXH00

3       12:54:25  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='预约号源分类'

4       12:55:06  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20260114'
 and GHMZSJ <= '20260114'
 and PBLX00 in('0','2') 
  order by  GHMZSJ,YSXM00,GHQSSJ 

5       12:55:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 107414
6       12:55:12  SQL Execute: ORACLE - select GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,decode(YYBZ00,'1','普通号','2','优先号','3','院外预约号','4','院内电话预约号','5','分诊预约号','6','网络预约号','7','当天预约号','8','自助机预约号','9','双向转诊号','保留号') YYBZMC 
 from YS_HBHZXH where GHHBID=? order by HZXH00

7       12:55:12  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='预约号源分类'

8       12:55:52  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20260128'
 and GHMZSJ <= '20260128'
 and PBLX00 in('0','2') 
  order by  GHMZSJ,YSXM00,GHQSSJ 

9       12:55:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 108332
10      12:55:53  SQL Execute: ORACLE - select GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,decode(YYBZ00,'1','普通号','2','优先号','3','院外预约号','4','院内电话预约号','5','分诊预约号','6','网络预约号','7','当天预约号','8','自助机预约号','9','双向转诊号','保留号') YYBZMC 
 from YS_HBHZXH where GHHBID=? order by HZXH00

11      12:55:53  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='预约号源分类'

12      12:56:06  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20260114'
 and GHMZSJ <= '20260115'
 and PBLX00 in('0','2') 
  order by  GHMZSJ,YSXM00,GHQSSJ 

13      12:56:07  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 107430
14      12:56:07  SQL Execute: ORACLE - select GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,decode(YYBZ00,'1','普通号','2','优先号','3','院外预约号','4','院内电话预约号','5','分诊预约号','6','网络预约号','7','当天预约号','8','自助机预约号','9','双向转诊号','保留号') YYBZMC 
 from YS_HBHZXH where GHHBID=? order by HZXH00

15      12:56:08  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='预约号源分类'

16      12:56:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 107430
17      12:56:16  SQL Execute: ORACLE - select GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,decode(YYBZ00,'1','普通号','2','优先号','3','院外预约号','4','院内电话预约号','5','分诊预约号','6','网络预约号','7','当天预约号','8','自助机预约号','9','双向转诊号','保留号') YYBZMC 
 from YS_HBHZXH where GHHBID=? order by HZXH00

18      12:56:16  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='预约号源分类'

19      12:56:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 107385
20      12:56:26  SQL Execute: ORACLE - select GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,decode(YYBZ00,'1','普通号','2','优先号','3','院外预约号','4','院内电话预约号','5','分诊预约号','6','网络预约号','7','当天预约号','8','自助机预约号','9','双向转诊号','保留号') YYBZMC 
 from YS_HBHZXH where GHHBID=? order by HZXH00

21      12:56:26  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='预约号源分类'

22      12:57:10  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20260129'
 and GHMZSJ <= '20260129'
 and PBLX00 in('0','2') 
  order by  GHMZSJ,YSXM00,GHQSSJ 

23      12:57:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 108387
24      12:57:12  SQL Execute: ORACLE - select GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,decode(YYBZ00,'1','普通号','2','优先号','3','院外预约号','4','院内电话预约号','5','分诊预约号','6','网络预约号','7','当天预约号','8','自助机预约号','9','双向转诊号','保留号') YYBZMC 
 from YS_HBHZXH where GHHBID=? order by HZXH00

25      12:57:12  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='预约号源分类'

26      12:57:20  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10
27      12:57:20  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 108387.000000
28      12:57:20  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
29      12:57:20  SQL Execute: ORACLE - update YS_HBHZXH
 set 
 YYBZ00=?
 where GHHBID=?
 and HZXH00=?

30      12:57:20  SQL Data In: ORACLE - Rows affected = 1
31      12:57:20  SQL Execute: ORACLE - COMMIT WORK