📈QCBox常见问题
打开QCBox 报错
现象:提示缺少QcLog
解决方法:打开SQL Server Management Studio ,选择QCDAO数据库,添加表
执行以下语句:
IF OBJECT_ID ('dbo.QcLog') IS NOT NULL
DROP TABLE dbo.QcLog
GO
CREATE TABLE dbo.QcLog
(
ID INT IDENTITY NOT NULL,
Kind NVARCHAR (50) NOT NULL,
Message NVARCHAR (1000) NOT NULL,
LogLevel INT NOT NULL,
LogTime DATETIME NOT NULL,
LogUser NVARCHAR (20) NOT NULL,
LogComputer NVARCHAR (50) NOT NULL,
LogIp NVARCHAR (20) NOT NULL,
Version NVARCHAR (30) NOT NULL,
Properties NTEXT,
Extend1 NVARCHAR (50),
Extend2 NVARCHAR (50),
CONSTRAINT PK_QcLog PRIMARY KEY (ID)
)
GO
CREATE INDEX IX_QcLog_Kind
ON dbo.QcLog (Kind)
GO
QcBox导入基质
部分用户在使用QcBox添加非伯乐质控品时,无法选择基质信息,
原因在于QCDAO数据库QcDict表中没有相关数据,需要将基质数据添加到数据库中
添加基质信息
1.打开SQL Server Management Studio或者其他数据库工具比如SqlDbx,连接到QCDAO数据库
2.执行下列SQL语句,即可解决问题
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 1,N'水', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 2, N'等离子体', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 3,N'血清', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 4, N'脑脊液', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 5, N'尿液', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 6, N'全血', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 7, N'拭子', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 8, N'精液', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 9, N'粪便', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 10, N'汗液', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 11, N'唾液', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 12, N'核酸', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 98, N'未知', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
INSERT INTO dbo.QcDict (CodeKind, CodeNo, CodeName, ShortName, Status, Description, IsEnable, SeqNo, Extend1, Extend2, Extend3)
VALUES ('Matrix', 99, N'其他', NULL, 0, NULL, 1, 0, NULL, NULL, NULL)
GO
提示不可恢复的UI线程
可能的原因:未安装系统补丁,安装对应版本的补丁即可
QcBox 会用到的补丁
下载地址:https://decent.lanzoui.com/iKf6hnyqd9a 密码:aaaa
QcBox 非伯乐质控品批号无法复制

复制非伯乐质控品新批号的时候,无法填写新批号信息,解决办法:
将厂商改成其他值,不能含有BIO、biorad、伯乐 等字母或汉字
最后更新于
这有帮助吗?