A kind of industrial
raw material warehouse full-service big unified
processing method based on table value parameter belongs to industrial MES and
database security technical field.This method will
raw material warehouse, modification, warehouse, move, query and dynamic warehouse position
planar graph synchronization, pound house weight accounting unified encapsulation as
stored procedure, with table value parameter as only entrance, with standard
SQL It is realized that cross-
library compatibility is realized;Through fully closed architecture,
data access is fully controlled and audited;Through dynamic warehouse position engine, warehouse position is automatically updated, and through pound house linkage
algorithm, weight is automatically allocated and state is
closed loop;Full process strong transaction and strong check ensure that
raw material roll, warehouse position, weight, batch data are accurate and consistent.The present application is suitable for hot rolling raw material warehouse management, has
high security level, strong business integrity and outstanding industrial value.The present application has been applied in actual industrial ERP
system, can be long-term stable operation in real production environment, has mature
engineering value and industrialization popularization ability.