/// <summary> /// 判断调节案件选择的调解室是否时间存在冲突. /// </summary> /// <param name="iLawsId">法庭ID</param> /// <param name="type">添加 true,编辑 false</param> /// <returns></returns> public bool DateCommon(TjCase tjcase, bool type) { using (var db = new Entities()) { var res = false; if (type) { res = db.TjCase. Any(m => m.iTjRoomId == tjcase.iTjRoomId && m.dAclEndTime == null && ( (tjcase.dPreStaTime <= m.dPreStaTime && tjcase.dPreEndTime >= m.dPreStaTime) || //第一种情况 (tjcase.dPreStaTime >= m.dPreStaTime && tjcase.dPreEndTime <= m.dPreEndTime) || //第二种情况 (tjcase.dPreStaTime >= m.dPreStaTime && tjcase.dPreEndTime >= m.dPreEndTime && tjcase.dPreStaTime < m.dPreEndTime) || //第三种情况 (tjcase.dPreStaTime <= m.dPreStaTime && tjcase.dPreEndTime >= m.dPreEndTime))); //第四种情况 } else { res = db.TjCase. Any(m => m.iTjRoomId == tjcase.iTjRoomId && m.dAclEndTime == null && m.ID != tjcase.ID && ( (tjcase.dPreStaTime <= m.dPreStaTime && tjcase.dPreEndTime >= m.dPreStaTime) || //第一种情况 (tjcase.dPreStaTime >= m.dPreStaTime && tjcase.dPreEndTime <= m.dPreEndTime) || //第二种情况 (tjcase.dPreStaTime >= m.dPreStaTime && tjcase.dPreEndTime >= m.dPreEndTime && tjcase.dPreStaTime < m.dPreEndTime) || //第三种情况 (tjcase.dPreStaTime <= m.dPreStaTime && tjcase.dPreEndTime >= m.dPreEndTime))); //第四种情况 } return(res); } }
/// <summary> /// 编辑调解案件 /// </summary> /// <param name="tjcase"></param> /// <returns></returns> public int Edit(TjCase tjcase) { using (var db = new Entities()) { var tjroom = db.Tj_Room.Find(tjcase.iTjRoomId); tjcase.RoomOrder = tjroom.RoomOrder.Value; db.Entry <TjCase>(tjcase).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 添加调解案件 /// </summary> /// <param name="tjcase"></param> /// <returns></returns> public int Add(TjCase tjcase) { using (var db = new Entities()) { var tjroom = db.Tj_Room.Find(tjcase.iTjRoomId); tjcase.RoomOrder = tjroom.RoomOrder.Value; tjcase.dInsertTime = DateTime.Now; db.TjCase.Add(tjcase); return(db.SaveChanges()); } }
public void Insert(TjCase tjcase, string RealName) { var user = Resolve <UserManage>().Get(tjcase.iUserId); if (user.RealName == RealName) { if (!manage.DateCommon(tjcase, true)) { if (manage.Add(tjcase) > 0) { result.success = true; } } else { result.info = "该调解室在选择的时间上存在冲突,请重新选择时间或者法庭"; } } else { result.info = string.Format("{0}调解员不存在,请重新选择!", RealName); } }