摘  要：随着社会经济的快速发展，人们对家居生活智能化有了更高的要求。本文介绍智能家居系统课题中服务端管理软件功能及设计思想和设计过程。系统可供普通用户和管理员登录。普通用户可登录此系统查看自家安防情况及开关灯、开关窗帘等操作；管理员可以对用户进行管理，包括修改信息，删除用户和新增用户等操作，同时管理员可以看到本系统内全部用户的情况，并可以对其家里进行远程控制操作。本文通过对当前网站开发中常用的各种技术进行分析对比，确定采用基于ASP.NET的B/S架构，同时使用Microsoft SQL Server 2008作为数据库存储和迁移的工具，遵循Http协议，数据传输采用json格式。系统开发环境为visual studio 2010 + SQLserver 2008；系统后台架构技术分为：界面层、业务逻辑层、数据层三层分离技术；系统前台架构技术为：p + CSS 布局，ajax 实现局部数据更新。71367

毕业论文关键词：智能家居，控制，B/S，json。

Abstract:With the rapid development of social economy, people have a higher demand on intelligent household life. In this paper, the intelligent household system project in the server management software function and design ideas and design process. System is available for ordinary users and administrators to log in. Ordinary users can login this system to view their own security situation and open to turn off the lights, switch the curtains and other operations; Administrator can manage the users, including modify information, delete user and new user operation, at the same time, the administrator can see all the users in this system, and can be conducted on its home remote control operation. This article through to the current web development that is commonly used in technical analysis comparison, determine the B/S architecture based on ASP.NET, at the same time using Microsoft SQL Server 2008 as the database storage and migration tool, follow the Http protocol, data transmission using the json format. System development environment for visual studio 2010 + used 2008; System background architecture technology is pided into: interface layer, business logic layer and data layer three layer separation technology; System architecture reception technology is: the p + CSS layout, ajax local data update.

Keywords: Smart home, Control, B/S, Json.

目  录

1 引言 4

1.1 开发意义 4

1.2 需求分析 4

1.3 可行性分析 5

2 系统开发环境及开发工具的介绍 5

2.1 系统开发环境 5

2.2 开发工具 5

3 系统设计说明 7

3.1 系统功能结构图 7

3.2 功能模块解释 8

3.3 系统E-R图 11

3.4 数据库设计 11

4 部分代码实现 12

4.1 业务层（以管理员为例） 12

4.2 数据层（以管理员为例） 12

4.3 数据库的连接 13

5 系统功能模块的实现 13

5.1 系统登录 13

5.2系统各功能模块的实现 17

结 论 21

参考文献 22 ASP.NET+sqlserver智能家居系统服务端管理软件设计与实现:http://www.youerw.com/jisuanji/lunwen_81015.html