矿山设备管理与图纸信息集成系统研究
|
摘要
本文是以江西理工大学和某矿山合作开发的“矿山设备管理与图纸信息集成系统”为课题进行研究的。课题来源于生产实际,具有大的实用价值。课题对矿山企业设备管理的现状进行了调查分析,然后结合该矿山企业的实际情况,利用Visual Basic 6.0作为开发平台,SQL Server2000作后台数据库,通过运用ADO技术访问SQL数据库的方法,为该矿山企业量身定做了基于客户机/服务器(C/S)模式的系统。
本文研究了“矿山设备管理与图纸信息集成系统”的系统设计方法与过程,分析了系统的主要模块及其功能。系统包括系统管理、设备及固定资产档案管理、设备运行查询统计、设备大修查询统计、固定资产查询统计、设备图档管理和特种设备管理等模块。研究提出矿山设备管理如何集成图纸信息管理的有效解决方案。该方案使设备管理系统能够为设备维修人员提供快捷的图纸查询、浏览和输出服务,提高了设备维修的效率。设备及固定资产档案管理模块将设备一生的档案信息整合在一个界面之下,为用户查阅设备的所有档案信息提供极大方便;运行管理模块可以生成按月展开的设备维修成本分析曲线,方便用户把握设备劣化状态。该系统的投入使用有效提高了矿山企业的设备管理水平。
该系统在矿山设备管理系统中集成了图纸信息管理功能,用一个界面集成设备一生的档案信息,自动生成设备维修成本分析曲线,这些都具有一定的创新性和很强的实用性。
This paper is carried on the subject with "Mining equipment management and drawing information integration system" which is developed by Jiangxi University of Science and Technology and one mining Company. The subject has great practical value because it stems from producing activities of enterprise. This paper investigated and analyzed the current situation of the mineral enterprise's plant management. In combining this practical situation, the author used Visual Basic 6.0 as the developing platform and SQL Server 2000 as backstage database. By taking the application of using ADO technology to visit SQL database, this paper develops a client / server-mode(C/S) software which is suitable for mining industrial enterprise.
This paper studies the designing method of“The integration system of mining equipment management and drawing information", and analyzed main module and function of the system. The system includes the following modules: system management, management of files of plants and fixed assets, plant operation statue inquiry and statistics, plants’overhauling inquiry and statistics, fixed assets inquiring and statistics, drawing information management, and particular kinds of plant management. In this paper, the author presented an effective solution of how to integrated drawing information management and mining equipment management. The implementation of this solution brings the system a powerful utility of serving the plant manager with swift drawing information inquiry and drawing printing, which is dramatically improve the efficiency of mining industrial plant management. Management of files of plants and fixed assets module can display all the files and historical information of the whole life of plants in one interface. This function provides greatly convenience for users’consulting. System can also calculate the fee of maintaining mining equipment, and form a diagram of curves which shows monthly cost of the service the plant. This function helps users to have a clear picture of the state of the equipment. The implementation of this system has effectively improved the plant management level of mining enterprises.
Merging drawing information management into mining equipment management system, displaying all the information of equipment’s life within one interface, calculating and displaying monthly maintenance of equipment in a graph, all these feature in the system, are highly practicable and of certain innovativeness.
本文研究了“矿山设备管理与图纸信息集成系统”的系统设计方法与过程,分析了系统的主要模块及其功能。系统包括系统管理、设备及固定资产档案管理、设备运行查询统计、设备大修查询统计、固定资产查询统计、设备图档管理和特种设备管理等模块。研究提出矿山设备管理如何集成图纸信息管理的有效解决方案。该方案使设备管理系统能够为设备维修人员提供快捷的图纸查询、浏览和输出服务,提高了设备维修的效率。设备及固定资产档案管理模块将设备一生的档案信息整合在一个界面之下,为用户查阅设备的所有档案信息提供极大方便;运行管理模块可以生成按月展开的设备维修成本分析曲线,方便用户把握设备劣化状态。该系统的投入使用有效提高了矿山企业的设备管理水平。
该系统在矿山设备管理系统中集成了图纸信息管理功能,用一个界面集成设备一生的档案信息,自动生成设备维修成本分析曲线,这些都具有一定的创新性和很强的实用性。
This paper is carried on the subject with "Mining equipment management and drawing information integration system" which is developed by Jiangxi University of Science and Technology and one mining Company. The subject has great practical value because it stems from producing activities of enterprise. This paper investigated and analyzed the current situation of the mineral enterprise's plant management. In combining this practical situation, the author used Visual Basic 6.0 as the developing platform and SQL Server 2000 as backstage database. By taking the application of using ADO technology to visit SQL database, this paper develops a client / server-mode(C/S) software which is suitable for mining industrial enterprise.
This paper studies the designing method of“The integration system of mining equipment management and drawing information", and analyzed main module and function of the system. The system includes the following modules: system management, management of files of plants and fixed assets, plant operation statue inquiry and statistics, plants’overhauling inquiry and statistics, fixed assets inquiring and statistics, drawing information management, and particular kinds of plant management. In this paper, the author presented an effective solution of how to integrated drawing information management and mining equipment management. The implementation of this solution brings the system a powerful utility of serving the plant manager with swift drawing information inquiry and drawing printing, which is dramatically improve the efficiency of mining industrial plant management. Management of files of plants and fixed assets module can display all the files and historical information of the whole life of plants in one interface. This function provides greatly convenience for users’consulting. System can also calculate the fee of maintaining mining equipment, and form a diagram of curves which shows monthly cost of the service the plant. This function helps users to have a clear picture of the state of the equipment. The implementation of this system has effectively improved the plant management level of mining enterprises.
Merging drawing information management into mining equipment management system, displaying all the information of equipment’s life within one interface, calculating and displaying monthly maintenance of equipment in a graph, all these feature in the system, are highly practicable and of certain innovativeness.
引文
[1] 符胜斌,彭娟娟.设备管理理论的新发展及其启示[J] .冶金矿山设计与建设,2002, 34 (2):22-23.
[2] 邱晓卫,邹甫.设备管理信息系统的开发和应用[J] .计算机应用,2000,8:18-19.
[3] Fechner, M. Sahl, U.A TPM(total productive maintenance)-based SAP-PMimplementation. Industry Management. 2002. 6-45.
[4] 秦建华,黄世界.设备管理信息系统的开发[J] .计算机应用,2001, 21(8) :225-226.
[5] 张宽海,匡松.管理信息系统概论[M] .第 1 版.北京:高等教育出版社,2002. 108-120.
[6] 庞士宗,肖平阳,唐加福.产品数据管理(PDM)[M] .机械工业出版社,2001.11
[7] 庞士宗.PDM 走向何方. CAD/CAM 计算机辅助设计与制造,2003.11.22
[8] 庞士宗.PDM 及其最新进展.CAD/CAM 计算机辅助设计与制造,2000.2
[9] 陈宏亮.PDM 技术多方向“延伸”[J].中国计算机用户,1998.11
[10] Burdick D, Product Data Management:Enabling Enterprisewide Design Collabration.CIM Strategic Analysis Report,GartnerGroup, Sept.1995
[11] 赵敏.PLM——制造业信息化的基础[J] .计算机世界网,2003.11
[12] 程永上.工程扫描图的矢量化和图档管理系统设计[D] .河海大学,2004.12
[13] 刘亮.工程图纸管理软件系统的设计与实现[D].西安理工大学,2003
[14] 武小强.工程图纸管理系统[D] .西安理工大学,2003.2
[15] 赵艳萍,姚冠新,陈骏.设备管理与维修[M] .第 1 版.北京:化学工业出版社,2004.8.
[16] 薛华成.管理信息系统[M] .北京:清华大学出版社,2000 年 7 月
[17] 于波.一个设备管理系统的设计与实现[J] .计算机与现代化,1998 (6)82-85
[18] 巫世晶.设备管理工程[M] .第 1 版.北京:中国电力出版社,2004.6
[19] 曾众. ERP 与设备管理信息系的管理要素[J] .中国设备工程,2004, (4) :13-14.
[20] 刘亮.工程图纸管理软件系统的设计与实现 [D] .大连理工大学,2006.12
[21] 韦兆文,李陶深.工程图档设计过程管理模型的设计与实现[J] .广西科学院学报,200117 (04):172-174
[22] 沈澐.上海新模式 PDM 系统[D] .江西理工大学,2004.12
[23] Jeffrey L.Whitten, Lonnie D.Bentley. Systems Analysis and Design Methods.McGraw-Hill, 4 edition. 1998.
[24] Electronic Data Systems Corporation, Information Manager Use Guide, Version 3.4, MU8230,1996.9
[25] Electronic Data Systems Corporation, Information Manager Integration Tool Kit Programmer Guide, Version 3.4, MU8210, 1996. 9
[26] 张莉,王强,赵文,董莉.SQL Server 数据库原理及应用教程[M] .清华大学出版社,2003.1
[27] Microsoft 公司著,云舟工作室译.SQL Server 2000 资源大全[M] .机械工业出版社,2002.2
[28] 王成,马里杰编著.SQL Server 数据库开发经典案例解析[M] .北京第一版,清华大学出版社,2006.1
[29] 陈景艳.管理信息系统 [M] .第 2 版 .北京 :中国铁道出版社,2001.1-100.
[30] 高复先.信息资源规划[M] .清华大学出版社,2002
[31] Christian N.Madu, Chu-hua Kuei, Jau-Hwei Chen. A decision support systems approach to adjust maintenance float system availability levels. Computers ind. Engng.1995,28(4):773-786
[32] 二代龙震工作室.AutoCAD&数据库整合运用实作[M].电子工业出版社,2002.1
[33] 李文龙,申志宏,郭淑琴.设备管理信息系统的设计与开发[J].中国金融电脑,2002, 10:67-68.
[34] 王立福等.软件工程—技术、方法与环境[M].第 1 版.北京:北京大学出版社,1997. 10-28
[35] 龙怀冰,李白桦.郭智博.SQL Server 2000 使用开发教程[M].人民邮电出版社.2006
[36] 张金隆. 现代管理信息技术[M].武昌:华中理工大学出版社.1998.11
[37] 程秀芳,冯立艳.设备管理信息系统的开发[J] .新技术新工艺,2002,11:6-7.
[38] 张巨俭,甘初初.管理信息系统的发展方向及实现技术[J] .计算机应用研究,2003.1:8-10.
[39] Mohamed Ben-Daya. You may need RCM to enhance TPM implementation. Journal of Quality in Maintenance Engineering,2000,6(2):82-85.
[40] 吕文元,臧洪路.设备管理信息化的研究与发展[J] .中国设备工程,2001, 8:5-7
[41] 邱教喜,张瑞祥.现代企业设备管理的新概念[J] .山东煤碳科技,2002, 增刊:114-115
[42] 闽小勇.基于 C/S 结构煤矿企业设备管理信息系统的实现[J] .矿山机械,2006, 12 :6-7.
[43] 徐晓霞、贝雨馨.B/S 模式和 C/S 模式之比较[[J] .延边大学学报.2002,28(2):126- 129
[44] 苏金明.用 Visual Basic 开发交互式 CAD 系统[M] .电子工业出版社, 2003.5
[45] 张树兵、戴红、陈哲.Visual Basic 6.0 入门与提高[M] .清华大学出版社,2001.10
[46] 林永、张乐强.Visual Basic 6.0 用户编程手册[M] .人民邮电出版社, 1999.11
[47] 求是科技.SQL Server 2000 数据库开发技术与工程实践[M].北京:人民邮电出版社,2004
[48] 王建伟,李延如,王晓红.Crystal Reports水晶报表设计与开发实务[M] .电子工业出版社,2003.1
[49] 莫卫东,白鹏,张晓敏,张福萍.Visual Basic 6.0 高级编程技巧 —ADO 数据访问篇[M] .西安交通大学出版社,2000.1
[50] 陈万华,曹争.Visual Basic 中两种 ADO 数据库访问技术的比较[J] .微机发展,第 13 卷 2003 年 6 月,44-46
[51] 谭子丹,刘国庆,李光明.Visual Basic 6. 0 数据库编程思想 与实践[M] .北京:冶金工业出版社. 2002.
[52] 冯旭哲,张记,杨波.Visual Basic 中数据库访问的实现[J] .计算机应用与软件.2002(8):18-19.
[53] 李勇平等.Visual Basic 6.0 案例教程[M] .电子出版物数据中心,2001.9
[2] 邱晓卫,邹甫.设备管理信息系统的开发和应用[J] .计算机应用,2000,8:18-19.
[3] Fechner, M. Sahl, U.A TPM(total productive maintenance)-based SAP-PMimplementation. Industry Management. 2002. 6-45.
[4] 秦建华,黄世界.设备管理信息系统的开发[J] .计算机应用,2001, 21(8) :225-226.
[5] 张宽海,匡松.管理信息系统概论[M] .第 1 版.北京:高等教育出版社,2002. 108-120.
[6] 庞士宗,肖平阳,唐加福.产品数据管理(PDM)[M] .机械工业出版社,2001.11
[7] 庞士宗.PDM 走向何方. CAD/CAM 计算机辅助设计与制造,2003.11.22
[8] 庞士宗.PDM 及其最新进展.CAD/CAM 计算机辅助设计与制造,2000.2
[9] 陈宏亮.PDM 技术多方向“延伸”[J].中国计算机用户,1998.11
[10] Burdick D, Product Data Management:Enabling Enterprisewide Design Collabration.CIM Strategic Analysis Report,GartnerGroup, Sept.1995
[11] 赵敏.PLM——制造业信息化的基础[J] .计算机世界网,2003.11
[12] 程永上.工程扫描图的矢量化和图档管理系统设计[D] .河海大学,2004.12
[13] 刘亮.工程图纸管理软件系统的设计与实现[D].西安理工大学,2003
[14] 武小强.工程图纸管理系统[D] .西安理工大学,2003.2
[15] 赵艳萍,姚冠新,陈骏.设备管理与维修[M] .第 1 版.北京:化学工业出版社,2004.8.
[16] 薛华成.管理信息系统[M] .北京:清华大学出版社,2000 年 7 月
[17] 于波.一个设备管理系统的设计与实现[J] .计算机与现代化,1998 (6)82-85
[18] 巫世晶.设备管理工程[M] .第 1 版.北京:中国电力出版社,2004.6
[19] 曾众. ERP 与设备管理信息系的管理要素[J] .中国设备工程,2004, (4) :13-14.
[20] 刘亮.工程图纸管理软件系统的设计与实现 [D] .大连理工大学,2006.12
[21] 韦兆文,李陶深.工程图档设计过程管理模型的设计与实现[J] .广西科学院学报,200117 (04):172-174
[22] 沈澐.上海新模式 PDM 系统[D] .江西理工大学,2004.12
[23] Jeffrey L.Whitten, Lonnie D.Bentley. Systems Analysis and Design Methods.McGraw-Hill, 4 edition. 1998.
[24] Electronic Data Systems Corporation, Information Manager Use Guide, Version 3.4, MU8230,1996.9
[25] Electronic Data Systems Corporation, Information Manager Integration Tool Kit Programmer Guide, Version 3.4, MU8210, 1996. 9
[26] 张莉,王强,赵文,董莉.SQL Server 数据库原理及应用教程[M] .清华大学出版社,2003.1
[27] Microsoft 公司著,云舟工作室译.SQL Server 2000 资源大全[M] .机械工业出版社,2002.2
[28] 王成,马里杰编著.SQL Server 数据库开发经典案例解析[M] .北京第一版,清华大学出版社,2006.1
[29] 陈景艳.管理信息系统 [M] .第 2 版 .北京 :中国铁道出版社,2001.1-100.
[30] 高复先.信息资源规划[M] .清华大学出版社,2002
[31] Christian N.Madu, Chu-hua Kuei, Jau-Hwei Chen. A decision support systems approach to adjust maintenance float system availability levels. Computers ind. Engng.1995,28(4):773-786
[32] 二代龙震工作室.AutoCAD&数据库整合运用实作[M].电子工业出版社,2002.1
[33] 李文龙,申志宏,郭淑琴.设备管理信息系统的设计与开发[J].中国金融电脑,2002, 10:67-68.
[34] 王立福等.软件工程—技术、方法与环境[M].第 1 版.北京:北京大学出版社,1997. 10-28
[35] 龙怀冰,李白桦.郭智博.SQL Server 2000 使用开发教程[M].人民邮电出版社.2006
[36] 张金隆. 现代管理信息技术[M].武昌:华中理工大学出版社.1998.11
[37] 程秀芳,冯立艳.设备管理信息系统的开发[J] .新技术新工艺,2002,11:6-7.
[38] 张巨俭,甘初初.管理信息系统的发展方向及实现技术[J] .计算机应用研究,2003.1:8-10.
[39] Mohamed Ben-Daya. You may need RCM to enhance TPM implementation. Journal of Quality in Maintenance Engineering,2000,6(2):82-85.
[40] 吕文元,臧洪路.设备管理信息化的研究与发展[J] .中国设备工程,2001, 8:5-7
[41] 邱教喜,张瑞祥.现代企业设备管理的新概念[J] .山东煤碳科技,2002, 增刊:114-115
[42] 闽小勇.基于 C/S 结构煤矿企业设备管理信息系统的实现[J] .矿山机械,2006, 12 :6-7.
[43] 徐晓霞、贝雨馨.B/S 模式和 C/S 模式之比较[[J] .延边大学学报.2002,28(2):126- 129
[44] 苏金明.用 Visual Basic 开发交互式 CAD 系统[M] .电子工业出版社, 2003.5
[45] 张树兵、戴红、陈哲.Visual Basic 6.0 入门与提高[M] .清华大学出版社,2001.10
[46] 林永、张乐强.Visual Basic 6.0 用户编程手册[M] .人民邮电出版社, 1999.11
[47] 求是科技.SQL Server 2000 数据库开发技术与工程实践[M].北京:人民邮电出版社,2004
[48] 王建伟,李延如,王晓红.Crystal Reports水晶报表设计与开发实务[M] .电子工业出版社,2003.1
[49] 莫卫东,白鹏,张晓敏,张福萍.Visual Basic 6.0 高级编程技巧 —ADO 数据访问篇[M] .西安交通大学出版社,2000.1
[50] 陈万华,曹争.Visual Basic 中两种 ADO 数据库访问技术的比较[J] .微机发展,第 13 卷 2003 年 6 月,44-46
[51] 谭子丹,刘国庆,李光明.Visual Basic 6. 0 数据库编程思想 与实践[M] .北京:冶金工业出版社. 2002.
[52] 冯旭哲,张记,杨波.Visual Basic 中数据库访问的实现[J] .计算机应用与软件.2002(8):18-19.
[53] 李勇平等.Visual Basic 6.0 案例教程[M] .电子出版物数据中心,2001.9