【作者】 陈琳；

【导师】 朱绍文；

【作者基本信息】 华中师范大学 ， 电路与系统， 2002， 硕士

【摘要】 随着计算机、网络和通信技术的飞速发展，管理信息系统特别是商、财务管理系统得到广泛的应用，其中图书进销存管理系统的使用已成为图书商业企业处理业务、实现管理、进行辅助决策的最重要的手段之一。 目前进销存系统一般采用C／S或B／S两种结构模式，根据图书进销存业务特点和现状、现在企业普遍改造的Intranet环境、企业长期的需求习惯方式及将来业务和经营方式的发展趋势，针对C／S、B／S结构进销存系统各自优缺点，本文提出了采用一种C／S和B／S混合结构模式。把业务复杂、数据处理频繁、数据传输量大、安全性要求高的业务，运用C／S结构模式，而对于面向范围广、安全性要求不高的业务，运用B／S结构模式。这样集C／S和B／S结构的优点，满足了图书进销存业务不同的特点需求，同时，使企业的原有的经营处理应用系统能平滑过渡，也为满足今后新的需求具有很好的扩展性。 论文分析了进销存的现状，进销存业务流程和特点，目前进销存软件的结构，以及C／S和B／S结构的进销存系统各自优缺点，论述了采用C／S、B／S混合结构模式的可行性及优势。 论文给出了C／S、B／S的体系结构、关键技术，同时从数据库系统设计的一般原则出发，提出了关系数据库在C／S与B／S混合模式开发中的设计优化原则和应用注意事项。 论文给出了基于C／S和B／S混合结构模式的设计与实现，包括图书进销存系统的需求分析，系统的体系结构、网络结构图、数据流图、功能模块图，数据库的实体关系图，以及各关键技术的应用。并对数据库的动态连接进行了详细的阐述。 论文提出了建立中间表实现满足不同要求的灵活结算，并用触发器实现了高效、灵活、安全的结算要求。提出了四种安全方案相结合的安全机制。 最后，进行了总结，并展望了进销存系统的发展方向。更多还原

【Abstract】 With the rapid development of computer -. network and communication technology ,the manage information systems, especially the commerce manage systems and the finance manage systems ,are extensively applied .A lot of books commercial corporations would like Purchease-Sales-Inventory (PSI) books manage systems ,as one of the most important means of dealing with operations ^ carrying out management and making assistant decisions .At present, Purchease-Sales-Inventory manage systems generally have two types of constructive patterns .One is C/S, the other is B/S .In view of their advantages and shortcomings as well as correlative factors ,such as its operations characteristic and actuality , being changing Intranet environment and customary demanding fashion and developing trend of operations and manage fashions of corporations ,the paper puts forward a kind of mixed constructive pattern of C/S and B/S Aiming at complex operation, frequent data processing , more data transmitting and high-demand to security ,the C/S is used .On the contrary, for those operations of wide scope and low-rise security ,the B/S is used .In this way ,the mixed patterns has the advantages both C/S and B/S and it satisfied different special demands. At the same time, the transition is smooth from the original management systems to the new pattern and it has the sound expansibility meeting with future demands.The paper introduces the status quo of Purchease-Sales-Inventory , operation flow and characteristic and the software structure of Purchease-Sales-Inventory . It analyses the advantages and disadvantages of C/S and B/S and demonstrates the feasibilities and superiorities of mixed pattern.The paper reasons the system structure of C/S and B/S and the key techniques. It puts forward the developing means of mixed pattern and database designing and optimizing principle and noticed proceedings in applying.By the general design principles of Relation Database System, the optimal design methods and the points for attention during applications are developed.The paper expounds the design and implement based on the mixed pattern of C/S andB/S .It consists of demanding analysis s system structure , network structures data flowing diagrams function module .. entity relation chart of database and the application of key techniques .It gives a detailed expounding about database’s dynamic links.The paper puts forward making middle table to satisfy different strikes and handling trigger to realize high efficiency and security of strikes. It gives out a security mechanism combined by four kinds security scheme. In the last part, the paper sums up the key points and gives an expectation of Purchease-Sales-Inventory systems developing direction.更多还原