Design And Implementation Of The Jewelry Sales Management Information System

With the development of information technology and network technology, more andmore industries are eager to use the computer to do the business management ofenterprises. So does the jewelry industry. Now, how to use advanced management tools toimprove the management level of enterprises has become the primary task of variousindustries. Therefore, a fresh network information technology and the new managementsystem of jewelry have become one of important methods to improve managementefficiency of jewelry company and improve the service level of jewelry company.The system realized the information management of jewels business, that is theprocess from purchase, sales, storage to management. The main functions of the systemare consisted of six modules including the purchase management, sales management,storage management, query statistics, finance management, system management andmaintenance. The purchase management function is used to complete the commoditycollection; sales management functions is used to complete the cash sales of jewelry, theexchange of old jewelry, the recycling of old material, the return of the goods, thereplacement of goods, the cancellation of receipt, the daily checkout of the businessoperating situation and other revenue and expenditure management, and all of thesefunctions are often used in daily business activities, also, they are the most basic ones andthe core of the system.The jewelry sales information management system is designed and realized in thispaper.First,the system module functions are designed;Second, it carrys out the analysis ofthe system function and data, and designs and completes the case diagram, the mainbusiness activity diagram and data flow diagram;In the end,the system is encoded andtest, it runs in good condition.The main characteristic of this system is that the embeddeddesign of the system is completed by VBA, so that the output data of the system can beformatted, neat and tidy, and provide a good interface for other applications. The systemadopted the module design, and distinguished the functions among modules and theirmutual relationships reasonably, and finally completed the jewelry sales managementinformation system, and laid a good foundation for the further expansion and promotion.The system used database system based on.NET development platform and SQLServer during the development process of the system, and adopted C/S softwarearchitecture, and used Visual Studio.NET2005and Microsoft SQL Server2008as the development tool, the system realized the information management of jewels business,that is the process from purchase, sales, storage to management, and truly realizedpaperless office, error free operation and high efficiency operation, so the study of jewelrysales management information system has important and practical significance.