Implementation on Data Layer Component for Music Equipment Accounting Treatment System

Abstract:

With the national efforts to increase investment for quality education and an increase in the number of college enrollment music class students, so the college needs more music equipments. And the music equipment management is always one of the challenges for colleges and universities. Accounting treatment system is the core part of the music equipment management system, and this paper carries on study based on SQLServer database and ADO.NET framework. First, database design which includes conceptual structure design and logical structure design should be conducted; then, ADO.NET architecture can be researched, including the description of the structure model and its components; finally, studying the implementation on data layer component which includes the process when creating solutions and the three main processes when implementing data layer component. The successful use of research results in this paper will certainly improve the quality of development efficiency of music equipment management accounting treatment system and promote information construction in colleges and universities.

• Periodical: Applied Mechanics and Materials (Volumes 543-547)
• Pages: 4569-4572
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.543-547.4569
• Online since: March 2014
• Authors: Xin Xin Lv*
• Keywords: Accounting Treatment, Data Layer Component, Management System, Music Equipment

References

[1] X. H. Yi, Design and implementation of music equipment management system, " Master, s Degree of University of Shandong, (2011).

[2] K. X. Zhang, Research on the training mode of application oriented local university music professionals, Journal of Foshan University (Social Science Edition), vol. 30, no. 7, pp.20-24, (2012).

[3] L. J. Zheng, K. Li Database Design of Materials Classification Detailed Account, Lecture Notes in Information Technology, vol. 1, pp.104-108, (2012).

[4] W. J. Tao, Data Access Technology Based on ADO. NET, Computer Knowledge and Technology, vol. 15, no. 2, pp.205-207, (2008).

[5] X. Z. An, W. M. Ding, Class for data access based on . Net, Computer Engineering and Design, vol. 25, no. 3, pp.457-459, (2004).

[6] Y. N. Chen, Use ADO. NET to Achieve Data Access Layer Based on the . NET Platform, Computer Programming Skills & Maintenance, vol. 19, no. 4, pp.35-36, (2012).

[7] Baiduencyclopedia, namespace, "http: /baike. baidu. com/link, url=WeBcQR-ZTKBkWz5gUlNDNn15U5_saNKSaRDdxBaojvOviuDPYEunrQVgtKnvzH2WntOYtJkBi-KJd-ahn50tO_, 2014-1-10.

[8] X. F. Zhao, Application of ADO. NET Data Access Technology in Electronic Document Management System, Communications Technology, vol. 42, no. 8, pp.123-125, (2009).