public FuncResult GetListPagination([FromBody] SearchElectricModel model) { try { model.page--; if (model.page < 0) { model.page = 0; } return(eletricBll.GetListPagination(model)); } catch (Exception ex) { throw new Exception("error", ex); } }
public FuncResult GetListPagination(SearchElectricModel model) { FuncResult fr = new FuncResult() { IsSuccess = true, Message = "操作成功" }; try { var query = from e in context.ApdFctElectric join o in context.ApdDimOrg on e.OrgCode equals o.OrgCode select new { CreationDate = e.CreationDate, PeriodYear = e.PeriodYear, RecordId = e.RecordId, OrgName = o.OrgName, Town = o.Town, OrgCode = o.OrgCode, RegistrationType = o.RegistrationType, Address = o.Address, NetSupply = e.NetSupply, Spontaneous = e.Spontaneous, Remark = e.Remark }; query = query.Where(f => ( (string.IsNullOrWhiteSpace(model.orgcode) || f.OrgCode.Contains(model.orgcode)) && (string.IsNullOrWhiteSpace(model.orgname) || f.OrgName.Contains(model.orgname)) && (string.IsNullOrWhiteSpace(model.year) || f.PeriodYear.Equals(Convert.ToDecimal(model.year))) )); int count = query.Count(); if (model.limit * model.page >= count) { model.page = 0; } var pagination = query.Skip(model.limit * model.page).Take(model.limit); fr.Content = new { total = count, data = pagination }; return(fr); } catch (Exception ex) { throw new Exception("error", ex); } }