public ResultEntity <List <ShigongDTO> > GetShigongList([FromQuery] Request_Shigong dto) { if (ModelState.IsValid) { LogUtil.log.Info(ModelState); } else { LogUtil.log.Info(ModelState); } return(new ResultEntityUtil <List <ShigongDTO> >().Success(dm.GetShigongList(dto, out int count), count)); }
public List <ShigongDTO> GetShigongList(Request_Shigong dto, out int count) { List <ShigongDTO> dtoli = new List <ShigongDTO>(); Expression <Func <Shigong, bool> > expr = AutoAssemble.Splice <Shigong, Request_Shigong>(dto); if (dto.BShiyongTime2 != null) { expr = expr.And2(w => w.ShiyongTime2 >= dto.BShiyongTime2); } if (dto.EShiyongTime2 != null) { expr = expr.And2(w => w.ShiyongTime2 <= dto.EShiyongTime2); } //throw new Exception("11111111111"); count = c.Shigong.Where(expr).Count(); //List<Shigong> li = c.Shigong.Where(expr).OrderBy(px => px.Code).Skip((dto.PageIndex - 1) * dto.PageSize).Take(dto.PageSize).ToList(); dtoli = c.Shigong.Where(expr).OrderBy(px => px.Code).Skip((dto.PageIndex - 1) * dto.PageSize).Take(dto.PageSize) .Select(x => new ShigongDTO { BiaoduanId = x.BiaoduanId, BiaoduanName = x.Biaoduan.BiaoduanName, Code = x.Code, Id = x.Id, Money = x.Money, PayDuixiang = x.PayDuixiang, RegisterPeople = x.RegisterPeople, Remarks = x.Remarks, ShenhePeople = x.ShenhePeople, ShiyongTime = x.ShiyongTime, ShiyongTime2 = x.ShiyongTime2, Yongtu = x.Yongtu }).ToList(); //GetMapperDTO.GetDTOList<Shigong, ShigongDTO>(li); return(dtoli); }