采用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; }
}
}
}