/// <summary> /// 获取报警记录 /// </summary> /// <param name="totalCount">总的数量</param> /// <param name="searchName">查找字段</param> /// <param name="pageIndex">页码</param> /// <param name="pageSize">每一页显示多少条</param> /// <param name="orderEnum">排序枚举</param> /// <param name="ascending">标示正反排序的字段</param> /// <param name="searchStartTime">搜索开始时间</param> /// <param name="searchEndTime">搜索结束时间</param> /// <returns></returns> public CResult <List <WebAlarm> > GetAllAlarm(out int totalCount, string searchName = "", int pageIndex = 1, int pageSize = 100, AlarmOrderEnum orderEnum = AlarmOrderEnum.AlarmTime, bool ascending = false, DateTime?searchStartTime = null, DateTime?searchEndTime = null) { totalCount = 0; using (var db = new WarehouseContext()) { Expression <Func <Alarm, bool> > filter = r => true; if (searchStartTime.HasValue) { filter = filter.And(r => r.AlarmTime >= searchStartTime); } if (searchEndTime.HasValue) { var endTime = searchEndTime.Value.AddDays(1); filter = filter.And(r => r.AlarmTime < endTime); } var alarmIQuery = RepositoryIoc.GetAlarmRepository(db).Get(out totalCount, filter, null, orderEnum.ToString(), ascending, pageIndex, pageSize); var result = new List <WebAlarm>(); foreach (var item in alarmIQuery) { result.Add(new WebAlarm() { AlarmTypeInt = item.AlarmTypeInt, AlarmContent = item.AlarmContent, AlarmTime = item.AlarmTime, Operator = item.Operator, AlarmTypeName = ((AlarmType)item.AlarmTypeInt).ToString(), }); } return(new CResult <List <WebAlarm> >(result)); } }
/// <summary> /// 添加报警 /// </summary> /// <param name="webAlarm"></param> /// <returns></returns> public CResult <bool> AddAlarm(WebAlarm webAlarm) { using (var db = new WarehouseContext()) { var alarm = new Alarm(); alarm.AlarmContent = webAlarm.AlarmContent; alarm.AlarmTime = DateTime.Now; alarm.AlarmTypeInt = webAlarm.AlarmTypeInt; alarm.Operator = webAlarm.Operator; RepositoryIoc.GetAlarmRepository(db).Insert(alarm); if (db.SaveChanges() > 0) { return(new CResult <bool>(true)); } else { return(new CResult <bool>(false, ErrorCode.SaveDbChangesFailed)); } } }