public IEnumerable <ProjectCtrl> GetProjectCtrlList(ProjectCtrlRequest request = null) { request = request ?? new ProjectCtrlRequest(); using (var dbContext = new ProjectDbContext()) { IQueryable <ProjectCtrl> projects = dbContext.ProjectCtrls.Include("ProjectBasedata"); if (!string.IsNullOrEmpty(request.Name)) { projects = projects.Where(u => u.Name.Contains(request.Name)); } if (request.ProjectBasedataID > 0) { projects = projects.Where(u => u.ProjectBasedataID == request.ProjectBasedataID); } //if (!string.IsNullOrEmpty(request.Stuffname)) // projects = projects.Where(u => u.Stuffname.Contains(request.Stuffname)); //if (!string.IsNullOrEmpty(request.obb)) // projects = projects.Where(u => u.obb.Contains(request.obb)); //if (!string.IsNullOrEmpty(request.Way)) // projects = projects.Where(u => u.Way.Contains(request.Way)); return(projects.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize)); } }
// // GET: /Crm/Project/ public ActionResult Index(ProjectCtrlRequest requset) { var ProjectBasedataIDList = this.ProjectService.GetProjectBasedataList(new ProjectRequest()); this.ViewBag.ProjectBasedataID = new SelectList(ProjectBasedataIDList, "ID", "PName"); var result = this.ProjectService.GetProjectCtrlList(requset); return(View(result)); }