本毕业设计的开发实现了惠安太阳能公司的生产管理系统。本文首先简要地介绍了选题的背景以及意义,然后在系统的可行性分析、需求分析的基础上,着重阐述了数据库设计、系统的总体设计,最后介绍系统的具体实现情况。本文利用了许多截图,形象说明系统的总体设计。
本系统的开发工具采用PowerBuilder 9.0,后台数据库采用Microsoft SQL server 2000。通过对惠安太阳能公司的调研以及需求分析,本系统共设为六大功能模块:包括了支架生产管理、水桶生产管理、整机生产管理、员工工资管理、物品管理以及系统管理模块。其中前三个模块的功能是相似的,它们是针对不同生产部门的系统模块,他们之间在生产细节上是有差别的。这三个模块都有执行生产任务、制定生产计划、质量管理的功能,另外还包括生产记录、任务记录和质检记录的查询。在工资管理模块中,用户可以对员工的薪金进行设置,其中日工资管理以及月工资管理可以生成指定日和月的工资单以及对工资单的查询。物品管理是对公司的原材料以及产品进行管理,包括原材料和产品的购买入库、新增原材料、验收材料、购入查询以及产品的销售出库、新增产品、销售记录查询。系统管理模块用于员工、用户、角色的添加、删除和修改,同时管理员可以查看用户的操作日志和修改不同角色用户的权限。
关键词:太阳能,生产管理系统,PB系统开发,数据库系统
ABSTRACT
The paper is the graduation project which is based on the Huian solar energy company’s production management system. The paper first of all briefly introduces the background and significance of this topic, nnd then focuses on the feasibility of the system analysis, requriement analysis, database design, system design of the specific situation. The system design is also illustrated with some screenshots.
The system development tool is PowerBuilder 9.0, and the database is Microsoft SQL server 2000. With the company's requirement analysis for Huian company, the system was set to six functional modules: brackets production management, buckets production management, machine production management, staff wage management, goods management, and system management. Functions of the first three modules are similar, they are for different production sectors, and details in the production are different. These three modules are the implementation of production tasks, the development of production planning, quality management, as well as queries of production records, quality checking records and task records. In wage management module, it is possible to set the salaries of employees. In daily wage management and monthly wage managemrnt, wage list can be generated on the specified payroll and payroll inquiries. Goods management is management of the company's raw materials and products, including the purchase of raw materials and storage products, new raw materials, acceptance of materials, purchase inquiries and sales of products, new products, sales records inquiries. System Management Module is for employees, customers, roles’s add, delete, and modify, at the same time users can view the user’s operation log and and modify user's menu authority on different roles.
Keywords: Solar energy, Production management system, PB system design,Database system
目录