CN111191984A

CN111191984A - Solder paste inventory management method and system

Info

Publication number: CN111191984A
Application number: CN201911358165.5A
Authority: CN
Inventors: 黄常健; 谭信平; 王磊
Original assignee: Shenzhen Zhiwei Intelligent Software Development Co Ltd
Current assignee: Shenzhen Zhiwei Intelligent Software Development Co Ltd
Priority date: 2019-12-25
Filing date: 2019-12-25
Publication date: 2020-05-22

Abstract

The present disclosure provides a solder paste inventory management method, the method comprising the steps of: the electronic equipment receives a production plan with a set time period, and determines a plurality of processes and corresponding production quantity according to the production plan; the electronic equipment extracts m tin pastes related to a plurality of processes, and m using amounts needed by the m tin pastes are determined according to the production amount; the electronic equipment inquires m residual stocks of m solder pastes in the stock, and if the m residual stocks are lower than the corresponding m using amounts, sends a solder paste purchasing list to a purchasing system. The technical scheme provided by the application has the advantage of low cost.

Description

Solder paste inventory management method and system

Technical Field

The invention relates to the technical field of information, in particular to a method and a system for managing solder paste inventory.

Background

Solder paste, also called solder paste, gray or grey white paste, with a specific gravity of 7.2-8.5, is a novel soldering material. Compared with the traditional soldering paste, the soldering paste has more metal components. The paste is stored at a low temperature of zero to ten degrees (the best temperature is five to seven degrees), and the solder paste is also stored at a normal temperature in the market at present.

The existing solder paste is manually managed in inventory management, and the cost is high.

Disclosure of Invention

The embodiment of the invention provides a solder paste inventory management method and a related product, which can automatically manage solder paste inventory, reduce labor cost and have the advantage of low cost.

In a first aspect, an embodiment of the present invention provides a solder paste inventory management method, where the method includes the following steps:

the electronic equipment receives a production plan with a set time period, and determines a plurality of processes and corresponding production quantity according to the production plan;

the electronic equipment extracts m tin pastes related to a plurality of processes, and m using amounts needed by the m tin pastes are determined according to the production amount;

the electronic equipment inquires m residual stocks of m solder pastes in the stock, and if the m residual stocks are lower than the corresponding m using amounts, sends a solder paste purchasing list to a purchasing system.

In a second aspect, an electronic device is provided, the electronic device comprising:

the receiving and sending unit is used for receiving a production plan with a set time period;

the processing unit is used for determining a plurality of processes and corresponding production quantities according to the production plan; extracting m solder pastes associated with a plurality of processes, determining m using amounts required by the m solder pastes according to the production quantity, and inquiring m remaining stocks of the m solder pastes in the stock, wherein if the m remaining stocks are lower than the corresponding m using amounts;

and the receiving and sending unit is also used for sending a solder paste purchasing list to the purchasing system.

In a third aspect, a computer-readable storage medium is provided, which stores a program for electronic data exchange, wherein the program causes a server to execute the method provided in the first aspect.

The embodiment of the invention has the following beneficial effects:

it can be seen that the technical scheme provided by the application receives a production plan with a set time period, and determines a plurality of processes and corresponding production quantities according to the production plan; extracting m solder pastes associated with a plurality of processes, and determining m using amounts required by the m solder pastes according to the production amount; and inquiring m residual stocks of m solder pastes in the stock, and if the m residual stocks are lower than the corresponding m consumption, sending a solder paste purchasing list to a purchasing system. Therefore, the system can automatically calculate the stock and automatically schedule the solder paste according to the production plan, thereby reducing human factors, reducing the cost and improving the production efficiency.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a schematic structural diagram of an electronic device.

FIG. 2 is a flow chart of a method for managing solder paste inventory.

Fig. 3 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

The terms "first," "second," "third," and "fourth," etc. in the description and claims of the invention and in the accompanying drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.

Reference herein to "an embodiment" means that a particular feature, result, or characteristic described in connection with the embodiment can be included in at least one embodiment of the invention. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein can be combined with other embodiments.

The electronic device related to the embodiments of the present application may include various handheld devices, vehicle-mounted devices, wearable devices (smart watches, smart bracelets, wireless headsets, augmented reality/virtual reality devices, smart glasses), computing devices or other processing devices connected to wireless modems, and various forms of User Equipment (UE), Mobile Stations (MS), server devices (terminal device), and the like, which have wireless communication functions. For convenience of description, the above-mentioned devices are collectively referred to as electronic devices.

The following describes embodiments of the present application in detail.

Referring to fig. 1, fig. 1 is a schematic structural diagram of an electronic device disclosed in an embodiment of the present application, where the electronic device 100 includes a storage and processing circuit 110, and a sensor 170 connected to the storage and processing circuit 110, where:

the electronic device 100 may include control circuitry, which may include storage and processing circuitry 110. The storage and processing circuitry 110 may be a memory, such as a hard drive memory, a non-volatile memory (e.g., flash memory or other electronically programmable read-only memory used to form a solid state drive, etc.), a volatile memory (e.g., static or dynamic random access memory, etc.), etc., and the embodiments of the present application are not limited thereto. Processing circuitry in storage and processing circuitry 110 may be used to control the operation of electronic device 100. The processing circuitry may be implemented based on one or more microprocessors, microcontrollers, digital signal processors, baseband processors, power management units, audio codec chips, application specific integrated circuits, display driver integrated circuits, and the like.

The storage and processing circuitry 110 may be used to run software in the electronic device 100, such as an Internet browsing application, a Voice Over Internet Protocol (VOIP) telephone call application, an email application, a media playing application, operating system functions, and so forth. Such software may be used to perform control operations such as, for example, camera-based image capture, ambient light measurement based on an ambient light sensor, proximity sensor measurement based on a proximity sensor, information display functionality based on status indicators such as status indicator lights of light emitting diodes, touch event detection based on a touch sensor, functionality associated with displaying information on multiple (e.g., layered) display screens, operations associated with performing wireless communication functionality, operations associated with collecting and generating audio signals, control operations associated with collecting and processing button press event data, and other functions in the electronic device 100, to name a few.

The electronic device 100 may include input-output circuitry 150. The input-output circuit 150 may be used to enable the electronic device 100 to input and output data, i.e., to allow the electronic device 100 to receive data from an external device and also to allow the electronic device 100 to output data from the electronic device 100 to the external device. The input-output circuit 150 may further include a sensor 170. Sensor 170 may include the ultrasonic fingerprint identification module, may also include ambient light sensor, proximity sensor based on light and electric capacity, touch sensor (for example, based on light touch sensor and/or capacitanc touch sensor, wherein, touch sensor may be a part of touch display screen, also can regard as a touch sensor structure independent utility), acceleration sensor, and other sensors etc., the ultrasonic fingerprint identification module can be integrated in the screen below, or, the ultrasonic fingerprint identification module can set up in electronic equipment's side or back, do not do the restriction here, this ultrasonic fingerprint identification module can be used to gather the fingerprint image.

The sensor 170 may include an Infrared (IR) camera or an RGB camera, and when the IR camera takes a picture, the pupil reflects infrared light, so the IR camera takes a pupil image more accurately than the RGB camera; the RGB camera needs to perform more subsequent image processing, the calculation precision and accuracy are higher than those of the IR camera, the universality is better than that of the IR camera, and the calculation amount is large.

Input-output circuit 150 may also include one or more display screens, such as display screen 130. The display 130 may include one or a combination of liquid crystal display, organic light emitting diode display, electronic ink display, plasma display, display using other display technologies. The display screen 130 may include an array of touch sensors (i.e., the display screen 130 may be a touch display screen). The touch sensor may be a capacitive touch sensor formed by a transparent touch sensor electrode (e.g., an Indium Tin Oxide (ITO) electrode) array, or may be a touch sensor formed using other touch technologies, such as acoustic wave touch, pressure sensitive touch, resistive touch, optical touch, and the like, and the embodiments of the present application are not limited thereto.

The electronic device 100 may also include an audio component 140. The audio component 140 may be used to provide audio input and output functionality for the electronic device 100. The audio components 140 in the electronic device 100 may include a speaker, a microphone, a buzzer, a tone generator, and other components for generating and detecting sound.

The communication circuit 120 may be used to provide the electronic device 100 with the capability to communicate with external devices. The communication circuit 120 may include analog and digital input-output interface circuits, and wireless communication circuits based on radio frequency signals and/or optical signals. The wireless communication circuitry in communication circuitry 120 may include radio-frequency transceiver circuitry, power amplifier circuitry, low noise amplifiers, switches, filters, and antennas. For example, the wireless Communication circuitry in Communication circuitry 120 may include circuitry to support Near Field Communication (NFC) by transmitting and receiving Near Field coupled electromagnetic signals. For example, the communication circuit 120 may include a near field communication antenna and a near field communication transceiver. The communications circuitry 120 may also include a cellular telephone transceiver and antenna, a wireless local area network transceiver circuitry and antenna, and so forth.

The electronic device 100 may further include a battery, power management circuitry, and other input-output units 160. The input-output unit 160 may include buttons, joysticks, click wheels, scroll wheels, touch pads, keypads, keyboards, cameras, light emitting diodes and other status indicators, and the like.

A user may input commands through input-output circuitry 150 to control the operation of electronic device 100, and may use output data of input-output circuitry 150 to enable receipt of status information and other outputs from electronic device 100.

Solder paste was produced with the application of Surface Mount Technology (SMT) in the 70's of the 20 th century. It is a creamy mixture of solder powder, flux and other additives that, at soldering temperatures, will solder the components to be soldered to the printed circuit pads to form a permanent connection.

A database is a repository where data is stored. The storage space is large, and millions, millions and hundreds of millions of data can be stored. However, the database does not store data randomly, and has certain rules, otherwise, the query efficiency is low. The world today is an internet world that is full of data, which is flooded with large amounts of data. I.e. the internet world is the data world. The sources of data are many, such as travel records, consumption records, web pages viewed, messages sent, and so forth. In addition to text type data, image, music, sound, solder paste stock are all data.

A database is a computer software system that stores and manages data in a data structure. The concept of a database actually includes two layers of meaning:

(1) the database is an entity, which is a "warehouse" capable of reasonably keeping data, in which a user stores transaction data to be managed, and the two concepts of "data" and "library" are combined into the database.

(2) Databases are new methods and techniques for data management that enable more appropriate organization of data, more convenient maintenance of data, tighter control of data, and more efficient use of data.

The database management system is a core component of the database system, mainly completes the operation and management functions of the database, and realizes the creation of database objects, the query, addition, modification and deletion operations of database storage data, the user management and the authority management of the database, and the like. The security of the database system is directly related to the security of the whole database system, and the protection means mainly comprises the following steps:

(1) use the legal version database management system and install the relevant patches in time.

(2) User account management is well done, a default super administrator account is forbidden or a complex password is set for the super administrator account; respectively allocating special accounts for the application programs to access; and setting the login time and login failure times limit of the user to prevent the user password from being cracked violently.

(3) When the user access right is distributed, the minimum right distribution principle is adhered to, and the user is limited to access only a specific database and cannot access other databases at the same time.

(4) And modifying the default access port of the database, shielding other ports which are open to the outside by using a firewall, and forbidding all external port detection behaviors.

(5) Important data and sensitive data stored in the database are encrypted and stored, and data leakage caused by database backup or data file theft is prevented.

(6) And a backup strategy of the database is set, so that the database can be quickly restored after being damaged.

(7) The system storage process in the database is reasonably managed, unnecessary storage processes are forbidden, and database detection and attack by the storage processes are prevented.

(8) And starting a database auditing function, and carrying out comprehensive event tracking and log recording on the database.

Referring to fig. 2, fig. 2 provides a solder paste inventory management method, as shown in fig. 2, including the steps of:

step S201, the electronic equipment receives a production plan with a set time period, and determines a plurality of processes and corresponding production quantity according to the production plan;

step S202, the electronic equipment extracts m tin pastes related to a plurality of processes, and m using amounts needed by the m tin pastes are determined according to the production amount;

step S203, the electronic equipment inquires m residual stocks of m solder pastes in the stock, and if the m residual stocks are lower than the corresponding m using amounts, sends a solder paste purchasing list to a purchasing system.

The technical scheme provided by the application receives a production plan with a set time period, and a plurality of processes and corresponding production quantities are determined according to the production plan; extracting m solder pastes associated with a plurality of processes, and determining m using amounts required by the m solder pastes according to the production amount; and inquiring m residual stocks of m solder pastes in the stock, and if the m residual stocks are lower than the corresponding m consumption, sending a solder paste purchasing list to a purchasing system. Therefore, the system can automatically calculate the stock and automatically schedule the solder paste according to the production plan, thereby reducing human factors, reducing the cost and improving the production efficiency.

Optionally, the method may further include:

the electronic equipment inquires the backlog stock of the solder paste, obtains x models and x remaining stocks of the backlog stock, and sends the x models and the x remaining stocks to a process department.

Optionally, the determining m usage amounts required by the m solder pastes according to the production quantity specifically includes:

the electronic equipment extracts the unit dosage of the unit quantity of the first process in the plurality of processes, and the dosage required by the first solder paste corresponding to the first process is the product of the unit dosage and the yield quantity.

Optionally, the method further includes:

the electronic equipment determines m order deadlines corresponding to the m solder pastes, performs descending order arrangement on the m order deadlines, and then sends m order requests in sequence.

Optionally, the method further includes:

the electronic equipment determines m payment due dates corresponding to the m solder pastes, and sends m ordering requests in sequence after the m payment due dates are arranged in an ascending order.

Referring to fig. 3, fig. 3 provides an electronic device including:

Optionally, the electronic device further includes:

and the processing unit is also used for inquiring the backlog stock of the solder paste, acquiring x models and x remaining stocks of the backlog stock, and sending the x models and the x remaining stocks to a process department.

Optionally, the electronic device further includes:

and the processing unit is used for extracting the unit dosage of the unit quantity of the first process in the plurality of processes, and the dosage required by the first solder paste corresponding to the first process is the product of the unit dosage and the yield quantity.

Optionally, the processing unit is further configured to determine m order deadlines corresponding to the m solder pastes, and send the m order requests in sequence after performing descending order arrangement on the m order deadlines.

Optionally, the processing unit is further configured to determine m payment due dates corresponding to the m solder pastes, and send the m order requests in sequence after the m payment due dates are arranged in an ascending order.

Embodiments of the present invention also provide a computer storage medium, wherein the computer storage medium stores a computer program for electronic data exchange, and the computer program enables a computer to execute part or all of the steps of any one of the solder paste inventory management methods described in the above method embodiments.

Embodiments of the present invention also provide a computer program product comprising a non-transitory computer readable storage medium storing a computer program operable to cause a computer to perform some or all of the steps of any one of the solder paste inventory management methods as recited in the above method embodiments.

It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts, as some steps may occur in other orders or concurrently in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are exemplary embodiments and that the acts and modules illustrated are not necessarily required to practice the invention.

In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the embodiments provided in the present application, it should be understood that the disclosed apparatus may be implemented in other manners. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implementing, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of some interfaces, devices or units, and may be an electric or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit may be implemented in the form of hardware, or may be implemented in the form of a software program module.

The integrated units, if implemented in the form of software program modules and sold or used as stand-alone products, may be stored in a computer readable memory. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a memory and includes several instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned memory comprises: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.

Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by associated hardware instructed by a program, which may be stored in a computer-readable memory, which may include: flash Memory disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.

The above embodiments of the present invention are described in detail, and the principle and the implementation of the present invention are explained by applying specific embodiments, and the above description of the embodiments is only used to help understanding the method of the present invention and the core idea thereof; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.

Claims

1. A method of solder paste inventory management, the method comprising the steps of:

2. The method of claim 1, further comprising:

3. The method of claim 1, wherein determining the m quantities of solder paste required for the m solder pastes based on the production quantity comprises:

4. The method of claim 1, further comprising:

5. The method of claim 1, further comprising:

6. An electronic device, characterized in that the electronic device comprises:

7. The electronic device of claim 6, further comprising:

8. The electronic device of claim 6, further comprising:

9. The electronic device of claim 6,

the processing unit is further used for determining m order deadlines corresponding to the m solder pastes, and sending the m order requests in sequence after the m order deadlines are arranged in a descending order.

10. The electronic device of claim 9,

the processing unit is also used for determining m payment due dates corresponding to the m solder pastes, and sending m ordering requests in sequence after the m payment due dates are arranged in an ascending order.