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);
}
}
