public List <AppDto> GetList(AppPara para, out int total)
{
try
{
var apps = GetList(para.RoleId, para.OrgId);
var p = PredicateBuilder.Default <AppDto>();
if (para.UserId.IsNotNullOrEmpty())
{
p = p.And(m => m.UserId != null && m.UserId.Contains(para.UserId));
}
if (para.Id.IsNotNullOrEmpty())
{
p = p.And(m => m.Id.Equals(para.Id));
}
if (para.AppName.IsNotNullOrEmpty())
{
p = p.And(m => m.AppName.Contains(para.AppName));
}
if (para.SalesMan.IsNotNullOrEmpty())
{
p = p.And(m => m.SalesMan.Contains(para.SalesMan));
}
if (para.AppType != 0)
{
p = p.And(m => m.AppType == para.AppType);
}
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 apps = UnitOfWorkService.Execute(() =>
//{
// var list = _repo.GetPaged(p, para.PageNumber, para.PageSize, out count, false, m => m.CreateDate);
// return list?.Select(c => c.MapTo<AppDto>()).ToList();
//});
//if (apps == null)
//{
// total = 0;
// return new List<AppDto>();
//}
apps = apps.Where(p.Compile()).ToList();
total = apps.Count;
var rlt = apps.OrderByDescending(m => m.CreateDate).Skip(para.PageNumber * para.PageSize).Take(para.PageSize).ToList();
return(rlt);
}
catch (Exception e)
{
Logger.Error("select * from app error", e);
total = 0;
return(new List <AppDto>());
}
}
public async Task <JsonResult> GetList(AppPara para)
{
para.PageNumber = para.PageNumber - 1;
para.UserId = LoginInfo.Id;
return(await Task.Run(() =>
{
var dtos = _appService.GetList(para, out var count);
var list = dtos.MapTo <List <AppModel> >();
return Json(new { rows = list, total = count });
}));
}
public async Task <JsonResult> GetList(string id, string userId, string appName, AppType appType, DateTime startTime, DateTime endTime, int page = 1, int rows = 20)
{
var _staffService = ObjectContainer.Resolve <IStaffService>();
try
{
return(await Task.Run(() =>
{
var para = new AppPara
{
Id = id,
UserId = userId,
AppName = appName,
AppType = appType,
StartTime = startTime,
EndTime = endTime,
PageNumber = page - 1,
PageSize = rows,
OrgId = LoginInfo.Org.Id,
RoleId = LoginInfo.Role
};
var rlt = _appService.GetList(para, out var count);
var data = rlt.MapTo <IEnumerable <AppModel> >().ToList();
data.ForEach(m => m.Icon = m.Icon);
data.ForEach(m => m.SalesMan = _staffService.Get(m.SalesMan)?.Name);
var res = new JsonResult(new { total = count, rows = data });
return res;
}));
}
catch (Exception e)
{
Logger.Error("查询错误", e);
return(new JsonResult(new { total = 0, rows = "" }));
}
}
