public List <BillingDetailsDto> GetList(BillingDetailsPara para, out int total)
{
try
{
var p = PredicateBuilder.Default <BillingDetailsDto>();
if (para.UserId.IsNotNullOrEmpty())
{
p = p.And(m => m.UserId != null && m.UserId.Contains(para.UserId));
}
if (para.AppKey.IsNotNullOrEmpty())
{
p = p.And(m => m.AppKey.Equals(para.AppKey));
}
if (para.StartTime > new DateTime())
{
p = p.And(m => m.CreateDate >= para.StartTime);
}
if (para.EndTime > new DateTime())
{
p = p.And(m => m.CreateDate < para.EndTime);
}
var details = GetList(para.RoleId, para.OrgId);
details = details.Where(p.Compile()).ToList();
total = details.Count;
return(details.OrderByDescending(m => m.CreateDate).Skip(para.PageNumber * para.PageSize).Take(para.PageSize).ToList());
}
catch (Exception ex)
{
Logger.Error("select * from BillingDetails error", ex);
total = 0;
return(new List <BillingDetailsDto>());
}
}
public async Task <JsonResult> GetList(BillingDetailsPara para)
{
para.PageNumber = para.PageNumber - 1;
para.UserId = LoginInfo.Id;
return(await Task.Run(() =>
{
var dtos = _billingDetailsService.GetList(para, out var count);
var list = dtos.MapTo <List <BillingDetailsModel> >();
return Json(new { rows = list, total = count });
}));
}
public async Task <JsonResult> GetList(BillingDetailsPara para, int page = 0, int rows = 20)
{
return(await Task.Run(() =>
{
para.PageNumber = page - 1; //当前页
para.PageSize = rows; //每页显示条数
para.OrgId = LoginInfo.Org.Id;
para.RoleId = LoginInfo.Role;
var rlt = _billingDetailsService.GetList(para, out var count);
var data = rlt.MapTo <List <BillingDetailsModel> >();
return new JsonResult(new { total = count, rows = data });
}));
}
