1 17:26:28 SQL Prepare: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='' Order by Bh0000 2 17:26:28 SQL Execute: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='' Order by Bh0000 3 17:26:28 SQL Prepare: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00=' ' Order by Bh0000 4 17:26:28 SQL Execute: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00=' ' Order by Bh0000 5 17:26:28 SQL Prepare: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='' Order by Bh0000 6 17:26:28 SQL Execute: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='' Order by Bh0000 7 17:26:28 SQL Prepare: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like :1) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By PYSM00) where Rownum<=30 8 17:26:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 9 17:26:28 SQL Execute: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like ?) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By PYSM00) where Rownum<=30 10 17:26:30 SQL Prepare: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like :1) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By Instrb(PYSM00,'s'),PYSM00) where Rownum<=30 11 17:26:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %s% 12 17:26:30 SQL Execute: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like ?) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By Instrb(PYSM00,'s'),PYSM00) where Rownum<=30 13 17:26:36 SQL Prepare: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like :1) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By PYSM00) where Rownum<=30 14 17:26:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 15 17:26:36 SQL Execute: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like ?) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By PYSM00) where Rownum<=30 16 17:26:36 SQL Prepare: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like :1) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By Instrb(PYSM00,'z'),PYSM00) where Rownum<=30 17 17:26:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %z% 18 17:26:36 SQL Execute: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like ?) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By Instrb(PYSM00,'z'),PYSM00) where Rownum<=30 19 17:26:37 SQL Prepare: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like :1) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By Instrb(PYSM00,'zd'),PYSM00) where Rownum<=30 20 17:26:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %zd% 21 17:26:37 SQL Execute: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like ?) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By Instrb(PYSM00,'zd'),PYSM00) where Rownum<=30 22 17:26:37 SQL Prepare: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like :1) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By Instrb(PYSM00,'zdf'),PYSM00) where Rownum<=30 23 17:26:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %zdf% 24 17:26:37 SQL Execute: ORACLE - Select * from (select ZDMC00,PYSM00,WBSM00 from VW_BM_TYZD00 where (PYSM00 Like ?) and( exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=VW_BM_TYZD00.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1372))))) or MKDM00 is null ) Order By Instrb(PYSM00,'zdf'),PYSM00) where Rownum<=30 25 17:34:53 Log started for: 手术麻醉管理系统 26 17:35:24 SQL Prepare: ORACLE - delete XT_ZDYLXS where YGBH00=1372 and BMBH00=109 and DLXTMC='手术麻醉管理系统' and CTMC00='frmSS_TXMSM1' and DBGRIN='DBGridEhKCXX' 27 17:35:24 SQL Execute: ORACLE - delete XT_ZDYLXS where YGBH00=1372 and BMBH00=109 and DLXTMC='手术麻醉管理系统' and CTMC00='frmSS_TXMSM1' and DBGRIN='DBGridEhKCXX' 28 17:35:24 SQL Data In: ORACLE - Rows affected = 0 29 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',0,'Y', 'Name','物品名称',65 ,'-2147483633','-2147483643' ) 30 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',0,'Y', 'Name','物品名称',65 ,'-2147483633','-2147483643' ) 31 17:35:24 SQL Data In: ORACLE - Rows affected = 1 32 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',1,'Y', 'Spec','规格',45 ,'-2147483633','-2147483643' ) 33 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',1,'Y', 'Spec','规格',45 ,'-2147483633','-2147483643' ) 34 17:35:24 SQL Data In: ORACLE - Rows affected = 1 35 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',2,'Y', 'Unit','单位',45 ,'-2147483633','-2147483643' ) 36 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',2,'Y', 'Unit','单位',45 ,'-2147483633','-2147483643' ) 37 17:35:24 SQL Data In: ORACLE - Rows affected = 1 38 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',3,'Y', 'price','进价',45 ,'-2147483633','-2147483643' ) 39 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',3,'Y', 'price','进价',45 ,'-2147483633','-2147483643' ) 40 17:35:24 SQL Data In: ORACLE - Rows affected = 1 41 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',4,'Y', 'quantity','库存数量',65 ,'-2147483633','-2147483643' ) 42 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',4,'Y', 'quantity','库存数量',65 ,'-2147483633','-2147483643' ) 43 17:35:24 SQL Data In: ORACLE - Rows affected = 1 44 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',5,'Y', 'amount','库存金额',65 ,'-2147483633','-2147483643' ) 45 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',5,'Y', 'amount','库存金额',65 ,'-2147483633','-2147483643' ) 46 17:35:24 SQL Data In: ORACLE - Rows affected = 1 47 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',6,'Y', 'ph','批号',75 ,'-2147483633','-2147483643' ) 48 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',6,'Y', 'ph','批号',75 ,'-2147483633','-2147483643' ) 49 17:35:24 SQL Data In: ORACLE - Rows affected = 1 50 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',7,'Y', 'Regist_num','注册证号',70 ,'-2147483633','-2147483643' ) 51 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',7,'Y', 'Regist_num','注册证号',70 ,'-2147483633','-2147483643' ) 52 17:35:24 SQL Data In: ORACLE - Rows affected = 1 53 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',8,'Y', 'Yxq','有效期',90 ,'-2147483633','-2147483643' ) 54 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',8,'Y', 'Yxq','有效期',90 ,'-2147483633','-2147483643' ) 55 17:35:24 SQL Data In: ORACLE - Rows affected = 1 56 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',9,'Y', 'manufacturer','厂家',100 ,'-2147483633','-2147483643' ) 57 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',9,'Y', 'manufacturer','厂家',100 ,'-2147483633','-2147483643' ) 58 17:35:24 SQL Data In: ORACLE - Rows affected = 1 59 17:35:24 SQL Prepare: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',10,'Y', 'provider','供应商',100 ,'-2147483633','-2147483643' ) 60 17:35:24 SQL Execute: ORACLE - insert into XT_ZDYLXS(YGBH00,BMBH00,DLXTMC,CTMC00,DBGRIN,LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS) values(1372,109, '手术麻醉管理系统','frmSS_TXMSM1','DBGridEhKCXX',10,'Y', 'provider','供应商',100 ,'-2147483633','-2147483643' ) 61 17:35:24 SQL Data In: ORACLE - Rows affected = 1 62 17:35:24 SQL Prepare: ORACLE - Commit 63 17:35:24 SQL Execute: ORACLE - Commit 64 17:35:24 SQL Data In: ORACLE - Rows affected = 0 65 17:35:24 SQL Prepare: ORACLE - Rollback 66 17:35:24 SQL Execute: ORACLE - Rollback 67 17:35:24 SQL Data In: ORACLE - Rows affected = 0 68 17:35:27 SQL Prepare: ORACLE - select *,'DSS' from vw_ss_ybfy00_inp where sfxmid in (8000042487) and ((ybbrlb='0' and FBBH00='3' and YBZXLB='1' and sfsfxm='Y') or (sfsfxm='N')) 69 17:35:27 SQL Execute: ORACLE - select *,'DSS' from vw_ss_ybfy00_inp where sfxmid in (8000042487) and ((ybbrlb='0' and FBBH00='3' and YBZXLB='1' and sfsfxm='Y') or (sfsfxm='N')) 70 17:35:27 SQL Error: ORACLE - ORA-00923: 未找到要求的 FROM 关键字 71 17:35:27 SQL Error: ORACLE - Unmapped SQL Error Code: 923 72 17:35:27 SQL Data In: ORACLE - Rows affected = 0