| The system mainly introduced the application of ERP technology in the purchasing and selling system of modern enterprise. Its main function is managing the activity of the enterprise, providing various kinds of service data, and comprehensively reflecting the intercourse state of goods purchase, sell, transfer, deposit, cost, gross profit, account receivable and account payable.Participating in the management forecast and the decision-making is an ideal choice for the modernization of enterprise management. The enterprise purchase and sale system includes purchase management, sale management, and storage management subsystem. It takes the service as foundation, takes finance as core and designed as an entire system. It provides a smooth function, ease operation and simple interface system for users.Through analysis, the system adopts SQL Server2000 and Delphi as developing tools. The system first builds up the system application prototype with this various development tools. And then carry on the requirement analysis for the prototype system. After this, repeatedly revision and improvement are made until the feasible system which satisfies the customers is constructed.In chapter 1, this paper introduces the current application status of ERP in domestic enterprise, and presents the meaning and effect of its application on the enterprise efficiency. The usage of the ERP system makes the business enterprise information get a completely share, reduces the circumstance of the information dissymmetry. Governors in each level of the business enterprise can get the most grass-roots business information at any time, thus reduces the management layer and prompts for the business enterprise thus flat even turn a management, exaltation management the efficiency create a condition.In chapter 2, requirement analyses and the development tool are introduced. In the process of requirement analyses, the purchase subsystem, storage subsystem, sell subsystem and the data flow chart of each subsystem are introduced. The design of this system is based on the real requirement and operation flow of enterprise. It provides record, revise and query tools for the activities of purchase, the stock, database, sell and so on. It can manage the enterprise goods flow operation such as order for sell goods,purchase goods, raw material purchase, buy to accept goods, sell to accept the payment, purchase payment, and the stocktaking of the stock with an fast, efficiently and safety way.As for the developing tool, the synopsis introduced delphi 7 of the database plait distance technique, the SQL language in the delphi 7th of application, the Server, technique of MS SQL are introduced.In chapter 3, the applied need and overall design of the management forecast and the decision-making system is analyzed, the structure of the system database is designed, and the system function is deliberately classified according to the requirements. Then main function of the ERP includes 12 forms: Products information,Supplier information,Customers information,Employees information,Store information,purchase information,storage information,Into store information,Out store information,distribution information,User information。In chapter 4, the system carries on applied program design with MS SQL server 2000 and Delphi based on the result of chapter 3.The ERP purchase and sale system is divided into the 6 sections, this 6 sections include: basic information management sub- system, purchase sub- system, warehouse sub- system, sale the sub- system, system support to manage six parts and customer. In addition to basic information from the merchandise basic information, customer basic information and supplier the basic information constitute, each usage Delphi establishes the item of a Windows application procedure; The system maintenance includes the database backup, the database instauration and date book, each usage Delphi establishes the item of a Windows application procedure; All of the establishments of each sub- system of the rest are the items that uses Delphi to establish a Windows application procedure. For the sake of the importance of the exaltation code and seal to pack to adjust to use to the saving process, each the statures systems all carried out a public type of access data, providing this system usage. In the meantime, for the sake of economical origin the system circulate take up of calculator resources, each item of applied procedure while carry out all just use a window body (Form).In chapter 5, debugging and testing are carried out; the system becomes more perfect through debugging and testing. There are two kinds of errors while debugging: one is the error during the process of design, the other is the error during the process of running. In order to improve the sufficiency of testing, we adopt the method of logic cover. Logic's overlay is to take the logic structure of the procedure inner part as foundation, the design test uses an example, making the procedure use a movement with these tests, can carry out procedure in of each an ask a sentence, branch, Path. Not only for the test but also forspeech, its target is discovering mistake of software.In chapter 6, conclusion remarks of this system are given. In brief, this can satisfy the basic need of user. But for the matters of time, it also needs improvement in the future. |
