/// <summary> /// 判断调节案件选择的接待室是否时间存在冲突. /// </summary> /// <param name="iLawsId">法庭ID</param> /// <param name="type">添加 true,编辑 false</param> /// <returns></returns> public bool DateCommon(LawyerCase lawyercase, bool type) { using (var db = new Entities()) { var res = false; if (type) { res = db.LawyerCase. Any(m => m.iLawyerRoomId == lawyercase.iLawyerRoomId && m.dAclEndTime == null && ( (lawyercase.dPreStaTime <= m.dPreStaTime && lawyercase.dPreEndTime >= m.dPreStaTime) || //第一种情况 (lawyercase.dPreStaTime >= m.dPreStaTime && lawyercase.dPreEndTime <= m.dPreEndTime) || //第二种情况 (lawyercase.dPreStaTime >= m.dPreStaTime && lawyercase.dPreEndTime >= m.dPreEndTime && lawyercase.dPreStaTime < m.dPreEndTime) || //第三种情况 (lawyercase.dPreStaTime <= m.dPreStaTime && lawyercase.dPreEndTime >= m.dPreEndTime))); //第四种情况 } else { res = db.LawyerCase. Any(m => m.iLawyerRoomId == lawyercase.iLawyerRoomId && m.dAclEndTime == null && m.ID != lawyercase.ID && ( (lawyercase.dPreStaTime <= m.dPreStaTime && lawyercase.dPreEndTime >= m.dPreStaTime) || //第一种情况 (lawyercase.dPreStaTime >= m.dPreStaTime && lawyercase.dPreEndTime <= m.dPreEndTime) || //第二种情况 (lawyercase.dPreStaTime >= m.dPreStaTime && lawyercase.dPreEndTime >= m.dPreEndTime && lawyercase.dPreStaTime < m.dPreEndTime) || //第三种情况 (lawyercase.dPreStaTime <= m.dPreStaTime && lawyercase.dPreEndTime >= m.dPreEndTime))); //第四种情况 } return(res); } }
/// <summary> /// 添加律师案件 /// </summary> /// <param name="lawyercase"></param> /// <returns></returns> public int Add(LawyerCase lawyercase) { using (var db = new Entities()) { var lawyerroom = db.LawyerRoom.Find(lawyercase.iLawyerRoomId); lawyercase.iRoomOrder = lawyerroom.iRoomOrder; db.LawyerCase.Add(lawyercase); return(db.SaveChanges()); } }
/// <summary> /// 编辑律师案件 /// </summary> /// <param name="lawyercase"></param> /// <returns></returns> public int Edit(LawyerCase lawyercase) { using (var db = new Entities()) { var lawyerroom = db.LawyerRoom.Find(lawyercase.iLawyerRoomId); lawyercase.iRoomOrder = lawyerroom.iRoomOrder; db.Entry <LawyerCase>(lawyercase).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } }
public void Insert(LawyerCase lawyerCase, string RealName) { var lawyer = Resolve <LawyerManage>().Get(lawyerCase.iLawyerId); if (lawyer.sLawyerName == RealName) { if (!manage.DateCommon(lawyerCase, true)) { if (manage.Add(lawyerCase) > 0) { result.success = true; } } else { result.info = "该接待室在选择的时间上存在冲突,请重新选择时间或者接待室"; } } else { result.info = string.Format("{0}律师不存在,请重新选择!", RealName); } }