public ActionResult List(AlarmQueryCondition conditions) { if (conditions != null) { Session["AlarmHistoryConditions"] = conditions; } return(List()); }
public ActionResult List(int page = 1, int pageSize = 10) { AlarmQueryCondition conditions = null; IEnumerable <AlarmInformation> alarmInfo = null; //数据库取数据 using (var ctx = new GlsunViewEntities()) { alarmInfo = ctx.AlarmInformation .Where(a => a.AIConfirm == false) .ToList(); } //筛选 conditions = (AlarmQueryCondition)Session["AlarmQueryConditions"]; if (conditions == null) { conditions = new AlarmQueryCondition { IP = "", AlarmLevel = "不限", AlarmTimeBeg = DateTime.Now.AddMonths(-3), AlarmTimeEnd = DateTime.Now }; } if (!string.IsNullOrWhiteSpace(conditions.IP)) { alarmInfo = alarmInfo.Where(a => a.DAddress.Contains(conditions.IP)); } if (conditions.AlarmLevel != "不限") { alarmInfo = alarmInfo.Where(a => a.AILevel == conditions.AlarmLevel); } alarmInfo = alarmInfo.Where(a => a.AITime > conditions.AlarmTimeBeg); alarmInfo = alarmInfo.Where(a => a.AITime < conditions.AlarmTimeEnd.AddDays(1)); //分页处理 var totals = alarmInfo.Count(); alarmInfo = alarmInfo.OrderByDescending(a => a.AITime) .Skip((page - 1) * pageSize) .Take(pageSize) .ToList(); var pagingInfo = new PagingInfo { TotalItems = totals, CurrentPage = page, ItemsPerPage = pageSize, ShowPageCount = 5 }; ViewBag.PagingInfo = pagingInfo; ViewBag.Conditions = conditions; SetAuthorityData(); return(View(alarmInfo)); }