1 10:41:20 SQL Execute: ORACLE - select count(*) from XK_BRXX00 WHERE BRID00=718494 2 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 3 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5780207 4 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 周晓东 5 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 6 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19490303 7 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本市 8 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 9 10:41:20 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 10 10:41:20 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 门诊 11 10:41:20 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 718494.000000 12 10:41:20 SQL Execute: ORACLE - update XK_BRXX00 set MRN000=?, ZYH000=?, XM0000=?, XB0000=?, CSRQ00=?, SXZSD0=?, CHYS00=?, SCS000=?, MZZYBZ=? where BRID00=? 13 10:41:20 SQL Data In: ORACLE - Rows affected = 1 14 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 外科 15 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 16 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 17 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:14:55 18 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 常规 19 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 悬浮红细胞 20 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 21 10:41:20 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = u 22 10:41:20 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 支气管炎 23 10:41:20 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 795.000000 24 10:41:20 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 陈群 25 10:41:20 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 26 10:41:20 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 输血 27 10:41:20 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 10:41:20 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 门诊 29 10:41:20 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 30 10:41:20 SQL Execute: ORACLE - Update XK_SXSQ00 set KSMC00=?, BQMC00=?, YJSXRQ=?, YJSRSJ=?, SXSZ00=?, SXCF00=?, SXSL00=?, SXDW00=?, LCZDMC=?, SQYSBH=?, SHYSXM=?, CXRXM0=?, SXMD00=?, SFJWSX=?, MZZYBZ=? WHERE SQDH00=? 31 10:41:20 SQL Data In: ORACLE - Rows affected = 1 32 10:41:20 SQL Execute: ORACLE - commit 33 10:41:20 SQL Data In: ORACLE - Rows affected = 0 34 10:41:20 SQL Execute: ORACLE - delete XK_SQDJG0 where ZYID00=10694758 and SQDH00='090560' 35 10:41:20 SQL Data In: ORACLE - Rows affected = 10 36 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 37 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 38 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 109453.000000 39 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 40 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 41 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 42 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 43 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 44 10:41:20 SQL Data In: ORACLE - Rows affected = 1 45 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 46 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 47 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 109454.000000 48 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 49 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 50 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 51 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 52 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 53 10:41:20 SQL Data In: ORACLE - Rows affected = 1 54 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 55 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 56 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 57 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 58 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 59 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 60 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121.000000 61 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 62 10:41:20 SQL Data In: ORACLE - Rows affected = 1 63 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 64 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 65 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 66 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 67 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 68 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 69 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 122.000000 70 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 71 10:41:20 SQL Data In: ORACLE - Rows affected = 1 72 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 73 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 74 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1168.000000 75 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 76 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 77 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 78 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000 79 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 80 10:41:20 SQL Data In: ORACLE - Rows affected = 1 81 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 82 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 83 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1221.000000 84 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 85 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 86 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 87 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25.000000 88 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 89 10:41:20 SQL Data In: ORACLE - Rows affected = 1 90 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 91 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 92 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1228.000000 93 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 94 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 95 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 96 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26.000000 97 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 98 10:41:20 SQL Data In: ORACLE - Rows affected = 1 99 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 100 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 101 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227.000000 102 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 103 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 104 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 105 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27.000000 106 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 107 10:41:20 SQL Data In: ORACLE - Rows affected = 1 108 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 109 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 110 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1261.000000 111 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 112 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 113 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 114 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 115 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 116 10:41:20 SQL Data In: ORACLE - Rows affected = 1 117 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 118 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 119 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1262.000000 120 10:41:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 送检待报 121 10:41:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 122 10:41:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:36:42 123 10:41:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 124 10:41:20 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 125 10:41:20 SQL Data In: ORACLE - Rows affected = 1 126 10:41:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 127 10:41:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161104 128 10:41:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 718494.000000 129 10:41:20 SQL Execute: ORACLE - SELECT "SQDH00", "ZYID00", "BRID00", "BRXM00", "MZZYBZ", "ZYH000", "MRN000", "XB0000", "CSRQ00", "NL0000", "XX0000", "FDXX00", "RHXX00", "TYKTSC", "TYKTJD", "JYYGXM", "FJRXM0", "JYRQSJ", "KSMC00", "BQMC00", "CH0000", "YZMXID", "YZXX00", "SXZSD0", "CHYS00", "SCS000", "LRRXM0", "LRRQ00", "LRSJ00", "LRRQSJ", "SQZT00", "SQZTMC", "SFJWSX", "LCZDMC", "SXSZ00", "SXCF00", "SXCFBH", "SXSL00", "SXDW00", "CXRXM0", "CYRQ00", "CYRQSJ", "SQYSBH", "SQYSXM", "SHYSXM", "SQRQ00", "SQSJ00", "YJSXRQ", "YJSRSJ", "SQRQSJ", "YJSRRQ", "SXMD00", "PXBGRQ", "PXBGSJ", "PXRQSJ", "PXYGBH", "PXRXM0", "PXFHXM", "QXRXM0", "FXRBH0", "QXRQ00", "QXSJ00", "SXRXM0", "SXRQ00", "SXSJ00", "HDRXM0", "HDRXM1", "SXHS00", "SXHS01", "SXKSRQ", "SXKSSJ", "SXJSRQ", "SXJSSJ", "SXGC00", "JLRQ00", "JLSJ00", "JLRXM0", "DQBQ00", "READBZ", "JSRQ00", "JSSJ00", "ZYE000", "YKZYE0", "FXDH00", "DQKS00", "SXSQYT", "SQDFZH", "SSZT00", "SHR000", "LSTDBZ", "SXL000", "SPRQ00", "SPSJ00", "YSSPRQ", "YSSPSJ", "YWKSPR", "SPRXM0", "SFYWYX" FROM "VW_XK_SXSQ00" WHERE ((("SQRQ00") >= (?)) AND (("SQRQ00") <= (?))) AND (("BRID00") = (?)) ORDER BY "SQDH00" 130 10:41:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 280.000000 131 10:41:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 132 10:41:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 133 10:41:21 SQL Execute: ORACLE - SELECT B.JYXMMC,B.JYXMBH, substr(SF_XK_GETJYJG(A.ZYID00,B.JKBH00),1,100) JYJG00, A.ZYID00,B.BGXMID,B.JYXMID FROM XK_SQDJG0 A,VW_XK_JYBGXM B WHERE A.JYXMID(+)=B.JYXMID and (B.BGDJID=? or (B.BGXMMC='输血申请中输血成分个性报告' and B.BZ0000='悬浮红细胞') ) AND ZYID00(+)=? and A.SQDH00(+)=? order by JYXMBH 134 10:41:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 280.000000 135 10:41:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10694758.000000 136 10:41:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090560 137 10:41:21 SQL Execute: ORACLE - SELECT B.JYXMMC,B.JYXMBH, substr(SF_XK_GETJYJG(A.ZYID00,B.JKBH00),1,100) JYJG00, A.ZYID00,B.BGXMID,B.JYXMID FROM XK_SQDJG0 A,VW_XK_JYBGXM B WHERE A.JYXMID(+)=B.JYXMID and (B.BGDJID=? or (B.BGXMMC='输血申请中输血成分个性报告' and B.BZ0000='悬浮红细胞') ) AND ZYID00(+)=? and A.SQDH00(+)=? order by JYXMBH 138 10:56:29 Log started for: 后台维护系统 139 11:16:37 Log started for: 门诊医生工作站分系统 140 14:40:45 Log started for: SQL Navigator for Oracle