上海奈那卡斯运费管理系统设计与实现

发布时间：2018-06-20 08:56

本文选题：数据库设计 + 查询　；参考：《大连理工大学》2015年硕士论文

【摘要】：上海奈那卡斯运费管理系统以我公司财务成本核算为主线,以物流货运单作为首要基础数据而展开到发票录入,发票核算,财务凭证处理,最终提供成本分摊报表,此数据作为企业实际运营过程中的部分成本数据写入集团财务系统。在硬件架构方面,上海作为集团在华的数据中心,所有硬件服务器均放置在中心机房,我们采用了DELL R710高性能服务器作为数据存储之用,网络适配器采用双千兆光纤卡通讯,客户端电脑都采用惠普商用电脑和笔记本。网络核心交换机为思科3750全光口模块插入,这些硬件设施的投入确保硬件传输层没有性能瓶颈。软件方面,服务器系统是目前的新版微软Windows server2012企业版,客户端操作系统也都是微软正版操作系统Windows7和Windows8.1,在数据库的设计方面,我们严格按照遵循完整性原则、安全性原则、可伸缩性原则、规范化原则。运费管理系统采用C／S和B/S模式相结合的方式来设计开发,在本论文中我们主要介绍C/S下的设计,B/S模式主要是因为公司高级管理人员需要在系统中查询相关报表,无需安装客户端程序,同时并没有数据录入工作；反之,而对于其它一线用户需要较快的数据存储能力和数据录入、编辑,人机互动性较强,所以这部分用户决定采用安装客户端程序的C/S模式。主要使用基于微软Office办公自动化的VBA作为主要编程工具,对于客户端和数据库的访问,程序内部定制了ODBC数据源自动链接的代码。运费管理系统投入使用以来由于其界面友好,操作简单灵活,对用户的计算机能力要求低,受到了最终用户的一致好评,也有效节约了公司资源,为管理层决策提供了快捷的数据报表支持,在当前严峻的经济形势下节省了企业管理成本,最大限度地提高企业的运行效率和管理水平,给我公司带来了显著的经济效益。
[Abstract]:Shanghai Nainakas freight management system takes the financial cost accounting of our company as the main line, takes the logistics freight bill as the primary basic data and develops to the invoice entry, the invoice accounting, the financial voucher processing, and finally provides the cost share report. This data is written into the group financial system as part of the cost data in the actual operation of the enterprise. In terms of hardware architecture, Shanghai serves as the group's data center in China, and all hardware servers are placed in the central computer room. We use the Dell R710 high performance server as data storage, and the network adapter uses dual gigabit optical fiber cards to communicate. Client computers use HP commercial computers and laptops. The network core switch is plugged into the Cisco 3750 all-optical port module, and these hardware facilities are invested to ensure that the hardware transport layer has no performance bottlenecks. In terms of software, the server system is the new version of Microsoft server2012 Enterprise Edition, and the client operating system is also the original Microsoft operating system Windows 7 and Windows 8.1. In the design of database, we strictly follow the integrity principle and security principle. Principle of scalability, principle of standardization. The freight management system is designed and developed by the combination of C / S and B / S mode. In this paper, we mainly introduce the design of B / S model under C / S mainly because the senior managers of the company need to query the related reports in the system. There is no need to install client programs, and there is no data entry; on the contrary, for other front-line users, they need faster data storage capacity and data entry, editing, human-computer interaction, So this part of the user decided to install the client program C / S mode. VBA, which is based on Microsoft Office Automation, is used as the main programming tool. For the access of client and database, the code of ODBC data source automatic link is customized inside the program. Since the freight management system was put into use, because of its friendly interface, simple and flexible operation, low requirements for the user's computer capability, it has been praised by the end users, and has also effectively saved the company's resources. It provides quick data report support for management decision, saves the cost of enterprise management under the severe economic situation at present, improves the operation efficiency and management level of the enterprise to the maximum extent, and brings the remarkable economic benefit to our company.
【学位授予单位】：大连理工大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：TP311.52

【相似文献】