66      16:14:26  Log started for: 药房管理系统
67      16:14:34  SQL Prepare: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00,
C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00,sum(C.CKSL00) CKSL00,TRIM(C.CKDW00) CKDW00,
K.BZ0000,D.DXSYBZ,D.JXBH00,D.YLBH00,K.QRRQ00,D.YPBM00,
C.CKDH00,K.QRSJ00,
X.GZDJ00,
SF_YF_EXROUND(sum(C.CKSL00)*C.LSDJ00,0,2) AS C_YPJE
 FROM YF_YPCKMX C,YF_YPCKD0 K,BM_YD0000 D,YF_YPKCXX X
 WHERE C.CKDH00 ='1385308'
 AND  C.YPNM00=D.YPNM00 AND C.CKDH00=K.CKDH00
 AND  C.YPNM00=X.YPNM00 AND X.YFBMBH=20
 GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,
          C.YPNM00,C.YPMC00,C.YPGG00,K.BZ0000,
          C.LSDJ00,C.CKDW00,X.YFBMBH,K.QRRQ00,D.YPBM00
,C.CKDH00,K.QRSJ00
 ORDER BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPBM00

68      16:14:34  SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00,
C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00,sum(C.CKSL00) CKSL00,TRIM(C.CKDW00) CKDW00,
K.BZ0000,D.DXSYBZ,D.JXBH00,D.YLBH00,K.QRRQ00,D.YPBM00,
C.CKDH00,K.QRSJ00,
X.GZDJ00,
SF_YF_EXROUND(sum(C.CKSL00)*C.LSDJ00,0,2) AS C_YPJE
 FROM YF_YPCKMX C,YF_YPCKD0 K,BM_YD0000 D,YF_YPKCXX X
 WHERE C.CKDH00 ='1385308'
 AND  C.YPNM00=D.YPNM00 AND C.CKDH00=K.CKDH00
 AND  C.YPNM00=X.YPNM00 AND X.YFBMBH=20
 GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,
          C.YPNM00,C.YPMC00,C.YPGG00,K.BZ0000,
          C.LSDJ00,C.CKDW00,X.YFBMBH,K.QRRQ00,D.YPBM00
,C.CKDH00,K.QRSJ00
 ORDER BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPBM00

69      16:14:34  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

70      16:14:34  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

71      16:14:34  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

72      16:14:34  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

73      16:14:34  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

74      16:14:34  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

75      16:14:34  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

76      16:14:34  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

77      16:14:34  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

78      16:14:34  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

79      16:14:34  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

80      16:14:34  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL