Medical information collaborative management and data analysis system and method

Abstract

The invention discloses a medical information collaborative management and data analysis system and method, relates to the field of intelligent medical treatment, adopts a layered architecture design and realizes application and service separation based on a C / S mode, and the layered architecture comprises a data center layer, a business logic layer and a user interface layer. The medical information collaborative management and data analysis system (MACM) has the remarkable advantages that multi-source data such as UDI, medical insurance, drug administration and HIS billing can be integrated, data islands are broken through a layered architecture and a multi-module design, and cross-department efficient collaboration is achieved; rich automatic tools such as one-key form generation and data preprocessing are provided, manual operation is reduced, and efficiency is improved; the intelligent analysis module can carry out multi-dimensional analysis such as disease consumption ratio calculation and standardized consumption analysis, support refined decision making and comprehensively solve the defects of a traditional system.

Description

Technical Field

[0001] This invention relates to the field of smart healthcare technology, specifically to a collaborative management and data analysis system and method for medical information. Background Technology

[0002] Traditional medical supply management systems (such as the SPD model) manage the flow of supplies through basic modules such as logistics, inventory, and consumption. However, they lack dynamic monitoring of data such as UDI, medical insurance classification, drug regulatory classification, and HIS billing prices, and rely on manual operation to generate reports, resulting in low efficiency.

[0003] Existing medical data analysis tools mostly use independent modules (such as Excel or BI software) for consumption ratio or DRG analysis. The data needs to be manually integrated, cannot be linked with the material management process, and lacks automated preprocessing functions.

[0004] Therefore, the existing technology has the following specific drawbacks:

[0005] 1. Data silos and inefficient integration: Traditional systems do not integrate multi-source data such as UDI, medical insurance, drug supervision, and HIS billing, which makes cross-departmental data collaboration difficult, and manual processing is time-consuming and prone to errors.

[0006] 2. Insufficient level of automation: Lack of automation tools (such as one-click generation of supplier change requests, classification and summary, string formatting, etc.), relying on manual operation, resulting in low efficiency.

[0007] 3. Limited analytical dimensions: Existing technologies cannot achieve the calculation of consumption ratio indicators based on disease type, standardized consumption analysis based on disease type, departmental cost allocation, and dynamic management of alliance procurement, making it difficult to support refined decision-making. Summary of the Invention

[0008] The purpose of this invention is to provide a medical information collaborative management and data analysis system and method to solve the problems of existing technologies mentioned in the background, such as data silos and inefficient integration, insufficient intelligence, and single analysis dimensions, which make it difficult to meet the needs of refined management and decision support.

[0009] To achieve the above objectives, the present invention provides the following technical solution: a medical information collaborative management and data analysis system, which adopts a layered architecture design and separates applications and services based on a client / server model. The layered architecture includes:

[0010] Data center layer: Built on MySQL, it includes configuration data tables, hospital-level data tables, drug supervision data tables, and medical insurance data tables, which are used to store the core data of the system;

[0011] Business logic layer: Provides intermediate processing functions, including database operations, file I / O operations, search engine, DataCollection, and general API modules;

[0012] User Interface Layer: Provides user interaction functions, including a basic directory management module, a third-party situational awareness module, a one-click management tool module, an intelligent analysis module, and an interaction and logging module.

[0013] Preferably, the third-party situational awareness module of the user interface layer includes:

[0014] SPD monitoring submodule: Real-time tracking of SPD material identity information, inventory and consumption status;

[0015] UDI / Medical Insurance / Drug Regulatory Classification Monitoring Submodule: Dynamically matches regulatory data and triggers early warnings;

[0016] Price monitoring submodule: Links HIS billing catalog and procurement prices to optimize costs.

[0017] Preferably, the intelligent analysis module of the user interface layer includes:

[0018] Disease-specific consumption ratio calculation submodule: Based on the correlation analysis between DRG data and historical consumption;

[0019] Departmental cost allocation submodule: Dynamically allocates costs based on departmental revenue and expenditure data;

[0020] Alliance Procurement Optimization Submodule: Generates recommended solutions by combining historical procurement data with supplier evaluations;

[0021] Adverse event optimization submodule: Enables full-dimensional adverse event tracing and analysis.

[0022] Preferably, the intelligent analysis module further includes a standardized consumption analysis model. The model relies on a MySQL database and is based on real historical data from the hospital. It uses statistical analysis to calculate standardized consumption thresholds. The thresholds include usage probability, minimum consumption, maximum consumption, median consumption, upper quartile of consumption, lower quartile of consumption, consumption IQR, and consumption CV coefficient of variation.

[0023] Preferably, the intelligent analysis module also includes a consumption ratio calculation model. The model relies on a MySQL database and uses indicators based on DRG profit and loss, hospital budget, and core technologies to predict the annual consumption ratio.

[0024] The collaborative management and data analysis methods for medical information include the following steps:

[0025] System configuration steps: Install the Visual C++ runtime library, MySQL database and management tools, and Navicat tool; create a plandb database containing preset data tables.

[0026] System installation steps: Install the main program's runtime toolkit, system upgrade toolkit, system HTML page processing toolkit, open-source dynamic libraries, subroutine usage toolkit, and system configuration files;

[0027] User interaction steps: Receive user operations through the user interface layer, including attribute settings, medical device three-certificate information management, email management, log management, acceptance management, enterprise interaction management, and multi-platform collaborative management;

[0028] Data processing steps: The business logic layer processes the data generated by user interactions, including database operations, file I / O operations, and data acquisition.

[0029] Data storage steps: The processed data is stored in the corresponding data table through the data center layer;

[0030] Data update steps.

[0031] Preferably, the data update step includes:

[0032] Export data in Excel format from the hospital's integrated operation and management system, Zhixinlian smart medical consumables management software, the National Medical Products Administration database, the medical insurance database, and the Sunshine Procurement Platform;

[0033] The Excel format data can be imported into the corresponding data table in the system through the "Add" and "Update" operations, thereby updating the supplier matching directory, company contact information, billing system directory, registration certificate details, UDI information, and data from the Sunshine Platform.

[0034] Preferably, the multi-platform collaborative management includes:

[0035] The HERP module is used to process weekly plan documents, perform warehouse inventory checks, and print warehouse location labels.

[0036] The SPD / Sunshine Platform's functional modules can be used to process purchase orders, generate SPD specification import sheets, analyze online procurement rates, and manage alliance procurement.

[0037] The system utilizes general-purpose functional modules to classify, summarize, merge, format strings, and convert between XML and Excel formats for Excel files.

[0038] The main collaborative management module manages material reference information, pre-processed data, supplier changes, and ledger data.

[0039] Preferably, the management of the three certificates for medical devices includes:

[0040] Receive user-input attribute settings parameters, including system data directory, expiration time, drug regulatory authority website address, email information, and SMTP server information;

[0041] Receive user-input query criteria, including supplier name and registration certificate information, execute the query and return the results;

[0042] Respond to the "reload" operation and reload the data when the original data file of the three certificates changes.

[0043] Preferably, the log management includes:

[0044] Record email sending history and user daily activities;

[0045] It responds to right-click menu operations, including viewing / modifying company contact information, querying complete company certification information, sending emails, adding / modifying / viewing related files, and querying product information.

[0046] Compared with the prior art, the beneficial effects of the present invention are:

[0047] 1. In this invention, the Medical Information Collaborative Management and Data Analysis System (MACM) effectively integrates multi-source data from UDI, medical insurance, drug regulatory authorities, and HIS billing through a layered architecture and multi-module design. The data center layer relies on MySQL to construct comprehensive data tables covering data from drug regulatory authorities (registration certificate details, UDI identifiers, etc.), medical insurance (classification and codes, transparent platform directory, etc.), and hospital-wide data (HIS billing directory, departmental information, etc.). The business logic layer achieves data interaction through database operations, data acquisition, and other modules. The user interface layer's third-party situational awareness module links data from multiple systems (such as SPD monitoring and price monitoring), eliminating cross-departmental data barriers. Simultaneously, the system supports importing and exporting data in Excel, XML, and other formats, as well as automated conversion, reducing manual processing, improving data collaboration efficiency, and solving the problems of data isolation and inefficient integration in traditional systems.

[0048] 2. In this invention, the system possesses a wealth of automated tools, significantly enhancing its level of intelligence. The one-click management tool module can automatically generate forms such as supplier change request forms, complete data preprocessing such as Excel merging and string formatting, and convert XML to Excel; the general function modules of the multi-platform collaborative management subroutine support automated operations such as Excel categorization and summarization, file merging, and enhanced VLOOKUP functionality. These tools replace a large amount of repetitive manual work, reduce human error rates, and accelerate data processing speed. For example, the data preprocessing module can quickly correlate and match multi-source data, and the interactive design of the user interface layer simplifies the operation process, greatly improving management efficiency and solving the problems of traditional systems relying on manual labor and being inefficient.

[0049] 3. In this invention, the system achieves multi-dimensional in-depth analysis through an intelligent analysis module to meet the needs of refined decision-making. The disease-specific consumption ratio calculation submodule predicts the annual consumption ratio based on DRG data and historical consumption correlation analysis, combined with indicators such as DRG profit and loss and hospital budget; the standardized consumption analysis model calculates multi-dimensional thresholds (such as median usage, coefficient of variation, etc.) based on real data to achieve standardized assessment of disease-specific consumption; the department cost allocation submodule dynamically allocates costs according to departmental income and expenditure; the alliance procurement optimization submodule generates recommended solutions by combining historical data and supplier evaluations. In addition, the adverse event optimization submodule achieves full-dimensional traceability, and the multi-module collaboration covers disease, department, procurement and other scenarios, solving the problem that traditional technical analysis has a single dimension and is difficult to support refined decision-making. Attached Figure Description

[0050] Figure 1 This is a schematic diagram of the system architecture of the medical information collaborative management and data analysis system of the present invention;

[0051] Figure 2 This is a schematic diagram of the C / S mode of the medical information collaborative management and data analysis system of the present invention;

[0052] Figure 3 This is a schematic diagram of the standardized consumption analysis model in the medical information collaborative management and data analysis system of the present invention;

[0053] Figure 4 This is a schematic diagram of the consumption ratio calculation model in the medical information collaborative management and data analysis system of the present invention;

[0054] Figure 5 This is the main program user interface of the medical information collaborative management and data analysis system of the present invention;

[0055] Figure 6 This invention provides a multi-platform collaborative management interface for the medical information collaborative management and data analysis system.

[0056] Figure 7This is the interface of the standardized consumption analysis model in the medical information collaborative management and data analysis system of the present invention;

[0057] Figure 8 This is the interface of the consumption ratio calculation model in the medical information collaborative management and data analysis system of the present invention;

[0058] Figure 9 This is the interface of the department cost allocation model in the medical information collaborative management and data analysis system of the present invention. Detailed Implementation

[0059] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0060] Example 1: The Medical Information Collaborative Management and Data Analysis System (MACM) adopts a layered architecture: Data Center Layer (DC), Business Logic Layer (BL), and User Interface Layer (UI), conforming to the principle of "high cohesion and low coupling," as follows: Figure 1 .

[0061] By adopting a client / server (C / S) model, applications and services are separated, resulting in better stability and flexibility, and meeting the requirements of "security and high efficiency," such as... Figure 2 .

[0062] Data center layer: mainly built on MySQL, containing the following core data tables (see system configuration below for details).

[0063] Business logic layer: mainly provides intermediate processing functions, including the following core modules: database operations, file I / O operations, search engine, data collection, general API, etc.

[0064] User Interface Layer: Primarily provides user interaction functionality, and includes the following core modules:

[0065] (I) Basic catalog management module: Standardized management of information such as medical supplies classification, suppliers and departments.

[0066] (II) Third-party situational awareness module:

[0067] SPD monitoring: Real-time tracking of SPD material "identity" information, inventory and consumption status;

[0068] UDI / Medical Insurance / Drug Regulatory Classification Monitoring: Dynamically matches regulatory data and triggers early warnings;

[0069] Price monitoring: Linking the HIS billing catalog with procurement prices reduces billing error rates and optimizes costs.

[0070] (III) One-click management tool module:

[0071] Automated generation of management forms such as supplier change request forms and replacement request forms;

[0072] Data preprocessing (such as Excel merging, subtotaling, string formatting, data association, etc.);

[0073] XML to Excel conversion tool.

[0074] (iv) Intelligent Analysis Module:

[0075] Disease-specific consumption ratio calculation: based on DRG data and historical consumption correlation analysis;

[0076] Departmental cost allocation: Costs are dynamically allocated based on departmental revenue and expenditure data;

[0077] Alliance Procurement Optimization: Generate recommended solutions by combining historical procurement data with supplier evaluations.

[0078] Adverse event optimization: Enable full-dimensional adverse event tracing and analysis.

[0079] Among them, standardized consumption analysis models, such as Figure 7 Based on a MySQL database and real historical data from the hospital, statistical analysis methods are used to calculate standardized consumption thresholds (including usage probability, minimum consumption, maximum consumption, median consumption, upper quartile of consumption, lower quartile of consumption, IQR of consumption, coefficient of variation of consumption CV, etc.). The specific analysis process is as follows: Figure 3 .

[0080] Consumption ratio calculation model, such as Figure 8 Based on a MySQL database and indicators such as DRG profitability, hospital budget, and core technology implementation, the annual cost-to-consumption ratio is predicted. The specific calculation process is as follows: Figure 4 .

[0081] (v) Interaction and Log Module: Supports enterprise-side interaction and full operation log traceability.

[0082] Example 2: Medical Information Collaborative Management and Data Analysis System (MACM), whose basic support components are system configuration and system installation.

[0083] System configuration includes the following steps:

[0084] (1) Install the 32-bit runtime library for Visual C++.

[0085] vcredist.exe is Microsoft's 32-bit Visual C++ runtime library, containing several Visual C++ library functions. The Windows operating system installation packages are as follows: 32-bit operating system installer VC_redist.x86.exe and 64-bit operating system installer VC_redist.x64.exe.

[0086] (2) Install MySQL database management tools.

[0087] MySQL Installer Community is an official tool provided by MySQL for installing and managing MySQL databases. It's an integrated installer that helps users quickly and easily install and configure MySQL databases, and provides a suite of tools for managing and maintaining the database.

[0088] The Windows operating system installation packages are as follows: 32-bit operating system installation package mysql-installer-community-5.7.29.0 (supports Win32-bit).msi and 64-bit operating system installation package mysql-installer-community-8.0.20.0 (supports Win64-bit).msi.

[0089] (3) Install the MySQL database.

[0090] MySQL is a relational database, a typical client / server (C / S) architecture application. The MySQL Server program (MySqld) provides database services, handling client requests and responses. The client is responsible for connecting to the database server and providing command-line operations.

[0091] MySQL supports many storage engines, but the three most commonly used are:

[0092] MyISAM extends the ISAM storage engine. It is one of the most commonly used storage engines in web, data warehousing, and other application environments. MyISAM offers high insertion and query speeds but does not support transactions. MyISAM supports table locks but not row locks, so it is less efficient when handling high-concurrency write operations. Additionally, MyISAM does not support foreign keys (although foreign keys are now rarely used in practical projects).

[0093] InnoDB (default) is the default storage engine option for MySQL, providing transaction-safe tables (ACID), row locking, and foreign keys. It boasts robust transaction safety (ACID compliant) capabilities with commit, rollback, and crash recovery, enabling high-performance applications that support massive amounts of data.

[0094] Memory is similar to Redis, storing data in memory primarily to provide fast operations.

[0095] The Windows operating system installation packages are as follows: 32-bit operating system installation package mysql-connector-odbc-8.0.27-win32.msi and 64-bit operating system installation package mysql-connector-odbc-8.0.27-winx64.msi.

[0096] (4) Install Navicat database management tool.

[0097] Navicat is a database management tool that allows you to create multiple connections for easy management of various databases, including MySQL, Redis, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB, and MongoDB. It is compatible with GaussDB, OceanBase, and cloud databases such as Alibaba Cloud, Tencent Cloud, Huawei Cloud, Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, and MongoDB Atlas. It's used for creating, managing, and maintaining databases. Navicat's functionality is sufficient for all the needs of professional developers, yet it's simple and easy to use for database server beginners. Navicat's user interface (GUI) is well-designed, providing a secure and simple way to create, organize, access, and share information. The installation package for Windows operating systems is as follows: Navicat for MySQL V11.0.10 portable version.

[0098] (5) Create the plandb database.

[0099] ① Connect to the MySQL database: Open the Navicat tool and connect to the database. Set the connection name (you can customize it, no special requirements), hostname or IP address (the IP address of the host where the MySQL database is located), port (default 3306), username (root), and password (the root password set when installing the database: cgb1201).

[0100] ② Create the plandb database.

[0101] ③ Create data tables: The order of the fields in the data tables should follow the order within the table. Details are as follows:

[0102] I. Configuration Data Tables:

[0103] The logs table is used to store log information generated automatically by the system or by the log management module.

[0104] The users table is used for user information and operation records;

[0105] The rights table is used to store the permission parameters for each user.

[0106] II. Departmental Data Tables:

[0107] The contact table is used to store company information and contact person information.

[0108] The evaluation table is used to store information on company evaluations.

[0109] ICD-10 National Clinical Version 2.0 vs. Medical Insurance Version 2.0 (Diagnosis) Table: Used to store ICD-10 diagnostic information;

[0110] ICD-9 National Clinical Version 3.0 vs. Medical Insurance Version 2.0 (Surgical Procedure) Table: Used to store ICD-9 surgical procedure information;

[0111] Adverse Event Statistics Table: Used to store information related to adverse events;

[0112] The procurement catalog classification table (ksyy) is used to store medical device product classification information (based on the classification published by the State Drug Administration).

[0113] Supplier Matching Directory Table: Used to store basic directory information; the core data table of the MACM system.

[0114] Billing System Master Directory: Used to store HIS billing directory information;

[0115] Department Matching Directory: Used to store information on all departments in the hospital;

[0116] Ledger Data Management Form: Used to store ledger data information;

[0117] Barcode Information Table: Used to store catalog information of third-party (SPD) systems;

[0118] File inventory management directory table: used to store file-related information;

[0119] Material Information Table: Used to store the registration certificate information corresponding to the 'Material Code' field in the "Supplier Matching Directory" data table;

[0120] Hospital Administrative Affairs Process Chart: Used to store a list of hospital administrative affairs processes;

[0121] Government Procurement Item Classification Catalog: Used to store government procurement item classification catalog information;

[0122] Key Variety Monitoring Catalog: Used to store catalog information of key varieties;

[0123] III. Drug Regulatory Data Sheet:

[0124] Registration Certificate Details Table: Used to store detailed information about the registration certificate;

[0125] UDI Packaging Identification Information Table: Used to store UDI packaging identification information to support UDI module functionality;

[0126] UDI Identifier Information Table: Used to store UDI identifier information to support UDI module functionality;

[0127] UDI storage or operation information table: Used to store UDI storage or operation information to support UDI module functions;

[0128] UDI Clinical Usage Size Information Table: Used to store UDI clinical usage size information to support UDI module functionality;

[0129] UDI Enterprise Contact Information Table: Used to store UDI enterprise contact information to support UDI module functions;

[0130] IV. Medical Insurance Data Sheet:

[0131] Sunshine Platform System Master Catalog: Used to store product system catalog information published within the Sunshine Procurement Platform;

[0132] Medical Insurance Catalog: Used to store information on medical consumables covered by medical insurance;

[0133] The Sunshine Platform Historical Orders Table: Used to store historical orders from hospitals on the Sunshine Procurement Platform;

[0134] Emergency Procurement Master Catalog on the Sunshine Platform: This catalog stores emergency procurement information published on the Sunshine Procurement Platform.

[0135] The Sunshine Platform Master Catalog: This catalog stores the regular procurement catalog information published within the Sunshine Procurement Platform.

[0136] Classification and Code Table of In Vitro Diagnostic Reagents Covered by Medical Insurance: This table stores the classification and code information of in vitro diagnostic reagents covered by medical insurance published by the National Healthcare Security Administration.

[0137] Medical Insurance Consumables Classification and Code Table: Used to store the medical insurance consumables classification and code information published by the National Healthcare Security Administration;

[0138] System installation includes the following steps:

[0139] (1) Install the MedAppCertManage.exe application.

[0140] The MedAppCertManage toolkit is the runtime toolkit for the MACM main program. It provides the main functions of the MACM main program. Store the MedAppCertManage toolkit in a specified folder, such as D:\Program Files\MACM\.

[0141] (2) Install the MedAppCertManageUpdate.exe application.

[0142] The MACM system upgrade toolkit and the MedAppCertManageUpdate toolkit are responsible for providing update and upgrade functions for the MACM system. Store the toolkit in a specified folder, such as D:\Program Files\MACM\.

[0143] (3) Install the HTMLAutoService.exe application.

[0144] The MACM system HTML page processing toolkit, specifically the HTMLAutoService toolkit, provides backend HTML processing functionality for the MACM system. Store the toolkit in a specified folder, such as D:\Program Files\MACM\.

[0145] (4) Install the jmail.dll dynamic library.

[0146] jmail.dll is an open-source dynamic library that provides email service functionality for the MACM system. The toolkit should be placed in a specified folder, such as D:\Program Files\MACM\.

[0147] (5) Install the MACMHelpTool.xls application.

[0148] The MACMHelpTool toolkit is a utility package for the MACM subroutines. It provides the main functionalities of the MACM subroutines and should be stored in a specified folder, such as D:\Program Files\MACM\.

[0149] (6) Install the cfg.ini configuration file.

[0150] cfg.ini is the configuration file for the MACM system, where key user settings are stored. Below is a configuration template:

[0151] [CERTTABLE]

[0152] table1 = t1

[0153] table2 = t2

[0154] table3 = t3

[0155] table4 = t4

[0156] table5 = t5

[0157] table6 = t6

[0158] table7 = t7

[0159] table8 = t8

[0160] table9 = t9

[0161] table10 = t10

[0162] table11 = t11

[0163] table12 = t12

[0164] table13 = t13

[0165] table14 = t14

[0166] table15 = t15

[0167] table16 = t16

[0168] table17 = t17

[0169] table18 = t18

[0170] table19 = t19

[0171] table20 = t20

[0172] table21=t21

[0173] table22 = t22-25 heart table23 = t26-29 transformation

[0174] [PATH]

[0175] syspath = \\192.1.11.14\MedAppCertManageDataBase\sys_macm exportpath = D:\Plans\High-Value Procurement Plans\Weekly Plan Template Temporary Folder\[FOLDER]

[0176] certfolder = cert_tmp

[0177] emailfolder =

[0178] updatefolder = update

[0179] [EMAIL]

[0180] mailpwd=hr{cvzmnkzpqdbic

[0181] mailsmtp = smtp.qq.com

[0182] mailaddr = 67590140@qq.com

[0183] [SYSFILE]

[0184] certfile = Medical Device Three Certificates (New).xls

[0185] contactfile=Supplier Contacts.xls

[0186] logfile = log.xls

[0187] plandb = PlanDB.xls

[0188] plandb2 = PlanDB2.xls

[0189] plandb3 = PlanDB3.xls

[0190] planfile = MACMHelpTool.xls

[0191] [MySQL]

[0192] server=192.1.11.14

[0193] [URL]

[0194] url=http: / / app1.sfda.gov.cn / datasearchcnda / face3 / base.jsp

[0195] [CACHE]

[0196] cache=on

[0197] [LOGIN]

[0198] user=7430

[0199] Save the cfg.ini configuration file to the specified folder, such as D:\Program Files\MACM\.

[0200] (7) Install the tmpdb.ini configuration file.

[0201] tmpdb.ini is the configuration file for the MACM system. User path selection records are stored here. Below is a configuration template:

[0202] [tmpfilepath]

[0203] tfp1 = C:\Users\Administrator\Downloads\Temporary Downloads Folder\

[0204] tfp2 = C:\Users\Administrator\Desktop\Registration Certificate Collection 20240817\Registration Certificate 20240817\

[0205] tfp3=C:\Users\Administrator\Desktop\

[0206] tfp4=C:\Users\Administrator\Downloads\

[0207] tfp5 = D:\Work Documents\Procurement and Supply Department\Monthly Work Arrangement\SPD-Provincial Platform Data\

[0208] tfp6 = C:\Users\Administrator\Desktop\Ledger Materials\Ledger Materials\Logistics Supplies Details\2024\

[0209] Save the tmpdb.ini configuration file to the specified folder, such as D:\Program Files\MACM\

[0210] Example 3: Medical Information Collaborative Management and Data Analysis System (MACM). The user double-clicks MedAppCertManage.exe to run the system, and the user interface opens, as shown below. Figure 5 The user process is as follows:

[0211] (1) Attribute settings:

[0212] ① First, install JMail45.msi. This software is a key module for ensuring the email system. If you do not need the email function, you can skip installing it.

[0213] ② Run MedAppCertManage.exe and set the relevant property values ​​as follows:

[0214] Select the configured server folder for "System Data Directory" (refer to the System Manual: System Data Configuration (Excel) section);

[0215] The “Expiration Time” setting is used to set the baseline time for detecting whether the three certificates have expired;

[0216] The "Official Website of the State Drug Administration" provides a URL for quick access to the State Drug Administration's website;

[0217] The "Email" setting is used to set the email address for sending emails;

[0218] "Password" sets the access password for your email account;

[0219] The "SMTP server" setting specifies the SMTP mail server for the corresponding email address.

[0220] (2) Management of Medical Device Certificates:

[0221] ① After entering the attribute settings module;

[0222] ② After setting the data, click the "Finish" button. The system will then begin initialization and load the three certificates information.

[0223] In the "Supplier" field, enter the name of the supplier you want to query; you can enter only part of the name.

[0224] Enter the registration certificate number you want to query or other information related to the registration certificate, such as the product name on the registration certificate, in the "Registration Certificate" field.

[0225] Clicking the "Search" button allows you to retrieve the desired data and input it into the "Results Information" field.

[0226] When the original data file of the three medical certificates changes, you need to click the "Reload" button to reload the original data.

[0227] Click the "Settings" button. For instructions on how to use it, refer to the property settings.

[0228] (3) Email Management: Click the "Email" button to enter the email system module;

[0229] "Data Source": Select the data source for the email from the query results of the Three Certificates Management System, or a custom data source;

[0230] After selecting the data source, click the "Import" button and set the email title and body information in the import interface;

[0231] Once the data import is complete, click the 'Send' button to send the three certificates data.

[0232] (4) Log Management:

[0233] ① Click the "Log Management" button to enter the log system module. This module can query and record the sending records of the email system, and users can also use it to record and query daily tasks.

[0234] ② Right-click on the record found in the Medical Device Three Certificates Information Management module to bring up a menu;

[0235] Clicking "View (Edit) Business Card" allows you to add relevant contact information for your business;

[0236] Click "Query Full Information" to view the company's complete three certificates information;

[0237] Clicking "Send Email" will automatically take you to the email module and generate the email to be sent.

[0238] Clicking "Add / Modify File" allows you to add associated files for this piece of information regarding the three certificates;

[0239] Click "View File" to open the associated file.

[0240] Click "View Product Information" to view the product information corresponding to the registration certificate.

[0241] (5) Acceptance Management: Click the "Acceptance" button to enter the acceptance management module;

[0242] Select the barcode input box, and enter the barcode to query using the keyboard or a barcode scanner;

[0243] Clicking the "Search" button will automatically retrieve the product information corresponding to the barcode, as well as the product's associated registration certificate information and relevant supplier certification information.

[0244] Double-clicking the registration certificate information line will display detailed registration certificate information.

[0245] (6) Enterprise Interaction Management: Click the “Enterprise Interaction Management” button to query, add, modify and delete enterprise contact information, and also send emails to enterprise contacts within this interface.

[0246] (7) Multi-platform collaborative management: Click the “Multi-platform collaborative management” button to enter the MACM subroutine.

[0247] The MACM subroutine (Weekly Plan Print Template / MACMHelpTool) is an auxiliary tool for the HERP logistics management system. It provides three main functions: purchase order management, clinical plan management, and warehouse inventory management. It can simplify the work of purchase order, plan issuance, and warehouse inventory, improve related workflows, and further improve work efficiency.

[0248] Double-click the "Multi-Platform Collaboration Management Subroutine" user interface to open it, as shown below. Figure 6 ;

[0249] (1) HERP function:

[0250] I. Prepare the weekly plan file: Prepare the original data file for the weekly plan, xxxweekplan.xls. The worksheet name must be "Headquarters". In the worksheet, a yellow background indicates no inventory or other abnormal situations, and materials cannot be sent out temporarily; a colorless background indicates that materials can be produced according to the production plan and can be sent out normally; a gray background indicates that a production plan has been produced and a delivery order has been issued, and the accurate number of the delivery completed in HERP is entered in the quantity column; the actual quantity sent can be entered in the actual quantity column, which cannot exceed the data in the quantity column.

[0251] II. Click the "Weekly Plan Print Template" button, set the relevant attribute values. The weekly plan print template file contains a total of seven worksheets: print template, planned outbound order, configuration file, label template, weekly plan query results, plan summary, and plan.

[0252] The print template is the original outbound slip print template and generally does not require modification;

[0253] The planned outbound order is the weekly planned outbound order for the last production week, and it can be printed directly.

[0254] Configuration files contain the program's standard configuration information and can be modified.

[0255] The label template is the template required for printing warehouse location labels and generally does not need to be modified.

[0256] The weekly plan query result is an output worksheet containing information related to the weekly plan.

[0257] The plan summary is an output worksheet that summarizes the clinical weekly plans.

[0258] The plan is a temporary worksheet for storing weekly plans and does not require modification.

[0259] III. Click the "Weekly Plan Preprocessing" button. The main function of this module is to detect the inventory data of materials and set the status information of the material rows in the weekly plan file according to the inventory situation.

[0260] The inventory file selects the inventory data exported from the HERP system, the weekly plan file selects the weekly plan Excel file that needs to be preprocessed, and the unconfirmed transfer (out) file selects the data that has been transferred or out but has not been confirmed. If you select to sort by warehouse location, the weekly plan file will be sorted by warehouse location classification number.

[0261] IV. After selecting the weekly plan file, click the "Weekly Plan Summary" button. The system will automatically summarize the material data in the weekly plan based on the PlanDB system data, generating material procurement data for different suppliers to assist in the weekly plan procurement. Finally, the data will be generated in the plan summary worksheet.

[0262] V. Select the weekly plan date, select the weekly plan file, and click the "Generate Weekly Plan Print Template" button. The system will generate the weekly plan outbound order based on the original data in the weekly plan file, and the data will be generated in the plan outbound order worksheet.

[0263] Weekly Plan Dates: Select the dates from the actual dates in the weekly plan document;

[0264] Weekly plan file: Select a weekly plan Excel file for a specific week;

[0265] Department Name: To print the weekly plan for a specific department, enter the exact department name; to print the weekly plans for all departments, you do not need to enter the name. Department names can be abbreviated (e.g., for the Neurosurgery Nursing Unit, enter Neurosurgery).

[0266] VI. Click the "Weekly Plan Inquiry" button. The main function of this module is to search for data in the weekly plan file based on the query conditions. For example, you can get the status of a certain material in previous weekly plans.

[0267] VII. Warehouse Inventory Management Module: Click the 'Inventory Preprocessing' button. This module mainly completes the preprocessing of inventory data, formats the inventory data, and improves inventory efficiency.

[0268] VIII. Storage Location Label Printing Module: Click the "Storage Location Label Printing" button. This module mainly generates storage location labels.

[0269] IX. Warehouse Plan Template Export Module: Click the "Export Warehouse Plan Template" button. This module mainly generates a warehouse plan template file. Warehouse staff and purchasing staff use this template file to formulate purchasing plans to achieve a unified standard.

[0270] (2) SPD / Sunshine Platform Functions:

[0271] I. Purchase Order Management Module: This module mainly includes two functions: first, purchase order preprocessing (click the "Purchase Order Preprocessing" button); second, automated uploading of purchase orders to the bidding website (click the "HTML Automation" button).

[0272] II. SPD Specification Import Form Generation Module: This module primarily provides the ability to format Excel files into files that conform to the SPD specification import standard. Click the "SPD Specification Import Form Generation" button.

[0273] III. Online Procurement Rate Analysis Module: This module primarily analyzes the differences between the hospital's full data and the full data from the Sunshine Platform based on the "three unifications" rule and outputs the analysis results for online procurement rate difference analysis. Click the "Online Procurement Rate Analysis" button.

[0274] IV. Alliance Procurement Management Module: This module primarily provides batch information management, completion progress monitoring, and analysis for alliance procurement. Click the "Alliance Procurement" button.

[0275] (3) General functions:

[0276] I. Categorization Function Module: This module primarily separates the row data in an Excel file according to different categorization fields (column names) and saves them to different Excel files or different worksheets within the same Excel file for data post-processing and analysis. Click the "Categorized Output" button.

[0277] II. Summary Function Module: This module mainly summarizes and calculates the row data in the Excel file according to different category fields (column names) and saves it to a new Excel file for data post-processing and analysis. Click the "Subtotal" button.

[0278] III. Merge Files Module: This module merges row data from multiple Excel files and saves it to a new Excel file for post-processing and analysis. Click the "Merge Multiple Files" button.

[0279] IV. String Formatting Function Module: This module primarily replaces existing delimiters in the source string with new delimiters. It is used for processing multiple query conditions within the Material Reference Information module or other scenarios requiring this type of data. Click the "Delimit String" button.

[0280] V. VLOOKUP PLUS (XLS) Function Module: This module simplifies and enhances the built-in VLOOKUP function in Excel to support the output of multiple query results. Click the "VLOOKUP PLUS (XLS)" button.

[0281] VI. VLOOKUP PLUS (DB) Function Module: This module is primarily based on a database, simplifying and enhancing the functionality of Excel's built-in VLOOKUP function to support the output of multiple query results and handle massive amounts of data. Click the "VLOOKUPPLUS (DB)" button.

[0282] VII. XML File Conversion Module: This module primarily parses XML files and converts them into Excel files for data post-processing and analysis. Click the "XML To Excel" button.

[0283] VIII. Batch Page Print Format Setting Module: This module primarily uses the print format settings parameters of a template Excel file to batch set the print format settings parameters of target Excel files, thereby improving file processing efficiency. Click the "Page Print Format Setting" button.

[0284] (4) Collaborative management main function;

[0285] I. Material Reference Information Management Module: This module primarily manages medical consumable catalog information, registration certificate information, UDI, instructions for use, adverse events, third-party situational awareness, and abnormal information alerts, providing comprehensive management of medical consumables within the hospital. Click the "Material Reference Information" button.

[0286] II. Data Preprocessing Module: This module primarily adds necessary new data columns to the source Excel file based on key fields (column names) for data preprocessing and analysis. Click the "Data Extraction and Preprocessing" button.

[0287] III. Supplier Change Management Module: This module primarily generates supplier change application forms automatically for supplier change management and supplier evaluation. Click the "Data Extraction and Preprocessing" button.

[0288] IV. Ledger Directory and File Module: This module mainly manages the ledger directory and files, and establishes connections between the ledger directory and files for paperless ledger management, as well as for managing daily work documents. Click the "Ledger Data Management" button.

[0289] V. Business Data Management Module: This module primarily manages business-related data (consumption ratio, key monitored products, DRG, etc.) and provides analytical data for key indicators, used for departmental assessment and control in medical consumables management. Click the "Business Reference Information" button.

[0290] VI. File Management System Module: This module primarily manages the MACM system and files, requiring administrator-level privileges. Click the "File Management System" button.

[0291] VII. User Permission Management Module: This module primarily manages user permissions within the MACM system and requires administrator-level privileges. Click the "User Permission Management" button.

[0292] VIII. Project Management Module: This module is mainly used for the application of project results (including consumption ratio calculation, standardized consumption analysis, and departmental cost allocation). Click the "Project Management" button to access the standardized consumption analysis model ( Figure 7 ), consumption ratio calculation model ( Figure 8 ) and departmental cost-sharing model ( Figure 9 It is located in this module.

[0293] Data processing steps: The business logic layer processes the data generated by user interactions, including database operations, file I / O operations, and data acquisition.

[0294] Data storage steps: The processed data is stored in the corresponding data table through the data center layer.

[0295] The various buttons mentioned in the article are virtual buttons that exist within the system interface. The attached images only show a portion of the interface and virtual buttons.

[0296] Example 4: Data updates in the Medical Information Collaborative Management and Data Analysis System (MACM) are to ensure that other functional modules in the MACM system can obtain accurate and real-time data, thereby guaranteeing the normal operation of each module. Currently, data updates mainly include: supplier matching directory, company contact information, billing system master directory, registration certificate details, barcode information table (specification and model details), UDI information, medical insurance medical consumables classification and codes (consumables + reagents), historical orders from the Sunshine Platform, and the Sunshine Platform master directory, etc. The interface access path is: Multi-Platform Collaborative Management (MACM main program interface) - Material Reference Information (MACM sub-program interface) - Update Directory (MACM sub-program interface).

[0297] (1) Supplier matching directory:

[0298] Ⅰ. Log in to the Hospital Integrated Operation Management System (HERP), go to Information Maintenance - Basic Information - Materials module, query and obtain the materials catalog information, and export it as an Excel file;

[0299] II. Click the "Add" button under "plandb: Supplier Matching Directory", select the Excel file exported in the previous step, and then click the "Update" button under "plandb: Supplier Matching Directory" to import the information in the Excel file into the MACM system.

[0300] (2) Company contact information:

[0301] Ⅰ. Businesses upload their contact information by scanning a QR code;

[0302] II. Export the collected company contact information as an Excel file.

[0303] III. Click the "Add" button under "plandb:contact (Company Contact Information)", select the Excel file exported in the previous step, and then click the "Update" button under "plandb:contact (Company Contact Information)" to import the information from the Excel file into the MACM system.

[0304] (3) Billing System Master Catalog:

[0305] Ⅰ. Log in to the Smart Medical Consumables Management Software (SPD) via the Chrome browser;

[0306] II. Click the icon in the upper right corner of the browser to bring up a dialog box;

[0307] III. Click the "Get Old HIS Billing Catalog" button in the dialog box, wait about 30 seconds, and the download of the HIS billing catalog will be completed automatically. The file name is hisitems.xlsx.

[0308] IV. Click the "Add" button under "plandb: Billing System Main Directory", select the Excel file exported in the previous step, and then click the "Update" button under "plandb: Billing System Main Directory" to import the information from the Excel file into the MACM system.

[0309] (4) Registration Certificate Details:

[0310] 1. Log in to the data query module of the National Medical Products Administration through the Chrome browser;

[0311] II. Select different registration certificate categories (multiple selections are limited to three, but it is generally recommended to select two);

[0312] III. Enter the registration certificate information, obtain the query results, and click the "Details" button to bring up the registration certificate details page;

[0313] IV. Select the registration certificate details page, click the icon in the upper right corner of the browser, and a dialog box will pop up;

[0314] V. Click the "Query and Export" button in the dialog box, wait about 5 seconds, and the registration certificate details will be downloaded automatically. The file name is: CFDA-detail1.xlsx;

[0315] VI. Click the "Add" button under "plandb: Registration Certificate Details", select the Excel file exported in the previous step, and then click the "Update" button under "plandb: Registration Certificate Details" to import the information from the Excel file into the MACM system.

[0316] (5) Barcode information (specification details):

[0317] Ⅰ. Log in to the Smart Medical Consumables Management Software (SPD) via the Chrome browser and go to the Basic Information - Product Management - Product Specifications module;

[0318] II. Click the "Advanced Search" button. In the pop-up search criteria dialog box, select "All" for the status and click the "Search" button.

[0319] III. Click the "Export Specifications" button, wait 5 minutes, then click "Home". Find the exported specification details in the notification messages and click the notification message line to export the Excel file.

[0320] IV. Click the "Add" button under "plandb: Barcode Information (Specifications and Model Details)", select the Excel file exported in the previous step, and then click the "Update" button under "plandb: Barcode Information (Specifications and Model Details)" to import the information from the Excel file into the MACM system.

[0321] (6) UDI Information: Log in to the Medical Device Unique Identifier Integration Service via the Chrome browser. Updates are available daily, weekly, and full.

[0322] (7) Classification and Codes of Medical Consumables Covered by Medical Insurance:

[0323] Medical consumables:

[0324] 1. Log in to the National Medical Insurance Information Business Coding Standard Database using the Chrome browser;

[0325] II. Enter "C" in the "Medical Consumables Code" field and click "Search" to obtain the latest published medical consumables categories and codes. The number of items displayed per page has been adjusted to 100 to reduce the total number of pages.

[0326] Ⅲ. Click the icon in the upper right corner of the browser to bring up a dialog box. Enter 600 in the "Save Base" field and 5000 in the "Interval Query Time" field, and then click "Export Details".

[0327] IV. Due to the limited query interval of the National Medical Insurance Information Business Coding Standard Database, the specific completion progress is subject to the progress bar in the figure. An Excel file will be exported upon completion.

[0328] V. Open the Excel file exported in the previous step. In the cells of the "Operation" column, enter the formula row by row: "="Level 3"&MID($B2,1,7)&"-"&"Common Name"&MID($B2,8,3)&"-"&"Material"&MID($B2,11,2)&"-"&"Specifications"&MID($B2,13,3)". In the cells of the newly added "National Database Version" column, enter the release date row by row, in the format yyyy-mm-dd.

[0329] VI. Click the "Add" button under "plandb: Barcode Information (Specifications and Model Details)", select the Excel file exported in III, select "Medical Consumables" from the drop-down menu, check "Clear Database", and then click the "Update" button under "plandb: Barcode Information (Specifications and Model Details)" to import the information from the Excel file into the MACM system.

[0330] In vitro diagnostic reagents:

[0331] 1. Log in to the National Medical Insurance Information Business Coding Standard Database using the Chrome browser;

[0332] II. Find the latest updated link to the medical insurance in vitro diagnostic reagent classification and code database;

[0333] III. Clicking the link will open a new page, with the number of pages displayed per page adjusted to 100 to reduce the total number of pages and close other pages;

[0334] IV. Click the icon in the upper right corner of the browser. A dialog box will pop up. Enter 600 in the "Save Base" field and 5000 in the "Interval Query Time" field. Then click "Export Details".

[0335] V. Due to the limited query interval of the National Medical Insurance Information Business Coding Standard Database, the specific completion progress is subject to the progress bar in the figure. After completion, an Excel file will be exported.

[0336] VI. Open the Excel file exported from IV. In the cells of the "Operation" column, enter the formula row by row: "="Level 3"&MID($B2,1,7)&"-"&"Detection Category"&MID($B2,8,2)&"-"&"Detection Indicator"&MID($B2,10,3)&"-"&"Application Method"&MID($B2,13,1)&"-"&"Detection Type"&MID($B2,14,1)". In the newly added "National Database Version" column, enter the release date row by row, in the format yyyy-mm-dd;

[0337] VII. Click the "Add" button under "plandb: Barcode Information (Specifications and Model Details)", select the Excel file exported from IV, select "In Vitro Diagnostic Reagents" from the drop-down menu, check "Clear Database", and then click the "Update" button under "plandb: Barcode Information (Specifications and Model Details)" to import the information from the Excel file into the MACM system.

[0338] (8) Historical orders on the Sunshine Platform:

[0339] Ⅰ. Log in to the Drug (Consumables) Sunshine Procurement Platform through the Chrome browser.

[0340] II. Export monthly historical order Excel files from the historical order query module of the Sunshine Procurement Platform.

[0341] III. Click the "Add" button under "plandb: Sunshine Platform Historical Orders", select the Excel file exported in the previous step, and then click the "Update" button under "plandb: Sunshine Platform Historical Orders" to import the information from the Excel file into the MACM system.

[0342] (9) Sunshine Platform Master Directory:

[0343] Regular online listings:

[0344] Ⅰ. Log in to the Medical Security Bureau's online service hall through the Chrome browser, and go to the Drug and Medical Consumables Procurement Management System - Consumables Transaction - Hospital Catalog Management - Online Catalog Inquiry;

[0345] II. Click the "Export" button to export the general online directory as an Excel file;

[0346] Ⅲ. Open the Excel file exported in the previous step and convert the "listing price (yuan)" into a numerical value;

[0347] IV. Click the "Add" button under "plandb: Sunshine Platform Main Directory", select the Excel file exported in the previous step, select "Regular Online Directory" from the drop-down menu, check "Clear Database", and then click the "Update" button under "plandb: Sunshine Platform Main Directory" to import the information of the Excel file into the MACM system.

[0348] Emergency online directory:

[0349] Ⅰ. Log in to the Medical Security Bureau's online service hall through the Chrome browser, and go to the Drug and Medical Consumables Procurement Management System - Consumables Transaction - Hospital Catalog Management - Listing of Provinces with Insufficient Quantities (Emergency Procurement);

[0350] II. Click the "Export" button to export the emergency network directory as an Excel file;

[0351] Ⅲ. Open the Excel file exported in the previous step, convert the "Listing Price (Yuan)" into a numerical value, add a "Library Version" column, and enter the release date in the cells of the "Library Version" column row by row, in the format yyyy-mm-dd;

[0352] IV. Click the "Add" button under "plandb: Sunshine Platform Main Directory", select the Excel file exported in the previous step, select "Emergency Network Directory" from the drop-down menu, check "Clear Database", and then click the "Update" button under "plandb: Sunshine Platform Main Directory" to import the information of the Excel file into the MACM system.

[0353] Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art can still modify the technical solutions described in the foregoing embodiments or make equivalent substitutions for some of the technical features. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A medical information collaborative management and data analysis system, characterized in that, The architecture employs a layered design and separates applications and services based on a client / server model. The layered architecture includes: Data center layer: Built on MySQL, it includes configuration data tables, hospital-level data tables, drug supervision data tables, and medical insurance data tables, which are used to store the core data of the system; Business logic layer: Provides intermediate processing functions, including database operations, file I / O operations, search engine, DataCollection, and general API modules; User Interface Layer: Provides user interaction functions, including a basic directory management module, a third-party situational awareness module, a one-click management tool module, an intelligent analysis module, and an interaction and logging module.

2. The medical information collaborative management and data analysis system according to claim 1, characterized in that: The third-party situational awareness module of the user interface layer includes: SPD monitoring submodule: Real-time tracking of SPD material identity information, inventory and consumption status; UDI / Medical Insurance / Drug Regulatory Classification Monitoring Submodule: Dynamically matches regulatory data and triggers early warnings; Price monitoring submodule: Links HIS billing catalog and procurement prices to optimize costs.

3. The medical information collaborative management and data analysis system according to claim 1, characterized in that: The intelligent analysis module of the user interface layer includes: Disease-specific consumption ratio calculation submodule: Based on the correlation analysis between DRG data and historical consumption; Departmental cost allocation submodule: Dynamically allocates costs based on departmental revenue and expenditure data; Alliance Procurement Optimization Submodule: Generates recommended solutions by combining historical procurement data with supplier evaluations; Adverse event optimization submodule: Enables full-dimensional adverse event tracing and analysis.

4. The medical information collaborative management and data analysis system according to claim 3, characterized in that: The intelligent analysis module also includes a standardized consumption analysis model. The model relies on a MySQL database and is based on real historical data from the hospital. It uses statistical analysis to calculate standardized consumption thresholds, which include usage probability, minimum consumption, maximum consumption, median consumption, upper quartile of consumption, lower quartile of consumption, consumption IQR, and consumption CV coefficient of variation.

5. The medical information collaborative management and data analysis system according to claim 3, characterized in that: The intelligent analysis module also includes a consumption ratio calculation model. The model relies on a MySQL database and uses indicators based on DRG profit and loss, hospital budget, and core technologies to predict the annual consumption ratio.

6. A method for collaborative management and data analysis of medical information, characterized in that, The medical information collaborative management and data analysis system according to any one of claims 1-5 includes the following steps: System configuration steps: Install the Visual C++ runtime library, MySQL database and management tools, and Navicat tool; create a plandb database containing preset data tables. System installation steps: Install the main program's runtime toolkit, system upgrade toolkit, system HTML page processing toolkit, open-source dynamic libraries, subroutine usage toolkit, and system configuration files; User interaction steps: Receive user operations through the user interface layer, including attribute settings, medical device three-certificate information management, email management, log management, acceptance management, enterprise interaction management, and multi-platform collaborative management; Data processing steps: The business logic layer processes the data generated by user interactions, including database operations, file I / O operations, and data acquisition. Data storage steps: The processed data is stored in the corresponding data table through the data center layer; Data update steps.

7. The medical information collaborative management and data analysis method according to claim 6, characterized in that: The data update steps include: Export data in Excel format from the hospital's integrated operation and management system, Zhixinlian smart medical consumables management software, the National Medical Products Administration database, the medical insurance database, and the Sunshine Procurement Platform; By adding and updating data, the Excel format data is imported into the corresponding data table in the system, enabling updates to the supplier matching directory, company contact information, billing system directory, registration certificate details, UDI information, and data from the Sunshine Platform.

8. The medical information collaborative management and data analysis method according to claim 6, characterized in that, The multi-platform collaborative management includes: The HERP module is used to process weekly plan documents, perform warehouse inventory checks, and print warehouse location labels. The SPD / Sunshine Platform's functional modules can be used to process purchase orders, generate SPD specification import sheets, analyze online procurement rates, and manage alliance procurement. The system utilizes general-purpose functional modules to classify, summarize, merge, format strings, and convert between XML and Excel formats for Excel files. The main collaborative management module manages material reference information, pre-processed data, supplier changes, and ledger data.

9. The medical information collaborative management and data analysis method according to claim 6, characterized in that, The management of the three certificates for medical devices includes: Receive user-input attribute settings parameters, including system data directory, expiration time, drug regulatory authority website address, email information, and SMTP server information; Receive user-input query criteria, including supplier name and registration certificate information, execute the query and return the results; Respond to reload operations and reload data when the original data files for the three certificates change.

10. The medical information collaborative management and data analysis method according to claim 6, characterized in that, The log management includes: Record email system sending records and users' daily tasks; It responds to right-click menu operations, including viewing / modifying company contact information, querying complete company certification information, sending emails, adding / modifying / viewing related files, and querying product information.

Images