上海大众销售服务地图管理系统的设计与实现
摘要
随着科学技术的飞速发展,信息自动化已经成为各个企业非常重要的工作。上海大众目前采取的人工管理和手工操作的工作方式不仅在效率上跟不上时代的要求,而且在处理大批量数据时非常容易出错。由于其所涉及到的汽车销售数据的更新频率很快,并且数量繁多,如果依靠传统的方式,从各个经销商的营业网点收集到的汽车销售数据必须用人工的方式与注册信息进行比对处理,然后制作出统计表格,最后用图像工具制作出各种专题图。这样不仅导致了企业成本的增加,并且使得统计出来的数据失去了时效性,很大程度上影响了企业策略的制定和调整。因此很需要采用一套有效可靠的系统来对数据进行快速处理并以直观的方式表现出来。
基于以上背景,本系统以组件式GIS软件进行开发,采用了面向对象的编程思想,根据业务的需求和特点采用桌面式结构,地图平台采用MapXtreme提供的嵌入组件,用可视化编程语言VS.C#实现地图图元的基本操作和空间数据的处理,属性数据则采用MySql和Access数据库进行管理。整个系统的查询和管理功能都在VS2005平台上实现。
本文首先概要说明了GIS的基本理论和用于开发本系统的二次平台MapInfo、MapX等相关技术,重点论述了该系统的设计与实现的整个过程,最后详细描述了开发该系统所用到的关键技术。例如:如何获取地图的空间数据,空间数据如何与属性数据关联,地图如何加载的更快,更合理等。本文的主要研究成果是将基于ActiveX技术的MapX组件嵌入VS2005系统集成开发环境中,引入系统所需的GeoSet地图,进行一系列GIS功能模块的开发。完成空间数据与属性数据的分析处理工作,建立适合各种数据分析的GIS空间数据库与属性数据库。通过这些技术的实现,该系统可以根据经销商的销售信息和各种数据进行销量的有效分析,统计出销量的流向和状态,通过散点图和涂色图等专题图的方式表现出来,为管理层的决策提供科学依据。同时兼顾系统的扩展性,为将来进一步的开发提供方便。
With the fast development of science and technology, information automation has already become a very important job for each enterprise.The artificial management and hand-operated working way that Shanghai Volkswagen takes at present can not merely catch up with the times on efficiency, and very apt to make mistakes while dealing with the data in enormous quantities. Because the renewal of automobile sale information is rapid, and the quantity is various, if just depend on the traditional way, we have to analyse and compare the sale date collected from distributor’s agency with the registration imformation in artificial way,and then make out statistics tables, make out various thematic pictures with the picture tool finally. It would not only cause the increasing of cost, and also lose effectiveness, furthermore it have influenced the adjustment of enterprise's tactics to a great extent. So we need an effective and reliable system that would deal with the data quickly and show it directly.
Base on upwards background,the popular ComGIS software MapX is used to develop this system,and according to the requirement applied by client,this system is built as a desktop system with object-oriented way.Visual programming language VS.C# is used to realize the basic operation of the map features and spatial data. Database MySql and Access are used to manage Attribute data. The whole inquiry and management functions of the system are realized at VS2005 platform.
The article explains the basic theories of GIS and the related technologies of MapInfo and MapX which is the twice platform of the system.And focus on describing the process of how the system designed and realized. At length,it describes the key technologies the system used.Such as how to get the spatial data,how the spatial date and attribute data related,how to load the maps in fast speed and more effective,etc.The results of this study is embed the ComGIS MapX based on the ActiveX into the integrated Development Environment of VS2005,needed GeoSet maps are inputted and a series of function modules are developed.Finished the analysis work of spatial data and attribute data,and build database fit for them.Though the technologies,this system could analyse sale results effectively with the sale information and various other data,get the trend and status of the sale information and describe them as thematic pictures,which would give scientific support to the manager. Give consideration to systematic expansion,at the same time,this system contained and offered the convenience to further development in the future.
基于以上背景,本系统以组件式GIS软件进行开发,采用了面向对象的编程思想,根据业务的需求和特点采用桌面式结构,地图平台采用MapXtreme提供的嵌入组件,用可视化编程语言VS.C#实现地图图元的基本操作和空间数据的处理,属性数据则采用MySql和Access数据库进行管理。整个系统的查询和管理功能都在VS2005平台上实现。
本文首先概要说明了GIS的基本理论和用于开发本系统的二次平台MapInfo、MapX等相关技术,重点论述了该系统的设计与实现的整个过程,最后详细描述了开发该系统所用到的关键技术。例如:如何获取地图的空间数据,空间数据如何与属性数据关联,地图如何加载的更快,更合理等。本文的主要研究成果是将基于ActiveX技术的MapX组件嵌入VS2005系统集成开发环境中,引入系统所需的GeoSet地图,进行一系列GIS功能模块的开发。完成空间数据与属性数据的分析处理工作,建立适合各种数据分析的GIS空间数据库与属性数据库。通过这些技术的实现,该系统可以根据经销商的销售信息和各种数据进行销量的有效分析,统计出销量的流向和状态,通过散点图和涂色图等专题图的方式表现出来,为管理层的决策提供科学依据。同时兼顾系统的扩展性,为将来进一步的开发提供方便。
With the fast development of science and technology, information automation has already become a very important job for each enterprise.The artificial management and hand-operated working way that Shanghai Volkswagen takes at present can not merely catch up with the times on efficiency, and very apt to make mistakes while dealing with the data in enormous quantities. Because the renewal of automobile sale information is rapid, and the quantity is various, if just depend on the traditional way, we have to analyse and compare the sale date collected from distributor’s agency with the registration imformation in artificial way,and then make out statistics tables, make out various thematic pictures with the picture tool finally. It would not only cause the increasing of cost, and also lose effectiveness, furthermore it have influenced the adjustment of enterprise's tactics to a great extent. So we need an effective and reliable system that would deal with the data quickly and show it directly.
Base on upwards background,the popular ComGIS software MapX is used to develop this system,and according to the requirement applied by client,this system is built as a desktop system with object-oriented way.Visual programming language VS.C# is used to realize the basic operation of the map features and spatial data. Database MySql and Access are used to manage Attribute data. The whole inquiry and management functions of the system are realized at VS2005 platform.
The article explains the basic theories of GIS and the related technologies of MapInfo and MapX which is the twice platform of the system.And focus on describing the process of how the system designed and realized. At length,it describes the key technologies the system used.Such as how to get the spatial data,how the spatial date and attribute data related,how to load the maps in fast speed and more effective,etc.The results of this study is embed the ComGIS MapX based on the ActiveX into the integrated Development Environment of VS2005,needed GeoSet maps are inputted and a series of function modules are developed.Finished the analysis work of spatial data and attribute data,and build database fit for them.Though the technologies,this system could analyse sale results effectively with the sale information and various other data,get the trend and status of the sale information and describe them as thematic pictures,which would give scientific support to the manager. Give consideration to systematic expansion,at the same time,this system contained and offered the convenience to further development in the future.
引文
[1] 曹桂发,徐江.互联网技术条件下的 GIS 应用分析.地球信息科学,2000,04:(36-39)
[2] 倪金生.地理信息系统理论与实践-地球空间信息技术丛书.北京:电子工业出版社,2007
[3] 邬伦,刘瑜,张晶,等.地理信息系统——原理、方法和应用.北京:科学出版社,2004
[4] 薛华柱,张大永,王宝山.基于 MapX 的 WebGIS 的设计与实现.矿山测量,2004,2(10):22-47s
[5] 罗浩.基于 GIS 的电力智能巡检管理系统的设计与实现:[硕士学位论文].北京:北京邮电大学,2006
[6] 曾鸣,刘显.基于 MapX 的网络地理信息系统的实现.现代电子技术,2004,24(10):52-52
[7] 刘大杰.全球定位系统的原理与数据处理.上海:同济大学出版社,1996
[8] 鲍海峰.地图图像地理特征提取的关键研究:[硕士学位论文].上海:上海交通大学,2003
[9] 陈述彭,鲁学军,周成虎.地理信息系统导论,北京:科学出版社,2000
[10] 王子煜,陈秀万.油田地理信息系统的基本框架及其实现.计算机应用研究,2004,05(50):151-152
[11] 林泽.地球物理学导论.北京:地理出版社,1997
[12] 张晓贤.地理信息系统中栅格图像矢量化技术研究与实现:[硕士学位论文].吉林:长春理工大学,2004
[13] 李德仁.信息高速公路、空间数据基础设施与数字地球.测绘学报,11999, 28 (1): 1-5
[14] 王英杰.数据压缩技术在地理信息系统可视化研究中的应用.北京:科学出版社,2003
[15] 马建良.基于 GIS 的电力配网巡检系统研究:[硕士学位论文].广东:广东工业大学,2005
[16] 杜巧玲,吴秀芹,张淼.MapInfo 7 中文版入门与提高.北京:清华大学出版社,2005
[17] 赵晶.基于 GPS_GIS 技术的电力线路巡检管理系统的研究:[硕士学位论文].黑龙江:哈尔滨理工大学,2006
[18] 齐锐,屈韶琳.用 MapX 开发地理信息系统.北京:清华大学出版社,2003
[19] 杜四清,何丕廉,杨朋润,等.基于 WWW 的平衡施肥——WebGIS 专家系统的设计与实现.计算机工程与应用,2003,26(65):208-210
[20] WRichard Stevens 著,范建华译.TCP/IP 详解卷 1:协议.北京:机械工业出版社,2000
[21] 舒海林,曹菁,秦朝奎.数据压缩技术在地理信息系统可视化研究中的应用.石油
[22] 孔凡壮.遥感图像分割算法的研究与应用:[硕士学位论文].湖南:国防科学技术
[23] 王俊,张文诗,王建涛.多图幅海量数据电子地图快速显示的研究与实现.测绘工程,2003,03(5):18-20
[24] 王晓武,陈宗敏,杜兴国.MapBasic 程序设计.北京:电子工业出版社,2000
[25] 李胜乐,陆远忠,车时.MapInfo 地理信息系统二次开发实例.北京:电子工业出版社,2004
[26] 吴立新,史文中.地理信息系统原理与算法.北京:科学出版社,2003,170-419
[27] 杨春晓.基于 MapX 的最优路径搜索理论与实施技术研究:[硕士学位论文].吉林:吉林大学,2004
[2] 倪金生.地理信息系统理论与实践-地球空间信息技术丛书.北京:电子工业出版社,2007
[3] 邬伦,刘瑜,张晶,等.地理信息系统——原理、方法和应用.北京:科学出版社,2004
[4] 薛华柱,张大永,王宝山.基于 MapX 的 WebGIS 的设计与实现.矿山测量,2004,2(10):22-47s
[5] 罗浩.基于 GIS 的电力智能巡检管理系统的设计与实现:[硕士学位论文].北京:北京邮电大学,2006
[6] 曾鸣,刘显.基于 MapX 的网络地理信息系统的实现.现代电子技术,2004,24(10):52-52
[7] 刘大杰.全球定位系统的原理与数据处理.上海:同济大学出版社,1996
[8] 鲍海峰.地图图像地理特征提取的关键研究:[硕士学位论文].上海:上海交通大学,2003
[9] 陈述彭,鲁学军,周成虎.地理信息系统导论,北京:科学出版社,2000
[10] 王子煜,陈秀万.油田地理信息系统的基本框架及其实现.计算机应用研究,2004,05(50):151-152
[11] 林泽.地球物理学导论.北京:地理出版社,1997
[12] 张晓贤.地理信息系统中栅格图像矢量化技术研究与实现:[硕士学位论文].吉林:长春理工大学,2004
[13] 李德仁.信息高速公路、空间数据基础设施与数字地球.测绘学报,11999, 28 (1): 1-5
[14] 王英杰.数据压缩技术在地理信息系统可视化研究中的应用.北京:科学出版社,2003
[15] 马建良.基于 GIS 的电力配网巡检系统研究:[硕士学位论文].广东:广东工业大学,2005
[16] 杜巧玲,吴秀芹,张淼.MapInfo 7 中文版入门与提高.北京:清华大学出版社,2005
[17] 赵晶.基于 GPS_GIS 技术的电力线路巡检管理系统的研究:[硕士学位论文].黑龙江:哈尔滨理工大学,2006
[18] 齐锐,屈韶琳.用 MapX 开发地理信息系统.北京:清华大学出版社,2003
[19] 杜四清,何丕廉,杨朋润,等.基于 WWW 的平衡施肥——WebGIS 专家系统的设计与实现.计算机工程与应用,2003,26(65):208-210
[20] WRichard Stevens 著,范建华译.TCP/IP 详解卷 1:协议.北京:机械工业出版社,2000
[21] 舒海林,曹菁,秦朝奎.数据压缩技术在地理信息系统可视化研究中的应用.石油
[22] 孔凡壮.遥感图像分割算法的研究与应用:[硕士学位论文].湖南:国防科学技术
[23] 王俊,张文诗,王建涛.多图幅海量数据电子地图快速显示的研究与实现.测绘工程,2003,03(5):18-20
[24] 王晓武,陈宗敏,杜兴国.MapBasic 程序设计.北京:电子工业出版社,2000
[25] 李胜乐,陆远忠,车时.MapInfo 地理信息系统二次开发实例.北京:电子工业出版社,2004
[26] 吴立新,史文中.地理信息系统原理与算法.北京:科学出版社,2003,170-419
[27] 杨春晓.基于 MapX 的最优路径搜索理论与实施技术研究:[硕士学位论文].吉林:吉林大学,2004