/// <summary>
/// 获取过去七天迟到早退情况
/// </summary>
/// <param name="SchoolID"></param>
/// <returns></returns>
public static object GetNotifyStateByTime(int SchoolID)
{
using (NotifyService notifyService = new NotifyService()) {
DateTime dt = DateTime.Now;
ArrayList myArray = new ArrayList();
ArrayList Late = new ArrayList(); //迟到
ArrayList LeaveEarly = new ArrayList(); //早退
ArrayList Normal = new ArrayList(); //正常
for (int i = -12; i < 0; i++)
{
var month = dt.AddMonths(i).Month;
myArray.Add(month);
var notify = notifyService.GetAll(m => m.IsDelete == false && m.SchoolID == SchoolID && m.CreatTime.Month == month);
Late.Add(notify.Where(m => m.State == "迟到").Count());
LeaveEarly.Add(notify.Where(m => m.State == "早退").Count());
Normal.Add(notify.Where(m => m.State == "正常").Count());
}
object obj = new {
DateArr = myArray,
Late,
LeaveEarly,
Normal
};
return(obj);
}
}
public static int GetNotifyCount()
{
try {
using (var notifyService = new NotifyService()) {
return(notifyService.GetAll().Count());
};
}
catch (Exception) {
throw;
}
}
/// <summary>
/// 分页查询进出记录
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SchoolID"></param>
/// <returns></returns>
public static List <Models.EnterAndLeave> GetNotify(int PageSize, int PageIndex, int SchoolID)
{
try {
using (var notifyService = new NotifyService()) {
return(notifyService.GetAll(m => m.SchoolID == SchoolID, false, PageSize, PageIndex).ToList());
};
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
}
/// <summary>
/// 分页查询进出记录
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SchoolID"></param>
/// <returns></returns>
public static List <Models.EnterAndLeave> GetNotifyBySchoolName(string SchoolName, string PageIndex = null, string PageSize = null)
{
try {
using (var notifyService = new NotifyService()) {
var SchoolResult = SchoolManager.QuerySchool(SchoolName);
if (SchoolResult == null)
{
throw new Exception("不存在此学校");
}
if (PageIndex == null)
{
return(notifyService.GetAll(m => m.SchoolID == SchoolResult.Id).ToList());
}
return(notifyService.GetAll(m => m.SchoolID == SchoolResult.Id, false, Convert.ToInt32(PageSize), Convert.ToInt32(PageIndex)).ToList());
};
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
}
/// <summary>
/// 获取过去七天的通行记录
/// </summary>
public static object GetNotifyByTime(int SchoolID)
{
using (NotifyService notifyService = new NotifyService()) {
DateTime dt = DateTime.Now;
ArrayList myArray = new ArrayList(); //存放日期
List <int> InOutType = new List <int>(); //存放日期对应的数据
for (int i = -7; i < 0; i++)
{
var day = dt.AddDays(i).Day;
myArray.Add(day);
var notifyCount = notifyService.GetAll(m => m.IsDelete == false && m.SchoolID == SchoolID && m.CreatTime.Day == day).Count();
InOutType.Add(notifyCount);
}
object obj = new {
DateArr = myArray,
InOutType
};
return(obj);
}
}
/// <summary>
/// 通过名字查询进出记录
/// </summary>
/// <param name="Name"></param>
/// <param name="SchoolID"></param>
/// <returns></returns>
public static List <Models.EnterAndLeave> GetNotifyByName(int SchoolID, string Name = null, string StartTime = null, string EndTime = null)
{
try {
using (var notifyService = new NotifyService()) {
var result = notifyService.GetAll(m => m.SchoolID == SchoolID).ToList();
if (StartTime != null && EndTime != null)
{
result = result.Where(m => DateTime.Parse(m.Time) >= DateTime.Parse(StartTime) && DateTime.Parse(m.Time) <= DateTime.Parse(EndTime)).ToList();
}
if (Name != null)
{
result = result.Where(m => m.FaceName == Name).ToList();
}
return(result);
};
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
}