CN100377140C - Global stock inquiry system and method - Google Patents
Global stock inquiry system and method Download PDFInfo
- Publication number
- CN100377140C CN100377140C CNB031143792A CN03114379A CN100377140C CN 100377140 C CN100377140 C CN 100377140C CN B031143792 A CNB031143792 A CN B031143792A CN 03114379 A CN03114379 A CN 03114379A CN 100377140 C CN100377140 C CN 100377140C
- Authority
- CN
- China
- Prior art keywords
- stock
- website
- database
- holdings
- inquiring
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Transfer Between Computers (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a global stock inquiry system and a method. The system comprises a host computer, a data base, a plurality of client end computers and a plurality of web data bases which are connected with a plurality of stock web computers, wherein the host computer comprises a module for maintaining a basic data, a data collecting module, a data inquiry module, a module for outputting a report and a module for sending a report, wherein the module for maintaining a basic data maintains the data base and the datum of the web data bases, the stock related data is collected by the data collecting module from the web data bases and is stored to the data base; the data inquiry module queries details or graphs of stock webs according to an inquiry condition; the module for outputting a report prints an inquiry result; the module for sending a report is used for obtaining the related data to generate a report according to user information which is set, and the report is sent to an e-mail address corresponding to a user. The user can intuitively obtain global stock datum of an enterprise by the system so as to enable related personnel to timely obtain store information which is needed.
Description
[invention field]
The invention relates to a kind of enterprise supply chain electronic management system and method, particularly about a kind of inventory management system and method.
[background of invention]
The production and the operating system of modern enterprise spread all over the world, and at each production point of sale and dealer, common carrier and the supplier place of enterprise product inventory are arranged all.Understand product library poke everywhere whenever and wherever possible, accomplish the timely supply of material, in time replenish, keep that optimum inventory is arranged everywhere, can reduce logistics center's stock and improve service quality.
Along with the widespread use of Internet (Internet), achieving the above object becomes possibility.Be 507147 and be called the patent of " the data warehouse system that a plurality of supplier's remote inquiries are provided " in the Announcement Number of on October 21st, 2002 bulletin as Taiwan intellectual property office.This patent is transmitted by world wide web realization data, makes the supplier can carry out remote inquiry.This technology utilizes virtual data to handle transmission data between client and supplier, and by the data formats conversion data is passed out.Intellectual property office in Taiwan is the patent of 509852 by name " utilize Email to do the teledata library inquiry and real-time is replied Query Result " in the Announcement Number of on November 11st, 2002 bulletin for another example.This patent obtains Query Result in real time by the e-mail system inquiry remote data base of world wide web.This technology can be in specific database or file is that condition is searched for the keyword, and the result is by E-mail, Chinese conveyer or mobile phone short message method of service real-time informing user.
Above-described database is single database or file, inquire about and generally need the input keyword, lack directly perceived.
Global stocks inquiring of the present invention system passes through Internet, integrate each inventory location infosystem, can utilize graphics mode to inquire about each inventory location article from the store rooms situation, and can pass in related personnel's the Email address according to the different relevant form of demand generation of related personnel.
[summary of the invention]
Fundamental purpose of the present invention is to provide a kind of global stocks inquiring system and method, and it inquires about each stock's site inventory situation by patterned way.
Another object of the present invention is to provide a kind of global stocks inquiring system and method, it can produce relevant form automatically by requirements of different users, by predefined Email address and by the mailbox of Internet timed sending to the related personnel.
The present invention has disclosed a kind of global stocks inquiring system and method.The information of this global stocks inquiring system stock's website of each distribution that globalizes by Network integration, and provide the graph inquiring mode to obtain stock's website holdings.A plurality of stock's site computer that this global stocks inquiring system includes a main frame and is connected by network.Stock's site computer places each stock's website, and described each stock's site computer links one first database, and described first database storing has the holdings of this stock's website.Main frame links one second database, and described second database storing has user profile, and described user profile is project, the Email address of the holdings in the required form content of a plurality of users and the time that sends form.Described main frame also includes a data collection module, a data query module and a form sending module.Described data collection module is used for being stored in from the acquisition of stock's site computer the holdings of first database, and it is stored in second database.Described data query module is used to provide a graph inquiring interface, and this graphical query interface comprises: a plurality of stock's site identity and world's map.Described a plurality of stock's site identity is used to indicate the geographic position of each stock's website, adopts the client computer of the Mschart of Microsoft control to click each described stock's site identity, the holdings of this stock's website that can obtain to represent with graphics mode by one; Indicate the geographic position of each stock's website of enterprise on described world's map with described stock's site identity.Described form sending module is used for obtaining corresponding holdings according to user profile and generates form, and with the extremely corresponding Email address of its timed sending.
The present invention also provides a kind of method of global stocks inquiring, the information of stock's website of each distribution that globalizes by Network integration, and provide the graph inquiring mode to obtain stock's website holdings.This method includes following steps: a plurality of stock's site computer (a) are provided, and described each stock's site computer places each stock's website, and its binding has one first database, and described first database storing has the holdings of this stock's website; (b) provide a main frame, its binding has one second database, and described second database storing has user profile, the time that it includes project, the Email address of the holdings in the required form content of a plurality of users and sends form; (c) acquisition is stored in the holdings of first database, and it is stored in second database; (d) provide a graph inquiring interface, this graph inquiring interface comprises a plurality of stock's site identity and world's map, described stock's site identity is used for indicating the geographic position of each stock's website on described world map, adopt the client computer of the Mschart of Microsoft control to click each described stock's site identity, the holdings of this stock's website that can obtain to represent by one with graphics mode; (e) generate form according to the project of the holdings of the user Email address in the user profile, user's needs and the time of setting, and with its timed sending to corresponding Email address.
Above-mentioned global stocks inquiring system and method is by Internet, the infosystem of each stock's website of integrated global.Client computer adopts the Mschart of Microsoft control, realizes patterned inquiring stock interface.The user can obtain the product library storage of each each item number of website by network, also can carry out the Text Mode inquiry, promptly presses item number, website, common carrier and client's inquiry, obtains the detailed text message of website product.
[description of drawings]
Fig. 1 is the hardware structure figure of global stocks inquiring system and method for the present invention.
Fig. 2 is the functional block diagram of main frame of the present invention.
Fig. 3 is the data flow diagram of global stocks inquiring system and method for the present invention.
Fig. 4 is the inquiring stock page synoptic diagram of global stocks inquiring system and method for the present invention.
Fig. 5 is the operation process chart of global stocks inquiring system and method for the present invention.
[embodiment explanation]
Consult shown in Figure 1ly, be the hardware structure figure of global stocks inquiring of the present invention system.A plurality of client computers 2 of distributed distribution are connected 5 by one and link to each other with a database 6 by network 4 this main frame 1 that links to each other with a main frame 1; The a plurality of stock's site computer 3 that are distributed in the whole world link to each other with main frame by network 4; Site computer 3 by one connect 5 with its under site database 7 link to each other.Wherein, network 4 is a kind of electric network, and it can be intranet (Intranet), Internet (Internet) or other type network; Connecting 5 is that a kind of database connects, as the open type data storehouse connect (Open Database Connectivity, ODBC), perhaps the Java database connect (Java Database Connectivity, JDBC) etc.In the present invention, client computer 2 can be user's environment of Windows95, Windows98 or Windows NT.Client computer 2 provides interactive user the interface for the user, and adopt the mschart of Microsoft control, in order to realizing patterned inquiring stock interface, the carried out database of user's mat, the maintenance of site database, obtain information, inquire about operations such as each product inventory situation from main frame.Site computer 3 places enterprise to be distributed in each stock's website in the whole world, it is used for gathering the holdings of stock's website and it is stored in site database 7, and holdings include item number, name of an article description, quantity, net weight, gross weight, unit price and the total charge etc. of product.Database 6 storage enterprises be distributed in the whole world the holdings and the user profile of the various products of website in stock, wherein holdings include item number, name of an article description, quantity, net weight, gross weight, unit price and total charge, client and the common carrier etc. of station code, site name, website the country one belongs to title, product; User profile includes each user's Email address, the needed holdings that the user sets and the time that sends form etc., can receive the relevant holdings form of certain certain material of stock's website at 10:00 as the user.Main frame 1 includes a series of software function modules (as shown in Figure 2), is used to utilize Internet, realizes the global repository data query by network.
Consult shown in Figure 2ly, be the functional block diagram of main frame of the present invention.This main frame 1 includes a basic data maintenance module 20, a data acquisition module 30, a data query module 40, a report output module 50 and a form sending module 60.Wherein basic data maintenance module 20 is used for the related data by client computer 2 maintenance data bases 6 and site database 7, can increase newly, revises, the holdings in deletion and Query Database 6 and the site database 7.Data collection module 30 is used for gathering these stock's website holdings by site computer 3 from site database 7 and is stored to the database 6 by network 4, and holdings include item number, name of an article description, quantity, net weight, gross weight, unit price and the total charge etc. of product.Data check module 40 is used for according to condition inquiring about according to user's request.This module includes a stock's website particulars inquiry submodule 400 and a graphical query submodule 401.Wherein stock's website particulars inquiries submodule 400 is used for the user and selects website, item number, client and common carrier etc. one, a plurality of or all as querying condition, from database 6, obtain detailed inventory information, as stock's site name, item number, name of an article description, quantity, net weight, gross weight, unit price and total charge etc.Can select a website as the user, inquire about the product inventory situation of current each item number of this station inventory location, or select an item number to inquire about the inventories of this product at each website of the whole world.When graphical query submodule 401 is used for the user and only needs to know the tank farm stock of certain website, the login main frame, acquisition includes the graphical query interface of the different stock's websites of enterprise, this graphical query interface includes world's map and is distributed in site identity on the world map, this site identity is used to indicate the geographic position of business inventory website, when clicking arbitrary site identity, obtain the product library storage of this each item number of stock's website of representing with graphics mode.Described graphics mode has two-dimentional colored bar graph, two-dimentional colored pie chart, three-dimensional bar graph, two-dimentional broken line graph, three-dimensional polyline figure, two-dimensional areas figure and three-dimensional area-graph etc.Report output module 50 is used for according to Query Result, prints inquiry data form according to user's request.Form sending module 60 is used for regularly form being sent to related personnel's mailbox, promptly according to stored user information in the database 6: relevant holdings and transmitting time that user Email address, user need, from database 6, obtain stock's website product information that the user needs, generate form, timed sending is in its Email address.
Consult shown in Figure 3ly, be the data flow diagram of global stocks inquiring of the present invention system.20 pairs of databases 6 of basic data maintenance module and site database 7 safeguard, comprises the holdings in newly-increased, modification, inquiry, delete database 6 or the site database 7.The holdings that data collection module 30 is collected various products affiliated stock's website from site database 7 are stored in the database 6.Data check module 40 selects the proper inquiry condition to inquire about the website holdings or inquire about the distribution situation of certain product at each stock's website from database 6 according to user's request, and wherein querying condition includes website, item number, client and common carrier etc.Report output module 50 prints Query Result according to customer requirements.Form sending module 60 obtains relevant holdings according to user profile from database 6, generate form, and this form of timed sending is to client computer 2 user Email addresses.
Consult shown in Figure 4ly, be the inquiring stock page synoptic diagram of global stocks inquiring of the present invention system.This page shows a world map, utilizes site identity 30A, 30B, 30C and 30D etc. to indicate the geographic position (only marking four among the figure) of a plurality of stock's websites of enterprise in detail on this map.When the user clicks any site identity 30A, 30B, 30C and 30D, obtain the product library storage of this each item number of stock's website of representing with graphics mode.Described graphics mode includes two-dimentional colored bar graph, two-dimentional colored pie chart, three-dimensional bar graph, two-dimentional broken line graph, three-dimensional polyline figure, two-dimensional areas figure and three-dimensional area-graph etc.
Consult shown in Figure 5ly, be the operation process chart of global stocks inquiring of the present invention system.At first safeguard by 4 pairs of databases 6 of network and each site database 7 of being distributed in the whole world, comprise the product information (step S501) in newly-increased, modification, delete database 6 and the site database 7 by basic data maintenance module 20.The basic document that data collection module 30 is gathered various products from site database 7 by site computer by the network storage to database 6 (step S503).According to the user profile that is stored in the database 6, form sending module 60 obtains related datas and also generates form, timed sending (step S505) in the user Email address of client computer 2.According to user's request, data check module 40 judges whether the user needs detailed query (step S507); If need detailed query, then press querying condition, in selection website, item number, client and the common carrier etc. one, a plurality of or full terms inquire about, and obtain needed details (step S509); If only need to know each product library storage of each website, then can on the inquiring stock page, click the site identity that to inquire about, select different graphics modes to show the tank farm stock of this each product of stock's website, different graphics modes is (step S511) such as two-dimentional colored bar graph, two-dimentional colored pie chart, three-dimensional bar graph, two-dimentional broken line graph, three-dimensional polyline figure, two-dimensional areas figure and three-dimensional area-graphs.
Claims (8)
1. global stocks inquiring system, the information of stock's website of each distribution that globalizes by Network integration, and provide the graph inquiring mode to obtain stock's website holdings, it is characterized in that, a plurality of stock's site computer that this system includes a main frame and is connected by network, wherein:
Stock's site computer places each stock's website, and described each stock's site computer links one first database, and described first database storing has the holdings of this stock's website;
Main frame links one second database, and described second database storing has user profile, and described user profile is project, the Email address of the holdings in the required form content of a plurality of users and the time that sends form;
Described main frame also includes:
One data collection module is used for obtaining to be stored in from stock's site computer the holdings of first database, and it is stored in second database;
One data query module is used to provide a graph inquiring interface, and this graphical query interface comprises:
A plurality of stock's site identity are used to indicate the geographic position of each stock's website, adopt the client computer of the Mschart of Microsoft control to click each described stock's site identity, the holdings of this stock's website that can obtain to represent with graphics mode by one;
One world's map is indicated the geographic position of each stock's website of enterprise with described stock's site identity on it;
One form sending module obtains corresponding holdings according to user profile and generates form, and with the extremely corresponding Email address of its timed sending.
2. global stocks inquiring as claimed in claim 1 system is characterized in that, also includes a plurality of client computers, is used to provide a user interface, operations such as the carried out database of user's mat and the maintenance of site database and inquiry product information.
3. global stocks inquiring as claimed in claim 1 system is characterized in that wherein graphics mode includes two-dimentional colored bar graph, two-dimentional colored pie chart, three-dimensional bar graph, two-dimentional broken line graph, three-dimensional polyline figure, two-dimensional areas figure and three-dimensional area-graph.
4. global stocks inquiring as claimed in claim 1 system is characterized in that, the data check module includes stock's website particulars inquiry submodule, is used for the user and carries out text query by querying condition, obtains the detailed holdings of stock's website.
5. global stocks inquiring as claimed in claim 4 system is characterized in that wherein querying condition includes website, item number, client and common carrier.
6. global stocks inquiring method, the information of the stock's website that distributes by each globalization of Network integration, and provide the graph inquiring mode to obtain stock's website holdings, it is characterized in that this method includes following steps:
(a) provide a plurality of stock's site computer, described each stock's site computer places each stock's website, and its binding has one first database, and described first database storing has the holdings of this stock's website;
(b) provide a main frame, its binding has one second database, and described second database storing has user profile, the time that it includes project, the Email address of the holdings in the required form content of a plurality of users and sends form;
(c) acquisition is stored in the holdings of first database, and it is stored in second database;
(d) provide a graph inquiring interface, this graph inquiring interface comprises a plurality of stock's site identity and world's map, described stock's site identity is used for indicating the geographic position of each stock's website on described world map, adopt the client computer of the Mschart of Microsoft control to click each described stock's site identity, the holdings of this stock's website that can obtain to represent by one with graphics mode;
(e) generate form according to the project of the holdings of the user Email address in the user profile, user's needs and the time of setting, and with its timed sending to corresponding Email address.
7. global stocks inquiring method as claimed in claim 6 is characterized in that, wherein graphics mode includes two-dimentional colored bar graph, two-dimentional colored pie chart, three-dimensional bar graph, two-dimentional broken line graph, three-dimensional polyline figure, two-dimensional areas figure and three-dimensional area-graph.
8. global stocks inquiring method as claimed in claim 6, it is characterized in that wherein step (e) is meant that the time timed sending form of the project of the holdings that need according to the user Email address of storing in the database, user and setting is to corresponding Email address.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB031143792A CN100377140C (en) | 2003-04-28 | 2003-04-28 | Global stock inquiry system and method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB031143792A CN100377140C (en) | 2003-04-28 | 2003-04-28 | Global stock inquiry system and method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1542635A CN1542635A (en) | 2004-11-03 |
CN100377140C true CN100377140C (en) | 2008-03-26 |
Family
ID=34320196
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB031143792A Expired - Fee Related CN100377140C (en) | 2003-04-28 | 2003-04-28 | Global stock inquiry system and method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN100377140C (en) |
Families Citing this family (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100401288C (en) * | 2005-05-30 | 2008-07-09 | 北京慧讯信息技术有限公司 | Distributed data source data integration system and method |
CN101730077A (en) * | 2009-11-20 | 2010-06-09 | 中兴通讯股份有限公司 | Report subscription based method and system for configuring report parameter values |
CN101957849A (en) * | 2010-09-21 | 2011-01-26 | 用友软件股份有限公司 | Static statement generation method and device |
CN102479204A (en) * | 2010-11-26 | 2012-05-30 | 安凯(广州)微电子技术有限公司 | Data query method and tool |
CN102118446A (en) * | 2011-03-09 | 2011-07-06 | 成都四方信息技术有限公司 | WEB-based high-performance intelligent reporting system |
CN102999479A (en) * | 2011-09-13 | 2013-03-27 | 阿里巴巴集团控股有限公司 | Mail manufacturing method and mail manufacturing system |
CN102760378B (en) * | 2012-06-05 | 2014-12-31 | 深圳市粮食集团有限公司 | Electronic map-combined food information processing method and management system |
CN111461619A (en) * | 2020-04-09 | 2020-07-28 | 北京思特奇信息技术股份有限公司 | Front-end workbench system applied to marketing resource management |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1204410A (en) * | 1995-10-17 | 1999-01-06 | 花旗银行全国协会(N·A·) | Sales process support system and method |
CN1381973A (en) * | 2001-04-17 | 2002-11-27 | 松下电工株式会社 | Method, system and service device for automatic transmitting E-mail at communication network |
CN1403946A (en) * | 2001-09-06 | 2003-03-19 | 英业达股份有限公司 | Automatic e-mail data sending method in decision information system |
-
2003
- 2003-04-28 CN CNB031143792A patent/CN100377140C/en not_active Expired - Fee Related
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1204410A (en) * | 1995-10-17 | 1999-01-06 | 花旗银行全国协会(N·A·) | Sales process support system and method |
CN1381973A (en) * | 2001-04-17 | 2002-11-27 | 松下电工株式会社 | Method, system and service device for automatic transmitting E-mail at communication network |
CN1403946A (en) * | 2001-09-06 | 2003-03-19 | 英业达股份有限公司 | Automatic e-mail data sending method in decision information system |
Also Published As
Publication number | Publication date |
---|---|
CN1542635A (en) | 2004-11-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20060004615A1 (en) | System and method for filtering exceptions generated by forecasting and replenishment engine | |
CN101341464B (en) | Method for searching over structured data, system, and method and system for enabling the data item structuring and capable of searching | |
CN1955998B (en) | For the system and method for visualizing auto-id data | |
US20070124077A1 (en) | An Inventory Stocking and Locating System Utilizing Tags and GPS providing Summarization by Hierarchical Code | |
US20080097818A1 (en) | Client Account and Information Management System and Method | |
US20070027891A1 (en) | System and method for providing listing check functionality | |
US20040010496A1 (en) | Apparatus and method for integrating variable subsidiary information with main office information in an enterprise system | |
US20210256539A1 (en) | System and Method for Providing Requested Information to Thin Clients | |
CN1650649A (en) | Integrating geographical contextual information into mobile entreprise applications | |
CN100377140C (en) | Global stock inquiry system and method | |
CN100370458C (en) | Data integration and analysis system and method | |
US7251622B2 (en) | System and method for searching for information on inventory with virtual warehouses | |
CN1315709A (en) | Market circulation information system | |
Lau et al. | M‐commerce to support the implementation of a responsive supply chain network | |
TW200424890A (en) | System and method querying inventory of the seven seas | |
US8596524B2 (en) | Barcode information distribution system | |
CN100412858C (en) | Report generating system and method | |
CN201616115U (en) | Whole-course monitoring system for standardized production of pollution-free agricultural product | |
CN103455614A (en) | Method, device and system for lowering commodity barcode attaching rate | |
CN107506970B (en) | Project data processing method and system | |
Choy et al. | Improving logistics visibility in a supply chain: an integrated approach with radio frequency identification technology | |
CN1713191A (en) | Realtime sale and management system through wireless terminal | |
CN1614604A (en) | Stock inquiring system and method | |
CN1641665A (en) | Multi-strong-point inventory analysing system and method | |
CN1434404A (en) | Visualization stock management system and method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080326 Termination date: 20150428 |
|
EXPY | Termination of patent right or utility model |