Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for quickly positioning plant calendar

A factory and calendar technology, applied in special data processing applications, instruments, electrical and digital data processing, etc., can solve problems such as inability to fully utilize database indexes, poor performance, and complex SQL statement writing, saving computing time, reducing The amount of calculation and the effect of improving work efficiency

Active Publication Date: 2012-11-21
青岛金蝶软件科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The SQL statement is complicated to write, and the database index cannot be fully utilized, resulting in poor performance

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for quickly positioning plant calendar
  • Method and system for quickly positioning plant calendar
  • Method and system for quickly positioning plant calendar

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The embodiment of the present invention provides a method and system for quickly locating the factory calendar, modifying the physical table structure of the factory calendar, adding and updating the data in the fields of the advance working day and the delayed working day, and according to the actual ERP system needs, through SQL in the modified factory In the method provided by the embodiment of the present invention to query the working day in advance or the working day in advance in the calendar table, it is not necessary to use SQL statements for greater or less than judgment and maximum / minimum value operation, which reduces the amount of computation and saves Calculating time and time, improving work efficiency.

[0029] Embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0030] See attached figure 1 , in one embodiment of the present invention, the method for quickly locating the factory calend...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method and a system for rapidly positioning a factory calendar, wherein the method comprises the steps of: modifying the physical table structure of the factory calendar, adding fields of advancing working days and postponing working days; updating the contents of the fields of advancing working days and postponing working days; inquiring the advancing working days or postponing working days corresponding to a special target day from the modified factory calendar; in accordance with the embodiment of the invention, SQL sentences are no longer required to judge the values and take the maximum / minimum when inquiring each time, thus lessening the operation work, saving the operation time and improving the work efficiency.

Description

technical field [0001] The invention relates to the field of enterprise resource planning (ERP, Enterprise Resource Planning), in particular to a method and a system for quickly locating a factory calendar. Background technique [0002] The factory calendar, also known as the production calendar, is a special form of calendar used in the enterprise resource planning (ERP) system. It is formed by removing weekly rest days, holidays, shutdowns and other non-production dates from the ordinary calendar. It is a material One of the bases for MRP (Material Requirement Planning) to plan. [0003] For a certain day, it may be a working day or a non-working day. When the system generates the plan, because the production task cannot be arranged on a non-working day, it must be automatically skipped when it encounters a non-working day, and it will always be advanced or delayed. until the first working day is found. [0004] For non-working days, advancing a working day means skippin...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06Q10/10G06F17/30
Inventor 陈坚
Owner 青岛金蝶软件科技有限公司