From efad4f05e52c89f3b42774e313144abd039370e4 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 10 二月 2023 11:26:06 +0800 Subject: [PATCH] 考勤怎么加带薪假的计算 --- zhengcaioa/Services/AdmAttendanceDtlService.cs | 96 +++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 90 insertions(+), 6 deletions(-) diff --git a/zhengcaioa/Services/AdmAttendanceDtlService.cs b/zhengcaioa/Services/AdmAttendanceDtlService.cs index 63f1cc4..221bf05 100644 --- a/zhengcaioa/Services/AdmAttendanceDtlService.cs +++ b/zhengcaioa/Services/AdmAttendanceDtlService.cs @@ -52,9 +52,13 @@ updatepltRole.Createtime = AdmAttendanceDtl.Createtime; updatepltRole.Modifier = AdmAttendanceDtl.Modifier; updatepltRole.Modifytime = AdmAttendanceDtl.Modifytime; - updatepltRole.Chidaofenzhong = AdmAttendanceDtl.Chidaofenzhong; - updatepltRole.Zaotuifenzhong = AdmAttendanceDtl.Zaotuifenzhong; + updatepltRole.Shangwuchidaofenzhong = AdmAttendanceDtl.Shangwuchidaofenzhong; + updatepltRole.Xiawuchidaofenzhong = AdmAttendanceDtl.Xiawuchidaofenzhong; + updatepltRole.Shangwuzaotuifenzhong = AdmAttendanceDtl.Shangwuzaotuifenzhong; + updatepltRole.Xiawuzaotuifenzhong = AdmAttendanceDtl.Xiawuzaotuifenzhong; updatepltRole.Kuanggongtianshu = AdmAttendanceDtl.Kuanggongtianshu; + updatepltRole.Iswork = AdmAttendanceDtl.Iswork; + updatepltRole.Daixinjia = AdmAttendanceDtl.Daixinjia; } } @@ -84,7 +88,21 @@ return AdmAttendanceDtlDTO; } - + public AdmAttendanceDtlDTO GetByUserAndDate(string Attendanceid, DateTime SgninDate) + { + var entity = _context.AdmAttendanceDtls.Where(x => x.RecStatus == "A" && x.AttendanceId == Attendanceid && x.SgninDate == SgninDate ).FirstOrDefault(); + AdmAttendanceDtlDTO dto = null; + if (entity != null) + { + dto = _mapper.Map<AdmAttendanceDtlDTO>(entity); + } + + return dto; + } + + + + public ResultEntity ModifyStatus(string id, string userid) { @@ -139,13 +157,79 @@ Createtime = a.Createtime, Modifier = a.Modifier, Modifytime = a.Modifytime, - - Chidaofenzhong = a.Chidaofenzhong, - Zaotuifenzhong = a.Zaotuifenzhong, + Daixinjia = a.Daixinjia, + Shangwuchidaofenzhong = a.Shangwuchidaofenzhong, + Xiawuchidaofenzhong = a.Xiawuchidaofenzhong, + Shangwuzaotuifenzhong = a.Shangwuzaotuifenzhong, + Xiawuzaotuifenzhong = a.Xiawuzaotuifenzhong, Kuanggongtianshu = a.Kuanggongtianshu, + Iswork = a.Iswork }).OrderByDescending(x => x.Createtime).ToList(); return query; } + + + + /// <summary> + /// 鑾峰彇鎵�鏈夋湁鏁堢鐩� + /// </summary> + /// <returns></returns> + public ResultDataEntity<AdmAttendanceDtlDTO> SearchByPaging(AdmAttendanceDtlDTOSearch searchEntity) + { + ResultDataEntity<AdmAttendanceDtlDTO> data = new ResultDataEntity<AdmAttendanceDtlDTO>(); + + + var query = (from a in _context.AdmAttendanceDtls//.Where(x => x.RecStatus == "A") + + + + where a.RecStatus == "A" + && (string.IsNullOrWhiteSpace(searchEntity.AttendanceId) || a.AttendanceId == searchEntity.AttendanceId.Trim()) + && (!searchEntity.SgninDate.HasValue || a.SgninDate == searchEntity.SgninDate) + + select new AdmAttendanceDtlDTO + { + Id = a.Id, + AttendanceId = a.AttendanceId, + SgninDate = a.SgninDate, + MorningIn = a.MorningIn, + Daixinjia = a.Daixinjia, + MorningOut = a.MorningOut, + AfternoonIn = a.AfternoonIn, + AfternoonOut = a.AfternoonOut, + OvertimeIn = a.OvertimeIn, + OvertimeOut = a.OvertimeOut, + Qingjia = a.Qingjia, + Xiaojia = a.Xiaojia, + RecStatus = a.RecStatus, + Creater = a.Creater, + Createtime = a.Createtime, + Modifier = a.Modifier, + Modifytime = a.Modifytime, + + Shangwuchidaofenzhong = a.Shangwuchidaofenzhong, + Xiawuchidaofenzhong = a.Xiawuchidaofenzhong, + Shangwuzaotuifenzhong = a.Shangwuzaotuifenzhong, + Xiawuzaotuifenzhong = a.Xiawuzaotuifenzhong, + Kuanggongtianshu = a.Kuanggongtianshu, + Iswork = a.Iswork, + SgninDateName = a.SgninDate.HasValue? a.SgninDate.Value.ToString("yyyy-MM-dd"):"", + MorningInName = a.MorningIn.HasValue ? a.MorningIn.Value.ToString("yyyy-MM-dd HH:mm:ss") : "", + + MorningOutName = a.MorningOut.HasValue ? a.MorningOut.Value.ToString("yyyy-MM-dd HH:mm:ss") : "", + AfternoonInName = a.AfternoonIn.HasValue ? a.AfternoonIn.Value.ToString("yyyy-MM-dd HH:mm:ss") : "", + AfternoonOutName = a.AfternoonOut.HasValue ? a.AfternoonOut.Value.ToString("yyyy-MM-dd HH:mm:ss") : "", + OvertimeInName = a.OvertimeIn.HasValue ? a.OvertimeIn.Value.ToString("yyyy-MM-dd HH:mm:ss") : "", + OvertimeOutName = a.OvertimeOut.HasValue ? a.OvertimeOut.Value.ToString("yyyy-MM-dd HH:mm:ss") : "", + }).OrderBy(x => x.SgninDate).ToList(); + + //if (searchEntity.totalrows == 0) + searchEntity.totalrows = query.Count(); + var rolelist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); + + data.LoadData(searchEntity, rolelist); + return data; + } } } -- Gitblit v1.9.1