/// <summary> /// 根据危险源辨识与评价清单Id删除一个危险源辨识与评价清单信息 /// </summary> /// <param name="hazardListCode">危险源辨识与评价清单Id</param> public static void DeleteHazardListByHazardListId(string hazardListId) { Model.SUBHSSEDB db = Funs.DB; Model.Hazard_HazardList hazardList = db.Hazard_HazardList.FirstOrDefault(e => e.HazardListId == hazardListId); if (hazardList != null) { ///删除工程师日志收集记录 var flowOperate = from x in db.Sys_FlowOperate where x.DataId == hazardList.HazardListId select x; if (flowOperate.Count() > 0) { foreach (var item in flowOperate) { BLL.HSSELogService.CollectHSSELog(hazardList.ProjectId, item.OperaterId, item.OperaterTime, "25", "职业健康安全危险源辨识与评价", Const.BtnDelete, 1); } ////删除审核流程表 BLL.CommonService.DeleteFlowOperateByID(hazardList.HazardListId); } ///删除附件 BLL.CommonService.DeleteAttachFileById(hazardList.HazardListId); ///删除编码表记录 BLL.CodeRecordsService.DeleteCodeRecordsByDataId(hazardList.HazardListId); db.Hazard_HazardList.DeleteOnSubmit(hazardList); db.SubmitChanges(); } }
/// <summary> /// 修改危险源辨识与评价清单信息 /// </summary> /// <param name="hazardList">危险源辨识与评价清单实体</param> public static void UpdateHazardList(Model.Hazard_HazardList hazardList) { Model.SUBHSSEDB db = Funs.DB; Model.Hazard_HazardList newHazardList = db.Hazard_HazardList.FirstOrDefault(e => e.HazardListId == hazardList.HazardListId); if (newHazardList != null) { newHazardList.HazardListCode = hazardList.HazardListCode; //newHazardList.ProjectId = hazardList.ProjectId; newHazardList.VersionNo = hazardList.VersionNo; newHazardList.CompileMan = hazardList.CompileMan; newHazardList.CompileDate = hazardList.CompileDate; newHazardList.States = hazardList.States; newHazardList.WorkStage = hazardList.WorkStage; newHazardList.Contents = hazardList.Contents; newHazardList.WorkAreaName = hazardList.WorkAreaName; newHazardList.IdentificationDate = hazardList.IdentificationDate; newHazardList.ControllingPerson = hazardList.ControllingPerson; db.SubmitChanges(); } }
/// <summary> /// 增加危险源辨识与评价清单信息 /// </summary> /// <param name="hazardList">危险源辨识与评价清单实体</param> public static void AddHazardList(Model.Hazard_HazardList hazardList) { Model.SUBHSSEDB db = Funs.DB; Model.Hazard_HazardList newHazardList = new Model.Hazard_HazardList { HazardListId = hazardList.HazardListId, HazardListCode = hazardList.HazardListCode, ProjectId = hazardList.ProjectId, VersionNo = hazardList.VersionNo, CompileMan = hazardList.CompileMan, CompileDate = hazardList.CompileDate, States = hazardList.States, WorkStage = hazardList.WorkStage, Contents = hazardList.Contents, WorkAreaName = hazardList.WorkAreaName, IdentificationDate = hazardList.IdentificationDate, ControllingPerson = hazardList.ControllingPerson }; Funs.DB.Hazard_HazardList.InsertOnSubmit(newHazardList); Funs.DB.SubmitChanges(); ////增加一条编码记录 BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectHazardListMenuId, hazardList.ProjectId, null, hazardList.HazardListId, hazardList.CompileDate); }