A method and system for the whole life cycle processing of a procurement contract based on multi-table value parameter unified stored procedure and AI protection verification

By adopting three sets of table-valued parameters and a centralized parameter verification mechanism in the MES/ERP system, the problems of fragmented interfaces and data consistency in procurement contract management are solved, achieving efficient, secure, and stable procurement contract processing, supporting AI access, and meeting the needs of industrial intelligence.

CN122132470APending Publication Date: 2026-06-02HANDAN DINGSHENG DIGITAL INTELLIGENCE TECHNOLOGY CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
HANDAN DINGSHENG DIGITAL INTELLIGENCE TECHNOLOGY CO LTD
Filing Date
2026-03-18
Publication Date
2026-06-02

AI Technical Summary

Technical Problem

In the integrated MES/ERP systems of modern industrial manufacturing enterprises, procurement contract management suffers from problems such as fragmented business interfaces, scattered parameter verification, difficulty in ensuring data consistency, poor database compatibility, and difficulty in AI integration. This results in high maintenance costs, poor scalability, and insufficient security, failing to meet the needs of industrial intelligent upgrading.

Method used

It adopts three sets of table-valued parameters (TVP) as a unified data entry point, integrates six core business operations through a single stored procedure, and uses a two-level centralized parameter verification mechanism combined with a transaction mechanism to ensure data consistency. It supports dual database compatibility with SQL Server and GaussDB, and enables secure AI access.

Benefits of technology

It achieves unified interface for procurement contract management, enhanced security protection, high data consistency, and good database compatibility, reduces maintenance costs, supports AI ecosystem access, and is suitable for stable and efficient operation in complex factory scenarios.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

This invention discloses a method and system for processing the entire lifecycle of procurement contracts based on a unified stored procedure with multiple TVPs and AI protection verification, belonging to the field of industrial software MES / ERP technology. This invention uses three sets of table-valued parameters (TVPs) as a unified data entry point, integrating six core operations—adding, modifying, deleting, appending details, modifying details, and deleting details—in a single stored procedure, and returning unified exception information through a single output parameter. The system incorporates a two-level centralized parameter verification mechanism. The first level performs a one-time empty table check on the three sets of TVP tables; if any table is empty, the transaction is immediately rolled back and an exception is returned. The second level performs centralized integrity and legality verification on all business parameters, achieving security protection for AI and external calls, effectively intercepting dirty data and illegal requests. This invention features a simple architecture, high execution efficiency, and comprehensive business coverage. The transaction mechanism ensures strong consistency of master-slave table data, supports compatible operation with both SQL Server and GaussDB databases, and can securely integrate into the AI ​​ecosystem without business restructuring. It is particularly suitable for the high-stability and high-security procurement contract business processing of complex factories with more than 11 production lines. This invention has been fully implemented in a real industrial ERP system and can run stably in a real production environment for a long time, demonstrating mature engineering value and industrial promotion capabilities.
Need to check novelty before this filing date? Find Prior Art