保险代理管理系统中机构树的设计与实现

辽宁石油化工大学学报 ›› 2007, Vol. 27 ›› Issue (2): 72-75.

保险代理管理系统中机构树的设计与实现

栗　觅, 魏海平^＊ , 宋晓君, 石元博

辽宁石油化工大学计算机与通信工程学院, 辽宁抚顺113001

收稿日期:2006-10-23 出版日期:2007-06-20 发布日期:2017-07-05
作者简介:栗觅(1981 -), 女, 辽宁抚顺市, 在读硕士。

Design and Implementation of the Organization -Tree in the Insurance Agency MIS

School of Comp uter and Communication Engineering , Liaoning University o f Petroleum & Chemical Technolog y ,Fushun Liaoning 113001, P .R .China

Received:2006-10-23 Published:2007-06-20 Online:2017-07-05

摘要/Abstract

摘要： 　分析了人员管理机构树的特点、功能及其结构设计思想, 介绍了在MS SQL S ERVER2000 中实现动态机构树的方法。针对机构树动态生成中应用程序对数据库进行频繁操作而降低系统执行效率的问题, 详细给出了在VC++6 .0 中应用后台数据库存储过程和触发器技术的解决方案。系统实际运行结果表明, 该系统具有稳定、计帐准确和查询速度快等特点。

关键词: 机构树, 　存储过程, 　触发器

Abstract:

　 The characteristics, the function, and the structural design of the organization -tree were analyzed.The method of implementing the dynamic organization-tree in MS SQL S ERVER2000 was introduced .Aiming at the problem that , in the process of dynamically generating organization-tree , the application program manipulates the database frequently and leads to the low efficiency of the system running , a detailed solution scheme for applying the storage process of background database and trigger technique with VC ++6.0 was given.The practical running results show that the system is of stability , keeps business records accurately , and polls information quickly .

Key words: Organization -tree, , Storage process, , Trigger

栗　觅, 魏海平,宋晓君, 石元博. 保险代理管理系统中机构树的设计与实现[J]. 辽宁石油化工大学学报, 2007, 27(2): 72-75.

LI Mi,WEI Hai -ping,et al. Design and Implementation of the Organization -Tree in the Insurance Agency MIS[J]. Journal of Liaoning Petrochemical University, 2007, 27(2): 72-75.

[1]	吴　云,　戴　文. 基于Intel 80C196KC 单片机控制的晶闸管触发器的设计[J]. 辽宁石油化工大学学报, 2005, 25(2): 78-82.
[2]	李桂兰, 毕于深. 考务管理中考试日程表自动生成算法设计[J]. 辽宁石油化工大学学报, 2005, 25(1): 78-81.