Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for acquiring designated workday

A technology for working days and factories, applied in the field of obtaining specified working days, which can solve the problems of complex SQL statements and low work efficiency.

Inactive Publication Date: 2009-03-25
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Obviously, the SQL statement in such a method is complex, and SQL loops are required every time the workday of the specified workday difference is to be queried, and the work efficiency is low.

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 acquiring designated workday
  • Method and system for acquiring designated workday
  • Method and system for acquiring designated workday

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] Embodiments of the present invention provide a method and system for obtaining a designated working day, and the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0044] Before performing the method for obtaining the specified working day provided by the embodiment of the present invention, it is necessary to modify the factory calendar physical table in advance, specifically including:

[0045] 1. Modify the physical table structure of the factory calendar and add a workday sequence field.

[0046] 2. Update the content of the added weekday sequence field.

[0047] The conventional factory calendar physical table is shown in Table 1, including records of sequence number, date, week and whether the day is a working day. In the prior art, to obtain the 13th working day starting from September 4, 2007, that is, to find the working day with a difference of 13 working days from September 4, 2007, the met...

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 for acquiring appointed workdays and a system thereof, wherein the method comprises the following steps: acquiring the difference between an inquired start date and the appointed workdays; according to the acquired start date, determining the workday sequence of the inquired start date from a pre-amended factory calendar; according to the difference between the workday sequence of the inquired start date and the appointed workdays, acquiring workday sequential values of the appointed workdays to be inquired; and according to the acquired workday sequential values of the appointed workdays to be inquired, determining the appointed workdays from the amended factory calendar. Therefore, the method avoids SQL cycling operations carried out when inquiring the workdays which are difference from the appointed workdays each time, optimizes the operation time and improves the working 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 obtaining a designated working day. Background technique [0002] The factory calendar, also known as the production calendar, is a special form of calendar used in the 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 requirements plan (MRP, Material Requirement Planning) is one of the basis for launching the 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 automatically skip it when it encounters a non-working day until it finds a working day that meets the specified Different working days. [0004] Wherein, the specified weekday difference can be a positive diffe...

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
IPC IPC(8): G06Q10/00G06F17/30G06Q10/10
Inventor 王馗
Owner KINGDEE SOFTWARE(CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com