KR20110042707A - A method for operating a web-based parts list managing system - Google Patents

A method for operating a web-based parts list managing system Download PDF

Info

Publication number
KR20110042707A
KR20110042707A KR1020090099503A KR20090099503A KR20110042707A KR 20110042707 A KR20110042707 A KR 20110042707A KR 1020090099503 A KR1020090099503 A KR 1020090099503A KR 20090099503 A KR20090099503 A KR 20090099503A KR 20110042707 A KR20110042707 A KR 20110042707A
Authority
KR
South Korea
Prior art keywords
information
parts list
image
web
parts
Prior art date
Application number
KR1020090099503A
Other languages
Korean (ko)
Inventor
김창수
현지연
Original Assignee
김창수
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 김창수 filed Critical 김창수
Priority to KR1020090099503A priority Critical patent/KR20110042707A/en
Publication of KR20110042707A publication Critical patent/KR20110042707A/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/50Information retrieval; Database structures therefor; File system structures therefor of still image data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0623Item investigation
    • G06Q30/0625Directed, with specific intent or strategy
    • G06Q30/0627Directed, with specific intent or strategy using item specifications
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0641Shopping interfaces
    • G06Q30/0643Graphical representation of items or shoppers
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/10Services

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Economics (AREA)
  • Finance (AREA)
  • Marketing (AREA)
  • Databases & Information Systems (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Development Economics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The present invention relates to a method of operating a web-based parts list management system comprising a database management system (DBMS), a client system, and a server system for storing and managing parts list information. The present invention provides a system management method comprising: an administrator mode step for a system operator to database image and text information of each parts list; Linking image data and text data of each component databased by a system operator to provide a user mode screen and to display to a customer on a web in three dimensions; And user mode customers logging in to a web site provided by a system operator, viewing a desired parts list, and ordering desired parts.

According to the implementation of the present invention, the image and text information of parts lists managed in a single file format (PDF, Word, Excel, etc.) is made into a database to share information, search and history management, and other systems (inventory management, order management, etc.). ), And customer service through website are possible.

Description

A method for operating a web-based parts list managing system}

The present invention relates to a system operating method for managing a parts list such as a machine on a web. In particular, the present invention provides a system operating method for managing parts list by linking image data and text data by making a database of parts list information managed in a file form.

In general, customers receive instruction manuals and parts catalogs in the form of books or files (PDF, Word, Excel, etc.). If a product breaks down or the dealer wants to repair the product, the customer will be charged for the required parts.

The parts catalog is in the form of images so that customers can easily find the parts, and the images are numbered in sequence, and next to the images, information such as the part number, part name, quantity, specification, price, etc. according to the number is written in TEXT form. .

Therefore, if a customer wants to buy a part, they can find it by calling the parts catalog, and then call and buy it after checking whether it is in stock or how much it is. At this time, the customer may have lost the parts catalog, or the parts may be changed due to the design change according to the production date, so that the parts catalog information that the customer has is not accurate. This leads to significant difficulty in purchasing parts, which can result in significant loss of time and money due to shipping mistakes if the customer is overseas. As a result, there was a constant demand for inquiry of necessary parts through web services from customers with the development of the Internet. However, due to the nature of the parts catalog where image data and TEXT data coexist, there was a considerable difficulty in displaying information in response to customer needs.

For this reason, existing systems are either inexpensive to download part catalogs in PDF format from the web, or at a high cost to provide programmers to create one web page per part catalog page. . In the former case, since the PDF file format, data such as real-time inventory information, price information, and design change information cannot be viewed. In the latter case, not only the initial development cost but also the maintenance cost are high, which increases the software price.

For this reason, it is necessary to prevent such unnecessary work, provide a database for efficiently managing the parts catalog, provide an administrator tool for linking image data with text data, and provide a smooth customer support method through web services.

The present invention has a first object of providing a system operating method capable of managing a list of parts list information managed in a file form and managing image data and text data in association.

In addition, the present invention has a second object of teaching a technique of providing parts list information to a customer through a website.

Other objects and advantages of this invention will become more apparent upon reading the detailed description of the invention described below and referring to the drawings.

It has a database management system (DBMS), a client system and a server system for storing and managing parts list information.

The DBMS is a business application integrated with the Service Information System, which manages product installation and after-sales information, parts information, claims information, and customer dissatisfaction information. It includes finance, human resources, manufacturing, sales, logistics and distribution. In addition, the system is equipped with SAP (Systems, Applications and Products in Data Processing) or ERP, which provides workflow functions for managing equipment and construction, documents are automatically delivered to users, and has the same structure for sharing data with existing systems. Has,

The client system may include a web-only browser for logging in and using the Internet; DLL file for showing parts list information executed in the above dedicated browser; and .Net Framework for interpreting the DLL file.

The server system includes Internet Information Services (IIS), a software service that supports web site creation, configuration, management, and other Internet functions; Windows server; Microsoft's .Net Frame Work, an integrated software package for PCs containing programming languages, and XML Web Services using Soap communication to communicate with DLL files in user browsers.

One embodiment of a method of operating a web-based parts list management system according to the present invention,

A manager mode step for the system operator to database the image and text information of each parts list;

Providing a user mode screen for displaying a stereoscopic image to a customer on a web by linking image data and text data of each part which is made by a system operator to a database; And

User mode Customers log in to the website provided by the system operator to view the desired parts list and order the desired parts.

It is characterized by including.

In this embodiment, the web browser is composed of a general area and a smart client area. In the smart client area (DLL file), the web server requests an XML web service from a web server, and the web server encapsulates the XML data in binary form in response thereto. It is preferable to return.

In this embodiment, it is preferable that the administrator mode screen and the general user mode screen work in the smart client area (DLL file).

In this embodiment, the hierarchy of .Net Framework above is

A web server based presentation layer;

An application server based business layer; And

It consists of backend layer based on database management system,

When the smart client area (DLL area) requests the web server for information related to the link of text data and image data for each part, the web service accesses the DBMS through the business layer (Vb.Net) and obtains the information. After that, it is preferably converted to XML format and returned to the smart client area (DLL file) and displayed on the user screen.

In this embodiment, the web-based parts list management system has a logical configuration of AS-IS / TO-BE, and the parts list information includes PDF, EXCEL, and word through this AS-IS / TO-BE configuration. When the administrator mode customer inputs the parts list file in the form of a file, it is desirable to show the drawing details, parts information details, design change information, manufacturing / manufacturing information, sales unit price information, and inventory information by the above input and the interface with ERP. Do.

In this embodiment, the database above,

It consists of the unique ID of the parts list, the product model, P_ID, the parent ID of the parts list, P_IMAGENO, the parent image number of the parts list, and P_SEQ, the parent serial number of the parts list. A base which is a parts list master for constructing a top-level information screen of a parts list;

An image data of a parts list including a parts list ID, a parts list image number IMAGE_NO, a parts list image name IMAGE_NAME, and a parts list image path IMAGE_PATH and having image information of the parts list specified by the base;

ID, IMAGE_NO, SEQ of sequence number of parts list image, TOP of position information of sequence number, LEFT of sequence information on left side of sequence, WIDTH of sequence width information, HEIGHT of sequence number information, HEIGHT of sequence number, POINT_TOP of point information It consists of POINT_LEFT, which is the left information, and the sequence number data and the part text data on the image are shared with the same KEY value, so that customers can see the part information and stock information when selecting the sequence number, and can be linked with the ordering system. A label which is sequence data to be climbed on the designated image data;

It consists of ID, IMAGE_NO, SEQ, part number PART_N0, part name PART_NAME, and part specification information SPEC.The information system including ERP is used to share information with other systems including inventory and order management through PART_NO. Component text data corresponding to the above image data; And

ID, IMAGE_N0, SEQ, application date information APPLY_DATE, PART_NO, PART_NAME, price information PRICE, consisting of part design change history information corresponding to the above part text data;

It is preferable to comprise.

In this embodiment, the output screen of the system is

An area for selecting a desired image among a plurality of images;

An area for displaying the selected image and for assembling the sub-parts;

An area for inputting a parts list;

Areas for managing models and subcomponents; And

A toolbox area for graphically displaying a number of tools;

It is desirable to provide.

In this embodiment, when the administrator mode customer wants to add a new image to an existing image in the database, it is preferable to load the image to be added from the folder where the image is located, and then download and store the image.

In this embodiment, the display of the assembly sequence number of the above components is preferably achieved by moving to a desired position to generate the assembly sequence number and creating or deleting the assembly sequence number.

In this embodiment, the function to manage the sub-components,

After selecting the desired part assembly number in the drawing display window, right-click and move to the subpart registration window through the pop-up menu. If there is a subpart, the part number is indicated in the first color. It is desirable to move.

In this embodiment, the system further provides a window for managing the design change information, in which the registration and deletion of the design change information, if the design change information is present, the sequence number is displayed in the second color and the second It is desirable to be able to inquire design change information by clicking the part marked with color.

In this embodiment, it is preferable to provide an enlargement and reduction function of the parts drawing and to move and enlarge the image by dragging the mouse.

In this embodiment, a function for storing data in a BOM structure in the above database, inquiring a desired level of data, and moving to a higher level;

A function of inquiring parts inventory information in association with an existing system;

A function of comparing the generated order number with the parts list data; And

The ability to provide part number, part name and balloon help;

It is desirable to provide.

According to the practice of the present invention, image and text information of parts lists managed in a single file format (PDF, Word, Excel, etc.) is made into a database so that information sharing, retrieval and history management, and other systems (inventory management, order management) Etc.), and customer service through website are possible.

The present invention prevents unnecessary work in the prior art, provides a database for efficiently managing a parts list, provides an administrator tool for linking image data and text data, and provides a customer support method through a web service. Hereinafter, with reference to the accompanying drawings will be described in detail the configuration and operation principle of the present invention.

1 shows a configuration of a web-based parts list management system according to the present invention. The system builds a database using legacy programs and data to ensure that their applications can be used under any operating system.

The legacy system 800 of the present invention is composed of a Service Information System (SIS) 500, a DB server 510, and Systems, Applications and Products in Data Processing (SAP) 520. The SIS 500 innovates the service information management system and process to create a foundation for promptly responding to various customer complaints at home and abroad, and manages product installation, A / S information, parts information, claims information, and customer dissatisfaction information. It plays a role. The SAP 520 is an integrated business application using a database that provides financial, human resources, manufacturing, sales, logistics / distribution, facilities and construction management functions as well as a workflow function where documents are automatically delivered to users. The SIS system 500 is interoperable with the parts list system 900 and uses Internet Information Services (IIS), Windows Server, and .Net Framework for this purpose.

IIS is a software service that supports Web site creation, configuration, management, and other Internet features. Internet Information Services includes Network News Transfer Protocol (NNTP), File Transfer Protocol (FTP), and Simple Mail Transfer Protocol (SMTP). .

The .Net Framework is an integrated software package for PCs that includes programming languages.

Parts list system 900 uses the .Net SmartClient method, Partslist.dll, XML Web Service. The legacy system 800 may be accessed by an office or a factory 1000 or an A / S branch, an agency, or an overseas corporation 1100 through a login through a wired or wireless Internet. Office or factory (1000), after-sales branch, distributor, overseas corporation (1100) has a web-only browser (1010), Partslist.dll (1020) and .Net Framework (1030), a program for using Web services. Doing. Here, Partslist.dll 1020 is a file that stores various functions related to the parts list or an execution routine that performs a set of these functions.

FIG. 2 shows the internal system configuration of the system of FIG. 1 as well as the concept of customer service through a web site. The web-only browser 1010 is composed of a general area 1011 and a smart client area 1012, the general area 1011 is made of HTML, VB Script and Java Script, and the smart client area 1012. It consists of Net Framework and partslist.dll. With this environment in place, a customer logs into the legacy system 800 using a web-only browser 1010 and then presents the presentation layer 1030, business layer 1040, and backend layer ( 1050) to receive customer service provided by the website.

The web browser 1010 communicates with the web server 530 at the presentation layer 1030. The web server 530 is provided with HTML and a DLL file (partslist.dll). Presentation layer 1030 communicates with application server 540 at business layer 1040. The application server 540 is equipped with ASP Net, XML Web Service, and VB Net. The smart client area (DLL file) 1012 in the web browser 1010 returns XML data to an XML Web service in the application server 540 when the business layer 1040 requests XML data through SOAP communication. At this time, XML data is encapsulated and transmitted in binary form. The business layer 1040 then stores or calls the corresponding data in the database management system (DBMS) 550 at the back end layer 1050 via ADO.NET. The web site also includes the .Net Framework 560.

Generally, HTML, JavaScript, and VBScript provided by the web have difficulty in displaying parts list information. Therefore, this invention uses XML Web Service using Soap communication to show data at high speed, and adopts .Net SmartClient method provided by Microsoft company to provide colorful UI (User Interface) screen.

In the present invention, a web browser is composed of a general area and a smart client area, and a smart client area (DLL file) requests an XML web service from a web server, and the web server encapsulates and returns XML data in binary form in response. It is desirable to.

In the present invention, it is preferable that the administrator mode screen and the general user mode screen work in the smart client area (DLL file).

3 shows a logical diagram of an AS-IS / TO-BE according to the present invention. The AS-IS 500 holds various parts lists in a file format (PDF, EXCEL, Word). Administrator Mode When a customer enters a parts list file, the above details and the interface with the ERP system (enterprise resource planning system) 400 make it easy to view detailed drawings, parts information, design changes, and manufacturing / manufacturing information. , Selling unit price information and inventory information.

4a shows the structure of a database according to this invention. The database of this invention consists of a base 10, an image 20, a label 30, part information 40 and a part history 50. The base 10 includes information on a parts list unique ID, a product model, a parts list parent ID P_ID (parent ID), a parts image parent image number P_IMAGENO, and a parts list image sequence SEQ. The contents of the base 10 are linked to the image 20, and the image 20 has an ID, a part list image number IMAGE_NO, a part list image name IMAGE_NAME, and a part image. Image 20 is connected in parallel with label 30 and part information 40. The label 30 includes ID, IMAGE_NO, SEQ, sequence position information TOP, sequence position left information LEFT, sequence width information WIDTH, sequence height information HEIGHT, and points of the sequence. It consists of the above position information POINT_TOP, the left information of the point POINT_LEFT, part information 40 is ID, IMAGE_NO, SEQ, part number PART_NO, part name PART_NAME and part information 40 is the part history (50) and It is connected in series. The part history 50 is provided with ID, IMAGE_NO, SEQ, APPLY_DATE, PART_NO, PART_NAME, which is application date information, and PRICE information, which is price information.

Meanwhile, in FIG. 4A, the image 20 is image information, the label 30 is position information of a sequence to be included in the image, the part information 40 is part text information, and the part history 50 is history information of the part. And the small circles in FIGS. 4A and 4B mean that there may be no data.

Fig. 5 shows the main configuration of the screen work area of this invention manager mode. 110 shows an image selection area, 120 shows an image and sequence area, 130 shows a parts list input area, 140 shows a model and subpart selection area, and 150 shows a toolbox area.

In this example, two images are selected at 110, and 120 represents the region of the first one of the images selected at 110. 130 indicates a part number and serial number, 140 indicates a model is VX, and a lower part selection area is group 01 of Group 2. In the present invention, the screen work area provides a GUI (Graphic User Interface) environment in which a user can conveniently manage image, sequence, and part information data.

6 shows an example of managing an image in this invention manager mode. 160 shows an example of an increase in image addition, and 170 shows that buttons for loading, adding, or downloading images are installed. The upper right window of FIG. 6 is a window for loading an image, which can be selected by clicking an image to be loaded in an input box of this window, and inputs a file name to download and store the image in the input box of the lower right window.

7 shows an example of sequence management in this invention manager mode. 180 indicates a case where a sequence number is generated and moved to a desired position, and when there is a starting point, it moves to a starting point. 190 represents an example of sequence generation or deletion. In other words, if you click on the small square (light blue) in the part marked 180, the 16th part number will be automatically assigned as shown in 190, and will be displayed like the right part of the drawing (light blue rectangle), and the new part number will be given here. The user can enter a group name. In the present invention, the sequence number is a key value to be connected with the part information data, is also connected to the lower part, design change information, inventory information, it is possible to move the position using the mouse after generating the sequence number.

8 shows an example of the lower part management in this invention manager mode. If 200 is a right mouse click on the sequence and selects 'Add Sub-Parts' in pop-up menu, it goes to window 210 and shows the example of registering sub-parts. 220 shows the sequence number in orange when there are sub-parts. An example of moving to the lower part upon clicking, 230 shows an example of classification of groups. In this invention, the sub-parts can be continuously registered and managed by a bill of materials (BOM) structure.

9 shows an example of management of design change information in this invention manager mode. 240 shows an example of registering design change information by right-clicking on the sequence number and selecting 'Register snow information' from the pop-up menu, and 250 shows green sequence number (in this example, number 4) when design change information exists. Click this sequence to show design change information.

Fig. 10 illustrates the zoom function of the part drawing in this invention user mode. The 260 shows a zoom function by dragging the mouse, the 270 shows a 40% reduction, and the 280 shows a 200% zoom. In this invention, zooming from 30% to 500% is possible.

11 illustrates other functions in this invention user mode. 290 is a bill of materials (BOM) structure in which data is stored to look up the desired level of data, and it is possible to move to a higher level. 300 is a function window for inquiring parts stock information in connection with the existing system. , 310 indicates the generated sequence number and parts list data comparison function window, and 320 provides the part number, part name, and balloon help function.

12 illustrates buttons and functions in an administrator mode of a user screen according to the present invention. There are two user screens: administrator mode and normal user mode. The manager mode provides a function to register, add, delete, and modify image data, sequence data, and part information data of a parts list. 12A shows an administrator mode button and function, and FIG. 12B shows a user mode button and function.

12A illustrates a manager mode button and a function when registering a model and subparts. The buttons are largely classified into buttons used for model and sub-part registration, buttons for managing order and part data, and buttons used for managing drawing images. The buttons used to register models and sub-parts are 'New model and sub-parts' button, 'Save model and sub-parts' button, and 'Delete model and sub-parts' button.The buttons are used to manage sequence and part data. There are 'Add Sequence' button, 'Delete Sequence' button, 'Copy Excel Data to Part Data' button, and 'Compare Sequence Data to Part Data' button. There are 'Add Image' and 'Download Image' buttons.

On the other hand, the user mode can query the registered parts list information, can be expanded / reduced, can query the information in conjunction with other systems such as inventory information, and can provide functions such as parts order and shopping cart. 12B shows buttons and functions in the user mode. The user mode buttons include 'move mode', 'enlarge mode', 'image reduction' and 'add to cart' button. In particular, the 'move mode' is to move the image when the mouse is dragged, and provides a function to enlarge the image when dragging the mouse.

Fig. 13 illustrates the add shopping cart function of the present invention user mode. The add to cart function is used to order parts. 330 shows the process of adding to the shopping cart through the pop-up menu after right-clicking on the sequence number, and 340 shows the selected parts when the shopping cart is checked, and the order system is created after confirmation.

14 is a flowchart of a web-based parts list management system operating method according to the present invention. In the present invention, the system operator first provides an administrator mode for databaseting the image and text information of the parts list according to the structure described above (S10), and then the user mode screen for associating the image data with the text data (FIG. 5 to FIG. 11) (S20). Then, the customer logs in to the web site provided by the system operator, looks up the desired parts list and orders the desired parts (S30).

When the system operator (system server) instructs the department to deliver the ordered parts to the customer, the department delivers the ordered parts to the customer. The most important steps in this invention are in S10 and S20. In other words, image data and text data of parts could not be provided to customers at one time, and this required considerable time and expense because web parts had to be built at a huge cost for every part. Therefore, technology with the same function as S10 was not provided. However, in the present invention, the image data and text data of the parts are stored in a database, and the customer screen connected to the Internet through the manager screen built in this invention can easily retrieve images and texts of specific parts in the database through the manager screen. It is very convenient because it comes in one screen. In addition to the customers who want to purchase parts, as well as companies that want to provide product information such as parts to customers, the technology of this invention makes it easy to build relevant information in a database and provide it to customers through the administrator screen. And high industrial value. Building a database can be accomplished easily by those skilled in the art using conventional techniques. In addition, the technology for providing the manager screen may be easily implemented by those skilled in the art through the contents shown in FIGS. 1 to 14 and detailed description thereof.

As such, the present invention may be variously modified and may take various forms and only the specific embodiments thereof are described above. It is to be understood, however, that the present invention is not limited to the specific forms mentioned above, but rather includes all modifications, equivalents, and substitutions within the spirit and scope of the invention as defined by the appended claims. .

This invention can be widely used in a place which handles various parts, such as an automobile and an electronic product, a manufacturer of these parts, and the design office which designs these parts, and is highly industrially applicable.

1 is a block diagram of a web-based parts list management system according to the present invention.

2 is an internal system configuration diagram of the system of FIG.

3 is a logical diagram of an AS-IS / TO-BE according to the present invention;

4 is a structural diagram of a database according to the present invention;

5 is a main configuration diagram of a screen work area according to the present invention;

6 is an exemplary image management diagram according to the present invention.

7 is a sequence management example according to the present invention.

8 is an exemplary lower part management according to the present invention.

9 is an exemplary diagram of snow information management according to the present invention;

Figure 10 is an exemplary zoom function according to the present invention.

11 is an illustration of other functions according to the present invention.

12 is an exemplary view of buttons and functions in an administrator mode of a user screen according to the present invention.

Figure 13 is an exemplary view of the shopping cart add function according to the present invention.

14 is a flowchart of a web-based parts list management system operating method according to the present invention.

<Description of Symbols for Main Parts of Drawings>

10: base 20: image

30: label 40: part information

50: Part History 110: Image Selection Area

120: image and sequence area 130: parts list input area

140: Model and Subpart Selection Area 150: Toolbox Area

160: example of an increase in image addition

170: Additional image import examples

180: example of generating a sequence number and moving to a desired position

190: Create and delete sequence numbers

200: Right-click on the sequence and register sub-parts through pop-up menu

210: Go to the screen to register subparts

220: If there are subparts, the sequence number is displayed in orange, and moving to the subparts when double-clicking

230: Classification example of a group

240: Right-click on the sequence and register the change information through the pop-up menu

250: If there is snow information, the order number is displayed in green, and when clicked, the snow information can be seen.

260: Zoom in by mouse drag 270: 40% zoom out

280: 200% magnification

290: Data is saved in BOM structure, the data of the desired level is inquired, and the upper level can be moved.

300: Display part stock information in connection with existing system

310: Compare the generated sequence number and parts list data

320: Part Number, Part Name, Balloon Help Function

330: Add a shopping cart to the part to buy 340: Check the shopping cart history

400: ERP 500: AS-IS, SIS system

510: DB server 520: SAP

600: database converter 700: TO-BE

800: Legacy System 900: Parts List System

Claims (13)

It has a database management system (DBMS), a client system and a server system for storing and managing parts list information. The DBMS is a business application integrated with the Service Information System, which manages product installation and after-sales information, parts information, claims information, and customer dissatisfaction information. It includes finance, human resources, manufacturing, sales, logistics and distribution. It has the same structure for data sharing, with SAP (Systems, Applications and Products in Data Processing) or ERP, which provides workflow functions for managing equipment and construction and documents automatically delivered to users. The client system may include a web-only browser for logging in and using the Internet; DLL file for showing parts list information executed in the above dedicated browser; and .Net Framework for interpreting the DLL file. The server system includes Internet Information Services (IIS), a software service that supports web site creation, configuration, management, and other Internet functions; Windows server; Microsoft's .Net Frame Work, an integrated software package for PCs containing programming languages, and XML Web Services using Soap communication to communicate with DLL files in the user's browser. In the operation method of the web-based parts list management system, A manager mode step for the system operator to database the image and text information of each parts list; Providing a user mode screen for displaying a stereoscopic image to a customer on a web by linking image data and text data of each part which is made by a system operator to a database; And User mode Customers log in to the website provided by the system operator to view the desired parts list and order the desired parts. Characterized in that the operating method of the web-based parts list management system. 2. The web browser of claim 1, wherein the web browser is composed of a general area and a smart client area, and the smart client area (DLL file) requests an XML web service from a web server, and the web server responds to the XML data in binary form. Web-based parts list management system operating method, characterized in that the return to encapsulation. The method of claim 2, wherein the administrator mode screen and the general user mode screen operate in a smart client area (DLL file). The hierarchical structure of claim 2 wherein A web server based presentation layer; An application server based business layer; And It consists of backend layer based on database management system, When the smart client area (DLL area) requests the web server for information related to the link of text data and image data related to each part, the web service accesses the DBMS through the business layer (Vb.Net) and obtains the information. The web-based parts list management system operating method, which is converted into XML format and returned to the smart client area (DLL file) and displayed on the user screen. The web-based parts list management system has a logical configuration of AS-IS / TO-BE, and the parts list information includes PDF, EXCEL, and word through the AS-IS / TO-BE configuration. When a manager mode customer inputs a parts list file in the form of a file, the drawing details, parts information details, design change information, manufacturing / manufacturing information, sales unit price information, and inventory information are displayed by the above input and interface with ERP. A method of operating a web-based parts list management system. The method of claim 1, wherein the database, It consists of the unique ID of the parts list, the product model, P_ID, the parent ID of the parts list, P_IMAGENO, the parent image number of the parts list, and P_SEQ, the parent serial number of the parts list. A base which is a parts list master for constructing a top-level information screen of a parts list; An image data of a parts list including a parts list ID, a parts list image number IMAGE_NO, a parts list image name IMAGE_NAME, and a parts list image path IMAGE_PATH and having image information of the parts list specified by the base; ID, IMAGE_NO, SEQ of sequence number of parts list image, TOP of position information of sequence number, LEFT of sequence information on left side of sequence, WIDTH of sequence width information, HEIGHT of sequence number information, HEIGHT of sequence number, POINT_TOP of point information It consists of POINT_LEFT, which is the left information, and the sequence number data and the part text data on the image are shared with the same KEY value, so that customers can see the part information and stock information when selecting the sequence number, and can be linked with the ordering system. A label which is sequence data to be climbed on the designated image data; It consists of ID, IMAGE_NO, SEQ, part number PART_N0, part name PART_NAME, and part specification information SPEC.The information system including ERP is used to share information with other systems including inventory and order management through PART_NO. Component text data corresponding to the above image data; And ID, IMAGE_N0, SEQ, application date information APPLY_DATE, PART_NO, PART_NAME, price information PRICE, consisting of part design change history information corresponding to the above part text data; Web-based parts list management system operating method, characterized in that comprises a. According to claim 1, The output screen of the system, An area for selecting a desired image among a plurality of images; An area for displaying the selected image and for assembling the sub-parts; An area for inputting a parts list; Areas for managing models and subcomponents; And A toolbox area for graphically displaying a number of tools; Web-based parts list management system operating method, characterized in that to provide. According to claim 1, If the administrator mode customer wants to add a new image to the existing image in the database, after loading the image to be added from the folder where the image is located, and downloads and stores the image, Web How to operate a based parts list management system. The method of claim 7, wherein the display of the assembly sequence number of the component is achieved by moving to a desired position to generate the assembly sequence number and generating or deleting the assembly sequence number. The method of claim 7, wherein the function of managing the lower parts, In the drawing display window, select the desired part assembly sequence number, then right-click and move to the subpart registration window through the pop-up menu. A web-based parts list management system operating method, characterized in that the movement. The system of claim 1, wherein the system further provides a window for managing design change information, wherein the design change information is registered and deleted in this window, and if the design change information is present, the sequence number is indicated by a second color and the second color is changed. How to operate the web-based parts list management system, characterized in that the design change information can be inquired by clicking the color-coded part of the. The method of claim 1, wherein the component drawing enlargement and reduction function is provided, and the image is moved and enlarged by dragging the mouse. The method of claim 1, A function for storing data in a BOM structure in the above database, inquiring desired level of data, and moving to a higher level; A function of inquiring parts inventory information in association with an existing system; A function of comparing the generated order number with the parts list data; And The ability to provide part number, part name and balloon help; Method for operating a web-based parts list management system, characterized in that to provide.
KR1020090099503A 2009-10-20 2009-10-20 A method for operating a web-based parts list managing system KR20110042707A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
KR1020090099503A KR20110042707A (en) 2009-10-20 2009-10-20 A method for operating a web-based parts list managing system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
KR1020090099503A KR20110042707A (en) 2009-10-20 2009-10-20 A method for operating a web-based parts list managing system

Publications (1)

Publication Number Publication Date
KR20110042707A true KR20110042707A (en) 2011-04-27

Family

ID=44048078

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020090099503A KR20110042707A (en) 2009-10-20 2009-10-20 A method for operating a web-based parts list managing system

Country Status (1)

Country Link
KR (1) KR20110042707A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR102055920B1 (en) * 2018-12-19 2019-12-13 (주)린치핀 Method and system for providing online parts book service
KR102484760B1 (en) * 2022-07-13 2023-01-06 (주)이로젠 System for synchronizing component information and library information and method thereof
KR102591318B1 (en) * 2022-11-10 2023-10-19 (주)이로젠 System for modeling 3D electric circuit comprising auto routing function and method thereof

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR102055920B1 (en) * 2018-12-19 2019-12-13 (주)린치핀 Method and system for providing online parts book service
KR102484760B1 (en) * 2022-07-13 2023-01-06 (주)이로젠 System for synchronizing component information and library information and method thereof
KR102591318B1 (en) * 2022-11-10 2023-10-19 (주)이로젠 System for modeling 3D electric circuit comprising auto routing function and method thereof

Similar Documents

Publication Publication Date Title
US7543005B1 (en) Web site content change management
US8407664B2 (en) Software model business objects
US6662199B1 (en) Method and apparatus for customized hosted applications
US7366723B2 (en) Visual query modeling for configurable patterns
US6700590B1 (en) System and method for retrieving and presenting data using class-based component and view model
US8448137B2 (en) Software model integration scenarios
US8316344B2 (en) Software model deployment units
US8838627B2 (en) Systems and methods for providing template based output management
US11126968B2 (en) Custom application builder for supply chain management
US20030189600A1 (en) Defining an approval process for requests for approval
US20060112123A1 (en) Spreadsheet user-interfaced business data visualization and publishing system
US20070067338A1 (en) System for supporting introduction/operation of enterprise resource planning software
US20110173529A1 (en) Template processing engine for business systems
ITMI20130390U1 (en) METHODS AND SYSTEM FOR DYNAMIC ENDPOINT GENERATORS, DETECTION AND MEDIATION (BROKERAGE) OF DYNAMIC REMOTE OBJECTS
JP2008511935A (en) User interface for data integration systems
GB2543003A (en) System including a server and multiple mobile computing devices
WO2010144329A1 (en) Systems and methods for metadata driven dynamic web services
CN104050229A (en) System And Method For Providing Commercial Functionality From A Product Data Sheet
KR20110042707A (en) A method for operating a web-based parts list managing system
JP2004252951A (en) Introductory operation support system for integrated business software
US11036763B2 (en) Flexible organizational hierarchy
Brambilla et al. Model-driven design of service-enabled web applications
KR20000063910A (en) Interior material electronic commerce system and method using the internet
Kim et al. Cost information model for managing multiple projects
KR100656152B1 (en) Method and apparatus for providing content and module lent in connection with service

Legal Events

Date Code Title Description
A201 Request for examination
E902 Notification of reason for refusal
E701 Decision to grant or registration of patent right
NORF Unpaid initial registration fee