public List <RM_BiddingAgency> GetList(BiddingAgencyFilter filter, Guid userid, out int total) { using (DataProvider dp = new DataProvider()) { //Guid? depid = dp.PM_Department.FirstOrDefault(m => m.DepName == "招标代理部")?.Id; //if (!dp.PM_Employee.Any(x => x.RelateUserId == userid && x.DepartmentId == depid)) //{ // total = 0; // return new List<RM_BiddingAgency>(); //} var list = dp.RM_BiddingAgency.Where(m => true); if (filter.TenderType.IsNotNullAndCountGtZero()) { list = list.Where(m => filter.TenderWay.Contains(m.TenderWay)); } if (filter.TenderType.IsNotNullAndCountGtZero()) { list = list.Where(m => filter.TenderType.Contains(m.TenderType)); } if (filter.AgentMan.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.AgentMan.Contains(filter.AgentMan)); } if (filter.Salesman.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.Salesman.Contains(filter.Salesman)); } if (filter.ProjectName.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.ProjectName.Contains(filter.ProjectName)); } list = list.OrderBy(m => m.CreateTime); total = list.Count(); return(list.Skip(filter.Skip).Take(filter.PageSize).ToList()); } }
public ActionResult GetList(BiddingAgencyFilter filter) { var list = service.GetList(filter, CurrentUser.Id, out int total); return(Json(new TableDataModel(total, list))); }