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 | 66 ++++++++++++++++++++++++++++++++ 1 files changed, 65 insertions(+), 1 deletions(-) diff --git a/zhengcaioa/Services/AdmAttendanceDtlService.cs b/zhengcaioa/Services/AdmAttendanceDtlService.cs index e9978d4..221bf05 100644 --- a/zhengcaioa/Services/AdmAttendanceDtlService.cs +++ b/zhengcaioa/Services/AdmAttendanceDtlService.cs @@ -58,6 +58,7 @@ updatepltRole.Xiawuzaotuifenzhong = AdmAttendanceDtl.Xiawuzaotuifenzhong; updatepltRole.Kuanggongtianshu = AdmAttendanceDtl.Kuanggongtianshu; updatepltRole.Iswork = AdmAttendanceDtl.Iswork; + updatepltRole.Daixinjia = AdmAttendanceDtl.Daixinjia; } } @@ -156,7 +157,7 @@ Createtime = a.Createtime, Modifier = a.Modifier, Modifytime = a.Modifytime, - + Daixinjia = a.Daixinjia, Shangwuchidaofenzhong = a.Shangwuchidaofenzhong, Xiawuchidaofenzhong = a.Xiawuchidaofenzhong, Shangwuzaotuifenzhong = a.Shangwuzaotuifenzhong, @@ -167,5 +168,68 @@ 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