基于Delphi的织部工艺CAD系统的开发及应用
摘要
织部工艺CAD系统是纺织企业信息化系统的重要组成部分。该系统的开发与成功实施大大提高了上机图设计、工艺表设计的质量及速度,规范了工艺管理。本文在充分了解纺织企业织部工艺特点的基础上,基于软件开发原理,采用面向对象编程及数据库等计算机技术,开发了织部工艺CAD系统。系统采用模块化设计思路,具有界面友好、操作方便的特点。用户使用效果良好。
结合具体工程项目,本系统选用Windows环境下的Delphi 7.0作为前台应用程序开发工具,Microsoft SQL Server 2000作为后台数据库管理系统,来实现织部工艺CAD系统的各功能模块及解决有关系统运行的相关问题。论文着重讨论了织部工艺CAD系统的分析、设计与实现。分析了织部工艺设计及管理流程,包括业务流程以及数据流程。以规范工艺设计为出发点,将工艺数据库设计成三层结构,并引入了用户自定义机制,这不仅仅规范了工艺流程,而且还提高了系统的通用性,使系统具有很强的扩展性。围绕工艺数据库,系统实现了上机图自动设计、工艺表自动设计、工艺变更管理、钢筘齿轮台帐管理、浆料成本分析等功能。
最后,论文对本次系统开发中遇到的几个关键性问题进行了详细的阐述。包括系统的安全性和速度,上机图的设计,静态、动态权限控制设计以及报警窗设计的问题。并对论文的研究内容进行了总结,指出了进一步研究工作的方向。
The development and successful implementation of the system has greatly enhanced the quality and speed of the Designing Weaving Plan and the Designing technical chart, this also normalizes process management. Based on the full understanding of Weaving process characteristics in the textile enterprises, based on the principles of software development, I Developed the Weaving process CAD system using object-oriented programming and databases etc. computer technology. The system has used the modular design ideas, with the characteristic of friendly surface, convenient operating, and effect being good for users.
Combining to concrete project, the functional modules of the Weaving process CAD system were implemented, and the question related to system running was solved, which were all developed by Delphi 7.0 as application development facility, and Microsoft SQL Server 2000 as Database Management System on Windows Operating System. The dissertation emphasizes the analysis, design and realization of the weaving process CAD system. This dissertation studied the flow of the design and management of the Weaving process, including the business flow and the date flow. To normalize process design as the starting point, the process database is designed as three-layered structure, and user-defined mechanism is introduced into it. This method not only normalizes the processes of the technical, but also enhanced system’s generality, and The system is highly expansionary. According to the process database, the system implemented the function of the Designing Weaving Plan, process changing mangement and so on.
Finally, the dissertation illustrations several key problems which has been encountered in the proceeding of this system development in detail. The problems involved the safety and speed of the system, the design of the Weaving Plan, static and dynamic purview control and annunciator. Then,summarize research content of the paper and point out the direction of further studying.
结合具体工程项目,本系统选用Windows环境下的Delphi 7.0作为前台应用程序开发工具,Microsoft SQL Server 2000作为后台数据库管理系统,来实现织部工艺CAD系统的各功能模块及解决有关系统运行的相关问题。论文着重讨论了织部工艺CAD系统的分析、设计与实现。分析了织部工艺设计及管理流程,包括业务流程以及数据流程。以规范工艺设计为出发点,将工艺数据库设计成三层结构,并引入了用户自定义机制,这不仅仅规范了工艺流程,而且还提高了系统的通用性,使系统具有很强的扩展性。围绕工艺数据库,系统实现了上机图自动设计、工艺表自动设计、工艺变更管理、钢筘齿轮台帐管理、浆料成本分析等功能。
最后,论文对本次系统开发中遇到的几个关键性问题进行了详细的阐述。包括系统的安全性和速度,上机图的设计,静态、动态权限控制设计以及报警窗设计的问题。并对论文的研究内容进行了总结,指出了进一步研究工作的方向。
The development and successful implementation of the system has greatly enhanced the quality and speed of the Designing Weaving Plan and the Designing technical chart, this also normalizes process management. Based on the full understanding of Weaving process characteristics in the textile enterprises, based on the principles of software development, I Developed the Weaving process CAD system using object-oriented programming and databases etc. computer technology. The system has used the modular design ideas, with the characteristic of friendly surface, convenient operating, and effect being good for users.
Combining to concrete project, the functional modules of the Weaving process CAD system were implemented, and the question related to system running was solved, which were all developed by Delphi 7.0 as application development facility, and Microsoft SQL Server 2000 as Database Management System on Windows Operating System. The dissertation emphasizes the analysis, design and realization of the weaving process CAD system. This dissertation studied the flow of the design and management of the Weaving process, including the business flow and the date flow. To normalize process design as the starting point, the process database is designed as three-layered structure, and user-defined mechanism is introduced into it. This method not only normalizes the processes of the technical, but also enhanced system’s generality, and The system is highly expansionary. According to the process database, the system implemented the function of the Designing Weaving Plan, process changing mangement and so on.
Finally, the dissertation illustrations several key problems which has been encountered in the proceeding of this system development in detail. The problems involved the safety and speed of the system, the design of the Weaving Plan, static and dynamic purview control and annunciator. Then,summarize research content of the paper and point out the direction of further studying.
引文
[1] 傅恩福,信息化建设与纺织企业竞争力,全国棉纺织科技信息中心,2005
[2] 吴国芳,纺织企业生产计划管理系统的研究与开发,东华大学,2003
[3] 刘晓冰、王 枫,ERP的发展、现状及展望,工业工程,2002,5(2):19-22
[4] 刁 翔,华茂集团管理信息系统的设计与应用研究[D]:[硕士论文],东南大学,2001
[5] 姜江等编著,Power Designer 数据库系统分析设计与应用[M],北京:电子工业出版社,2004
[6] Computer Village, the new dimension.Textile Month,Jan.1990,p.17
[7] Karacapilidis, Nikos I;Pappis,Costas P.Production planning and control in textile
[8] 贺方松、张文赓,国内外纺织生产应用软件的开发现状与展望,纺织学报,第十六卷,第二期,55-57
[9] 宋新平、崔玉梅,棉纺织工厂工艺CAD系统的开发,纺织学报,2005年12月,86-88
[10] Gary B.Shelly Thomas J.Cashman Harry J.Roseblatt 著,李芳、朱群雄、陈轶群 译,《系统分析与设计教程》,机械工业出版社,2005
[11] 姜旭本,信息系统开发方法--方法、策略、技术、工具、与发展,清华大学出版社,1997,105-107
[12] Michael V.Mannino 著,唐常杰、张天庆 陈安龙 李川译,《数据库设计、应用开发与管理》,电子工业出版社,2005.1
[13] 苗雪兰、 刘瑞新、 王怀峰编著,数据库系统原理及应用教程[M],北京:机械工业出版社,2001
[14] 刘瑞新,Delphi数据库程序设计教程[M],北京,机械工业出版社,2004.1
[15] 飞思科技产品研发中心编著,《Delphi7 数据库应用开发》,电子工业出版社,2003.1
[16] Paul Nislsen Microsoft SQL Server 2000 宝典,中国铁道出版社,2004.1
[17] Marci Forhock Garcia,Jamie Reding,Edward Whalen,Steve Adrien DeLuca Microsoft SQL Server2000 系统管理员宝典,清华大学出版社,2001
[18] (美)A.比特勒,金蓓弘、郭江译,客户机/服务器环境中的事务处理[M],北京:科学出版社,1998
[19] 樊 胜,C/S 与 B/S 的结构比较及 Web 数据库的访问方式,情报科学,2001(4):443-445.
[20] 顾 平,数据库设计工具 Power designer 的研究与实践,计算机应用与研究,2004 年第 11 期
[21] 童秉枢,现代CAD技术,北京,清华大学出版社.2000,22-38
[22] 武继松、崔卫刚等,棉织工艺计算机辅助设计系统,福建轻纺,1999年2月,1-5页
[23] 潘浙丹、陶晓东,ERP 环境下基于决策支持的纺织产品设计系统开发,福建电脑,2003年第2期,23页
[24] 蒋 满,纺织计算机辅助设计(CAD)技术,纺织导报,2000年第2期,28-29页
[25] 蔡陛霞,《织物结构与设计》,北京:中国纺织出版社, 2004.9.1
[26] 张增强、刘 程,Delphi 7 数据库开发完全手册[M],清华大学出版社,2003
[27] 杨 幸、张银明、张谋东,网络 MIS 的用户权限设计,华侨大学学报(自然科学版),19(2):202-205,1998
[28] 冉玉晶,基于 C/S 结构的管理信息系统的设计与开发[D]:[硕士学位论文] ,北京工业大学,2004
[29] 减国全,SQL Server 大型数据库中的索引设计[J],河南图书馆学刊,2000 年第 3 期:62-67
[30] Ralph Barletta,基于事例的推理导论[J],计算机科学,1993,20(10):10-14
[31] 徐 明,胡守仁,基于事例的推理[J],计算机科学,1992,(5):37-42
[32] David B leake.Case-based reasoning[J] .The Knowledge Engineering Review,1994,9(1):61-64
[33] Jeff Downey.Web Server Data Connections[J].PC magazine,1998,17(9):62-65
[34] 吴国芳、刘伟、邵建民,ADO 技术分析及应用,信息技术,2001 年第一期,34-35
[2] 吴国芳,纺织企业生产计划管理系统的研究与开发,东华大学,2003
[3] 刘晓冰、王 枫,ERP的发展、现状及展望,工业工程,2002,5(2):19-22
[4] 刁 翔,华茂集团管理信息系统的设计与应用研究[D]:[硕士论文],东南大学,2001
[5] 姜江等编著,Power Designer 数据库系统分析设计与应用[M],北京:电子工业出版社,2004
[6] Computer Village, the new dimension.Textile Month,Jan.1990,p.17
[7] Karacapilidis, Nikos I;Pappis,Costas P.Production planning and control in textile
[8] 贺方松、张文赓,国内外纺织生产应用软件的开发现状与展望,纺织学报,第十六卷,第二期,55-57
[9] 宋新平、崔玉梅,棉纺织工厂工艺CAD系统的开发,纺织学报,2005年12月,86-88
[10] Gary B.Shelly Thomas J.Cashman Harry J.Roseblatt 著,李芳、朱群雄、陈轶群 译,《系统分析与设计教程》,机械工业出版社,2005
[11] 姜旭本,信息系统开发方法--方法、策略、技术、工具、与发展,清华大学出版社,1997,105-107
[12] Michael V.Mannino 著,唐常杰、张天庆 陈安龙 李川译,《数据库设计、应用开发与管理》,电子工业出版社,2005.1
[13] 苗雪兰、 刘瑞新、 王怀峰编著,数据库系统原理及应用教程[M],北京:机械工业出版社,2001
[14] 刘瑞新,Delphi数据库程序设计教程[M],北京,机械工业出版社,2004.1
[15] 飞思科技产品研发中心编著,《Delphi7 数据库应用开发》,电子工业出版社,2003.1
[16] Paul Nislsen Microsoft SQL Server 2000 宝典,中国铁道出版社,2004.1
[17] Marci Forhock Garcia,Jamie Reding,Edward Whalen,Steve Adrien DeLuca Microsoft SQL Server2000 系统管理员宝典,清华大学出版社,2001
[18] (美)A.比特勒,金蓓弘、郭江译,客户机/服务器环境中的事务处理[M],北京:科学出版社,1998
[19] 樊 胜,C/S 与 B/S 的结构比较及 Web 数据库的访问方式,情报科学,2001(4):443-445.
[20] 顾 平,数据库设计工具 Power designer 的研究与实践,计算机应用与研究,2004 年第 11 期
[21] 童秉枢,现代CAD技术,北京,清华大学出版社.2000,22-38
[22] 武继松、崔卫刚等,棉织工艺计算机辅助设计系统,福建轻纺,1999年2月,1-5页
[23] 潘浙丹、陶晓东,ERP 环境下基于决策支持的纺织产品设计系统开发,福建电脑,2003年第2期,23页
[24] 蒋 满,纺织计算机辅助设计(CAD)技术,纺织导报,2000年第2期,28-29页
[25] 蔡陛霞,《织物结构与设计》,北京:中国纺织出版社, 2004.9.1
[26] 张增强、刘 程,Delphi 7 数据库开发完全手册[M],清华大学出版社,2003
[27] 杨 幸、张银明、张谋东,网络 MIS 的用户权限设计,华侨大学学报(自然科学版),19(2):202-205,1998
[28] 冉玉晶,基于 C/S 结构的管理信息系统的设计与开发[D]:[硕士学位论文] ,北京工业大学,2004
[29] 减国全,SQL Server 大型数据库中的索引设计[J],河南图书馆学刊,2000 年第 3 期:62-67
[30] Ralph Barletta,基于事例的推理导论[J],计算机科学,1993,20(10):10-14
[31] 徐 明,胡守仁,基于事例的推理[J],计算机科学,1992,(5):37-42
[32] David B leake.Case-based reasoning[J] .The Knowledge Engineering Review,1994,9(1):61-64
[33] Jeff Downey.Web Server Data Connections[J].PC magazine,1998,17(9):62-65
[34] 吴国芳、刘伟、邵建民,ADO 技术分析及应用,信息技术,2001 年第一期,34-35