public JsonResult MeetingroomApplySave(T_MeetingRoom model) { using (TransactionScope sc = new TransactionScope()) { try { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); model.IsDelete = 0; model.PostTime = DateTime.Now; model.Status = -1; model.Step = 1; model.PostName = name; //model.CurrentApprove = approveName; db.T_MeetingRoom.Add(model); db.SaveChanges(); T_MeetingRoomApprove newApprove = new T_MeetingRoomApprove(); newApprove.ApproveName = model.CurrentApprove; newApprove.PID = model.ID; newApprove.Status = 0; newApprove.Step = 1; db.T_MeetingRoomApprove.Add(newApprove); db.SaveChanges(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } } }
public JsonResult CheckSave(T_MeetingRoomApprove model) { using (TransactionScope sc = new TransactionScope()) { try { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); T_MeetingRoomApprove editModel = db.T_MeetingRoomApprove.Find(model.ID); editModel.Status = model.Status; editModel.ApproveTime = DateTime.Now; editModel.ApproveName = name; editModel.Memo = model.Memo; db.Entry <T_MeetingRoomApprove>(editModel).State = System.Data.Entity.EntityState.Modified; T_MeetingRoom MeetingModel = db.T_MeetingRoom.Find(editModel.PID); if (model.Status == 1) //同意 { int nextStep = editModel.Step + 1; List <T_MeetingRoomConfig> ConfigList = db.T_MeetingRoomConfig.Where(a => a.Step == nextStep).ToList(); if (ConfigList.Count > 0) //下一步 { MeetingModel.Status = 0; MeetingModel.Step = nextStep; MeetingModel.CurrentApprove = ConfigList.First().Name; T_MeetingRoomApprove newApprove = new T_MeetingRoomApprove(); newApprove.ApproveName = ConfigList.First().Name; newApprove.PID = editModel.PID; newApprove.Status = 0; newApprove.Step = nextStep; db.T_MeetingRoomApprove.Add(newApprove); } else //结束 { MeetingModel.Status = 1; MeetingModel.Step = 99; } } else //不同意结束 { MeetingModel.Status = 2; MeetingModel.Step = 99; } db.Entry <T_MeetingRoom>(MeetingModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult ViewEdit(int ID) { T_MeetingRoom model = db.T_MeetingRoom.Find(ID); ViewData["ApproveList"] = getApproveName(1); ViewData["RoomName"] = getMeetingRoomName(); if (model != null) { return(View(model)); } else { return(HttpNotFound()); } }
public JsonResult Delete(int ID) { try { T_MeetingRoom delModel = db.T_MeetingRoom.Find(ID); delModel.IsDelete = 1; db.Entry <T_MeetingRoom>(delModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult EditSave(T_MeetingRoom model) { using (TransactionScope sc = new TransactionScope()) { try { T_MeetingRoom editModel = db.T_MeetingRoom.Find(model.ID); editModel.MeetingRoom = model.MeetingRoom; editModel.StartTime = model.StartTime; editModel.EndTime = model.EndTime; editModel.Host = model.Host; editModel.MeetingTheme = model.MeetingTheme; editModel.Memo = model.Memo; editModel.PeopleNum = model.PeopleNum; editModel.CurrentApprove = model.CurrentApprove; editModel.EndTime = model.EndTime; editModel.StartTime = model.StartTime; if (editModel.Status == 2) { editModel.Status = -1; editModel.Step = 1; T_MeetingRoomApprove newApprove = new T_MeetingRoomApprove(); newApprove.ApproveName = model.CurrentApprove; newApprove.PID = model.ID; newApprove.Status = 0; newApprove.Step = 1; db.T_MeetingRoomApprove.Add(newApprove); } db.SaveChanges(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } } }