using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using zhengcaioa.Models;
|
using IServices;
|
using AutoMapper;
|
using DTO;
|
using System.Linq;
|
|
namespace Services
|
{
|
public class AdmSigninService : IAdmSigninService
|
{
|
private readonly zhengcaioaContext _context;
|
private readonly IMapper _mapper;
|
public AdmSigninService(zhengcaioaContext context, IMapper mapper)
|
{
|
_context = context;
|
_mapper = mapper;
|
}
|
|
#region 考勤打卡
|
|
public ResultEntity save(string id, int signinType)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
AdmSignIn signIn = _context.AdmSignIns.Where(e => e.Id == id).FirstOrDefault();
|
|
if (string.IsNullOrEmpty(signIn.Id))
|
{
|
signIn.Id = Guid.NewGuid().ToString();
|
_context.AdmSignIns.Add(signIn);
|
}
|
else
|
{
|
switch (signinType)
|
{
|
case 10:
|
if (signIn.MorningIn.HasValue)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "已经打上午上班，请不要重复打卡";
|
return resultEntity;
|
}
|
signIn.MorningIn = DateTime.Now;
|
break;
|
case 11:
|
signIn.MorningOut = DateTime.Now;
|
break;
|
|
case 20:
|
if (signIn.AfternoonIn.HasValue)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "已经打下午上班卡，请不要重复打卡";
|
return resultEntity;
|
}
|
signIn.AfternoonIn = DateTime.Now;
|
break;
|
case 21:
|
signIn.AfternoonOut = DateTime.Now;
|
break;
|
case 30:
|
if (signIn.AfternoonIn.HasValue)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "已经打加班卡，请不要重复打卡";
|
return resultEntity;
|
}
|
signIn.OvertimeIn = DateTime.Now;
|
break;
|
case 31:
|
signIn.OvertimeOut = DateTime.Now;
|
break;
|
|
|
}
|
|
}
|
_context.SaveChanges();
|
resultEntity.ReturnID = signIn.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
ex.Message.ToString();
|
}
|
return resultEntity;
|
}
|
|
public AdmSignInDTO Get(string id)
|
{
|
AdmSignIn entity = _context.AdmSignIns.Find(id);
|
if (entity.RecStatus != "A")
|
{
|
entity = new AdmSignIn();
|
}
|
AdmSignInDTO signin = _mapper.Map<AdmSignInDTO>(entity);
|
return signin;
|
}
|
|
public AdmSignInDTO GetByUserAndDate(string userid, DateTime sgninDate)
|
{
|
AdmSignIn entity = _context.AdmSignIns.Where(x=>x.RecStatus == "A" && x.UserId == userid && x.SgninDate == sgninDate).FirstOrDefault();
|
AdmSignInDTO signin = null;
|
if (entity != null)
|
{
|
signin = _mapper.Map<AdmSignInDTO>(entity);
|
}
|
|
return signin;
|
}
|
|
|
|
public AdmSignInDTO GetTodaySignin(string userId)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
AdmSignInDTO signin = null;
|
try
|
{
|
AdmSignIn entity = _context.AdmSignIns.Where(e => e.UserId == userId && e.SgninDate.Date == DateTime.Now.Date).FirstOrDefault();
|
|
if (entity == null || entity.RecStatus != "A")
|
{
|
entity = new AdmSignIn();
|
}
|
if (string.IsNullOrEmpty(entity.Id))
|
{
|
entity.Id = Guid.NewGuid().ToString();
|
entity.UserId = userId;
|
entity.Creater = userId;
|
entity.Modifier = userId;
|
entity.RecStatus = "A";
|
entity.Createtime = DateTime.Now;
|
entity.Modifytime = DateTime.Now;
|
entity.SgninDate = DateTime.Now.Date;//Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
|
_context.AdmSignIns.Add(entity);
|
_context.SaveChanges();
|
}
|
signin = _mapper.Map<AdmSignInDTO>(entity);
|
resultEntity.ReturnID = entity.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
ex.Message.ToString();
|
}
|
|
return signin;
|
}
|
public ResultDataEntity<SigninListDTO> SearchByPaging(AdmSignInDTOSearch searchEntity)
|
{
|
//生成单月的考勤记录
|
int days = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month);
|
DateTime today;
|
var monthlist = _context.AdmSignIns.Where(e => e.UserId == searchEntity.userId && e.SgninDate.Date == DateTime.Now.Date && e.RecStatus == "A").ToList();
|
if (monthlist.Count < days)
|
{
|
for (int i = 1; i <= days; i++)
|
{
|
today = Convert.ToDateTime(string.Format("{0}-{1}-{2}", DateTime.Now.Year, DateTime.Now.Month, i.ToString().PadLeft(2, '0')));
|
monthlist = _context.AdmSignIns.Where(e => e.UserId == searchEntity.userId && e.RecStatus == "A" && e.SgninDate.Date == today.Date).ToList();
|
if (monthlist.Count == 0)
|
{
|
AdmSignInDTO signinDTO = new AdmSignInDTO();
|
AdmSignIn signIn = _mapper.Map<AdmSignIn>(signinDTO);
|
if (string.IsNullOrEmpty(signIn.Id))
|
{
|
signIn.Id = Guid.NewGuid().ToString();
|
|
signIn.UserId = searchEntity.userId;
|
signIn.Creater = searchEntity.userId;
|
signIn.Modifier = searchEntity.userId;
|
signIn.RecStatus = "A";
|
signIn.Createtime = DateTime.Now;
|
signIn.Modifytime = DateTime.Now;
|
signIn.SgninDate = today.Date;
|
_context.AdmSignIns.Add(signIn);
|
_context.SaveChanges();
|
}
|
|
}
|
}
|
|
}
|
|
ResultDataEntity<SigninListDTO> data = new ResultDataEntity<SigninListDTO>();
|
List<SigninListDTO> list = new List<SigninListDTO>();
|
//筛选
|
var query = _context.AdmSignIns
|
.Where(b => b.RecStatus == "A" && b.UserId == searchEntity.userId)
|
.ToList();
|
|
if (searchEntity.Year > 0)
|
{
|
DateTime startDate = DateTime.Now;
|
DateTime endDate = DateTime.Now;
|
if (searchEntity.Month == 0) //全部
|
{
|
startDate = Convert.ToDateTime(string.Format("{0}-1-1", searchEntity.Year));
|
endDate = Convert.ToDateTime(string.Format("{0}-12-31", searchEntity.Year));
|
|
}
|
else //选择月份
|
{
|
startDate = Convert.ToDateTime(string.Format("{0}-{1}-1",
|
searchEntity.Year,
|
searchEntity.Month));
|
endDate = Convert.ToDateTime(string.Format("{0}-{1}-{2}",
|
searchEntity.Year,
|
searchEntity.Month,
|
DateTime.DaysInMonth(searchEntity.Year, searchEntity.Month)
|
));
|
|
}
|
query = query.Where(b => b.SgninDate >= startDate && b.SgninDate <= endDate)
|
.ToList();
|
}
|
|
var dt = (from a in query
|
join b in _context.PltUsers.Where(e => e.RecStatus == "A")
|
on a.UserId equals b.Id
|
join c in _context.HrDepts.Where(e => e.RecStatus == "A")
|
on b.DeptId equals c.Id
|
orderby a.SgninDate ascending
|
select new SigninListDTO
|
{
|
Id = a.Id,
|
UserId = a.UserId,
|
UserName = b.UserName,
|
DeptName = c.DeptName,
|
SgninDate = a.SgninDate.ToString("yyyy-MM-dd"),
|
Morning = virtity(a.MorningIn, a.MorningOut),
|
Afternoon = virtity(a.AfternoonIn, a.AfternoonOut),
|
Overtime = virtity(a.OvertimeIn, a.OvertimeOut)
|
}).ToList();
|
//if (searchEntity.totalrows == 0)
|
searchEntity.totalrows = dt.Count();
|
var signinList = dt.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
|
list = _mapper.Map<List<SigninListDTO>>(signinList);
|
|
data.LoadData(searchEntity, list);
|
return data;
|
|
}
|
|
|
|
public ResultEntity ModifyStatus(string id, string userid)
|
{
|
return null;
|
}
|
|
private static string virtity(DateTime? time1, DateTime? time2)
|
{
|
string t1 = " ", t2 = " ";
|
if (time1 != null)
|
{
|
t1 = Convert.ToDateTime(time1).ToString("HH:mm:ss");
|
}
|
if (time2 != null)
|
{
|
t2 = Convert.ToDateTime(time2).ToString("HH:mm:ss");
|
}
|
|
return t1 + " - " + t2;
|
}
|
#endregion
|
|
#region 请假与销假
|
public ResultEntity SaveAskLeave(AdmAskLeaveDTO admAsk)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
AdmAskLeave ask = _mapper.Map<AdmAskLeave>(admAsk);
|
if (string.IsNullOrEmpty(admAsk.Id))
|
{
|
ask.Id = Guid.NewGuid().ToString();
|
admAsk.Id = ask.Id;
|
_context.AdmAskLeaves.Add(ask);
|
}
|
else
|
{
|
var entity = _context.AdmAskLeaves.Find(admAsk.Id);
|
|
entity.SigninId = admAsk.SigninId;
|
entity.StratPoint = admAsk.StratPoint;
|
entity.EndPoint = admAsk.EndPoint;
|
entity.ShenpiStatus = admAsk.ShenpiStatus;
|
entity.CreaterName = admAsk.CreaterName;
|
entity.Tittle = admAsk.Tittle;
|
|
entity.LaveDay = admAsk.LaveDay;
|
entity.LavehHour = admAsk.LavehHour;
|
entity.Remark = admAsk.Remark;
|
entity.Lavetype = admAsk.Lavetype;
|
entity.StratTime = admAsk.StratTime;
|
entity.EndTime = admAsk.EndTime;
|
entity.Modifier = admAsk.Modifier;
|
entity.Modifytime = DateTime.Now;
|
}
|
_context.SaveChanges();
|
resultEntity.ReturnID = ask.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
ex.Message.ToString();
|
}
|
|
return resultEntity;
|
}
|
|
public ResultEntity SaveAskLeaveOff(AdmAskLeaveOffDTO leaveOff)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
AdmAskLeaveOff askLeaveOff = _mapper.Map<AdmAskLeaveOff>(leaveOff);
|
if (string.IsNullOrEmpty(leaveOff.Id))
|
{
|
askLeaveOff.Id = Guid.NewGuid().ToString();
|
leaveOff.Id = askLeaveOff.Id;
|
_context.AdmAskLeaveOffs.Add(askLeaveOff);
|
}
|
else
|
{
|
var entity = _context.AdmAskLeaveOffs.Find(leaveOff.Id);
|
|
entity.SigninId = leaveOff.SigninId;
|
entity.StratPoint = leaveOff.StratPoint;
|
entity.EndPoint = leaveOff.EndPoint;
|
entity.ShenpiStatus = leaveOff.ShenpiStatus;
|
entity.CreaterName = leaveOff.CreaterName;
|
entity.Tittle = leaveOff.Tittle;
|
|
entity.MedicalRecord = leaveOff.MedicalRecord;
|
entity.Remark = leaveOff.Remark;
|
entity.Lavetype = leaveOff.Lavetype;
|
entity.StratTime = leaveOff.StratTime;
|
entity.EndTime = leaveOff.EndTime;
|
entity.Modifier = leaveOff.Modifier;
|
entity.Modifytime = DateTime.Now;
|
}
|
_context.SaveChanges();
|
resultEntity.ReturnID = askLeaveOff.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
ex.Message.ToString();
|
}
|
|
return resultEntity;
|
}
|
|
public AdmAskLeaveDTO GetAskLeave(string Id)
|
{
|
AdmAskLeave entity = _context.AdmAskLeaves.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
|
if (entity == null)
|
{
|
entity = new AdmAskLeave();
|
}
|
AdmAskLeaveDTO leaveDTO = _mapper.Map<AdmAskLeaveDTO>(entity);
|
return leaveDTO;
|
|
}
|
|
public List<AdmAskLeaveDTO> GetAskLeaveByUserId(string UserId)
|
{
|
List<AdmAskLeave> admAskLeaveDTOs = _context.AdmAskLeaves.Where(e => e.RecStatus == "A" && e.ShenpiStatus == "A" && e.Creater == UserId).ToList();
|
|
List<AdmAskLeaveDTO> leaveDTOs = _mapper.Map< List <AdmAskLeaveDTO> >(admAskLeaveDTOs);
|
return leaveDTOs;
|
|
}
|
|
public List<AdmAskLeaveDTO> GetAskLeaveChongdie(string UserId, DateTime StratTime, DateTime EndTime)
|
{
|
List<AdmAskLeave> admAskLeaveDTOs = _context.AdmAskLeaves.Where(e => e.RecStatus == "A" && e.Creater == UserId && (( e.StratTime <= StratTime && e.EndTime > StratTime) || (e.StratTime < EndTime && e.EndTime >= EndTime) )).ToList();
|
|
List<AdmAskLeaveDTO> leaveDTOs = _mapper.Map<List<AdmAskLeaveDTO>>(admAskLeaveDTOs);
|
return leaveDTOs;
|
|
}
|
|
public List<AdmAskLeaveOffDTO> GetAskLeaveOffByUserId(string UserId)
|
{
|
List<AdmAskLeaveOff> admAskLeaveOffs = _context.AdmAskLeaveOffs.Where(e => e.RecStatus == "A" && e.ShenpiStatus == "A" && e.Creater == UserId).ToList();
|
|
List<AdmAskLeaveOffDTO> leaveDTOs = _mapper.Map<List<AdmAskLeaveOffDTO>>(admAskLeaveOffs);
|
return leaveDTOs;
|
|
}
|
|
public List<AdmAskLeaveOffDTO> GetAskLeaveOffChongdie(string UserId, DateTime StratTime, DateTime EndTime)
|
{
|
List<AdmAskLeaveOff> admAskLeaveOffs = _context.AdmAskLeaveOffs.Where(e => e.RecStatus == "A" && e.Creater == UserId && ((e.StratTime <= StratTime && e.EndTime > StratTime) || (e.StratTime < EndTime && e.EndTime >= EndTime))).ToList();
|
|
List<AdmAskLeaveOffDTO> leaveDTOs = _mapper.Map<List<AdmAskLeaveOffDTO>>(admAskLeaveOffs);
|
return leaveDTOs;
|
|
}
|
|
public AdmAskLeaveOffDTO GetAskLeaveOff(string Id)
|
{
|
AdmAskLeaveOff entity = _context.AdmAskLeaveOffs.Where(e => e.RecStatus == "A" && e.Id == Id ).FirstOrDefault();
|
if (entity == null)
|
{
|
entity = new AdmAskLeaveOff();
|
}
|
AdmAskLeaveOffDTO leaveOffDTO = _mapper.Map<AdmAskLeaveOffDTO>(entity);
|
return leaveOffDTO;
|
|
}
|
#endregion
|
|
#region 考勤规则
|
|
public ResultEntity SaveAttendanceRlues(string attRlues)
|
{
|
return null;
|
}
|
public string GetAttendanceRlues()
|
{
|
return "";
|
}
|
|
#endregion
|
|
}
|
|
}
|
