/// <summary> /// 分页查询 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <Page <SysPersonWorkDto> > > GetPagesAsync(SysPersonWorkPostPage parm) { var res = new ApiResult <Page <SysPersonWorkDto> >(); try { using (Db) { var query = Db.Queryable <SysPersonWork>() .Where(m => m.PersonGuid == parm.guid) .Select(m => new SysPersonWorkDto() { Guid = m.Guid, EntryTime = m.EntryTime, OutTime = m.OutTime, Address = m.Address, CompanyName = m.CompanyName, PostName = m.PostName, WorkContent = m.WorkContent, Witness = m.Witness, WitnessTel = m.WitnessTel, OutSummary = m.OutSummary, SalarySummary = m.SalarySummary }).ToPageAsync(parm.page, parm.limit); res.success = true; res.message = "获取成功!"; res.data = await query; } } catch (Exception ex) { res.message = ApiEnum.Error.GetEnumText() + ex.Message; res.statusCode = (int)ApiEnum.Error; } return(await Task.Run(() => res)); }
public async Task <JsonResult> GetWorkPages(SysPersonWorkPostPage request) { var res = await _sysPersonWorkService.GetPagesAsync(request); return(Json(new { code = 0, msg = "success", count = res.data.TotalItems, data = res.data.Items })); }