基于Android+asp.net+SQLite的生产车间产品质量品质管理系统 毕业论文+答辩PPT+项目源码+数据
【摘要】质量是产品永恒不变的主题，保证产品质量就是坚持企业的永续发展。近年来，许多企业为了使产品质量的管理更加智能化、更加有效率，纷纷引进计算机辅助系统来管理产品质量。然而，生产车间的条件限制必然导致难以将计算机作为采集数据的终端，这是像制鞋企业这类传统制造业企业面临的又一困难。而本文研究的产品质量管理系统，是一套基于Android终端的产品质量系统，以制鞋行业作为实现载体。它从品管员的角度考虑，采用有利于品管员携带的手机客户端，以便于采集质量数据。从数据分析人员以及企业经营者的角度考虑，采用便于质量数据分析和展示的网页客户端。从系统维护人员、开发人员以及经营成本的角度考虑，采用了软硬件裁剪的专门嵌入式设备作为管理数据的服务器，适合嵌入式开发的体积小且运算速快的SQLite3数据库。首先，本文先对项目需求进行分析，分别从市场、技术、经济三个角度综合考虑本系统实现的可行性。然后，从设计模式的角度加以分析本系统的架构，重点描述了本系统的功能模块，并利用用例图和流程图直观地反应本系统的主要功能。之后，简单描述了本系统实现的关键技术，主要包括多线程技术、IO多路复用技术、SQLite数据库技术、Socket通信技术以及ASP.Net的若干种技术。接着，本文花了大量笔墨介绍产品质量系统的实现，分别从手机客户端、数据库服务器端、网页客户端三个方面，阐述函数设计、编码实现以及工程三层架构的具体实现。最后，本文简单介绍了系统的使用说明并进行项目总结。【关键词】产品质量管理系统;品管系统;Android终端;鞋业产品质量管理系统Abstract:Product quality is the eternal theme, to ensure product quality is to adhere to the sustainable development of enterprises. In recent years, many companies in order to make the management of product quality more intelligent, more efficient, have introduced computer-aided system to manage product quality. However, the conditions of the production workshop will inevitably lead to difficult to computer as a data collection terminal, which is like shoe-making enterprises such traditional manufacturing enterprises are facing another difficult. This paper, the product quality management system is a set of product quality system based on Android terminal, as the realization of the carrier to the shoe-making industry. It is considered from the point of view of the quality control staff, is conducive to quality control staff to carry mobile client, in order to collect quality data. Considered from the point of view of data analysis and business, to facilitate quality data analysis and presentation in the web client. Maintenance personnel, developers, and operating costs from the system point of view, the use of specialized embedded hardware and software to crop equipment as management data server, suitable for the small size and fast computing speed SQLite3 database embedded development. First, this paper first analyze the needs of the project, considering the three angles from the market, technical, economic feasibility of the system. Then, from the point of view of the design pattern analysis of the structure of the system, focusing on description of the function of the system module, and use case diagrams and flow charts intuitively reflect the main functions of the system. After a brief description of the key technologies in the system, including the multi-threading technology, the IO multiplexing technology, SQLite database technology, Socket communication technology and ASP.Net certain kinds of technology. Then, we spent a lot of ink on product quality system implementation, respectively, from the mobile client, the database server side, the web client three aspects of the function design, coding, and the concrete realization of the project three-tier architecture. Finally, the paper briefly describes the instructions for use of the system, system testing, and project summary.Key words：Product quality management system; quality control system; Android terminal; footwear product quality management system目 录1 绪论 41.1项目背景 41.2项目意义 42 需求分析 42.1功能性需求 42.2非功能性需求 53 可行性分析 53.1市场可行性 53.2技术可行性 53.3经济可行性 64 系统概要设计 64.1系统用例图 64.2系统功能模块描述 64.2.1手机客户端各功能模块描述 74.2.2数据库服务器端各功能模块描述 74.2.3网页客户端各功能模块描述 74.3系统流程图 74.3.1质量数据采集 74.3.2数据库服务器 84.3.3数据展示与分析 84.4 系统运行环境 95 系统详细设计 95.1系统架构 95.2系统设计模式 105.2.1传统两层客户机/服务器模式(C/S) 105.2.2浏览器/服务器模式(B/S) 105.3数据库设计 115.3.1表格设计 115.3.2数据库配置优化 135.4网络连接设计 146 系统实现 156.1 系统实现关键技术 156.1.1多线程服务器 156.1.2面向连接的Socket编程模型 166.1.3 IO多路复用 176.1.4 SQLite3数据库 176.1.5 ASP.Net 176.2数据库服务器的实现 186.2.1概述 186.2.2主程序模块 186.2.3业务处理模块 196.2.4 Socket通信模块 196.2.5线程池模块 196.2.6字符串处理模块 196.2.7数据库访问模块 196.2.8调试模块 206.2.9 编译、移植和运行 206.3手机客户端的实现 216.3.1概述 216.3.2界面实现 216.3.3面向连接的Socket通信模块 216.3.4本地缓存模块 226.3.5业务逻辑模块 236.3.6工程代码架构 236.3.7编译与运行 236.4网页客户端的实现 246.4.1概述 246.4.2网页前端 246.4.3网页后端 246.4.4工程代码架构 256.4.5编译与运行 267 系统使用说明 267.1运行数据库服务器 267.2采集质量数据 277.3显示分析数据 298总结 37致谢 38参考文献 38
