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

Journal of Liaoning Petrochemical University ›› 2007, Vol. 27 ›› Issue (2): 72-75.

Previous Articles Next Articles

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

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

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

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

作者简介:栗觅(1981 -), 女, 辽宁抚顺市, 在读硕士。

Abstract

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

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

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

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.

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

[1]	Mingfei Ji, Tao Li, Jiawen Liao, Xin Yang. Sliding Mode Formation Control of UAVs Based on Event⁃Triggered under Delay and Disturbance [J]. Journal of Liaoning Petrochemical University, 2022, 42(4): 77-86.
[2]	Bowei Ji, Xiao Zhang, Shen Yan, Zhou Gu. Event⁃Triggered and Deception Attack⁃Based Load Frequency Control for Power Systems [J]. Journal of Liaoning Petrochemical University, 2022, 42(4): 87-96.
[3]	Tao Sun, Xiaoxiao Dong. Asynchronous Event⁃Triggered Control of Cascade Nonlinear Switched System [J]. Journal of Liaoning Petrochemical University, 2021, 41(4): 91-96.
[4]	. Removal of Sulfides from Simulated Oil by CH₃CONH₂/ZnCl₂ Deep Eutectic Solvent [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 1-7.
[5]	LiuYujuan,XuJi,TongYufei,et al. Progress in Research of the Synthesis Methods of Nanometer Ceria [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 8-12.
[6]	Liu Jindong,He Xin,Xin Dingye,et al. Change Law of Four Fractions in Residue Hydrotreating Catalyst Grading System [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 13-16.
[7]	Wu Hao， Ma Guiyang， Xiang Nan，et al. The Effect Analysis of Settlement of Soil on Stress Fields of  Horizontal Section of Crossing Pipeline Structure [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 22-25.
[8]	Yan Rongju， Wang Weiqiang， Li Zimeng，et al. Progress of Severe Slugging in Marine Riser System [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 26-30.
[9]	Wang Long. Application of Seismic Reconstruction Inversion in Prediction of River  Channel of X Development Zone in Daqing Placantieline [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 31-37.
[10]	Zhu Bomin. Optimization of Well Spacing in Gaotaizi Reservoir  of Sazhong Development Zone [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 38-43.
[11]	Ma Jing,Jin Kejun,Liang Yufeng,et al. Study on Comprehensive Evaluation for Engineering  Mode of Offshore Oil and Gas Fields [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 44-48.
[12]	Fan Dengshuai,Gao Peng, Liu Zhihui，et al. A Method of Connection Reliability Analysis of Bolted Flange Systems [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 49-52.
[13]	Wu Zhiyong,Liu Yang,Gao Yang,et al. An Investigation on the Time Relaxation Parameter Used in Boiling  Simulation of Helical Coil Heat Exchanger ShellSide [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 53-60.
[14]	Gao Yang,Han Yunping,Pan Zhen,et al. Static Simulation Research and System Design of Gas Transmission Pipeline Network [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 61-66.
[15]	Fu Chun,Sun Xianglei,Wang Kun,et al. Research on Improved EMD Algorithm Based on FastICA [J]. Journal of Liaoning Petrochemical University, 2017, 37(5): 67-70.

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

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

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics