/// <summary> /// 判断法官案件选择的调解室是否时间存在冲突. /// </summary> /// <param name="iLawsId">法官ID</param> /// <param name="type">添加 true,编辑 false</param> /// <returns></returns> public bool DateCommon(JudgeStudioCase judsCase, bool type) { using (var db = new Entities()) { var res = false; if (type) { res = db.JudgeStudioCase. Any(m => m.iJudgeStudioId == judsCase.iJudgeStudioId && m.dAclEndTime == null && ( (judsCase.dPreStaTime <= m.dPreStaTime && judsCase.dPreEndTime >= m.dPreStaTime) || //第一种情况 (judsCase.dPreStaTime >= m.dPreStaTime && judsCase.dPreEndTime <= m.dPreEndTime) || //第二种情况 (judsCase.dPreStaTime >= m.dPreStaTime && judsCase.dPreEndTime >= m.dPreEndTime && judsCase.dPreStaTime < m.dPreEndTime) || //第三种情况 (judsCase.dPreStaTime <= m.dPreStaTime && judsCase.dPreEndTime >= m.dPreEndTime))); //第四种情况 } else { res = db.JudgeStudioCase. Any(m => m.iJudgeStudioId == judsCase.iJudgeStudioId && m.dAclEndTime == null && m.ID != judsCase.ID && ( (judsCase.dPreStaTime <= m.dPreStaTime && judsCase.dPreEndTime >= m.dPreStaTime) || //第一种情况 (judsCase.dPreStaTime >= m.dPreStaTime && judsCase.dPreEndTime <= m.dPreEndTime) || //第二种情况 (judsCase.dPreStaTime >= m.dPreStaTime && judsCase.dPreEndTime >= m.dPreEndTime && judsCase.dPreStaTime < m.dPreEndTime) || //第三种情况 (judsCase.dPreStaTime <= m.dPreStaTime && judsCase.dPreEndTime >= m.dPreEndTime))); //第四种情况 } return(res); } }
/// <summary> /// 编辑法官案件 /// </summary> /// <param name="judsCase"></param> /// <returns></returns> public int Edit(JudgeStudioCase judsCase) { using (var db = new Entities()) { var juds = db.JudgeStudio.Find(judsCase.iJudgeStudioId); judsCase.iRoomOrder = juds.iRoomOrder; db.Entry <JudgeStudioCase>(judsCase).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 添加法官案件 /// </summary> /// <param name="lawsCase"></param> /// <returns></returns> public int Add(JudgeStudioCase judsCase) { using (var db = new Entities()) { var juds = db.JudgeStudio.Find(judsCase.iJudgeStudioId); judsCase.iRoomOrder = juds.iRoomOrder; db.JudgeStudioCase.Add(judsCase); return(db.SaveChanges()); } }
public void Update(JudgeStudioCase judsCase, string RealName) { if (!manage.DateCommon(judsCase, false)) { if (manage.Edit(judsCase) > 0) { result.success = true; } } else { result.info = "该法官工作室在选择的时间上存在冲突,请重新选择时间或者法官工作室"; } }
public void Insert(JudgeStudioCase judsCase) { if (!manage.DateCommon(judsCase, true)) { if (manage.Add(judsCase) > 0) { result.success = true; } } else { result.info = "该法官工作室在选择的时间上存在冲突,请重新选择时间或者法官工作室"; } }