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