/// <summary> /// 增加危险源辨识与评价清单明细信息 /// </summary> /// <param name="environmentalRiskItem">危险源辨识与评价清单实体</param> public static void AddEnvironmentalRiskItem(Model.Hazard_EnvironmentalRiskItem environmentalRiskItem) { Model.SUBHSSEDB db = Funs.DB; Model.Hazard_EnvironmentalRiskItem newEnvironmentalRiskItem = new Model.Hazard_EnvironmentalRiskItem { EnvironmentalRiskItemId = environmentalRiskItem.EnvironmentalRiskItemId, EnvironmentalRiskListId = environmentalRiskItem.EnvironmentalRiskListId, EnvironmentalId = environmentalRiskItem.EnvironmentalId, EType = environmentalRiskItem.EType, ActivePoint = environmentalRiskItem.ActivePoint, EnvironmentalFactors = environmentalRiskItem.EnvironmentalFactors, AValue = environmentalRiskItem.AValue, BValue = environmentalRiskItem.BValue, CValue = environmentalRiskItem.CValue, DValue = environmentalRiskItem.DValue, EValue = environmentalRiskItem.EValue, FValue = environmentalRiskItem.FValue, GValue = environmentalRiskItem.GValue, SmallType = environmentalRiskItem.SmallType, IsImportant = environmentalRiskItem.IsImportant, Code = environmentalRiskItem.Code, ControlMeasures = environmentalRiskItem.ControlMeasures, Remark = environmentalRiskItem.Remark, EnvironmentEffect = environmentalRiskItem.EnvironmentEffect }; Funs.DB.Hazard_EnvironmentalRiskItem.InsertOnSubmit(newEnvironmentalRiskItem); Funs.DB.SubmitChanges(); }
/// <summary> /// 修改危险源辨识与评价清单明细信息 /// </summary> /// <param name="environmentalRiskItem">危险源辨识与评价清单实体</param> public static void UpdateEnvironmentalRiskItem(Model.Hazard_EnvironmentalRiskItem environmentalRiskItem) { Model.SUBHSSEDB db = Funs.DB; Model.Hazard_EnvironmentalRiskItem newEnvironmentalRiskItem = db.Hazard_EnvironmentalRiskItem.FirstOrDefault(e => e.EnvironmentalRiskItemId == environmentalRiskItem.EnvironmentalRiskItemId); if (newEnvironmentalRiskItem != null) { newEnvironmentalRiskItem.EType = environmentalRiskItem.EType; newEnvironmentalRiskItem.ActivePoint = environmentalRiskItem.ActivePoint; newEnvironmentalRiskItem.EnvironmentalFactors = environmentalRiskItem.EnvironmentalFactors; newEnvironmentalRiskItem.AValue = environmentalRiskItem.AValue; newEnvironmentalRiskItem.BValue = environmentalRiskItem.BValue; newEnvironmentalRiskItem.CValue = environmentalRiskItem.CValue; newEnvironmentalRiskItem.DValue = environmentalRiskItem.DValue; newEnvironmentalRiskItem.EValue = environmentalRiskItem.EValue; newEnvironmentalRiskItem.FValue = environmentalRiskItem.FValue; newEnvironmentalRiskItem.GValue = environmentalRiskItem.GValue; newEnvironmentalRiskItem.SmallType = environmentalRiskItem.SmallType; newEnvironmentalRiskItem.IsImportant = environmentalRiskItem.IsImportant; newEnvironmentalRiskItem.Code = environmentalRiskItem.Code; newEnvironmentalRiskItem.ControlMeasures = environmentalRiskItem.ControlMeasures; newEnvironmentalRiskItem.Remark = environmentalRiskItem.Remark; newEnvironmentalRiskItem.EnvironmentEffect = environmentalRiskItem.EnvironmentEffect; db.SubmitChanges(); } }
/// <summary> /// 根据危险源辨识与评价清单Id删除一个危险源辨识与评价清单明细信息 /// </summary> /// <param name="environmentalRiskItemId">危险源辨识与评价清单Id</param> public static void DeleteEnvironmentalRiskItemById(string environmentalRiskItemId) { Model.SUBHSSEDB db = Funs.DB; Model.Hazard_EnvironmentalRiskItem newEnvironmentalRiskItem = db.Hazard_EnvironmentalRiskItem.FirstOrDefault(e => e.EnvironmentalRiskItemId == environmentalRiskItemId); if (newEnvironmentalRiskItem != null) { db.Hazard_EnvironmentalRiskItem.DeleteOnSubmit(newEnvironmentalRiskItem); db.SubmitChanges(); } }