• 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)缴费管理：对缴费信息进行添加、删除、修改和查看

    数据库设计

    1. BEGIN
    2. CREATE TABLE [dbo].[gly]([glyid] [int] IDENTITY(1,1) NOT NULL,
    3. [yhm] [VARCHAR](40),
    4. [mm] [VARCHAR](40),
    5. [xm] [VARCHAR](40),
    6. ) ON [PRIMARY]
    7. END
    8. GO
    9. 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'
    10. GO
    11. 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'
    12. GO
    13. 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'
    14. BEGIN
    15. CREATE TABLE [dbo].[banji]([bjid] [int] IDENTITY(1,1) NOT NULL,
    16. [bj] [VARCHAR](40),
    17. [js] [VARCHAR](40),
    18. ) ON [PRIMARY]
    19. END
    20. GO
    21. 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'
    22. GO
    23. 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'
    24. BEGIN
    25. CREATE TABLE [dbo].[jiaoshi]([jsid] [int] IDENTITY(1,1) NOT NULL,
    26. [yhm] [VARCHAR](40),
    27. [mm] [VARCHAR](40),
    28. [xm] [VARCHAR](40),
    29. [nl] [VARCHAR](40),
    30. [xb] [VARCHAR](40),
    31. ) ON [PRIMARY]
    32. END
    33. GO
    34. 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'
    35. GO
    36. 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'
    37. GO
    38. 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'
    39. GO
    40. 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'
    41. GO
    42. 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'
    43. BEGIN
    44. CREATE TABLE [dbo].[xuesheng]([xsid] [int] IDENTITY(1,1) NOT NULL,
    45. [yhm] [VARCHAR](40),
    46. [mm] [VARCHAR](40),
    47. [xm] [VARCHAR](40),
    48. [bj] [VARCHAR](40),
    49. [nl] [VARCHAR](40),
    50. [xb] [VARCHAR](40),
    51. ) ON [PRIMARY]
    52. END
    53. GO
    54. 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'
    55. GO
    56. 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'
    57. GO
    58. 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'
    59. GO
    60. 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'
    61. GO
    62. 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'
    63. GO
    64. 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'
    65. BEGIN
    66. CREATE TABLE [dbo].[jiazhang]([jzid] [int] IDENTITY(1,1) NOT NULL,
    67. [yhm] [VARCHAR](40),
    68. [mm] [VARCHAR](40),
    69. [xm] [VARCHAR](40),
    70. [nl] [VARCHAR](40),
    71. [xb] [VARCHAR](40),
    72. [xs] [VARCHAR](40),
    73. ) ON [PRIMARY]
    74. END
    75. GO
    76. 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'
    77. GO
    78. 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'
    79. GO
    80. 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'
    81. GO
    82. 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'
    83. GO
    84. 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'
    85. GO
    86. 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'
    87. BEGIN
    88. CREATE TABLE [dbo].[xxzy]([xxzyid] [int] IDENTITY(1,1) NOT NULL,
    89. [zymc] [VARCHAR](40),
    90. [js] [VARCHAR](40),
    91. [fbsj] [VARCHAR](40),
    92. [fj] [VARCHAR](40),
    93. ) ON [PRIMARY]
    94. END
    95. GO
    96. 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'
    97. GO
    98. 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'
    99. GO
    100. 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'
    101. GO
    102. 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'
    103. BEGIN
    104. CREATE TABLE [dbo].[kecheng]([kcid] [int] IDENTITY(1,1) NOT NULL,
    105. [kcmc] [VARCHAR](40),
    106. [js] [VARCHAR](40),
    107. [jg] [VARCHAR](40),
    108. ) ON [PRIMARY]
    109. END
    110. GO
    111. 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'
    112. GO
    113. 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'
    114. GO
    115. 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'
    116. BEGIN
    117. CREATE TABLE [dbo].[chengji]([cjid] [int] IDENTITY(1,1) NOT NULL,
    118. [xs] [VARCHAR](40),
    119. [kc] [VARCHAR](40),
    120. [cj] [VARCHAR](40),
    121. [fbsj] [VARCHAR](40),
    122. ) ON [PRIMARY]
    123. END
    124. GO
    125. 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'
    126. GO
    127. 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'
    128. GO
    129. 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'
    130. GO
    131. 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'
    132. BEGIN
    133. CREATE TABLE [dbo].[yuyue]([yyid] [int] IDENTITY(1,1) NOT NULL,
    134. [bt] [VARCHAR](40),
    135. [nr] [VARCHAR](40),
    136. [lx] [VARCHAR](40),
    137. [yysj] [VARCHAR](40),
    138. [sm] [VARCHAR](40),
    139. [zt] [VARCHAR](40),
    140. ) ON [PRIMARY]
    141. END
    142. GO
    143. 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'
    144. GO
    145. 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'
    146. GO
    147. 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'
    148. GO
    149. 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'
    150. GO
    151. 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'
    152. GO
    153. 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'
    154. BEGIN
    155. CREATE TABLE [dbo].[duanxin]([dxid] [int] IDENTITY(1,1) NOT NULL,
    156. [bt] [VARCHAR](40),
    157. [nr] [VARCHAR](40),
    158. [fbsj] [VARCHAR](40),
    159. [zt] [VARCHAR](40),
    160. [jsr] [VARCHAR](40),
    161. [fbr] [VARCHAR](40),
    162. ) ON [PRIMARY]
    163. END
    164. GO
    165. 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'
    166. GO
    167. 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'
    168. GO
    169. 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'
    170. GO
    171. 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'
    172. GO
    173. 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'
    174. GO
    175. 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'
    176. BEGIN
    177. CREATE TABLE [dbo].[jiaofei]([jfid] [int] IDENTITY(1,1) NOT NULL,
    178. [kc] [VARCHAR](40),
    179. [jfje] [VARCHAR](40),
    180. [jfsj] [VARCHAR](40),
    181. [yh] [VARCHAR](40),
    182. ) ON [PRIMARY]
    183. END
    184. GO
    185. 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'
    186. GO
    187. 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'
    188. GO
    189. 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'
    190. GO
    191. 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'
    192.  
    193.


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

    系统实现

     

     

     

     

     

  • 相关阅读:
    React学习之路-目录结构
    【论文笔记】基于动作空间划分的MAXQ自动分层方法
    玩以太坊链上项目的必备技能（初识智能合约语言-Solidity之旅一）
    一幅长文细学TypeScript（一）——上手
    关于循环浅析
    C++类型转换与函数
    递归方法反转链表（Java实现）
    短视频账号矩阵系统saas管理私信回复管理系统
    尬住了！小扎被自家产品爆黑料；酷炫清晰的『技术学习路线图』大合辑；Markdown引用块的N种样式；地形设计工具；前沿论文 | ShowMeAI资讯日报
    [附源码]计算机毕业设计springboot茶叶销售微信小程序
  • 原文地址：https://blog.csdn.net/qq_41221322/article/details/127406719