From 1c4f3bce3d88557b7ddb5f0a49b4be5e91b416f1 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期四, 14 十月 2021 13:42:33 +0800 Subject: [PATCH] 专家测试--题库管理 --- zhengcaioa/Services/AdmSigninService.cs | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 53 insertions(+), 2 deletions(-) diff --git a/zhengcaioa/Services/AdmSigninService.cs b/zhengcaioa/Services/AdmSigninService.cs index 59502a8..bb73473 100644 --- a/zhengcaioa/Services/AdmSigninService.cs +++ b/zhengcaioa/Services/AdmSigninService.cs @@ -20,6 +20,7 @@ } #region 鑰冨嫟鎵撳崱 + public ResultEntity save(string id, int signinType) { ResultEntity resultEntity = new ResultEntity(); @@ -83,6 +84,20 @@ 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) { @@ -208,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); @@ -344,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