本文關(guān)鍵詞： SMT防錯FoxPro ERP C/S 表面貼裝技術(shù)　出處：《電子科技大學》2014年碩士論文　論文類型：學位論文

【摘要】：近些年,隨著電子產(chǎn)業(yè)的興起,尤其是電子元器件的高速發(fā)展,以及集成電子電路的創(chuàng)新開發(fā),使得電子產(chǎn)品不斷的向小型化發(fā)展,而電子產(chǎn)品的功能卻更加的豐富,這些電子產(chǎn)品大多采用大規(guī)模、高集成電路,在制造過程中采用時下最為流行的表面貼裝技術(shù)(SMT,Surface Mounted Technology)。表面貼裝技術(shù)的生產(chǎn)過程中采用速運轉(zhuǎn)的設備,這些設備具有大批量生產(chǎn)和工藝精密的特點,這些特點決定了在SMT生產(chǎn)過程中不能出現(xiàn)差錯,否則會造成材料錯誤,而導致產(chǎn)品不良報廢,人力成本攀高和設備折舊成本增高。因而迫切的需要防錯措施,以減少因表面貼裝生產(chǎn)線的原料錯誤所造成的生產(chǎn)損失,由此SMT防錯系統(tǒng)就應運而生。此論文根據(jù)表面貼裝技術(shù)(SMT)生產(chǎn)線的特點,結(jié)合蘇州A公司已有的物料供應鏈系統(tǒng),以及蘇州A公司對改進表面貼裝技術(shù)生產(chǎn)線的預算,論述了基于C/S體系結(jié)構(gòu),采用Visual FoxPro編程技術(shù),以及SQL Server數(shù)據(jù)庫技術(shù)開發(fā)設計SMT上料防錯ERP(Enterprise Resource Planning)系統(tǒng)。本文從系統(tǒng)需求分析,系統(tǒng)設計,系統(tǒng)實現(xiàn)和測試這幾個方面闡述了系統(tǒng)的建立。需求分析部分通過對蘇州A企業(yè)SMT生產(chǎn)線業(yè)務和供應鏈系統(tǒng)業(yè)務的分析,得出A企業(yè)的業(yè)務需求,并且根據(jù)需求總結(jié)出本系統(tǒng)所需要的功能模塊。系統(tǒng)設計部分,根據(jù)需求分析的結(jié)果,詳細介紹了系統(tǒng)各個模塊的設計方法思路,并且給出了系統(tǒng)所需的數(shù)據(jù)庫設計。系統(tǒng)實現(xiàn)部分闡述了利用Visual Foxpro編程環(huán)境,實現(xiàn)本系統(tǒng)各個模塊的細節(jié)和方法。系統(tǒng)測試部分,闡述了系統(tǒng)部署在蘇州A企業(yè)之后的運行情況,其測試的結(jié)果顯示滿足了蘇州A企業(yè)對此系統(tǒng)的要求。最終這個系統(tǒng)應用于A企業(yè)的表面貼裝生產(chǎn)線,本系統(tǒng)規(guī)范了蘇州A企業(yè)SMT生產(chǎn)線工人的操作流程,并提示了生產(chǎn)線即將缺料的料站,從而提A企業(yè)高表面貼裝生產(chǎn)線的供料精確度,提高生產(chǎn)質(zhì)量,減少產(chǎn)品不良率,并結(jié)合A企業(yè)的物料管理系統(tǒng),改進A企業(yè)的表面貼裝生產(chǎn)線的物料供應效率,從而節(jié)省人力成本。
[Abstract]:In recent years, with the rise of electronic industry, especially the rapid development of electronic components, as well as the innovative development of integrated electronic circuits, electronic products continue to develop to miniaturization, but the functions of electronic products are more abundant. Most of these electronic products are made of large scale, high integrated circuits, and the most popular surface mount technology in the manufacturing process is the SMT / Surface Mounted Technology. These equipments have the characteristics of mass production and precise process. These characteristics determine that there should be no errors in the production of SMT, otherwise they will cause material errors and lead to bad products. Higher labor costs and higher equipment depreciation costs. Therefore, there is an urgent need for error prevention measures to reduce production losses caused by errors in the raw materials of surface mount production lines, According to the characteristics of surface mount technology (SMT) production line, this paper combines the material supply chain system of Suzhou A Company and the budget of Suzhou A Company to improve the surface mount technology production line. Based on C / S architecture, using Visual FoxPro programming technology and SQL Server database technology to develop and design ERP(Enterprise Resource planning system for SMT loading and error prevention. The establishment of the system is described in the realization and test of the system. In the part of requirement analysis, the business requirements of A enterprise are obtained by analyzing the SMT production line and supply chain system business of Suzhou A enterprise. And according to the needs of the system summarized the functional modules. The system design part, according to the results of demand analysis, detailed introduction of the system of each module design ideas, At the same time, the database design needed by the system is given. In the part of system realization, the details and methods of each module of the system are realized by using Visual Foxpro programming environment. The operation of the system after being deployed in Suzhou A enterprise is described. The test results show that the system meets the requirements of Suzhou A enterprise. Finally, the system is applied to the surface mount production line of A enterprise. The system standardizes the operation flow of SMT production line workers in Suzhou A enterprise, and indicates that the production line is about to be short of material, thus raising the feeding accuracy of high surface mount production line, improving the production quality and reducing the defective rate of the product. Combined with the material management system of enterprise A, the material supply efficiency of the surface mount production line of enterprise A is improved, thus the labor cost is saved.
【學位授予單位】：電子科技大學
【學位級別】：碩士
【學位授予年份】：2014
【分類號】：TP311.52
，

本文編號：1538114