CN102542426A - Visualized purchase, sales and inventory management system and management method - Google Patents
Visualized purchase, sales and inventory management system and management method Download PDFInfo
- Publication number
- CN102542426A CN102542426A CN2010106080711A CN201010608071A CN102542426A CN 102542426 A CN102542426 A CN 102542426A CN 2010106080711 A CN2010106080711 A CN 2010106080711A CN 201010608071 A CN201010608071 A CN 201010608071A CN 102542426 A CN102542426 A CN 102542426A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- interface
- inventory
- visually
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a visualized purchase, sales and inventory management system. The system comprises a database for storing purchase, sales and inventory data of goods; an in-storage interface for recording in-storage data of goods and correspondingly adjusting the database after receiving the in-storage data; an out-storage interface for recording out-storage data of goods, and correspondingly adjusting the database after receiving the out-storage data; an inventory statistics device for conducting inventory statistics of goods in the database to obtain inventory data; a data collection module connected with the in-storage interface, the out-storage interface and the inventory statistics device, for collecting the in-storage data, the out-storage data and the inventory data, standardizing and unifying format of the in-storage data, the out-storage data and the inventory data, and generating basic data; and a visualized module connected with the data collection module for generating visualized data according to the basic data, wherein the visualized module can also generate a visualization interface, on which the visualized data can be displayed.
Description
Technical field
The present invention relates to the data visualization technology, relate in particular to a kind of visual purchase, sales and inventory management system and management method.
Background technology
Current; China's commerce is in the period of a high speed development; Also be China's commerce by conventional commercial to the commercial important period that changes of modernization, experiencing, how to obtain market information, merchandise news timely and accurately by the period of empirical decision making to the information decision transformation; Understand market developing trend, predict, directing operational activities; Purchase and sale how to grasp the enterprises commodity timely and accurately dynamically, information such as the price mechanism of the article class formation of commodity, commodity, Inventory Performance, financial condition, become the object of competition.Have only basis and the foundation of complete comprehensively information, make whole business activity information-based, just can devise strategies at the headquarters, grasp future as decision-making.From what time, " commercial struggle " become information war, and " commercial struggle " fires outside the market.The operator not only only has been concerned about sales volume, the tank farm stock of the commodity of managing, and what the operator more was concerned about is that which commodity has brought more profit, which commodity " only eating rice does not lay eggs ".Today, which commodity was fast-selling, and tomorrow, which commodity sold well, advance which type of goods, from where advance, advance what or the like problem." appetite " how in time to understand client become the key of operation, if prepare too much or can not reach best effect very little.Want to achieve the above object, need various information as foundation: be in great demand, information of information, supplier and the supplied goods thereof of unseasonable goods, client's information, the information in market or the like.And range of goods becomes increasingly abundant in the current business management, and turnover period is shorter and shorter; Quantity of information is increasing; Original ladder of management can not adapt to the demand of modern management to information, to some information geo-statistic, relies on by hand and can not realize; Even the result has been arranged, can not avoid the hysteresis of information, drawback such as inaccurate, not comprehensive.
The business operator is more and more urgent and harsh to the demand of information, and the fieriness of the competition between the market makes to be utilized computing machine that information is managed to become indispensable means in the business activities.Computer management information system has become the favourable instrument that carries out the modern commerce management.
Along with the development of mechanics of communication, network technology, computer technology, software engineering, utilize computer system through participative management is collected, puts in order, processed to the information of using in the business activities and aid decision making has become possibility.The development of mechanics of communication shortened the world distance, shortened the distance of people and information, people can stay indoors just can become global information the our grasp of oneself.Networks development has thoroughly been eliminated the wide gap between heterogeneous network, and the development of computer technology and software engineering has improved its cost performance greatly, and its application is yielded unusually brilliant results.Make full use of above various technology, can realize comprising electronic order service (EOS) system; Online Store, electronic retailing system etc. are in the comprehensive management of interior whole business activity.How the market is implemented computer management and how to be let auxiliary better management of computer system and decision-making become key.
Summary of the invention
According to an aspect of the present invention, propose a kind of visual purchase, sales and inventory management system, comprising:
Database, database is preserved the goods entry, stock and sales data of goods;
Warehousing interface is connected to database, and warehousing interface writes down the database data of going into of goods, and warehousing interface is adjusted database after receiving database data accordingly;
Go out bank interface, be connected to database, go out the database data of bank interface record goods, go out bank interface and after receiving out database data, database is adjusted accordingly;
The inventory statistics device is connected to database, and the stock of goods in the database is added up, and obtains inventory data;
Data collection module is connected to warehousing interface, goes out bank interface and inventory statistics device, is collected into database data, goes out database data and inventory data, will go into database data, go out database data and inventory data carries out standardization and uniform format, the formation base data;
Visualization model is connected to data collection module, generates visualized data based on basic data, and visualization model also generates a visualization interface and display of visually data on visualization interface.
In one embodiment, the visualized data that generates of visualization model comprises: the visible database integrated data, visually go into database data, visually go out database data, visual inventory data.
In one embodiment, the visualization interface that generates of visualization model comprises: main interface, put sub-interface, the sub-interface of outbound and the sub-interface of stock in storage.
In one embodiment, visualization model display of visually database integrated data on the main interface, on the sub-interface of warehouse-in display of visually dissolve database data, dissolve database data at display of visually on the sub-interface of outbound, display of visually inventory data on the sub-interface of stock.
According to a further aspect in the invention, also propose a kind of visual purchase, sales and stock management method, comprising:
Keep a database, database is preserved the goods entry, stock and sales data of goods;
Write down the database data of going into of goods, and after going into database data, database is adjusted accordingly;
Write down the database data that of goods, and after receiving out database data, database is adjusted accordingly according to going out bank interface;
Stock to goods in the database adds up, and obtains inventory data;
Be collected into database data, go out database data and inventory data, will go into database data, go out database data and inventory data carries out standardization and uniform format, the formation base data;
Generate visualized data based on basic data, generate visualization interface and display of visually data on visualization interface.
In one embodiment, the visualized data of generation comprises: the visible database integrated data, visually go into database data, visually go out database data, visual inventory data.
In one embodiment, the visualization interface of generation comprises: main interface, put sub-interface, the sub-interface of outbound and the sub-interface of stock in storage.
In one embodiment, comprise in display of visually data on the visualization interface: display of visually database integrated data on the main interface, on the sub-interface of warehouse-in display of visually dissolve database data, dissolve database data at display of visually on the sub-interface of outbound, display of visually inventory data on the sub-interface of stock.
Visual purchase, sales and inventory management system of the present invention and visual purchase, sales and stock management method make full use of visualization technique; Make that the goods entry, stock and sales data of the various goods preserved in the database can very be showed intuitively, help business activities are judged exactly.
Description of drawings
Fig. 1 has disclosed the structural drawing according to visual purchase, sales and inventory management system of the present invention.
Fig. 2 has disclosed the process flow diagram according to visual purchase, sales and stock management method of the present invention.
Embodiment
The present invention has disclosed visual purchase, sales and inventory management system and visual purchase, sales and stock management method, all is based on visualization technique and realizes.In one embodiment, visualization technique has utilized VB to reach.
VB is the quick visualization program development tools software that Microsoft produces, and by the monopoly position of Microsoft at operating system and office software, VB is the fashionable whole world in short several years.VB is that the utmost point has and powerful software, mainly shows: the INTERFACE DESIGN of What You See Is What You Get, and object-based method for designing, extremely short software development cycle is than the generating code of easy care.Microsoft released VB1.0 in 1991 and has experienced 6 versions so far, and VB6.0 operates in win9x or winme, win2000, and winxp under the operating systems such as windowsNT, is one 32 an application development instrument.
The VB program language has many outstanding characteristics, and two basic characteristics are arranged during with its design application:
1) The visual design;
2) event-driven programming.
The visual design: VB provides a large amount of interface elements (in VB, being called control object) for the user; These control object are not strange at all for the user who is familiar with window application; Like " forms ", " menu ", " order button ", " tool button ", " check box " or the like; The user only need utilize mouse, keyboard to drag to suitable position to these control object; Their size, shape, attribute etc. are set, just can design required Application Program Interface.
Event-driven programming: since Windows operating system occurs; It can not be monistic that the application program of patterned user interface and multitask multi-process requires program design; When using the VB design application, must confirm at first how application program carries out with the user alternately.When incident such as mouse-click, keyboard input for example takes place, the response of these incidents of code control of writing by the user, Here it is so-called event-driven programming.
VB provides the application program that is easy to learn and use IDE; In the VB IDE; But user's design interface, writing code, debugged program, move in Windows until being compiled into executable file to application program, is that the user works in close friend's development environment.
VB has rich data type and structured program structure, and easy to learn.In addition; As a kind of programming language; VB also has many distinctive features, comprising: but powerful numerical value and character processing capacity, abundant graphics command can draw various figures easily, provide static state and Dynamic Array help simplifying memory management, process recursive call make program more terse, support random file visit and sequential file visit, provide that but a programs calls comprise polytype chart storehouse, have perfect operation error handling processing.
VB also supports the visit in several data storehouse; Utilize the addressable Database Systems of data control to have: Microsoft Access, Btrieve, dBASE, Microsoft FoxPro and Paradox etc.; Also can accessing Microsoft Excel, multiple electrical form such as Lotsl2-3.
VB also supports the link and embedding (OLE) technology of dynamic data exchange (DDE), dynamic link libraries (DLL) and object
The programming technique of dynamic data exchange (DDE), make the VB developing application can and other window applications between set up data communication.Through dynamic link library (DLL) technology of VB, in the VB program, can call the function of writing with C language or assembly language easily, also can call window application interface (API) function, with the function that realizes that SDK can realize.The core of VB be its to the link of object and the support of embedding (OLE), it be the visit all objects a kind of method.Utilize the OLE technology, VB is regarded as an object with other application software and is embedded in the VB application program, carries out various operations, also can various application programs based on Windows be embedded into the VB application program, realizes multimedias such as sound, image, animation.
With reference to shown in Figure 1, disclosed a kind of visual purchase, sales and inventory management system, comprising: database 10, warehousing interface 11, go out bank interface 12, inventory statistics device 13, data collection module 14 and visualization model 15.
The goods entry, stock and sales data that database 10 is preserved goods.Warehousing interface 11 is connected to database 10, and warehousing interface 11 writes down the database data of going into of goods, and warehousing interface 11 is adjusted database 10 after receiving database data accordingly.Go out bank interface 12 and be connected to database 10, go out the database data of bank interface 12 record goods, go out bank interface 12 and after receiving out database data, database 10 is adjusted accordingly.Inventory statistics device 13 is connected to database 10, and the stock of goods in the database 10 is added up, and obtains inventory data.Data collection module 14 is connected to warehousing interface 11, goes out bank interface 12 and inventory statistics device 13, is collected into database data, goes out database data and inventory data, will go into database data, go out database data and inventory data carries out standardization and uniform format, the formation base data.Visualization model 15 is connected to data collection module 14, generates visualized data based on basic data, and visualization model 15 also generates a visualization interface and display of visually data on visualization interface.
In one embodiment, visualization model 15 comprises based on the visualized data that basic data generates: the visible database integrated data, visually go into database data, visually go out database data, visual inventory data.Simultaneously, the visualization interface that generates of visualization model 15 comprises: main interface, put sub-interface, the sub-interface of outbound and the sub-interface of stock in storage.In one embodiment, visualization model 15 shows these visualized datas according to following mode: display of visually database integrated data on the main interface, on the sub-interface of warehouse-in display of visually dissolve database data, dissolve database data at display of visually on the sub-interface of outbound, display of visually inventory data on the sub-interface of stock.
With reference to shown in Figure 2, disclosed a kind of visual purchase, sales and stock management method, comprising:
S20. keep a database, database is preserved the goods entry, stock and sales data of goods.
S21. write down the database data of going into of goods, and after going into database data, database is adjusted accordingly.
S22. write down the database data that of goods, and after receiving out database data, database is adjusted accordingly according to going out bank interface.
S23. the stock to goods in the database adds up, and obtains inventory data.
S24. be collected into database data, go out database data and inventory data, will go into database data, go out database data and inventory data carries out standardization and uniform format, the formation base data.
S25. generate visualized data based on basic data, generate visualization interface and display of visually data on visualization interface.In one embodiment, the visualized data that generates among the step S25 comprises: the visible database integrated data, visually go into database data, visually go out database data, visual inventory data.The visualization interface that generates comprises: main interface, put sub-interface, the sub-interface of outbound and the sub-interface of stock in storage.In one embodiment, among the step S25 according to following mode in display of visually data on the visualization interface: display of visually database integrated data on the main interface, on the sub-interface of warehouse-in display of visually dissolve database data, dissolve database data at display of visually on the sub-interface of outbound, display of visually inventory data on the sub-interface of stock.
Visual purchase, sales and inventory management system of the present invention and visual purchase, sales and stock management method make full use of visualization technique; Make that the goods entry, stock and sales data of the various goods preserved in the database can very be showed intuitively, help business activities are judged exactly.
Claims (8)
1. a visual purchase, sales and inventory management system is characterized in that, comprising:
Database, said database is preserved the goods entry, stock and sales data of goods;
Warehousing interface is connected to said database, and warehousing interface writes down the database data of going into of goods, and warehousing interface is adjusted database after receiving database data accordingly;
Go out bank interface, be connected to said database, go out the database data of bank interface record goods, go out bank interface and after receiving out database data, database is adjusted accordingly;
The inventory statistics device is connected to said database, and the stock of goods in the database is added up, and obtains inventory data;
Data collection module is connected to said warehousing interface, goes out bank interface and inventory statistics device, is collected into database data, goes out database data and inventory data, will go into database data, go out database data and inventory data carries out standardization and uniform format, the formation base data;
Visualization model is connected to said data collection module, generates visualized data based on basic data, and visualization model also generates a visualization interface and on visualization interface, shows said visualized data.
2. visual purchase, sales and inventory management system as claimed in claim 1 is characterized in that, the visualized data that said visualization model generates comprises: the visible database integrated data, visually go into database data, visually go out database data, visual inventory data.
3. like claim 2 described visual purchase, sales and inventory management systems, it is characterized in that the visualization interface that said visualization model generates comprises: main interface, put sub-interface, the sub-interface of outbound and the sub-interface of stock in storage.
4. visual purchase, sales and inventory management system as claimed in claim 3; It is characterized in that, said visualization model display of visually database integrated data on the main interface, on the sub-interface of warehouse-in display of visually dissolve database data, dissolve database data at display of visually on the sub-interface of outbound, display of visually inventory data on the sub-interface of stock.
5. a visual purchase, sales and stock management method is characterized in that, comprising:
Keep a database, database is preserved the goods entry, stock and sales data of goods;
Write down the database data of going into of goods, and after going into database data, database is adjusted accordingly;
Write down the database data that of goods, and after receiving out database data, database is adjusted accordingly according to going out bank interface;
Stock to goods in the database adds up, and obtains inventory data;
Be collected into database data, go out database data and inventory data, will go into database data, go out database data and inventory data carries out standardization and uniform format, the formation base data;
Generate visualized data based on basic data, generate visualization interface and display of visually data on visualization interface.
6. visual purchase, sales and stock management method as claimed in claim 5 is characterized in that the visualized data of generation comprises: the visible database integrated data, visually go into database data, visually go out database data, visual inventory data.
7. like claim 6 described visual purchase, sales and stock management methods, it is characterized in that the visualization interface of generation comprises: main interface, put sub-interface, the sub-interface of outbound and the sub-interface of stock in storage.
8. visual purchase, sales and stock management method as claimed in claim 7; It is characterized in that, comprise in display of visually data on the visualization interface: display of visually database integrated data on the main interface, on the sub-interface of warehouse-in display of visually dissolve database data, dissolve database data at display of visually on the sub-interface of outbound, display of visually inventory data on the sub-interface of stock.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010106080711A CN102542426A (en) | 2010-12-27 | 2010-12-27 | Visualized purchase, sales and inventory management system and management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010106080711A CN102542426A (en) | 2010-12-27 | 2010-12-27 | Visualized purchase, sales and inventory management system and management method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102542426A true CN102542426A (en) | 2012-07-04 |
Family
ID=46349267
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010106080711A Pending CN102542426A (en) | 2010-12-27 | 2010-12-27 | Visualized purchase, sales and inventory management system and management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102542426A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103279860A (en) * | 2013-05-13 | 2013-09-04 | 苏州才子佳人文化传播有限公司 | Supermarket purchase, sales and inventory management system of mobile mall |
| CN105303277A (en) * | 2014-06-13 | 2016-02-03 | 北京农业信息技术研究中心 | Germplasm resource management method and system |
| CN106355369A (en) * | 2016-08-29 | 2017-01-25 | 芜湖创易科技有限公司 | Purchase-sales-inventory management system |
| CN112633798A (en) * | 2020-12-21 | 2021-04-09 | 山东众阳健康科技集团有限公司 | Hospital medicine purchase, sale and storage supervision method and system |
-
2010
- 2010-12-27 CN CN2010106080711A patent/CN102542426A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103279860A (en) * | 2013-05-13 | 2013-09-04 | 苏州才子佳人文化传播有限公司 | Supermarket purchase, sales and inventory management system of mobile mall |
| CN105303277A (en) * | 2014-06-13 | 2016-02-03 | 北京农业信息技术研究中心 | Germplasm resource management method and system |
| CN106355369A (en) * | 2016-08-29 | 2017-01-25 | 芜湖创易科技有限公司 | Purchase-sales-inventory management system |
| CN112633798A (en) * | 2020-12-21 | 2021-04-09 | 山东众阳健康科技集团有限公司 | Hospital medicine purchase, sale and storage supervision method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11157128B2 (en) | Software robots for programmatically controlling computer programs to perform tasks | |
| JP7017613B2 (en) | Naming Robotic Process Automation activities based on auto-discovered target labels | |
| CN100504768C (en) | System and methods for inline property editing in tree view based editors | |
| CN104106066A (en) | System to view and manipulate artifacts at temporal reference point | |
| CN101828169A (en) | Software factory specification and execution model | |
| CN103970527A (en) | Assistive Overlay For Report Generation | |
| US9015608B2 (en) | Regenerating a user interface area | |
| US7512451B2 (en) | System and method for interactive process management | |
| US20230008198A1 (en) | Methods, systems, articles of manufacture and apparatus to label text on images | |
| CN102542426A (en) | Visualized purchase, sales and inventory management system and management method | |
| CN102426570B (en) | Method and equipment for demonstrating influencing factors in statistical chart | |
| US20240037084A1 (en) | Method and apparatus for storing data | |
| CN113287100A (en) | System and method for generating in-memory table model database | |
| CN101515864B (en) | Alarm information allocation system and allocation method thereof | |
| CN102043627A (en) | Development method and system of comparable data showing program of browser server architecture | |
| CN113901096A (en) | Data screening method and device, electronic equipment and storage medium | |
| US20140337350A1 (en) | Matrix viewing | |
| US20230111999A1 (en) | Method and system of creating clusters for feedback data | |
| US11561982B2 (en) | Intelligent and automatic exception handling | |
| KR20240054362A (en) | Methods and systems for managing apps, especially developing apps that include event artifacts | |
| CN109657896A (en) | Mobility notch detection method, device, equipment and storage medium | |
| CN113723062A (en) | Report label editing method and device, storage medium and terminal equipment | |
| Tupec | Android components for business applications | |
| JP2007188187A (en) | Business form creation support device, method, and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120704 |