/// <summary> /// 新增历史报警策略 /// </summary> public ReturnItem <RetHistoryAlertPolicies> AddHistoryAlertPolicies(HistoryAlertPoliciesModel parameter) { ReturnItem <RetHistoryAlertPolicies> r = new ReturnItem <RetHistoryAlertPolicies>(); using (AlertPoliciesEntities alert = new AlertPoliciesEntities()) { try { //新增历史报警策略 A_AlarmHistory newalert = new A_AlarmHistory() { DeviceID = Convert.ToInt32(parameter.DeviceID), DeviceItemID = Convert.ToInt32(parameter.DeviceItemID), StrategyID = Convert.ToInt32(parameter.StrategyID), Value = parameter.Value, AlarmTime = parameter.AlarmTime, EndTime = parameter.EndTime, OrgID = Convert.ToInt32(parameter.OrgID), }; alert.A_AlarmHistory.Add(newalert); alert.SaveChanges(); r.Msg = "报警策略新增成功"; r.Code = 0; } catch (Exception e) { r.Msg = "内部错误请重试"; log.ErrorFormat("内部错误:{0},{1}", e.Message, e.StackTrace); r.Code = -1; } } return(r); }
/// <summary> /// 通过id删除历史报警列表记录数据 /// </summary> public ReturnItem <RetHistoryAlertPolicies> DelHistoryAlertPoliciesData(HistoryAlertPoliciesModel parameter) { ReturnItem <RetHistoryAlertPolicies> r = new ReturnItem <RetHistoryAlertPolicies>(); using (AlertPoliciesEntities alert = new AlertPoliciesEntities()) { try { A_AlarmHistory delalert = alert.Set <A_AlarmHistory>().Where(a => a.ID == parameter.ID).FirstOrDefault(); if (delalert != null) { var entry = alert.Entry(delalert); //设置该对象的状态为删除 entry.State = EntityState.Deleted; alert.SaveChanges(); //保存修改 r.Msg = "信息删除成功"; r.Code = 0; } } catch (Exception e) { r.Msg = "内部错误请重试"; log.ErrorFormat("内部错误:{0},{1}", e.Message, e.StackTrace); r.Code = -1; } } return(r); }