From cbff3bc3a629c74a3d72f5986721ed0b2716ac13 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 18 十月 2021 13:51:36 +0800
Subject: [PATCH] 提交
---
zhengcaioa/Services/AdmAttendanceDtlService.cs | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 55 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Services/AdmAttendanceDtlService.cs b/zhengcaioa/Services/AdmAttendanceDtlService.cs
index e9978d4..8856b4f 100644
--- a/zhengcaioa/Services/AdmAttendanceDtlService.cs
+++ b/zhengcaioa/Services/AdmAttendanceDtlService.cs
@@ -167,5 +167,60 @@
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,
+
+ 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
+ }).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