/// <summary> /// 修改事故统计 /// </summary> /// <param name="accidentAnalysis"></param> public static void UpdateAccidentAnalysis(Model.ProjectAccident_AccidentAnalysis accidentAnalysis) { Model.SUBHSSEDB db = Funs.DB; Model.ProjectAccident_AccidentAnalysis newAccidentAnalysis = db.ProjectAccident_AccidentAnalysis.FirstOrDefault(e => e.AccidentAnalysisId == accidentAnalysis.AccidentAnalysisId); if (newAccidentAnalysis != null) { newAccidentAnalysis.ProjectId = accidentAnalysis.ProjectId; newAccidentAnalysis.CompileMan = accidentAnalysis.CompileMan; newAccidentAnalysis.Remarks = accidentAnalysis.Remarks; newAccidentAnalysis.CompileDate = accidentAnalysis.CompileDate; db.SubmitChanges(); } }
/// <summary> /// 根据主键删除事故统计 /// </summary> /// <param name="accidentAnalysisId"></param> public static void DeleteAccidentAnalysisById(string accidentAnalysisId) { Model.SUBHSSEDB db = Funs.DB; Model.ProjectAccident_AccidentAnalysis accidentAnalysis = db.ProjectAccident_AccidentAnalysis.FirstOrDefault(e => e.AccidentAnalysisId == accidentAnalysisId); if (accidentAnalysis != null) { ///删除编码表记录 BLL.CodeRecordsService.DeleteCodeRecordsByDataId(accidentAnalysisId); ////删除附件表 BLL.CommonService.DeleteAttachFileById(accidentAnalysisId); ////删除流程表 BLL.CommonService.DeleteFlowOperateByID(accidentAnalysisId); db.ProjectAccident_AccidentAnalysis.DeleteOnSubmit(accidentAnalysis); db.SubmitChanges(); } }
/// <summary> /// 添加事故统计 /// </summary> /// <param name="accidentAnalysis"></param> public static void AddAccidentAnalysis(Model.ProjectAccident_AccidentAnalysis accidentAnalysis) { Model.SUBHSSEDB db = Funs.DB; Model.ProjectAccident_AccidentAnalysis newAccidentAnalysis = new Model.ProjectAccident_AccidentAnalysis { AccidentAnalysisId = accidentAnalysis.AccidentAnalysisId, ProjectId = accidentAnalysis.ProjectId, CompileMan = accidentAnalysis.CompileMan, Remarks = accidentAnalysis.Remarks, CompileDate = accidentAnalysis.CompileDate }; db.ProjectAccident_AccidentAnalysis.InsertOnSubmit(newAccidentAnalysis); db.SubmitChanges(); }