预约系统（二） MVC框架搭建

采用VS2013，自带的MVC4来搭建

 

MODEL层，表对象的建立：

 

T_Bm.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Reservation.MODEL
{
    public class T_Bm
    {
        /// <summary>
        /// 部门表，对象
        /// </summary>

        int _id;

        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }

        //部门代号
        string bm_no;

        public string Bm_no
        {
            get { return bm_no; }
            set { bm_no = value; }
        }

        //部门名称
        string bm_mc;

        public string Bm_mc
        {
            get { return bm_mc; }
            set { bm_mc = value; }
        }

        //创建人
        string adder;

        public string Adder
        {
            get { return adder; }
            set { adder = value; }
        }

        //创建时间
        DateTime add_time;

        public DateTime Add_time
        {
            get { return add_time; }
            set { add_time = value; }
        }

    }
}

 

T_Hys_Plan.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Reservation.MODEL
{
    public class T_Hys_Plan
    {
        /// <summary>
        /// 会议室预约表，对象
        /// </summary>

        int id;

        public int Id
        {
            get { return id; }
            set { id = value; }
        }

        //创建时间
        DateTime add_time;

        public DateTime Add_time
        {
            get { return add_time; }
            set { add_time = value; }
        }

        //创建人
        string adder;

        public string Adder
        {
            get { return adder; }
            set { adder = value; }
        }

        //预约日期
        string rq;

        public string Rq
        {
            get { return rq; }
            set { rq = value; }
        }

        //预约开始时间
        string time_begin;

        public string Time_begin
        {
            get { return time_begin; }
            set { time_begin = value; }
        }

        //预约结束时间
        string time_end;

        public string Time_end
        {
            get { return time_end; }
            set { time_end = value; }
        }

        //会议室
        string hys;

        public string Hys
        {
            get { return hys; }
            set { hys = value; }
        }

        //预约人
        string yyr;

        public string Yyr
        {
            get { return yyr; }
            set { yyr = value; }
        }

        //预约部门
        string yybm;

        public string Yybm
        {
            get { return yybm; }
            set { yybm = value; }
        }

        //会议主题
        string hyzt;

        public string Hyzt
        {
            get { return hyzt; }
            set { hyzt = value; }
        }

        //目前状态
        string mqzt;

        public string Mqzt
        {
            get { return mqzt; }
            set { mqzt = value; }
        }

        //操作密码
        string lock_key;

        public string Lock_key
        {
            get { return lock_key; }
            set { lock_key = value; }
        }

        //是否例会
        string flax_while;

        public string Flax_while
        {
            get { return flax_while; }
            set { flax_while = value; }
        }

        //例会备注
        string flax_bz;

        public string Flax_bz
        {
            get { return flax_bz; }
            set { flax_bz = value; }
        }

        //每周几
        string zhou_x;

        public string Zhou_x
        {
            get { return zhou_x; }
            set { zhou_x = value; }
        }

        //每月几号
        string yue_x;

        public string Yue_x
        {
            get { return yue_x; }
            set { yue_x = value; }
        }

        //每天
        string day_x;

        public string Day_x
        {
            get { return day_x; }
            set { day_x = value; }
        }

        //备注
        string bz;

        public string Bz
        {
            get { return bz; }
            set { bz = value; }
        }

        string flax;

        //标志 0:普通预约 1：例会预约
        public string Flax
        {
            get { return flax; }
            set { flax = value; }
        }
    }

}

 

T_Room.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Reservation.MODEL
{
    public class T_Room
    {

        /// <summary>
        /// 会议室表，对象
        /// </summary>


        int id;

        public int Id
        {
            get { return id; }
            set { id = value; }
        }

        //会议室编号
        string room_id;

        public string Room_id
        {
            get { return room_id; }
            set { room_id = value; }
        }

        //会议室名字：一楼教育培训会议室，一楼大会议室......
        string room_mc;

        public string Room_mc
        {
            get { return room_mc; }
            set { room_mc = value; }
        }

        //创建人
        string adder;

        public string Adder
        {
            get { return adder; }
            set { adder = value; }
        }

        //创建时间
        DateTime add_time;

        public DateTime Add_time
        {
            get { return add_time; }
            set { add_time = value; }
        }

    }
}

 

T_UserInfo.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Reservation.MODEL
{
    public class T_UserInfo
    {
        /// <summary>
        /// 用户表，对象
        /// </summary>

        //id
        int id;

        public int Id
        {
            get { return id; }
            set { id = value; }
        }

        //用户名
        string userName;

        public string UserName
        {
            get { return userName; }
            set { userName = value; }
        }

        //密码
        string userPassword;

        public string UserPassword
        {
            get { return userPassword; }
            set { userPassword = value; }
        }

        //邮箱
        string userEmail;

        public string UserEmail
        {
            get { return userEmail; }
            set { userEmail = value; }
        }

        //部门
        string user_BM;

        public string User_BM
        {
            get { return user_BM; }
            set { user_BM = value; }
        }

        //添加时间
        DateTime add_time;

        public DateTime Add_time
        {
            get { return add_time; }
            set { add_time = value; }
        }

        //用户全名
        string user_FullName;

        public string User_FullName
        {
            get { return user_FullName; }
            set { user_FullName = value; }
        }

        string user_Power;

        public string User_Power
        {
            get { return user_Power; }
            set { user_Power = value; }
        }
    }
}