摘要
社区院落是社会的基本单元,是巩固党的执政基础的重要基石。为推动社区院落群众文化生活繁荣兴盛,在基层群众娱乐中进一步加强基层社区治理和文化建设,强化党政方针政策在基层的宣传,基于C#语言开发了智慧院落监管系统。系统采用C/S技术架构,依托SQL Server2008R2进行数据库设计,实现了社区院落宣传播放任务的编排、智能终端的控制和监视,实现通讯服务器与智能终端之间的流畅通讯。为方便社区管理人员远程监控社区各院落智能终端的工作状况及播放内容,实现了监管端APP。介绍了系统开发的主要方案及软件工作流程,阐述了系统主要业务实现过程,如:文件和版块管理、节目单的编排及控制、智能终端工作状态查询等,描述了系统设计的关键类及关键算法流程、主要数据表的结构及表间关系。经实际应用,系统稳定可靠,对丰富社区群众文化活动及强化政策宣讲起到了推动作用。
Community courtyards are the basic unit of society, cozy space for people to live in harmony, and an important cornerstone to consolidate our party’s governing foundation. In order to promote the prosperity of cultural life in community courtyards, further strengthen grassroots community governance and culture construction, and enhance the promotion of our party and government’s poli-cies at the grassroots level, we developed a smart courtyard supervision system based on C# language. The system adopts C/S structure, which enables the publicity and broadcasting tasks in community courtyards, the control and monitoring of intelligent terminals, and the smooth communication between communication servers and intelligent terminals. The database is designed based on SQL Server 2008R2. In order to facilitate the community management personnel to remotely monitor the working status and playback content of the smart terminals in various courtyards, a supervision APP has been implemented as well. This article introduces the main program and software workflow of the system, and describes the main business implementation of the system such as: file and plate management, program schedule and control, intelligent terminal work status query, etc. Additionally, this paper also demonstrates the key classes and algorithms of the system, the structure of the main data tables, and the relationships between the tables. The practical application shows that the system is stable and reliable. It has promoted the enrichment of community cultural activities and strengthened policy promotion.
出处
《计算机科学与应用》
2020年第5期950-959,共10页
Computer Science and Application
