Design And Realization Of Vehicle Dealer’s Spare Patr System Base On C#.NET Technology

With the auto market competition is fierce day by day, in order to enhance theefficiency of information management of the business philosophy has been adoptedby many car dealers. Among them, in the maintenance and repair vehicle, used toreplace the damaged parts of the new parts and repair parts called parts, accessoriesfor the preparation known as spare parts. In order to shorten the repair time lag, priortissue procurement and reserve a certain number of spare parts, spare parts are themain material basis for vehicle repair, and timely supply of spare parts, can shortenthe repair time, improve customer satisfaction, increase into the plant, improve theoutput value. Spare parts for vehicle repair not only, but also for sales, spare partssales but also for the dealers bring certain benefits. Therefore, automobile dealers ofspare parts information system has been implemented to car distribution in the area.The design of the auto dealers of spare parts spare parts procurementinformation system contains storage, spare parts sales, spare parts inventory, spareparts, spare parts from the collar and other functions. Mainly by the basic datamodule, procurement management module, sales management module, internalrequirements, borrow, inventory module. The system covers almost all auto dealersof spare parts management operations, and can greatly improve the workingefficiency of automobile dealers of spare parts management, including the following:(1) system with purchasing and warehousing, purchasing, sales Chukuchansales refund, refund and other functions. The management need to record parts intoand out of warehouse, date, supplier, buyer, as well as the spare parts of the name,quantity, price and other details, spare parts into a database operation, amount andquantity change information will automatically update the inventory quantity andamount, form the ledgers to inquire.(2) spare parts inventory functions, users can book amount and the actual amount of the check, the quantity and the actual stock number match, allowing thesystem to reflect the real situation of business, enabling the system to correct theactual business management.(3) spare parts dealers internal departments claim management.(4) spare parts dealers parts case through management.This paper analyses the system structure, main function modules, the mainbusiness processes, database design, system function module detailed design,development and implementation. The backstage database using the OracleOracle10g, development language selected Microsoft C#.net, and using Oracle EMdatabase monitoring, management and optimization. OEM is a Oracle with softwareprovides enterprise manager, contains a series of tools integrated managementinterface. Through the OEM conversation view and other functions, can easily findactive session the currently executing SQL statements and its implementation plan ofinformation. Through an analysis of the implementation plan, and then find the SQLoccupancy resource high reason. Common optimization methods:(1) to be driven to the connecting column is indexed;(2) for driving the connection table columns and column establishment ofcomposite index query;(3) in the column index on the use of function, to prevent the index wasinhibited;(4) Union all instead of Union;(5) elimination of Cartesian product;(6) bind variables.The memory parameter optimization is a very important part of databaseoptimization. The Oracle database is composed of two parts: memory and physicalfiles, Oracle needs through the process in the memory read the physical file data, atthe same time, also in the memory cache used data, so that we in the next access tothe same data, can be directly read out of the memory, without the need for physicalI/O. So, if the memory is not set properly, will cause the database frequent physicalI/O, whereas the physical I/O is very time-consuming, resulting in the entire systemefficiency. General settings for the server database memory physical memory in 70%-80%.As car dealers the increasing volume of business, the backstage databasemanagement and optimization of the efficiency of the whole system will producebigger and bigger effect. With the massive increase in car users, dealers of spareparts information also grow with each passing day, the backstage databasemanagement and optimization are becoming more and more important. Study onhow to carry out the database monitoring, management and optimization aredescribed.