public IHttpActionResult QueryList(RemindCondition condition) { condition.ReceiverAccount = ClientCookie.UserCode; int totalSize; var data = Remind.Query(condition, out totalSize).ToList(); return(Ok(new { data, totalSize })); }
public static IQueryable <Remind> Query(RemindCondition searchCondition, out int totalSize) { var predicate = PredicateBuilder.True <Remind>(); if (!string.IsNullOrEmpty(searchCondition.Title)) { predicate = predicate.And(e => e.Title.Contains(searchCondition.Title)); } if (!string.IsNullOrEmpty(searchCondition.SenderZHCN)) { //var employeeList = Employee.Search(e => e.NameZHCN.Contains(searchCondition.SenderZHCN)); //var employeeCodeList = employeeList.Select(e => e.Code).ToList(); predicate = predicate.And(e => e.SenderNameZHCN.Contains(searchCondition.SenderNameZHCN)); } if (!string.IsNullOrEmpty(searchCondition.SenderNameENUS)) { //var employeeList = Employee.Search(e => e.NameZHCN.Contains(searchCondition.SenderZHCN)); //var employeeCodeList = employeeList.Select(e => e.Code).ToList(); predicate = predicate.And(e => e.SenderNameENUS.Contains(searchCondition.SenderNameENUS)); } if (!string.IsNullOrEmpty(searchCondition.ReceiverAccount)) { predicate = predicate.And(e => e.ReceiverAccount == searchCondition.ReceiverAccount); } //从多少页开始取数据 var remindList = Search(predicate, e => e.CreateTime, searchCondition.PageIndex, searchCondition.PageSize, out totalSize, true); return(remindList); }