Ejemplo n.º 1
0
        /// <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();
            }
        }
Ejemplo n.º 2
0
 /// <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();
     }
 }
Ejemplo n.º 3
0
        /// <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();
        }