BEGIN
CREATE TABLE [dbo].[xueyuan]([xyid] [int] IDENTITY(1,1) NOT NULL,
[xy] [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'xueyuan', @level2type=N'COLUMN', @level2name=N'xy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xueyuan', @level2type=N'COLUMN', @level2name=N'js'
BEGIN
CREATE TABLE [dbo].[zhuanye]([zyid] [int] IDENTITY(1,1) NOT NULL,
[zy] [VARCHAR](40),
[fzr] [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'zhuanye', @level2type=N'COLUMN', @level2name=N'zy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanye', @level2type=N'COLUMN', @level2name=N'fzr'
BEGIN
CREATE TABLE [dbo].[quanxian]([qxid] [int] IDENTITY(1,1) NOT NULL,
[qx] [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'quanxian', @level2type=N'COLUMN', @level2name=N'qx'
BEGIN
CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[qx] [VARCHAR](40),
[zy] [VARCHAR](40),
[xy] [VARCHAR](40),
[zcsj] [VARCHAR](40),
[qs] [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'yonghu', @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'yonghu', @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'yonghu', @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'yonghu', @level2type=N'COLUMN', @level2name=N'qx'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专业' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'zy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学院' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'xy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注册时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'zcsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寝室' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'qs'
BEGIN
CREATE TABLE [dbo].[gongyu]([gyid] [int] IDENTITY(1,1) NOT NULL,
[gyh] [VARCHAR](40),
[lc] [VARCHAR](40),
[wz] [VARCHAR](40),
[fzr] [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'gongyu', @level2type=N'COLUMN', @level2name=N'gyh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'楼层' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gongyu', @level2type=N'COLUMN', @level2name=N'lc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'位置' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gongyu', @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'gongyu', @level2type=N'COLUMN', @level2name=N'fzr'
BEGIN
CREATE TABLE [dbo].[yegui]([ygid] [int] IDENTITY(1,1) NOT NULL,
[xs] [VARCHAR](40),
[rq] [VARCHAR](40),
[ygsj] [VARCHAR](40),
[tjr] [VARCHAR](40),
[yy] [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'yegui', @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'yegui', @level2type=N'COLUMN', @level2name=N'rq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'夜归时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yegui', @level2type=N'COLUMN', @level2name=N'ygsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yegui', @level2type=N'COLUMN', @level2name=N'tjr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'原因' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yegui', @level2type=N'COLUMN', @level2name=N'yy'
BEGIN
CREATE TABLE [dbo].[lixiao]([lxid] [int] IDENTITY(1,1) NOT NULL,
[xs] [VARCHAR](40),
[lxrq] [VARCHAR](40),
[fxrq] [VARCHAR](40),
[yy] [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'lixiao', @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'lixiao', @level2type=N'COLUMN', @level2name=N'lxrq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'返校日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'lixiao', @level2type=N'COLUMN', @level2name=N'fxrq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'原因' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'lixiao', @level2type=N'COLUMN', @level2name=N'yy'
BEGIN
CREATE TABLE [dbo].[qinshi]([qsid] [int] IDENTITY(1,1) NOT NULL,
[qsh] [VARCHAR](40),
[wz] [VARCHAR](40),
[gy] [VARCHAR](40),
[fzr] [VARCHAR](40),
[dh] [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'qinshi', @level2type=N'COLUMN', @level2name=N'qsh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'位置' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qinshi', @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'qinshi', @level2type=N'COLUMN', @level2name=N'gy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qinshi', @level2type=N'COLUMN', @level2name=N'fzr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qinshi', @level2type=N'COLUMN', @level2name=N'dh'
BEGIN
CREATE TABLE [dbo].[qscc]([qsccid] [int] IDENTITY(1,1) NOT NULL,
[qs] [VARCHAR](40),
[cc] [VARCHAR](40),
[jz] [VARCHAR](40),
[wp] [VARCHAR](40),
[sl] [VARCHAR](40),
[tjsj] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedprop
asp.net高校学生宿舍管理系统VS开发sqlserver数据库web结构c#编程计算机网页源码项目
版权申诉
5星 · 超过95%的资源 148 浏览量
2021-12-07
15:00:51
上传
评论 5
收藏 838KB RAR 举报 
asp.net高校学生宿舍管理系统VS开发sqlserver数据库web结构c#编程计算机网页源码项目 （239个子文件） 
left.aspx 6KB qinshidetail.aspx 6KB yonghuadd.aspx 4KB yonghumod.aspx 4KB login.aspx 3KB yonghulist.aspx 3KB qscclist.aspx 3KB qinshi.aspx 3KB qinshilist.aspx 3KB yeguilist.aspx 3KB lixiaolist.aspx 3KB gongyulist.aspx 3KB qsccadd.aspx 3KB myyeguilist.aspx 3KB zhuanyelist.aspx 3KB xueyuanlist.aspx 3KB mylixiaolist.aspx 2KB yeguiadd.aspx 2KB yonghudetail.aspx 2KB qinshiadd.aspx 2KB quanxianlist.aspx 2KB lixiaoadd.aspx 2KB qsccmod.aspx 2KB qinshimod.aspx 2KB yeguimod.aspx 2KB qsccdetail.aspx 2KB gongyuadd.aspx 2KB lixiaomod.aspx 2KB gongyumod.aspx 2KB yeguidetail.aspx 2KB lixiaodetail.aspx 2KB gongyudetail.aspx 2KB zhuanyeadd.aspx 2KB xueyuanadd.aspx 2KB zhuanyemod.aspx 2KB xueyuanmod.aspx 2KB quanxianadd.aspx 1KB zhuanyedetail.aspx 1KB xueyuandetail.aspx 1KB quanxianmod.aspx 1KB quanxiandetail.aspx 1KB top.aspx 1KB quanxiandel.aspx 452B xueyuandel.aspx 449B zhuanyedel.aspx 449B qinshidel.aspx 446B gongyudel.aspx 446B lixiaodel.aspx 446B yonghudel.aspx 446B yeguidel.aspx 443B qsccdel.aspx 440B Default.aspx 432B web.config 6KB DBHelper.cs 5KB MessageBox.cs 3KB yonghumod.aspx.cs 3KB qsccmod.aspx.cs 2KB yeguimod.aspx.cs 2KB qinshimod.aspx.cs 2KB yonghuadd.aspx.cs 2KB lixiaomod.aspx.cs 2KB gongyumod.aspx.cs 2KB yeguiadd.aspx.cs 2KB login.aspx.cs 2KB qsccadd.aspx.cs 2KB zhuanyemod.aspx.cs 2KB xueyuanmod.aspx.cs 2KB qinshidetail.aspx.cs 2KB qinshiadd.aspx.cs 2KB quanxianmod.aspx.cs 1KB lixiaoadd.aspx.cs 1KB gongyuadd.aspx.cs 1KB zhuanyeadd.aspx.cs 1KB xueyuanadd.aspx.cs 1KB yonghudetail.aspx.cs 1KB qsccdetail.aspx.cs 1KB quanxianadd.aspx.cs 1KB yeguidetail.aspx.cs 1KB lixiaodetail.aspx.cs 1001B gongyudetail.aspx.cs 997B zhuanyedetail.aspx.cs 910B xueyuandetail.aspx.cs 908B qinshi.aspx.cs 902B quanxiandel.aspx.cs 868B quanxiandetail.aspx.cs 867B xueyuandel.aspx.cs 864B zhuanyedel.aspx.cs 864B gongyudel.aspx.cs 860B qinshidel.aspx.cs 860B lixiaodel.aspx.cs 860B yonghudel.aspx.cs 860B yeguidel.aspx.cs 856B qsccdel.aspx.cs 854B myyeguilist.aspx.cs 669B mylixiaolist.aspx.cs 665B quanxianlist.aspx.cs 614B xueyuanlist.aspx.cs 612B zhuanyelist.aspx.cs 612B gongyulist.aspx.cs 610B qinshilist.aspx.cs 610B共 239 条
- 1
- 2
- 3
资源评论
yueyueyueue1232023-03-19资源中能够借鉴的内容很多，值得学习的地方也很多，大家一起进步！
weixin_476466282022-04-29用户下载后在一定时间内未进行评价，系统默认好评。
༺怪蜀黍༻2022-04-26用户下载后在一定时间内未进行评价，系统默认好评。
南风不起.2022-04-27用户下载后在一定时间内未进行评价，系统默认好评。- qq_13055300892022-09-18资源有一定的参考价值，与资源描述一致，很实用，能够借鉴的部分挺多的，值得下载。
