| | |
|---|
| | | updatepltRole.Xiawuzaotuifenzhong = AdmAttendanceDtl.Xiawuzaotuifenzhong; |
|---|
| | | updatepltRole.Kuanggongtianshu = AdmAttendanceDtl.Kuanggongtianshu; |
|---|
| | | updatepltRole.Iswork = AdmAttendanceDtl.Iswork; |
|---|
| | | updatepltRole.Daixinjia = AdmAttendanceDtl.Daixinjia; |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | |
|---|
| | | Createtime = a.Createtime, |
|---|
| | | Modifier = a.Modifier, |
|---|
| | | Modifytime = a.Modifytime, |
|---|
| | | |
|---|
| | | Daixinjia = a.Daixinjia, |
|---|
| | | Shangwuchidaofenzhong = a.Shangwuchidaofenzhong, |
|---|
| | | Xiawuchidaofenzhong = a.Xiawuchidaofenzhong, |
|---|
| | | Shangwuzaotuifenzhong = a.Shangwuzaotuifenzhong, |
|---|
| | |
|---|
| | | |
|---|
| | | 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; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
