Beispiel #1
0
        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)));
        }