/// <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 = "该法官工作室在选择的时间上存在冲突,请重新选择时间或者法官工作室";
}
}
