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