From f33ece65bdfd7b8354bd5046d4b9d2d600643b0f Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期六, 09 十月 2021 13:24:51 +0800 Subject: [PATCH] tijiao --- zhengcaioa/Services/AdmSigninService.cs | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 52 insertions(+), 2 deletions(-) diff --git a/zhengcaioa/Services/AdmSigninService.cs b/zhengcaioa/Services/AdmSigninService.cs index 6c628cc..bb73473 100644 --- a/zhengcaioa/Services/AdmSigninService.cs +++ b/zhengcaioa/Services/AdmSigninService.cs @@ -85,6 +85,20 @@ 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(); @@ -209,7 +223,7 @@ Afternoon = virtity(a.AfternoonIn, a.AfternoonOut), Overtime = virtity(a.OvertimeIn, a.OvertimeOut) }).ToList(); - if (searchEntity.totalrows == 0) + //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); @@ -345,7 +359,43 @@ 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(); -- Gitblit v1.9.1