本文選題：基建工程　切入點：SQL　出處：《電子科技大學(xué)》2014年碩士論文　論文類型：學(xué)位論文

【摘要】：工程建設(shè)項目隨著科學(xué)技術(shù)的發(fā)展和人類的剛性需求及投資需求的發(fā)展,規(guī)模越來越大,隨之而來的問題是項目復(fù)雜度和難度加大,質(zhì)量要求提高,傳統(tǒng)的管理方法已經(jīng)不能滿足基建工程管理的需求;隨著計算機技術(shù)、信息化技術(shù)的高速發(fā)展,將二者引入建筑工程管理是現(xiàn)代建筑行業(yè)發(fā)展的一種必然趨勢�；üこ添椖渴墙ㄖ袠I(yè)一種經(jīng)典的業(yè)務(wù)模式,通過完成既定的工程目標(biāo),來完成業(yè)務(wù)需求和經(jīng)典服務(wù)。采用建筑工地工程信息管理系統(tǒng)實現(xiàn)建筑工地項目工程的管理,不僅能夠出色的完成項目管理,而且能夠提高工作效率,節(jié)約資源,為建筑公司提供功能強大的財務(wù)核算功能。本文根據(jù)業(yè)務(wù)需求,提出了基于C/S架構(gòu)的建筑工地工程信息管理系統(tǒng)的實現(xiàn)方案,并結(jié)合POS機系統(tǒng)、數(shù)據(jù)庫系統(tǒng)、計算機網(wǎng)絡(luò)通信技術(shù)實現(xiàn)系統(tǒng)研發(fā),將系統(tǒng)分為三大模塊,即數(shù)據(jù)庫服務(wù)器系統(tǒng)、客戶端管理系統(tǒng)和POS機采集系統(tǒng)。數(shù)據(jù)庫服務(wù)器系統(tǒng)的實現(xiàn),采用SQL Server實現(xiàn)數(shù)據(jù)庫的設(shè)計,采用網(wǎng)絡(luò)通信、數(shù)據(jù)封裝、自動指令生成實現(xiàn)數(shù)據(jù)庫服務(wù)器端的設(shè)計。服務(wù)器端負責(zé)與客戶端之間通過網(wǎng)絡(luò)進行數(shù)據(jù)通信,按需提供收包功能、解包功能、指令解釋功能和發(fā)包功能,保證系統(tǒng)數(shù)據(jù)庫的穩(wěn)定正常運行�？蛻舳斯芾硐到y(tǒng)采用設(shè)計模式在MFC下實現(xiàn)系統(tǒng)架構(gòu),增加軟件重做和撤銷功能,實時監(jiān)控數(shù)據(jù)狀態(tài),所需數(shù)據(jù)采用網(wǎng)絡(luò)通信方式從數(shù)據(jù)庫服務(wù)器獲取�？蛻舳酥饕譃檫\行層模塊、數(shù)據(jù)庫訪問模塊和通信模塊,三大模塊共同支撐良好人機交互系統(tǒng)的運行。POS機采集系統(tǒng)主要分為管理模塊、采集模塊和通信模塊,采用Linux嵌入式系統(tǒng)下的POS機界面編程實現(xiàn)管理模塊;采集模塊采用RFID識別技術(shù)實現(xiàn)數(shù)據(jù)讀取和采集;通信模塊采用網(wǎng)絡(luò)通信技術(shù)、GPRS無線通信技術(shù)和文件傳輸技術(shù)實現(xiàn),保證數(shù)據(jù)的實時性和完整性,確保系統(tǒng)的穩(wěn)定運行。本文系統(tǒng)根據(jù)建筑工地工程管理流程和業(yè)務(wù)需求,經(jīng)過較長時期的測試和使用,驗證了建筑工地工程信息管理系統(tǒng)的安全性、穩(wěn)定性和可靠性。該系統(tǒng)對于提高工作效率,減少工程核算中的失誤問題起了重要作用。
[Abstract]:The engineering construction project with the development of science and technology development and the human's rigid demand and investment demand, increasingly large scale, the problem is the project complexity and difficulty, improve the quality requirements, the traditional management method has been unable to meet the construction management requirements; with the development of computer technology, the rapid development of information technology, two the construction project management is an inevitable trend of the development of modern construction industry. The construction project is the construction industry a classic business model, through the established goal of the project, to complete the business needs and services. The classic information management system construction engineering construction site project management, not only can be good the completion of the project management, but also can improve the work efficiency, saving resources, provide a powerful financial accounting function for the construction company in this paper. According to the business needs, proposed the implementation scheme of C/S site construction based on information management system, combined with the POS machine system, database system, system research and development of computer network communication technology, the system is divided into three modules, namely the database server system, the client management system and POS database server acquisition system. The system design, using SQL Server database, network communication, data encapsulation, design and implementation of database server. The server is responsible for generating automatic instruction and data communication between the client through the network, on-demand packet receiving function, unpack function, and the function of instruction interpretation function, ensure the stability of the normal operation of the system database the client management system. The system architecture design pattern implementation in MFC software, increase the redo and Undo function, real time monitoring data. State, the data required by network communication and access from the database server. The client is divided into operation module, database module and communication module, running.POS acquisition system of three modules to support the good human-computer interaction system is divided into management module, collection module and communication module, using Linux embedded system POS machine interface programming management module; acquisition module uses RFID technology to realize data acquisition and recognition reading; communication module based on network communication technology, GPRS wireless communication technology and file transmission technology, real-time and data integrity, ensure the stable operation of the system. This system according to the construction site project management processes and business requirements, after test and use a longer period, verify the safety of the information management system of construction project, the stability and reliability of the system. It plays an important role in improving work efficiency and reducing errors in engineering accounting.

【學(xué)位授予單位】：電子科技大學(xué)
【學(xué)位級別】：碩士
【學(xué)位授予年份】：2014
【分類號】：TU71;TP311.52

【參考文獻】

相關(guān)期刊論文 前1條

1 郭亞文;;國外POS機發(fā)展動向[J];信息與電腦;2008年04期

，

本文編號：1607371