系统结构构成
一、组织架构
二、系统详细说明
2.1 数据库部分构成
数据库系统主要采用SQL2005 .
数据库名称:zhaoming ,下分七个表;
第一个用户表: tbuser ,字段构成如下
USE [ZhaoMing]
GO
/****** 对象: Table [dbo].[tbUser] 脚本日期: 08/30/2011 16:28:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbUser](
[序号] [int] IDENTITY(1,1) NOT NULL,
[操作员] [nvarchar](10) NULL CONSTRAINT [DF_tbUser_操作员] DEFAULT (N'User'),
[密码] [nvarchar](20) NULL CONSTRAINT [DF_tbUser_密码] DEFAULT (N'ss'),
[站点] [nvarchar](20) NULL CONSTRAINT [DF_tbUser_站点] DEFAULT (N'"1号站点“'),
[权限] [nvarchar](10) NULL,
[备注] [nvarchar](50) NULL CONSTRAINT [DF_tbUser_备注] DEFAULT (N'无'),
CONSTRAINT [PK_tbUser] PRIMARY KEY CLUSTERED
(
[序号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
主要用来记录操作人员的权限和登录密码。为系统下一步控制起到分级作控制作用。只有管理人员才能修改灯的信息。
第二个日志表 :tblog,字段构成如下
USE [ZhaoMing]
GO
/****** 对象: Table [dbo].[tbLog] 脚本日期: 08/30/2011 16:36:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbLog](
[序号] [int] IDENTITY(1,1) NOT NULL,
[站点] [nvarchar](20) NULL,
[操作员] [nvarchar](10) NULL,
[事件] [nvarchar](50) NULL,
[时间] [datetime] NULL,
[备注] [nvarchar](50) NULL,
CONSTRAINT [PK_tbLog] PRIMARY KEY CLUSTERED
(
[序号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
主要用来记录操作过程痕迹,如记录操作员何时修改灯的信息,何时开关灯,何时修改开关灯时间,何时添加删除数据等。便于今后查询和分析。
第三个灯运行状态表 ,tbLedValue,字段构成如下
USE [ZhaoMing]
GO
/****** 对象: Table [dbo].[tbLedValue] 脚本日期: 08/30/2011 16:43:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbLedValue](
[序号] [int] IDENTITY(1,1) NOT NULL,
[灯名称] [nvarchar](20) NULL,
[灯状态] [int] NULL,
CONSTRAINT [PK_tbLedValue] PRIMARY KEY CLUSTERED
(
[序号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
主要用来记录每一个灯塔(或每一个模块地址)的实时运行状态,为其他系统(b/s)提供数据支持。这里有一个问题是:一个模块带数个灯塔。这要求是保存地址还是灯塔需要慎重考虑。
第四个开关灯时间统计表 ,tbLedTimed,字段构成如下
USE [ZhaoMing]
GO
/****** 对象: Table [dbo].[tbLedTimed] 脚本日期: 08/30/2011 16:51:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbLedTimed](
[序号] [int] IDENTITY(1,1) NOT NULL,
[灯名称] [nvarchar](20) NULL,
[开灯时间] [datetime] NULL CONSTRAINT [DF_tbLedTimed_开灯时间] DEFAULT (getdate()),
[关灯时间] [datetime] NULL CONSTRAINT [DF_tbLedTimed_关灯时间] DEFAULT (getdate()),
[合计时间] [int] NULL CONSTRAINT [DF_tbLedTimed_合计时间] DEFAULT (1),
CONSTRAINT [PK_tbLedTimed] PRIMARY KEY CLUSTERED
(
[序号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
主要用来记录每一个灯的开灯时间,关灯时间及合计时间。每一天的开灯时间和关灯时间都预先记录好。
第五个开灯时间表,tbLedOpenTime主要字段构成
USE [ZhaoMing]
GO
/****** 对象: Table [dbo].[tbLedOpenTime] 脚本日期: 08/30/2011 16:56:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbLedOpenTime](
[序号] [int] IDENTITY(1,1) NOT NULL,
[灯地址] [nvarchar](50) NULL,
[通道号] [int] NULL,
[开灯时间] [datetime] NULL,
CONSTRAINT [PK_tbLedOpenTime] PRIMARY KEY CLUSTERED
(
[序号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
主要记录每一个模块地址对应通道号的开灯时间。为关灯时间作好记录保证;
第六个灯的IP地址表,tbLedIp,主要字段构成
USE [ZhaoMing]
GO
/****** 对象: Table [dbo].[tbLedIp] 脚本日期: 08/30/2011 17:00:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbLedIp](
[序号] [int] IDENTITY(1,1) NOT NULL,
[灯名称] [nvarchar](20) NULL,
[灯地址] [nvarchar](20) NULL,
[灯输入通道] [int] NULL,
[灯输出通道] [int] NULL,
[备注] [nvarchar](50) NULL,
CONSTRAINT [PK_tbLedIp] PRIMARY KEY CLUSTERED
(
[序号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
主要记录每一个模块的IP名称,IP地址,灯的输入通道数量,灯的输出通道数量,这里是针对带IP地址的模块。
第七个模块地址信息表,表名称 tbLedInfo,主要字段构成
USE [ZhaoMing]
GO
/****** 对象: Table [dbo].[tbLedInfo] 脚本日期: 08/30/2011 17:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbLedInfo](
[序号] [int] IDENTITY(1,1) NOT NULL,
[模块地址] [int] NULL CONSTRAINT [DF_tbLedInfo_模块地址] DEFAULT (0),
[灯名称] [nvarchar](20) NULL,
[通道数] [int] NULL CONSTRAINT [DF_tbLedInfo_通道数] DEFAULT (1),
[通道方向] [nvarchar](20) NULL CONSTRAINT [DF_tbLedInfo_通道方向] DEFAULT (N'无'),
[通道方向] [nvarchar](20) NULL CONSTRAINT [DF_tbLedInfo_通道方向] DEFAULT (N'无'),
[通道方向] [nvarchar](20) NULL CONSTRAINT [DF_tbLedInfo_通道方向] DEFAULT (N'无'),
[通道方向] [nvarchar](20) NULL CONSTRAINT [DF_tbLedInfo_通道方向] DEFAULT (N'无'),
[启动状态] [bit] NULL CONSTRAINT [DF_tbLedInfo_启动状态] DEFAULT (1),
[备注] [nvarchar](50) NULL CONSTRAINT [DF_tbLedInfo_备注] DEFAULT (N'无'),
CONSTRAINT [PK_tbLedInfo] PRIMARY KEY CLUSTERED
(
[序号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
这个表主要用来记录不带IP地址的开关量模块,7065D模块。如模块名称 ,通道数量 及每个通道接的灯的方向及启动状态。