From 86392f6e51620a47e0f6b4e8309adf3183feedbd Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期四, 29 十月 2026 13:33:58 +0800
Subject: [PATCH] feat(LIMS): 补齐资源管理、系统配置两个缺失模块

---
 src/main/java/com/ruoyi/lims/pojo/Instrument.java                               |   99 +++
 src/main/java/com/ruoyi/lims/controller/ReagentRecordController.java            |   55 +
 src/main/java/com/ruoyi/lims/mapper/InstrumentMapper.java                       |    9 
 src/main/java/com/ruoyi/lims/pojo/InstrumentCalibration.java                    |   94 +++
 src/main/java/com/ruoyi/lims/pojo/Unit.java                                     |   75 ++
 src/main/java/com/ruoyi/lims/service/InstrumentCalibrationService.java          |   11 
 src/main/java/com/ruoyi/lims/controller/UnitController.java                     |   55 +
 src/main/java/com/ruoyi/lims/service/impl/ReagentServiceImpl.java               |   37 +
 src/main/java/com/ruoyi/lims/controller/InstrumentCalibrationController.java    |   55 +
 src/main/java/com/ruoyi/lims/service/ReagentRecordService.java                  |   11 
 src/main/java/com/ruoyi/lims/service/ReagentService.java                        |   11 
 src/main/java/com/ruoyi/lims/service/impl/JudgmentStandardServiceImpl.java      |   34 +
 src/main/java/com/ruoyi/lims/service/impl/UnitServiceImpl.java                  |   32 +
 src/main/java/com/ruoyi/lims/service/UnitService.java                           |   11 
 src/main/java/com/ruoyi/lims/service/JudgmentStandardService.java               |   11 
 src/main/java/com/ruoyi/lims/service/TestItemService.java                       |   11 
 src/main/java/com/ruoyi/lims/mapper/ReagentRecordMapper.java                    |    9 
 src/main/java/com/ruoyi/lims/pojo/ReagentRecord.java                            |  104 +++
 doc/sql/lims_extra_modules.sql                                                  |  225 ++++++++
 src/main/java/com/ruoyi/lims/service/impl/InstrumentCalibrationServiceImpl.java |   34 +
 src/main/java/com/ruoyi/lims/pojo/Reagent.java                                  |  103 +++
 src/main/java/com/ruoyi/lims/pojo/JudgmentStandard.java                         |   93 +++
 src/main/java/com/ruoyi/lims/service/InstrumentService.java                     |   11 
 src/main/java/com/ruoyi/lims/service/impl/InstrumentServiceImpl.java            |   36 +
 src/main/java/com/ruoyi/lims/controller/ReagentController.java                  |   55 +
 src/main/java/com/ruoyi/lims/controller/InstrumentController.java               |   55 +
 src/main/java/com/ruoyi/lims/service/impl/ReagentRecordServiceImpl.java         |   35 +
 src/main/java/com/ruoyi/lims/mapper/InstrumentCalibrationMapper.java            |    9 
 src/main/java/com/ruoyi/lims/mapper/UnitMapper.java                             |    9 
 src/main/java/com/ruoyi/lims/mapper/JudgmentStandardMapper.java                 |    9 
 src/main/java/com/ruoyi/lims/mapper/TestItemMapper.java                         |    9 
 src/main/java/com/ruoyi/lims/controller/TestItemController.java                 |   55 +
 src/main/java/com/ruoyi/lims/mapper/ReagentMapper.java                          |    9 
 src/main/java/com/ruoyi/lims/service/impl/TestItemServiceImpl.java              |   34 +
 src/main/java/com/ruoyi/lims/pojo/TestItem.java                                 |   84 +++
 src/main/java/com/ruoyi/lims/controller/JudgmentStandardController.java         |   55 +
 36 files changed, 1,644 insertions(+), 0 deletions(-)

diff --git a/doc/sql/lims_extra_modules.sql b/doc/sql/lims_extra_modules.sql
new file mode 100644
index 0000000..2fec2df
--- /dev/null
+++ b/doc/sql/lims_extra_modules.sql
@@ -0,0 +1,225 @@
+-- ============================================================
+-- 鑺-LIMS 琛ュ厖妯″潡 DDL
+--   鈶� 璧勬簮绠$悊锛氫华鍣ㄨ澶囩淮鎶ゆ牎鍑� + 璇曞墏鑰楁潗搴撳瓨閲囪喘
+--   鈶� 绯荤粺閰嶇疆锛氭娴嬮」鐩簱 / 璁¢噺鍗曚綅搴� / 鍒ゅ畾鏍囧噯搴�
+-- 搴擄細lims-ruoyi
+-- ============================================================
+
+-- ============================================================
+-- 鈶� 璧勬簮绠$悊 路 浠櫒璁惧鍙拌处
+-- ============================================================
+DROP TABLE IF EXISTS `lims_instrument`;
+CREATE TABLE `lims_instrument` (
+  `id`                 BIGINT        NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `instrument_code`    VARCHAR(64)   DEFAULT NULL COMMENT '浠櫒缂栧彿',
+  `instrument_name`    VARCHAR(255)  DEFAULT NULL COMMENT '浠櫒鍚嶇О',
+  `instrument_model`   VARCHAR(255)  DEFAULT NULL COMMENT '瑙勬牸鍨嬪彿',
+  `manufacturer`       VARCHAR(255)  DEFAULT NULL COMMENT '鐢熶骇鍘傚晢',
+  `serial_no`          VARCHAR(128)  DEFAULT NULL COMMENT '鍑哄巶搴忓垪鍙�',
+  `location`           VARCHAR(255)  DEFAULT NULL COMMENT '瀛樻斁浣嶇疆',
+  `purchase_date`      DATE          DEFAULT NULL COMMENT '璐疆鏃ユ湡',
+  `warranty_end_date`  DATE          DEFAULT NULL COMMENT '淇濅慨鎴鏃ユ湡',
+  `status`             VARCHAR(32)   DEFAULT 'normal' COMMENT '鐘舵��(normal-姝e父,maintenance-缁翠慨涓�,scrapped-宸叉姤搴�,idle-闂茬疆)',
+  `responsible_person` VARCHAR(64)   DEFAULT NULL COMMENT '璐d换浜�',
+  `remark`             VARCHAR(1000) DEFAULT NULL COMMENT '澶囨敞',
+  `maintainer`         VARCHAR(64)   DEFAULT NULL COMMENT '缁存姢浜�',
+  `maintenance_time`   DATE          DEFAULT NULL COMMENT '缁存姢鏃堕棿',
+  `del_flag`           CHAR(1)       DEFAULT '0' COMMENT '鍒犻櫎鏍囧織(0-姝e父,2-鍒犻櫎)',
+  `tenant_id`          BIGINT        DEFAULT NULL COMMENT '绉熸埛ID',
+  `create_time`        DATETIME      DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `create_user`        INT           DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛',
+  `update_time`        DATETIME      DEFAULT NULL COMMENT '淇敼鏃堕棿',
+  `update_user`        INT           DEFAULT NULL COMMENT '淇敼鐢ㄦ埛',
+  PRIMARY KEY (`id`),
+  KEY `idx_instrument_code` (`instrument_code`),
+  KEY `idx_status` (`status`),
+  KEY `idx_tenant` (`tenant_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LIMS-浠櫒璁惧鍙拌处';
+
+-- ============================================================
+-- 鈶� 璧勬簮绠$悊 路 浠櫒鏍″噯/缁存姢璁板綍
+-- ============================================================
+DROP TABLE IF EXISTS `lims_instrument_calibration`;
+CREATE TABLE `lims_instrument_calibration` (
+  `id`                   BIGINT        NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `instrument_id`        BIGINT        DEFAULT NULL COMMENT '浠櫒ID(lims_instrument.id)',
+  `instrument_code`      VARCHAR(64)   DEFAULT NULL COMMENT '浠櫒缂栧彿(鍐椾綑渚夸簬鏌ヨ)',
+  `instrument_name`      VARCHAR(255)  DEFAULT NULL COMMENT '浠櫒鍚嶇О(鍐椾綑)',
+  `record_type`          VARCHAR(32)   DEFAULT 'calibration' COMMENT '璁板綍绫诲瀷(calibration-鏍″噯,maintenance-缁存姢淇濆吇,repair-缁翠慨)',
+  `calibration_date`     DATE          DEFAULT NULL COMMENT '鏈鏃ユ湡',
+  `next_calibration_date` DATE         DEFAULT NULL COMMENT '涓嬫鍒版湡鏃ユ湡',
+  `calibration_org`      VARCHAR(255)  DEFAULT NULL COMMENT '鏍″噯/缁翠繚鏈烘瀯',
+  `certificate_no`       VARCHAR(128)  DEFAULT NULL COMMENT '璇佷功缂栧彿',
+  `calibration_result`   VARCHAR(32)   DEFAULT NULL COMMENT '缁撴灉(pass-鍚堟牸,fail-涓嶅悎鏍�,conditional-鏈夋潯浠堕�氳繃)',
+  `cost`                 DECIMAL(18,2) DEFAULT NULL COMMENT '璐圭敤',
+  `executor`             VARCHAR(64)   DEFAULT NULL COMMENT '鎵ц浜�',
+  `remark`               VARCHAR(1000) DEFAULT NULL COMMENT '澶囨敞',
+  `del_flag`             CHAR(1)       DEFAULT '0' COMMENT '鍒犻櫎鏍囧織(0-姝e父,2-鍒犻櫎)',
+  `tenant_id`            BIGINT        DEFAULT NULL COMMENT '绉熸埛ID',
+  `create_time`          DATETIME      DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `create_user`          INT           DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛',
+  `update_time`          DATETIME      DEFAULT NULL COMMENT '淇敼鏃堕棿',
+  `update_user`          INT           DEFAULT NULL COMMENT '淇敼鐢ㄦ埛',
+  PRIMARY KEY (`id`),
+  KEY `idx_instrument_id` (`instrument_id`),
+  KEY `idx_next_date` (`next_calibration_date`),
+  KEY `idx_tenant` (`tenant_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LIMS-浠櫒鏍″噯缁存姢璁板綍';
+
+-- ============================================================
+-- 鈶� 璧勬簮绠$悊 路 璇曞墏鑰楁潗鍙拌处
+-- ============================================================
+DROP TABLE IF EXISTS `lims_reagent`;
+CREATE TABLE `lims_reagent` (
+  `id`                BIGINT        NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `reagent_code`      VARCHAR(64)   DEFAULT NULL COMMENT '璇曞墏/鑰楁潗缂栧彿',
+  `reagent_name`      VARCHAR(255)  DEFAULT NULL COMMENT '鍚嶇О',
+  `specification`     VARCHAR(255)  DEFAULT NULL COMMENT '瑙勬牸',
+  `category`          VARCHAR(32)   DEFAULT NULL COMMENT '绫诲埆(reagent-璇曞墏,consumable-鑰楁潗,standard-鏍囧噯鍝�,control-璐ㄦ帶鍝�)',
+  `unit`              VARCHAR(32)   DEFAULT NULL COMMENT '璁¢噺鍗曚綅',
+  `supplier`          VARCHAR(255)  DEFAULT NULL COMMENT '渚涘簲鍟�',
+  `storage_condition` VARCHAR(255)  DEFAULT NULL COMMENT '瀛樺偍鏉′欢(濡� 2-8鈩冮伩鍏�)',
+  `current_stock`     DECIMAL(18,4) DEFAULT 0 COMMENT '褰撳墠搴撳瓨',
+  `safety_stock`      DECIMAL(18,4) DEFAULT 0 COMMENT '瀹夊叏搴撳瓨(浣庝簬姝ゅ�奸璀�)',
+  `expiry_date`       DATE          DEFAULT NULL COMMENT '鏈夋晥鏈熻嚦',
+  `location`          VARCHAR(255)  DEFAULT NULL COMMENT '瀛樻斁浣嶇疆',
+  `status`            VARCHAR(32)   DEFAULT 'normal' COMMENT '鐘舵��(normal-姝e父,expiring-涓存湡,expired-杩囨湡,depleted-宸茶�楀敖)',
+  `remark`            VARCHAR(1000) DEFAULT NULL COMMENT '澶囨敞',
+  `maintainer`        VARCHAR(64)   DEFAULT NULL COMMENT '缁存姢浜�',
+  `maintenance_time`  DATE          DEFAULT NULL COMMENT '缁存姢鏃堕棿',
+  `del_flag`          CHAR(1)       DEFAULT '0' COMMENT '鍒犻櫎鏍囧織(0-姝e父,2-鍒犻櫎)',
+  `tenant_id`         BIGINT        DEFAULT NULL COMMENT '绉熸埛ID',
+  `create_time`       DATETIME      DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `create_user`       INT           DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛',
+  `update_time`       DATETIME      DEFAULT NULL COMMENT '淇敼鏃堕棿',
+  `update_user`       INT           DEFAULT NULL COMMENT '淇敼鐢ㄦ埛',
+  PRIMARY KEY (`id`),
+  KEY `idx_reagent_code` (`reagent_code`),
+  KEY `idx_expiry` (`expiry_date`),
+  KEY `idx_tenant` (`tenant_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LIMS-璇曞墏鑰楁潗鍙拌处';
+
+-- ============================================================
+-- 鈶� 璧勬簮绠$悊 路 璇曞墏鑰楁潗鍑哄叆搴撴祦姘达紙鍚噰璐叆搴擄級
+-- ============================================================
+DROP TABLE IF EXISTS `lims_reagent_record`;
+CREATE TABLE `lims_reagent_record` (
+  `id`                  BIGINT        NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `reagent_id`          BIGINT        DEFAULT NULL COMMENT '璇曞墏ID(lims_reagent.id)',
+  `reagent_code`        VARCHAR(64)   DEFAULT NULL COMMENT '璇曞墏缂栧彿(鍐椾綑)',
+  `reagent_name`        VARCHAR(255)  DEFAULT NULL COMMENT '鍚嶇О(鍐椾綑)',
+  `record_type`         VARCHAR(32)   DEFAULT 'in' COMMENT '绫诲瀷(in-鍏ュ簱(閲囪喘),out-鍑哄簱(棰嗙敤),return-閫�搴�,scrap-鎶ュ簾)',
+  `quantity`            DECIMAL(18,4) DEFAULT NULL COMMENT '鏁伴噺(姝f暟)',
+  `before_stock`        DECIMAL(18,4) DEFAULT NULL COMMENT '鎿嶄綔鍓嶅簱瀛�',
+  `after_stock`         DECIMAL(18,4) DEFAULT NULL COMMENT '鎿嶄綔鍚庡簱瀛�',
+  `batch_no`            VARCHAR(128)  DEFAULT NULL COMMENT '鎵规鍙�',
+  `supplier`            VARCHAR(255)  DEFAULT NULL COMMENT '渚涘簲鍟�(鍏ュ簱鏃�)',
+  `unit_price`          DECIMAL(18,4) DEFAULT NULL COMMENT '鍗曚环',
+  `total_amount`        DECIMAL(18,2) DEFAULT NULL COMMENT '閲戦',
+  `operator`            VARCHAR(64)   DEFAULT NULL COMMENT '缁忔墜浜�',
+  `operate_time`        DATETIME      DEFAULT NULL COMMENT '鎿嶄綔鏃堕棿',
+  `purpose`             VARCHAR(500)  DEFAULT NULL COMMENT '鐢ㄩ��/棰嗙敤浜嬬敱',
+  `related_experiment`  VARCHAR(128)  DEFAULT NULL COMMENT '鍏宠仈瀹為獙缂栧彿',
+  `remark`              VARCHAR(1000) DEFAULT NULL COMMENT '澶囨敞',
+  `del_flag`            CHAR(1)       DEFAULT '0' COMMENT '鍒犻櫎鏍囧織(0-姝e父,2-鍒犻櫎)',
+  `tenant_id`           BIGINT        DEFAULT NULL COMMENT '绉熸埛ID',
+  `create_time`         DATETIME      DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `create_user`         INT           DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛',
+  `update_time`         DATETIME      DEFAULT NULL COMMENT '淇敼鏃堕棿',
+  `update_user`         INT           DEFAULT NULL COMMENT '淇敼鐢ㄦ埛',
+  PRIMARY KEY (`id`),
+  KEY `idx_reagent_id` (`reagent_id`),
+  KEY `idx_operate_time` (`operate_time`),
+  KEY `idx_tenant` (`tenant_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LIMS-璇曞墏鑰楁潗鍑哄叆搴撴祦姘�';
+
+-- ============================================================
+-- 鈶� 绯荤粺閰嶇疆 路 妫�娴嬮」鐩簱
+-- ============================================================
+DROP TABLE IF EXISTS `lims_test_item`;
+CREATE TABLE `lims_test_item` (
+  `id`          BIGINT        NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `item_code`   VARCHAR(64)   DEFAULT NULL COMMENT '椤圭洰缂栧彿',
+  `item_name`   VARCHAR(255)  DEFAULT NULL COMMENT '妫�娴嬮」鐩悕绉�',
+  `item_type`   VARCHAR(32)   DEFAULT NULL COMMENT '绫诲瀷(chemical-鍖栧鍒嗘瀽,physical-鐗╃悊娴嬭瘯,microbial-寰敓鐗�,other-鍏跺畠)',
+  `unit`        VARCHAR(32)   DEFAULT NULL COMMENT '璁¢噺鍗曚綅',
+  `method`      VARCHAR(500)  DEFAULT NULL COMMENT '妫�娴嬫柟娉�/渚濇嵁',
+  `standard`    VARCHAR(255)  DEFAULT NULL COMMENT '鎵ц鏍囧噯(濡� GB/T xxxx)',
+  `limit_min`   DECIMAL(18,4) DEFAULT NULL COMMENT '鍚堟牸涓嬮檺',
+  `limit_max`   DECIMAL(18,4) DEFAULT NULL COMMENT '鍚堟牸涓婇檺',
+  `status`      VARCHAR(4)    DEFAULT '1' COMMENT '鐘舵��(1-鍚敤,0-鍋滅敤)',
+  `remark`      VARCHAR(1000) DEFAULT NULL COMMENT '澶囨敞',
+  `del_flag`    CHAR(1)       DEFAULT '0' COMMENT '鍒犻櫎鏍囧織(0-姝e父,2-鍒犻櫎)',
+  `tenant_id`   BIGINT        DEFAULT NULL COMMENT '绉熸埛ID',
+  `create_time` DATETIME      DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `create_user` INT           DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛',
+  `update_time` DATETIME      DEFAULT NULL COMMENT '淇敼鏃堕棿',
+  `update_user` INT           DEFAULT NULL COMMENT '淇敼鐢ㄦ埛',
+  PRIMARY KEY (`id`),
+  KEY `idx_item_code` (`item_code`),
+  KEY `idx_tenant` (`tenant_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LIMS-妫�娴嬮」鐩簱';
+
+-- ============================================================
+-- 鈶� 绯荤粺閰嶇疆 路 璁¢噺鍗曚綅搴�
+-- ============================================================
+DROP TABLE IF EXISTS `lims_unit`;
+CREATE TABLE `lims_unit` (
+  `id`              BIGINT        NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `unit_code`       VARCHAR(32)   DEFAULT NULL COMMENT '鍗曚綅缂栫爜',
+  `unit_name`       VARCHAR(64)   DEFAULT NULL COMMENT '鍗曚綅鍚嶇О',
+  `unit_type`       VARCHAR(32)   DEFAULT NULL COMMENT '绫诲瀷(weight-閲嶉噺,volume-浣撶Н,length-闀垮害,temperature-娓╁害,concentration-娴撳害,count-璁℃暟)',
+  `base_unit`       VARCHAR(32)   DEFAULT NULL COMMENT '鍩哄噯鍗曚綅(鎹㈢畻鍙傜収)',
+  `conversion_rate` DECIMAL(18,6) DEFAULT 1 COMMENT '鎹㈢畻绯绘暟(1 鏈崟浣� = N 鍩哄噯鍗曚綅)',
+  `status`          VARCHAR(4)    DEFAULT '1' COMMENT '鐘舵��(1-鍚敤,0-鍋滅敤)',
+  `remark`          VARCHAR(500)  DEFAULT NULL COMMENT '澶囨敞',
+  `del_flag`        CHAR(1)       DEFAULT '0' COMMENT '鍒犻櫎鏍囧織(0-姝e父,2-鍒犻櫎)',
+  `tenant_id`       BIGINT        DEFAULT NULL COMMENT '绉熸埛ID',
+  `create_time`     DATETIME      DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `create_user`     INT           DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛',
+  `update_time`     DATETIME      DEFAULT NULL COMMENT '淇敼鏃堕棿',
+  `update_user`     INT           DEFAULT NULL COMMENT '淇敼鐢ㄦ埛',
+  PRIMARY KEY (`id`),
+  KEY `idx_unit_code` (`unit_code`),
+  KEY `idx_tenant` (`tenant_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LIMS-璁¢噺鍗曚綅搴�';
+
+-- ============================================================
+-- 鈶� 绯荤粺閰嶇疆 路 鍒ゅ畾鏍囧噯搴�
+-- ============================================================
+DROP TABLE IF EXISTS `lims_judgment_standard`;
+CREATE TABLE `lims_judgment_standard` (
+  `id`             BIGINT        NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `standard_code`  VARCHAR(64)   DEFAULT NULL COMMENT '鏍囧噯缂栧彿',
+  `standard_name`  VARCHAR(255)  DEFAULT NULL COMMENT '鏍囧噯鍚嶇О',
+  `item_id`        BIGINT        DEFAULT NULL COMMENT '鍏宠仈妫�娴嬮」鐩甀D(lims_test_item.id)',
+  `item_name`      VARCHAR(255)  DEFAULT NULL COMMENT '妫�娴嬮」鐩悕绉�(鍐椾綑)',
+  `standard_type`  VARCHAR(32)   DEFAULT 'range' COMMENT '鍒ゅ畾绫诲瀷(range-鍖洪棿,min-涓嶄綆浜�,max-涓嶉珮浜�,equal-绛変簬,target-鐩爣鍊悸卞亸宸�)',
+  `min_value`      DECIMAL(18,4) DEFAULT NULL COMMENT '涓嬮檺',
+  `max_value`      DECIMAL(18,4) DEFAULT NULL COMMENT '涓婇檺',
+  `target_value`   DECIMAL(18,4) DEFAULT NULL COMMENT '鐩爣鍊�',
+  `deviation`      DECIMAL(18,4) DEFAULT NULL COMMENT '鍏佽鍋忓樊',
+  `unit`           VARCHAR(32)   DEFAULT NULL COMMENT '鍗曚綅',
+  `source_standard` VARCHAR(255) DEFAULT NULL COMMENT '渚濇嵁鏍囧噯(濡� GB 5749-2022)',
+  `status`         VARCHAR(4)    DEFAULT '1' COMMENT '鐘舵��(1-鍚敤,0-鍋滅敤)',
+  `remark`         VARCHAR(1000) DEFAULT NULL COMMENT '澶囨敞',
+  `del_flag`       CHAR(1)       DEFAULT '0' COMMENT '鍒犻櫎鏍囧織(0-姝e父,2-鍒犻櫎)',
+  `tenant_id`      BIGINT        DEFAULT NULL COMMENT '绉熸埛ID',
+  `create_time`    DATETIME      DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `create_user`    INT           DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛',
+  `update_time`    DATETIME      DEFAULT NULL COMMENT '淇敼鏃堕棿',
+  `update_user`    INT           DEFAULT NULL COMMENT '淇敼鐢ㄦ埛',
+  PRIMARY KEY (`id`),
+  KEY `idx_standard_code` (`standard_code`),
+  KEY `idx_item_id` (`item_id`),
+  KEY `idx_tenant` (`tenant_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LIMS-鍒ゅ畾鏍囧噯搴�';
+
+-- ============================================================
+-- 鏍¢獙
+-- ============================================================
+SELECT table_name, table_comment
+FROM information_schema.tables
+WHERE table_schema = 'lims-ruoyi'
+  AND table_name IN ('lims_instrument','lims_instrument_calibration','lims_reagent','lims_reagent_record','lims_test_item','lims_unit','lims_judgment_standard')
+ORDER BY table_name;
diff --git a/src/main/java/com/ruoyi/lims/controller/InstrumentCalibrationController.java b/src/main/java/com/ruoyi/lims/controller/InstrumentCalibrationController.java
new file mode 100644
index 0000000..1fcd6db
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/controller/InstrumentCalibrationController.java
@@ -0,0 +1,55 @@
+package com.ruoyi.lims.controller;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.lims.pojo.InstrumentCalibration;
+import com.ruoyi.lims.service.InstrumentCalibrationService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@RestController
+@AllArgsConstructor
+@RequestMapping("/lims/instrumentCalibration")
+@Api(value = "InstrumentCalibration", tags = "Instrument Calibration Records")
+public class InstrumentCalibrationController {
+
+    private InstrumentCalibrationService calibrationService;
+
+    @GetMapping("/listPage")
+    @ApiOperation("Paged query")
+    public AjaxResult listPage(Page<InstrumentCalibration> page, InstrumentCalibration query) {
+        IPage<InstrumentCalibration> result = calibrationService.listPage(page, query);
+        return AjaxResult.success(result);
+    }
+
+    @GetMapping("/{id}")
+    @ApiOperation("Get by id")
+    public AjaxResult getById(@PathVariable Long id) {
+        return AjaxResult.success(calibrationService.getById(id));
+    }
+
+    @PostMapping("/add")
+    @ApiOperation("Add")
+    public AjaxResult add(@RequestBody InstrumentCalibration entity) {
+        return AjaxResult.success(calibrationService.save(entity));
+    }
+
+    @PostMapping("/update")
+    @ApiOperation("Update")
+    public AjaxResult update(@RequestBody InstrumentCalibration entity) {
+        return AjaxResult.success(calibrationService.updateById(entity));
+    }
+
+    @DeleteMapping("/delete")
+    @ApiOperation("Batch delete")
+    public AjaxResult delete(@RequestBody List<Long> ids) {
+        if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("ids required");
+        return AjaxResult.success(calibrationService.removeBatchByIds(ids));
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/controller/InstrumentController.java b/src/main/java/com/ruoyi/lims/controller/InstrumentController.java
new file mode 100644
index 0000000..af1a493
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/controller/InstrumentController.java
@@ -0,0 +1,55 @@
+package com.ruoyi.lims.controller;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.lims.pojo.Instrument;
+import com.ruoyi.lims.service.InstrumentService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@RestController
+@AllArgsConstructor
+@RequestMapping("/lims/instrument")
+@Api(value = "Instrument", tags = "Instrument Ledger")
+public class InstrumentController {
+
+    private InstrumentService instrumentService;
+
+    @GetMapping("/listPage")
+    @ApiOperation("Paged query")
+    public AjaxResult listPage(Page<Instrument> page, Instrument query) {
+        IPage<Instrument> result = instrumentService.listPage(page, query);
+        return AjaxResult.success(result);
+    }
+
+    @GetMapping("/{id}")
+    @ApiOperation("Get by id")
+    public AjaxResult getById(@PathVariable Long id) {
+        return AjaxResult.success(instrumentService.getById(id));
+    }
+
+    @PostMapping("/add")
+    @ApiOperation("Add")
+    public AjaxResult add(@RequestBody Instrument entity) {
+        return AjaxResult.success(instrumentService.save(entity));
+    }
+
+    @PostMapping("/update")
+    @ApiOperation("Update")
+    public AjaxResult update(@RequestBody Instrument entity) {
+        return AjaxResult.success(instrumentService.updateById(entity));
+    }
+
+    @DeleteMapping("/delete")
+    @ApiOperation("Batch delete")
+    public AjaxResult delete(@RequestBody List<Long> ids) {
+        if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("ids required");
+        return AjaxResult.success(instrumentService.removeBatchByIds(ids));
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/controller/JudgmentStandardController.java b/src/main/java/com/ruoyi/lims/controller/JudgmentStandardController.java
new file mode 100644
index 0000000..ae4646e
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/controller/JudgmentStandardController.java
@@ -0,0 +1,55 @@
+package com.ruoyi.lims.controller;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.lims.pojo.JudgmentStandard;
+import com.ruoyi.lims.service.JudgmentStandardService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@RestController
+@AllArgsConstructor
+@RequestMapping("/lims/judgmentStandard")
+@Api(value = "JudgmentStandard", tags = "Judgment Standard Library")
+public class JudgmentStandardController {
+
+    private JudgmentStandardService judgmentStandardService;
+
+    @GetMapping("/listPage")
+    @ApiOperation("Paged query")
+    public AjaxResult listPage(Page<JudgmentStandard> page, JudgmentStandard query) {
+        IPage<JudgmentStandard> result = judgmentStandardService.listPage(page, query);
+        return AjaxResult.success(result);
+    }
+
+    @GetMapping("/{id}")
+    @ApiOperation("Get by id")
+    public AjaxResult getById(@PathVariable Long id) {
+        return AjaxResult.success(judgmentStandardService.getById(id));
+    }
+
+    @PostMapping("/add")
+    @ApiOperation("Add")
+    public AjaxResult add(@RequestBody JudgmentStandard entity) {
+        return AjaxResult.success(judgmentStandardService.save(entity));
+    }
+
+    @PostMapping("/update")
+    @ApiOperation("Update")
+    public AjaxResult update(@RequestBody JudgmentStandard entity) {
+        return AjaxResult.success(judgmentStandardService.updateById(entity));
+    }
+
+    @DeleteMapping("/delete")
+    @ApiOperation("Batch delete")
+    public AjaxResult delete(@RequestBody List<Long> ids) {
+        if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("ids required");
+        return AjaxResult.success(judgmentStandardService.removeBatchByIds(ids));
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/controller/ReagentController.java b/src/main/java/com/ruoyi/lims/controller/ReagentController.java
new file mode 100644
index 0000000..6e9f684
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/controller/ReagentController.java
@@ -0,0 +1,55 @@
+package com.ruoyi.lims.controller;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.lims.pojo.Reagent;
+import com.ruoyi.lims.service.ReagentService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@RestController
+@AllArgsConstructor
+@RequestMapping("/lims/reagent")
+@Api(value = "Reagent", tags = "Reagent and Consumable Ledger")
+public class ReagentController {
+
+    private ReagentService reagentService;
+
+    @GetMapping("/listPage")
+    @ApiOperation("Paged query")
+    public AjaxResult listPage(Page<Reagent> page, Reagent query) {
+        IPage<Reagent> result = reagentService.listPage(page, query);
+        return AjaxResult.success(result);
+    }
+
+    @GetMapping("/{id}")
+    @ApiOperation("Get by id")
+    public AjaxResult getById(@PathVariable Long id) {
+        return AjaxResult.success(reagentService.getById(id));
+    }
+
+    @PostMapping("/add")
+    @ApiOperation("Add")
+    public AjaxResult add(@RequestBody Reagent entity) {
+        return AjaxResult.success(reagentService.save(entity));
+    }
+
+    @PostMapping("/update")
+    @ApiOperation("Update")
+    public AjaxResult update(@RequestBody Reagent entity) {
+        return AjaxResult.success(reagentService.updateById(entity));
+    }
+
+    @DeleteMapping("/delete")
+    @ApiOperation("Batch delete")
+    public AjaxResult delete(@RequestBody List<Long> ids) {
+        if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("ids required");
+        return AjaxResult.success(reagentService.removeBatchByIds(ids));
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/controller/ReagentRecordController.java b/src/main/java/com/ruoyi/lims/controller/ReagentRecordController.java
new file mode 100644
index 0000000..25ac3df
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/controller/ReagentRecordController.java
@@ -0,0 +1,55 @@
+package com.ruoyi.lims.controller;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.lims.pojo.ReagentRecord;
+import com.ruoyi.lims.service.ReagentRecordService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@RestController
+@AllArgsConstructor
+@RequestMapping("/lims/reagentRecord")
+@Api(value = "ReagentRecord", tags = "Reagent Stock In/Out Records")
+public class ReagentRecordController {
+
+    private ReagentRecordService reagentRecordService;
+
+    @GetMapping("/listPage")
+    @ApiOperation("Paged query")
+    public AjaxResult listPage(Page<ReagentRecord> page, ReagentRecord query) {
+        IPage<ReagentRecord> result = reagentRecordService.listPage(page, query);
+        return AjaxResult.success(result);
+    }
+
+    @GetMapping("/{id}")
+    @ApiOperation("Get by id")
+    public AjaxResult getById(@PathVariable Long id) {
+        return AjaxResult.success(reagentRecordService.getById(id));
+    }
+
+    @PostMapping("/add")
+    @ApiOperation("Add")
+    public AjaxResult add(@RequestBody ReagentRecord entity) {
+        return AjaxResult.success(reagentRecordService.save(entity));
+    }
+
+    @PostMapping("/update")
+    @ApiOperation("Update")
+    public AjaxResult update(@RequestBody ReagentRecord entity) {
+        return AjaxResult.success(reagentRecordService.updateById(entity));
+    }
+
+    @DeleteMapping("/delete")
+    @ApiOperation("Batch delete")
+    public AjaxResult delete(@RequestBody List<Long> ids) {
+        if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("ids required");
+        return AjaxResult.success(reagentRecordService.removeBatchByIds(ids));
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/controller/TestItemController.java b/src/main/java/com/ruoyi/lims/controller/TestItemController.java
new file mode 100644
index 0000000..eb62786
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/controller/TestItemController.java
@@ -0,0 +1,55 @@
+package com.ruoyi.lims.controller;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.lims.pojo.TestItem;
+import com.ruoyi.lims.service.TestItemService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@RestController
+@AllArgsConstructor
+@RequestMapping("/lims/testItem")
+@Api(value = "TestItem", tags = "Test Item Library")
+public class TestItemController {
+
+    private TestItemService testItemService;
+
+    @GetMapping("/listPage")
+    @ApiOperation("Paged query")
+    public AjaxResult listPage(Page<TestItem> page, TestItem query) {
+        IPage<TestItem> result = testItemService.listPage(page, query);
+        return AjaxResult.success(result);
+    }
+
+    @GetMapping("/{id}")
+    @ApiOperation("Get by id")
+    public AjaxResult getById(@PathVariable Long id) {
+        return AjaxResult.success(testItemService.getById(id));
+    }
+
+    @PostMapping("/add")
+    @ApiOperation("Add")
+    public AjaxResult add(@RequestBody TestItem entity) {
+        return AjaxResult.success(testItemService.save(entity));
+    }
+
+    @PostMapping("/update")
+    @ApiOperation("Update")
+    public AjaxResult update(@RequestBody TestItem entity) {
+        return AjaxResult.success(testItemService.updateById(entity));
+    }
+
+    @DeleteMapping("/delete")
+    @ApiOperation("Batch delete")
+    public AjaxResult delete(@RequestBody List<Long> ids) {
+        if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("ids required");
+        return AjaxResult.success(testItemService.removeBatchByIds(ids));
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/controller/UnitController.java b/src/main/java/com/ruoyi/lims/controller/UnitController.java
new file mode 100644
index 0000000..04196c7
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/controller/UnitController.java
@@ -0,0 +1,55 @@
+package com.ruoyi.lims.controller;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.lims.pojo.Unit;
+import com.ruoyi.lims.service.UnitService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@RestController
+@AllArgsConstructor
+@RequestMapping("/lims/unit")
+@Api(value = "Unit", tags = "Unit Library")
+public class UnitController {
+
+    private UnitService unitService;
+
+    @GetMapping("/listPage")
+    @ApiOperation("Paged query")
+    public AjaxResult listPage(Page<Unit> page, Unit query) {
+        IPage<Unit> result = unitService.listPage(page, query);
+        return AjaxResult.success(result);
+    }
+
+    @GetMapping("/{id}")
+    @ApiOperation("Get by id")
+    public AjaxResult getById(@PathVariable Long id) {
+        return AjaxResult.success(unitService.getById(id));
+    }
+
+    @PostMapping("/add")
+    @ApiOperation("Add")
+    public AjaxResult add(@RequestBody Unit entity) {
+        return AjaxResult.success(unitService.save(entity));
+    }
+
+    @PostMapping("/update")
+    @ApiOperation("Update")
+    public AjaxResult update(@RequestBody Unit entity) {
+        return AjaxResult.success(unitService.updateById(entity));
+    }
+
+    @DeleteMapping("/delete")
+    @ApiOperation("Batch delete")
+    public AjaxResult delete(@RequestBody List<Long> ids) {
+        if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("ids required");
+        return AjaxResult.success(unitService.removeBatchByIds(ids));
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/mapper/InstrumentCalibrationMapper.java b/src/main/java/com/ruoyi/lims/mapper/InstrumentCalibrationMapper.java
new file mode 100644
index 0000000..ecc8936
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/mapper/InstrumentCalibrationMapper.java
@@ -0,0 +1,9 @@
+package com.ruoyi.lims.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.lims.pojo.InstrumentCalibration;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface InstrumentCalibrationMapper extends BaseMapper<InstrumentCalibration> {
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/mapper/InstrumentMapper.java b/src/main/java/com/ruoyi/lims/mapper/InstrumentMapper.java
new file mode 100644
index 0000000..795fd39
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/mapper/InstrumentMapper.java
@@ -0,0 +1,9 @@
+package com.ruoyi.lims.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.lims.pojo.Instrument;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface InstrumentMapper extends BaseMapper<Instrument> {
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/mapper/JudgmentStandardMapper.java b/src/main/java/com/ruoyi/lims/mapper/JudgmentStandardMapper.java
new file mode 100644
index 0000000..2881562
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/mapper/JudgmentStandardMapper.java
@@ -0,0 +1,9 @@
+package com.ruoyi.lims.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.lims.pojo.JudgmentStandard;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface JudgmentStandardMapper extends BaseMapper<JudgmentStandard> {
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/mapper/ReagentMapper.java b/src/main/java/com/ruoyi/lims/mapper/ReagentMapper.java
new file mode 100644
index 0000000..af155b5
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/mapper/ReagentMapper.java
@@ -0,0 +1,9 @@
+package com.ruoyi.lims.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.lims.pojo.Reagent;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface ReagentMapper extends BaseMapper<Reagent> {
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/mapper/ReagentRecordMapper.java b/src/main/java/com/ruoyi/lims/mapper/ReagentRecordMapper.java
new file mode 100644
index 0000000..4da51bf
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/mapper/ReagentRecordMapper.java
@@ -0,0 +1,9 @@
+package com.ruoyi.lims.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.lims.pojo.ReagentRecord;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface ReagentRecordMapper extends BaseMapper<ReagentRecord> {
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/mapper/TestItemMapper.java b/src/main/java/com/ruoyi/lims/mapper/TestItemMapper.java
new file mode 100644
index 0000000..4b6ebfd
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/mapper/TestItemMapper.java
@@ -0,0 +1,9 @@
+package com.ruoyi.lims.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.lims.pojo.TestItem;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface TestItemMapper extends BaseMapper<TestItem> {
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/mapper/UnitMapper.java b/src/main/java/com/ruoyi/lims/mapper/UnitMapper.java
new file mode 100644
index 0000000..3b50c25
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/mapper/UnitMapper.java
@@ -0,0 +1,9 @@
+package com.ruoyi.lims.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.lims.pojo.Unit;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface UnitMapper extends BaseMapper<Unit> {
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/pojo/Instrument.java b/src/main/java/com/ruoyi/lims/pojo/Instrument.java
new file mode 100644
index 0000000..59d569d
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/pojo/Instrument.java
@@ -0,0 +1,99 @@
+package com.ruoyi.lims.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Data
+@TableName("lims_instrument")
+public class Instrument implements Serializable {
+
+    private static final long serialVersionUID = 1L;
+    @ApiModelProperty(value = "ID")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    @ApiModelProperty(value = "Instrument code")
+    private String instrumentCode;
+
+    @ApiModelProperty(value = "Instrument name")
+    private String instrumentName;
+
+    @ApiModelProperty(value = "Model")
+    private String instrumentModel;
+
+    @ApiModelProperty(value = "Manufacturer")
+    private String manufacturer;
+
+    @ApiModelProperty(value = "Serial number")
+    private String serialNo;
+
+    @ApiModelProperty(value = "Storage location")
+    private String location;
+
+    @ApiModelProperty(value = "Purchase date")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private LocalDate purchaseDate;
+
+    @ApiModelProperty(value = "Warranty end date")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private LocalDate warrantyEndDate;
+
+    @ApiModelProperty(value = "Status: normal/maintenance/scrapped/idle")
+    private String status;
+
+    @ApiModelProperty(value = "Responsible person")
+    private String responsiblePerson;
+
+    @ApiModelProperty(value = "Remark")
+    private String remark;
+
+    @ApiModelProperty(value = "Maintainer")
+    private String maintainer;
+
+    @ApiModelProperty(value = "Maintenance time")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private LocalDate maintenanceTime;
+
+    @ApiModelProperty(value = "Delete flag")
+    private String delFlag;
+
+    @ApiModelProperty(value = "Tenant id")
+    @TableField(fill = FieldFill.INSERT)
+    private Long tenantId;
+
+    @ApiModelProperty(value = "Create time")
+    @TableField(fill = FieldFill.INSERT)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime createTime;
+
+    @ApiModelProperty(value = "Create user")
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty(value = "Update time")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime updateTime;
+
+    @ApiModelProperty(value = "Update user")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+}
diff --git a/src/main/java/com/ruoyi/lims/pojo/InstrumentCalibration.java b/src/main/java/com/ruoyi/lims/pojo/InstrumentCalibration.java
new file mode 100644
index 0000000..9a58dfe
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/pojo/InstrumentCalibration.java
@@ -0,0 +1,94 @@
+package com.ruoyi.lims.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Data
+@TableName("lims_instrument_calibration")
+public class InstrumentCalibration implements Serializable {
+
+    private static final long serialVersionUID = 1L;
+    @ApiModelProperty(value = "ID")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    @ApiModelProperty(value = "Instrument id")
+    private Long instrumentId;
+
+    @ApiModelProperty(value = "Instrument code")
+    private String instrumentCode;
+
+    @ApiModelProperty(value = "Instrument name")
+    private String instrumentName;
+
+    @ApiModelProperty(value = "Type: calibration/maintenance/repair")
+    private String recordType;
+
+    @ApiModelProperty(value = "Calibration date")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private LocalDate calibrationDate;
+
+    @ApiModelProperty(value = "Next due date")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private LocalDate nextCalibrationDate;
+
+    @ApiModelProperty(value = "Calibration organization")
+    private String calibrationOrg;
+
+    @ApiModelProperty(value = "Certificate number")
+    private String certificateNo;
+
+    @ApiModelProperty(value = "Result: pass/fail/conditional")
+    private String calibrationResult;
+
+    @ApiModelProperty(value = "Cost")
+    private BigDecimal cost;
+
+    @ApiModelProperty(value = "Executor")
+    private String executor;
+
+    @ApiModelProperty(value = "Remark")
+    private String remark;
+
+    @ApiModelProperty(value = "Delete flag")
+    private String delFlag;
+
+    @ApiModelProperty(value = "Tenant id")
+    @TableField(fill = FieldFill.INSERT)
+    private Long tenantId;
+
+    @ApiModelProperty(value = "Create time")
+    @TableField(fill = FieldFill.INSERT)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime createTime;
+
+    @ApiModelProperty(value = "Create user")
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty(value = "Update time")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime updateTime;
+
+    @ApiModelProperty(value = "Update user")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+}
diff --git a/src/main/java/com/ruoyi/lims/pojo/JudgmentStandard.java b/src/main/java/com/ruoyi/lims/pojo/JudgmentStandard.java
new file mode 100644
index 0000000..b5a44a8
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/pojo/JudgmentStandard.java
@@ -0,0 +1,93 @@
+package com.ruoyi.lims.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Data
+@TableName("lims_judgment_standard")
+public class JudgmentStandard implements Serializable {
+
+    private static final long serialVersionUID = 1L;
+    @ApiModelProperty(value = "ID")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    @ApiModelProperty(value = "Standard code")
+    private String standardCode;
+
+    @ApiModelProperty(value = "Standard name")
+    private String standardName;
+
+    @ApiModelProperty(value = "Test item id")
+    private Long itemId;
+
+    @ApiModelProperty(value = "Test item name")
+    private String itemName;
+
+    @ApiModelProperty(value = "Type: range/min/max/equal/target")
+    private String standardType;
+
+    @ApiModelProperty(value = "Min value")
+    private BigDecimal minValue;
+
+    @ApiModelProperty(value = "Max value")
+    private BigDecimal maxValue;
+
+    @ApiModelProperty(value = "Target value")
+    private BigDecimal targetValue;
+
+    @ApiModelProperty(value = "Deviation")
+    private BigDecimal deviation;
+
+    @ApiModelProperty(value = "Unit")
+    private String unit;
+
+    @ApiModelProperty(value = "Source standard")
+    private String sourceStandard;
+
+    @ApiModelProperty(value = "Status 1 enabled 0 disabled")
+    private String status;
+
+    @ApiModelProperty(value = "Remark")
+    private String remark;
+
+    @ApiModelProperty(value = "Delete flag")
+    private String delFlag;
+
+    @ApiModelProperty(value = "Tenant id")
+    @TableField(fill = FieldFill.INSERT)
+    private Long tenantId;
+
+    @ApiModelProperty(value = "Create time")
+    @TableField(fill = FieldFill.INSERT)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime createTime;
+
+    @ApiModelProperty(value = "Create user")
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty(value = "Update time")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime updateTime;
+
+    @ApiModelProperty(value = "Update user")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+}
diff --git a/src/main/java/com/ruoyi/lims/pojo/Reagent.java b/src/main/java/com/ruoyi/lims/pojo/Reagent.java
new file mode 100644
index 0000000..3ce6329
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/pojo/Reagent.java
@@ -0,0 +1,103 @@
+package com.ruoyi.lims.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Data
+@TableName("lims_reagent")
+public class Reagent implements Serializable {
+
+    private static final long serialVersionUID = 1L;
+    @ApiModelProperty(value = "ID")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    @ApiModelProperty(value = "Reagent code")
+    private String reagentCode;
+
+    @ApiModelProperty(value = "Reagent name")
+    private String reagentName;
+
+    @ApiModelProperty(value = "Specification")
+    private String specification;
+
+    @ApiModelProperty(value = "Category: reagent/consumable/standard/control")
+    private String category;
+
+    @ApiModelProperty(value = "Unit")
+    private String unit;
+
+    @ApiModelProperty(value = "Supplier")
+    private String supplier;
+
+    @ApiModelProperty(value = "Storage condition")
+    private String storageCondition;
+
+    @ApiModelProperty(value = "Current stock")
+    private BigDecimal currentStock;
+
+    @ApiModelProperty(value = "Safety stock")
+    private BigDecimal safetyStock;
+
+    @ApiModelProperty(value = "Expiry date")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private LocalDate expiryDate;
+
+    @ApiModelProperty(value = "Location")
+    private String location;
+
+    @ApiModelProperty(value = "Status: normal/expiring/expired/depleted")
+    private String status;
+
+    @ApiModelProperty(value = "Remark")
+    private String remark;
+
+    @ApiModelProperty(value = "Maintainer")
+    private String maintainer;
+
+    @ApiModelProperty(value = "Maintenance time")
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    private LocalDate maintenanceTime;
+
+    @ApiModelProperty(value = "Delete flag")
+    private String delFlag;
+
+    @ApiModelProperty(value = "Tenant id")
+    @TableField(fill = FieldFill.INSERT)
+    private Long tenantId;
+
+    @ApiModelProperty(value = "Create time")
+    @TableField(fill = FieldFill.INSERT)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime createTime;
+
+    @ApiModelProperty(value = "Create user")
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty(value = "Update time")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime updateTime;
+
+    @ApiModelProperty(value = "Update user")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+}
diff --git a/src/main/java/com/ruoyi/lims/pojo/ReagentRecord.java b/src/main/java/com/ruoyi/lims/pojo/ReagentRecord.java
new file mode 100644
index 0000000..74cf56a
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/pojo/ReagentRecord.java
@@ -0,0 +1,104 @@
+package com.ruoyi.lims.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Data
+@TableName("lims_reagent_record")
+public class ReagentRecord implements Serializable {
+
+    private static final long serialVersionUID = 1L;
+    @ApiModelProperty(value = "ID")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    @ApiModelProperty(value = "Reagent id")
+    private Long reagentId;
+
+    @ApiModelProperty(value = "Reagent code")
+    private String reagentCode;
+
+    @ApiModelProperty(value = "Reagent name")
+    private String reagentName;
+
+    @ApiModelProperty(value = "Type: in/out/return/scrap")
+    private String recordType;
+
+    @ApiModelProperty(value = "Quantity")
+    private BigDecimal quantity;
+
+    @ApiModelProperty(value = "Stock before")
+    private BigDecimal beforeStock;
+
+    @ApiModelProperty(value = "Stock after")
+    private BigDecimal afterStock;
+
+    @ApiModelProperty(value = "Batch number")
+    private String batchNo;
+
+    @ApiModelProperty(value = "Supplier")
+    private String supplier;
+
+    @ApiModelProperty(value = "Unit price")
+    private BigDecimal unitPrice;
+
+    @ApiModelProperty(value = "Total amount")
+    private BigDecimal totalAmount;
+
+    @ApiModelProperty(value = "Operator")
+    private String operator;
+
+    @ApiModelProperty(value = "Operate time")
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime operateTime;
+
+    @ApiModelProperty(value = "Purpose")
+    private String purpose;
+
+    @ApiModelProperty(value = "Related experiment")
+    private String relatedExperiment;
+
+    @ApiModelProperty(value = "Remark")
+    private String remark;
+
+    @ApiModelProperty(value = "Delete flag")
+    private String delFlag;
+
+    @ApiModelProperty(value = "Tenant id")
+    @TableField(fill = FieldFill.INSERT)
+    private Long tenantId;
+
+    @ApiModelProperty(value = "Create time")
+    @TableField(fill = FieldFill.INSERT)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime createTime;
+
+    @ApiModelProperty(value = "Create user")
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty(value = "Update time")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime updateTime;
+
+    @ApiModelProperty(value = "Update user")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+}
diff --git a/src/main/java/com/ruoyi/lims/pojo/TestItem.java b/src/main/java/com/ruoyi/lims/pojo/TestItem.java
new file mode 100644
index 0000000..743f06d
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/pojo/TestItem.java
@@ -0,0 +1,84 @@
+package com.ruoyi.lims.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Data
+@TableName("lims_test_item")
+public class TestItem implements Serializable {
+
+    private static final long serialVersionUID = 1L;
+    @ApiModelProperty(value = "ID")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    @ApiModelProperty(value = "Item code")
+    private String itemCode;
+
+    @ApiModelProperty(value = "Item name")
+    private String itemName;
+
+    @ApiModelProperty(value = "Type: chemical/physical/microbial/other")
+    private String itemType;
+
+    @ApiModelProperty(value = "Unit")
+    private String unit;
+
+    @ApiModelProperty(value = "Test method")
+    private String method;
+
+    @ApiModelProperty(value = "Standard")
+    private String standard;
+
+    @ApiModelProperty(value = "Lower limit")
+    private BigDecimal limitMin;
+
+    @ApiModelProperty(value = "Upper limit")
+    private BigDecimal limitMax;
+
+    @ApiModelProperty(value = "Status 1 enabled 0 disabled")
+    private String status;
+
+    @ApiModelProperty(value = "Remark")
+    private String remark;
+
+    @ApiModelProperty(value = "Delete flag")
+    private String delFlag;
+
+    @ApiModelProperty(value = "Tenant id")
+    @TableField(fill = FieldFill.INSERT)
+    private Long tenantId;
+
+    @ApiModelProperty(value = "Create time")
+    @TableField(fill = FieldFill.INSERT)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime createTime;
+
+    @ApiModelProperty(value = "Create user")
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty(value = "Update time")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime updateTime;
+
+    @ApiModelProperty(value = "Update user")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+}
diff --git a/src/main/java/com/ruoyi/lims/pojo/Unit.java b/src/main/java/com/ruoyi/lims/pojo/Unit.java
new file mode 100644
index 0000000..f2178a8
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/pojo/Unit.java
@@ -0,0 +1,75 @@
+package com.ruoyi.lims.pojo;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Data
+@TableName("lims_unit")
+public class Unit implements Serializable {
+
+    private static final long serialVersionUID = 1L;
+    @ApiModelProperty(value = "ID")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    @ApiModelProperty(value = "Unit code")
+    private String unitCode;
+
+    @ApiModelProperty(value = "Unit name")
+    private String unitName;
+
+    @ApiModelProperty(value = "Type: weight/volume/length/temperature/concentration/count")
+    private String unitType;
+
+    @ApiModelProperty(value = "Base unit")
+    private String baseUnit;
+
+    @ApiModelProperty(value = "Conversion rate")
+    private BigDecimal conversionRate;
+
+    @ApiModelProperty(value = "Status 1 enabled 0 disabled")
+    private String status;
+
+    @ApiModelProperty(value = "Remark")
+    private String remark;
+
+    @ApiModelProperty(value = "Delete flag")
+    private String delFlag;
+
+    @ApiModelProperty(value = "Tenant id")
+    @TableField(fill = FieldFill.INSERT)
+    private Long tenantId;
+
+    @ApiModelProperty(value = "Create time")
+    @TableField(fill = FieldFill.INSERT)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime createTime;
+
+    @ApiModelProperty(value = "Create user")
+    @TableField(fill = FieldFill.INSERT)
+    private Integer createUser;
+
+    @ApiModelProperty(value = "Update time")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private LocalDateTime updateTime;
+
+    @ApiModelProperty(value = "Update user")
+    @TableField(fill = FieldFill.INSERT_UPDATE)
+    private Integer updateUser;
+
+}
diff --git a/src/main/java/com/ruoyi/lims/service/InstrumentCalibrationService.java b/src/main/java/com/ruoyi/lims/service/InstrumentCalibrationService.java
new file mode 100644
index 0000000..a2a8525
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/InstrumentCalibrationService.java
@@ -0,0 +1,11 @@
+package com.ruoyi.lims.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.lims.pojo.InstrumentCalibration;
+
+public interface InstrumentCalibrationService extends IService<InstrumentCalibration> {
+    IPage<InstrumentCalibration> listPage(Page<InstrumentCalibration> page, InstrumentCalibration query);
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/InstrumentService.java b/src/main/java/com/ruoyi/lims/service/InstrumentService.java
new file mode 100644
index 0000000..fe99184
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/InstrumentService.java
@@ -0,0 +1,11 @@
+package com.ruoyi.lims.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.lims.pojo.Instrument;
+
+public interface InstrumentService extends IService<Instrument> {
+    IPage<Instrument> listPage(Page<Instrument> page, Instrument query);
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/JudgmentStandardService.java b/src/main/java/com/ruoyi/lims/service/JudgmentStandardService.java
new file mode 100644
index 0000000..a3a6165
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/JudgmentStandardService.java
@@ -0,0 +1,11 @@
+package com.ruoyi.lims.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.lims.pojo.JudgmentStandard;
+
+public interface JudgmentStandardService extends IService<JudgmentStandard> {
+    IPage<JudgmentStandard> listPage(Page<JudgmentStandard> page, JudgmentStandard query);
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/ReagentRecordService.java b/src/main/java/com/ruoyi/lims/service/ReagentRecordService.java
new file mode 100644
index 0000000..8a50567
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/ReagentRecordService.java
@@ -0,0 +1,11 @@
+package com.ruoyi.lims.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.lims.pojo.ReagentRecord;
+
+public interface ReagentRecordService extends IService<ReagentRecord> {
+    IPage<ReagentRecord> listPage(Page<ReagentRecord> page, ReagentRecord query);
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/ReagentService.java b/src/main/java/com/ruoyi/lims/service/ReagentService.java
new file mode 100644
index 0000000..05b7fc8
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/ReagentService.java
@@ -0,0 +1,11 @@
+package com.ruoyi.lims.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.lims.pojo.Reagent;
+
+public interface ReagentService extends IService<Reagent> {
+    IPage<Reagent> listPage(Page<Reagent> page, Reagent query);
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/TestItemService.java b/src/main/java/com/ruoyi/lims/service/TestItemService.java
new file mode 100644
index 0000000..30b36fe
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/TestItemService.java
@@ -0,0 +1,11 @@
+package com.ruoyi.lims.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.lims.pojo.TestItem;
+
+public interface TestItemService extends IService<TestItem> {
+    IPage<TestItem> listPage(Page<TestItem> page, TestItem query);
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/UnitService.java b/src/main/java/com/ruoyi/lims/service/UnitService.java
new file mode 100644
index 0000000..22a7e90
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/UnitService.java
@@ -0,0 +1,11 @@
+package com.ruoyi.lims.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.lims.pojo.Unit;
+
+public interface UnitService extends IService<Unit> {
+    IPage<Unit> listPage(Page<Unit> page, Unit query);
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/impl/InstrumentCalibrationServiceImpl.java b/src/main/java/com/ruoyi/lims/service/impl/InstrumentCalibrationServiceImpl.java
new file mode 100644
index 0000000..1b500b1
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/impl/InstrumentCalibrationServiceImpl.java
@@ -0,0 +1,34 @@
+package com.ruoyi.lims.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.lims.mapper.InstrumentCalibrationMapper;
+import com.ruoyi.lims.pojo.InstrumentCalibration;
+import com.ruoyi.lims.service.InstrumentCalibrationService;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class InstrumentCalibrationServiceImpl extends ServiceImpl<InstrumentCalibrationMapper, InstrumentCalibration> implements InstrumentCalibrationService {
+
+    @Override
+    public IPage<InstrumentCalibration> listPage(Page<InstrumentCalibration> page, InstrumentCalibration query) {
+        QueryWrapper<InstrumentCalibration> wrapper = new QueryWrapper<>();
+        if (query != null) {
+        wrapper.like(StringUtils.isNotEmpty(query.getInstrumentCode()), "instrument_code", query.getInstrumentCode());
+        wrapper.like(StringUtils.isNotEmpty(query.getInstrumentName()), "instrument_name", query.getInstrumentName());
+        wrapper.like(StringUtils.isNotEmpty(query.getRecordType()), "record_type", query.getRecordType());
+        wrapper.like(StringUtils.isNotEmpty(query.getCalibrationOrg()), "calibration_org", query.getCalibrationOrg());
+        wrapper.like(StringUtils.isNotEmpty(query.getCertificateNo()), "certificate_no", query.getCertificateNo());
+        wrapper.like(StringUtils.isNotEmpty(query.getCalibrationResult()), "calibration_result", query.getCalibrationResult());
+        wrapper.like(StringUtils.isNotEmpty(query.getExecutor()), "executor", query.getExecutor());
+        wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
+        }
+        wrapper.orderByDesc("id");
+        return baseMapper.selectPage(page, wrapper);
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/impl/InstrumentServiceImpl.java b/src/main/java/com/ruoyi/lims/service/impl/InstrumentServiceImpl.java
new file mode 100644
index 0000000..a3c6c9a
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/impl/InstrumentServiceImpl.java
@@ -0,0 +1,36 @@
+package com.ruoyi.lims.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.lims.mapper.InstrumentMapper;
+import com.ruoyi.lims.pojo.Instrument;
+import com.ruoyi.lims.service.InstrumentService;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class InstrumentServiceImpl extends ServiceImpl<InstrumentMapper, Instrument> implements InstrumentService {
+
+    @Override
+    public IPage<Instrument> listPage(Page<Instrument> page, Instrument query) {
+        QueryWrapper<Instrument> wrapper = new QueryWrapper<>();
+        if (query != null) {
+        wrapper.like(StringUtils.isNotEmpty(query.getInstrumentCode()), "instrument_code", query.getInstrumentCode());
+        wrapper.like(StringUtils.isNotEmpty(query.getInstrumentName()), "instrument_name", query.getInstrumentName());
+        wrapper.like(StringUtils.isNotEmpty(query.getInstrumentModel()), "instrument_model", query.getInstrumentModel());
+        wrapper.like(StringUtils.isNotEmpty(query.getManufacturer()), "manufacturer", query.getManufacturer());
+        wrapper.like(StringUtils.isNotEmpty(query.getSerialNo()), "serial_no", query.getSerialNo());
+        wrapper.like(StringUtils.isNotEmpty(query.getLocation()), "location", query.getLocation());
+        wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus());
+        wrapper.like(StringUtils.isNotEmpty(query.getResponsiblePerson()), "responsible_person", query.getResponsiblePerson());
+        wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
+        wrapper.like(StringUtils.isNotEmpty(query.getMaintainer()), "maintainer", query.getMaintainer());
+        }
+        wrapper.orderByDesc("id");
+        return baseMapper.selectPage(page, wrapper);
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/impl/JudgmentStandardServiceImpl.java b/src/main/java/com/ruoyi/lims/service/impl/JudgmentStandardServiceImpl.java
new file mode 100644
index 0000000..85e7d80
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/impl/JudgmentStandardServiceImpl.java
@@ -0,0 +1,34 @@
+package com.ruoyi.lims.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.lims.mapper.JudgmentStandardMapper;
+import com.ruoyi.lims.pojo.JudgmentStandard;
+import com.ruoyi.lims.service.JudgmentStandardService;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class JudgmentStandardServiceImpl extends ServiceImpl<JudgmentStandardMapper, JudgmentStandard> implements JudgmentStandardService {
+
+    @Override
+    public IPage<JudgmentStandard> listPage(Page<JudgmentStandard> page, JudgmentStandard query) {
+        QueryWrapper<JudgmentStandard> wrapper = new QueryWrapper<>();
+        if (query != null) {
+        wrapper.like(StringUtils.isNotEmpty(query.getStandardCode()), "standard_code", query.getStandardCode());
+        wrapper.like(StringUtils.isNotEmpty(query.getStandardName()), "standard_name", query.getStandardName());
+        wrapper.like(StringUtils.isNotEmpty(query.getItemName()), "item_name", query.getItemName());
+        wrapper.like(StringUtils.isNotEmpty(query.getStandardType()), "standard_type", query.getStandardType());
+        wrapper.like(StringUtils.isNotEmpty(query.getUnit()), "unit", query.getUnit());
+        wrapper.like(StringUtils.isNotEmpty(query.getSourceStandard()), "source_standard", query.getSourceStandard());
+        wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus());
+        wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
+        }
+        wrapper.orderByDesc("id");
+        return baseMapper.selectPage(page, wrapper);
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/impl/ReagentRecordServiceImpl.java b/src/main/java/com/ruoyi/lims/service/impl/ReagentRecordServiceImpl.java
new file mode 100644
index 0000000..0fdece6
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/impl/ReagentRecordServiceImpl.java
@@ -0,0 +1,35 @@
+package com.ruoyi.lims.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.lims.mapper.ReagentRecordMapper;
+import com.ruoyi.lims.pojo.ReagentRecord;
+import com.ruoyi.lims.service.ReagentRecordService;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class ReagentRecordServiceImpl extends ServiceImpl<ReagentRecordMapper, ReagentRecord> implements ReagentRecordService {
+
+    @Override
+    public IPage<ReagentRecord> listPage(Page<ReagentRecord> page, ReagentRecord query) {
+        QueryWrapper<ReagentRecord> wrapper = new QueryWrapper<>();
+        if (query != null) {
+        wrapper.like(StringUtils.isNotEmpty(query.getReagentCode()), "reagent_code", query.getReagentCode());
+        wrapper.like(StringUtils.isNotEmpty(query.getReagentName()), "reagent_name", query.getReagentName());
+        wrapper.like(StringUtils.isNotEmpty(query.getRecordType()), "record_type", query.getRecordType());
+        wrapper.like(StringUtils.isNotEmpty(query.getBatchNo()), "batch_no", query.getBatchNo());
+        wrapper.like(StringUtils.isNotEmpty(query.getSupplier()), "supplier", query.getSupplier());
+        wrapper.like(StringUtils.isNotEmpty(query.getOperator()), "operator", query.getOperator());
+        wrapper.like(StringUtils.isNotEmpty(query.getPurpose()), "purpose", query.getPurpose());
+        wrapper.like(StringUtils.isNotEmpty(query.getRelatedExperiment()), "related_experiment", query.getRelatedExperiment());
+        wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
+        }
+        wrapper.orderByDesc("id");
+        return baseMapper.selectPage(page, wrapper);
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/impl/ReagentServiceImpl.java b/src/main/java/com/ruoyi/lims/service/impl/ReagentServiceImpl.java
new file mode 100644
index 0000000..98883cc
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/impl/ReagentServiceImpl.java
@@ -0,0 +1,37 @@
+package com.ruoyi.lims.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.lims.mapper.ReagentMapper;
+import com.ruoyi.lims.pojo.Reagent;
+import com.ruoyi.lims.service.ReagentService;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class ReagentServiceImpl extends ServiceImpl<ReagentMapper, Reagent> implements ReagentService {
+
+    @Override
+    public IPage<Reagent> listPage(Page<Reagent> page, Reagent query) {
+        QueryWrapper<Reagent> wrapper = new QueryWrapper<>();
+        if (query != null) {
+        wrapper.like(StringUtils.isNotEmpty(query.getReagentCode()), "reagent_code", query.getReagentCode());
+        wrapper.like(StringUtils.isNotEmpty(query.getReagentName()), "reagent_name", query.getReagentName());
+        wrapper.like(StringUtils.isNotEmpty(query.getSpecification()), "specification", query.getSpecification());
+        wrapper.like(StringUtils.isNotEmpty(query.getCategory()), "category", query.getCategory());
+        wrapper.like(StringUtils.isNotEmpty(query.getUnit()), "unit", query.getUnit());
+        wrapper.like(StringUtils.isNotEmpty(query.getSupplier()), "supplier", query.getSupplier());
+        wrapper.like(StringUtils.isNotEmpty(query.getStorageCondition()), "storage_condition", query.getStorageCondition());
+        wrapper.like(StringUtils.isNotEmpty(query.getLocation()), "location", query.getLocation());
+        wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus());
+        wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
+        wrapper.like(StringUtils.isNotEmpty(query.getMaintainer()), "maintainer", query.getMaintainer());
+        }
+        wrapper.orderByDesc("id");
+        return baseMapper.selectPage(page, wrapper);
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/impl/TestItemServiceImpl.java b/src/main/java/com/ruoyi/lims/service/impl/TestItemServiceImpl.java
new file mode 100644
index 0000000..1fbbce7
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/impl/TestItemServiceImpl.java
@@ -0,0 +1,34 @@
+package com.ruoyi.lims.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.lims.mapper.TestItemMapper;
+import com.ruoyi.lims.pojo.TestItem;
+import com.ruoyi.lims.service.TestItemService;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class TestItemServiceImpl extends ServiceImpl<TestItemMapper, TestItem> implements TestItemService {
+
+    @Override
+    public IPage<TestItem> listPage(Page<TestItem> page, TestItem query) {
+        QueryWrapper<TestItem> wrapper = new QueryWrapper<>();
+        if (query != null) {
+        wrapper.like(StringUtils.isNotEmpty(query.getItemCode()), "item_code", query.getItemCode());
+        wrapper.like(StringUtils.isNotEmpty(query.getItemName()), "item_name", query.getItemName());
+        wrapper.like(StringUtils.isNotEmpty(query.getItemType()), "item_type", query.getItemType());
+        wrapper.like(StringUtils.isNotEmpty(query.getUnit()), "unit", query.getUnit());
+        wrapper.like(StringUtils.isNotEmpty(query.getMethod()), "method", query.getMethod());
+        wrapper.like(StringUtils.isNotEmpty(query.getStandard()), "standard", query.getStandard());
+        wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus());
+        wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
+        }
+        wrapper.orderByDesc("id");
+        return baseMapper.selectPage(page, wrapper);
+    }
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/lims/service/impl/UnitServiceImpl.java b/src/main/java/com/ruoyi/lims/service/impl/UnitServiceImpl.java
new file mode 100644
index 0000000..564dec9
--- /dev/null
+++ b/src/main/java/com/ruoyi/lims/service/impl/UnitServiceImpl.java
@@ -0,0 +1,32 @@
+package com.ruoyi.lims.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.lims.mapper.UnitMapper;
+import com.ruoyi.lims.pojo.Unit;
+import com.ruoyi.lims.service.UnitService;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class UnitServiceImpl extends ServiceImpl<UnitMapper, Unit> implements UnitService {
+
+    @Override
+    public IPage<Unit> listPage(Page<Unit> page, Unit query) {
+        QueryWrapper<Unit> wrapper = new QueryWrapper<>();
+        if (query != null) {
+        wrapper.like(StringUtils.isNotEmpty(query.getUnitCode()), "unit_code", query.getUnitCode());
+        wrapper.like(StringUtils.isNotEmpty(query.getUnitName()), "unit_name", query.getUnitName());
+        wrapper.like(StringUtils.isNotEmpty(query.getUnitType()), "unit_type", query.getUnitType());
+        wrapper.like(StringUtils.isNotEmpty(query.getBaseUnit()), "base_unit", query.getBaseUnit());
+        wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus());
+        wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
+        }
+        wrapper.orderByDesc("id");
+        return baseMapper.selectPage(page, wrapper);
+    }
+}
\ No newline at end of file

--
Gitblit v1.9.3