1. Basic file module
This module is mainly used to realize the functions of goods file setting, supplier setting and warehouse setting.
2. Cargo management module
This module is mainly used to realize the functions of commodity warehousing management, commodity warehousing management, commodity borrowing management, commodity return management and inventory management.
3. Query statistics module
This module is mainly used to realize the functions of inventory query, warehousing query, delivery query, lending query, return query, early warning query, annual statistics and monthly statistics of goods in and out of storage.
4. System maintenance module
This module is mainly used for data backup, recovery and compression.
5. Help module
This module is mainly used to realize user management, password modification, permission setting, about this system, login and logout again and other functions.
abstract
With the development of modern industry, computer information management system is paid more and more attention by enterprises. This paper mainly analyzes some basic functions and components of the inventory management system, including system demand analysis, system structure, functional module division and database mode analysis. , and focuses on the actual development and implementation of applications. The consistency and security of data are realized, and the application program is fully functional, which meets the requirements of inventory management system as a typical information management system. At the same time, the functional characteristics of Visual Studio programming environment and SQL Server database management system are briefly introduced. Inventory management system is an indispensable part of enterprise logistics management.
Keywords: inventory management, database, information management, VS summary
With the development of modern industry, computer information management system is paid more and more attention by enterprises. This paper mainly analyzes some basic functions and composition of inventory management system, including system demand analysis, system structure, functional module division and database mode analysis. In particular, the actual development of the application program is introduced. The data consistency and security are achieved, and the application program is fully functional, which meets the requirements of the inventory management system as a typical information management system (MIS). At the same time, the functional characteristics of Visual Studio programming environment and SQL Server database management system are briefly introduced. Inventory management system is an indispensable part of enterprise logistics management.
Keywords: inventory management, database, information management, VS
catalogue
Introduction to Chapter 1
1. 1 Overview
1.2 background
1.3 content and work arrangement of this paper
1.4 meaning
Chapter II System Platform and Development Tools
2. 1 system development language
2. 1. 1 Microsoft launches C#
2. 1.2 Efficiency and safety
2. 1.3 supports the existing new network programming standards.
2. 1.4 eliminates a lot of program errors.
2. 1.5 provides internal support for version update, which reduces the development cost.
2. 1.6 Better consistency between business processes and software implementation
2. 1.7 Extended interactivity
2. 1.8 conclusion
2.2 database theory
2.2. Introduction to1SQL Server
Client-server component
2.2.3 client-server communication process
SQL Server service
2.2.5 Common tools of SQL Server
2. 2. 6 SQL server database system database
ddl
Data manipulation language
stored procedure
2.2. 10 trigger
2.3 system development tools
2.3. Introduction to1Visual Studio 2005
2.3.2 .NET framework
Windows forms
Chapter III Design and Analysis of Inventory Management System
3. 1 Overall design
3. 1. 1 project planning
3. 1.2 system business process analysis
3. 1.3 system functional structure
3.2 System design
3.2. 1 Design objective
3.2.2 Development and operation environment
database design
3.3 Technical preparation
3.3. 1 Use of graphics classes
3.3.2 Query records by date in Windows application.
Chapter IV Implementation and Testing of Inventory System
4. 1 male * * * module
4. 1. 1 DataCon class
4. 1.2 data operation class
4.2 Main functional modules
4.2. 1 system login
4.2.2 Supplier Information Settings
4.2.3 Commodity storage management
4.2.4 Delivery management
4.2.5 Loan management
4.2.6 Return Management
4.2.7 Inventory information query
4.2.8 Annual statistics of inbound and outbound goods
4.3 Analysis and solution of difficult problems
4.3. 1 Update the cargo information table when the goods are put into storage.
4.3.2 Analyze the goods in and out of the warehouse through the pie chart.
4.4 Program Debugging and Error Handling
Chapter V Summary
5. 1 technical summary
5.2 Experience summary
Concluding remarks
refer to
Express gratitude/gratitude
appendix
Appendix 1: Inventory Management System Home Page
Original text of foreign language materials
Translate a manuscript
Introduction to Chapter 1
1. 1 Overview
Inventory management is an important part of enterprise's daily management. The traditional manual management method has many disadvantages, such as extremely heavy workload of warehousing, statistics and summary processing, very low processing efficiency, and leaders can't keep abreast of the actual situation of enterprise capital occupation. More and more business operators realize that only by adopting information management system can they adapt to the increasingly fierce market competition.
The inventory management system I made is a Windows application program, which can not only effectively manage the enterprise's inventory, but also analyze the goods in and out of the warehouse in a certain year and month with charts, providing a basis for enterprise managers' business decisions.
1.2 background
Nowadays, the expansion of the competition scope of enterprises requires strengthening the management of all aspects of enterprises, requiring enterprises to have higher information integration, and requiring integrated management of the overall resources of enterprises, not just manufacturing resources. Modern enterprises are aware that the competition of enterprises is the competition of comprehensive strength, which requires enterprises to have stronger financial strength and faster market response speed. Therefore, it is not enough for the information management system and theory to only stay in the information integration and theoretical research of the manufacturing part. The logistics, information and capital related to competition should extend from manufacturing to total quality management, and all resources of enterprises (distribution resources, human resources and service resources, etc.). ) and market information and resources, and requires the ability to handle workflow. On the other hand, the scale of enterprises continues to expand. This requires unified planning, coordination of production steps, information collection and resource allocation within the group. These should be independent and unified in resource management. Third, the development of information globalization requires enterprises to strengthen information exchange and information sharing. Enterprises are both competitors and partners, and information management needs to be extended to the whole supply chain management.
With JIT (just ln time-just in time), TQC (total quality control-total quality management), OPT(optimized production technology-optimized production technology)、DRP(distribution resource planning-distribution resource planning) With the introduction and development of modern management ideas and methods, modern management ideas such as MES (Manufacturing Execution System) and AMS (Agile Manufacturing System) appeared one after another. MRP-II gradually absorbs and integrates other advanced ideas, perfecting and developing its own theory. In 1990s, MRP-II developed to a new stage: ERP (Enterprise Resource Planning). Simply put, all the resources of an enterprise include three streams: logistics, capital flow and information flow. ERP is a management information system that comprehensively manages these three resources. Generally speaking, ERP is an all-round and systematic management platform based on information technology and using advanced management ideas of modern enterprises to comprehensively integrate all resource information of enterprises and provide enterprises with decision-making, planning, control and performance evaluation.
ERP system is a management theory and thought, not just an information system. It uses all the resources of the enterprise, including internal resources and external market resources, to create the best solution for the enterprise to manufacture products or provide services, and finally realize the business objectives of the enterprise. ERP theory and system developed from MRP-II, which not only inherited the basic ideas of MRP-II (manufacturing, supply and marketing and finance), but also greatly expanded the management modules, such as multi-factory management, quality management, equipment management, transportation management, distribution resource management, process control interface, data acquisition interface, electronic communication and so on. It combines the characteristics of discrete production and process production, expands the scope of management, conducts business activities more flexibly or "flexibly" and responds to market demand in real time. It also integrates a variety of modern management ideas, further improving the management level and competitiveness of enterprises. Therefore, ERP theory is not a negation of MRP-II, but an inheritance and development. The core of MRP-II is logistics, and the main line is planning. In the process of logistics, there are both capital flow and information flow. The main line of ERP is also planning, but ERP shifts the focus of management to finance, and the concept of financial cost control runs through the whole operation process of enterprises.
In a word, ERP has greatly expanded the scope and depth of enterprise management, including quality, equipment, distribution, transportation, multi-factory management, data acquisition interface and so on. The management scope of ERP involves all the supply and demand processes of enterprises, and it is a comprehensive management of supply chain and supply chain structure operated by enterprises.
1.3 content and work arrangement of this paper
This paper is an inventory management system based on Visual Studio platform, C# programming language and SQL Server database. As the center of enterprise goods management, inventory should first understand its functions and processes. The function of inventory is to analyze and count the stored goods so that enterprises can manage them. After determining the function, write out the business process and functional structure, and establish the corresponding data table and the relationship between tables in SQL Server database according to the functional structure. With the database, I began to write certain functional modules on the Visual Studio platform in a familiar programming language. The functional modules of this paper include: commodity management, basic files, query statistics, system maintenance and help. Write each functional module of the system, test each module and the whole, and modify it according to different errors until all functions can be used normally.
My work arrangement: After I have determined the topic of my thesis, I will look up materials related to inventory management through books and the Internet, understand the process and functions of inventory management, and then determine the development language, database and development tools of the inventory management system. Then, the overall design scheme of the inventory management system is defined, and the code and program are written to debug and optimize the system. Finally, write a thesis, be familiar with the design operation, and prepare for graduation defense.
1.4 meaning
Inventory management system is the basis of production, planning and control. The inventory management system mainly reflects the warehousing and circulation of materials in time through the management of warehousing, warehousing and warehousing, and provides a basis for production management and cost accounting. And analyze the information through inventory. At the same time, it provides real-time and accurate inventory information for planners and decision makers, so as to adjust production in time and ensure the smooth progress of various production and business activities of enterprises. Through the informationization of inventory management, we can comprehensively monitor the import, export and storage of enterprise goods to meet the needs of modern enterprise inventory management.
Chapter II System Platform and Development Tools
2. 1 system development language
2. 1. 1 Microsoft launches C#
C# (C sharp) is Microsoft's solution to this problem. C# is a new object-oriented programming language. It enables programmers to quickly write various applications based on Microsoft. NET platform, and Microsoft. NET provides a series of tools and services to maximize the development and utilization of computing and communication fields.
It is C#' s excellent object-oriented design that makes it an ideal choice for building various components, whether it is advanced business objects or system-level applications. Using simple C# language structure, these components can be easily converted into XML network services, which can be called by any language on any operating system through the Internet.
Most importantly, C# enables C++ programmers to develop programs efficiently without losing the original powerful functions of C/C++. Because of this inheritance relationship, C# and C/C++ have great similarities, and developers familiar with similar languages can quickly turn to C#.
2. 1.2 Efficiency and safety
The emerging network economy forces enterprises to deal with the threat of competition more quickly. Developers must constantly shorten the development cycle and constantly introduce new versions of applications, rather than just developing an "iconic" version.
C# has considered these problems in its design. It enables developers to do more with less code, and it is not easy to make mistakes.
2. 1.3 supports the existing new network programming standards.
The new application development model means that more and more solutions depend on emerging network standards, such as HTML, XML and SOAP. Existing development tools often appear before the Internet, or when the well-known network is still in its infancy. Therefore, they generally can't support the latest network technology well.
C# programmers can get twice the result with half the effort by building an extended framework of applications on Microsoft. NET platform. C# contains built-in features, so any component can be easily converted into XML network service, and any program running on any operating system can call the service through the Internet.
More importantly, the framework of XML web services can make existing XML web services look like C# objects of programmers. In this way, programmers can easily use their existing object-oriented programming skills to develop and utilize existing XML network services.
There are also some excellent features that make C# a first-class network programming tool. For example, XML has gradually become the standard for transmitting structured data on the network. This data set is usually very small. To improve performance, C# allows XML data to be mapped directly to struct data types instead of classes. This is very effective for dealing with a small amount of data.
2. 1.4 eliminates a lot of program errors.
Even expert C++ programmers often make some simple mistakes, such as forgetting to initialize variables, but it is these small mistakes that often bring unpredictable problems, and some even take a long time to find and solve. Once a program is used as a product, even the simplest mistake can be extremely expensive.
The modern design of C# can eliminate many common C++ programming errors. For example:
1. Resource recycling reduces the memory management burden of programmers.
2. Variables in 2.C # are automatically initialized by the environment.
3. Variables are type-safe.
In this way, it is more convenient for programmers to write and maintain programs to solve complex business problems.
2. 1.5 provides internal support for version update, which reduces the development cost.
Updating software components is an error-prone task, because the modification of code may inadvertently change the semantics of the original program. To help developers do this, C# provides internal support for version update. For example, method overloading must be explicitly declared. This can prevent coding errors and ensure the flexibility of version update. Another related feature is the inherent support for interfaces and interface inheritance. These features enable C# to develop complex frameworks and update them over time.
Generally speaking, these characteristics make the process of developing subsequent versions of program projects more robust, thus reducing the development cost of subsequent versions.
2. 1.6 Better consistency between business processes and software implementation
To turn an enterprise's business plan into reality, it is necessary to establish a close correspondence between abstract business processes and actual software implementation. However, it is difficult for most languages to do this. For example, programmers today usually use code comments to indicate which class corresponds to an abstract business object.
C# language allows extended metadata of type definitions. These metadata can be applied to any object. Project builders can define domain-specific properties and apply them to any language element-classes, interfaces, etc. Then, developers can programmatically check the properties of each element. In this way, many tasks become more convenient, such as writing a gadget to automatically check whether each class or interface is correctly defined as part of an abstract business object, or just creating a report based on the domain-specific properties of the object. The close correspondence between custom metadata and program code helps to strengthen the correspondence between the expected behavior of the program and the actual implementation.
2. 1.7 Extended interactivity
As an automated and type-safe environment, C# is suitable for most enterprise applications. However, practical experience shows that some applications still need some low-level code, either for performance reasons or because of compatibility with existing application interfaces. These situations may force developers to use C++, even if they prefer to use a more efficient development environment.
C# adopts the following countermeasures to solve this problem:
1. Built-in Object Model (COM) and Windows-based? Support of API;
2. Allow limited use of native pointers.
In C#, each object is automatically generated as a COM object. Developers no longer need to explicitly implement IUnknown and other COM interfaces. These functions are built-in. Similarly, C # can call an existing COM object, no matter what language it is written in.
C# contains a special function that enables programs to call any pure API. In specially marked code, developers can use pointers and traditional C/C++ functions, such as manual memory management and pointer operation. This is its great advantage over other environments. This means that C# programmers can write programs based on the original C/C++ codes instead of giving up those codes completely.
Whether it is to support the call of COM or the call of pure API, it is to let developers have the necessary powerful functions directly in the C# environment.
2. 1.8 conclusion
C# is a modern object-oriented language. It enables programmers to create Microsoft-based solutions. NET platform, convenient and fast. This framework enables C# components to be easily converted into XML web services, so that applications on any platform can call it through the Internet.
While improving the efficiency of developers, C# is committed to eliminating errors that may lead to serious consequences in programming. C# enables C/C++ programmers to develop networks quickly, while maintaining the functions and flexibility required by developers.
1. 1 summary of experience Before developing a system, you must first find out what the purpose of developing this system is, and draw its business process, then make feasibility analysis, overall design and system design according to the demand analysis, and finally code after these preliminary works are perfected, then you will find your own programming ideas very clear. In addition, when developing database applications, if you encounter problems involving multiple table operations, you can simplify the code design by using triggers.
Conclusion After two months of stumbling, my graduation project is finally coming to an end. I finally finished the paper "Design and Implementation of Inventory Management System". Every step is a new attempt and challenge for me, from receiving the title of the paper, to the realization of the system, and then to the completion of the paper, which is also the biggest project I independently completed during my college years. During this time, I learned a lot of knowledge and gained a lot of insights. From the state that I don't know anything about inventory management and ASP.NET, ADO and other related technologies, I began to study and experiment independently, read relevant materials and books, and gradually clarified the vague concepts in my mind, so as to improve my very immature works step by step. Every progress is my learning harvest, and the success of every experiment will make me excited for a long time. Click Run to basically achieve the desired effect. Vanity always comes to mind when no one is around. However, due to the relationship between ability and time, I always feel that there are many unsatisfactory places, such as incomplete functions, rough appearance, unreasonable underlying code and so on. However, I will be a little narcissistic to comfort myself: do one thing, don't care too much about the final result, what is valuable is the harvest in the process. Use this language to soothe my uneasy heart. Graduation design may be the last assignment I handed in in my college career. I want to take this opportunity to thank all the teachers and classmates who have helped me in the past four years. Your friendship is my wealth and an indispensable part of my life. Professor Zhang Fengli, my graduation consultant, although we just met for the first time, she can forgive my ignorance and impulsiveness as an elder and give me tireless guidance. Here, I want to say thank you to her. College life is about to pass in a hurry, but I can say, "I have been here." I have been in college for four years, but its influence on me can't be measured by time. Everything and everyone I have experienced in these four years will become a part of my afterlife and a compass for me to deal with people. I am about to leave school to work, which is another starting point of my life. Here, I wish my friends in the same boat in college a pleasant journey and a splendid future forever.
Reference [1] Microsoft Corporation. Database programming-—SQL Server 2000 database programming. Beijing: Higher Education Press, 2005[2] Selected cases of Zhang Yueting. C# database system development. Beijing: People's Posts and Telecommunications Publishing House, 2007.6[3] Microsoft Company. C# programming language. Beijing: Higher Education Press, 2005[4] Hu Hailu. Essentials of Examples of Network System Development (ASP.NET Edition). Beijing: Electronic Industry Press, 2006,6 [5] Yan Weimin. Data Structure (2nd Edition). Beijing: Tsinghua University Publishing House, 2003, 1.
Thank you. Please click /article/html/694.html for details.