1984asp.net宿舍管理系统VS开发sqlserver数据库web结构c#编程Microsoft Visual Studio

最新推荐文章于 2024-11-01 12:20:35 发布

翰文编程

最新推荐文章于 2024-11-01 12:20:35 发布

阅读量971

点赞数 11

分类专栏： asp.net类文章标签：数据库 asp.net sqlserver

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

版权

asp.net类专栏收录该内容

228 篇文章 23 订阅

订阅专栏

一、源码特点
asp.net宿舍管理系统是一套完善的web设计管理系统，系统采用mvc模式（BLL+DAL+ENTITY）系统具有完整的源代码和数据库，系统主要采用B/S模式开发。开发环境为vs2010，数据库为sqlserver2008，使用c#语言开发

asp.net学生宿舍管理系统

二、功能介绍

(1)管理员管理：对管理员信息进行添加、删除、修改和查看
(2)学生管理：对学生信息进行添加、删除、修改和查看
(3)宿舍管理：对宿舍信息进行添加、删除、修改和查看
(4)处罚管理：对处罚信息进行添加、删除、修改和查看
(5)访客登记管理：对访客登记信息进行添加、删除、修改和查看
(6)安全检查管理：对安全检查信息进行添加、删除、修改和查看
(7)财产管理：对财产信息进行添加、删除、修改和查看
(8)报修管理：对报修信息进行添加、删除、修改和查看
(9)费用类型管理：对费用类型信息进行添加、删除、修改和查看
(10)费用管理：对费用信息进行添加、删除、修改和查看
(11)缴费管理：对缴费信息进行添加、删除、修改和查看
(12)调宿管理：对调宿信息进行添加、删除、修改和查看
(13)公告管理：对公告信息进行添加、删除、修改和查看
(14)卫生检查管理：对卫生检查信息进行添加、删除、修改和查看
(15)奖励管理：对奖励信息进行添加、删除、修改和查看

数据库设计

BEGIN
CREATE TABLE [dbo].[gly]([glyid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[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'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'
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'qx'
BEGIN
CREATE TABLE [dbo].[xuesheng]([xsid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[ss] [VARCHAR](40),
[nl] [VARCHAR](40),
[xb] [VARCHAR](40),
[zy] [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'ss'
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'
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'zy'
BEGIN
CREATE TABLE [dbo].[sushe]([ssid] [int] IDENTITY(1,1) NOT NULL,
[ssmc] [VARCHAR](40),
[bh] [VARCHAR](40),
[lc] [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'sushe', @level2type=N'COLUMN', @level2name=N'ssmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'sushe', @level2type=N'COLUMN', @level2name=N'bh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'楼层' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'sushe', @level2type=N'COLUMN', @level2name=N'lc'
BEGIN
CREATE TABLE [dbo].[chufa]([cfid] [int] IDENTITY(1,1) NOT NULL,
[cfbt] [VARCHAR](40),
[cfnr] [VARCHAR](40),
[xs] [VARCHAR](40),
[fbsj] [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'chufa', @level2type=N'COLUMN', @level2name=N'cfbt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'处罚内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'chufa', @level2type=N'COLUMN', @level2name=N'cfnr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'chufa', @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'chufa', @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'chufa', @level2type=N'COLUMN', @level2name=N'yy'
BEGIN
CREATE TABLE [dbo].[fkdj]([fkdjid] [int] IDENTITY(1,1) NOT NULL,
[fwsj] [VARCHAR](40),
[ss] [VARCHAR](40),
[fwsy] [VARCHAR](40),
[lxr] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[djsj] [VARCHAR](40),
) ON [PRIMARY]
END

代码设计

      public static string sql = "";
	/// <summary>
    	///表baoxiu [报修]  的添加方法
    	/// </summary>
        public static bool Addbaoxiu(ENTITY.baoxiu baoxiu)
        {
            string sql = "insert into baoxiu(bt,cc,sm,yh,bxsj,zt,hf) values('"+baoxiu.bt+"','"+baoxiu.cc+"','"+baoxiu.sm+"','"+baoxiu.yh+"','"+baoxiu.bxsj+"','"+baoxiu.zt+"','"+baoxiu.hf+"')";
      
          
		
            return (DBHelper.update(sql) > 0) ? true : false;
        }
	/// <summary>
    	///通过表baoxiu [报修]  的主键获得该信息 的方法
    	/// </summary>
        public static ENTITY.baoxiu getbaoxiuinfo(int bxid)
        {
            string sql = "select * from baoxiu where  bxid=" + bxid;
                  SqlDataReader DataRead = DBHelper.GetReader(sql);//查询
            ENTITY.baoxiu baoxiu = new ENTITY.baoxiu();//初始化对象
            while (DataRead.Read())
            {//遍历
              
		baoxiu.bxid = Convert.ToInt32(DataRead["bxid"]);//报修编号

baoxiu.bt = DataRead["bt"].ToString();//标题

baoxiu.cc = DataRead["cc"].ToString();//财产

baoxiu.sm = DataRead["sm"].ToString();//说明

baoxiu.yh = DataRead["yh"].ToString();//用户

baoxiu.bxsj = DataRead["bxsj"].ToString();//报修时间

baoxiu.zt = DataRead["zt"].ToString();//状态

baoxiu.hf = DataRead["hf"].ToString();//回复



            }
            return baoxiu;

        }
	/// <summary>
    	///通过表baoxiu [报修]  的主键更改该信息 的修改方法
    	/// </summary>		
        public static bool Editbaoxiu(ENTITY.baoxiu baoxiu)
        {
            string sql = "update baoxiu set bt='"+baoxiu.bt+"',cc='"+baoxiu.cc+"',sm='"+baoxiu.sm+"',yh='"+baoxiu.yh+"',bxsj='"+baoxiu.bxsj+"',zt='"+baoxiu.zt+"',hf='"+baoxiu.hf+"'  where bxid='"+baoxiu.bxid+"'";
           

            return (DBHelper.update(sql) > 0) ? true : false;
        }
	/// <summary>
    	///通过主键id 删除表baoxiu [报修]  的方法
    	/// </summary>
        public static bool Delbaoxiu(string p)
        {
            string sql = "delete from baoxiu where bxid in (" + p + ") ";
            return ((DBHelper.update(sql)) > 0) ? true : false;
        }
	/// <summary>
    	///查询表baoxiu [报修]  的获取全部数据方法，提供分页
    	/// </summary>
        public static System.Data.DataTable querybaoxiu(string strWhere)
        {
            try
            {
                string strSql = " select * from baoxiu where 1=1"+strWhere;
                string strShow = "*";
                             return DBHelper.GetDataSet(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
	/// <summary>
    	///查询表baoxiu [报修]  的获取全部数据方法
    	/// </summary>
        public static DataSet getAllbaoxiu(string str)
        {
            try
            {	string st="";
		if(str!=""){
		st=str;
		}
                string strSql = "select * from baoxiu where 1=1 "+st;
                return DBHelper.query(strSql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

四系统实现

需要源码其他的定制服务下方联系卡片↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ 或者私信作者