CN103646304A - A automobile fitting data management system based on a Delphi - Google Patents
A automobile fitting data management system based on a Delphi Download PDFInfo
- Publication number
- CN103646304A CN103646304A CN201310595402.6A CN201310595402A CN103646304A CN 103646304 A CN103646304 A CN 103646304A CN 201310595402 A CN201310595402 A CN 201310595402A CN 103646304 A CN103646304 A CN 103646304A
- Authority
- CN
- China
- Prior art keywords
- accessory
- delphi
- management system
- maintenance items
- auto parts
- 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
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a database exploitation application system, and especially relates to an automobile fitting data management system based on a Delphi. Customer information of users who enter 4S stores is recorded. Correlation is established between the client information and maintenance items related to clients, and the information is stored. The client information comprises account names and login passwords. According to content of the maintenance items, fitting categories and stock conditions in a database are called to process the client inoformation, and processed results are printed. The system based on the Delphi can carry out designing and programming in a short time, and continuously carry out correction, improvement and perfection. The assembly function is strong. The efficiency is high. Properties such as conciseness and beauty are realized. In addition, the system based on the Delphi is easy to operate.
Description
Technical field
The present invention relates to database development application system, especially a kind of based on Delphi auto parts machinery management system.
Background technology
Along with the continuous expansion of expanding economy and China Auto Market, auto parts machinery market has vast potential for future development.The customer quantity in automobile 4s shop increases, increase in demand, and various service business refinements, all departments' workload also increases thereupon.In order to meet the various demands of 4s shop to auto parts machinery management modernization, use computer technology to carry out typing to auto parts machinery data management system.Realization to the fast search of the various parts of dissimilar automobile, collection, location, extract and append, both can overcome all inconvenience that the staff on after sale service foreground manually managed in the past, can make again front desk service succinct, clear and definite and reasonable; They are freed from loaded down with trivial details affairs, greatly improved work efficiency.
The function singleness shortcoming of traditional Delphi, is a kind of single programming development software, and it is excessively of a specified duration that realization logs in the startup page time, and window ejects too slow, has reduced greatly the efficiency of work.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of system that overcomes above-mentioned shortcoming, described system is to combine the advantage that Delphi compilation function is strong, efficiency is high, Microsoft Jet Database Engine and two features of graphic user interface with Access, it is relevant database, is again data base management system (DBMS).
The technical scheme that the present invention solves the problems of the technologies described above is as follows: a kind of based on Delphi auto parts machinery management system, affiliated system comprises:
Recording user is to the customer data in 4S shop, and stores after described customer data maintenance items relevant to client is associated, and described customer data comprises account name and login password;
According to accessory classification and the inventories in the content calling data storehouse of maintenance items, process customer data, and result is printed.
On the basis of technique scheme, the present invention can also do following improvement.
Further, log in client's account name, to described system setting, arrange comprise password revise, about system, log off, it is for the password of login user name is modified that described password is revised; Described about system be for to the version information of system, described in the correlation function that possesses, and programming personnel's relevant information; Described logging off is for user log off, and simultaneously described system ejects inquiry session frame, is confirmed whether to log off.
Further, described maintenance items, for maintenance items, project ownership, unit price and the required duration of maintaining are inquired about, can " be added " or " deletion " project particular content in described maintenance items.
Further, described service management comprises accessory classification and inventories, described accessory classification is for classification, vehicle and the required warehouse location of depositing described in physical planning accessory, different brands, model vehicle body fittings type are carried out to careful division, make staff easy-to-look-up in auto repair, add and delete determined accessory model; Described inventories, for recording means stock's actual conditions, are made careful record to the warehouse-in of accessory, outbound, make the inventories of accessory more transparent, clear.
Further, the described classification of the accessory according to the content calling data storehouse of maintenance items and inventories are processed customer data, and details are as follows:
According to accessory classification and the inventories of the content search database of the maintenance items that needs after detecting to change, whether add or delete accessory, if so, in database, add or delete accessory, if not, not processing.
Further, described database is the Access based on Ado connected mode, for data storage, inquiry, Pages Design, report generation.
The invention has the beneficial effects as follows: the described system based on Delphi can design and programme in the short time, and constantly revise, Improvement and perfection, compilation function strong, efficiency is high, succinct, attractive in appearance, easy operating.
Accompanying drawing explanation
Fig. 1 is auto parts machinery data management system structural drawing of the present invention;
Fig. 2 is auto parts machinery data management system log-in interface figure of the present invention;
Fig. 3 is the main surface chart of auto parts machinery data management system of the present invention;
Fig. 4 is auto parts machinery data management system customer data surface chart of the present invention;
Fig. 5 is auto parts machinery data management system customer data data chart of the present invention.
Embodiment
Below in conjunction with accompanying drawing, principle of the present invention and feature are described, example, only for explaining the present invention, is not intended to limit scope of the present invention.
If Fig. 1 is auto parts machinery data management system structural drawing of the present invention, details are as follows:
Recording user is to the customer data in 4S shop, and stores after described customer data maintenance items relevant to client is associated, and described customer data comprises account name and login password;
According to accessory classification and the inventories in the content calling data storehouse of maintenance items, process customer data, and result is printed.
Described system also comprises the account name that logs in client, to described system setting, arrange comprise password revise, about system, log off, it is for the password of login user name is modified that described password is revised; Described about system be for to the version information of system, described in the correlation function that possesses, and programming personnel's relevant information; Described logging off is for user log off, and simultaneously described system ejects inquiry session frame, is confirmed whether to log off.
If Fig. 2 is auto parts machinery data management system log-in interface figure of the present invention, details are as follows:
Log-in interface Form1 window is mainly by 2 Button, 2 Edit, a Panel(wherein comprises a Label for " 4S shop auto parts machinery data management system "), 2 Label are respectively user name and login password, and an Image figure beautifies the assembly at interface.The assembly of Button, when opening log-in interface, after username and password input, is clicked " confirmations " button, and system is to user name and log in password and judge, both correctly after, can enter subordinate's menu.For example, the user name in literary composition and log in password: after Zhang San and 123. these two information of input, system there will be dialog box, and " welcome enters 4S shop auto parts machinery data management system " simultaneously can the main interface of automatic spring.
If Fig. 3 is the main surface chart of auto parts machinery data management system of the present invention, details are as follows:
When specific functional modules is divided in programming, set up 4 Panel assemblies by each function distinguishing, and Label and Button assembly are set in each Panel device region, be used for arranging each button and connect.Simultaneously the main interface of described system also possesses the time clock feature of current date, and in interface, each Button assembly can link a new interface, deliberately makes that operator is convenient and swift enters new interface.For example link the 4th new interface code as follows:
Procedure?TForm2.Button?Click(Sender:TObject);
Begin
Form4.show: // the 4th page entered.
End；
As 4 being auto parts machinery data management system customer data surface chart of the present invention, details are as follows:
Take customer data interface processes as example, and described processing is divided into design and analysis, and other major function interfaces are similar to the implementation of programming.This interface has condition query, interpolation and delete function, the main Button in interface, Label, DBGrid, the assemblies such as ADO Connection, ADO Query, Data Source.
(1) add button: change the Readonly in DBGrid attribute into False, can make database possess the function of revising and editing, click after " interpolation " button, can on the new Data Position adding, edit new customer information.Partial code is as follows:
if?ADOQuery1.active=False?then?exit;
ADOQuery1.Append；
ADOQuery1.Field By Name (' customer name ') .asstring:=' ';
ADOQuery1.Field By Name (' client's classification ') .asstring:=' ';
ADOQuery1.Field By Name (' contact address ') .asstring:=' ';
ADOQuery1.Field By Name (' postcode ') .asstring:=' ';
ADOQuery1.Field By Name (' phone ') .asstring:=' ';
ADOQuery1.Field By Name (' information of vehicles ') .asstring:=' ';
ADOQuery1.Post；
(2) delete button: click the data that will delete, then, then click " deletion " button on the page.Whether system can be pointed out and delete. and after selecting " Yes ", this information will be deleted, and partial code is as follows:
if?ADOQuery1.Record?Count=0then
begin
Application.Message Box (could delete by e no record! : prompting j0 ten
MB—ICONINFORMATION)；
exit；
end；
if?ADOQuery1.Is?Empty?then
exit；
If ID-YES=application.Message Box (will delete this note really
Record j prompting: MB YESNO) then
begin
ADOQuery1.Delete；
Application.Message Box (deletion record success f j prompting j0+
MB_ICONINFORMATION)；
end；
(3) inquire button: select " client's classification " or " information of vehicles " to inquire about on upper left side, interface, input any condition of required inquiry, click inquiry, system will be selected the content that user will inquire about by Automatic sieve.Main code is as follows:
with?ADOQuery1.do
begin
close；
sql.clear；
Sql.add[Format (" select wood from customer data where customer class
Not=%s or information of vehicles=%S:[Quoted Str (Editl.Text), Quoted Str (
Edit2.Text)]))；
open；
end；
(4) show all: click " showing all " button, all the elements in database can be shown.
(5) upper one and next button: selected, after the wherein information in database, if inquire about one or next content, can click " upper one ", " next " button.
(6) return push-button: click the Back button, can the closing function page, turn back to main interface.
Be illustrated in figure 5 auto parts machinery data management system customer data data chart of the present invention, details are as follows:
Utilize Microsoft Access2003 to needing the database of using to set up in the auto parts machinery data management system of 4S shop, open Microsoft Access2003, select after the hollow Access database of newdata storehouse, click OK button, selecting paths, file is called " customer data .mdb ", and preserving type is Microsoft Access database.Click establishment, required content of filling in table is filled in to rear preservation, the building work of database has just completed the Data Access assembly page of database access component in Delphi element panels.Select Data Source assembly, Data Source assembly is the very important assembly of commonly using in the application program of development data storehouse, is the link medium of data set assembly and Data Control assembly.What Data Control assembly often can be used is exactly DBGrid control, and it utilizes Data Source attribute to obtain data, data writing and demonstration data from data centralization conventionally.
Described 4S shop auto parts machinery data management system is used ADO assembly page, conventional ADO Query assembly in program, click its assembly, its attribute Connection String is arranged, click " Build ... " button, there is data connection attribute dialog box, select data-droved engine " Microsoft Jet4.0OLE DB Provid--er ", input database title " customer data .mdb ", click " test connects " button, eject the dialog box of " connection of Microsoft data ", click " determining " button and test.After test successful connection, click " determining " button of " data connection attribute " dialog box, select database to connect, after successful connection.Select Ta-ble Name attribute, Active setup of attribute is True, the connection of database has just completed like this.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (6)
1. based on a Delphi auto parts machinery management system, it is characterized in that, described system comprises:
Recording user is to the customer data in 4S shop, and stores after described customer data maintenance items relevant to client is associated, and described customer data comprises account name and login password;
According to accessory classification and the inventories in the content calling data storehouse of maintenance items, process customer data, and result is printed.
2. according to claim 1 a kind ofly it is characterized in that based on Delphi auto parts machinery management system, described system also comprises:
Log in client's account name, to described system setting, arrange comprise password revise, about system, log off;
It is for the password of login user name is modified that described password is revised; Described about system be for to the version information of system, described in the correlation function that possesses, and programming personnel's relevant information; Described logging off is for user log off, and simultaneously described system ejects inquiry session frame, is confirmed whether to log off.
3. according to claim 1 a kind of based on Delphi auto parts machinery management system, it is characterized in that, described maintenance items, for maintenance items, project ownership, unit price and the required duration of maintaining are inquired about, can " be added " or " deletion " project particular content in described maintenance items.
4. according to claim 1 a kind of based on Delphi auto parts machinery management system, it is characterized in that, described service management comprises accessory classification and inventories, described accessory classification is for classification, vehicle and the required warehouse location of depositing described in physical planning accessory, different brands, model vehicle body fittings type are carried out to careful division, make staff easy-to-look-up in auto repair, add and delete determined accessory model; Described inventories, for recording means stock's actual conditions, are made careful record to the warehouse-in of accessory, outbound, make the inventories of accessory more transparent, clear.
5. according to claim 1 a kind ofly it is characterized in that based on Delphi auto parts machinery management system, the described classification of the accessory according to the content calling data storehouse of maintenance items and inventories processing customer data, details are as follows:
According to accessory classification and the inventories of the content search database of the maintenance items that needs after detecting to change, whether add or delete accessory, if so, in database, add or delete accessory, if not, not processing.
6. according to claim 1 a kind ofly it is characterized in that based on Delphi auto parts machinery management system, described database is the Access based on Ado connected mode, for data storage, inquiry, Pages Design, report generation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310595402.6A CN103646304A (en) | 2013-11-21 | 2013-11-21 | A automobile fitting data management system based on a Delphi |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310595402.6A CN103646304A (en) | 2013-11-21 | 2013-11-21 | A automobile fitting data management system based on a Delphi |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103646304A true CN103646304A (en) | 2014-03-19 |
Family
ID=50251515
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310595402.6A Pending CN103646304A (en) | 2013-11-21 | 2013-11-21 | A automobile fitting data management system based on a Delphi |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103646304A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104978417A (en) * | 2015-06-29 | 2015-10-14 | 江苏鸿信系统集成有限公司 | Mobile device based standby unit management method |
| CN107392553A (en) * | 2017-08-23 | 2017-11-24 | 天津市深大天星科技发展有限公司 | Vehicle maintenance management method and system |
| CN107679137A (en) * | 2017-09-22 | 2018-02-09 | 浙江第元信息技术有限公司 | Automobile Service data record method based on Version Control |
| CN108733817A (en) * | 2018-05-21 | 2018-11-02 | 江苏省节能工程设计研究院有限公司 | A kind of system and method for store keeping |
| CN110263941A (en) * | 2018-03-12 | 2019-09-20 | 中国石油天然气股份有限公司 | equipment maintenance method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101419684A (en) * | 2008-12-11 | 2009-04-29 | 徐立 | Interactive customer relationship management system in automobile industry |
| CN102385721A (en) * | 2011-10-17 | 2012-03-21 | 徐宗保 | Customer management system |
| CN102456163A (en) * | 2010-10-27 | 2012-05-16 | 镇江华扬信息科技有限公司 | Automobile maintenance management system |
| CN102456172A (en) * | 2010-10-19 | 2012-05-16 | 陈亿龙 | Smart automobile maintenance and management method |
-
2013
- 2013-11-21 CN CN201310595402.6A patent/CN103646304A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101419684A (en) * | 2008-12-11 | 2009-04-29 | 徐立 | Interactive customer relationship management system in automobile industry |
| CN102456172A (en) * | 2010-10-19 | 2012-05-16 | 陈亿龙 | Smart automobile maintenance and management method |
| CN102456163A (en) * | 2010-10-27 | 2012-05-16 | 镇江华扬信息科技有限公司 | Automobile maintenance management system |
| CN102385721A (en) * | 2011-10-17 | 2012-03-21 | 徐宗保 | Customer management system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104978417A (en) * | 2015-06-29 | 2015-10-14 | 江苏鸿信系统集成有限公司 | Mobile device based standby unit management method |
| CN107392553A (en) * | 2017-08-23 | 2017-11-24 | 天津市深大天星科技发展有限公司 | Vehicle maintenance management method and system |
| CN107679137A (en) * | 2017-09-22 | 2018-02-09 | 浙江第元信息技术有限公司 | Automobile Service data record method based on Version Control |
| CN110263941A (en) * | 2018-03-12 | 2019-09-20 | 中国石油天然气股份有限公司 | equipment maintenance method and device |
| CN108733817A (en) * | 2018-05-21 | 2018-11-02 | 江苏省节能工程设计研究院有限公司 | A kind of system and method for store keeping |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103646304A (en) | A automobile fitting data management system based on a Delphi | |
| US9361464B2 (en) | Versatile log system | |
| US11934460B2 (en) | Linking business objects and documents | |
| CN102207948B (en) | Method for generating incident statement sentence material base | |
| US10581754B2 (en) | Configurable views of context-relevant content | |
| US8156150B2 (en) | Fusion general ledger | |
| CN101169804A (en) | Electronic drawing data recording method and system | |
| CN101650797A (en) | Movable service knowledge base system and working method thereof | |
| US20160373394A1 (en) | Document Manager Integration | |
| CN105868284A (en) | Deployment method and system of enterprise address book | |
| CN105187220A (en) | Centralized script material printing management system | |
| CN103294845A (en) | Business analysis design support device, business analysis design support method and business analysis design support program | |
| CN111984690B (en) | Invoice information indexing method and system | |
| CN107844960B (en) | Investment analysis tool for automatically and intelligently analyzing business plan | |
| CN107291951B (en) | Data processing method, device, storage medium and processor | |
| US8887045B2 (en) | System and method for providing data links | |
| CN107967595B (en) | Message reminding method and system supporting asynchronous and synchronous calculation | |
| CN110008384A (en) | A kind of textile fabric intelligent movable management platform | |
| CN102663205B (en) | Software realization method and system for vehicle assembly shop tooling site management | |
| CN102591871A (en) | Search method and search system | |
| US20240211439A1 (en) | Al/ml concierge for a multi-client distributed system | |
| CN115202539B (en) | Record generation method, record generation device, storage medium and electronic equipment | |
| CN113674115B (en) | University data management auxiliary system and method based on data management technology | |
| CN111046053B (en) | Ordering address maintenance method and device | |
| US8244811B1 (en) | Method and apparatus for searching messaging identities |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140319 |
|
| RJ01 | Rejection of invention patent application after publication |