Designation and Realization of Commodity Marketing Management System The aim of this essay is to explore the design of a commodity sales management with the relevant database management systems， from computers to replace the artificial， such as the implementation of a series of new products， delete the goods have been sold， inventory changes enquiries， statistics and printing operations， as well as goods Providers of basic data management． This will enable office staff can quickly and easily complete the task of the management of goods． 1． Iintroduction China's accession to the WTO， enterprises are facing unprecedented opportunities and challenges， enterprises also requires the rapid development of enterprise management level of continuous improvement， therefore， rapidly increasing levels of corporate management， master of advanced enterprise management is an imminent task is to enterprises In the fierce competition in the et steady development． Faced with a large number of enterprise sales， data warehousing， manual approach has been difficult to keep up with the pace of modernization． With computer technology and network the rapid development of communication technologies， many enterprises have a better computer network hardware or building foundation． Therefore， in order to improve the work of the modern enterprise management and scientific level， and ensure the immediate information processing， accuracy， the development of a set of commodity sales and storage management of the database system is extremely important． Based on the survey's basic situation of enterprises， have designed a sales management， inventory management， supplier management， and other functions of eting management systems． 2． Database design After investigation， the value of the business management of the data， including sales of goods aggregate statistics， data processing storage， the supplier for the basic information and statements such as the formation． Sales of goods aggregate statistics main registration of the basic commodities for sale， including goods number， date of sale， the sales price， sales volume and discounts． Storage of information， including names and numbers of goods， the supplier name and number， Jinjia and commodity prices， the purchase date， location and storage of inventory． Providers of basic information providers， including the number and names of people responsible for the goods number， contact telephone numbers and addresses， and other providers． According to the data analysis， that the system requires a basic information form of goods， the supplier information form， record sales table， the password table． 3． Design Merchandise sales management system is mainly for goods purchase， sale， as well as related data management providers to achieve the functions are as follows: (1) eting the management of aggregate statistics， the requirements are here for any transaction records， to delete records of transactions， can display the current total sales， total sales of all， and so on． (2) the Zhubi goods sales management， commodity requirements to record numbers， names， prices， discounts． (3) providers basic information management， requirements to add， query， modify， delete， one by one to supply the basic information． (4) commodity storage management， requirements to add， query， modify， delete， one by one to each of the inventory of goods． (5) print statements， including the printing of various commodities sales， inventory， and so on． (6) maintenance of user rights， including the increase in new users， delete the old users， modify your password， and other functions． 4． Certification authority To prevent non-management staff into the system， it is necessary to use certain methods to determine the sign that users are legitimate． Therefore， the need for a user login window， concrete realization of the process are as follows: VFP open the main interface click the "new documents" icon in the open dialog box， select the form， to open the new form， this can be in the form required for the design function． In the login form on the main control the use of the following categories: (1) tab control: the use of this form of four labels control， respectively， of its caption attribute set to "Welcome to the eting management system"， "user name" and "user password，" "try" to show Different meanings． (2) list box: to display the user name， through its controlsource attributes and the user name password form fields to establish the association． (3) text box: the user to enter a password， to confirm whether the sign legal． (4) command buttons: two orders were the caption button attribute set to "confirm" and "Cancel"， if the correct password， the system calls the main menu， or the wrong pop-up dialog， its realization is in the process of "confirmation" Click the Properties button in the settings． 5． System main menu To confirm the user name and password， you can enter the system main menu． The design process is as follows: Open VFP interface， select the "new menu" Options， then select "drop-down" menu， you can enter the "menu design for the" interface． Their respective sub-menu called functional form， concrete realization of the process are as follows: (1) sales summary: Calling merchandise sales aggregated interface， the editing process is in its "process" fill in the code are as follows: set path to D: \ general merchandise sales management system \ FORMS \ do form an integrated management sales． scx Sales of integrated management． Pageframe1．activepage = 1 (2) the basic inventory information: Call the basic inventory information to the interface， the "process" in the code for: set path to D: \ general merchandise sales management system \ FORMS \ do form an integrated management sales． scx Sales of integrated management． Pageframe1．activepage = 2 (3) withdraw from the system: the process of the code for: Quit Other menu design features similar to the call， not repeat them． 6． Functional form Click on the sub-menu of different options， you can call the functions of different form． The system required the establishment of major commodities to find form， find suppliers form， the form certification authority， competence maintenance form， sales of integrated management of form， Zhubi form， such as sales records． Providers basic information: can find suppliers numbers， names of suppliers， vendors address， the main person responsible for the supply of goods number， names of suppliers of goods and other basic information．． Maintenance of user rights: remove the old main users， adding new users， change the password function． Data Report Print: The print storage invoices， Chuku Dan and the specific sales alone． Concrete realization of the process are as follows: Add in the form of a label， its caption attribute set to "commodity warehousing and sales management" and set the appropriate font size， color， as the title． On a form to add a frame pageframe1， its pagecount attribute set to "4" and page1， page2， page3， page4 the caption properties were set as follows: sales of goods aggregate statistics， the value of basic information storage， suppliers Information， print statements， as the title page． Then all were designed page and use the text box controlsource attributes data binding． 7． Concluding res To sum up， this paper from system analysis， system design and systems， and other areas on the establishment of commodity sales management system involves a number of issues． With the system， allowing the computer to replace the artificial， such as the implementation of a series of new products， delete the goods have been sold， inventory changes enquiries， statistics and printing operation， can also be suppliers of goods the basic information management， and this So that office staff can quickly and easily complete the task of the management of goods．
http://www.google.com.hk/language_tools?hl=zh-CN你随便找一篇文章，都懒得复制它的内容，直接复制URL，谷歌翻译文字下面，有个翻译网页，比如你把我的网站全翻成英文试试www.qipeidaquan.com
The aim of this essay is to explore the design of a commodity sales management with the relevant database management systems， from computers to replace the artificial， such as the implementation of a series of new products， delete the goods have been sold， inventory changes enquiries， statistics and printing operations， as well as goods Providers of basic data management． This will enable office staff can quickly and easily complete the task of the management of goods．
1． Iintroduction
China's accession to the WTO， enterprises are facing unprecedented opportunities and challenges， enterprises also requires the rapid development of enterprise management level of continuous improvement， therefore， rapidly increasing levels of corporate management， master of advanced enterprise management is an imminent task is to enterprises In the fierce competition in the et steady development． Faced with a large number of enterprise sales， data warehousing， manual approach has been difficult to keep up with the pace of modernization． With computer technology and network the rapid development of communication technologies， many enterprises have a better computer network hardware or building foundation． Therefore， in order to improve the work of the modern enterprise management and scientific level， and ensure the immediate information processing， accuracy， the development of a set of commodity sales and storage management of the database system is extremely important． Based on the survey's basic situation of enterprises， have designed a sales management， inventory management， supplier management， and other functions of eting management systems．
2． Database design
After investigation， the value of the business management of the data， including sales of goods aggregate statistics， data processing storage， the supplier for the basic information and statements such as the formation． Sales of goods aggregate statistics main registration of the basic commodities for sale， including goods number， date of sale， the sales price， sales volume and discounts． Storage of information， including names and numbers of goods， the supplier name and number， Jinjia and commodity prices， the purchase date， location and storage of inventory． Providers of basic information providers， including the number and names of people responsible for the goods number， contact telephone numbers and addresses， and other providers．
According to the data analysis， that the system requires a basic information form of goods， the supplier information form， record sales table， the password table．
3． Design
Merchandise sales management system is mainly for goods purchase， sale， as well as related data management providers to achieve the functions are as follows:
(1) eting the management of aggregate statistics， the requirements are here for any transaction records， to delete records of transactions， can display the current total sales， total sales of all， and so on．
(2) the Zhubi goods sales management， commodity requirements to record numbers， names， prices， discounts．
(3) providers basic information management， requirements to add， query， modify， delete， one by one to supply the basic information．
(4) commodity storage management， requirements to add， query， modify， delete， one by one to each of the inventory of goods．
(5) print statements， including the printing of various commodities sales， inventory， and so on．
(6) maintenance of user rights， including the increase in new users， delete the old users， modify your password， and other functions．
4． Certification authority
To prevent non-management staff into the system， it is necessary to use certain methods to determine the sign that users are legitimate． Therefore， the need for a user login window， concrete realization of the process are as follows:
VFP open the main interface click the "new documents" icon in the open dialog box， select the form， to open the new form， this can be in the form required for the design function．
In the login form on the main control the use of the following categories:
(1) tab control: the use of this form of four labels control， respectively， of its caption attribute set to "Welcome to the eting management system"， "user name" and "user password，" "try" to show Different meanings．
(2) list box: to display the user name， through its controlsource attributes and the user name password form fields to establish the association．
(3) text box: the user to enter a password， to confirm whether the sign legal．
(4) command buttons: two orders were the caption button attribute set to "confirm" and "Cancel"， if the correct password， the system calls the main menu， or the wrong pop-up dialog， its realization is in the process of "confirmation" Click the Properties button in the settings．
5． System main menu
To confirm the user name and password， you can enter the system main menu．
The design process is as follows: Open VFP interface， select the "new menu" Options， then select "drop-down" menu， you can enter the "menu design for the" interface．
Their respective sub-menu called functional form， concrete realization of the process are as follows:
(1) sales summary: Calling merchandise sales aggregated interface， the editing process is in its "process" fill in the code are as follows:
set path to D: \ general merchandise sales management system \ FORMS \
do form an integrated management sales． scx
Sales of integrated management． Pageframe1．activepage = 1
(2) the basic inventory information: Call the basic inventory information to the interface， the "process" in the code for:
set path to D: \ general merchandise sales management system \ FORMS \
do form an integrated management sales． scx
Sales of integrated management． Pageframe1．activepage = 2
(3) withdraw from the system: the process of the code for: Quit
Other menu design features similar to the call， not repeat them．
6． Functional form
Click on the sub-menu of different options， you can call the functions of different form． The system required the establishment of major commodities to find form， find suppliers form， the form certification authority， competence maintenance form， sales of integrated management of form， Zhubi form， such as sales records．
Providers basic information: can find suppliers numbers， names of suppliers， vendors address， the main person responsible for the supply of goods number， names of suppliers of goods and other basic information．．
Maintenance of user rights: remove the old main users， adding new users， change the password function．
Data Report Print: The print storage invoices， Chuku Dan and the specific sales alone．
Concrete realization of the process are as follows:
Add in the form of a label， its caption attribute set to "commodity warehousing and sales management" and set the appropriate font size， color， as the title．
On a form to add a frame pageframe1， its pagecount attribute set to "4" and page1， page2， page3， page4 the caption properties were set as follows: sales of goods aggregate statistics， the value of basic information storage， suppliers Information， print statements， as the title page． Then all were designed page and use the text box controlsource attributes data binding．
7． Concluding res
To sum up， this paper from system analysis， system design and systems， and other areas on the establishment of commodity sales management system involves a number of issues． With the system， allowing the computer to replace the artificial， such as the implementation of a series of new products， delete the goods have been sold， inventory changes enquiries， statistics and printing operation， can also be suppliers of goods the basic information management， and this So that office staff can quickly and easily complete the task of the management of goods．