public async Task <ResponseMessage <HumanSearchResponse <AttendanceInfoResponse> > > ImportAttendenceLst(UserInfo User, [FromBody] List <AttendanceInfoRequest> lst) { var pagingResponse = new ResponseMessage <HumanSearchResponse <AttendanceInfoResponse> >(); if (!ModelState.IsValid) { pagingResponse.Code = ResponseCodeDefines.ModelStateInvalid; Logger.Warn($"用户{User?.UserName ?? ""}({User?.Id ?? ""})导入考勤信息(PostCustomerListSaleMan)模型验证失败:\r\n{pagingResponse.Message ?? ""},\r\n请求参数为:\r\n" + (lst != null ? JsonHelper.ToJson(lst) : "")); return(pagingResponse); } try { await _attendanceManage.AddAttendence(lst, HttpContext.RequestAborted); AttendenceSearchRequest condition = new AttendenceSearchRequest() { pageIndex = 0, pageSize = 10, CreateDate = lst[0].Date.GetValueOrDefault() }; pagingResponse.Extension = await _attendanceManage.SearchAttendenceInfo(User, condition, HttpContext.RequestAborted); } catch (Exception e) { pagingResponse.Code = ResponseCodeDefines.ServiceError; pagingResponse.Message = "服务器错误:" + e.ToString(); Logger.Error($"用户{User?.UserName ?? ""}({User?.Id ?? ""})导入考勤信息(PostCustomerListSaleMan)请求失败:\r\n{pagingResponse.Message ?? ""},\r\n请求参数为:\r\n" + (lst != null ? JsonHelper.ToJson(lst) : "")); } return(pagingResponse); }
public async Task <ResponseMessage <HumanSearchResponse <AttendanceInfoResponse> > > SearchAttendenceLst(UserInfo User, [FromBody] AttendenceSearchRequest condition) { var pagingResponse = new ResponseMessage <HumanSearchResponse <AttendanceInfoResponse> >(); if (!ModelState.IsValid) { pagingResponse.Code = ResponseCodeDefines.ModelStateInvalid; Logger.Warn($"用户{User?.UserName ?? ""}({User?.Id ?? ""})查询考勤信息(PostCustomerListSaleMan)模型验证失败:\r\n{pagingResponse.Message ?? ""},\r\n请求参数为:\r\n" + (condition != null ? JsonHelper.ToJson(condition) : "")); return(pagingResponse); } try { pagingResponse.Extension = await _attendanceManage.SearchAttendenceInfo(User, condition, HttpContext.RequestAborted); pagingResponse.Message = "searchattendencelst ok"; } catch (Exception e) { pagingResponse.Code = ResponseCodeDefines.ServiceError; pagingResponse.Message = "服务器错误:" + e.ToString(); Logger.Error($"用户{User?.UserName ?? ""}({User?.Id ?? ""})查询考勤信息(PostCustomerListSaleMan)请求失败:\r\n{pagingResponse.Message ?? ""},\r\n请求参数为:\r\n" + (condition != null ? JsonHelper.ToJson(condition) : "")); } return(pagingResponse); }
public virtual async Task <HumanSearchResponse <AttendanceInfoResponse> > SearchAttendenceInfo(UserInfo user, AttendenceSearchRequest condition, CancellationToken cancellationToken = default(CancellationToken)) { if (condition == null) { throw new ArgumentNullException(nameof(condition)); } var Response = new HumanSearchResponse <AttendanceInfoResponse>(); var sql = @"SELECT a.* from XYH_HU_ATTENDANCE as a where"; string connectstr = " "; if (!string.IsNullOrEmpty(condition?.KeyWord)) { sql += connectstr + @"LOCATE('" + condition.KeyWord + "', a.`Name`)>0"; connectstr = " and "; } else { sql += connectstr + @"a.`ID`!=''"; connectstr = " and "; } if (condition?.CreateDate != null && condition.CreateDate.Year > 2017) { sql += connectstr + @"(a.`Date`='" + condition.CreateDate + "')"; connectstr = " and "; } try { var query = _Store.DapperSelect <AttendanceInfo>(sql).ToList(); Response.ValidityContractCount = query.Count; Response.TotalCount = query.Count; List <AttendanceInfo> result = new List <AttendanceInfo>(); var begin = (condition.pageIndex) * condition.pageSize; var end = (begin + condition.pageSize) > query.Count ? query.Count : (begin + condition.pageSize); for (; begin < end; begin++) { result.Add(query.ElementAt(begin)); } Response.PageIndex = condition.pageIndex; Response.PageSize = condition.pageSize; Response.Extension = _mapper.Map <List <AttendanceInfoResponse> >(result); } catch (Exception e) { throw; } return(Response); }