楼盘销售管理系统的设计与实现
|
摘要
随着房地产业的不断发展,利用电脑的先进管理手段,把售楼人员从一大堆合同中解放出来,将楼盘的销售推向“无纸化”已经成了解决当前房地产售楼管理的当务之急。本系统介绍的售楼管理就是为了实现这一目标而设计的。管理人员通过该系统可以及时了解楼盘的动态销售情况,还能充分利用电脑的可检索性,方便,快速地了解有关楼盘销售的其他各种详细资料,以便及时做出正确决策。不但极大地降低管理人员的工作强度、提高管理人员的工作效率,而且使数据的准确性、安全性也有保证;最大程度的节约资源。
本系统结合售楼企业实际工作中存在的通用需求,经过详细的需求分析,采用VB作为开发工具、SQL作为数据库开发出来的楼盘销售管理系统。整个系统各操作窗口清新、大方,操作方便,包含了房产管理、客户管理、收费管理、售楼管理四大功能模块。论文主要介绍了本课题的开发背景,所要完成的功能和开发的过程。重点的说明了系统设计的重点、设计思想、主要任务和解决方案。
Nowadays, with the steps into information society, knowledge-based economy has become a mainstream industry in the new century. On the promotion and use of them, computers have created a lot of efficiencies in many fields such as scientific research, production, commerce and service. At the same time, unit cost on technique appears declining obviously year by year, while office expense is continuously increasing. In foreign countries, it costs both professional and administrative staff cost from 2/3 to 4/5 out of the whole office expense, which makes the demands of office automation increasing day by day. Therefore, the moment institution reform is taken, modernization management equipment, action and method are all in urgent need.
With the fast development of software and hardware technology, computer technique has played an important role in all aspects in social life, especially in computer management field. Application on advanced programming language and database technology helps to save much more human and material resource, serving the human society in more efficiency from all kinds of causes. Moreover, with its popularity, computer technology will be applied in all walks of life. Following the progress of real estate industry, with the help of advanced computer management method it has been a preoccupation to take“no-paper”property sale into action, releasing the sales staff from hills of contracts in the working. This system introduces such property sale management solely designed for this kind of demand.
Property sale management system(hereunder PSMS) is a kind of database management system for a certain enterprise, being handled by computers instead of manpower a series of operation such as housing information, client adding, amending, contract making, charge managing, information searching, client finding, contract indexing, charge inquiring, handling and so on. The main task of PSMS is to coordinate among client material, sales contract and charge trace, in order to get sales information in convenience and high-speed, which helps the clerks a lot to finish housing property, client and charge management easier and faster. Therefore, the research and designment are playing an active role as regards to increase working efficiency, system reliability and sales management, gaining definite economic benefit.
PSMS is part of indispensability in modernization management, being necessary condition of adapting modern enterprise system demands and promoting its scientization and standardization
PSMS is applied to support the whole process of housing property sale management, with which it realizes following three targets:
●To support the enterprise to realize the standard management.
●To support the enterprise to finish the daily operation including property, client, charge, sale management and so on.
●To support the enterprise to make scientific decision on sales management and others aspects.
When designing the system, the writer tries the best to introduce current software and hardware in enterprise as well as its advanced management developing plan, making full use of existing resources, improving the system development for application. The system caters for the general existing demands of enterprise in practical working, achieving direct-perception, convenience, practicality, security needs and so on during the operation. It adopts the design theory of modular program, which is not only convenient for system functions on kinds of combination modification but also easy for technical maintenance staff who are not involved in the development to make more supplement and maintenance. At the same time, it is also provided with database maintaining function upon which operations are done such as data add, delete, modify, or prepare based on clients’demands. PSMS is able to find out dynamic sales status in time, make full use of the computer’s search functions, manage to know other details about housing selling in convenience and fast-speed, in order that the right decision could be made in time.
Visual Basic and SQL server database are applied in this system. The users have to log on the system upon controller’s verification in order for them to work under management interface. It realizes lots of managing functions on property sales, including updating house information, adding/amending clients’information, signing the contract and managing the charge issue. The whole function could not only finish the searches for property, clients, contract and charge information but also solve piles of tedious working problems such as clients information, contracts, charge status. It has been playing an active role as regards to increase working efficiency, system reliability and sales management, which gains definite economic benefit.
Regards to the background of property sales management development, the essay makes an in-depth research, and make a brief introduction of Visual Basic and SQL server 2000 with explanations on these technical terms, two kinds of software that are mentioned in the system, and then it makes detailed demanding analyse, ends with the design for interface module protection, realizing its functions, offering the corresponding codes and remarking after essential process, which could be easily understood and be clear at a glance.
The research, based mainly on traditional manual working, is taking advantage of and making full use of the computers’fast-speed and accuracy in order that huge of tedious work could be done by computers; the exploitation of this system also caters for the demands of resource-saving advocated in social life, applying itself into non-paper office automation more widely. Real estate deal is quite a common phenomenon in daily life that happens every day nowadays. However, the developers, who are busy in doing the developing, are always aimlessly employing more salesmen focusing on the selling, which wastes both human resources and expense. The system in the essay could make the minority manage to finish the work that is done by numerous person before. It not only saves the human resources, but also releases the developers from unnecessary energy on sales management, so that people are easy to know the dealing status as well as working diligence, which could be applied with more value in future social society.
In a conclusion, the essay percolates through a great deal of practice from research to design, combining theory with practice as much as possible, as well as writer’s most efforts. Anyway, due to a series of objective reasons like pressure for time, there are still problems and some places to improve. If possible, it could be more valuable to develop it into a network system.
本系统结合售楼企业实际工作中存在的通用需求,经过详细的需求分析,采用VB作为开发工具、SQL作为数据库开发出来的楼盘销售管理系统。整个系统各操作窗口清新、大方,操作方便,包含了房产管理、客户管理、收费管理、售楼管理四大功能模块。论文主要介绍了本课题的开发背景,所要完成的功能和开发的过程。重点的说明了系统设计的重点、设计思想、主要任务和解决方案。
Nowadays, with the steps into information society, knowledge-based economy has become a mainstream industry in the new century. On the promotion and use of them, computers have created a lot of efficiencies in many fields such as scientific research, production, commerce and service. At the same time, unit cost on technique appears declining obviously year by year, while office expense is continuously increasing. In foreign countries, it costs both professional and administrative staff cost from 2/3 to 4/5 out of the whole office expense, which makes the demands of office automation increasing day by day. Therefore, the moment institution reform is taken, modernization management equipment, action and method are all in urgent need.
With the fast development of software and hardware technology, computer technique has played an important role in all aspects in social life, especially in computer management field. Application on advanced programming language and database technology helps to save much more human and material resource, serving the human society in more efficiency from all kinds of causes. Moreover, with its popularity, computer technology will be applied in all walks of life. Following the progress of real estate industry, with the help of advanced computer management method it has been a preoccupation to take“no-paper”property sale into action, releasing the sales staff from hills of contracts in the working. This system introduces such property sale management solely designed for this kind of demand.
Property sale management system(hereunder PSMS) is a kind of database management system for a certain enterprise, being handled by computers instead of manpower a series of operation such as housing information, client adding, amending, contract making, charge managing, information searching, client finding, contract indexing, charge inquiring, handling and so on. The main task of PSMS is to coordinate among client material, sales contract and charge trace, in order to get sales information in convenience and high-speed, which helps the clerks a lot to finish housing property, client and charge management easier and faster. Therefore, the research and designment are playing an active role as regards to increase working efficiency, system reliability and sales management, gaining definite economic benefit.
PSMS is part of indispensability in modernization management, being necessary condition of adapting modern enterprise system demands and promoting its scientization and standardization
PSMS is applied to support the whole process of housing property sale management, with which it realizes following three targets:
●To support the enterprise to realize the standard management.
●To support the enterprise to finish the daily operation including property, client, charge, sale management and so on.
●To support the enterprise to make scientific decision on sales management and others aspects.
When designing the system, the writer tries the best to introduce current software and hardware in enterprise as well as its advanced management developing plan, making full use of existing resources, improving the system development for application. The system caters for the general existing demands of enterprise in practical working, achieving direct-perception, convenience, practicality, security needs and so on during the operation. It adopts the design theory of modular program, which is not only convenient for system functions on kinds of combination modification but also easy for technical maintenance staff who are not involved in the development to make more supplement and maintenance. At the same time, it is also provided with database maintaining function upon which operations are done such as data add, delete, modify, or prepare based on clients’demands. PSMS is able to find out dynamic sales status in time, make full use of the computer’s search functions, manage to know other details about housing selling in convenience and fast-speed, in order that the right decision could be made in time.
Visual Basic and SQL server database are applied in this system. The users have to log on the system upon controller’s verification in order for them to work under management interface. It realizes lots of managing functions on property sales, including updating house information, adding/amending clients’information, signing the contract and managing the charge issue. The whole function could not only finish the searches for property, clients, contract and charge information but also solve piles of tedious working problems such as clients information, contracts, charge status. It has been playing an active role as regards to increase working efficiency, system reliability and sales management, which gains definite economic benefit.
Regards to the background of property sales management development, the essay makes an in-depth research, and make a brief introduction of Visual Basic and SQL server 2000 with explanations on these technical terms, two kinds of software that are mentioned in the system, and then it makes detailed demanding analyse, ends with the design for interface module protection, realizing its functions, offering the corresponding codes and remarking after essential process, which could be easily understood and be clear at a glance.
The research, based mainly on traditional manual working, is taking advantage of and making full use of the computers’fast-speed and accuracy in order that huge of tedious work could be done by computers; the exploitation of this system also caters for the demands of resource-saving advocated in social life, applying itself into non-paper office automation more widely. Real estate deal is quite a common phenomenon in daily life that happens every day nowadays. However, the developers, who are busy in doing the developing, are always aimlessly employing more salesmen focusing on the selling, which wastes both human resources and expense. The system in the essay could make the minority manage to finish the work that is done by numerous person before. It not only saves the human resources, but also releases the developers from unnecessary energy on sales management, so that people are easy to know the dealing status as well as working diligence, which could be applied with more value in future social society.
In a conclusion, the essay percolates through a great deal of practice from research to design, combining theory with practice as much as possible, as well as writer’s most efforts. Anyway, due to a series of objective reasons like pressure for time, there are still problems and some places to improve. If possible, it could be more valuable to develop it into a network system.
引文
[1].林杰斌. MIS管理信息系统-信息系统经典解析,北京:清华大学出版社,2006
[2].闵联营. Visual Basic程序设计,北京:北京大学出版社,2006,86-119
[3].陈学东. Visual Basic6.0程序设计实验教程,北京:电子工业出版社,2007,25-184
[4].吕凤顺. SQL Server数据库基础与实训教程,北京:清华大学出版社,2006,2-95
[5].王小铭.管理信息系统学习与开发实践指南,华南理工大学出版社,2004,36-122
[6].李芷.软件工程方法与实践,北京:电子工业出版社,2004,68-79
[7].陈春玲、陈丹伟、李频.软件工程与数据库概论,西安:西安电子科技大学出版社,2002.87-125
[8].张志清.管理信息系统实用教程,北京:电子工业出版社,2004,47-120
[9].钟珞.现代软件工程学,国防工业出版社,2004,122-158
[10].王春才. Visual Basic数据库系统开发完全手册,北京:人民邮电出版社,2006
[11]. (美)斯蒂尔勒/(美)勒布朗.基于项目的软件工程:面向对象方法,北京:高等教育出版社, 2002,187-234
[12].赵杰,李涛,余江,王浩全.数据库原理与应用-(SQL Server),人民邮电出版社,2006, 100-190
[13].邓良松.软件工程,西安:西安电子科技大学出版社,2004
[14].李成忠,张新有,贾真.计算机网络应用与实验教程(第2版),北京:电子工业出版社,2007,178-263
[15].董吉文.计算机网络技术与应用,北京:电子工业出版社,2006
[16].赵子江,王丹.数据库原理与SQL Server应用,北京:机械工业出版社,2006,149-250
[17].王彤宇王秀红张冬霞王春红.管理信息系统,北京:中国水利水电出版社,2004,10-166
[18].耿骞.数据库应用基础-SQL Server2000,北京:高等教育出版社, 6-152
[19].贾志华.管理信息系统,北京:机械工业出版社,2006
[20].段爱玲张德贤张红梅孙会峰唐建国.管理信息系统,北京:机械工业出版社,2005,65-92
[21].王知强.管理信息系统入门与提高,北京:清华大学出版社,2005,162-188
[22].蒋秀英. SQLSERVER2000数据库与应用,北方交通大学出版社, 2006
[23].聂元铭,丘平.网络信息安全技术[M],北京:科学出版社,2001,132-198
[24]. Saadat Malik,CCIE No. 4955.网络安全原理与实践[M],北京:人民邮电出版社,2003
[25].张彦清. SQL SERVER 2000程序设计,北京:清华大学出版社,2005,47-68
[26]. Eric L.Brown吴戈. SQL Server 2005中文版精粹,北京:机械工业出版社,2007,140-193
[27].赵海峰.局域网组网实务,北京:电子工业出版社,2007,13-128
[28].第一时间工作室. VisualBasic6.0程序设计技能百练(1CD),北京:中国铁路出版社,2005
[29].刘瑞新. VisualBasic程序设计教程(第二版),北京:电子工业出版社,2003,121-177
[30].王颖. Visual Basic + SQL Server数据库应用实例完全解析-混合编程之案例详解,北京:人民邮电出版社,2006,125-255
[31].皱先霞. Visual Basic程序设计实训教程,北京:冶金工业出版社,2006, 51-161
[32].马力. Visual Basic 6.0程序设计,北京:北京大学出版社,2005,130-180
[33].陈世洪. SQL Server 2000管理.开发及应用实例详解-(附光盘),2006
[34].罗朝盛. Visual Basic 6.0程序设计实用教程,北京:清华大学出版社,2006,300-357
[35].徐恪,吴建平,徐明伟.高等计算机网络[M],北京:机械工业出版社,2003
[2].闵联营. Visual Basic程序设计,北京:北京大学出版社,2006,86-119
[3].陈学东. Visual Basic6.0程序设计实验教程,北京:电子工业出版社,2007,25-184
[4].吕凤顺. SQL Server数据库基础与实训教程,北京:清华大学出版社,2006,2-95
[5].王小铭.管理信息系统学习与开发实践指南,华南理工大学出版社,2004,36-122
[6].李芷.软件工程方法与实践,北京:电子工业出版社,2004,68-79
[7].陈春玲、陈丹伟、李频.软件工程与数据库概论,西安:西安电子科技大学出版社,2002.87-125
[8].张志清.管理信息系统实用教程,北京:电子工业出版社,2004,47-120
[9].钟珞.现代软件工程学,国防工业出版社,2004,122-158
[10].王春才. Visual Basic数据库系统开发完全手册,北京:人民邮电出版社,2006
[11]. (美)斯蒂尔勒/(美)勒布朗.基于项目的软件工程:面向对象方法,北京:高等教育出版社, 2002,187-234
[12].赵杰,李涛,余江,王浩全.数据库原理与应用-(SQL Server),人民邮电出版社,2006, 100-190
[13].邓良松.软件工程,西安:西安电子科技大学出版社,2004
[14].李成忠,张新有,贾真.计算机网络应用与实验教程(第2版),北京:电子工业出版社,2007,178-263
[15].董吉文.计算机网络技术与应用,北京:电子工业出版社,2006
[16].赵子江,王丹.数据库原理与SQL Server应用,北京:机械工业出版社,2006,149-250
[17].王彤宇王秀红张冬霞王春红.管理信息系统,北京:中国水利水电出版社,2004,10-166
[18].耿骞.数据库应用基础-SQL Server2000,北京:高等教育出版社, 6-152
[19].贾志华.管理信息系统,北京:机械工业出版社,2006
[20].段爱玲张德贤张红梅孙会峰唐建国.管理信息系统,北京:机械工业出版社,2005,65-92
[21].王知强.管理信息系统入门与提高,北京:清华大学出版社,2005,162-188
[22].蒋秀英. SQLSERVER2000数据库与应用,北方交通大学出版社, 2006
[23].聂元铭,丘平.网络信息安全技术[M],北京:科学出版社,2001,132-198
[24]. Saadat Malik,CCIE No. 4955.网络安全原理与实践[M],北京:人民邮电出版社,2003
[25].张彦清. SQL SERVER 2000程序设计,北京:清华大学出版社,2005,47-68
[26]. Eric L.Brown吴戈. SQL Server 2005中文版精粹,北京:机械工业出版社,2007,140-193
[27].赵海峰.局域网组网实务,北京:电子工业出版社,2007,13-128
[28].第一时间工作室. VisualBasic6.0程序设计技能百练(1CD),北京:中国铁路出版社,2005
[29].刘瑞新. VisualBasic程序设计教程(第二版),北京:电子工业出版社,2003,121-177
[30].王颖. Visual Basic + SQL Server数据库应用实例完全解析-混合编程之案例详解,北京:人民邮电出版社,2006,125-255
[31].皱先霞. Visual Basic程序设计实训教程,北京:冶金工业出版社,2006, 51-161
[32].马力. Visual Basic 6.0程序设计,北京:北京大学出版社,2005,130-180
[33].陈世洪. SQL Server 2000管理.开发及应用实例详解-(附光盘),2006
[34].罗朝盛. Visual Basic 6.0程序设计实用教程,北京:清华大学出版社,2006,300-357
[35].徐恪,吴建平,徐明伟.高等计算机网络[M],北京:机械工业出版社,2003