/// <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);
}
}
