Hello everyone, I am Pisces Lin. I have been using the B/S structure information management system developed by ASP some time ago. Recently, I designed an inventory management system using VB software development tools. Personally, I think this system is doing well. I am now The source program of this system is released to everyone for free. It can be used as the source program for graduation projects. I hope it will be helpful to my friends. If you don’t understand anything, please add me at qq: 287307421 to learn more. Thank you! The following is a functional analysis of this system:
The main problem that the system can solve is to be able to use VB development tools to correctly connect to the database we designed through ODBC and other database connection methods, and implement corresponding operations on the database to complete various functions required by the system. The functions to be implemented by this system are as follows:
(1) Product category information management: including adding new product categories, modifying and deleting existing product categories. When deleting product category information, if there is still product information under the product category, the deletion operation of this category is not allowed.
(2) Product information management: As a warehouse of items, there must be many different products. In order to efficiently manage these products, each product belongs to a different product category. This module includes the entry of new product information, the modification of existing product information such as modifying the category and inventory of the product, and the query of product information. Product information can be combined and queried based on product name keywords and product categories, and product information can be deleted. .
(3) Inventory operation information management: As a warehouse of goods, in daily life, it may be necessary to enter certain goods into the warehouse at certain times, and may need to carry out goods out of the warehouse at certain times, and these input and output operations The library information will also be recorded by the system, and the administrator can also perform conditional queries on this operation information in the future.
(4) Printing of various report information: As long as the operator has this authority, he can print the system's product information report, and can query and print various inbound and outbound information records according to conditions.
(5) Data table information export: As long as the operator has this authority, he can export the product category information table, product information table, warehousing information record table, and warehouse out information record table in the system.
(6) Operator management: Each operator who logs in to the system can modify his or her own login password information, but to manage the permissions of other operators requires the permission to maintain operator information. With this permission, you can control other operations. Operators can be assigned permissions, new operators can be added, and operator account information can be deleted.
Username and password: admin
Expand