// GET: LandRecord public ActionResult Index( string code = null, string ELName = null, double?minScore = null, double?maxScore = null, int page = 1, int rows = 20) { var parameter = new LandRecordViewParameter { Code = code, ELName = ELName, MinScore = minScore, MaxScore = maxScore, Page = new PageParameter(page, rows) }; try { var list = Core.LandRecordViewManager.Search(parameter); ViewBag.List = list; ViewBag.Parameter = parameter; } catch (Exception ex) { throw new ArgumentException(ex.ToString()); } return(View()); }
/// <summary> /// 作用:查询 /// 作者:汪建龙 /// 编写时间:2017年3月19日15:34:38 /// </summary> /// <param name="parameter"></param> /// <returns></returns> public List <LandRecordView> Search(LandRecordViewParameter parameter) { var query = Db.LandRecordViews.AsQueryable(); if (parameter.ELID.HasValue) { query = query.Where(e => e.ELID == parameter.ELID.Value); } if (parameter.SystemData.HasValue) { query = query.Where(e => e.SystemData == parameter.SystemData.Value); } if (parameter.State.HasValue) { query = query.Where(e => e.State == parameter.State.Value); } if (!string.IsNullOrEmpty(parameter.Code)) { query = query.Where(e => e.Code.ToLower().Contains(parameter.Code.ToLower())); } if (!string.IsNullOrEmpty(parameter.ELName)) { query = query.Where(e => e.ELName.ToLower().Contains(parameter.ELName.ToLower())); } if (parameter.MinScore.HasValue) { query = query.Where(e => e.Score >= parameter.MinScore.Value); } if (parameter.MaxScore.HasValue) { query = query.Where(e => e.Score <= parameter.MaxScore.Value); } query = query.OrderByDescending(e => e.CreateTime).SetPage(parameter.Page); return(query.ToList()); }