1、 中小型污水处理厂ERP系统建设摘 要随着计算机信息技术的蓬勃发展和广泛应用，和我国多年的入世经验，同时在全球的经济一体化的形式下，我国中小型污水处理厂所面临的挑战将越来越大。我国中小型污水处理厂要在这种背景下求得生存并发展，就必须要不断提升自身的竞争实力，这就要求中小型污水处理厂不仅要提高本身的业务水平，还要推进企业信息化改革充分整合资源。但是我国的中小型污水处理厂数量非常之庞大，行业种类也非常繁多，通用的企业信息管理系统完全不适用，这就必须要根据企业本身的特点来定制。本文以中小型污水处理厂的实际应用为背景，在研究ERP系统产生和发展以及管理思想和技术的理论基础上，结合国内中小型污水处理厂的
2、ERP使用现状，分析了市面上的ERP在中小型污水处理厂的应用中的主要问题，并针对存在的问题提出了适合中小型污水处理厂的管理现状的ERP系统目标，设计核心思想和设计准则，并给出解决详尽的解决方案。依照软件工程设计的思想，结合中小型污水处理厂企业的实际需求，和分析企业的物料、销售、生产、采购、库存、固定资产、人力资源等方面的现状，对ERP系统进行了整体流程设计，并阐述系统各功能模块组成和详细流程设计和实现。数据库的设计根据范式准则，并通过绘制数据流程图和E-R图的来详细描述数据库的建模过程，数据结构以及关系模式。本文采用.NET为编程语言，服务器操作系统采用Windows 2003 Sever，数
3、据库才用SQL Sever 2003。目前，本套系统已经在许多中小型污水处理厂试运行，反应皆良好，无论是在业务分析方面还是业务流程方面，都使整个信息化资源达到整合共享状态，这就极大的提高了企业自身的整体运营水平。同时期盼本套ERP系统的设计构思和设计理念能对其他行业的中小型污水处理厂的ERP系统的建设起到一定的借鉴作用。关键词：中小型污水处理厂，ERP系统ABSTRACTWith the rapid development of computer information technology and wide application, and Chinas accession to the W
4、TO for many years of experience, both in the form of global economic integration, Chinas small and medium sized sewage treatment plants are facing the challenge will be increasing. Chinas small and medium sized sewage treatment plants to survive in this context and development, it is necessary to co
5、ntinuously upgrade their competitive strength, which requires not only small and medium sized sewage treatment plants to improve their professional level, but also to promote enterprise information reform fully integrated resources. However, Chinas number of small and medium sized sewage treatment p
6、lants is very large, very diverse types of industry, common enterprise information management system model does not apply, which must be based on the characteristics of the enterprise itself to customization.In this paper, small and medium sized sewage treatment plant for the practical application o
7、f the background, studying the emergence and development of ERP systems and management ideas and techniques based on the theory, combined with the small and medium sized sewage treatment plants use the ERP status, analysis of the ERP market in the small sewage treatment plant applications of the mai
8、n issues and deal with the problems raised for small and medium sized sewage treatment plant management status of the ERP system objectives, design core ideas and design criteria, and gives solutions elaborate solutions. Software engineering design in accordance with the idea of combining small and
9、medium sized sewage treatment plant to the actual needs, and analyze the material, sales, production, purchasing, inventory, fixed assets, human resources and so the status of the ERP system for the overall process design , and describes the system of functional modules and detailed process design a
10、nd implementation. Database design guidelines based on the paradigm, and by drawing data flow diagrams and ER diagrams to describe in detail the process of database modeling, data structures and relational schema. This paper. NET as a programming language, server operating system is Windows 2003 Sev
11、er, the database only with SQL Sever 2003.Currently, the system has been set in many small and medium sized sewage treatment plant test run, the reaction are good, both in business analysis or business processes, have allowed the sharing of information resources to achieve integration of the state,
12、which greatly improved the business their overall operational level. ERP systems also look forward to this set of design ideas and design concepts to other sectors of small and medium sized sewage treatment plant construction ERP systems play a role in learning.Keywords: small sewage treatment plant
13、, ERP systems目 录第一章绪论11.1选题的背景和目的11.2课题开发目的及应用价值21.3本文的主要研究内容3第二章ERP理论和技术综述42.1 ERP的概念42.2 ERP的发展历程42.2.1基本MRP52.2.2闭环MRP62.2.3制造资源计划MRP-62.2.4企业资源计划ERP72.3 ERP的核心思想82.4 ERP国内外应用现状及趋势发展102.5 ERP系统设计的技术综述122.5.1 C/S结构122.5.2 B/S结构122.5.3传统三层结构122.5.4基于Web的分布式结构132.6系统设计开发相关技术简介142.6.1.NET与J2EE14第三章我国
14、中小型污水处理厂ERP应用现状及特点163.1中小型污水处理厂的定义和地位163.1.1中小型污水处理厂的定义163.1.2中小型污水处理厂的地位163.2中小型污水处理厂信息化建设的现状及特征173.2.1中小型污水处理厂信息化的建设现状173.2.2中小型污水处理厂信息化建设的特征173.3中小型污水处理厂实施ERP的特征及可行性分析183.3.1中小型污水处理厂实施ERP的必要性分析183.3.2中小型污水处理厂ERP需求分析193.3.3中小型污水处理厂实施ERP的可行性分析203.3.4中小型污水处理厂ERP应用中存在的问题21第四章中小型污水处理厂ERP系统的设计234.1系统设计
15、原则234.2系统的总体设计244.2.1系统概述244.2.2系统总体工作流程244.2.3系统功能模块的划分254.2.4系统各模块间的集成关系284.3系统各模块流程分析294.3.1系统管理模块294.3.2物料管理模块294.3.3销售管理模块304.3.4生产管理模块314.3.5采购管理模块314.3.6库存管理模块324.3.7应收应付管理模块334.3.8固定资产管理模块344.3.9人力资源管理模块354.4系统数据库设计354.4.1数据库设计准则354.4.2系统数据流程图374.4.3数据结构设计414.4.4系统数据表设计424.5系统环境运行44第五章系统的测试和分析475.1测试流程设计475.2系统测试475.2.1开发用户测试475.2.2关键用户测试485.3测试结果分析48第六章结论50致 谢52参考文献53第一章 绪论现行的通用ESP产品组件也有不足的地方，所以本文的选题的目的是如何设计和实现我国中小型流程工业类企业ERP。1.1选题的背景和目的随着现代信息化技术的高速发展和广泛应用，全球化的市场和企业间本身的竞争日益加剧，ERP(EnterPris