asp.net会展管理平台系统VS开发sqlserver数据库web结构c#编程计算机网页项目

本文链接：https://blog.csdn.net/qq_41221322/article/details/127229101

一、源码特点
ASP.NET 会展管理平台系统是一套完善的web设计管理系统，系统具有完整的源代码和数据库，系统主要采用B/S模式开发。开发环境为vs2010，数据库为sqlserver2008，使用c#语言
开发。

asp.net会展管理平台系统VS开发sqlserver数据

二、功能介绍

1.用户登录验证。

2.人员管理模块包括对系统内人员信息的发布，修改，查看，删除等功能。

3.场馆管理模块包括对系统内场馆信息的发布，修改，查看，删除等功能。

4.展会管理模块包括对系统内展会信息的发布，修改，查看，删除等功能。

5.地区管理模块包括对系统内地区信息的发布，修改，查看，删除等功能。

6.单位性质管理模块包括对系统内单位性质信息的发布，修改，查看，删除等功能。

7.展品类别管理模块包括对系统内展品类别信息的发布，修改，查看，删除等功能。
8.参展单位管理模块包括对系统内参展单位信息的发布，修改，查看，删除等功能。

数据库设计

BEGIN
CREATE TABLE [dbo].[ryxz]([ryxzid] [int] IDENTITY(1,1) NOT NULL,
[xz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性质' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ryxz', @level2type=N'COLUMN', @level2name=N'xz'
BEGIN
CREATE TABLE [dbo].[renyuan]([ryid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[js] [VARCHAR](40),
[dh] [VARCHAR](40),
[dz] [VARCHAR](40),
[xz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'js'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'dh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'dz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性质' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'xz'
BEGIN
CREATE TABLE [dbo].[changguan]([cgid] [int] IDENTITY(1,1) NOT NULL,
[cgmc] [VARCHAR](40),
[dhhm] [VARCHAR](40),
[chuanz] [VARCHAR](40),
[dzyj] [VARCHAR](40),
[wz] [VARCHAR](40),
[gd] [VARCHAR](40),
[cz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'场馆名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'changguan', @level2type=N'COLUMN', @level2name=N'cgmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话号码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'changguan', @level2type=N'COLUMN', @level2name=N'dhhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'传真' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'changguan', @level2type=N'COLUMN', @level2name=N'chuanz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮件' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'changguan', @level2type=N'COLUMN', @level2name=N'dzyj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'changguan', @level2type=N'COLUMN', @level2name=N'wz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'高度' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'changguan', @level2type=N'COLUMN', @level2name=N'gd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'承重' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'changguan', @level2type=N'COLUMN', @level2name=N'cz'
BEGIN
CREATE TABLE [dbo].[zhanhui]([zhid] [int] IDENTITY(1,1) NOT NULL,
[zh] [VARCHAR](40),
[cg] [VARCHAR](40),
[jbrq] [VARCHAR](40),
[sm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'展会' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhanhui', @level2type=N'COLUMN', @level2name=N'zh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'场馆' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhanhui', @level2type=N'COLUMN', @level2name=N'cg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'举办日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhanhui', @level2type=N'COLUMN', @level2name=N'jbrq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhanhui', @level2type=N'COLUMN', @level2name=N'sm'
BEGIN
CREATE TABLE [dbo].[diqu]([dqid] [int] IDENTITY(1,1) NOT NULL,
[dqmc] [VARCHAR](40),
[sjdq] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地区名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'diqu', @level2type=N'COLUMN', @level2name=N'dqmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上级地区' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'diqu', @level2type=N'COLUMN', @level2name=N'sjdq'
BEGIN
CREATE TABLE [dbo].[dwxz]([dwxzid] [int] IDENTITY(1,1) NOT NULL,
[xz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性质' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'dwxz', @level2type=N'COLUMN', @level2name=N'xz'
BEGIN
CREATE TABLE [dbo].[zplb]([zplbid] [int] IDENTITY(1,1) NOT NULL,
[lb] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zplb', @level2type=N'COLUMN', @level2name=N'lb'
BEGIN
CREATE TABLE [dbo].[czdw]([czdwid] [int] IDENTITY(1,1) NOT NULL,
[dwmc] [VARCHAR](40),
[zh] [VARCHAR](40),
[zplb] [VARCHAR](40),
[zychnr] [VARCHAR](40),
[zp] [VARCHAR](40),
[cjsj] [VARCHAR](40),
[bz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'czdw', @level2type=N'COLUMN', @level2name=N'dwmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'展会' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'czdw', @level2type=N'COLUMN', @level2name=N'zh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'展品类别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'czdw', @level2type=N'COLUMN', @level2name=N'zplb'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要参会内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'czdw', @level2type=N'COLUMN', @level2name=N'zychnr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'czdw', @level2type=N'COLUMN', @level2name=N'zp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'参加时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'czdw', @level2type=N'COLUMN', @level2name=N'cjsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'czdw', @level2type=N'COLUMN', @level2name=N'bz'

三、注意事项
1、管理员账号：admin 密码：admin
2、开发环境为vs2010，数据库为sqlserver2008，使用c#语言开发。
3、数据库文件名aspnethuizhan.mdf
4.登录地址：login.aspx