/// <summary>
/// 删除数据
/// </summary>
/// <param name="id">会议室id</param>
public void Detail(int id)
{
MeetRoom room = GetModel(id);
db.MeetRoom.DeleteOnSubmit(room);
db.SubmitChanges();
}
public ActionResult MeetRoomDetail()
{
int id = int.Parse(Request["id"]);
MeetRoom meetRoom = meetRoomService.GetModels(p => p.MeetRoomId == id).FirstOrDefault();
return(Json(meetRoom, JsonRequestBehavior.AllowGet));
}
public ActionResult Add(MeetRoom meetRoom)
{
if (meetRoom.MeetRoomId != 0)
{
//显示加载
MeetRoom updateMeetRoom = meetRoomService.GetModels(p => p.MeetRoomId == meetRoom.MeetRoomId).FirstOrDefault();
updateMeetRoom.Name = meetRoom.Name;
updateMeetRoom.HoldPerson = meetRoom.HoldPerson;
updateMeetRoom.Address = meetRoom.Address;
updateMeetRoom.Describe = meetRoom.Describe;
//updateMeetRoom.Picture = meetRoom.Picture;
if (updateMeetRoom.Name != null && meetRoomService.Update(updateMeetRoom))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
else
{
if (meetRoom.Name != null && meetRoomService.Add(meetRoom))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
}
public ActionResult GetUseTime()
{
string data = null;
List <String> list = new List <String>();
int id = int.Parse(Request.Params["id"]);
MeetRoom meetRoom = meetRoomService.GetModels(p => p.MeetRoomId == id).FirstOrDefault();
String[] dates = new String[0];
if (meetRoom != null && !String.IsNullOrEmpty(meetRoom.UseTime))
{
dates = meetRoom.UseTime.Split('|');
}
foreach (String date in dates)
{
String[] startend = date.Split(',');
String[] startStrArr = startend[1].Split(' ');
String[] endStrArr = startend[2].Split(' ');
String startStr = startStrArr[0].Replace("/", "-");
String endStr = endStrArr[0].Replace("/", "-");
String startDay = startStr.Split('-')[2];
String endDay = startStr.Split('-')[2];
//int startDay = int.Parse(startStr.Split('-')[2]);
//int endDay = int.Parse(startStr.Split('-')[2]);
if (!list.Contains(startDay))
{
list.Add(startDay);
}
if (list.Contains(endDay))
{
list.Add(endDay);
}
}
return(Json(list, JsonRequestBehavior.AllowGet));;
}
/// <summary>
/// 设置为可用
/// </summary>
/// <param name="id">会议室ID</param>
public void ValidChangeYes(int id)
{
MeetRoom room = GetModel(id);
room.IsValid = true;
db.SubmitChanges();
}
/// <summary>
/// 设置为不可用
/// </summary>
/// <param name="id">会议室ID</param>
public void ValidChangeNo(int id)
{
MeetRoom room = GetModel(id);
room.IsValid = false;
db.SubmitChanges();
}
/// <summary>
/// 保存会议室信息的修改
/// </summary>
/// <param name="emp">会议室实体</param>
public void Save(MeetRoom room)
{
if (room.RoomId == 0)
{
db.MeetRoom.InsertOnSubmit(room);
}
db.SubmitChanges();
}
public ActionResult Delete()
{
int id = int.Parse(Request["id"]);
MeetRoom meetRoom = meetRoomService.GetModels(p => p.MeetRoomId == id).FirstOrDefault();
if (meetRoomService.Delete(meetRoom))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
/// <summary>
/// 创建及修改获取会议室
/// </summary>
/// <param name="id">会议室ID</param>
/// <returns></returns>
public ActionResult CreateAndEditer(int?id)
{
MeetRoom emp = null;
if (id != null)
{
emp = db.GetModel(id.Value);
}
if (emp == null)
{
emp = new MeetRoom();
}
return(View(emp));
}
public ActionResult AddMeetRoom()
{
if (Request.Params["id"] != null)
{
int id = int.Parse(Request.Params["id"]);
MeetRoom meetRoom = meetRoomService.GetModels(p => p.MeetRoomId == id).FirstOrDefault();
ViewData["meetRoom"] = meetRoom;
ViewData["Name"] = meetRoom.Name;
ViewData["HoldPerson"] = meetRoom.HoldPerson;
ViewData["Address"] = meetRoom.Address;
ViewData["Describe"] = meetRoom.Describe;
ViewData["Picture"] = meetRoom.Picture;
ViewData["Status"] = meetRoom.Status;
ViewData["MeetRoomId"] = meetRoom.MeetRoomId;
}
return(View());
}
public ActionResult CreateAndEditer(int?id, string name, string remark, int person)
{
MeetRoom currentRoom;
if (id == 0 || id == null)
{
currentRoom = new MeetRoom();
}
else
{
currentRoom = db.GetModel(int.Parse(id.ToString()));
}
currentRoom.RoomName = name;
currentRoom.Person = person;
currentRoom.Remark = remark;
currentRoom.IsValid = true;
db.Save(currentRoom);
return(Json("OK"));
}
public ActionResult TimeIsUsed()
{
string data = null;
int id = int.Parse(Request.Params["id"]);
string dateStr = Request.Params["time"].Split(' ')[0];
DateTime dateTime = DateTime.Parse(Request.Params["time"]);
if (dateTime == null)
{
return(Content("输入时间格式有误"));
}
MeetRoom meetRoom = meetRoomService.GetModels(p => p.MeetRoomId == id).FirstOrDefault();
String[] dates = new String[0];
if (meetRoom != null && !String.IsNullOrEmpty(meetRoom.UseTime))
{
dates = meetRoom.UseTime.Split('|');
}
foreach (String date in dates)
{
String[] startend = date.Split(',');
String[] startStrArr = startend[1].Split(' ');
String[] endStrArr = startend[2].Split(' ');
String startStr = startStrArr[0].Replace("/", "-");
String endStr = endStrArr[0].Replace("/", "-");
if (DateTime.Parse(startStr).CompareTo(DateTime.Parse(dateStr)) == 0 || DateTime.Parse(endStr).CompareTo(DateTime.Parse(dateStr)) == 0)
{
if (data != null)
{
data += "\n" + startStrArr[1] + "到" + endStrArr[1];
}
else
{
data += "今天有会议：" + startStrArr[1] + "到" + endStrArr[1];
}
}
}
return(Content(data));
}
