基于C#的带式输送机选型系统中数据库数据自动添加的研究
|
摘要
针对带式输送机设计选型工作量大、人工计算效率低的情况,根据输送机设计原理开发带式输送机选型及线路布置系统。为实现软件的智能化计算及设备选型,需要针对输送物料及设备数据建立数据库。在用户到达数据输入模块时,以物料参数选择为例,用户可在物料属性一栏中选择要输送的物料,当数据库中无用户所需物料数据时需要用户手动输入,输入完成后数据同时自动添加在原数据库中,使得软件在使用的同时不断更新、完善自身数据库,当软件再次使用时,新的物料参数便会出现在物料选择栏中,充分体现软件的智能化。
To lighten the workload in belt conveyor design and selection and improve calculation efficiency, a selection and route layout system is developed based on the design principle of the conveyor. A database needs to be established for the materials to be conveyed and equipment data so as to realize intelligent calculations and equipment selection. Taking material parameters selection as an example, after opening the data input module, the user can select the material to be conveyed in the material parameters bar. If there is no data on the material needed in the database, the user needs to enter the data manually, and the data is automatically added to the database. In this way, the software can constantly update and improve its database when in use. Next time, the user will find the new material parameters in the material selection bar. The whole process is a clear manifestation of how intelligent the software is.
To lighten the workload in belt conveyor design and selection and improve calculation efficiency, a selection and route layout system is developed based on the design principle of the conveyor. A database needs to be established for the materials to be conveyed and equipment data so as to realize intelligent calculations and equipment selection. Taking material parameters selection as an example, after opening the data input module, the user can select the material to be conveyed in the material parameters bar. If there is no data on the material needed in the database, the user needs to enter the data manually, and the data is automatically added to the database. In this way, the software can constantly update and improve its database when in use. Next time, the user will find the new material parameters in the material selection bar. The whole process is a clear manifestation of how intelligent the software is.
引文
[1]孟文俊,黄琪,王静,等.圆管带式输送机的设计与选型[J].硫磷设计与粉体工程,2009(6):3-11.
[2]李琨,芮晓明.带式输送机计算机辅助设计系统的开发[J].中国电力教育,2005(S2):58-60.
[3]杜冬梅,居敬杰,董大仟,等.基于虚拟现实技术的带式输送机设计系统[J].图学学报,2007,28(1):28-32.
[4]刘仙桃,李道兵.基于C#.NET的Access数据库创建与访问[J].电脑编程技巧与维护,2011(6):52,53.
[5]胡修斌,李春英.DTⅡ(A)带式输送机计算机辅助设计系统的研发[J].机械工程与自动化,2009(1):84-86.
[6]邓春晓,邓春江,胡文菊.DTⅡ型带式输送机选型设计系统的研制[J].矿山机械,2007(5):92-95.
[7]赵光亮,田华.基于C#.NET的Excel表格数据导入数据库技术研究[J].铜仁学院学报,2014(4):99,100.
[8]王梅娟,时章明,刘志强,等.用VB加Access数据库实现热电偶检定数据的自动采集与处理[J].计量技术,2006(1):45-48.
[9]Yoshitomi Y,Kawakami J,Shimizu K.Study on the Development of Belt Conveyor Mucking System in Tunnel[J].Proceedings of the Japan Society of Civil Engineers,2002,700:133-143.
[10]王小科,徐薇.C#从入门到精通[M].第2版.北京:清华大学出版社,2010.
[2]李琨,芮晓明.带式输送机计算机辅助设计系统的开发[J].中国电力教育,2005(S2):58-60.
[3]杜冬梅,居敬杰,董大仟,等.基于虚拟现实技术的带式输送机设计系统[J].图学学报,2007,28(1):28-32.
[4]刘仙桃,李道兵.基于C#.NET的Access数据库创建与访问[J].电脑编程技巧与维护,2011(6):52,53.
[5]胡修斌,李春英.DTⅡ(A)带式输送机计算机辅助设计系统的研发[J].机械工程与自动化,2009(1):84-86.
[6]邓春晓,邓春江,胡文菊.DTⅡ型带式输送机选型设计系统的研制[J].矿山机械,2007(5):92-95.
[7]赵光亮,田华.基于C#.NET的Excel表格数据导入数据库技术研究[J].铜仁学院学报,2014(4):99,100.
[8]王梅娟,时章明,刘志强,等.用VB加Access数据库实现热电偶检定数据的自动采集与处理[J].计量技术,2006(1):45-48.
[9]Yoshitomi Y,Kawakami J,Shimizu K.Study on the Development of Belt Conveyor Mucking System in Tunnel[J].Proceedings of the Japan Society of Civil Engineers,2002,700:133-143.
[10]王小科,徐薇.C#从入门到精通[M].第2版.北京:清华大学出版社,2010.