asp.net家校互动系统VS开发sqlserver数据库web结构c#编程计算机网页项目

一、源码特点
       ASP.NET家校互动系统是一套完善的计算机web设计系统,系统具有完整的源代码和数据库,系统主要采用B/S模式开发。开发环境为vs2010,数据库为sqlserver2008,使用c#语言开发

asp.net家校互动系统VS开发sqlserver数据库


二、功能介绍
(1)管理员管理:对管理员信息进行添加、删除、修改和查看
(2)班级管理:对班级信息进行添加、删除、修改和查看
(3)教师管理:对教师信息进行添加、删除、修改和查看
(4)学生管理:对学生信息进行添加、删除、修改和查看
(5)家长管理:对家长信息进行添加、删除、修改和查看
(6)学习资源管理:对学习资源信息进行添加、删除、修改和查看
(7)课程管理:对课程信息进行添加、删除、修改和查看
(8)成绩管理:对成绩信息进行添加、删除、修改和查看
(9)预约管理:对预约信息进行添加、删除、修改和查看
(10)短信管理:对短信信息进行添加、删除、修改和查看
(11)缴费管理:对缴费信息进行添加、删除、修改和查看

数据库设计

BEGIN
CREATE TABLE [dbo].[gly]([glyid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [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'gly', @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'gly', @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'gly', @level2type=N'COLUMN', @level2name=N'xm'
BEGIN
CREATE TABLE [dbo].[banji]([bjid] [int] IDENTITY(1,1) NOT NULL,
[bj] [VARCHAR](40),
[js] [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'banji', @level2type=N'COLUMN', @level2name=N'bj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'banji', @level2type=N'COLUMN', @level2name=N'js'
BEGIN
CREATE TABLE [dbo].[jiaoshi]([jsid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[nl] [VARCHAR](40),
[xb] [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'jiaoshi', @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'jiaoshi', @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'jiaoshi', @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'jiaoshi', @level2type=N'COLUMN', @level2name=N'nl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jiaoshi', @level2type=N'COLUMN', @level2name=N'xb'
BEGIN
CREATE TABLE [dbo].[xuesheng]([xsid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[bj] [VARCHAR](40),
[nl] [VARCHAR](40),
[xb] [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'xuesheng', @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'xuesheng', @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'xuesheng', @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'xuesheng', @level2type=N'COLUMN', @level2name=N'bj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'nl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'xb'
BEGIN
CREATE TABLE [dbo].[jiazhang]([jzid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[nl] [VARCHAR](40),
[xb] [VARCHAR](40),
[xs] [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'jiazhang', @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'jiazhang', @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'jiazhang', @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'jiazhang', @level2type=N'COLUMN', @level2name=N'nl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jiazhang', @level2type=N'COLUMN', @level2name=N'xb'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jiazhang', @level2type=N'COLUMN', @level2name=N'xs'
BEGIN
CREATE TABLE [dbo].[xxzy]([xxzyid] [int] IDENTITY(1,1) NOT NULL,
[zymc] [VARCHAR](40),
[js] [VARCHAR](40),
[fbsj] [VARCHAR](40),
[fj] [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'xxzy', @level2type=N'COLUMN', @level2name=N'zymc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xxzy', @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'xxzy', @level2type=N'COLUMN', @level2name=N'fbsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xxzy', @level2type=N'COLUMN', @level2name=N'fj'
BEGIN
CREATE TABLE [dbo].[kecheng]([kcid] [int] IDENTITY(1,1) NOT NULL,
[kcmc] [VARCHAR](40),
[js] [VARCHAR](40),
[jg] [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'kecheng', @level2type=N'COLUMN', @level2name=N'kcmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kecheng', @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'kecheng', @level2type=N'COLUMN', @level2name=N'jg'
BEGIN
CREATE TABLE [dbo].[chengji]([cjid] [int] IDENTITY(1,1) NOT NULL,
[xs] [VARCHAR](40),
[kc] [VARCHAR](40),
[cj] [VARCHAR](40),
[fbsj] [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'chengji', @level2type=N'COLUMN', @level2name=N'xs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'课程' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'chengji', @level2type=N'COLUMN', @level2name=N'kc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成绩' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'chengji', @level2type=N'COLUMN', @level2name=N'cj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'chengji', @level2type=N'COLUMN', @level2name=N'fbsj'
BEGIN
CREATE TABLE [dbo].[yuyue]([yyid] [int] IDENTITY(1,1) NOT NULL,
[bt] [VARCHAR](40),
[nr] [VARCHAR](40),
[lx] [VARCHAR](40),
[yysj] [VARCHAR](40),
[sm] [VARCHAR](40),
[zt] [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'yuyue', @level2type=N'COLUMN', @level2name=N'bt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yuyue', @level2type=N'COLUMN', @level2name=N'nr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yuyue', @level2type=N'COLUMN', @level2name=N'lx'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yuyue', @level2type=N'COLUMN', @level2name=N'yysj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yuyue', @level2type=N'COLUMN', @level2name=N'sm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yuyue', @level2type=N'COLUMN', @level2name=N'zt'
BEGIN
CREATE TABLE [dbo].[duanxin]([dxid] [int] IDENTITY(1,1) NOT NULL,
[bt] [VARCHAR](40),
[nr] [VARCHAR](40),
[fbsj] [VARCHAR](40),
[zt] [VARCHAR](40),
[jsr] [VARCHAR](40),
[fbr] [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'duanxin', @level2type=N'COLUMN', @level2name=N'bt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'duanxin', @level2type=N'COLUMN', @level2name=N'nr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'duanxin', @level2type=N'COLUMN', @level2name=N'fbsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'duanxin', @level2type=N'COLUMN', @level2name=N'zt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'duanxin', @level2type=N'COLUMN', @level2name=N'jsr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'duanxin', @level2type=N'COLUMN', @level2name=N'fbr'
BEGIN
CREATE TABLE [dbo].[jiaofei]([jfid] [int] IDENTITY(1,1) NOT NULL,
[kc] [VARCHAR](40),
[jfje] [VARCHAR](40),
[jfsj] [VARCHAR](40),
[yh] [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'jiaofei', @level2type=N'COLUMN', @level2name=N'kc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缴费金额' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jiaofei', @level2type=N'COLUMN', @level2name=N'jfje'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缴费时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jiaofei', @level2type=N'COLUMN', @level2name=N'jfsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jiaofei', @level2type=N'COLUMN', @level2name=N'yh'



三、注意事项
   1、管理员账号:admin 密码:admin  主要角色 :用户和管理员
   2、开发环境为vs2010,数据库为sqlserver2008,使用c#语言开发。
   3、数据库文件名aspnetjiaxiao.mdf 
   4.登录地址:login.aspx

系统实现

 

 

 

 

 

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

qq_251836457

你的鼓励 是我最大的动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值