【正文】 .................................................................. 7 167。 C編程簡介 ................................................................................. 3 167。 房屋中介行業(yè)做為一個管理房屋信息的機構(gòu) ，其對信息的管理應(yīng)該準確，無誤。 關(guān)鍵詞 ：房屋中介， C/S 模式， .NET，斷開式連接，非斷開式連接 河南科技大學(xué)本科畢業(yè)設(shè)計（論文） II HOUSING INTERMEDIARY MANAGEMENT SYSTEM ABSTRACT As an essential part of real estate industry, property agents exist in the whole economic operation of this industry, providing diversified services for the production, logistic and consumption of real estate industry. As an information management institution, property agents should ensure the information is precise and correct. Designing a set of management software for property agent by using the knowledge of software engineering design and database is very important for improving the efficiency of property agents. In this paper, we talk about the theory basis and designing ideas of property agent management system and introduce all the functions in the property agent management system. Using software engineering theories as the theory foundation of system developing, we have designed and realized the goal to manage the information on leasing and selling houses, on clients who want to rent or purchase a house and on the record of property demands. Therefore, precise information are provided in a timely manner. This paper mainly includes the following content: management on property information, the design and building of database as well as the relationship among the people have since always used the traditional artificial way to manage housing rental, Qiuzu other housing information, the management has many shortings, such as low efficiency, poor security, so to find, update and maintain the housing information brings many difficulties, housing intermediary management system appears to change this situation, it is able to the operators and users to provide sufficient information and the quick inquiry method. 河南科技大學(xué)本科畢業(yè)設(shè)計（論文） III KEY WORDS ： Housing intermediary， Browser/Server ， NET ， Open Connection， Non Disconnect Connection.河南科技大學(xué)本科畢業(yè)設(shè)計（論文） IV 目 錄 前 言 ....................................................................................................... 1 第 1 章 系統(tǒng)概述 .................................................................................... 2 167。 技術(shù)可行性 ......................................................................... 5 167。 視圖設(shè)計 ....................................................................................13 167。 員工信 息設(shè)置模塊設(shè)計 ...........................................................19 167。河南科技大學(xué)本科畢業(yè)設(shè)計（論文） 2 第 1章 系統(tǒng)概述 167。它是由許多房地產(chǎn)經(jīng)紀人聯(lián)合起來，共同建立信息系統(tǒng)，共享系統(tǒng)的信息資源，使客戶委托的房地產(chǎn)出售、出租業(yè)務(wù)能在較短的時間內(nèi)完成。隨著 C語言的不斷 完善，其中又新增了包括泛型、迭代器和匿名方法等重要特性，與Microsoft Visual Studio 2020 結(jié)合使用將顯著提高開發(fā)者的工作效率。 安全性：隨著 Web 應(yīng)用程序的日益強大和完善，安全性也變得越來越重河南科技大學(xué)本科畢業(yè)設(shè)計（論文） 4 要。 系統(tǒng)開發(fā)平臺： Microsoft Visual Studio 2020。信息化的系統(tǒng)開發(fā)方法確實在開發(fā)實踐中取得了一定的效果。 技術(shù)可行性 本系統(tǒng)的開發(fā)利用 Microsoft SQL Server2020 作為本系統(tǒng)的數(shù)據(jù)庫，河南科技大學(xué)本科畢業(yè)設(shè)計（論文） 6 它是一個關(guān)系 型數(shù)據(jù)庫，而且最基本的功能和 SQL2020 都一樣，增加的都是擴展的功能，它是一個支持多用戶的新型數(shù)據(jù)庫適用于大中規(guī)模的數(shù)據(jù)量需求。 河南科技大學(xué)本科畢業(yè)設(shè)計（論文） 7 167。河南科技大學(xué)本科畢業(yè)設(shè)計（論文） 8 第 3章 總體 設(shè)計 167。 （ 7） 對用戶輸入的數(shù)據(jù)進行嚴格的數(shù)據(jù)檢驗，盡可能避免人為錯誤。 視圖設(shè)計 視圖是一種常用的數(shù)據(jù)庫對象，可以把它看成虛擬表或存儲在數(shù)據(jù)庫中的查詢，它為查看和存取數(shù)據(jù)提供了另外一種途徑。 觸發(fā)器設(shè)計 觸發(fā)器是一種特殊的存儲過程，它與表格緊密相連。 AND type = 39。 begin pwd set lpo=39。原始密碼 39。 圖 51 房屋中介管理系統(tǒng)主窗體的運行結(jié)果 167。 房源信息查詢模塊設(shè)計 本模塊使用的數(shù)據(jù)表： tb_favor 、 tb_fitment、 tb_floor、 tb_mothed、tb_seat 、 tb_type 本模塊使用的視圖： view_house 房源信息查詢模塊是房屋中介管理系統(tǒng)中重要的功能之一，它主要根據(jù)物業(yè)名稱、樓層、價格、面積和朝向等條件對房源信息進行查詢，并且部分字段支持模糊查詢。 當(dāng) 添 加 新 員 工 時 ， 通 過 觸 發(fā) 器 trig_insetOfEmployeeinLogin 將其添加到用戶信息表中，并且將密碼及權(quán)限進行初始化，如將密碼統(tǒng)一為 111，權(quán)限為普通員工。房屋中介管理系統(tǒng)中的房源狀態(tài)查詢主要體現(xiàn)了這一點，不同狀態(tài)的房屋在瀏覽時顯示出不同的圖標，這樣使系統(tǒng)操作員對查詢結(jié)果一目了然；同時為了方便數(shù)據(jù)的瀏覽，還提供了多種房源狀態(tài)查看方式。s information system blueprint. In the information system planning, you can build an enterprise data model as a whole information system architecture part. According to Zachman (1987), Sowa and Zachman (1992) views of an information system architecture consists of the following six key ponents: Data (Figure 1 shows, but there are other methods that). Manipulation of data processing (of a data flow diagram can be used, with the object model methods, or other symbols that). Networks, which anizations and in anizations wi th its main transmission of data between business partners (it can connect through the work topology map and to demonstrate). People who deal with the implementation of data and information and is the source and receiver (in the process model for the data shows that the sender and the receiver). Implementation of the events and time points (they can use state transition diagram and other means.) The reasons for the incident and data processing rules (often in the form of text display, but there are also a number of charts for the planning tools such as decision tables). Information Engineering Information systems planners in accordance with the specific information system planning methods developed information system architecture. Information engineering is a popular and formal methods. Information engineering is a dataoriented creation and maintenance of the information system. Information engineering is because the dataoriented, so when you begin to understand how the database is defined by the logo and when information engineering a concise explanation is very helpful. Information Engineering follow topdown planning approach, in which specific information systems from 河南科技大學(xué)本科畢業(yè)設(shè)計（論文） 25 a wide range of information needs in the understanding derived from (for example, we need about customers, products, suppliers, sales and processing of the data center), rather than merging many detailed