📈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、伯乐 等字母或汉字