From 06e75f18b5b3b0fbfd25731c8b7324cc42df045f Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 07 七月 2021 17:15:30 +0800 Subject: [PATCH] 提交 --- zhengcaioa/Services/AdmPieceCheckService.cs | 17 +++++++++++++++-- 1 files changed, 15 insertions(+), 2 deletions(-) diff --git a/zhengcaioa/Services/AdmPieceCheckService.cs b/zhengcaioa/Services/AdmPieceCheckService.cs index caddbfe..d6f3fca 100644 --- a/zhengcaioa/Services/AdmPieceCheckService.cs +++ b/zhengcaioa/Services/AdmPieceCheckService.cs @@ -136,7 +136,7 @@ from kkk in ksssss.DefaultIfEmpty() join h in _context.HrDepts.Where(x => x.RecStatus == "A" && x.QiyongStatus == "A") - on kkk.DeptId equals h.Id + on a.DeptId equals h.Id into hsss from hhh in hsss.DefaultIfEmpty() @@ -160,7 +160,7 @@ where a.RecStatus == "A" && (string.IsNullOrWhiteSpace(searchEntity.WorkTime) || (a.WorkTime >= WorkTimestart && a.WorkTime <= WorkTimeend)) && (string.IsNullOrWhiteSpace(searchEntity.PayType) || ccc.Pieceratetype == searchEntity.PayType.Trim()) - && (string.IsNullOrWhiteSpace(searchEntity.DeptId) || kkk.DeptId == searchEntity.DeptId.Trim()) + && (string.IsNullOrWhiteSpace(searchEntity.DeptId) || a.DeptId == searchEntity.DeptId.Trim()) && (string.IsNullOrWhiteSpace(searchEntity.UserName) || kkk.UserName.Contains(searchEntity.UserName.Trim())) @@ -231,5 +231,18 @@ return result; } + + public List<AdmPieceCheckDTO> GetList(string userid, DateTime datemin, DateTime datemax) + { + + var entity = _context.AdmPieceChecks.Where(x=> x.RecStatus == "A" && x.UserId == userid && x.WorkTime >= datemin && x.WorkTime < datemax).ToList(); + + + + var result = _mapper.Map<List<AdmPieceCheckDTO>>(entity); + + + return result; + } } } -- Gitblit v1.9.1