using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EMIS.DataLogic.Common.CalendarManage;
using Bowin.Common.Linq.Entity;
using EMIS.Entities;
using EMIS.ViewModel;
using System.Linq.Expressions;
using EMIS.ViewModel.CalendarManage;
namespace EMIS.CommonLogic.CalendarManage
{
public class DutyServices : BaseServices, IDutyServices
{
public DutyDAL dutyDAL { get; set; }
/// <summary>
/// 查询值班管理信息
/// </summary>
/// <param name="configuretView">查询条件实体</param>
/// <param name="departmentID">负责部门/科室</param>
/// <param name="campusID">校区ID</param>
/// <param name="collegeID">学院ID</param>
/// <param name="timesSegment">时间段</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">显示页数</param>
/// <returns></returns>
public IGridResultSet<DutyView> GetDutyViewGrid(ConfiguretView configuretView, Guid? campusID, Guid? collegeID, Guid? departmentID, int? timesSegment, int pageIndex, int pageSize)
{
var query = dutyDAL.GetDutyQueryable(x => true);
if (campusID.HasValue && campusID != Guid.Empty)
query = query.Where(x => x.CampusID == campusID);
if (collegeID.HasValue && collegeID != Guid.Empty)
query = query.Where(x => x.CollegeID == collegeID);
if (departmentID.HasValue && departmentID != Guid.Empty)
query = query.Where(x => x.DepartmentID == departmentID);
if (timesSegment.HasValue && timesSegment != -1)
query = query.Where(x => x.TimesSegment == timesSegment);
if (!string.IsNullOrEmpty(configuretView.ConditionValue))
return query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue)
.OrderBy(x => x.DutyTime).ThenBy(x => x.TimesSegment).ToGridResultSet<DutyView>(pageIndex, pageSize);
return query.OrderBy(x => x.DutyTime).ThenBy(x => x.TimesSegment).ToGridResultSet<DutyView>(pageIndex, pageSize);
}
/// <summary>
/// 查询值班管理信息
/// </summary>
/// <param name="configuretView">查询条件实体</param>
/// <param name="departmentID">负责部门/科室</param>
/// <param name="timesSegment">时间段</param>
/// <returns></returns>
public List<DutyView> GetDutyViewList(ConfiguretView configuretView, Guid? campusID, Guid? collegeID, Guid? departmentID, int? timesSegment)
{
var query = dutyDAL.GetDutyQueryable(x => true);
if (campusID.HasValue && campusID != Guid.Empty)
query = query.Where(x => x.CampusID == campusID);
if (collegeID.HasValue && collegeID != Guid.Empty)
query = query.Where(x => x.CollegeID == collegeID);
if (departmentID.HasValue && departmentID != Guid.Empty)
query = query.Where(x => x.DepartmentID == departmentID);
if (timesSegment.HasValue && timesSegment != -1)
query = query.Where(x => x.TimesSegment == timesSegment);
if (!string.IsNullOrEmpty(configuretView.ConditionValue))
return query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue)
.OrderBy(x => x.DutyTime).ThenBy(x => x.TimesSegment).ToList();
return query.OrderBy(x => x.DutyTime).ThenBy(x => x.TimesSegment).ToList();
}
/// <summary>
/// 获取值班管理信息
/// </summary>
/// <param name="dutyID">主键ID</param>
/// <returns></returns>
public EM_duty GetDuty(Guid? dutyID)
{
//查询条件
Expression<Func<EM_duty, bool>> expression = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
expression = (x => x.DutyID == dutyID);
return dutyDAL.dutyRepository.GetSingle(expression);
}
/// <summary>
/// 获取值班管理信息
/// </summary>
/// <param name="userID">值班人ID</param>
/// <param name="dutyTime">值班日期</param>
/// <param name="timesSegment">时间段</param>
/// <param name="departmentID">负责部门/科室</param>
/// <returns></returns>
public EM_duty GetDuty(Guid userID, DateTime dutyTime, int timesSegment, Guid departmentID)
{
//查询条件
Expression<Func<EM_duty, bool>> expression = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
expression = (x => x.UserID == userID && x.DutyTime == dutyTime && x.TimesSegment == timesSegment && x.DepartmentID == departmentID);
return dutyDAL.dutyRepository.GetSingle(expression);
}
/// <summary>
/// 获取值班管理信息
/// </summary>
/// <param name="dutyID">主键ID</param>
/// <returns></returns>
public DutyView GetDutyView(Guid? dutyID)
{
DutyView dutyView = new DutyView();
if (dutyID.HasValue)
dutyView = dutyDAL.GetDutyQueryable(x => true).Where(x => x.DutyID == dutyID).FirstOrDefault();
return dutyView;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="duty">实体</param>
/// <returns></returns>
public bool DutyAdd(DutyView dutyView)
{
try
{
if (this.dutyDAL.dutyRepository
.GetList(x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE
&& x.UserID == dutyView.UserID && x.DutyTime == dutyView.DutyTime &&
x.TimesSegment == dutyView.TimesSegment && x.DepartmentID == dutyView.DepartmentID).Count() > 0)
{
throw new Exception("值班人、值班日期、时间段、教研室必须唯一，请重新输入！");
}
EM_duty duty = new EM_duty();
duty.DutyID = Guid.NewGuid();
duty.UserID = dutyView.UserID.Value;
duty.TimesSegment = dutyView.TimesSegment.Value;
duty.DutyTime = dutyView.DutyTime;
duty.StartHour = dutyView.StartHour;
duty.StartMinutes = dutyView.StartMinutes;
duty.EndHour = dutyView.EndHour;
duty.EndMinutes = dutyView.EndMinutes;
duty.Description = dutyView.Description;
duty.DepartmentID = dutyView.DepartmentID;
this.SetNewStatus(duty);
UnitOfWork.Add(duty);
UnitOfWork.Commit();
return true;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="duty">实体</param>
/// <returns></returns>
public bool DutyUpdate(DutyView dutyView)
{
try
{
if (this.dutyDAL.dutyRepository
.GetList(x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE
&& x.UserID == dutyView.UserID && x.DutyTime == dutyView.DutyTime &&
x.TimesSegment == dutyView.TimesSegment && x.DepartmentID == dutyView.DepartmentID
&& x.DutyID != dutyView.DutyID).Count() > 0)
{
throw new Exception("值班人、值班日期、时间段、教研室必须唯一，请重新输入！");
}
var duty = GetDuty(dutyView.DutyID);
if (duty == null)
{
throw new Exception("保存失败，未能找到相对应的数据！");
}
duty.UserID = dutyView.UserID.Value;
duty.TimesSegment = dutyView.TimesSegment.Value;
duty.DutyTime = dutyView.DutyTime;
duty.StartHour = dutyView.StartHour;
duty.StartMinutes = dutyView.StartMinutes;
duty.EndHour = dutyView.EndHour;
duty.EndMinutes = dutyView.EndMinutes;
duty.Description = dutyView.Description;
duty.DepartmentID = dutyView.DepartmentID;
this.SetModifyStatus(duty);
UnitOfWork.Commit();
return true;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="dutyIDs"></param>
/// <returns></returns>
public bool DutyDelete(List<Guid> dutyIDs)
{
try
{
UnitOfWork.Delete<EM_duty>(x => dutyIDs.Contains(x.DutyID));
UnitOfWork.Commit();
return true;
}
catch (Exception)
{
throw;
}
}
}
}