# 📈QCBox常见问题

### 打开QCBox 报错

> 现象：提示缺少QcLog 
>
> 解决方法：打开SQL Server Management Studio ，选择QCDAO数据库，添加表

执行以下语句：

```sql
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语句，即可解决问题

```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 非伯乐质控品批号无法复制

![](/files/ccm6ADxlUZn0hTeLeQpr)

复制非伯乐质控品新批号的时候，无法填写新批号信息，解决办法：

将厂商改成其他值，不能含有**BIO**、**biorad**、**伯乐** 等字母或汉字


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://moli.gitbook.io/memo/wenti/qcbox.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.