1       10:43:46  Log started for: SQL Navigator for Oracle
2       10:44:12  Log started for: 住院医生工作站系统
3       10:44:24  SQL Prepare: ORACLE - SELECT  A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM 
FROM VW_ZS_YJBLXX A WHERE (DQKS00=:1 or DQBQ00=:2) 
 ORDER BY RYCWH0

4       10:44:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
5       10:44:24  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
6       10:44:24  SQL Execute: ORACLE - SELECT  A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM 
FROM VW_ZS_YJBLXX A WHERE (DQKS00=? or DQBQ00=?) 
 ORDER BY RYCWH0

7       10:44:36  SQL Prepare: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0,992366,989811,992109,994663,992609,993011,994510,990459,991913,988897,993270,992861,993061,994560,995710,986772)

8       10:44:36  SQL Execute: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0,992366,989811,992109,994663,992609,993011,994510,990459,991913,988897,993270,992861,993061,994560,995710,986772)

9       10:44:45  SQL Prepare: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0,984320,977558,987060,971350,972606,980862,984434,986765,985103,986779,984413,973058,976160,981668,985683,984368,977608,989066,991813,977430,973318,989075,985426,986824,992088,963686,972043,974614,969953,976559,989966,986828,988571,969954,972955,969994,988461,977883,981330,988594,989172,977881,985425,986699,989241,984424,986762,974882,990010,985098,991419,977258,964942,988543,971370,989865,973007,975209,980110,986550,986767,972013,981331,988598,961884,977058,987209,986795,970040,981760,971627,986838,988593,989882,970440,973310,977421,989245,976208,989880,980074,989910,988575,973259,976009,983513,985631,989963,986949,989911,976213,988581,970500,972705,986650,988602,984412,986752,984367,993269,974684,979963,970192,976158,986716,988536,972348,984325,988542,979965,993071,984329,975909,973319,986817,988610,973322,984419,977663,984416,986704,986715,984418,975813,974824,979760,988573)

10      10:44:45  SQL Execute: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0,984320,977558,987060,971350,972606,980862,984434,986765,985103,986779,984413,973058,976160,981668,985683,984368,977608,989066,991813,977430,973318,989075,985426,986824,992088,963686,972043,974614,969953,976559,989966,986828,988571,969954,972955,969994,988461,977883,981330,988594,989172,977881,985425,986699,989241,984424,986762,974882,990010,985098,991419,977258,964942,988543,971370,989865,973007,975209,980110,986550,986767,972013,981331,988598,961884,977058,987209,986795,970040,981760,971627,986838,988593,989882,970440,973310,977421,989245,976208,989880,980074,989910,988575,973259,976009,983513,985631,989963,986949,989911,976213,988581,970500,972705,986650,988602,984412,986752,984367,993269,974684,979963,970192,976158,986716,988536,972348,984325,988542,979965,993071,984329,975909,973319,986817,988610,973322,984419,977663,984416,986704,986715,984418,975813,974824,979760,988573)

11      10:45:33  SQL Prepare: ORACLE - BEGIN "SP_ZS_CJBASY" (PZYID00 => :PZYID00,PCZY000 => :PCZY000); END;
12      10:45:33  SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 980110.000000
13      10:45:33  SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000
14      10:45:33  SQL Execute: ORACLE - BEGIN "SP_ZS_CJBASY" (PZYID00 => :PZYID00,PCZY000 => :PCZY000); END;
15      10:45:34  SQL Prepare: ORACLE - rollback

16      10:45:34  SQL Execute: ORACLE - rollback

17      10:45:34  SQL Data In: ORACLE - Rows affected = 0