本科论文设备管理系统——查询及报表生成子系统-1-设备管理系统——查询及报表生成子系统专业班级:学生姓名:指导老师:职称:摘要为了进一步加强和完善设备的信息化管理,引导用户合理有效的使用设备,基于这种需求,我们做了设备信息管理系统,用来对设备进行统计及管理工作,减少每天需要涉及到的相关工作量,尽可能的提高工作效率,可以节省人力物力的资源,提高设备信息的现代化管理。互联网的高速发展,使得信息共享成为必然。因而系统放弃了传统的基于局域网的C/S结构,使用了流行的B/S结构。使得不仅是局域网用户,Internet上的用户也可以访问本系统,大大加强了系统的数据共享的程度。同时,采用B/S结构可以方便对系统的维护,降低对系统的维护成本。首先整个系统采用网页格式中的框架建格,即左面为导航栏不变,而右面是可变的功能实现界面.其次这个设备信息管理系统采用ASP动态网页技术与SQLServer2000数据库,制作了一个B/S结构的设备管理系统。最后系统实现了1.设备管理相关子系统设计和数据库设计2.设备信息查询及修改子系统,包括土地查询、房屋及构建物查询、交通运输设备查询、电子产品及通信设备查询、家具用具及其它类查询,按照要求查询并在网页中的事先建立好的表格中显示出来。3.报表生成子系统,包括打印设备报表,软件部门电脑报表,系统能把信息打印输出到Excel文件,提高了系统的方便性。关键字:设备管理系统,B/S结构,SQLServer2000数据库,ASP本科论文设备管理系统——查询及报表生成子系统-2-EquipmentManagementSystem——forenquiriesandstatementsgeneratedsubsystemAbstractInordertofurtherstrengthenandimprovetheinformationmanagementequipment,userguiderationalandeffectiveuseofequipment,basedonthisdemand,wehavedoneequipmentinformationmanagementsystems,equipmentusedforstatisticalandmanagement,andreducethedailyneedsrelatedtotherelevantWorkload,increaseefficiencyasmuchaspossible,cansavemanpowerandresourcesofresources,improvetheequipmentofmoderninformationmanagement.Thehigh-speeddevelopmentoftheInternet,maketheinformationsharebecomeaffirmant.Sothesystemescapefromthetraditionallan-basedC/Sstructure,adpottheprevalentB/Sstructure.Itcanpermitnotonlythelanusers,butalsotheinternetuserstoaccessthesystem.Itdomoreelevationthesystem’sdegreeoftheinformationshareadpottheB/Sstructurecanconvenienttomaintenanceofthesystem,decreasethecostofthemaintenance.FirstthesystemasawholepageformatusedinbuildingtheframeworkofGeorgia,thatisleftunchangedforthenavigationbar,whiletherightisthevariabletoachievethefunctionsoftheinterface.ThiswasfollowedbytheinformationmanagementsystemequipmentusedASPdynamicwebtechnologyandSQLServer2000databases,producedaB/Sstructureoftheequipmentmanagementsystem.Finallysystemtoachievea1.subsystemdesign-relatedequipmentmanagementanddatabasedesign2.modifiedequipmentandinformationsystems,includinglandforthehousingandconstructionofenquiries,fortransportationequipment,electronicproductsandforcommunicationsequipment,furnitureandappliancesforothercategories,inaccordancewiththerequirementsofqueryandthepageinthepriorestablishmentofgoodformintheshow.3.reportgenerationsubsystems,includingprintequipmentstatements,statementsofthecomputersoftwaresector,thesystemcanprintouttheinformationtoExceldocuments,improvethesystem'sconvenience.keywordsequipmentmanagementsystem,B/Sstructure,SQLServer2000databases,ActiveServerPages本科论文设备管理系统——查询及报表生成子系统-3-目录第一章引言..................................................................................................................................11.1背景说明...................................................................................................................................11.2系统技术介绍...........................................................................................................................2第二章系统运行环境分析......................................................................................................42.1IIS.............................................................................................................................................42.2SQLSERVER2000简介................................................................................................................62.3ASP技术....................................................................................................................................7第三章设备管理系统需求分析............................................................................................93.1系统目标...................................................................................................................................93.2需求分析...................................................................................................................................93.3系统模块功能.........................................................................................................................113.4系统配置.................................................................................................................................123.4.1硬件环境..........................................................................................................................123.4.2软件环境..........................................................................................................................133.4.3网络配置..........................................................................................................................13第四章设备管理系统设计....................................................................................................144.1设备管理系统总体设计.........................................................................................................154.2相关子系统设计.....................................................................................................................164.3数据库设计......................................................................................................................